Schema for estOrientInfo
  Database: criGriChoV2    Primary Table: estOrientInfo    Row Count: 13   Data last updated: 2018-03-13
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 1363smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom LT883665v1varchar(255) values Reference sequence chromosome or scaffold
chromStart 102000759int(10) unsigned range Start position in chromosome
chromEnd 102002769int(10) unsigned range End position in chromosome
name AF022942varchar(255) values Accession of EST
intronOrientation 2smallint(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
        criGriChoV2.all_est.qName (via estOrientInfo.name)
      criGriChoV2.intronEst.qName (via estOrientInfo.name)
      hgFixed.gbCdnaInfo.acc (via estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
1363LT883665v1102000759102002769AF02294220000
1363LT883665v1102004198102004243AF022941000210
1363LT883665v1102004200102004369AF022941000210
636LT883667v168089806809158AF02294500000
871LT883670v13749518237495288AF02294401000
834LT883677v13276262432766363AF18091811000
767LT883693v12387254223872753AF02293800000
767LT883693v12387280023873722AF022939-10000
767LT883693v12387281423873699AF022940-10000
626LT883710v153867035386792AF02294400100

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