Schema for kgColor
  Database: hg38    Primary Table: kgColor    Row Count: 276,905   Data last updated: 2023-08-22
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENST00000000233.10varchar(255) values Known gene ID
r 12tinyint(3) unsigned range Red component 0-255
g 12tinyint(3) unsigned range Green component 0-255
b 120tinyint(3) unsigned range Blue component 0-255

Connected Tables and Joining Fields
        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.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.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.101212120
ENST00000000412.81212120
ENST00000000442.111212120
ENST00000001008.61212120
ENST00000001146.71212120
ENST00000002125.91212120
ENST00000002165.111212120
ENST00000002501.111212120
ENST00000002596.61212120
ENST00000002829.81212120

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