Schema for snpArrayIlluminaHuman660W_Quad
  Database: hg18    Primary Table: snpArrayIlluminaHuman660W_Quad    Row Count: 665,901   Data last updated: 2009-12-09
Format description: Illumina 300K SNP Array
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585int(10) unsigned For browser speedup
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 10003int(10) unsigned Start position in chrom
chromEnd 10004int(10) unsigned End position in chrom
name cnvi0115911varchar(255) Identifier
score 0int(10) unsigned Not used
strand Tchar(1) Strand: +, - or ?
observed A/Gblob Observed alleles

Connected Tables and Joining Fields
        hg18.gwasCatalog.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snp130.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snp130CodingDbSnp.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snp130Exceptions.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snp130OrthoPt2Pa2Rm2.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snp130Seq.acc (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snpArrayIlluminaHumanCytoSNP_12.name (via snpArrayIlluminaHuman660W_Quad.name)
      hg18.snpArrayIlluminaHumanOmni1_Quad.name (via snpArrayIlluminaHuman660W_Quad.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandobserved
585chr11000310004cnvi01159110TA/G
585chr11434214343cnvi00525550PN/A
585chr11768517686rs4489420-C/G
585chr11856918570cnvi00525560PN/A
585chr12260522606cnvi00525570PN/A
585chr12503425035rs39827340-C/T
585chr12683826839cnvi00525580PN/A
585chr12887728878rs23688110+A/C
585chr13105631057cnvi00525590PN/A
585chr13539335394cnvi00525600PN/A

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