table |
field |
type |
example |
survey |
id |
int |
123 |
human_id |
string |
hu826751 |
date |
string |
2015-06-23 10:30:01 |
phenotype_category |
string |
Participant_Survey:Age |
phenotype |
string |
30-39 years |
uploaded_data |
id |
int |
123 |
human_id |
string |
hu826751 |
date |
string |
2015-06-23 10:30:01 |
data_type |
string |
Complete Genomics |
source |
string |
PGP |
name |
string |
CGI sample: GS03052-DNA_B01 |
download_description |
string |
(101.3 MB) |
download_url |
string |
http://evidence.pgp-hms.org/genome_download.php?download_genome_id=8e2fb8975d5a05735c56505e1697ad1fa1df73ab&download_nickname=CGI+sample%3A+GS03052-DNA_B01 |
report_description |
string |
male 2,743,807,495 positions covered ref. b37 |
report_url |
string |
http://evidence.pgp-hms.org/genomes?display_genome_id=8e2fb8975d5a05735c56505e1697ad1fa1df73ab |
allergies |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
Honey Bee Venom Protein |
severity |
string |
MILD |
start_date |
string |
2000-08-01 |
end_date |
string |
2010-05-01 |
conditions |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
Chest Pain |
start_date |
string |
2001-08-06 |
end_date |
string |
2010-03-01 |
demographics |
id |
int |
123 |
human_id |
string |
hu826751 |
date_of_birth |
string |
1968-11-01 (46 years old) |
gender |
string |
Female |
weight |
string |
145lbs (66kg) |
height |
string |
5ft 10in (177cm) |
blood_type |
string |
A+ |
race |
string |
White |
immunizations |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
Tetanus/Diphtheria/Pertussis (Tdap) Vaccine |
date |
string |
2008-08-13 |
medications |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
Viibryd |
dosage |
string |
50 Milligram (mg) |
frequency |
string |
Take 1, 2 Times Daily |
start_date |
string |
2013-01-01 |
end_date |
string |
2013-02-01 |
procedures |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
ELECTROCARDIOGRAM |
date |
string |
2011-10-20 |
test_results |
id |
int |
123 |
human_id |
string |
hu826751 |
name |
string |
Height |
result |
string |
77 inches |
date |
string |
2009-07-01 |
suff_record |
id |
int |
123 |
json_record |
string |
["benign","0.000114142",4,"Low","Uncertain","OFD1-Q545R",true,"benign","Homozygous",-1] |
human_suff_record_map |
id |
int |
123 |
uploaded_data_id |
string |
465 |
suff_record_index |
string |
89 |
insuff_record |
id |
int |
123 |
json_record |
string |
["","0.000",1,"","","ACOT2-M455V",false,"","Heterozygous",-1] |
human_insuff_record_map |
id |
int |
123 |
uploaded_data_id |
string |
465 |
insuff_record_index |
string |
130 |