Schema for YRI daught '9240 - YRI Trio Daughter NA19240 (1000 Genomes Project) (from Human Mar. 2006 assembly)

Database: hg19 Primary Table: pgNA19240 Row Count: 3,583,007
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`	61461	`int(10) unsigned`	Start position in chrom
`chromEnd`	61462	`int(10) unsigned`	End position in chrom
`name`	A	`varchar(255)`	alleles
`alleleCount`	1	`int(11)`	number of alleles
`alleleFreq`	0	`varchar(255)`	comma separated list of frequency of each allele
`alleleScores`	2	`varchar(255)`	comma separated list of quality scores

bin	chrom	chromStart	chromEnd	name	alleleCount	alleleFreq	alleleScores
585	chr1	61461	61462	A	1	0	2
586	chr1	233472	233473	C/G	2	0,0	9,9
590	chr1	718385	718386	G	1	0	0
590	chr1	718554	718555	C	1	0	0
590	chr1	720239	720240	C	1	0	0
590	chr1	723890	723891	C/G	2	0,0	11,11
590	chr1	739141	739142	A/T	2	0,0	2,2
590	chr1	752565	752566	A	1	0	5
590	chr1	752720	752721	G	1	0	21
590	chr1	752893	752894	C	1	0	0

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