Schema for mrnaOrientInfo
  Database: panTro1    Primary Table: mrnaOrientInfo    Row Count: 6,890   Data last updated: 2020-08-22
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 589smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
chromStart 618093int(10) unsigned range Start position in chromosome
chromEnd 618207int(10) unsigned range End position in chromosome
name AK305871varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 18smallint(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
        hgFixed.gbCdnaInfo.acc (via mrnaOrientInfo.name)
      hgFixed.gbSeq.acc (via mrnaOrientInfo.name)
      hgFixed.imageClone.acc (via mrnaOrientInfo.name)
      panTro1.all_mrna.qName (via mrnaOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
589chr1618093618207AK305871018000
590chr1712281715628AK305017116000
590chr1712281718366AK305801215000
590chr1712281718420AK305124216000
590chr1712286715607AK304952117000
590chr1712303719071AK305316417000
592chr1938226972523AK305466917000
592chr1938237948977AK306029744000
592chr110292821029371FZ42713700000
593chr111161541135419AK306358417000

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