Schema for mrnaOrientInfo
  Database: dm2    Primary Table: mrnaOrientInfo    Row Count: 131,432   Data last updated: 2020-08-21
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr2Lvarchar(255) values Reference sequence chromosome or scaffold
chromStart 7528int(10) unsigned range Start position in chromosome
chromEnd 9484int(10) unsigned range End position in chromosome
name BT023872varchar(255) values Accession of EST
intronOrientation 1smallint(6) range Orientation of introns with respect to EST
sizePolyA 26smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 44smallint(6) range Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) range PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        dm2.all_mrna.qName (via mrnaOrientInfo.name)
      dm2.flyBaseToRefSeq.value (via mrnaOrientInfo.name)
      dm2.refFlat.name (via mrnaOrientInfo.name)
      dm2.refGene.name (via mrnaOrientInfo.name)
      dm2.refSeqAli.qName (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)
      hgFixed.refLink.mrnaAcc (via mrnaOrientInfo.name)
      hgFixed.refSeqStatus.mrnaAcc (via mrnaOrientInfo.name)
      hgFixed.refSeqSummary.mrnaAcc (via mrnaOrientInfo.name)
      knownGeneV39.kgXref.refseq (via mrnaOrientInfo.name)
      knownGeneV39.knownToRefSeq.value (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585chr2L75289484BT0238721260440
719chr2L1758533017587196NM_078868100190
740chr3L2034744420353236BT12638130000
666chr2R1073188610732480NM_13717800000
690chr2L1380362513809994NM_07883720000
585chr2L984118562X054268200410
585chr2L1070218560AY0516548190430
654chr2R90718559073249NM_137043000210
585chr2L2195124237BT0227921180350
585chr2L2539959242AY12946112140340

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