Skip to main content
Schema for kgColor
  Database: hg19    Primary Table: kgColor    Row Count: 503,369   Data last updated: 2025-09-29
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENST00000000233.10_4varchar(255) Known gene ID
r 12tinyint(3) unsigned Red component 0-255
g 109tinyint(3) unsigned Green component 0-255
b 173tinyint(3) unsigned Blue component 0-255

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (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.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.knownAttrs.kgID (via kgColor.kgID)
      hg19.knownBlastTab.query (via kgColor.kgID)
      hg19.knownBlastTab.target (via kgColor.kgID)
      hg19.knownCanonical.transcript (via kgColor.kgID)
      hg19.knownCds.name (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.knownToMrna.name (via kgColor.kgID)
      hg19.knownToMrnaSingle.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.knownToTag.name (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)
      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.kgColor.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)

Sample Rows
 
kgIDrgb
ENST00000000233.10_412109173
ENST00000000412.31212120
ENST00000000442.11_812109173
ENST00000001008.6_512109173
ENST00000001146.7_712109173
ENST00000002125.9_412109173
ENST00000002165.11_812109173
ENST00000002501.11_612109173
ENST00000002596.6_712109173
ENST00000002829.8_612109173

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