Control_Sample

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.

Columns

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	lk_expsample_result_schema.name
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

Indexes

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