Schema for kgColor
  Database: hg38    Primary Table: kgColor    Row Count: 412,034   Data last updated: 2024-08-19
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 109tinyint(3) unsigned range Green component 0-255
b 173tinyint(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.1012109173
ENST00000000412.812109173
ENST00000000442.1112109173
ENST00000001008.612109173
ENST00000001146.712109173
ENST00000002125.912109173
ENST00000002165.1112109173
ENST00000002501.1112109173
ENST00000002596.612109173
ENST00000002829.812109173

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