search

berlinguyinca / binbase

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

need a webgui to generate statistics about imports #59

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
we need to visualize this query for all registered binbase databases

select a.*, count(b.found_at_correction) as "markers found" from
(
select a.sample_id, count(spectra_id) as "annotations", sample_name, 
correction_failed,class,date_of_import,date,leco from samples a, spectra b 
where a.sample_id = b.sample_id and class in ('enter classes here') and bin_id 
is not null group by 
sample_name,correction_failed,"class",date_of_import,date,a.sample_id,leco 
order by a.sample_id desc
) a,

spectra b where a.sample_id = b.sample_id and b.found_at_correction = 'TRUE' 
group by
a.sample_id,
a.annotations,
a.sample_name,
a.correction_failed,
a.date,
a.leco,
a.date_of_import,
a.class

order by a.sample_id desc

Original issue reported on code.google.com by berlinguyinca on 4 Sep 2013 at 12:21