 
    Characterization Name  other
    
-   Move all assay types to Characterization Name other_vt
-   
-select * from canano.common_lookup where name = 'other' 
-and ( attribute = 'assayType' OR attribute='otherAssayType' )
-and VALUE in (
-'actin cytoskeleton disruption',
-'apoptosis',
-'cholesterol impact on pore formation in plasma membrane',
-'cytochrome c release',
-'LDH release',
-'Tubule Formation/Angiogenesis',
-'VE-cadherin'
-);
-
-select * from canano.characterization where assay_type IN (
-'acoustic microscopy',
-'actin cytoskeleton disruption',
-'apoptosis',
-'cholesterol impact on pore formation in plasma membrane',
-'cytochrome c release',
-'LDH release',
-'stability',
-'Tubule Formation/Angiogenesis',
-'VE-cadherin'
-)
-AND other_char_name = 'other';
-
-*/
-
+   Move all assay types to Characterization Name other_vt */
+   
 update canano.common_lookup
 set name = 'other_vt'
 WHERE name = 'other'


/* Physicochemical Characterizations

   Characterization Name  surface
   
   Move  all assay types except surface to Characterization Name other_pc

select * from canano.common_lookup where name = 'other' 
and ( attribute = 'assayType' OR attribute='otherAssayType' )
order by value;

select * from canano.common_lookup where name = 'surface'
and value IN ( 
'Raman spectroscopy',
'fluorescence  lifetime',
'FT-IR spectroscopy',
'FTIR spectroscopy',
'gel electrophoresis',
'photoluminescence spectrophotometry',
'protein assay',
'uv-vis absorbance spectroscopy',
'uv-vis absorbance spectrometry',
'uv-vis absorbance spectrophotometry ',
'uv-vis  absorbance spectroscopy',
'uv-vis absorption spectrometry',
'uv-vis absorption spectroscopy',
'uv-vis spectroscopy',
'x-ray photoelectron spectroscopy'
);  

select assay_type, discriminator, other_char_assay_category, other_char_name from canano.characterization where assay_type IN ( 
'Raman spectroscopy',
'fluorescence  lifetime',
'FT-IR spectroscopy',
'FTIR spectroscopy',
'gel electrophoresis',
'photoluminescence spectrophotometry',
'protein assay',
'uv-vis absorbance spectroscopy',
'uv-vis absorbance spectrometry',
'uv-vis absorbance spectrophotometry ',
'uv-vis  absorbance spectroscopy',
'uv-vis absorption spectrometry',
'uv-vis absorption spectroscopy',
'uv-vis spectroscopy',
'x-ray photoelectron spectroscopy'
)
and discriminator = 'Surface';

*/

update canano.common_lookup
set name = 'other_pc'

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

/* Remove Dupes and Typos */

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