Schema for kgColor
  Database: mm10    Primary Table: kgColor    Row Count: 142,446   Data last updated: 2019-09-20
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000193812.1varchar(255) values Known gene ID
r 130tinyint(3) unsigned range Red component 0-255
g 130tinyint(3) unsigned range Green component 0-255
b 210tinyint(3) unsigned range Blue component 0-255

Connected Tables and Joining Fields
        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)
      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.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)

Sample Rows
 
kgIDrgb
ENSMUST00000193812.1130130210
ENSMUST00000082908.1130130210
ENSMUST00000162897.1130130210
ENSMUST00000159265.1130130210
ENSMUST00000070533.41212120
ENSMUST00000195335.1130130210
ENSMUST00000192336.1130130210
ENSMUST00000194099.1130130210
ENSMUST00000161581.1130130210
ENSMUST00000192973.1130130210

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