Schema for snp146CodingDbSnp
  Database: hg38    Primary Table: snp146CodingDbSnp    Row Count: 34,754,673   Data last updated: 2016-03-11
Format description: Annotations of the effects of SNPs on translated protein sequence.
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(6) Indexing field to speed chromosome range queries.
chrom chr1varchar(255) Reference sequence chromosome or scaffold
chromStart 14397int(10) unsigned Start position in chromosome
chromEnd 14400int(10) unsigned End position in chromosome
name rs756427959varchar(255) Reference SNP identifier
transcript NR_024540varchar(255) Accession of the transcript modified by SNP
frame n/aenum('1', '2', '3', 'n/a') Frame of transcript's codon modified by SNP
alleleCount 1int(11) Number of annotated alleles for SNP
funcCodes 45,longblob dbSNP function codes (e.g. 42=missense)
alleles -,longblob Observed nucleotide alleles corresponding to funcCodes
codons n/a,longblob Codons corresponding to funcCodes
peptides n/a,longblob Amino acid sequence corresponding to funcCodes

Connected Tables and Joining Fields
        hg38.snp146.name (via snp146CodingDbSnp.name)
      hg38.snp146Common.name (via snp146CodingDbSnp.name)
      hg38.snp146Flagged.name (via snp146CodingDbSnp.name)
      hg38.snp146Mult.name (via snp146CodingDbSnp.name)
      hg38.snp146OrthoPt4Pa2Rm3.name (via snp146CodingDbSnp.name)
      hg38.snp146Seq.acc (via snp146CodingDbSnp.name)

Sample Rows
 
binchromchromStartchromEndnametranscriptframealleleCountfuncCodesallelescodonspeptides
585chr11439714400rs756427959NR_024540n/a145,-,n/a,n/a,
585chr11439714400rs756427959NR_046018n/a145,-,n/a,n/a,
585chr11735817361rs749387668NR_024540n/a145,-,n/a,n/a,
585chr15197251975rs546829777XR_948874n/a145,-,n/a,n/a,
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,

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