Schema for knownToLynx
  Database: hg19    Primary Table: knownToLynx    Row Count: 74,800   Data last updated: 2014-03-25
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc001aaa.3varchar(255) values primary ID
value DDX11L1varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToLynx.name)
      hg19.ccdsKgMap.geneId (via knownToLynx.name)
      hg19.ceBlastTab.query (via knownToLynx.name)
      hg19.dmBlastTab.query (via knownToLynx.name)
      hg19.drBlastTab.query (via knownToLynx.name)
      hg19.foldUtr3.name (via knownToLynx.name)
      hg19.foldUtr5.name (via knownToLynx.name)
      hg19.gnfAtlas2Distance.query (via knownToLynx.name)
      hg19.gnfAtlas2Distance.target (via knownToLynx.name)
      hg19.gnfU95Distance.query (via knownToLynx.name)
      hg19.gnfU95Distance.target (via knownToLynx.name)
      hg19.humanHprdP2P.query (via knownToLynx.name)
      hg19.humanHprdP2P.target (via knownToLynx.name)
      hg19.humanVidalP2P.query (via knownToLynx.name)
      hg19.humanVidalP2P.target (via knownToLynx.name)
      hg19.humanWankerP2P.query (via knownToLynx.name)
      hg19.humanWankerP2P.target (via knownToLynx.name)
      hg19.keggPathway.kgID (via knownToLynx.name)
      hg19.kgAlias.kgID (via knownToLynx.name)
      hg19.kgColor.kgID (via knownToLynx.name)
      hg19.kgProtAlias.kgID (via knownToLynx.name)
      hg19.kgProtMap2.qName (via knownToLynx.name)
      hg19.kgSpAlias.kgID (via knownToLynx.name)
      hg19.kgTargetAli.qName (via knownToLynx.name)
      hg19.kgTxInfo.name (via knownToLynx.name)
      hg19.kgXref.kgID (via knownToLynx.name)
      hg19.knownBlastTab.query (via knownToLynx.name)
      hg19.knownBlastTab.target (via knownToLynx.name)
      hg19.knownCanonical.transcript (via knownToLynx.name)
      hg19.knownGene.name (via knownToLynx.name)
      hg19.knownGeneMrna.name (via knownToLynx.name)
      hg19.knownGenePep.name (via knownToLynx.name)
      hg19.knownGeneTxMrna.name (via knownToLynx.name)
      hg19.knownGeneTxPep.name (via knownToLynx.name)
      hg19.knownIsoforms.transcript (via knownToLynx.name)
      hg19.knownToAllenBrain.name (via knownToLynx.name)
      hg19.knownToEnsembl.name (via knownToLynx.name)
      hg19.knownToGnfAtlas2.name (via knownToLynx.name)
      hg19.knownToHInv.name (via knownToLynx.name)
      hg19.knownToHprd.name (via knownToLynx.name)
      hg19.knownToKeggEntrez.name (via knownToLynx.name)
      hg19.knownToLocusLink.name (via knownToLynx.name)
      hg19.knownToMupit.name (via knownToLynx.name)
      hg19.knownToNextProt.name (via knownToLynx.name)
      hg19.knownToPfam.name (via knownToLynx.name)
      hg19.knownToRefSeq.name (via knownToLynx.name)
      hg19.knownToSuper.gene (via knownToLynx.name)
      hg19.knownToTreefam.name (via knownToLynx.name)
      hg19.knownToU133.name (via knownToLynx.name)
      hg19.knownToU133Plus2.name (via knownToLynx.name)
      hg19.knownToU95.name (via knownToLynx.name)
      hg19.knownToVisiGene.name (via knownToLynx.name)
      hg19.knownToWikipedia.name (via knownToLynx.name)
      hg19.mmBlastTab.query (via knownToLynx.name)
      hg19.rnBlastTab.query (via knownToLynx.name)
      hg19.scBlastTab.query (via knownToLynx.name)
      hg19.ucscScop.ucscId (via knownToLynx.name)
      knownGeneV39.bioCycPathway.kgID (via knownToLynx.name)
      knownGeneV39.ceBlastTab.query (via knownToLynx.name)
      knownGeneV39.dmBlastTab.query (via knownToLynx.name)
      knownGeneV39.drBlastTab.query (via knownToLynx.name)
      knownGeneV39.foldUtr3.name (via knownToLynx.name)
      knownGeneV39.foldUtr5.name (via knownToLynx.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToLynx.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToLynx.name)
      knownGeneV39.kgAlias.kgID (via knownToLynx.name)
      knownGeneV39.kgColor.kgID (via knownToLynx.name)
      knownGeneV39.kgProtAlias.kgID (via knownToLynx.name)
      knownGeneV39.kgSpAlias.kgID (via knownToLynx.name)
      knownGeneV39.kgTargetAli.qName (via knownToLynx.name)
      knownGeneV39.kgXref.kgID (via knownToLynx.name)
      knownGeneV39.knownAttrs.kgID (via knownToLynx.name)
      knownGeneV39.knownBlastTab.query (via knownToLynx.name)
      knownGeneV39.knownBlastTab.target (via knownToLynx.name)
      knownGeneV39.knownCanonical.protein (via knownToLynx.name)
      knownGeneV39.knownCanonical.transcript (via knownToLynx.name)
      knownGeneV39.knownCds.name (via knownToLynx.name)
      knownGeneV39.knownGene.name (via knownToLynx.name)
      knownGeneV39.knownGeneMrna.name (via knownToLynx.name)
      knownGeneV39.knownGenePep.name (via knownToLynx.name)
      knownGeneV39.knownIsoforms.transcript (via knownToLynx.name)
      knownGeneV39.knownToEnsembl.name (via knownToLynx.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToLynx.name)
      knownGeneV39.knownToHprd.name (via knownToLynx.name)
      knownGeneV39.knownToLocusLink.name (via knownToLynx.name)
      knownGeneV39.knownToMrna.name (via knownToLynx.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToLynx.name)
      knownGeneV39.knownToMupit.name (via knownToLynx.name)
      knownGeneV39.knownToPfam.name (via knownToLynx.name)
      knownGeneV39.knownToRefSeq.name (via knownToLynx.name)
      knownGeneV39.knownToSuper.gene (via knownToLynx.name)
      knownGeneV39.knownToTag.name (via knownToLynx.name)
      knownGeneV39.knownToU133.name (via knownToLynx.name)
      knownGeneV39.knownToU95.name (via knownToLynx.name)
      knownGeneV39.knownToVisiGene.name (via knownToLynx.name)
      knownGeneV39.knownToWikipedia.name (via knownToLynx.name)
      knownGeneV39.mmBlastTab.query (via knownToLynx.name)
      knownGeneV39.rnBlastTab.query (via knownToLynx.name)
      knownGeneV39.scBlastTab.query (via knownToLynx.name)
      knownGeneV39.ucscScop.ucscId (via knownToLynx.name)

Sample Rows
 
namevalue
uc001aaa.3DDX11L1
uc001aac.4WASH7P
uc001aae.4WASH7P
uc001aah.4WASH7P
uc001aai.1WASH7P
uc001aak.3FAM138F
uc001aal.1OR4F5
uc001aau.3LOC100132062
uc001abe.4LOC100133331
uc001abo.3LOC100288069

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