Schema for rnBlastTab
  Database: hg18    Primary Table: rnBlastTab    Row Count: 20,757   Data last updated: 2009-03-03
Format description: Blast alignments of Rat genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query uc009vjp.1varchar(255) values Name of sequence in this assembly (query)
target NM_001033897varchar(255) values Name of sequence in other assembly (target)
identity 63.73float range Percent identity
aliLength 193int(10) unsigned range Length of alignment
mismatch 63int(10) unsigned range Number of mismatches
gapOpen 1int(10) unsigned range Number of gap openings
qStart 10int(10) unsigned range Start in query (0 based)
qEnd 203int(10) unsigned range End in query (non-inclusive)
tStart 445int(10) unsigned range Start in target (0 based)
tEnd 631int(10) unsigned range End in target (non-inclusive)
eValue 6e-60double range Expectation value
bitScore 225double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
uc009vjp.1NM_00103389763.73193631102034456316e-60225
uc001aby.2NM_00103389774.855091211295381296310761
uc001abz.2NM_00103389776.746021372135736316310908
uc009vjq.1NM_00103389775.456071412135741316310908
uc001aca.1NM_14567195.536272610627062501162
uc001acb.1NM_14567199.121141001141222365.0000000000000005e-61228
uc001aci.1NM_02436077.9512728023150231507.999999999999999e-54204
uc001ack.1NM_17575483.7383013501559855088001525
uc009vjt.1NM_00101407279.2277160077901676e-30125
uc001acm.2NM_00101407265.3818243217179171995e-63234

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