field | example | SQL type | description |
bin | 585 | int(10) unsigned | Indexing field to speed chromosome range queries. |
chrom | chr1 | varchar(255) | Chromosome |
chromStart | 45161 | int(10) unsigned | Start position in chrom (0 based) |
chromEnd | 45162 | int(10) unsigned | End position in chrom (1 based) |
name | rs10399749 | varchar(255) | Reference SNP identifier from dbSnp |
score | 0 | int(10) unsigned | Minor allele frequency normalized (0-500) |
strand | + | enum('+', '-', '?') | Which genomic strand contains the observed alleles |
observed | C/T | varchar(255) | Observed string from genotype file |
allele1 | C | enum('A', 'C', 'G', 'T') | This allele has been observed |
homoCount1 | 44 | int(10) unsigned | Count of individuals who are homozygous for allele1 |
allele2 | | enum('C', 'G', 'T', 'none') | This allele may not have been observed |
homoCount2 | 0 | int(10) unsigned | Count of individuals who are homozygous for allele2 |
heteroCount | 0 | int(10) unsigned | Count of individuals who are heterozygous |