Schema for flyBaseNoncoding
  Database: dm3    Primary Table: flyBaseNoncoding    Row Count: 1,110   Data last updated: 2008-10-21
Format description: Browser extensible data
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 591smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr2Lvarchar(255) values Reference sequence chromosome or scaffold
chromStart 865365int(10) unsigned range Start position in chromosome
chromEnd 865493int(10) unsigned range End position in chromosome
name CR34660-RAvarchar(255) values Name of item
score 0int(10) unsigned range Optional score, nominal range 0-1000
strand -char(1) values + or -
thickStart 865365int(10) unsigned range Start of where display should be thick (start codon)
thickEnd 865365int(10) unsigned range End of where display should be thick (stop codon)
reserved 0int(10) unsigned range Used as itemRgb as of 2004-11-22
blockCount 1int(10) unsigned range Number of blocks
blockSizes 128,longblob   Comma separated list of block sizes
chromStarts 0,longblob   Start positions relative to chromStart

Connected Tables and Joining Fields
        dm3.arbExpDistance.query (via flyBaseNoncoding.name)
      dm3.arbExpDistance.target (via flyBaseNoncoding.name)
      dm3.ceBlastTab.query (via flyBaseNoncoding.name)
      dm3.drBlastTab.query (via flyBaseNoncoding.name)
      dm3.flyBase2004Xref.name (via flyBaseNoncoding.name)
      dm3.flyBaseBlastTab.query (via flyBaseNoncoding.name)
      dm3.flyBaseBlastTab.target (via flyBaseNoncoding.name)
      dm3.flyBaseCanonical.transcript (via flyBaseNoncoding.name)
      dm3.flyBaseGene.name (via flyBaseNoncoding.name)
      dm3.flyBaseIsoforms.transcript (via flyBaseNoncoding.name)
      dm3.flyBasePep.name (via flyBaseNoncoding.name)
      dm3.flyBaseToCG.name (via flyBaseNoncoding.name)
      dm3.flyBaseToDescription.name (via flyBaseNoncoding.name)
      dm3.flyBaseToPfam.name (via flyBaseNoncoding.name)
      dm3.flyBaseToRefSeq.name (via flyBaseNoncoding.name)
      dm3.flyBaseToUniProt.name (via flyBaseNoncoding.name)
      dm3.flyP2P.query (via flyBaseNoncoding.name)
      dm3.flyP2P.target (via flyBaseNoncoding.name)
      dm3.hgBlastTab.query (via flyBaseNoncoding.name)
      dm3.mmBlastTab.query (via flyBaseNoncoding.name)
      dm3.rnBlastTab.query (via flyBaseNoncoding.name)
      dm3.scBlastTab.query (via flyBaseNoncoding.name)

Sample Rows
 
binchromchromStartchromEndnamescorestrandthickStartthickEndreservedblockCountblockSizeschromStarts
591chr2L865365865493CR34660-RA0-86536586536501128,0,
591chr2L901490901662CR31656-RA0-90149090149001172,0,
595chr2L14327101432921CR31927-RA0+1432710143271001211,0,
598chr2L17891401790361CR31930-RA0-17891401789140011221,0,
599chr2L19380881938159CR31667-RA0-193808819380880171,0,
599chr2L19654251965498CR31942-RA0+196542519654250173,0,
600chr2L20091542009226CR31943-RA0+200915420091540172,0,
600chr2L20095372009609CR31944-RA0+200953720095370172,0,
600chr2L20106452010717CR31939-RA0-201064520106450172,0,
600chr2L20108682010940CR31940-RA0-201086820108680172,0,

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