Schema for drBlastTab
  Database: sacCer3    Primary Table: drBlastTab    Row Count: 2,391   Data last updated: 2017-09-07
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR315Wvarchar(255) values Name of sequence in this assembly (query)
target ENSDART00000032392.4varchar(255) values Name of sequence in other assembly (target)
identity 21.18float range Percent identity
aliLength 255int(10) unsigned range Length of alignment
mismatch 189int(10) unsigned range Number of mismatches
gapOpen 5int(10) unsigned range Number of gap openings
qStart 6int(10) unsigned range Start in query (0 based)
qEnd 260int(10) unsigned range End in query (non-inclusive)
tStart 5int(10) unsigned range Start in target (0 based)
tEnd 249int(10) unsigned range End in target (non-inclusive)
eValue 0.00007double range Expectation value
bitScore 45.8double range Bit score

Connected Tables and Joining Fields
        sacCer3.ceBlastTab.query (via drBlastTab.query)
      sacCer3.choExpDistance.query (via drBlastTab.query)
      sacCer3.choExpDistance.target (via drBlastTab.query)
      sacCer3.dmBlastTab.query (via drBlastTab.query)
      sacCer3.esRegGeneToModule.gene (via drBlastTab.query)
      sacCer3.esRegGeneToMotif.gene (via drBlastTab.query)
      sacCer3.esRegUpstreamRegion.name (via drBlastTab.query)
      sacCer3.hgBlastTab.query (via drBlastTab.query)
      sacCer3.mmBlastTab.query (via drBlastTab.query)
      sacCer3.rnBlastTab.query (via drBlastTab.query)
      sacCer3.sgdBlastTab.query (via drBlastTab.query)
      sacCer3.sgdBlastTab.target (via drBlastTab.query)
      sacCer3.sgdCanonical.transcript (via drBlastTab.query)
      sacCer3.sgdDescription.name (via drBlastTab.query)
      sacCer3.sgdGene.name (via drBlastTab.query)
      sacCer3.sgdIsoforms.transcript (via drBlastTab.query)
      sacCer3.sgdPep.name (via drBlastTab.query)
      sacCer3.sgdToName.name (via drBlastTab.query)
      sacCer3.sgdToSwissProt.name (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315WENSDART00000032392.421.182551895626052490.0000745.8
YMR314WENSDART00000160688.152.342351092023402334e-63238
YMR309CENSDART00000121867.231.26547347112567943318582e-59228
YHR072W-AENSDART00000161015.267.27551800550554e-1680.1
YMR308CENSDART00000058876.829.241033686172010281510283e-107387
YMR304WENSDART00000150953.238.796293181338662686354e-116417
YMR296CENSDART00000167711.134.04470259783550724943e-70263
YMR292WENSDART00000143006.142.1610259029131301320.0000000454.3
YMR293CENSDART00000045615.534.65430250643457804956e-55212
YMR288WENSDART00000078568.453.04856400211797145913150876

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