Schema for bioCycPathway
  Database: hg38    Primary Table: bioCycPathway    Row Count: 2,727   Data last updated: 2022-05-15
Format description: BioCyc Pathway to Known Gene cross reference
fieldexampleSQL type info description
kgID ENST00000377855.6varchar(40) values Known Gene ID
geneID ACOT7varchar(40) values Gene (RefSeq) ID
mapID PWY-5148varchar(40) values BioCyc pathway map ID

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

Sample Rows
 
kgIDgeneIDmapID
ENST00000377855.6ACOT7PWY-5148
ENST00000336430.11ACOT9PWY-5148
ENST00000378228.8OLAHPWY-5148
ENST00000217455.9ACOT8PWY-5148
ENST00000269298.10SAT2PWY-6117
ENST00000379270.5SAT1PWY-6117
ENST00000305958.9SMOXPWY-6117
ENST00000308423.7AOC3PWY-6117
ENST00000278060.10PAOXPWY-6117
ENST00000697613.1PNPP121-PWY

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