Schema for bioCycPathway
  Database: hg19    Primary Table: bioCycPathway    Row Count: 2,176   Data last updated: 2013-06-18
Format description: BioCyc Pathway to Known Gene cross reference
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc002xjo.1varchar(40) values Known Gene ID
geneID PLCG1varchar(40) values Gene (RefSeq) ID
mapID LIPASYN-PWYvarchar(40) values BioCyc pathway map ID

Connected Tables and Joining Fields
        hg19.ccdsKgMap.geneId (via bioCycPathway.kgID)
      hg19.ceBlastTab.query (via bioCycPathway.kgID)
      hg19.dmBlastTab.query (via bioCycPathway.kgID)
      hg19.drBlastTab.query (via bioCycPathway.kgID)
      hg19.foldUtr3.name (via bioCycPathway.kgID)
      hg19.foldUtr5.name (via bioCycPathway.kgID)
      hg19.gnfAtlas2Distance.query (via bioCycPathway.kgID)
      hg19.gnfAtlas2Distance.target (via bioCycPathway.kgID)
      hg19.gnfU95Distance.query (via bioCycPathway.kgID)
      hg19.gnfU95Distance.target (via bioCycPathway.kgID)
      hg19.humanHprdP2P.query (via bioCycPathway.kgID)
      hg19.humanHprdP2P.target (via bioCycPathway.kgID)
      hg19.humanVidalP2P.query (via bioCycPathway.kgID)
      hg19.humanVidalP2P.target (via bioCycPathway.kgID)
      hg19.humanWankerP2P.query (via bioCycPathway.kgID)
      hg19.humanWankerP2P.target (via bioCycPathway.kgID)
      hg19.keggPathway.kgID (via bioCycPathway.kgID)
      hg19.kgAlias.kgID (via bioCycPathway.kgID)
      hg19.kgColor.kgID (via bioCycPathway.kgID)
      hg19.kgProtAlias.kgID (via bioCycPathway.kgID)
      hg19.kgProtMap2.qName (via bioCycPathway.kgID)
      hg19.kgSpAlias.kgID (via bioCycPathway.kgID)
      hg19.kgTargetAli.qName (via bioCycPathway.kgID)
      hg19.kgTxInfo.name (via bioCycPathway.kgID)
      hg19.kgXref.kgID (via bioCycPathway.kgID)
      hg19.knownBlastTab.query (via bioCycPathway.kgID)
      hg19.knownBlastTab.target (via bioCycPathway.kgID)
      hg19.knownCanonical.transcript (via bioCycPathway.kgID)
      hg19.knownGene.name (via bioCycPathway.kgID)
      hg19.knownGeneMrna.name (via bioCycPathway.kgID)
      hg19.knownGenePep.name (via bioCycPathway.kgID)
      hg19.knownGeneTxMrna.name (via bioCycPathway.kgID)
      hg19.knownGeneTxPep.name (via bioCycPathway.kgID)
      hg19.knownIsoforms.transcript (via bioCycPathway.kgID)
      hg19.knownToAllenBrain.name (via bioCycPathway.kgID)
      hg19.knownToEnsembl.name (via bioCycPathway.kgID)
      hg19.knownToGnfAtlas2.name (via bioCycPathway.kgID)
      hg19.knownToHInv.name (via bioCycPathway.kgID)
      hg19.knownToHprd.name (via bioCycPathway.kgID)
      hg19.knownToKeggEntrez.name (via bioCycPathway.kgID)
      hg19.knownToLocusLink.name (via bioCycPathway.kgID)
      hg19.knownToLynx.name (via bioCycPathway.kgID)
      hg19.knownToMupit.name (via bioCycPathway.kgID)
      hg19.knownToNextProt.name (via bioCycPathway.kgID)
      hg19.knownToPfam.name (via bioCycPathway.kgID)
      hg19.knownToRefSeq.name (via bioCycPathway.kgID)
      hg19.knownToSuper.gene (via bioCycPathway.kgID)
      hg19.knownToTreefam.name (via bioCycPathway.kgID)
      hg19.knownToU133.name (via bioCycPathway.kgID)
      hg19.knownToU133Plus2.name (via bioCycPathway.kgID)
      hg19.knownToU95.name (via bioCycPathway.kgID)
      hg19.knownToVisiGene.name (via bioCycPathway.kgID)
      hg19.knownToWikipedia.name (via bioCycPathway.kgID)
      hg19.mmBlastTab.query (via bioCycPathway.kgID)
      hg19.rnBlastTab.query (via bioCycPathway.kgID)
      hg19.scBlastTab.query (via bioCycPathway.kgID)
      hg19.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)
      hg19.bioCycMapDesc.mapID (via bioCycPathway.mapID)

Sample Rows
 
kgIDgeneIDmapID
uc002xjo.1PLCG1LIPASYN-PWY
uc001zld.3PLCB2LIPASYN-PWY
uc002wnb.4PLCB1LIPASYN-PWY
uc003chm.3PLCD1LIPASYN-PWY
uc001kjk.3PLCE1LIPASYN-PWY
uc009ypg.2PLCB3LIPASYN-PWY
uc021vwx.1PLCD4LIPASYN-PWY
uc001aji.1PLCH2LIPASYN-PWY
uc021xge.1PLCH1LIPASYN-PWY
uc002iib.3PLCD3LIPASYN-PWY

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