Schema for snp150CodingDbSnp
  Database: hg38    Primary Table: snp150CodingDbSnp    Row Count: 45,079,153   Data last updated: 2017-04-18
Format description: Annotations of the effects of SNPs on translated protein sequence.
fieldexampleSQL type description
bin 585smallint(6) Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 69091int(10) unsigned Start position in chromosome
chromEnd 69092int(10) unsigned End position in chromosome
name rs985675606varchar(255) Reference SNP identifier
transcript NM_001005484varchar(255) Accession of the transcript modified by SNP
frame 2enum('1', '2', '3', 'n/a') Frame of transcript's codon modified by SNP
alleleCount 2int(11) Number of annotated alleles for SNP
funcCodes 8,42,longblob dbSNP function codes (e.g. 42=missense)
alleles T,C,longblob Observed nucleotide alleles corresponding to funcCodes
codons ATG,ACG,longblob Codons corresponding to funcCodes
peptides M,T,longblob Amino acid sequence corresponding to funcCodes

Connected Tables and Joining Fields
        hg38.snp150.name (via snp150CodingDbSnp.name)
      hg38.snp150Common.name (via snp150CodingDbSnp.name)
      hg38.snp150Flagged.name (via snp150CodingDbSnp.name)
      hg38.snp150Mult.name (via snp150CodingDbSnp.name)
      hg38.snp150OrthoPt5Pa2Rm8.name (via snp150CodingDbSnp.name)
      hg38.snp150Seq.acc (via snp150CodingDbSnp.name)

Sample Rows
 
binchromchromStartchromEndnametranscriptframealleleCountfuncCodesallelescodonspeptides
585chr16909169092rs985675606NM_001005484228,42,T,C,ATG,ACG,M,T,
585chr16911569116rs757299236NM_001005484228,42,G,A,GGT,GAT,G,D,
585chr16913369134rs781394307NM_001005484228,42,A,G,GAA,GGA,E,G,
585chr16921769218rs746046455NM_001005484228,42,T,C,GTA,GCA,V,A,
585chr16922369224rs568964432NM_001005484228,42,A,T,GAC,GTC,D,V,
585chr16924069241rs768461588NM_001005484128,42,C,T,CCC,TCC,P,S,
585chr16926569266rs774179629NM_001005484228,42,T,A,CTC,CAC,L,H,
585chr16926969270rs201219564NM_001005484328,3,A,G,TCA,TCG,S,S,
585chr16929969300rs771968901NM_001005484328,3,A,C,ACA,ACC,T,T,
585chr16933469335rs773188222NM_001005484228,42,G,A,CGC,CAC,R,H,

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