search

berlinguyinca / binbase

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

possible bin double generation on rtx5recal l id #17122 and # 295 #51

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
possible bin double generation on rtx5recal l id #17122 and # 295

Original issue reported on code.google.com by berlinguyinca on 23 Aug 2013 at 2:05

GoogleCodeExporter commented 9 years ago 
seems to reflect 2 entries in the text file

Name    R.T. (s)    Type    UniqueMass
=>Unknown 301   1025.59 Unknown 192
=>chlorogenic acid minor _RI 1017094    1026    Unknown 345

does not look look like a binbase issue

Original comment by berlinguyinca on 23 Aug 2013 at 11:33

GoogleCodeExporter commented 9 years ago 
generated from sample:

bin_id  sample_name uniquemass  retention_index retention_time  problematic correct
ion_failed  standards_found
295 130513cjwqc04-01_1  255 1051615 972.566 FALSE   FALSE   13
17122   100201bsesa104_1    255 1052156 1025.59 FALSE   FALSE   13

select a.bin_id, sample_name,a.uniquemass,a.retention_index, 
c.retention_time/1000 as retention_time, problematic,correction_failed, (select 
count(*) from spectra where found_at_correction = 'TRUE' and sample_id = 
a.sample_id) as "standards_found" from bin a, samples b, spectra c where 
a.sample_id = b.sample_id and b.sample_id = c.sample_id and c.bin_id = a.bin_id 
and a.bin_id in (17122,295)

Original comment by berlinguyinca on 23 Aug 2013 at 11:54