Specific Challenge results table

[leandroradusky]

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

When exporting the tables from Challenge boxes, an additional table should be exported with the following columns:

• protocol_id: to be completed by the awardee
• technology_platform: to be completed by the awardee
• vqa_box_id: the uuid of the box
• sample_group: the purpose of the box + "-panel"
• 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 New fields for Batches entity #1863
• pango_lineage: new field in batch entity, see New fields for Batches entity #1863
• who_label: new field in batch entity, see New fields for Batches entity #1863
• non_clinical_cutoff_min: the actual selected threshold in the report
• non_clinical_cutoff_unit: fixed to copies/ml
• true_positives: its actual value in the confusion matrix based on the selected threshold
• false_positives: its actual value in the confusion matrix based on the selected threshold
• true_negatives: its actual value in the confusion matrix based on the selected threshold
• false_negatives: its actual value in the confusion matrix based on the selected threshold
• non_clinical_sensitivity: actual value of TPR based on the selected threshold
• non_clinical_sensitivity_ci_percent +
• non_clinical_sensitivity_ci_min +
• non_clinical_specificity: actual value of FPR based on the selected threshold
• non_clinical_specificity_ci_percent +
• non_clinical_specificity_ci_min +
• area_under_the_roc_curve: value already computed in the report for the selected threshold.
• roc_x_values: list of the x axis values of the roc-curve plot
• roc_y_values: list of the y axis values of the roc-curve plot

+ In all the _ci fields CI stands for Confidence Interval. This can be computed but, given the low number of replicates won't be really informative, to be defined

[sardar-usman]

@leandroradusky It is working fine.