Experiment

Describes the type of experiment, measurement technique and links to protocols used in the experiment.

Columns
Name Type Description Foreign Key
experiment_accession varchar(15) Primary key
description varchar(4000) Free text to expand upon details
measurement_technique varchar(50) Standardized value in LK_EXP_MEASUREMENT_TECH table lk_exp_measurement_tech.name
name varchar(500) Name or identifier
study_accession varchar(15) Foreign key reference to STUDY table study.study_accession
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY experiment_accession BTREE
idx_experiment_study study_accession BTREE
idx_experiment_workspace workspace_id BTREE
fk_experiment_2 measurement_technique BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
control_sample experiment_accession experiment experiment_accession
elisa_result experiment_accession experiment experiment_accession
elispot_result experiment_accession experiment experiment_accession
experiment_2_protocol experiment_accession experiment experiment_accession
expsample experiment_accession experiment experiment_accession
fcs_analyzed_result experiment_accession experiment experiment_accession
hai_result experiment_accession experiment experiment_accession
hla_typing_result experiment_accession experiment experiment_accession
kir_typing_result experiment_accession experiment experiment_accession
mass_spectrometry_result experiment_accession experiment experiment_accession
mbaa_result experiment_accession experiment experiment_accession
neut_ab_titer_result experiment_accession experiment experiment_accession
pcr_result experiment_accession experiment experiment_accession
standard_curve experiment_accession experiment experiment_accession
Back to top