Schema for rgdGene2ToKeggEntrez
  Database: rn4    Primary Table: rgdGene2ToKeggEntrez    Row Count: 6,642   Data last updated: 2010-10-25
Format description: Cross-reference of rgdGene2 gene ID to KEGG ID and KEGG ID + Entrez ID
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name RGD:1302965varchar(255) values Same as name field in rgdGene2 gene
value rno01100varchar(255) values KEGG ID
keggEntrez rno01100+312086varchar(255) values KEGG ID + Entrez ID

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via rgdGene2ToKeggEntrez.name)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via rgdGene2ToKeggEntrez.name)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via rgdGene2ToKeggEntrez.name)
      rn4.affyExonTissuesGsRgdGene2.name (via rgdGene2ToKeggEntrez.name)
      rn4.ceBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.dmBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.drBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.gnfAtlas2RgdGene2Distance.query (via rgdGene2ToKeggEntrez.name)
      rn4.gnfAtlas2RgdGene2Distance.target (via rgdGene2ToKeggEntrez.name)
      rn4.hgBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.mmBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2BlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2BlastTab.target (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2Canonical.transcript (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2Isoforms.transcript (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2KeggPathway.rgdId (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2Pep.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToDescription.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToDisplayId.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToEnsembl.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToGenbank.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToGenbankAll.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToGnfAtlas2.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToLocusLink.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToPDB.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToPfam.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToRAE230.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToRefSeq.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToSymbol.rgdId (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToU34A.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2ToUniProt.name (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGene2Xref.rgdGeneId (via rgdGene2ToKeggEntrez.name)
      rn4.rgdGenePathway.geneId (via rgdGene2ToKeggEntrez.name)
      rn4.scBlastTab.query (via rgdGene2ToKeggEntrez.name)
      rn4.keggMapDesc.mapID (via rgdGene2ToKeggEntrez.value)
      rn4.keggPathway.mapID (via rgdGene2ToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
RGD:1302965rno01100rno01100+312086
RGD:1302973rno04080rno04080+295144
RGD:1302976rno03010rno03010+290641
RGD:1302982rno00564rno00564+361401
RGD:1302982rno04142rno04142+361401
RGD:1302984rno04520rno04520+361084
RGD:1303007rno03010rno03010+296709
RGD:1303018rno03030rno03030+288532
RGD:1303018rno04110rno04110+288532
RGD:1303023rno00230rno00230+297998

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