Schema for snp142CodingDbSnp
  Database: mm10    Primary Table: snp142CodingDbSnp    Row Count: 1,951,211   Data last updated: 2015-11-21
Format description: Annotations of the effects of SNPs on translated protein sequence.
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 609smallint(6) Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 3216135int(10) unsigned Start position in chromosome
chromEnd 3216136int(10) unsigned End position in chromosome
name rs222134274varchar(255) Reference SNP identifier
transcript NM_001011874varchar(255) Accession of the transcript modified by SNP
frame 3enum('1', '2', '3', 'n/a') Frame of transcript's codon modified by SNP
alleleCount 2int(11) Number of annotated alleles for SNP
funcCodes 8,3,longblob dbSNP function codes (e.g. 42=missense)
alleles T,C,longblob Observed nucleotide alleles corresponding to funcCodes
codons GAT,GAC,longblob Codons corresponding to funcCodes
peptides D,D,longblob Amino acid sequence corresponding to funcCodes

Connected Tables and Joining Fields
        mm10.snp142.name (via snp142CodingDbSnp.name)
      mm10.snp142Common.name (via snp142CodingDbSnp.name)
      mm10.snp142Mult.name (via snp142CodingDbSnp.name)
      mm10.snp142Seq.acc (via snp142CodingDbSnp.name)

Sample Rows
 
binchromchromStartchromEndnametranscriptframealleleCountfuncCodesallelescodonspeptides
609chr132161353216136rs222134274NM_001011874328,3,T,C,GAT,GAC,D,D,
609chr132161353216136rs222134274XM_006495550328,3,T,C,GAT,GAC,D,D,
609chr132163813216382rs243921731NM_001011874328,3,A,T,CCA,CCT,P,P,
609chr132163813216382rs243921731XM_006495550328,3,A,T,CCA,CCT,P,P,
609chr132164233216424rs264606683NM_001011874328,3,G,C,GGG,GGC,G,G,
609chr132164233216424rs264606683XM_006495550328,3,G,C,GGG,GGC,G,G,
609chr132164353216436rs51278881NM_001011874328,3,T,C,TTT,TTC,F,F,
609chr132164353216436rs51278881XM_006495550328,3,T,C,TTT,TTC,F,F,
609chr132167413216742rs31156237NM_001011874328,3,C,A,ATC,ATA,I,I,
609chr132167413216742rs31156237XM_006495550328,3,C,A,ATC,ATA,I,I,

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