Schema for estOrientInfo
  Database: vicPac1    Primary Table: estOrientInfo    Row Count: 1,339   Data last updated: 2016-04-24
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom scaffold_1745varchar(255) values Reference sequence chromosome or scaffold
chromStart 74433int(10) unsigned range Start position in chromosome
chromEnd 74549int(10) unsigned range End position in chromosome
name EH218995varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 33smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 57smallint(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 estOrientInfo.name)
      hgFixed.gbSeq.acc (via estOrientInfo.name)
      hgFixed.imageClone.acc (via estOrientInfo.name)
      vicPac1.all_est.qName (via estOrientInfo.name)
      vicPac1.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
585scaffold_17457443374549EH2189950330570
585scaffold_1874937325409EH219024430000
585scaffold_190307791103EH2189992232350
585scaffold_1928510481147EH219010020000
585scaffold_2069235592481EH21901005000
585scaffold_218739121189EH218980030000
586scaffold_2340190019191697EH219024430000
585scaffold_2403152525342EH2189990282350
586scaffold_2413242339242410EH219014019000
585scaffold_266619489668EH2189980210470

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