Schema for CEU daught '2878 - CEU Trio Daughter NA12878 (1000 Genomes Project) (from Human Mar. 2006 assembly)

Database: hg19 Primary Table: pgNA12878 Row Count: 3,047,245
Format description: personal genome SNP

field	example	SQL type	description
`bin`	585	`smallint(5) unsigned`	A field to speed indexing
`chrom`	chr1	`varchar(255)`	Chromosome
`chromStart`	62202	`int(10) unsigned`	Start position in chrom
`chromEnd`	62203	`int(10) unsigned`	End position in chrom
`name`	C/T	`varchar(255)`	alleles
`alleleCount`	2	`int(11)`	number of alleles
`alleleFreq`	0,0	`varchar(255)`	comma separated list of frequency of each allele
`alleleScores`	64,64	`varchar(255)`	comma separated list of quality scores

bin	chrom	chromStart	chromEnd	name	alleleCount	alleleFreq	alleleScores
585	chr1	62202	62203	C/T	2	0,0	64,64
585	chr1	101685	101686	A/G	2	0,0	67,67
586	chr1	233472	233473	C/G	2	0,0	100,100
590	chr1	705881	705882	A/G	2	0,0	100,100
590	chr1	723890	723891	C	1	0	68
590	chr1	734565	734566	A/G	2	0,0	21,21
590	chr1	752565	752566	A	1	0	85
590	chr1	752720	752721	G	1	0	100
590	chr1	754181	754182	G	1	0	78
590	chr1	754333	754334	C	1	0	92

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.