Used for quality control and to allow comparison between assay runs or across labs. These control samples are distinct from Biosamples since they are often purchased in bulk, and are not linked to particular study subjects.

Name Type Description Foreign Key
control_sample_accession varchar(15) Primary key
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.
catalog_id varchar(100) An identifier provided by the vendor source
dilution_factor varchar(100) An indication of the amount of control sample used in the assay based on the initial amount or concentration from the source.
experiment_accession varchar(15) Foreign key reference to EXPERIMENT table experiment.experiment_accession
lot_number varchar(100) Identifies a specific version
result_schema varchar(50) Standardized value in LK_RESULT_SCHEMA
source varchar(100) The name of the lab/company/supplier providing the control sample
upload_result_status varchar(20) Upload result status
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Name Column Description
PRIMARY control_sample_accession BTREE
idx_control_sample_workspace workspace_id BTREE
fk_control_sample_2 experiment_accession BTREE
fk_control_sample_3 result_schema BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
control_sample_2_file_info control_sample_accession control_sample control_sample_accession
Back to top