Schema for knownToKeggEntrez
  Database: hg38    Primary Table: knownToKeggEntrez    Row Count: 139,390   Data last updated: 2021-01-27
Format description: Cross-reference of rgdGene2 gene ID to KEGG ID and KEGG ID + Entrez ID
fieldexampleSQL type info description
name ENST00000000412.8varchar(255) values Same as name field in rgdGene2 gene
value hsa04142varchar(255) values KEGG ID
keggEntrez hsa04142+4074varchar(255) values KEGG ID + Entrez ID

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToKeggEntrez.name)
      hg38.ccdsKgMap.geneId (via knownToKeggEntrez.name)
      hg38.ceBlastTab.query (via knownToKeggEntrez.name)
      hg38.dmBlastTab.query (via knownToKeggEntrez.name)
      hg38.drBlastTab.query (via knownToKeggEntrez.name)
      hg38.foldUtr3.name (via knownToKeggEntrez.name)
      hg38.foldUtr5.name (via knownToKeggEntrez.name)
      hg38.gnfAtlas2Distance.query (via knownToKeggEntrez.name)
      hg38.gnfAtlas2Distance.target (via knownToKeggEntrez.name)
      hg38.gnfU95Distance.query (via knownToKeggEntrez.name)
      hg38.gnfU95Distance.target (via knownToKeggEntrez.name)
      hg38.humanHprdP2P.query (via knownToKeggEntrez.name)
      hg38.humanHprdP2P.target (via knownToKeggEntrez.name)
      hg38.humanVidalP2P.query (via knownToKeggEntrez.name)
      hg38.humanVidalP2P.target (via knownToKeggEntrez.name)
      hg38.humanWankerP2P.query (via knownToKeggEntrez.name)
      hg38.humanWankerP2P.target (via knownToKeggEntrez.name)
      hg38.keggPathway.kgID (via knownToKeggEntrez.name)
      hg38.kgAlias.kgID (via knownToKeggEntrez.name)
      hg38.kgColor.kgID (via knownToKeggEntrez.name)
      hg38.kgProtAlias.kgID (via knownToKeggEntrez.name)
      hg38.kgSpAlias.kgID (via knownToKeggEntrez.name)
      hg38.kgTargetAli.qName (via knownToKeggEntrez.name)
      hg38.kgXref.kgID (via knownToKeggEntrez.name)
      hg38.knownAttrs.kgID (via knownToKeggEntrez.name)
      hg38.knownBlastTab.query (via knownToKeggEntrez.name)
      hg38.knownBlastTab.target (via knownToKeggEntrez.name)
      hg38.knownCanonical.transcript (via knownToKeggEntrez.name)
      hg38.knownCds.name (via knownToKeggEntrez.name)
      hg38.knownGene.name (via knownToKeggEntrez.name)
      hg38.knownGeneMrna.name (via knownToKeggEntrez.name)
      hg38.knownGenePep.name (via knownToKeggEntrez.name)
      hg38.knownIsoforms.transcript (via knownToKeggEntrez.name)
      hg38.knownToEnsembl.name (via knownToKeggEntrez.name)
      hg38.knownToGnfAtlas2.name (via knownToKeggEntrez.name)
      hg38.knownToHprd.name (via knownToKeggEntrez.name)
      hg38.knownToLocusLink.name (via knownToKeggEntrez.name)
      hg38.knownToLynx.name (via knownToKeggEntrez.name)
      hg38.knownToMrna.name (via knownToKeggEntrez.name)
      hg38.knownToMrnaSingle.name (via knownToKeggEntrez.name)
      hg38.knownToMupit.name (via knownToKeggEntrez.name)
      hg38.knownToNextProt.name (via knownToKeggEntrez.name)
      hg38.knownToPfam.name (via knownToKeggEntrez.name)
      hg38.knownToRefSeq.name (via knownToKeggEntrez.name)
      hg38.knownToSuper.gene (via knownToKeggEntrez.name)
      hg38.knownToTag.name (via knownToKeggEntrez.name)
      hg38.knownToU133.name (via knownToKeggEntrez.name)
      hg38.knownToU95.name (via knownToKeggEntrez.name)
      hg38.knownToVisiGene.name (via knownToKeggEntrez.name)
      hg38.knownToWikipedia.name (via knownToKeggEntrez.name)
      hg38.mmBlastTab.query (via knownToKeggEntrez.name)
      hg38.rnBlastTab.query (via knownToKeggEntrez.name)
      hg38.scBlastTab.query (via knownToKeggEntrez.name)
      hg38.ucscScop.ucscId (via knownToKeggEntrez.name)
      hg38.keggMapDesc.mapID (via knownToKeggEntrez.value)
      hg38.keggPathway.mapID (via knownToKeggEntrez.value)

Sample Rows
 
namevaluekeggEntrez
ENST00000000412.8hsa04142hsa04142+4074
ENST00000001146.6hsa00830hsa00830+56603
ENST00000002165.11hsa00511hsa00511+2519
ENST00000002596.6hsa00534hsa00534+9957
ENST00000002829.8hsa04360hsa04360+6405
ENST00000003084.11hsa02010hsa02010+1080
ENST00000003084.11hsa05110hsa05110+1080
ENST00000003100.13hsa00100hsa00100+1595
ENST00000003100.13hsa01100hsa01100+1595
ENST00000005180.9hsa04060hsa04060+10344

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