Schema for ensemblXref3
  Database: mm8    Primary Table: ensemblXref3    Row Count: 61,033   Data last updated: 2006-06-20
Format description: A cross-reference table for Ensembl Genes.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSMUSG00000058140char(20) values Ensembl gene ID
geneVer 0char(4) values Ensembl gene ID version number
transcript ENSMUST00000081249char(20) values Ensembl transcript ID
transcriptVer 0char(4) values Ensembl transcript ID version number
protein ENSMUSP00000080006char(20) values Ensembl protein ID
proteinVer 0char(4) values Ensembl protein version number
tremblAcc Q3TG39char(20) values TrEMBL protein accession number
swissDisplayId  char(20) values Swiss-Prot protein display ID
swissAcc  char(20) values Swiss-Prot protein accession number

Connected Tables and Joining Fields
        mm8.sfAssign.seqID (via ensemblXref3.protein)

Sample Rows
 
genegeneVertranscripttranscriptVerproteinproteinVertremblAccswissDisplayIdswissAcc
ENSMUSG000000581400ENSMUST000000812490ENSMUSP000000800060Q3TG39
ENSMUSG000000581400ENSMUST000000718290ENSMUSP000000717320Q6PB35
ENSMUSG000000237640ENSMUST000000934060ENSMUSP000000911100Q5NC01
ENSMUSG000000237640ENSMUST000000934070ENSMUSP000000911130Q9CTY8
ENSMUSG000000237640ENSMUST000000934070ENSMUSP000000911130Q80ZY0
ENSMUSG000000237640ENSMUST000001016550ENSMUSP000000991780Q3KQN2
ENSMUSG000000237640ENSMUST000000727040ENSMUSP000000724880Q6ZQ99
ENSMUSG000000237640ENSMUST000000813180ENSMUSP000000800660Q3UZY0
ENSMUSG000000237640ENSMUST000000813180ENSMUSP000000800660Q9CTY8
ENSMUSG000000237640ENSMUST000000813180ENSMUSP000000800660Q80ZJ4

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