Schema for snp130CodingDbSnp
  Database: hg18    Primary Table: snp130CodingDbSnp    Row Count: 279,815   Data last updated: 2010-10-12
Format description: Annotations of the effects of SNPs on translated protein sequence.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(6) range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 59414int(10) unsigned range Start position in chromosome
chromEnd 59415int(10) unsigned range End position in chromosome
name rs55874132varchar(255) values Reference SNP identifier
transcript NM_001005484varchar(255) values Accession of the transcript modified by SNP
frame 3enum('1', '2', '3') values Frame of transcript's codon modified by SNP
alleleCount 2int(11) range Number of annotated alleles for SNP
funcCodes 8,3,longblob   dbSNP function codes (e.g. 42=missense)
alleles G,C,longblob   Observed nucleotide alleles corresponding to funcCodes
codons GCG,GCC,longblob   Codons corresponding to funcCodes
peptides A,A,longblob   Amino acid sequence corresponding to funcCodes

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

Sample Rows
 
binchromchromStartchromEndnametranscriptframealleleCountfuncCodesallelescodonspeptides
585chr15941459415rs55874132NM_001005484328,3,G,C,GCG,GCC,A,A,
585chr17803178032rs940550XM_001724183228,42,C,T,GCC,GTC,A,V,
585chr17803478035rs940551XM_001724183228,42,G,A,CGT,CAT,R,H,
585chr17807878079rs2103136XM_001724183128,42,A,G,ATC,GTC,I,V,
585chr17812778128rs940552XM_001724183228,42,C,T,TCT,TTT,S,F,
585chr17820078201rs55700207XM_001724183328,3,G,A,GAG,GAA,E,E,
590chr1743267743268rs61770173XM_001724496328,3,G,T,CCG,CCT,P,P,
590chr1743287743288rs3131970XM_001724496128,42,A,G,ACA,GCA,T,A,
590chr1743336743337rs2073814XM_001724496328,3,G,C,CTG,CTC,L,L,
591chr1845903845904rs61769717XM_001724524328,3,C,T,CGC,CGT,R,R,

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