Schema for D. mel. cDNAs - cDNAs from D. melanogaster
  Database: dm3gene    Primary Table: dmel_cdna    Row Count: 7
fieldexampleSQL type info
bin 585smallint(5) unsigned range
matches 2194int(10) unsigned range
misMatches 12int(10) unsigned range
repMatches 0int(10) unsigned range
nCount 0int(10) unsigned range
qNumInsert 0int(10) unsigned range
qBaseInsert 0int(10) unsigned range
tNumInsert 4int(10) unsigned range
tBaseInsert 789int(10) unsigned range
strand -char(2) values
qName AY069466varchar(255) values
qSize 2233int(10) unsigned range
qStart 0int(10) unsigned range
qEnd 2206int(10) unsigned range
tName contig1varchar(255) values
tSize 11000int(10) unsigned range
tStart 439int(10) unsigned range
tEnd 3434int(10) unsigned range
blockCount 5int(10) unsigned range
blockSizes 721,218,1123,110,34,longblob  
qStarts 27,748,966,2089,2199,longblob  
tStarts 439,1239,1582,2764,3400,longblob  

Sample Rows
 
binmatchesmisMatchesrepMatchesnCountqNumInsertqBaseInserttNumInserttBaseInsertstrandqNameqSizeqStartqEndtNametSizetStarttEndblockCountblockSizesqStartstStarts
58521941200004789-AY069466223302206contig11100043934345721,218,1123,110,34,27,748,966,2089,2199,439,1239,1582,2764,3400,
585359943000071394-AY0955303680173659contig11100043954758721,218,1123,110,407,716,173,174,21,742,960,2083,2193,2600,3316,3489,439,1239,1582,2764,3400,3866,4641,5301,
585360042000071394-BT0441403680173659contig11100043954758721,218,1123,110,407,716,173,174,21,742,960,2083,2193,2600,3316,3489,439,1239,1582,2764,3400,3866,4641,5301,
5852330000004789-BT150059234702330contig11100044435635716,218,1123,110,163,17,733,951,2074,2184,444,1239,1582,2764,3400,
5853641000002122+AF145687366303641contig11100059329695387,757,2797,0,87,844,5932,6080,6898,
5853438000002122+FJ6301493472163454contig11100059349494385,757,2596,16,101,858,5934,6080,6898,
585848400002130+BT0287748850852contig111000986410846333,579,240,0,33,612,9864,9970,10606,

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

D. mel. cDNAs (dmel_cdna) Track Description
 

Description

This track shows the alignments between Drosophila cDNAs in GenBank and the D. melanogaster genome.