Schema for drBlastTab
  Database: sacCer2    Primary Table: drBlastTab    Row Count: 2,233   Data last updated: 2013-10-11
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 ENSDART00000032392varchar(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
        sacCer2.ceBlastTab.query (via drBlastTab.query)
      sacCer2.choExpDistance.query (via drBlastTab.query)
      sacCer2.choExpDistance.target (via drBlastTab.query)
      sacCer2.dmBlastTab.query (via drBlastTab.query)
      sacCer2.esRegGeneToModule.gene (via drBlastTab.query)
      sacCer2.esRegGeneToMotif.gene (via drBlastTab.query)
      sacCer2.esRegUpstreamRegion.name (via drBlastTab.query)
      sacCer2.hgBlastTab.query (via drBlastTab.query)
      sacCer2.mmBlastTab.query (via drBlastTab.query)
      sacCer2.rnBlastTab.query (via drBlastTab.query)
      sacCer2.sgdAbundance.name (via drBlastTab.query)
      sacCer2.sgdBlastTab.query (via drBlastTab.query)
      sacCer2.sgdBlastTab.target (via drBlastTab.query)
      sacCer2.sgdCanonical.transcript (via drBlastTab.query)
      sacCer2.sgdDescription.name (via drBlastTab.query)
      sacCer2.sgdGene.name (via drBlastTab.query)
      sacCer2.sgdIsoforms.transcript (via drBlastTab.query)
      sacCer2.sgdLocalization.name (via drBlastTab.query)
      sacCer2.sgdPep.name (via drBlastTab.query)
      sacCer2.sgdToName.name (via drBlastTab.query)
      sacCer2.sgdToPfam.name (via drBlastTab.query)
      sacCer2.sgdToSwissProt.name (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315WENSDART0000003239221.182551895626052490.0000745.8
YMR314WENSDART0000010857552.342351092023402334e-63238
YMR309CENSDART0000012186731.26547347112567943318582e-59228
YHR072W-AENSDART0000013024167.27551800550554e-1680.1
YMR308CENSDART0000005887629.241033686172010281510283e-107387
YMR304WENSDART0000015095338.796293181338662686354e-116417
YMR296CENSDART0000013392734.04470259783550584803e-70263
YMR293CENSDART0000004561534.65430250643457804956e-55212
YMR288WENSDART0000012914053.04856400211797145913150876
YMR301CENSDART0000009116951.775932754896741096998e-168588

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