Expsample

Links the biological samples analyzed in an experiment to the assay reagent, protocol and results via the experiment sample record.

Columns
Name Type Description Foreign Key
expsample_accession varchar(15) Primary key
description varchar(4000) Free text to expand upon details
experiment_accession varchar(15) Foreign key reference to EXPERIMENT table experiment.experiment_accession
name varchar(200) Name or identifier
result_schema varchar(50) Standardized value in LK_RESULT_SCHEMA lk_expsample_result_schema.name
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 expsample_accession BTREE
idx_expsample_experiment experiment_accession BTREE
idx_expsample_workspace workspace_id BTREE
fk_expsample_2 result_schema BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
elisa_result expsample_accession expsample expsample_accession
elispot_result expsample_accession expsample expsample_accession
expsample_2_biosample expsample_accession expsample expsample_accession
expsample_2_file_info expsample_accession expsample expsample_accession
expsample_2_reagent expsample_accession expsample expsample_accession
expsample_2_treatment expsample_accession expsample expsample_accession
expsample_mbaa_detail expsample_accession expsample expsample_accession
expsample_public_repository expsample_accession expsample expsample_accession
fcs_analyzed_result expsample_accession expsample expsample_accession
fcs_header expsample_accession expsample expsample_accession
hai_result expsample_accession expsample expsample_accession
hla_typing_result expsample_accession expsample expsample_accession
kir_typing_result expsample_accession expsample expsample_accession
mass_spectrometry_result expsample_accession expsample expsample_accession
neut_ab_titer_result expsample_accession expsample expsample_accession
pcr_result expsample_accession expsample expsample_accession
Back to top