| result_id |
int(11) |
Primary key |
|
| arm_accession |
varchar(15) |
Foreign key reference to the ARM_OR_COHORT table |
arm_or_cohort.arm_accession |
| biosample_accession |
varchar(15) |
Foreign key reference to the BIOSAMPLE table |
biosample.biosample_accession |
| comments |
varchar(500) |
Free text to expand upon details |
|
| experiment_accession |
varchar(15) |
Foreign key reference to the EXPERIMENT table |
experiment.experiment_accession |
| expsample_accession |
varchar(15) |
Foreign key reference to the EXPSAMPLE table |
expsample.expsample_accession |
| parent_population_preferred |
varchar(150) |
Standarized name of base or parent population preferred term for population percentage calculation |
lk_cell_population.name |
| parent_population_reported |
varchar(150) |
Reported name of base or parent population preferred term for population percentage calculation |
|
| population_defnition_preferred |
varchar(150) |
Standardized name or idenitifier |
|
| population_defnition_reported |
varchar(150) |
Reported name or identifier |
|
| population_name_preferred |
varchar(150) |
Standardized name or idenitifier |
lk_cell_population.name |
| population_name_reported |
varchar(150) |
Reported name or identifier |
|
| population_stat_unit_preferred |
varchar(100) |
Standardized value in LK_UNIT_of_MEASURE table |
lk_unit_of_measure.name |
| population_stat_unit_reported |
varchar(100) |
Reported name or identifier |
|
| population_statistic_preferred |
float |
Standardized value |
|
| population_statistic_reported |
varchar(50) |
Reported value |
|
| population_name_modifier |
varchar(150) |
The value after the ampersand in the alternate population format |
|
| parent_population_modifier |
varchar(150) |
The value after the ampersand in the alternate population format |
|
| 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 the 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 the SUBJECT table |
subject.subject_accession |
| workspace_file_info_id |
int(11) |
Foreign key reference to FILE_INFO table |
file_info.file_info_id |
| workspace_id |
int(11) |
Foreign key reference to WORKSPACE table |
workspace.workspace_id |