Schema for knownGeneLink
  Database: hg16    Primary Table: knownGeneLink    Row Count: 477   Data last updated: 2004-03-27
Format description: Known Genes Link table, currently storing DNA based entries only.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_000134varchar(40) values Known Gene ID
seqType gchar(1) values sequence type, 'g' genomic, 'm' mRNA, etc.
proteinID NP_000125.1varchar(40) values Protein ID

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownGeneLink.name)
      hg16.dmBlastTab.query (via knownGeneLink.name)
      hg16.drBlastTab.query (via knownGeneLink.name)
      hg16.dupSpMrna.mrnaID (via knownGeneLink.name)
      hg16.foldUtr3.name (via knownGeneLink.name)
      hg16.foldUtr5.name (via knownGeneLink.name)
      hg16.gnfAtlas2Distance.query (via knownGeneLink.name)
      hg16.gnfAtlas2Distance.target (via knownGeneLink.name)
      hg16.gnfU95Distance.query (via knownGeneLink.name)
      hg16.gnfU95Distance.target (via knownGeneLink.name)
      hg16.hg17Kg.name (via knownGeneLink.name)
      hg16.keggPathway.kgID (via knownGeneLink.name)
      hg16.kgAlias.kgID (via knownGeneLink.name)
      hg16.kgProtAlias.kgID (via knownGeneLink.name)
      hg16.kgXref.kgID (via knownGeneLink.name)
      hg16.knownBlastTab.query (via knownGeneLink.name)
      hg16.knownBlastTab.target (via knownGeneLink.name)
      hg16.knownCanonical.transcript (via knownGeneLink.name)
      hg16.knownGene.name (via knownGeneLink.name)
      hg16.knownGeneMrna.name (via knownGeneLink.name)
      hg16.knownGenePep.name (via knownGeneLink.name)
      hg16.knownIsoforms.transcript (via knownGeneLink.name)
      hg16.knownToEnsembl.name (via knownGeneLink.name)
      hg16.knownToGnfAtlas2.name (via knownGeneLink.name)
      hg16.knownToHInv.name (via knownGeneLink.name)
      hg16.knownToLocusLink.name (via knownGeneLink.name)
      hg16.knownToPfam.name (via knownGeneLink.name)
      hg16.knownToRefSeq.name (via knownGeneLink.name)
      hg16.knownToSuper.gene (via knownGeneLink.name)
      hg16.knownToU133.name (via knownGeneLink.name)
      hg16.knownToU95.name (via knownGeneLink.name)
      hg16.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
NM_000134gNP_000125.1
NM_000164gNP_000155.1
NM_000189gNP_000180.2
NM_000219gNP_000210.1
NM_000302gNP_000293.2
NM_000341gNP_000332.2
NM_000412gNP_000403.2
NM_000485gNP_000476.1
NM_000510gNP_000501.1
NM_000511gNP_000502.1

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