Schema for knownToLynx
  Database: hg38    Primary Table: knownToLynx    Row Count: 192,298   Data last updated: 2021-02-03
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 ENST00000000233.10varchar(255) values primary ID
value ARF5varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToLynx.name)
      hg38.ccdsKgMap.geneId (via knownToLynx.name)
      hg38.ceBlastTab.query (via knownToLynx.name)
      hg38.dmBlastTab.query (via knownToLynx.name)
      hg38.drBlastTab.query (via knownToLynx.name)
      hg38.foldUtr3.name (via knownToLynx.name)
      hg38.foldUtr5.name (via knownToLynx.name)
      hg38.gnfAtlas2Distance.query (via knownToLynx.name)
      hg38.gnfAtlas2Distance.target (via knownToLynx.name)
      hg38.gnfU95Distance.query (via knownToLynx.name)
      hg38.gnfU95Distance.target (via knownToLynx.name)
      hg38.humanHprdP2P.query (via knownToLynx.name)
      hg38.humanHprdP2P.target (via knownToLynx.name)
      hg38.humanVidalP2P.query (via knownToLynx.name)
      hg38.humanVidalP2P.target (via knownToLynx.name)
      hg38.humanWankerP2P.query (via knownToLynx.name)
      hg38.humanWankerP2P.target (via knownToLynx.name)
      hg38.keggPathway.kgID (via knownToLynx.name)
      hg38.kgAlias.kgID (via knownToLynx.name)
      hg38.kgColor.kgID (via knownToLynx.name)
      hg38.kgProtAlias.kgID (via knownToLynx.name)
      hg38.kgSpAlias.kgID (via knownToLynx.name)
      hg38.kgTargetAli.qName (via knownToLynx.name)
      hg38.kgXref.kgID (via knownToLynx.name)
      hg38.knownAttrs.kgID (via knownToLynx.name)
      hg38.knownBlastTab.query (via knownToLynx.name)
      hg38.knownBlastTab.target (via knownToLynx.name)
      hg38.knownCanonical.transcript (via knownToLynx.name)
      hg38.knownCds.name (via knownToLynx.name)
      hg38.knownGene.name (via knownToLynx.name)
      hg38.knownGeneMrna.name (via knownToLynx.name)
      hg38.knownGenePep.name (via knownToLynx.name)
      hg38.knownIsoforms.transcript (via knownToLynx.name)
      hg38.knownToEnsembl.name (via knownToLynx.name)
      hg38.knownToGnfAtlas2.name (via knownToLynx.name)
      hg38.knownToHprd.name (via knownToLynx.name)
      hg38.knownToKeggEntrez.name (via knownToLynx.name)
      hg38.knownToLocusLink.name (via knownToLynx.name)
      hg38.knownToMrna.name (via knownToLynx.name)
      hg38.knownToMrnaSingle.name (via knownToLynx.name)
      hg38.knownToMupit.name (via knownToLynx.name)
      hg38.knownToNextProt.name (via knownToLynx.name)
      hg38.knownToPfam.name (via knownToLynx.name)
      hg38.knownToRefSeq.name (via knownToLynx.name)
      hg38.knownToSuper.gene (via knownToLynx.name)
      hg38.knownToTag.name (via knownToLynx.name)
      hg38.knownToU133.name (via knownToLynx.name)
      hg38.knownToU95.name (via knownToLynx.name)
      hg38.knownToVisiGene.name (via knownToLynx.name)
      hg38.knownToWikipedia.name (via knownToLynx.name)
      hg38.mmBlastTab.query (via knownToLynx.name)
      hg38.rnBlastTab.query (via knownToLynx.name)
      hg38.scBlastTab.query (via knownToLynx.name)
      hg38.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
ENST00000000233.10ARF5
ENST00000000412.8M6PR
ENST00000000442.11ESRRA
ENST00000001008.6FKBP4
ENST00000001146.6CYP26B1
ENST00000002125.9NDUFAF7
ENST00000002165.11FUCA2
ENST00000002501.11DBNDD1
ENST00000002596.6HS3ST1
ENST00000002829.8SEMA3F

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