Schema for estOrientInfo
  Database: xenLae2    Primary Table: estOrientInfo    Row Count: 723,751   Data last updated: 2018-10-02
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 709smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom chr1Lvarchar(255) Reference sequence chromosome or scaffold
chromStart 16311076int(10) unsigned Start position in chromosome
chromEnd 16312467int(10) unsigned End position in chromosome
name AB047065varchar(255) Accession of EST
intronOrientation 0smallint(6) Orientation of introns with respect to EST
sizePolyA 0smallint(6) Number of trailing A's
revSizePolyA 0smallint(6) Number of trailing A's on reverse strand
signalPos 0smallint(6) Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint(6) PolyA signal position on reverse strand if any

Connected Tables and Joining Fields
        hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      xenLae2.all_est.qName (via estOrientInfo.name)
      xenLae2.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
709chr1L1631107616312467AB04706500000
1194chr1L7988135979881480AB09238400000
1376chr1L103807794103807939AB09235501904224
1568chr1L128846607128846726AB092383011000
1569chr1L129000461129000561AB09236000000
1738chr1L151165570151165752AB09238210000
1751chr1L152847253152847368AB0923870150390
1821chr1L162052819162053251AB09235600000
1005chr1S5509678855098872AB092403100180
1282chr1S9144667191446823AB0923850140330

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