Schema for mmBlastTab
  Database: sacCer3    Primary Table: mmBlastTab    Row Count: 2,366   Data last updated: 2022-07-12
Format description: Blast alignments of Mouse genes
On download server: MariaDB table dump directory
fieldexampleSQL type info description
query YMR315Wvarchar(255) values Name of sequence in this assembly (query)
target ENSMUST00000011526.7varchar(255) values Name of sequence in other assembly (target)
identity 28.4float range Percent identity
aliLength 243int(10) unsigned range Length of alignment
mismatch 145int(10) unsigned range Number of mismatches
gapOpen 12int(10) unsigned range Number of gap openings
qStart 3int(10) unsigned range Start in query (0 based)
qEnd 235int(10) unsigned range End in query (non-inclusive)
tStart 2int(10) unsigned range Start in target (0 based)
tEnd 227int(10) unsigned range End in target (non-inclusive)
eValue 0.000001double range Expectation value
bitScore 52double range Bit score

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

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
YMR315WENSMUST00000011526.728.424314512323522270.00000152
YMR314WENSMUST00000033008.1053.192351072023402334e-68255
YMR309CENSMUST00000032992.730.3538338112567803298444e-58224
YHR072W-AENSMUST00000028553.460.34582300580580.0000000000000972.8
YMR308CENSMUST00000032898.929.381045669192010281910322e-107388
YMR304WENSMUST00000161046.930.081157604293811726810438e-123439
YMR296CENSMUST00000021920.834.39471258783551474705e-74276
YMR292WENSMUST00000032372.742.64129740213131320.000000451.2
YMR293CENSMUST00000020012.733.954332511043457674842e-56217
YMR288WENSMUST00000027127.1453.47849393212497145513040899

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