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
field | example | SQL type | description |
bin | 585 | smallint(6) | Indexing field to speed chromosome range queries. |
chrom | chr1 | varchar(255) | Reference sequence chromosome or scaffold |
chromStart | 14397 | int(10) unsigned | Start position in chromosome |
chromEnd | 14400 | int(10) unsigned | End position in chromosome |
name | rs370886505 | varchar(255) | Reference SNP identifier |
transcript | NR_024540 | varchar(255) | Accession of the transcript modified by SNP |
frame | n/a | enum('1', '2', '3', 'n/a') | Frame of transcript's codon modified by SNP |
alleleCount | 1 | int(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
|
|
Sample Rows
|
|
bin | chrom | chromStart | chromEnd | name | transcript | frame | alleleCount | funcCodes | alleles | codons | peptides |
---|
585 | chr1 | 14397 | 14400 | rs370886505 | NR_024540 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 14397 | 14400 | rs370886505 | NR_046018 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 69223 | 69224 | rs568964432 | NM_001005484 | 2 | 2 | 8,42, | A,T, | GAC,GTC, | D,V, |
585 | chr1 | 69269 | 69270 | rs201219564 | NM_001005484 | 3 | 2 | 8,3, | A,G, | TCA,TCG, | S,S, |
585 | chr1 | 69427 | 69428 | rs140739101 | NM_001005484 | 2 | 2 | 8,42, | T,G, | TTT,TGT, | F,C, |
585 | chr1 | 69452 | 69453 | rs2854682 | NM_001005484 | 3 | 2 | 8,3, | G,A, | AAG,AAA, | K,K, |
585 | chr1 | 69475 | 69476 | rs148502021 | NM_001005484 | 2 | 2 | 8,42, | T,C, | ATG,ACG, | M,T, |
585 | chr1 | 69485 | 69486 | rs548369610 | NM_001005484 | 3 | 2 | 8,3, | C,T, | AAC,AAT, | N,N, |
585 | chr1 | 69486 | 69487 | rs568226429 | NM_001005484 | 1 | 2 | 8,42, | G,A, | GCA,ACA, | A,T, |
585 | chr1 | 69495 | 69496 | rs150690004 | NM_001005484 | 1 | 2 | 8,42, | G,A, | GGC,AGC, | G,S, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|