 
    Characterization Name  other
    
-   Move all assay types to Characterization Name other_pc
-   
-select * from canano.common_lookup where name = 'other' 
-and ( attribute = 'assayType' OR attribute='otherAssayType' )
-and VALUE in (
-'acoustic microscopy',
-'controlled aggregation',
-'cyclodextrin content',
-'DNA quantification',
-'dye content',
-'dye release',
-'elemental analysis',
-'elemental composition',
-'Gd2O3 content',
-'ICP-AES Analysis of Gd2O3 content in Gd2O3@SWNHag',
-'imaging',
-'iron content',
-'lipid-induced fluorescence enhancement',
-'magnetic properties',
-'magnetic property',
-'Ninhydrin Assay',
-'nuclear magnetic resonance',
-'protein adsorption',
-'Quantification of drug loading',
-'quantification of drug payload',
-'RBITC content',
-'RBITC release',
-'scanning transmission electron microscopy',
-'signal contrast enhancement',
-'stability',
-'Thermogravimetric Analysis of quantity of Gd2O3 in Gd2O3@SWNHag',
-'X-ray diffraction'
-);
-
-select * from canano.characterization where assay_type IN ( 
-'acoustic microscopy',
-'controlled aggregation',
-'cyclodextrin content',
-'DNA quantification',
-'dye content',
-'dye release',
-'elemental analysis',
-'elemental composition',
-'Gd2O3 content',
-'ICP-AES Analysis of Gd2O3 content in Gd2O3@SWNHag',
-'imaging',
-'iron content',
-'lipid-induced fluorescence enhancement',
-'magnetic properties',
-'magnetic property',
-'Ninhydrin Assay',
-'nuclear magnetic resonance',
-'protein adsorption',
-'Quantification of drug loading',
-'quantification of drug payload',
-'RBITC content',
-'RBITC release',
-'scanning transmission electron microscopy',
-'signal contrast enhancement',
-'stability',
-'Thermogravimetric Analysis of quantity of Gd2O3 in Gd2O3@SWNHag',
-'X-ray diffraction'
-)
-AND other_char_name = 'other';
-
-*/
-
+   Move all assay types to Characterization Name other_pc */
+   
 update canano.common_lookup
 set name = 'other_pc'
 WHERE name = 'other'

set value_unit = 'ug/uL'
where value_unit = 'microgram/microL';

/* Remove Dupes and Typos 

select * from canano.common_lookup where name = 'molecular weight'
and value = 'gel permeation chromotography';

select * from canano.common_lookup where name = 'size'
and value = 'gel permeation chromatograhy';

*/

delete from canano.common_lookup where name = 'molecular weight'
and value = 'gel permeation chromotography';


/* Replace in vivo imaging by imaging.

Remove in vivo multimodality imaging, in vivo multimodality imaging sensitivity, in vivo multimodality kinetics. */

update canano.common_lookup
set value = 'imaging'
