Schema for knownGeneLink
  Database: hg17    Primary Table: knownGeneLink    Row Count: 0   Data last updated: 2005-06-05
Format description: Known Genes Link table, currently storing DNA based entries only.
On download server: MariaDB table dump directory
fieldSQL type info description
name varchar(40) values Known Gene ID
seqType char(1) values sequence type, 'g' genomic, 'm' mRNA, etc.
proteinID varchar(40) values Protein ID

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

Sample Rows
 
nameseqTypeproteinID

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