Schema for estOrientInfo
  Database: susScr3    Primary Table: estOrientInfo    Row Count: 1,694,980   Data last updated: 2015-04-03
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
chrom GL892953-2varchar(255) Reference sequence chromosome or scaffold
chromStart 105417int(10) unsigned Start position in chromosome
chromEnd 105873int(10) unsigned End position in chromosome
name AA056899varchar(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)
      susScr3.all_est.qName (via estOrientInfo.name)
      susScr3.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585GL892953-2105417105873AA05689900000
585GL895031-237204054AA06366700000
585GL896052-23915639341AA06365500000
585GL896358-119242093AA06364900000
585GL896532-181471AA06366100000
1291chr19258172592582086AA05688600000
178chr1110359280110363405AA05691330000
1427chr1110410114110410531AA056914000013
2768chr1286250480286250740AA056891000180
735chr101969620619696398AA063650000016

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