Schema for snp130Exceptions
  Database: hg18    Primary Table: snp130Exceptions    Row Count: 2,631,563   Data last updated: 2009-07-07
Format description: Annotations on data from dbSNP (for version 125 and later).
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(6) Indexing field to speed chromosome range queries.
chrom chr1varchar(31) Reference sequence chromosome or scaffold
chromStart 259int(10) unsigned Start position in chrom
chromEnd 260int(10) unsigned End position in chrom
name rs72477211varchar(15) Reference SNP identifier or Affy SNP name
exception MultipleAlignmentsvarchar(63) Exception found for this SNP

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

Sample Rows
 
binchromchromStartchromEndnameexception
585chr1259260rs72477211MultipleAlignments
585chr1259260rs72477211ObservedMismatch
585chr1884885rs62636509MultipleAlignments
585chr1943944rs10218495MultipleAlignments
585chr110161017rs62635278MultipleAlignments
585chr110291030rs62635279MultipleAlignments
585chr112711272rs9803797MultipleAlignments
585chr112711272rs2441671MultipleAlignments
585chr113191320rs2758124MultipleAlignments
585chr113321333rs3950659MultipleAlignments

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