Schema for snp150CodingDbSnp
  Database: hg38    Primary Table: snp150CodingDbSnp    Row Count: 45,079,153   Data last updated: 2020-06-15
fieldexampleSQL type
bin 585smallint(6)
chrom chr1varchar(255)
chromStart 69091int(10) unsigned
chromEnd 69092int(10) unsigned
name rs985675606varchar(255)
transcript NM_001005484varchar(255)
frame 2enum('1', '2', '3', 'n/a')
alleleCount 2int(11)
funcCodes 8,42,longblob
alleles T,C,longblob
codons ATG,ACG,longblob
peptides M,T,longblob

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.