search

berlinguyinca / binbase

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

possible bin double generation on rtx5recal 1391 and # 17072 #49

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
possible bin double generation on rtx5recal 1391 and # 17072

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

GoogleCodeExporter commented 9 years ago 
both bins are annotated two two different spectra in 130812amssa18_2

Malic acid 560.75 s 580.415 Unknown 233
D-threitol_RI 466060    583.061 Unknown 217

select * from 
(
select  sample_name,uniquemass, class, bin_id,retention_index, 
retention_time/1000 as "rt",correction_failed from spectra a, samples b where 
b.visible = 'TRUE' and a.sample_id = b.sample_id order by class, sample_name
) a
where   ( bin_id = 1391 or bin_id = 17072 ) and sample_name = '130812amssa18_2'

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

GoogleCodeExporter commented 9 years ago 
bins generated from

bin_id  sample_name uniquemass  retention_index retention_time  problematic correct
ion_failed  standards_found
1391    130530cjwsa23_1 233 463180  525.334 FALSE   FALSE   13
17072   100201bsesa173_1    233 461056  579.96  FALSE   FALSE   13

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