Schema for mrnaOrientInfo
  Database: droYak1    Primary Table: mrnaOrientInfo    Row Count: 914   Data last updated: 2019-06-30
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 586smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr2Lvarchar(255) values Reference sequence chromosome or scaffold
chromStart 149475int(10) unsigned range Start position in chromosome
chromEnd 149851int(10) unsigned range End position in chromosome
name AY232141varchar(255) values Accession of EST
intronOrientation 1smallint(6) range Orientation of introns with respect to EST
sizePolyA 0smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 0smallint(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
        droYak1.all_mrna.qName (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
586chr2L149475149851AY23214110000
588chr2L412663413147AY23179110000
597chr2L16080851609081AY23204110000
602chr2L22531232253579AY23212200000
602chr2L22596262260082AY23212200000
603chr2L23846592385397AY23202920000
603chr2L23949792396668AJ86823210000
604chr2L25926002593787AF53200710000
604chr2L25969602597578AY23219630000
606chr2L27799562782801AY23185820000

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