TRON-Bioinformatics / covigator

CoVigator - Monitoring SARS-CoV-2 mutations
MIT License
11 stars 1 forks source link

Hover tooltips in lineages plot are difficult to use #68

Closed priesgo closed 1 year ago

priesgo commented 1 year ago

One option would be to allow the user to filter out lineages with less than X samples. That would leave a cleaner plot where this may less of an issue.

To set a reasonable default minimum of samples we would need a bit of playing with the data. Also, the minimum number of samples will depend on the dataset as the dataset sizes are very different. Maybe, we could come up with something like a frequency instead of absolute number of samples (?) or a top number of lineages (?).

covigator=> select count(*) from (select count(*) as count, pangolin_lineage from sample_ena_on group by pangolin_lineage order by count desc) as t;
 count 
-------
  1109
(1 row)

covigator=> select count(*) from (select count(*) as count, pangolin_lineage from sample_ena_on group by pangolin_lineage order by count desc) as t where t.count > 100;
 count 
-------
   122
(1 row)

covigator=> select count(*) from (select count(*) as count, pangolin_lineage from sample_covid19_portal_on group by pangolin_lineage order by count desc) as t;
 count 
-------
  1699
(1 row)

covigator=> select count(*) from (select count(*) as count, pangolin_lineage from sample_covid19_portal_on group by pangolin_lineage order by count desc) as t where t.count > 100;
 count 
-------
   697
(1 row)