FCS_Analyzed_Result

Stores the analysis results of .fcs file contents and includes measures of population cell number, gating definitions and other statistics.

Columns
Name Type Description Foreign Key
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
Indexes
Name Column Description
PRIMARY result_id BTREE
idx_fcs_analyzed_study_accession study_accession BTREE
idx_fcs_analyzed_arm_accession arm_accession BTREE
idx_fcs_analyzed_biosample_accession biosample_accession BTREE
idx_fcs_analyzed_experiment_accession experiment_accession BTREE
idx_fcs_analyzed_expsample_accession expsample_accession BTREE
idx_fcs_analyzed_subject_accession subject_accession BTREE
idx_fcs_analyzed_workspace workspace_id BTREE
fk_fcs_analyzed_result_8 parent_population_preferred BTREE
fk_fcs_analyzed_result_9 population_name_preferred BTREE
fk_fcs_analyzed_result_11 population_stat_unit_preferred BTREE
fk_fcs_analyzed_result_12 workspace_file_info_id BTREE
fk_fcs_analyzed_result_13 repository_name BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
fcs_analyzed_result_marker result_id fcs_analyzed_result result_id
Back to top