Schema for bioCycPathway
  Database: hg18    Primary Table: bioCycPathway    Row Count: 1,345   Data last updated: 2009-03-06
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc002tzo.1varchar(40) values Known Gene ID
geneID UPP2varchar(40) values Gene (RefSeq) ID
mapID RIB-DRIBMET-PWYvarchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        hg18.ccdsKgMap.geneId (via bioCycPathway.kgID)
      hg18.ceBlastTab.query (via bioCycPathway.kgID)
      hg18.dmBlastTab.query (via bioCycPathway.kgID)
      hg18.drBlastTab.query (via bioCycPathway.kgID)
      hg18.foldUtr3.name (via bioCycPathway.kgID)
      hg18.foldUtr5.name (via bioCycPathway.kgID)
      hg18.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg18.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg18.gnfU95Distance.query (via bioCycPathway.kgID)
      hg18.gnfU95Distance.target (via bioCycPathway.kgID)
      hg18.humanHprdP2P.query (via bioCycPathway.kgID)
      hg18.humanHprdP2P.target (via bioCycPathway.kgID)
      hg18.humanVidalP2P.query (via bioCycPathway.kgID)
      hg18.humanVidalP2P.target (via bioCycPathway.kgID)
      hg18.humanWankerP2P.query (via bioCycPathway.kgID)
      hg18.humanWankerP2P.target (via bioCycPathway.kgID)
      hg18.keggPathway.kgID (via bioCycPathway.kgID)
      hg18.kgAlias.kgID (via bioCycPathway.kgID)
      hg18.kgColor.kgID (via bioCycPathway.kgID)
      hg18.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg18.kgProtMap2.qName (via bioCycPathway.kgID)
      hg18.kgSpAlias.kgID (via bioCycPathway.kgID)
      hg18.kgTargetAli.qName (via bioCycPathway.kgID)
      hg18.kgTxInfo.name (via bioCycPathway.kgID)
      hg18.kgXref.kgID (via bioCycPathway.kgID)
      hg18.knownBlastTab.query (via bioCycPathway.kgID)
      hg18.knownBlastTab.target (via bioCycPathway.kgID)
      hg18.knownCanonToDecipher.name (via bioCycPathway.kgID)
      hg18.knownCanonical.protein (via bioCycPathway.kgID)
      hg18.knownCanonical.transcript (via bioCycPathway.kgID)
      hg18.knownGene.name (via bioCycPathway.kgID)
      hg18.knownGeneMrna.name (via bioCycPathway.kgID)
      hg18.knownGenePep.name (via bioCycPathway.kgID)
      hg18.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg18.knownToAllenBrain.name (via bioCycPathway.kgID)
      hg18.knownToDecipher.name (via bioCycPathway.kgID)
      hg18.knownToEnsembl.name (via bioCycPathway.kgID)
      hg18.knownToGnf1h.name (via bioCycPathway.kgID)
      hg18.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg18.knownToHInv.name (via bioCycPathway.kgID)
      hg18.knownToHprd.name (via bioCycPathway.kgID)
      hg18.knownToKeggEntrez.name (via bioCycPathway.kgID)
      hg18.knownToLocusLink.name (via bioCycPathway.kgID)
      hg18.knownToMupit.name (via bioCycPathway.kgID)
      hg18.knownToPfam.name (via bioCycPathway.kgID)
      hg18.knownToRefSeq.name (via bioCycPathway.kgID)
      hg18.knownToSuper.gene (via bioCycPathway.kgID)
      hg18.knownToTreefam.name (via bioCycPathway.kgID)
      hg18.knownToU133.name (via bioCycPathway.kgID)
      hg18.knownToU133Plus2.name (via bioCycPathway.kgID)
      hg18.knownToU95.name (via bioCycPathway.kgID)
      hg18.knownToVisiGene.name (via bioCycPathway.kgID)
      hg18.mmBlastTab.query (via bioCycPathway.kgID)
      hg18.rnBlastTab.query (via bioCycPathway.kgID)
      hg18.scBlastTab.query (via bioCycPathway.kgID)
      hg18.ucscScop.ucscId (via bioCycPathway.kgID)
      knownGeneV39.bioCycPathway.kgID (via bioCycPathway.kgID)
      knownGeneV39.ceBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.dmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.drBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.foldUtr3.name (via bioCycPathway.kgID)
      knownGeneV39.foldUtr5.name (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      knownGeneV39.kgAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgColor.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgProtAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgSpAlias.kgID (via bioCycPathway.kgID)
      knownGeneV39.kgTargetAli.qName (via bioCycPathway.kgID)
      knownGeneV39.kgXref.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownAttrs.kgID (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.knownBlastTab.target (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.protein (via bioCycPathway.kgID)
      knownGeneV39.knownCanonical.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownCds.name (via bioCycPathway.kgID)
      knownGeneV39.knownGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownGeneMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownGenePep.name (via bioCycPathway.kgID)
      knownGeneV39.knownIsoforms.transcript (via bioCycPathway.kgID)
      knownGeneV39.knownToEnsembl.name (via bioCycPathway.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      knownGeneV39.knownToHprd.name (via bioCycPathway.kgID)
      knownGeneV39.knownToLocusLink.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrna.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMrnaSingle.name (via bioCycPathway.kgID)
      knownGeneV39.knownToMupit.name (via bioCycPathway.kgID)
      knownGeneV39.knownToPfam.name (via bioCycPathway.kgID)
      knownGeneV39.knownToRefSeq.name (via bioCycPathway.kgID)
      knownGeneV39.knownToSuper.gene (via bioCycPathway.kgID)
      knownGeneV39.knownToTag.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU133.name (via bioCycPathway.kgID)
      knownGeneV39.knownToU95.name (via bioCycPathway.kgID)
      knownGeneV39.knownToVisiGene.name (via bioCycPathway.kgID)
      knownGeneV39.knownToWikipedia.name (via bioCycPathway.kgID)
      knownGeneV39.mmBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.rnBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.scBlastTab.query (via bioCycPathway.kgID)
      knownGeneV39.ucscScop.ucscId (via bioCycPathway.kgID)
      hg18.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
uc002tzo.1UPP2RIB-DRIBMET-PWY
uc004fkg.1TKTL1RIB-DRIBMET-PWY
uc003iqp.2TKTL2RIB-DRIBMET-PWY
uc003dgq.1TKTRIB-DRIBMET-PWY
uc003bmb.2TYMPRIB-DRIBMET-PWY
uc001rde.1DERARIB-DRIBMET-PWY
uc001bdk.1CDARIB-DRIBMET-PWY
uc001qur.1AICDARIB-DRIBMET-PWY
uc002rlo.1RBKSRIB-DRIBMET-PWY
uc002zij.1LSSPWY66-5

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