Biosample

Material extracted from a subject that has undergone isolation, processing and/or treatment prior to use in an assay or test. Attributes include all treatments and reagents used for sample processing and EXCLUDE reagents used to measure analytes.

Columns
Name Type Description Foreign Key
biosample_accession varchar(15) Primary key
description varchar(4000) Free text to expand upon details
name varchar(200) Name or identifier
planned_visit_accession varchar(15) Foreign key reference to PLANNED_VISIT table planned_visit.planned_visit_accession
study_accession varchar(15) Foreign key reference to STUDY table study.study_accession
study_time_collected float Reported value
study_time_collected_unit varchar(25) Standardized value in LK_TIME_UNIT table lk_time_unit.name
study_time_t0_event varchar(50) Standardized value in LK_T0_EVENT table lk_t0_event.name
study_time_t0_event_specify varchar(50) If 'Study Time T0 Event' = Other, this field specifies the study time T0 event.
subject_accession varchar(15) Foreign key reference to SUBJECT table subject.subject_accession
subtype varchar(50) Entered by the data provider when term is not in the controlled vocabulary
type varchar(50) Category lk_sample_type.name
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY biosample_accession BTREE
idx_biosample_subject subject_accession BTREE
idx_biosample_study study_accession BTREE
idx_biosample_planned_visit planned_visit_accession BTREE
idx_biosample_workspace workspace_id BTREE
fk_biosample_5 study_time_collected_unit BTREE
fk_biosample_6 study_time_t0_event BTREE
fk_biosample_8 type BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
biosample_2_treatment biosample_accession biosample biosample_accession
elisa_result biosample_accession biosample biosample_accession
elispot_result biosample_accession biosample biosample_accession
expsample_2_biosample biosample_accession biosample biosample_accession
fcs_analyzed_result biosample_accession biosample biosample_accession
hai_result biosample_accession biosample biosample_accession
hla_typing_result biosample_accession biosample biosample_accession
kir_typing_result biosample_accession biosample biosample_accession
lab_test biosample_accession biosample biosample_accession
mass_spectrometry_result biosample_accession biosample biosample_accession
mbaa_result biosample_accession biosample biosample_accession
neut_ab_titer_result biosample_accession biosample biosample_accession
pcr_result biosample_accession biosample biosample_accession
Back to top