search

fizzfizz / binbase

Automatically exported from code.google.com/p/binbase
0 stars 0 forks source link

visualize ratios over time #37

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
we need to visualize the qualifier ratios for the markers over time

 select date, (massspec[cast(qualifier as int4)] / (select max(unnest) from (select unnest(massspec)) b)) as ratio,min_ratio,max_ratio   from (

    select correction_failed, a.bin_id, a.retention_time,b.name,c.qualifier, (convertspectra(a.spectra)) as "massspec",sample_name,date,min_ratio,max_ratio from spectra a, bin b, standard c,samples d where a.bin_id = b.bin_id and c.bin_id = b.bin_id and a.sample_id = d.sample_id
        and d.sample_id in (
             select sample_id from samples where visible = 'TRUE' and machine = 'b' order by sample_id desc limit 5
        )
    ) 
a
where bin_id = 14441

order by name,date

Original issue reported on code.google.com by berlinguyinca on 2 May 2013 at 9:18