Schema for snp142CodingDbSnp
  Database: hg38    Primary Table: snp142CodingDbSnp    Row Count: 8,334,277   Data last updated: 2014-11-19
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 rs370886505varchar(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.snp142.name (via snp142CodingDbSnp.name)
      hg38.snp142Common.name (via snp142CodingDbSnp.name)
      hg38.snp142Flagged.name (via snp142CodingDbSnp.name)
      hg38.snp142Mult.name (via snp142CodingDbSnp.name)
      hg38.snp142OrthoPt4Pa2Rm3.name (via snp142CodingDbSnp.name)
      hg38.snp142Seq.acc (via snp142CodingDbSnp.name)

Sample Rows
 
binchromchromStartchromEndnametranscriptframealleleCountfuncCodesallelescodonspeptides
585chr11439714400rs370886505NR_024540n/a145,-,n/a,n/a,
585chr11439714400rs370886505NR_046018n/a145,-,n/a,n/a,
585chr16922369224rs568964432NM_001005484228,42,A,T,GAC,GTC,D,V,
585chr16926969270rs201219564NM_001005484328,3,A,G,TCA,TCG,S,S,
585chr16942769428rs140739101NM_001005484228,42,T,G,TTT,TGT,F,C,
585chr16945269453rs2854682NM_001005484328,3,G,A,AAG,AAA,K,K,
585chr16947569476rs148502021NM_001005484228,42,T,C,ATG,ACG,M,T,
585chr16948569486rs548369610NM_001005484328,3,C,T,AAC,AAT,N,N,
585chr16948669487rs568226429NM_001005484128,42,G,A,GCA,ACA,A,T,
585chr16949569496rs150690004NM_001005484128,42,G,A,GGC,AGC,G,S,

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