General NIH tables

[leandroradusky]

The columns target_organism_name and target_analyte_type will have dynamic data depending on the dropdown selection (see #1917).

The general tables for any box purpose to be exported are two: Results and Samples.

Samples: The template for this file has the following fields:

• sample_id: self-explanatory
• vqa_box_id: the uuid of the box
• sample_group: the purpose of the box + "-panel"
• sample_media: to be completed by the awardee
• sample_media_id: to be completed by the awardee
• sample_media_source: to be completed by the awardee
• sample_media_source_url: to be completed by the awardee
• sample_concentration: self-explanatory
• sample_concentration_unit: fixed to copies/ml
• sample_concentration_reference_gene: new field in batch entity, see #1863
• virus_sample_id: same as sample_id
• virus_batch_number: self-explanatory
• target_analyte_type: fixed to inactivated virus
• target_organism_name: fixed to SARS-CoV-2
• target_organism_taxonomy_id: new field in batch entity, see #1863
• pango_lineage: new field in batch entity, see #1863
• who_label: new field in batch entity, see #1863
• virus_sample_inactivation_method: self-explanatory

Results: The template for this file is the following:

The fields that should be fulfilled by CDx are:

• sample_id: self-explanatory
• vqa_box_id: the uuid of the box
• sample_group: the purpose of the box + "-panel"
• assay_readout: measured signal

The other columns should be there be populated by the Awardee.

[sardar-usman]

@leandroradusky It is working fine as expected.