Schema for ensemblXref3
  Database: rn4    Primary Table: ensemblXref3    Row Count: 38,051   Data last updated: 2006-06-19
Format description: A cross-reference table for Ensembl Genes.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
gene ENSRNOG00000030610char(20) values Ensembl gene ID
geneVer 0char(4) values Ensembl gene ID version number
transcript ENSRNOT00000041614char(20) values Ensembl transcript ID
transcriptVer 0char(4) values Ensembl transcript ID version number
protein ENSRNOP00000043983char(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
        rn4.sfAssign.seqID (via ensemblXref3.protein)

Sample Rows
 
genegeneVertranscripttranscriptVerproteinproteinVertremblAccswissDisplayIdswissAcc
ENSRNOG000000306100ENSRNOT000000416140ENSRNOP000000439830
ENSRNOG000000302850ENSRNOT000000408990ENSRNOP000000481860
ENSRNOG000000302850ENSRNOT000000435280ENSRNOP000000454400
ENSRNOG000000302850ENSRNOT000000400650ENSRNOP000000432630EPHA3_RATO08680
ENSRNOG000000302850ENSRNOT000000456620ENSRNOP000000455580
ENSRNOG000000302850ENSRNOT000000430620ENSRNOP000000466800
ENSRNOG000000302850ENSRNOT000000401600ENSRNOP000000440150
ENSRNOG000000302850ENSRNOT000000478220ENSRNOP000000466570
ENSRNOG000000302850ENSRNOT000000456340ENSRNOP000000472440
ENSRNOG000000360410ENSRNOT0000005416400

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