| result_id |
int(11) |
Primary key |
|
| analyte_accession |
varchar(15) |
Foreign key reference to LK_ANALYTE |
lk_analyte.analyte_accession |
| analyte_preferred |
varchar(100) |
Preferred analyte name |
|
| analyte_reported |
varchar(100) |
Reported analyte name |
|
| arm_accession |
varchar(15) |
Foreign key reference to the ARM_OR_COHORT table |
arm_or_cohort.arm_accession |
| assay_group_id |
varchar(100) |
Associates this result with a set of results that may come from a group of plates or chips |
|
| assay_id |
varchar(100) |
Associates this result with a set of results that come from the same plate or chip. A plate may have results for experiment sample, control sample, standard curve |
|
| biosample_accession |
varchar(15) |
Foreign key reference to the BIOSAMPLE table |
biosample.biosample_accession |
| comments |
varchar(500) |
Free text to expand upon details |
|
| concentration_unit_reported |
varchar(100) |
Standardized value in the LK_UNIT_OF_MEASURE table |
|
| concentration_unit_preferred |
varchar(50) |
Standardized value in the LK_UNIT_OF_MEASURE table |
lk_unit_of_measure.name |
| concentration_value_reported |
varchar(100) |
The value of concentration. If the result is linked to a Standard Curve, then the concentration is the actual concentration of the analyte. If this result is linked to an Experiment Sample or a Control Sample, then this refers to the concentration calculated from the MFI using the standard curve . If the Value is calculated for an experiment sample or control sample and the value exceeds the detection limits of the standard curve, a user defined value shall be entered to indicate out of range (e.g. -999 or 999) |
|
| concentration_value_preferred |
float |
The value of concentration. If the result is linked to a Standard Curve, then the concentration is the actual concentration of the analyte. If this result is linked to an Experiment Sample or a Control Sample, then this refers to the concentration calculated from the MFI using the standard curve . If the Value is calculated for an experiment sample or control sample and the value exceeds the detection limits of the standard curve, a user defined value shall be entered to indicate out of range (e.g. -999 or 999) |
|
| experiment_accession |
varchar(15) |
Foreign key reference to the EXPERIMENT table |
experiment.experiment_accession |
| mfi |
varchar(100) |
Median fluorescence intensity of the measurement |
|
| mfi_coordinate |
varchar(100) |
Records the position of the measurement on the plate or array. |
|
| repository_accession |
varchar(20) |
Foreign key reference to a public repository |
|
| repository_name |
varchar(50) |
Name or identifier |
|
| source_accession |
varchar(15) |
Foreign key reference to EXPSAMPLE, CONTROL_SAMPLE, or STANDARD_CURVE table |
|
| source_type |
varchar(30) |
Indicates table where accessions can be referenced |
lk_source_type.name |
| study_accession |
varchar(15) |
Foreign key reference to the STUDY table |
study.study_accession |
| study_time_collected |
float |
Reported value |
|
| study_time_collected_unit |
varchar(25) |
Standardized value in LK_TIME_UNIT table |
|
| subject_accession |
varchar(15) |
Foreign key reference to the SUBJECT table |
subject.subject_accession |
| workspace_id |
int(11) |
Foreign key reference to WORKSPACE table |
workspace.workspace_id |