HLA_Typing_Result

Captures the expert determined pair of allele values for the HLA genes that were typed.

Columns
Name Type Description Foreign Key
result_id int(11) Primary key
allele_1 varchar(250) Name of the first HLA allele assayed in standard HLA nomenclature.
allele_2 varchar(250) Name of the second HLA allele assayed in standard HLA nomenclature.
ancestral_population varchar(250) Foreign key reference to LK_ANCESTRAL_POPULATION
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
locus_name varchar(25) Standardized value in LK_LOCUS_NAME table
repository_accession varchar(20) Foreign key reference to a public repository
repository_name varchar(50) Name or identifier
result_set_id int(11) Primary Key
study_accession varchar(15) Reference to the study in the STUDY table. study.study_accession
study_time_collected float Standardized value in LK_TIME_UNIT table
study_time_collected_unit varchar(25) Reported value
subject_accession varchar(15) Foreign key reference to the SUBJECT table subject.subject_accession
workspace_id int(11) Foreign key reference to WORKSPACE table workspace.workspace_id
Indexes
Name Column Description
PRIMARY result_id BTREE
fk_hla_typing_result_1 expsample_accession BTREE
fk_hla_typing_result_2 experiment_accession BTREE
fk_hla_typing_result_3 study_accession BTREE
fk_hla_typing_result_4 arm_accession BTREE
fk_hla_typing_result_5 biosample_accession BTREE
fk_hla_typing_result_6 subject_accession BTREE
fk_hla_typing_result_7 workspace_id BTREE
Tables that Reference this Table
Name Column Table Reference Column Reference
Back to top