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
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 | rs756427959 | 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 | rs756427959 | NR_024540 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 14397 | 14400 | rs756427959 | NR_046018 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 17358 | 17361 | rs749387668 | NR_024540 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 51972 | 51975 | rs546829777 | XR_948874 | n/a | 1 | 45, | -, | n/a, | n/a, |
585 | chr1 | 69115 | 69116 | rs757299236 | NM_001005484 | 2 | 2 | 8,42, | G,A, | GGT,GAT, | G,D, |
585 | chr1 | 69133 | 69134 | rs781394307 | NM_001005484 | 2 | 2 | 8,42, | A,G, | GAA,GGA, | E,G, |
585 | chr1 | 69217 | 69218 | rs746046455 | NM_001005484 | 2 | 2 | 8,42, | T,C, | GTA,GCA, | V,A, |
585 | chr1 | 69223 | 69224 | rs568964432 | NM_001005484 | 2 | 2 | 8,42, | A,T, | GAC,GTC, | D,V, |
585 | chr1 | 69240 | 69241 | rs768461588 | NM_001005484 | 1 | 2 | 8,42, | C,T, | CCC,TCC, | P,S, |
585 | chr1 | 69265 | 69266 | rs774179629 | NM_001005484 | 2 | 2 | 8,42, | T,A, | CTC,CAC, | L,H, |
|
Note: all start coordinates in our database are 0-based, not
1-based. See explanation
here.
| |
|
|
|