Schema for knownGeneLink
  Database: rn3    Primary Table: knownGeneLink    Row Count: 109   Data last updated: 2004-03-23
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_012494varchar(40) values Known Gene ID
seqType gchar(1) values sequence type, 'g' genomic, 'm' mRNA, etc.
proteinID NP_036626.1varchar(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)
      rn3.dmBlastTab.query (via knownGeneLink.name)
      rn3.drBlastTab.query (via knownGeneLink.name)
      rn3.dupSpMrna.mrnaID (via knownGeneLink.name)
      rn3.gnfAtlas2Distance.query (via knownGeneLink.name)
      rn3.gnfAtlas2Distance.target (via knownGeneLink.name)
      rn3.hgBlastTab.query (via knownGeneLink.name)
      rn3.keggPathway.kgID (via knownGeneLink.name)
      rn3.kgAlias.kgID (via knownGeneLink.name)
      rn3.kgProtAlias.kgID (via knownGeneLink.name)
      rn3.kgSpAlias.kgID (via knownGeneLink.name)
      rn3.kgXref.kgID (via knownGeneLink.name)
      rn3.knownBlastTab.query (via knownGeneLink.name)
      rn3.knownBlastTab.target (via knownGeneLink.name)
      rn3.knownCanonical.transcript (via knownGeneLink.name)
      rn3.knownGene.name (via knownGeneLink.name)
      rn3.knownGeneMrna.name (via knownGeneLink.name)
      rn3.knownGenePep.name (via knownGeneLink.name)
      rn3.knownIsoforms.transcript (via knownGeneLink.name)
      rn3.knownToEnsembl.name (via knownGeneLink.name)
      rn3.knownToGnfAtlas2.name (via knownGeneLink.name)
      rn3.knownToLocusLink.name (via knownGeneLink.name)
      rn3.knownToPfam.name (via knownGeneLink.name)
      rn3.knownToRefSeq.name (via knownGeneLink.name)
      rn3.knownToSuper.gene (via knownGeneLink.name)
      rn3.scBlastTab.query (via knownGeneLink.name)

Sample Rows
 
nameseqTypeproteinID
NM_012494gNP_036626.1
NM_012518gNP_036650.1
NM_012524gNP_036656.1
NM_012533gNP_036665.1
NM_012542gNP_036674.1
NM_012549gNP_036681.1
NM_012561gNP_036693.1
NM_012579gNP_036711.1
NM_012585gNP_036717.1
NM_012594gNP_036726.1

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