Schema for knownToLocusLink
Database: hg19    Primary Table: knownToLocusLink    Row Count: 71,192
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name uc010yif.1varchar(255) values primary ID
value 10772varchar(255) values associated ID, label, quantity etc.
Connected Tables and Joining Fields
      hg19.bioCycPathway.kgID (via knownToLocusLink.name)
      hg19.ccdsKgMap.geneId (via knownToLocusLink.name)
      hg19.ceBlastTab.query (via knownToLocusLink.name)
      hg19.dmBlastTab.query (via knownToLocusLink.name)
      hg19.drBlastTab.query (via knownToLocusLink.name)
      hg19.foldUtr3.name (via knownToLocusLink.name)
      hg19.foldUtr5.name (via knownToLocusLink.name)
      hg19.gnfAtlas2Distance.query (via knownToLocusLink.name)
      hg19.gnfAtlas2Distance.target (via knownToLocusLink.name)
      hg19.humanHprdP2P.query (via knownToLocusLink.name)
      hg19.humanHprdP2P.target (via knownToLocusLink.name)
      hg19.humanVidalP2P.query (via knownToLocusLink.name)
      hg19.humanVidalP2P.target (via knownToLocusLink.name)
      hg19.humanWankerP2P.query (via knownToLocusLink.name)
      hg19.humanWankerP2P.target (via knownToLocusLink.name)
      hg19.keggPathway.kgID (via knownToLocusLink.name)
      hg19.kg4ToKg5.newId (via knownToLocusLink.name)
      hg19.kgAlias.kgID (via knownToLocusLink.name)
      hg19.kgColor.kgID (via knownToLocusLink.name)
      hg19.kgProtAlias.kgID (via knownToLocusLink.name)
      hg19.kgProtMap2.qName (via knownToLocusLink.name)
      hg19.kgSpAlias.kgID (via knownToLocusLink.name)
      hg19.kgTargetAli.qName (via knownToLocusLink.name)
      hg19.kgTxInfo.name (via knownToLocusLink.name)
      hg19.kgXref.kgID (via knownToLocusLink.name)
      hg19.knownBlastTab.query (via knownToLocusLink.name)
      hg19.knownBlastTab.target (via knownToLocusLink.name)
      hg19.knownCanonical.protein (via knownToLocusLink.name)
      hg19.knownCanonical.transcript (via knownToLocusLink.name)
      hg19.knownGene.name (via knownToLocusLink.name)
      hg19.knownGeneMrna.name (via knownToLocusLink.name)
      hg19.knownGenePep.name (via knownToLocusLink.name)
      hg19.knownIsoforms.transcript (via knownToLocusLink.name)
      hg19.knownToAllenBrain.name (via knownToLocusLink.name)
      hg19.knownToEnsembl.name (via knownToLocusLink.name)
      hg19.knownToGnfAtlas2.name (via knownToLocusLink.name)
      hg19.knownToHprd.name (via knownToLocusLink.name)
      hg19.knownToPfam.name (via knownToLocusLink.name)
      hg19.knownToRefSeq.name (via knownToLocusLink.name)
      hg19.knownToSuper.gene (via knownToLocusLink.name)
      hg19.knownToTreefam.name (via knownToLocusLink.name)
      hg19.knownToU133.name (via knownToLocusLink.name)
      hg19.knownToVisiGene.name (via knownToLocusLink.name)
      hg19.mmBlastTab.query (via knownToLocusLink.name)
      hg19.rnBlastTab.query (via knownToLocusLink.name)
      hg19.scBlastTab.query (via knownToLocusLink.name)
      hg19.keggPathway.locusID (via knownToLocusLink.value)
      hg19.refLink.locusLinkId (via knownToLocusLink.value)
Sample Rows
namevalue
uc010yif.110772
uc002qvr.110772
uc010yig.110772
uc011mgj.122947
uc011mgk.122947
uc011mgl.122947
uc011mgm.122947
uc011mgn.122947
uc011mgo.122947
uc011mgp.1728410

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