Schema for knownGeneLink
  Database: mm7    Primary Table: knownGeneLink    Row Count: 0   Data last updated: 2005-11-28
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
        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)
      mm7.affyGnfU74ADistance.query (via knownGeneLink.name)
      mm7.affyGnfU74ADistance.target (via knownGeneLink.name)
      mm7.affyGnfU74BDistance.query (via knownGeneLink.name)
      mm7.affyGnfU74BDistance.target (via knownGeneLink.name)
      mm7.affyGnfU74CDistance.query (via knownGeneLink.name)
      mm7.affyGnfU74CDistance.target (via knownGeneLink.name)
      mm7.dmBlastTab.query (via knownGeneLink.name)
      mm7.drBlastTab.query (via knownGeneLink.name)
      mm7.dupSpMrna.mrnaID (via knownGeneLink.name)
      mm7.foldUtr3.name (via knownGeneLink.name)
      mm7.foldUtr5.name (via knownGeneLink.name)
      mm7.gnfAtlas2Distance.query (via knownGeneLink.name)
      mm7.gnfAtlas2Distance.target (via knownGeneLink.name)
      mm7.hgBlastTab.query (via knownGeneLink.name)
      mm7.keggPathway.kgID (via knownGeneLink.name)
      mm7.kgAlias.kgID (via knownGeneLink.name)
      mm7.kgProtAlias.kgID (via knownGeneLink.name)
      mm7.kgSpAlias.kgID (via knownGeneLink.name)
      mm7.kgXref.kgID (via knownGeneLink.name)
      mm7.knownBlastTab.query (via knownGeneLink.name)
      mm7.knownBlastTab.target (via knownGeneLink.name)
      mm7.knownCanonical.transcript (via knownGeneLink.name)
      mm7.knownGene.name (via knownGeneLink.name)
      mm7.knownGeneMrna.name (via knownGeneLink.name)
      mm7.knownGenePep.name (via knownGeneLink.name)
      mm7.knownIsoforms.transcript (via knownGeneLink.name)
      mm7.knownToAllenBrain.name (via knownGeneLink.name)
      mm7.knownToEnsembl.name (via knownGeneLink.name)
      mm7.knownToGnfAtlas2.name (via knownGeneLink.name)
      mm7.knownToKeggEntrez.name (via knownGeneLink.name)
      mm7.knownToLocusLink.name (via knownGeneLink.name)
      mm7.knownToPfam.name (via knownGeneLink.name)
      mm7.knownToRefSeq.name (via knownGeneLink.name)
      mm7.knownToVisiGene.name (via knownGeneLink.name)
      mm7.rnBlastTab.query (via knownGeneLink.name)
      mm7.scBlastTab.query (via knownGeneLink.name)

Sample Rows
 
nameseqTypeproteinID

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