| result_id |
int(11) |
Primary key |
|
| arm_accession |
varchar(15) |
Foreign key reference to ARM_OR_COHORT table |
arm_or_cohort.arm_accession |
| biosample_accession |
varchar(15) |
Foreign key reference to BIOSAMPLE table |
biosample.biosample_accession |
| comments |
varchar(500) |
Free text to expand upon details |
|
| experiment_accession |
varchar(15) |
Foreign key reference to EXPERIMENT table |
experiment.experiment_accession |
| expsample_accession |
varchar(15) |
Foreign key reference to EXPSAMPLE table |
expsample.expsample_accession |
| intensity |
float |
The intensity of the mass spectrometry result |
|
| retention_time |
float |
The retention time of the mass spectrometry result |
|
| retention_time_unit |
varchar(25) |
The unit of time for the the retention time of the mass spectrometry result. |
lk_time_unit.name |
| m_z_ratio |
float |
The ratio of mass to Z charge |
|
| z_charge |
varchar(50) |
The Z charge of the mass spectrometry result |
|
| database_id_reported |
varchar(50) |
The HMDB, PubChem, or RefMet ID associated with the result |
|
| database_id_preferred |
varchar(25) |
The HMDB, PubChem, or RefMet ID associated with the result |
lk_hmdb.hmdb_id |
| mass_spectrometry_type |
varchar(50) |
Metabolomics or Proteomics |
lk_mass_spectrometry_type.name |
| metabolite_name_reported |
varchar(255) |
The name of the reported metabolite used in the mass spectrometry |
|
| metabolite_name_preferred |
varchar(255) |
The name of the reported metabolite used in the mass spectrometry |
|
| protein_name_reported |
varchar(255) |
The name or ID of the protein |
|
| protein_name_preferred |
varchar(255) |
The name or ID of the protein |
lk_protein_name.name |
| repository_accession |
varchar(20) |
Foreign key reference to a public repository |
|
| repository_name |
varchar(50) |
Name or identifier |
lk_public_repository.name |
| 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 |
|
| subject_accession |
varchar(15) |
Foreign key reference to SUBJECT table |
subject.subject_accession |
| workspace_id |
int(11) |
Foreign key reference to WORKSPACE table |
workspace.workspace_id |