Schema for kgColor
  Database: hg19    Primary Table: kgColor    Row Count: 381,930   Data last updated: 2024-08-23
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENST00000000233.10_4varchar(255) values Known gene ID
r 12tinyint(3) unsigned range Red component 0-255
g 109tinyint(3) unsigned range Green component 0-255
b 173tinyint(3) unsigned range 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.knownCanonToDecipher.name (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.knownToDecipher.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_412109173
ENST00000001146.7_712109173
ENST00000002125.9_412109173
ENST00000002165.11_712109173
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.