search

MullinsLab / viroverse

a platform for the collection, storage, retrieval, and analysis of experimental data for laboratory workflows
MIT License
5 stars 1 forks source link

Support VODA results in VV using sample-associated assay values #70

Closed silby closed 5 years ago

silby commented 5 years ago

lab_result_num has a sample_id column that is null in nearly all cases. Non-null instances are likely artifacts from usage of the old loader. Ages ago, we determined that it was confusing and undesirable for a lab result to be associated with a particular sample from a given visit, since these are clinical values pertaining to the subject's health at the given timepoint. So the ongoing existence of the sample_id column is just there out of an excessively conservative interest in preserving the data therein.

However, there is a need to attach similar bits of data (let's call them numeric and categorical assay results) to individual samples, for work done at the research bench that results in some kind of result data. The motivating example is the VODA quantitative PCR assay (that produce a number like "copies/million cells" for various HIV genes).

The task: add numeric_assay_result and numeric_assay_protocol tables and employ them to add a panel to the Sample page to display VODA results.

silby commented 5 years ago

Done, merged #75 and handled some data load internal to our lab