Schema for ensGeneXref
  Database: rn3    Primary Table: ensGeneXref    Row Count: 103,422   Data last updated: 2004-04-30
Format description: This is the table gene_xref downloaded directly from Ensembl ftp site (18.34 release 11/04). Please refer to Ensembl site for details. CAUTION: Ensembl sometimes changes its table definitions and some field may not contais data as its name indicates, e.g. translation_name.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
db corevarchar(40) values unknown - check with Ensembl
analysis ensemblvarchar(40) values unknown - check with Ensembl
type ensemblvarchar(40) values unknown - check with Ensembl
gene_id 96736int(10) unsigned range gene ID
gene_name ENSRNOG00000012136varchar(40) values gene name
gene_version 2smallint(5) unsigned range gene version
transcript_id 122346int(10) unsigned range transcript ID
transcript_name ENSRNOT00000016190varchar(40) values transcript name
transcript_version 2smallint(5) unsigned range transcript version
translation_name 65535smallint(5) unsigned range translation name
translation_id 0int(10) unsigned range translation ID
translation_version 1smallint(5) unsigned range translation version
external_db AFFY_RAE230_allvarchar(40) values external database
external_name 1373069_atvarchar(40) values external name
external_status XREFvarchar(10) values external status

Connected Tables and Joining Fields
        rn3.ensGtp.gene (via ensGeneXref.gene_name)
      rn3.ensTranscript.gene_name (via ensGeneXref.gene_name)
      knownGeneV39.knownToEnsembl.value (via ensGeneXref.transcript_name)
      rn3.ensGene.name (via ensGeneXref.transcript_name)
      rn3.ensGtp.transcript (via ensGeneXref.transcript_name)
      rn3.ensPep.name (via ensGeneXref.transcript_name)
      rn3.ensTranscript.transcript_name (via ensGeneXref.transcript_name)
      rn3.knownToEnsembl.value (via ensGeneXref.transcript_name)

Sample Rows
 
dbanalysistypegene_idgene_namegene_versiontranscript_idtranscript_nametranscript_versiontranslation_nametranslation_idtranslation_versionexternal_dbexternal_nameexternal_status
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RAE230_all1373069_atXREF
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RAE230A1373069_atXREF
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RG_U34_allrc_AI103151_atXREF
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RG_U34_allrc_AI172115_atXREF
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RG_U34Crc_AI103151_atXREF
coreensemblensembl96736ENSRNOG000000121362122346ENSRNOT0000001619026553501AFFY_RG_U34Crc_AI172115_atXREF
coreensemblensembl96737ENSRNOG000000122782122347ENSRNOT0000001648526553501SWISSPROTFGFA_RATKNOWN
coreensemblensembl96737ENSRNOG000000122782122347ENSRNOT0000001648526553501EMBLD79215KNOWNXREF
coreensemblensembl96737ENSRNOG000000122782122347ENSRNOT0000001648526553501protein_idBAA11468.1KNOWNXREF
coreensemblensembl96737ENSRNOG000000122782122347ENSRNOT0000001648526553501RefSeqNM_012951KNOWN

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