Schema for drBlastTab
  Database: rn4    Primary Table: drBlastTab    Row Count: 8,930   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 RGD:2174varchar(255) values Name of sequence in this assembly (query)
target ENSDART00000047201varchar(255) values Name of sequence in other assembly (target)
identity 86.96float range Percent identity
aliLength 1043int(10) unsigned range Length of alignment
mismatch 128int(10) unsigned range Number of mismatches
gapOpen 3int(10) unsigned range Number of gap openings
qStart 0int(10) unsigned range Start in query (0 based)
qEnd 1043int(10) unsigned range End in query (non-inclusive)
tStart 0int(10) unsigned range Start in target (0 based)
tEnd 1035int(10) unsigned range End in target (non-inclusive)
eValue 0double range Expectation value
bitScore 1789double range Bit score

Connected Tables and Joining Fields
        rn4.affyExonTissuesGsMedianDistRgdGene2.query (via drBlastTab.query)
      rn4.affyExonTissuesGsMedianDistRgdGene2.target (via drBlastTab.query)
      rn4.affyExonTissuesGsMedianRgdGene2.name (via drBlastTab.query)
      rn4.affyExonTissuesGsRgdGene2.name (via drBlastTab.query)
      rn4.ceBlastTab.query (via drBlastTab.query)
      rn4.dmBlastTab.query (via drBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.query (via drBlastTab.query)
      rn4.gnfAtlas2RgdGene2Distance.target (via drBlastTab.query)
      rn4.hgBlastTab.query (via drBlastTab.query)
      rn4.mmBlastTab.query (via drBlastTab.query)
      rn4.rgdGene2.name (via drBlastTab.query)
      rn4.rgdGene2BlastTab.query (via drBlastTab.query)
      rn4.rgdGene2BlastTab.target (via drBlastTab.query)
      rn4.rgdGene2Canonical.transcript (via drBlastTab.query)
      rn4.rgdGene2Isoforms.transcript (via drBlastTab.query)
      rn4.rgdGene2KeggPathway.rgdId (via drBlastTab.query)
      rn4.rgdGene2Pep.name (via drBlastTab.query)
      rn4.rgdGene2ToDescription.name (via drBlastTab.query)
      rn4.rgdGene2ToDisplayId.name (via drBlastTab.query)
      rn4.rgdGene2ToEnsembl.name (via drBlastTab.query)
      rn4.rgdGene2ToGenbank.name (via drBlastTab.query)
      rn4.rgdGene2ToGenbankAll.name (via drBlastTab.query)
      rn4.rgdGene2ToGnfAtlas2.name (via drBlastTab.query)
      rn4.rgdGene2ToKeggEntrez.name (via drBlastTab.query)
      rn4.rgdGene2ToLocusLink.name (via drBlastTab.query)
      rn4.rgdGene2ToPDB.name (via drBlastTab.query)
      rn4.rgdGene2ToPfam.name (via drBlastTab.query)
      rn4.rgdGene2ToRAE230.name (via drBlastTab.query)
      rn4.rgdGene2ToRefSeq.name (via drBlastTab.query)
      rn4.rgdGene2ToSymbol.rgdId (via drBlastTab.query)
      rn4.rgdGene2ToU34A.name (via drBlastTab.query)
      rn4.rgdGene2ToUniProt.name (via drBlastTab.query)
      rn4.rgdGene2Xref.rgdGeneId (via drBlastTab.query)
      rn4.rgdGenePathway.geneId (via drBlastTab.query)
      rn4.scBlastTab.query (via drBlastTab.query)

Sample Rows
 
querytargetidentityaliLengthmismatchgapOpenqStartqEndtStarttEndeValuebitScore
RGD:2174ENSDART0000004720186.9610431283010430103501789
RGD:2172ENSDART0000002254953.03264119313276152751e-78290
RGD:2171ENSDART0000009782257.0928211041628882892e-90329
RGD:2169ENSDART0000010495090.9599490019101329102301784
RGD:2170ENSDART0000013938757.9129712316303203156e-99357
RGD:2168ENSDART0000009329886.0810201391010200101701727
RGD:2167ENSDART0000008104788.0410281182010230102801769
RGD:2163ENSDART0000003990369.4927283014041202723e-113405
RGD:2162ENSDART0000012465271.45561581055605550793
RGD:2160ENSDART0000014935541.491881091902771052933e-41166

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