MBAA_Result

Captures results of Multiplex Bead Array Assays (MBAA or Luminex) assays.

Columns
Name Type Description Foreign Key
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
Indexes
Name Column Description
PRIMARY result_id BTREE
idx_mbaa_arm_accession arm_accession BTREE
idx_mbaa_biosample_accession biosample_accession BTREE
idx_mbaa_experiment_accession experiment_accession BTREE
idx_mbaa_source_accession source_accession BTREE
idx_mbaa_study_accession study_accession BTREE
idx_mbaa_subject_accession subject_accession BTREE
idx_mbaa_workspace workspace_id BTREE
fk_mbaa_result_7 source_type BTREE
fk_mbaa_result_8 analyte_accession BTREE
fk_mbaa_result_9 concentration_unit_preferred BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top