Schema for kgColor
  Database: knownGeneV39    Primary Table: kgColor    Row Count: 265,891   Data last updated: 2022-01-17
On download server: MariaDB table dump directory
fieldexampleSQL type info
kgID ENST00000456328.2varchar(255) values
r 255tinyint(3) unsigned range
g 51tinyint(3) unsigned range
b 255tinyint(3) unsigned range

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via kgColor.kgID)
      hg16.dmBlastTab.query (via kgColor.kgID)
      hg16.drBlastTab.query (via kgColor.kgID)
      hg16.dupSpMrna.mrnaID (via kgColor.kgID)
      hg16.foldUtr3.name (via kgColor.kgID)
      hg16.foldUtr5.name (via kgColor.kgID)
      hg16.gnfAtlas2Distance.query (via kgColor.kgID)
      hg16.gnfAtlas2Distance.target (via kgColor.kgID)
      hg16.gnfU95Distance.query (via kgColor.kgID)
      hg16.gnfU95Distance.target (via kgColor.kgID)
      hg16.hg17Kg.name (via kgColor.kgID)
      hg16.keggPathway.kgID (via kgColor.kgID)
      hg16.kgAlias.kgID (via kgColor.kgID)
      hg16.kgProtAlias.kgID (via kgColor.kgID)
      hg16.kgXref.kgID (via kgColor.kgID)
      hg16.knownBlastTab.query (via kgColor.kgID)
      hg16.knownBlastTab.target (via kgColor.kgID)
      hg16.knownCanonical.transcript (via kgColor.kgID)
      hg16.knownGene.name (via kgColor.kgID)
      hg16.knownGeneLink.name (via kgColor.kgID)
      hg16.knownGeneMrna.name (via kgColor.kgID)
      hg16.knownGenePep.name (via kgColor.kgID)
      hg16.knownIsoforms.transcript (via kgColor.kgID)
      hg16.knownToEnsembl.name (via kgColor.kgID)
      hg16.knownToGnfAtlas2.name (via kgColor.kgID)
      hg16.knownToHInv.name (via kgColor.kgID)
      hg16.knownToLocusLink.name (via kgColor.kgID)
      hg16.knownToPfam.name (via kgColor.kgID)
      hg16.knownToRefSeq.name (via kgColor.kgID)
      hg16.knownToSuper.gene (via kgColor.kgID)
      hg16.knownToU133.name (via kgColor.kgID)
      hg16.knownToU95.name (via kgColor.kgID)
      hg16.scBlastTab.query (via kgColor.kgID)
      hg17.bioCycPathway.kgID (via kgColor.kgID)
      hg17.ccdsKgMap.geneId (via kgColor.kgID)
      hg17.ceBlastTab.query (via kgColor.kgID)
      hg17.dmBlastTab.query (via kgColor.kgID)
      hg17.drBlastTab.query (via kgColor.kgID)
      hg17.dupSpMrna.mrnaID (via kgColor.kgID)
      hg17.foldUtr3.name (via kgColor.kgID)
      hg17.foldUtr5.name (via kgColor.kgID)
      hg17.gladHumESDistance.query (via kgColor.kgID)
      hg17.gladHumESDistance.target (via kgColor.kgID)
      hg17.gnfAtlas2Distance.query (via kgColor.kgID)
      hg17.gnfAtlas2Distance.target (via kgColor.kgID)
      hg17.gnfU95Distance.query (via kgColor.kgID)
      hg17.gnfU95Distance.target (via kgColor.kgID)
      hg17.humanHprdP2P.query (via kgColor.kgID)
      hg17.humanHprdP2P.target (via kgColor.kgID)
      hg17.humanVidalP2P.query (via kgColor.kgID)
      hg17.humanVidalP2P.target (via kgColor.kgID)
      hg17.humanWankerP2P.query (via kgColor.kgID)
      hg17.humanWankerP2P.target (via kgColor.kgID)
      hg17.keggPathway.kgID (via kgColor.kgID)
      hg17.kgAlias.kgID (via kgColor.kgID)
      hg17.kgProtAlias.kgID (via kgColor.kgID)
      hg17.kgSpAlias.kgID (via kgColor.kgID)
      hg17.kgTargetAli.qName (via kgColor.kgID)
      hg17.kgXref.kgID (via kgColor.kgID)
      hg17.knownBlastTab.query (via kgColor.kgID)
      hg17.knownBlastTab.target (via kgColor.kgID)
      hg17.knownCanonical.transcript (via kgColor.kgID)
      hg17.knownExpDistance.query (via kgColor.kgID)
      hg17.knownExpDistance.target (via kgColor.kgID)
      hg17.knownGene.name (via kgColor.kgID)
      hg17.knownGeneLink.name (via kgColor.kgID)
      hg17.knownGeneMrna.name (via kgColor.kgID)
      hg17.knownGenePep.name (via kgColor.kgID)
      hg17.knownIsoforms.transcript (via kgColor.kgID)
      hg17.knownToAllenBrain.name (via kgColor.kgID)
      hg17.knownToEnsembl.name (via kgColor.kgID)
      hg17.knownToGnf1h.name (via kgColor.kgID)
      hg17.knownToGnfAtlas2.name (via kgColor.kgID)
      hg17.knownToHInv.name (via kgColor.kgID)
      hg17.knownToHprd.name (via kgColor.kgID)
      hg17.knownToKeggEntrez.name (via kgColor.kgID)
      hg17.knownToLocusLink.name (via kgColor.kgID)
      hg17.knownToPfam.name (via kgColor.kgID)
      hg17.knownToRefSeq.name (via kgColor.kgID)
      hg17.knownToSuper.gene (via kgColor.kgID)
      hg17.knownToU133.name (via kgColor.kgID)
      hg17.knownToU133Plus2.name (via kgColor.kgID)
      hg17.knownToU95.name (via kgColor.kgID)
      hg17.knownToVisiGene.name (via kgColor.kgID)
      hg17.mmBlastTab.query (via kgColor.kgID)
      hg17.rankProp.query (via kgColor.kgID)
      hg17.rankProp.target (via kgColor.kgID)
      hg17.rnBlastTab.query (via kgColor.kgID)
      hg17.scBlastTab.query (via kgColor.kgID)
      hg18.bioCycPathway.kgID (via kgColor.kgID)
      hg18.ccdsKgMap.geneId (via kgColor.kgID)
      hg18.ceBlastTab.query (via kgColor.kgID)
      hg18.dmBlastTab.query (via kgColor.kgID)
      hg18.drBlastTab.query (via kgColor.kgID)
      hg18.foldUtr3.name (via kgColor.kgID)
      hg18.foldUtr5.name (via kgColor.kgID)
      hg18.gnfAtlas2Distance.query (via kgColor.kgID)
      hg18.gnfAtlas2Distance.target (via kgColor.kgID)
      hg18.gnfU95Distance.query (via kgColor.kgID)
      hg18.gnfU95Distance.target (via kgColor.kgID)
      hg18.humanHprdP2P.query (via kgColor.kgID)
      hg18.humanHprdP2P.target (via kgColor.kgID)
      hg18.humanVidalP2P.query (via kgColor.kgID)
      hg18.humanVidalP2P.target (via kgColor.kgID)
      hg18.humanWankerP2P.query (via kgColor.kgID)
      hg18.humanWankerP2P.target (via kgColor.kgID)
      hg18.keggPathway.kgID (via kgColor.kgID)
      hg18.kgAlias.kgID (via kgColor.kgID)
      hg18.kgColor.kgID (via kgColor.kgID)
      hg18.kgProtAlias.kgID (via kgColor.kgID)
      hg18.kgProtMap2.qName (via kgColor.kgID)
      hg18.kgSpAlias.kgID (via kgColor.kgID)
      hg18.kgTargetAli.qName (via kgColor.kgID)
      hg18.kgTxInfo.name (via kgColor.kgID)
      hg18.kgXref.kgID (via kgColor.kgID)
      hg18.knownBlastTab.query (via kgColor.kgID)
      hg18.knownBlastTab.target (via kgColor.kgID)
      hg18.knownCanonical.protein (via kgColor.kgID)
      hg18.knownCanonical.transcript (via kgColor.kgID)
      hg18.knownGene.name (via kgColor.kgID)
      hg18.knownGeneMrna.name (via kgColor.kgID)
      hg18.knownGenePep.name (via kgColor.kgID)
      hg18.knownIsoforms.transcript (via kgColor.kgID)
      hg18.knownToAllenBrain.name (via kgColor.kgID)
      hg18.knownToEnsembl.name (via kgColor.kgID)
      hg18.knownToGnf1h.name (via kgColor.kgID)
      hg18.knownToGnfAtlas2.name (via kgColor.kgID)
      hg18.knownToHInv.name (via kgColor.kgID)
      hg18.knownToHprd.name (via kgColor.kgID)
      hg18.knownToKeggEntrez.name (via kgColor.kgID)
      hg18.knownToLocusLink.name (via kgColor.kgID)
      hg18.knownToMupit.name (via kgColor.kgID)
      hg18.knownToPfam.name (via kgColor.kgID)
      hg18.knownToRefSeq.name (via kgColor.kgID)
      hg18.knownToSuper.gene (via kgColor.kgID)
      hg18.knownToTreefam.name (via kgColor.kgID)
      hg18.knownToU133.name (via kgColor.kgID)
      hg18.knownToU133Plus2.name (via kgColor.kgID)
      hg18.knownToU95.name (via kgColor.kgID)
      hg18.knownToVisiGene.name (via kgColor.kgID)
      hg18.mmBlastTab.query (via kgColor.kgID)
      hg18.rnBlastTab.query (via kgColor.kgID)
      hg18.scBlastTab.query (via kgColor.kgID)
      hg18.ucscScop.ucscId (via kgColor.kgID)
      hg19.bioCycPathway.kgID (via kgColor.kgID)
      hg19.ccdsKgMap.geneId (via kgColor.kgID)
      hg19.ceBlastTab.query (via kgColor.kgID)
      hg19.dmBlastTab.query (via kgColor.kgID)
      hg19.drBlastTab.query (via kgColor.kgID)
      hg19.foldUtr3.name (via kgColor.kgID)
      hg19.foldUtr5.name (via kgColor.kgID)
      hg19.gnfAtlas2Distance.query (via kgColor.kgID)
      hg19.gnfAtlas2Distance.target (via kgColor.kgID)
      hg19.gnfU95Distance.query (via kgColor.kgID)
      hg19.gnfU95Distance.target (via kgColor.kgID)
      hg19.humanHprdP2P.query (via kgColor.kgID)
      hg19.humanHprdP2P.target (via kgColor.kgID)
      hg19.humanVidalP2P.query (via kgColor.kgID)
      hg19.humanVidalP2P.target (via kgColor.kgID)
      hg19.humanWankerP2P.query (via kgColor.kgID)
      hg19.humanWankerP2P.target (via kgColor.kgID)
      hg19.keggPathway.kgID (via kgColor.kgID)
      hg19.kgAlias.kgID (via kgColor.kgID)
      hg19.kgColor.kgID (via kgColor.kgID)
      hg19.kgProtAlias.kgID (via kgColor.kgID)
      hg19.kgProtMap2.qName (via kgColor.kgID)
      hg19.kgSpAlias.kgID (via kgColor.kgID)
      hg19.kgTargetAli.qName (via kgColor.kgID)
      hg19.kgTxInfo.name (via kgColor.kgID)
      hg19.kgXref.kgID (via kgColor.kgID)
      hg19.knownBlastTab.query (via kgColor.kgID)
      hg19.knownBlastTab.target (via kgColor.kgID)
      hg19.knownCanonical.transcript (via kgColor.kgID)
      hg19.knownGene.name (via kgColor.kgID)
      hg19.knownGeneMrna.name (via kgColor.kgID)
      hg19.knownGenePep.name (via kgColor.kgID)
      hg19.knownGeneTxMrna.name (via kgColor.kgID)
      hg19.knownGeneTxPep.name (via kgColor.kgID)
      hg19.knownIsoforms.transcript (via kgColor.kgID)
      hg19.knownToAllenBrain.name (via kgColor.kgID)
      hg19.knownToEnsembl.name (via kgColor.kgID)
      hg19.knownToGnfAtlas2.name (via kgColor.kgID)
      hg19.knownToHInv.name (via kgColor.kgID)
      hg19.knownToHprd.name (via kgColor.kgID)
      hg19.knownToKeggEntrez.name (via kgColor.kgID)
      hg19.knownToLocusLink.name (via kgColor.kgID)
      hg19.knownToLynx.name (via kgColor.kgID)
      hg19.knownToMupit.name (via kgColor.kgID)
      hg19.knownToNextProt.name (via kgColor.kgID)
      hg19.knownToPfam.name (via kgColor.kgID)
      hg19.knownToRefSeq.name (via kgColor.kgID)
      hg19.knownToSuper.gene (via kgColor.kgID)
      hg19.knownToTreefam.name (via kgColor.kgID)
      hg19.knownToU133.name (via kgColor.kgID)
      hg19.knownToU133Plus2.name (via kgColor.kgID)
      hg19.knownToU95.name (via kgColor.kgID)
      hg19.knownToVisiGene.name (via kgColor.kgID)
      hg19.knownToWikipedia.name (via kgColor.kgID)
      hg19.mmBlastTab.query (via kgColor.kgID)
      hg19.rnBlastTab.query (via kgColor.kgID)
      hg19.scBlastTab.query (via kgColor.kgID)
      hg19.ucscScop.ucscId (via kgColor.kgID)
      hg38.bioCycPathway.kgID (via kgColor.kgID)
      hg38.ccdsKgMap.geneId (via kgColor.kgID)
      hg38.ceBlastTab.query (via kgColor.kgID)
      hg38.dmBlastTab.query (via kgColor.kgID)
      hg38.drBlastTab.query (via kgColor.kgID)
      hg38.foldUtr3.name (via kgColor.kgID)
      hg38.foldUtr5.name (via kgColor.kgID)
      hg38.gnfAtlas2Distance.query (via kgColor.kgID)
      hg38.gnfAtlas2Distance.target (via kgColor.kgID)
      hg38.gnfU95Distance.query (via kgColor.kgID)
      hg38.gnfU95Distance.target (via kgColor.kgID)
      hg38.humanHprdP2P.query (via kgColor.kgID)
      hg38.humanHprdP2P.target (via kgColor.kgID)
      hg38.humanVidalP2P.query (via kgColor.kgID)
      hg38.humanVidalP2P.target (via kgColor.kgID)
      hg38.humanWankerP2P.query (via kgColor.kgID)
      hg38.humanWankerP2P.target (via kgColor.kgID)
      hg38.keggPathway.kgID (via kgColor.kgID)
      hg38.kgAlias.kgID (via kgColor.kgID)
      hg38.kgColor.kgID (via kgColor.kgID)
      hg38.kgProtAlias.kgID (via kgColor.kgID)
      hg38.kgSpAlias.kgID (via kgColor.kgID)
      hg38.kgTargetAli.qName (via kgColor.kgID)
      hg38.kgXref.kgID (via kgColor.kgID)
      hg38.knownAttrs.kgID (via kgColor.kgID)
      hg38.knownBlastTab.query (via kgColor.kgID)
      hg38.knownBlastTab.target (via kgColor.kgID)
      hg38.knownCanonical.transcript (via kgColor.kgID)
      hg38.knownCds.name (via kgColor.kgID)
      hg38.knownGene.name (via kgColor.kgID)
      hg38.knownGeneMrna.name (via kgColor.kgID)
      hg38.knownGenePep.name (via kgColor.kgID)
      hg38.knownIsoforms.transcript (via kgColor.kgID)
      hg38.knownToEnsembl.name (via kgColor.kgID)
      hg38.knownToGnfAtlas2.name (via kgColor.kgID)
      hg38.knownToHprd.name (via kgColor.kgID)
      hg38.knownToKeggEntrez.name (via kgColor.kgID)
      hg38.knownToLocusLink.name (via kgColor.kgID)
      hg38.knownToLynx.name (via kgColor.kgID)
      hg38.knownToMrna.name (via kgColor.kgID)
      hg38.knownToMrnaSingle.name (via kgColor.kgID)
      hg38.knownToMupit.name (via kgColor.kgID)
      hg38.knownToNextProt.name (via kgColor.kgID)
      hg38.knownToPfam.name (via kgColor.kgID)
      hg38.knownToRefSeq.name (via kgColor.kgID)
      hg38.knownToSuper.gene (via kgColor.kgID)
      hg38.knownToTag.name (via kgColor.kgID)
      hg38.knownToU133.name (via kgColor.kgID)
      hg38.knownToU95.name (via kgColor.kgID)
      hg38.knownToVisiGene.name (via kgColor.kgID)
      hg38.knownToWikipedia.name (via kgColor.kgID)
      hg38.mmBlastTab.query (via kgColor.kgID)
      hg38.rnBlastTab.query (via kgColor.kgID)
      hg38.scBlastTab.query (via kgColor.kgID)
      hg38.ucscScop.ucscId (via kgColor.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgColor.kgID)
      knownGeneV39.ceBlastTab.query (via kgColor.kgID)
      knownGeneV39.dmBlastTab.query (via kgColor.kgID)
      knownGeneV39.drBlastTab.query (via kgColor.kgID)
      knownGeneV39.foldUtr3.name (via kgColor.kgID)
      knownGeneV39.foldUtr5.name (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgColor.kgID)
      knownGeneV39.kgAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgTargetAli.qName (via kgColor.kgID)
      knownGeneV39.kgXref.kgID (via kgColor.kgID)
      knownGeneV39.knownAttrs.kgID (via kgColor.kgID)
      knownGeneV39.knownBlastTab.query (via kgColor.kgID)
      knownGeneV39.knownBlastTab.target (via kgColor.kgID)
      knownGeneV39.knownCanonical.protein (via kgColor.kgID)
      knownGeneV39.knownCanonical.transcript (via kgColor.kgID)
      knownGeneV39.knownCds.name (via kgColor.kgID)
      knownGeneV39.knownGene.name (via kgColor.kgID)
      knownGeneV39.knownGeneMrna.name (via kgColor.kgID)
      knownGeneV39.knownGenePep.name (via kgColor.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgColor.kgID)
      knownGeneV39.knownToEnsembl.name (via kgColor.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgColor.kgID)
      knownGeneV39.knownToHprd.name (via kgColor.kgID)
      knownGeneV39.knownToLocusLink.name (via kgColor.kgID)
      knownGeneV39.knownToMrna.name (via kgColor.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgColor.kgID)
      knownGeneV39.knownToMupit.name (via kgColor.kgID)
      knownGeneV39.knownToPfam.name (via kgColor.kgID)
      knownGeneV39.knownToRefSeq.name (via kgColor.kgID)
      knownGeneV39.knownToSuper.gene (via kgColor.kgID)
      knownGeneV39.knownToTag.name (via kgColor.kgID)
      knownGeneV39.knownToU133.name (via kgColor.kgID)
      knownGeneV39.knownToU95.name (via kgColor.kgID)
      knownGeneV39.knownToVisiGene.name (via kgColor.kgID)
      knownGeneV39.knownToWikipedia.name (via kgColor.kgID)
      knownGeneV39.mmBlastTab.query (via kgColor.kgID)
      knownGeneV39.rnBlastTab.query (via kgColor.kgID)
      knownGeneV39.scBlastTab.query (via kgColor.kgID)
      knownGeneV39.ucscScop.ucscId (via kgColor.kgID)
      mm10.bioCycPathway.kgID (via kgColor.kgID)
      mm10.ccdsKgMap.geneId (via kgColor.kgID)
      mm10.ceBlastTab.query (via kgColor.kgID)
      mm10.dmBlastTab.query (via kgColor.kgID)
      mm10.drBlastTab.query (via kgColor.kgID)
      mm10.foldUtr3.name (via kgColor.kgID)
      mm10.foldUtr5.name (via kgColor.kgID)
      mm10.hgBlastTab.query (via kgColor.kgID)
      mm10.keggPathway.kgID (via kgColor.kgID)
      mm10.kgAlias.kgID (via kgColor.kgID)
      mm10.kgColor.kgID (via kgColor.kgID)
      mm10.kgProtAlias.kgID (via kgColor.kgID)
      mm10.kgProtMap2.qName (via kgColor.kgID)
      mm10.kgSpAlias.kgID (via kgColor.kgID)
      mm10.kgTargetAli.qName (via kgColor.kgID)
      mm10.kgTxInfo.name (via kgColor.kgID)
      mm10.kgXref.kgID (via kgColor.kgID)
      mm10.knownAttrs.kgID (via kgColor.kgID)
      mm10.knownBlastTab.query (via kgColor.kgID)
      mm10.knownBlastTab.target (via kgColor.kgID)
      mm10.knownCanonical.transcript (via kgColor.kgID)
      mm10.knownCds.name (via kgColor.kgID)
      mm10.knownGene.name (via kgColor.kgID)
      mm10.knownGeneMrna.name (via kgColor.kgID)
      mm10.knownGenePep.name (via kgColor.kgID)
      mm10.knownIsoforms.transcript (via kgColor.kgID)
      mm10.knownToEnsembl.name (via kgColor.kgID)
      mm10.knownToKeggEntrez.name (via kgColor.kgID)
      mm10.knownToLocusLink.name (via kgColor.kgID)
      mm10.knownToLynx.name (via kgColor.kgID)
      mm10.knownToMrna.name (via kgColor.kgID)
      mm10.knownToMrnaSingle.name (via kgColor.kgID)
      mm10.knownToPfam.name (via kgColor.kgID)
      mm10.knownToRefSeq.name (via kgColor.kgID)
      mm10.knownToSuper.gene (via kgColor.kgID)
      mm10.knownToTag.name (via kgColor.kgID)
      mm10.knownToVisiGene.name (via kgColor.kgID)
      mm10.knownToWikipedia.name (via kgColor.kgID)
      mm10.rnBlastTab.query (via kgColor.kgID)
      mm10.scBlastTab.query (via kgColor.kgID)
      mm10.ucscScop.ucscId (via kgColor.kgID)
      mm39.bioCycPathway.kgID (via kgColor.kgID)
      mm39.ceBlastTab.query (via kgColor.kgID)
      mm39.dmBlastTab.query (via kgColor.kgID)
      mm39.drBlastTab.query (via kgColor.kgID)
      mm39.foldUtr3.name (via kgColor.kgID)
      mm39.foldUtr5.name (via kgColor.kgID)
      mm39.hgBlastTab.query (via kgColor.kgID)
      mm39.kgAlias.kgID (via kgColor.kgID)
      mm39.kgColor.kgID (via kgColor.kgID)
      mm39.kgProtAlias.kgID (via kgColor.kgID)
      mm39.kgSpAlias.kgID (via kgColor.kgID)
      mm39.kgTargetAli.qName (via kgColor.kgID)
      mm39.kgXref.kgID (via kgColor.kgID)
      mm39.knownAttrs.kgID (via kgColor.kgID)
      mm39.knownBlastTab.query (via kgColor.kgID)
      mm39.knownBlastTab.target (via kgColor.kgID)
      mm39.knownCanonical.transcript (via kgColor.kgID)
      mm39.knownCds.name (via kgColor.kgID)
      mm39.knownGene.name (via kgColor.kgID)
      mm39.knownGeneMrna.name (via kgColor.kgID)
      mm39.knownIsoforms.transcript (via kgColor.kgID)
      mm39.knownToEnsembl.name (via kgColor.kgID)
      mm39.knownToLocusLink.name (via kgColor.kgID)
      mm39.knownToMrna.name (via kgColor.kgID)
      mm39.knownToMrnaSingle.name (via kgColor.kgID)
      mm39.knownToMupit.name (via kgColor.kgID)
      mm39.knownToNextProt.name (via kgColor.kgID)
      mm39.knownToPfam.name (via kgColor.kgID)
      mm39.knownToRefSeq.name (via kgColor.kgID)
      mm39.knownToSuper.gene (via kgColor.kgID)
      mm39.knownToTag.name (via kgColor.kgID)
      mm39.knownToVisiGene.name (via kgColor.kgID)
      mm39.knownToWikipedia.name (via kgColor.kgID)
      mm39.rnBlastTab.query (via kgColor.kgID)
      mm39.scBlastTab.query (via kgColor.kgID)
      mm39.ucscScop.ucscId (via kgColor.kgID)
      mm7.affyGnfU74ADistance.query (via kgColor.kgID)
      mm7.affyGnfU74ADistance.target (via kgColor.kgID)
      mm7.affyGnfU74BDistance.query (via kgColor.kgID)
      mm7.affyGnfU74BDistance.target (via kgColor.kgID)
      mm7.affyGnfU74CDistance.query (via kgColor.kgID)
      mm7.affyGnfU74CDistance.target (via kgColor.kgID)
      mm7.dmBlastTab.query (via kgColor.kgID)
      mm7.drBlastTab.query (via kgColor.kgID)
      mm7.dupSpMrna.mrnaID (via kgColor.kgID)
      mm7.foldUtr3.name (via kgColor.kgID)
      mm7.foldUtr5.name (via kgColor.kgID)
      mm7.gnfAtlas2Distance.query (via kgColor.kgID)
      mm7.gnfAtlas2Distance.target (via kgColor.kgID)
      mm7.hgBlastTab.query (via kgColor.kgID)
      mm7.keggPathway.kgID (via kgColor.kgID)
      mm7.kgAlias.kgID (via kgColor.kgID)
      mm7.kgProtAlias.kgID (via kgColor.kgID)
      mm7.kgSpAlias.kgID (via kgColor.kgID)
      mm7.kgXref.kgID (via kgColor.kgID)
      mm7.knownBlastTab.query (via kgColor.kgID)
      mm7.knownBlastTab.target (via kgColor.kgID)
      mm7.knownCanonical.transcript (via kgColor.kgID)
      mm7.knownGene.name (via kgColor.kgID)
      mm7.knownGeneLink.name (via kgColor.kgID)
      mm7.knownGeneMrna.name (via kgColor.kgID)
      mm7.knownGenePep.name (via kgColor.kgID)
      mm7.knownIsoforms.transcript (via kgColor.kgID)
      mm7.knownToAllenBrain.name (via kgColor.kgID)
      mm7.knownToEnsembl.name (via kgColor.kgID)
      mm7.knownToGnfAtlas2.name (via kgColor.kgID)
      mm7.knownToKeggEntrez.name (via kgColor.kgID)
      mm7.knownToLocusLink.name (via kgColor.kgID)
      mm7.knownToPfam.name (via kgColor.kgID)
      mm7.knownToRefSeq.name (via kgColor.kgID)
      mm7.knownToVisiGene.name (via kgColor.kgID)
      mm7.rnBlastTab.query (via kgColor.kgID)
      mm7.scBlastTab.query (via kgColor.kgID)
      mm8.affyGnfU74ADistance.query (via kgColor.kgID)
      mm8.affyGnfU74ADistance.target (via kgColor.kgID)
      mm8.affyGnfU74BDistance.query (via kgColor.kgID)
      mm8.affyGnfU74BDistance.target (via kgColor.kgID)
      mm8.affyGnfU74CDistance.query (via kgColor.kgID)
      mm8.affyGnfU74CDistance.target (via kgColor.kgID)
      mm8.ccdsKgMap.geneId (via kgColor.kgID)
      mm8.ceBlastTab.query (via kgColor.kgID)
      mm8.dmBlastTab.query (via kgColor.kgID)
      mm8.drBlastTab.query (via kgColor.kgID)
      mm8.dupSpMrna.mrnaID (via kgColor.kgID)
      mm8.foldUtr3.name (via kgColor.kgID)
      mm8.foldUtr5.name (via kgColor.kgID)
      mm8.gnfAtlas2Distance.query (via kgColor.kgID)
      mm8.gnfAtlas2Distance.target (via kgColor.kgID)
      mm8.hgBlastTab.query (via kgColor.kgID)
      mm8.keggPathway.kgID (via kgColor.kgID)
      mm8.kgAlias.kgID (via kgColor.kgID)
      mm8.kgProtAlias.kgID (via kgColor.kgID)
      mm8.kgSpAlias.kgID (via kgColor.kgID)
      mm8.kgTargetAli.qName (via kgColor.kgID)
      mm8.kgXref.kgID (via kgColor.kgID)
      mm8.knownBlastTab.query (via kgColor.kgID)
      mm8.knownBlastTab.target (via kgColor.kgID)
      mm8.knownCanonical.transcript (via kgColor.kgID)
      mm8.knownGene.name (via kgColor.kgID)
      mm8.knownGeneMrna.name (via kgColor.kgID)
      mm8.knownGenePep.name (via kgColor.kgID)
      mm8.knownIsoforms.transcript (via kgColor.kgID)
      mm8.knownToAllenBrain.name (via kgColor.kgID)
      mm8.knownToEnsembl.name (via kgColor.kgID)
      mm8.knownToGnfAtlas2.name (via kgColor.kgID)
      mm8.knownToKeggEntrez.name (via kgColor.kgID)
      mm8.knownToLocusLink.name (via kgColor.kgID)
      mm8.knownToPfam.name (via kgColor.kgID)
      mm8.knownToRefSeq.name (via kgColor.kgID)
      mm8.knownToSuper.gene (via kgColor.kgID)
      mm8.knownToVisiGene.name (via kgColor.kgID)
      mm8.rnBlastTab.query (via kgColor.kgID)
      mm8.scBlastTab.query (via kgColor.kgID)
      mm9.affyGnfU74ADistance.query (via kgColor.kgID)
      mm9.affyGnfU74ADistance.target (via kgColor.kgID)
      mm9.affyGnfU74BDistance.query (via kgColor.kgID)
      mm9.affyGnfU74BDistance.target (via kgColor.kgID)
      mm9.affyGnfU74CDistance.query (via kgColor.kgID)
      mm9.affyGnfU74CDistance.target (via kgColor.kgID)
      mm9.bioCycPathway.kgID (via kgColor.kgID)
      mm9.ccdsKgMap.geneId (via kgColor.kgID)
      mm9.ceBlastTab.query (via kgColor.kgID)
      mm9.dmBlastTab.query (via kgColor.kgID)
      mm9.drBlastTab.query (via kgColor.kgID)
      mm9.foldUtr3.name (via kgColor.kgID)
      mm9.foldUtr5.name (via kgColor.kgID)
      mm9.gnfAtlas2Distance.query (via kgColor.kgID)
      mm9.gnfAtlas2Distance.target (via kgColor.kgID)
      mm9.hgBlastTab.query (via kgColor.kgID)
      mm9.keggPathway.kgID (via kgColor.kgID)
      mm9.kgAlias.kgID (via kgColor.kgID)
      mm9.kgColor.kgID (via kgColor.kgID)
      mm9.kgProtAlias.kgID (via kgColor.kgID)
      mm9.kgProtMap2.qName (via kgColor.kgID)
      mm9.kgSpAlias.kgID (via kgColor.kgID)
      mm9.kgTargetAli.qName (via kgColor.kgID)
      mm9.kgTxInfo.name (via kgColor.kgID)
      mm9.kgXref.kgID (via kgColor.kgID)
      mm9.knownBlastTab.query (via kgColor.kgID)
      mm9.knownBlastTab.target (via kgColor.kgID)
      mm9.knownCanonical.protein (via kgColor.kgID)
      mm9.knownCanonical.transcript (via kgColor.kgID)
      mm9.knownGene.name (via kgColor.kgID)
      mm9.knownGeneMrna.name (via kgColor.kgID)
      mm9.knownGenePep.name (via kgColor.kgID)
      mm9.knownIsoforms.transcript (via kgColor.kgID)
      mm9.knownToAllenBrain.name (via kgColor.kgID)
      mm9.knownToEnsembl.name (via kgColor.kgID)
      mm9.knownToGnfAtlas2.name (via kgColor.kgID)
      mm9.knownToKeggEntrez.name (via kgColor.kgID)
      mm9.knownToLocusLink.name (via kgColor.kgID)
      mm9.knownToPfam.name (via kgColor.kgID)
      mm9.knownToRefSeq.name (via kgColor.kgID)
      mm9.knownToSuper.gene (via kgColor.kgID)
      mm9.knownToVisiGene.name (via kgColor.kgID)
      mm9.rnBlastTab.query (via kgColor.kgID)
      mm9.scBlastTab.query (via kgColor.kgID)
      mm9.ucscScop.ucscId (via kgColor.kgID)
      rn3.dmBlastTab.query (via kgColor.kgID)
      rn3.drBlastTab.query (via kgColor.kgID)
      rn3.dupSpMrna.mrnaID (via kgColor.kgID)
      rn3.gnfAtlas2Distance.query (via kgColor.kgID)
      rn3.gnfAtlas2Distance.target (via kgColor.kgID)
      rn3.hgBlastTab.query (via kgColor.kgID)
      rn3.keggPathway.kgID (via kgColor.kgID)
      rn3.kgAlias.kgID (via kgColor.kgID)
      rn3.kgProtAlias.kgID (via kgColor.kgID)
      rn3.kgSpAlias.kgID (via kgColor.kgID)
      rn3.kgXref.kgID (via kgColor.kgID)
      rn3.knownBlastTab.query (via kgColor.kgID)
      rn3.knownBlastTab.target (via kgColor.kgID)
      rn3.knownCanonical.transcript (via kgColor.kgID)
      rn3.knownGene.name (via kgColor.kgID)
      rn3.knownGeneLink.name (via kgColor.kgID)
      rn3.knownGeneMrna.name (via kgColor.kgID)
      rn3.knownGenePep.name (via kgColor.kgID)
      rn3.knownIsoforms.transcript (via kgColor.kgID)
      rn3.knownToEnsembl.name (via kgColor.kgID)
      rn3.knownToGnfAtlas2.name (via kgColor.kgID)
      rn3.knownToLocusLink.name (via kgColor.kgID)
      rn3.knownToPfam.name (via kgColor.kgID)
      rn3.knownToRefSeq.name (via kgColor.kgID)
      rn3.knownToSuper.gene (via kgColor.kgID)
      rn3.scBlastTab.query (via kgColor.kgID)

Sample Rows
 
kgIDrgb
ENST00000456328.225551255
ENST00000450305.225551255
ENST00000488147.125551255
ENST00000619216.101000
ENST00000473358.101000
ENST00000469289.101000
ENST00000607096.101000
ENST00000417324.101000
ENST00000461467.101000
ENST00000606857.125551255

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