Schema for drBlastTab
  Database: mm8    Primary Table: drBlastTab    Row Count: 26,010   Data last updated: 2006-07-03
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB001539varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000015262varchar(255) values Name of sequence in other assembly (target)
identity 61.98float range Percent identity
aliLength 434int(10) unsigned range Length of alignment
mismatch 154int(10) unsigned range Number of mismatches
gapOpen 6int(10) unsigned range Number of gap openings
qStart 14int(10) unsigned range Start in query (0 based)
qEnd 446int(10) unsigned range End in query (non-inclusive)
tStart 8int(10) unsigned range Start in target (0 based)
tEnd 433int(10) unsigned range End in target (non-inclusive)
eValue 2e-153double range Expectation value
bitScore 539double range Bit score

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via drBlastTab.query)
      knownGeneV39.ceBlastTab.query (via drBlastTab.query)
      knownGeneV39.dmBlastTab.query (via drBlastTab.query)
      knownGeneV39.drBlastTab.query (via drBlastTab.query)
      knownGeneV39.foldUtr3.name (via drBlastTab.query)
      knownGeneV39.foldUtr5.name (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.query (via drBlastTab.query)
      knownGeneV39.gnfAtlas2Distance.target (via drBlastTab.query)
      knownGeneV39.kgAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgColor.kgID (via drBlastTab.query)
      knownGeneV39.kgProtAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgSpAlias.kgID (via drBlastTab.query)
      knownGeneV39.kgTargetAli.qName (via drBlastTab.query)
      knownGeneV39.kgXref.kgID (via drBlastTab.query)
      knownGeneV39.knownAttrs.kgID (via drBlastTab.query)
      knownGeneV39.knownBlastTab.query (via drBlastTab.query)
      knownGeneV39.knownBlastTab.target (via drBlastTab.query)
      knownGeneV39.knownCanonical.protein (via drBlastTab.query)
      knownGeneV39.knownCanonical.transcript (via drBlastTab.query)
      knownGeneV39.knownCds.name (via drBlastTab.query)
      knownGeneV39.knownGene.name (via drBlastTab.query)
      knownGeneV39.knownGeneMrna.name (via drBlastTab.query)
      knownGeneV39.knownGenePep.name (via drBlastTab.query)
      knownGeneV39.knownIsoforms.transcript (via drBlastTab.query)
      knownGeneV39.knownToEnsembl.name (via drBlastTab.query)
      knownGeneV39.knownToGnfAtlas2.name (via drBlastTab.query)
      knownGeneV39.knownToHprd.name (via drBlastTab.query)
      knownGeneV39.knownToLocusLink.name (via drBlastTab.query)
      knownGeneV39.knownToMrna.name (via drBlastTab.query)
      knownGeneV39.knownToMrnaSingle.name (via drBlastTab.query)
      knownGeneV39.knownToMupit.name (via drBlastTab.query)
      knownGeneV39.knownToPfam.name (via drBlastTab.query)
      knownGeneV39.knownToRefSeq.name (via drBlastTab.query)
      knownGeneV39.knownToSuper.gene (via drBlastTab.query)
      knownGeneV39.knownToTag.name (via drBlastTab.query)
      knownGeneV39.knownToU133.name (via drBlastTab.query)
      knownGeneV39.knownToU95.name (via drBlastTab.query)
      knownGeneV39.knownToVisiGene.name (via drBlastTab.query)
      knownGeneV39.knownToWikipedia.name (via drBlastTab.query)
      knownGeneV39.mmBlastTab.query (via drBlastTab.query)
      knownGeneV39.rnBlastTab.query (via drBlastTab.query)
      knownGeneV39.scBlastTab.query (via drBlastTab.query)
      knownGeneV39.ucscScop.ucscId (via drBlastTab.query)
      mm8.affyGnfU74ADistance.query (via drBlastTab.query)
      mm8.affyGnfU74ADistance.target (via drBlastTab.query)
      mm8.affyGnfU74BDistance.query (via drBlastTab.query)
      mm8.affyGnfU74BDistance.target (via drBlastTab.query)
      mm8.affyGnfU74CDistance.query (via drBlastTab.query)
      mm8.affyGnfU74CDistance.target (via drBlastTab.query)
      mm8.ccdsKgMap.geneId (via drBlastTab.query)
      mm8.ceBlastTab.query (via drBlastTab.query)
      mm8.dmBlastTab.query (via drBlastTab.query)
      mm8.dupSpMrna.mrnaID (via drBlastTab.query)
      mm8.foldUtr3.name (via drBlastTab.query)
      mm8.foldUtr5.name (via drBlastTab.query)
      mm8.gnfAtlas2Distance.query (via drBlastTab.query)
      mm8.gnfAtlas2Distance.target (via drBlastTab.query)
      mm8.hgBlastTab.query (via drBlastTab.query)
      mm8.keggPathway.kgID (via drBlastTab.query)
      mm8.kgAlias.kgID (via drBlastTab.query)
      mm8.kgProtAlias.kgID (via drBlastTab.query)
      mm8.kgSpAlias.kgID (via drBlastTab.query)
      mm8.kgTargetAli.qName (via drBlastTab.query)
      mm8.kgXref.kgID (via drBlastTab.query)
      mm8.knownBlastTab.query (via drBlastTab.query)
      mm8.knownBlastTab.target (via drBlastTab.query)
      mm8.knownCanonical.transcript (via drBlastTab.query)
      mm8.knownGene.name (via drBlastTab.query)
      mm8.knownGeneMrna.name (via drBlastTab.query)
      mm8.knownGenePep.name (via drBlastTab.query)
      mm8.knownIsoforms.transcript (via drBlastTab.query)
      mm8.knownToAllenBrain.name (via drBlastTab.query)
      mm8.knownToEnsembl.name (via drBlastTab.query)
      mm8.knownToGnfAtlas2.name (via drBlastTab.query)
      mm8.knownToKeggEntrez.name (via drBlastTab.query)
      mm8.knownToLocusLink.name (via drBlastTab.query)
      mm8.knownToPfam.name (via drBlastTab.query)
      mm8.knownToRefSeq.name (via drBlastTab.query)
      mm8.knownToSuper.gene (via drBlastTab.query)
      mm8.knownToVisiGene.name (via drBlastTab.query)
      mm8.rnBlastTab.query (via drBlastTab.query)
      mm8.scBlastTab.query (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AB001539ENSDART0000001526261.9843415461444684332e-153539
AB001750ENSDART0000005092971.288532249158621685401068
AB001926ENSDART0000002103758.9723489302325868151e-74276
AB003147ENSDART0000000022124.4527418351083581804540.0000000000000477.4
AB003503ENSDART0000001678073.6591112615597245800808
AB005654ENSDART0000004819187.45263330164427132766e-135478
AB005662ENSDART0000005314585.563674540366263864e-179624
AB006034ENSDART0000006617851.6944520646350704372e-120429
AB006329ENSDART0000001904758.064961621046513535324e-107385
AB006330ENSDART0000000673770.83384965123872996766e-112401

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