Schema for knownToVisiGene
Database: hg19    Primary Table: knownToVisiGene    Row Count: 46,416
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name uc009vis.2varchar(255) values primary ID
value 179407varchar(255) values associated ID, label, quantity etc.
Connected Tables and Joining Fields
      hg19.bioCycPathway.kgID (via knownToVisiGene.name)
      hg19.ccdsKgMap.geneId (via knownToVisiGene.name)
      hg19.ceBlastTab.query (via knownToVisiGene.name)
      hg19.dmBlastTab.query (via knownToVisiGene.name)
      hg19.drBlastTab.query (via knownToVisiGene.name)
      hg19.foldUtr3.name (via knownToVisiGene.name)
      hg19.foldUtr5.name (via knownToVisiGene.name)
      hg19.gnfAtlas2Distance.query (via knownToVisiGene.name)
      hg19.gnfAtlas2Distance.target (via knownToVisiGene.name)
      hg19.humanHprdP2P.query (via knownToVisiGene.name)
      hg19.humanHprdP2P.target (via knownToVisiGene.name)
      hg19.humanVidalP2P.query (via knownToVisiGene.name)
      hg19.humanVidalP2P.target (via knownToVisiGene.name)
      hg19.humanWankerP2P.query (via knownToVisiGene.name)
      hg19.humanWankerP2P.target (via knownToVisiGene.name)
      hg19.keggPathway.kgID (via knownToVisiGene.name)
      hg19.kg4ToKg5.newId (via knownToVisiGene.name)
      hg19.kgAlias.kgID (via knownToVisiGene.name)
      hg19.kgColor.kgID (via knownToVisiGene.name)
      hg19.kgProtAlias.kgID (via knownToVisiGene.name)
      hg19.kgProtMap2.qName (via knownToVisiGene.name)
      hg19.kgSpAlias.kgID (via knownToVisiGene.name)
      hg19.kgTargetAli.qName (via knownToVisiGene.name)
      hg19.kgTxInfo.name (via knownToVisiGene.name)
      hg19.kgXref.kgID (via knownToVisiGene.name)
      hg19.knownBlastTab.query (via knownToVisiGene.name)
      hg19.knownBlastTab.target (via knownToVisiGene.name)
      hg19.knownCanonical.protein (via knownToVisiGene.name)
      hg19.knownCanonical.transcript (via knownToVisiGene.name)
      hg19.knownGene.name (via knownToVisiGene.name)
      hg19.knownGeneMrna.name (via knownToVisiGene.name)
      hg19.knownGenePep.name (via knownToVisiGene.name)
      hg19.knownIsoforms.transcript (via knownToVisiGene.name)
      hg19.knownToAllenBrain.name (via knownToVisiGene.name)
      hg19.knownToEnsembl.name (via knownToVisiGene.name)
      hg19.knownToGnfAtlas2.name (via knownToVisiGene.name)
      hg19.knownToHprd.name (via knownToVisiGene.name)
      hg19.knownToLocusLink.name (via knownToVisiGene.name)
      hg19.knownToPfam.name (via knownToVisiGene.name)
      hg19.knownToRefSeq.name (via knownToVisiGene.name)
      hg19.knownToSuper.gene (via knownToVisiGene.name)
      hg19.knownToTreefam.name (via knownToVisiGene.name)
      hg19.knownToU133.name (via knownToVisiGene.name)
      hg19.mmBlastTab.query (via knownToVisiGene.name)
      hg19.rnBlastTab.query (via knownToVisiGene.name)
      hg19.scBlastTab.query (via knownToVisiGene.name)
Sample Rows
namevalue
uc009vis.2179407
uc009vit.2179407
uc001aae.3179407
uc009viu.2179407
uc001aab.3179407
uc001aah.3179407
uc009vir.2179407
uc009viq.2179407
uc001aac.3179407
uc009viv.2179407

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