Schema for bioCycPathway
  Database: mm9    Primary Table: bioCycPathway    Row Count: 2,211   Data last updated: 2011-05-10
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc012bmb.1varchar(40) values Known Gene ID
geneID Got1varchar(40) values Gene (RefSeq) ID
mapID ASPASN-PWYvarchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        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)
      mm9.affyGnfU74ADistance.query (via bioCycPathway.kgID)
      mm9.affyGnfU74ADistance.target (via bioCycPathway.kgID)
      mm9.affyGnfU74BDistance.query (via bioCycPathway.kgID)
      mm9.affyGnfU74BDistance.target (via bioCycPathway.kgID)
      mm9.affyGnfU74CDistance.query (via bioCycPathway.kgID)
      mm9.affyGnfU74CDistance.target (via bioCycPathway.kgID)
      mm9.ccdsKgMap.geneId (via bioCycPathway.kgID)
      mm9.ceBlastTab.query (via bioCycPathway.kgID)
      mm9.dmBlastTab.query (via bioCycPathway.kgID)
      mm9.drBlastTab.query (via bioCycPathway.kgID)
      mm9.foldUtr3.name (via bioCycPathway.kgID)
      mm9.foldUtr5.name (via bioCycPathway.kgID)
      mm9.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      mm9.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      mm9.hgBlastTab.query (via bioCycPathway.kgID)
      mm9.keggPathway.kgID (via bioCycPathway.kgID)
      mm9.kgAlias.kgID (via bioCycPathway.kgID)
      mm9.kgColor.kgID (via bioCycPathway.kgID)
      mm9.kgProtAlias.kgID (via bioCycPathway.kgID)
      mm9.kgProtMap2.qName (via bioCycPathway.kgID)
      mm9.kgSpAlias.kgID (via bioCycPathway.kgID)
      mm9.kgTargetAli.qName (via bioCycPathway.kgID)
      mm9.kgTxInfo.name (via bioCycPathway.kgID)
      mm9.kgXref.kgID (via bioCycPathway.kgID)
      mm9.knownBlastTab.query (via bioCycPathway.kgID)
      mm9.knownBlastTab.target (via bioCycPathway.kgID)
      mm9.knownCanonical.protein (via bioCycPathway.kgID)
      mm9.knownCanonical.transcript (via bioCycPathway.kgID)
      mm9.knownGene.name (via bioCycPathway.kgID)
      mm9.knownGeneMrna.name (via bioCycPathway.kgID)
      mm9.knownGenePep.name (via bioCycPathway.kgID)
      mm9.knownIsoforms.transcript (via bioCycPathway.kgID)
      mm9.knownToAllenBrain.name (via bioCycPathway.kgID)
      mm9.knownToEnsembl.name (via bioCycPathway.kgID)
      mm9.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      mm9.knownToKeggEntrez.name (via bioCycPathway.kgID)
      mm9.knownToLocusLink.name (via bioCycPathway.kgID)
      mm9.knownToPfam.name (via bioCycPathway.kgID)
      mm9.knownToRefSeq.name (via bioCycPathway.kgID)
      mm9.knownToSuper.gene (via bioCycPathway.kgID)
      mm9.knownToVisiGene.name (via bioCycPathway.kgID)
      mm9.rnBlastTab.query (via bioCycPathway.kgID)
      mm9.scBlastTab.query (via bioCycPathway.kgID)
      mm9.ucscScop.ucscId (via bioCycPathway.kgID)
      mm9.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
uc012bmb.1Got1ASPASN-PWY
uc009mzi.1Got2ASPASN-PWY
uc009axf.1AsnsASPASN-PWY
uc007azg.1Asnsd1ASPASN-PWY
uc008gon.1Asrgl1ASPASN-PWY
uc009gwd.1Bcat2BRANCHED-CHAIN-AA-SYN-PWY
uc009eqs.2Bcat1BRANCHED-CHAIN-AA-SYN-PWY
uc008zth.2PsphSER-GLYSYN-PWY
uc008qps.1PhgdhSER-GLYSYN-PWY
uc008gwp.1Psat1SER-GLYSYN-PWY

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