Schema for estOrientInfo
  Database: felCat3    Primary Table: estOrientInfo    Row Count: 970   Data last updated: 2016-04-09
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 scaffold_212620varchar(255) values Reference sequence chromosome or scaffold
chromStart 679815int(10) unsigned range Start position in chromosome
chromEnd 681029int(10) unsigned range End position in chromosome
name AF034791varchar(255) values Accession of EST
intronOrientation 5smallint(6) range Orientation of introns with respect to EST
sizePolyA 59smallint(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
        felCat3.all_est.qName (via estOrientInfo.name)
      felCat3.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
590scaffold_212620679815681029AF034791559000
585scaffold_2171452235159AF197970125000
585scaffold_987262306597AF1979690120300
585scaffold_10032035223956AW64689200000
585scaffold_1005097136072437AW646840-100022
585scaffold_1006123863638882AW646864000023
585scaffold_100664118059118459AW64694100060
586scaffold_100727191617192132AW64679900000
586scaffold_100727192255192418AW64678800000
585scaffold_1007813235232725AW646947010021

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