Schema for mrnaOrientInfo
  Database: bosTau2    Primary Table: mrnaOrientInfo    Row Count: 43,699   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 590smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr8varchar(255) values Reference sequence chromosome or scaffold
chromStart 711724int(10) unsigned range Start position in chromosome
chromEnd 711855int(10) unsigned range End position in chromosome
name BC102586varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 16smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 33smallint(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
        bosTau2.all_mrna.qName (via mrnaOrientInfo.name)
      bosTau2.mgcFullMrna.qName (via mrnaOrientInfo.name)
      bosTau2.mgcGenes.name (via mrnaOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
590chr8711724711855BC1025860160330
797chr142782680327868350NM_001098095924000
73chr1170675271336BC1267354280460
587chr1289232289385BC1267350280460
794chr142751142227519228BC1116621160360
587chr1313819325445NM_0010464076160360
73chr1334164420503D85682300000
73chr1334164420503NM_174468300000
678chr271220766512217067BC1147817160380
73chr1626683699271BC122836216000

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