Schema for ensemblXref3
  Database: hg18    Primary Table: ensemblXref3    Row Count: 129,019   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 ENSG00000206668char(20) values Ensembl gene ID
geneVer 0char(4) values Ensembl gene ID version number
transcript ENST00000383941char(20) values Ensembl transcript ID
transcriptVer 0char(4) values Ensembl transcript ID version number
protein  char(20) values Ensembl protein ID
proteinVer 0char(4) values Ensembl protein version number
tremblAcc  char(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
        hg18.sfAssign.seqID (via ensemblXref3.protein)

Sample Rows
 
genegeneVertranscripttranscriptVerproteinproteinVertremblAccswissDisplayIdswissAcc
ENSG000002066680ENST0000038394100
ENSG000002067890ENST0000038406200
ENSG000002078910ENST0000038515600
ENSG000002073760ENST0000038464600
ENSG000001952160ENST0000035227500
ENSG000002079180ENST0000038518300
ENSG000001947510ENST0000035386200
ENSG000002067500ENST0000038402300
ENSG000002073720ENST0000038464200
ENSG000002078800ENST0000038514500

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