Schema for drBlastTab
  Database: hg17    Primary Table: drBlastTab    Row Count: 30,651   Data last updated: 2005-06-04
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query AB000409varchar(255) values Name of sequence in this assembly (query)
target ENSDARP00000012230varchar(255) values Name of sequence in other assembly (target)
identity 77.38float range Percent identity
aliLength 389int(10) unsigned range Length of alignment
mismatch 82int(10) unsigned range Number of mismatches
gapOpen 2int(10) unsigned range Number of gap openings
qStart 12int(10) unsigned range Start in query (0 based)
qEnd 401int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 383int(10) unsigned range End in target (non-inclusive)
eValue 2e-166double range Expectation value
bitScore 582.4double range Bit score

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via drBlastTab.query)
      hg17.ccdsKgMap.geneId (via drBlastTab.query)
      hg17.ceBlastTab.query (via drBlastTab.query)
      hg17.dmBlastTab.query (via drBlastTab.query)
      hg17.dupSpMrna.mrnaID (via drBlastTab.query)
      hg17.foldUtr3.name (via drBlastTab.query)
      hg17.foldUtr5.name (via drBlastTab.query)
      hg17.gladHumESDistance.query (via drBlastTab.query)
      hg17.gladHumESDistance.target (via drBlastTab.query)
      hg17.gnfAtlas2Distance.query (via drBlastTab.query)
      hg17.gnfAtlas2Distance.target (via drBlastTab.query)
      hg17.gnfU95Distance.query (via drBlastTab.query)
      hg17.gnfU95Distance.target (via drBlastTab.query)
      hg17.humanHprdP2P.query (via drBlastTab.query)
      hg17.humanHprdP2P.target (via drBlastTab.query)
      hg17.humanVidalP2P.query (via drBlastTab.query)
      hg17.humanVidalP2P.target (via drBlastTab.query)
      hg17.humanWankerP2P.query (via drBlastTab.query)
      hg17.humanWankerP2P.target (via drBlastTab.query)
      hg17.keggPathway.kgID (via drBlastTab.query)
      hg17.kgAlias.kgID (via drBlastTab.query)
      hg17.kgProtAlias.kgID (via drBlastTab.query)
      hg17.kgSpAlias.kgID (via drBlastTab.query)
      hg17.kgTargetAli.qName (via drBlastTab.query)
      hg17.kgXref.kgID (via drBlastTab.query)
      hg17.knownBlastTab.query (via drBlastTab.query)
      hg17.knownBlastTab.target (via drBlastTab.query)
      hg17.knownCanonical.transcript (via drBlastTab.query)
      hg17.knownExpDistance.query (via drBlastTab.query)
      hg17.knownExpDistance.target (via drBlastTab.query)
      hg17.knownGene.name (via drBlastTab.query)
      hg17.knownGeneLink.name (via drBlastTab.query)
      hg17.knownGeneMrna.name (via drBlastTab.query)
      hg17.knownGenePep.name (via drBlastTab.query)
      hg17.knownIsoforms.transcript (via drBlastTab.query)
      hg17.knownToAllenBrain.name (via drBlastTab.query)
      hg17.knownToEnsembl.name (via drBlastTab.query)
      hg17.knownToGnf1h.name (via drBlastTab.query)
      hg17.knownToGnfAtlas2.name (via drBlastTab.query)
      hg17.knownToHInv.name (via drBlastTab.query)
      hg17.knownToHprd.name (via drBlastTab.query)
      hg17.knownToKeggEntrez.name (via drBlastTab.query)
      hg17.knownToLocusLink.name (via drBlastTab.query)
      hg17.knownToPfam.name (via drBlastTab.query)
      hg17.knownToRefSeq.name (via drBlastTab.query)
      hg17.knownToSuper.gene (via drBlastTab.query)
      hg17.knownToU133.name (via drBlastTab.query)
      hg17.knownToU133Plus2.name (via drBlastTab.query)
      hg17.knownToU95.name (via drBlastTab.query)
      hg17.knownToVisiGene.name (via drBlastTab.query)
      hg17.mmBlastTab.query (via drBlastTab.query)
      hg17.rankProp.query (via drBlastTab.query)
      hg17.rankProp.target (via drBlastTab.query)
      hg17.rnBlastTab.query (via drBlastTab.query)
      hg17.scBlastTab.query (via drBlastTab.query)
      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)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
AB000409ENSDARP0000001223077.383898221240103832e-166582.4
AB000460ENSDARP0000004006428.471375863684905546660.00242.36
AB000461ENSDARP0000004006428.471375863684905546660.00242.36
AB000463ENSDARP0000003509478.75801700800801.6e-34140.6
AB000781ENSDARP0000004853343.3115786311841340211769e-28124
AB000815ENSDARP0000000422386.03229232022302264e-100360.9
AB001025ENSDARP0000004580456.174321177845842850424904448.3
AB001328ENSDARP0000005021065.581544410154271721.3e-45180.3
AB001535ENSDARP0000001722338.26933479181876749688e-143505.8
AB002292ENSDARP0000001722261.5310453561011311360102101210.3

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