Schema for YRI NA18507 - YRI NA18507 (Illumina Cambridge/Solexa, SNPs called by PSU) (from Human Mar. 2006 assembly)

Database: hg19 Primary Table: pgYoruban3 Row Count: 3,835,591
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`	10468	`int(10) unsigned`	Start position in chrom
`chromEnd`	10469	`int(10) unsigned`	End position in chrom
`name`	C/G	`varchar(255)`	alleles
`alleleCount`	2	`int(11)`	number of alleles
`alleleFreq`	0,0	`varchar(255)`	comma separated list of frequency of each allele
`alleleScores`	65,65	`varchar(255)`	comma separated list of quality scores

bin	chrom	chromStart	chromEnd	name	alleleCount	alleleFreq	alleleScores
585	chr1	10468	10469	C/G	2	0,0	65,65
585	chr1	55298	55299	C/T	2	0,0	119,119
585	chr1	63670	63671	A	1	0	250
585	chr1	63696	63697	C	1	0	36
585	chr1	67180	67181	A/G	2	0,0	120,120
586	chr1	233472	233473	G	1	0	33
587	chr1	362906	362907	C	1	0	28
588	chr1	416201	416202	G/T	2	0,0	26,26
589	chr1	574150	574151	A/T	2	0,0	200,200
590	chr1	723797	723798	C/G	2	0,0	40,40

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