Schema for estOrientInfo
  Database: oviAri3    Primary Table: estOrientInfo    Row Count: 342,411   Data last updated: 2016-04-29
Format description: Extra information on ESTs - calculated by polyInfo program
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 896smallint(5) unsigned range Indexing field to speed chromosome range queries.
chrom chr11varchar(255) values Reference sequence chromosome or scaffold
chromStart 40786110int(10) unsigned range Start position in chromosome
chromEnd 40786371int(10) unsigned range End position in chromosome
name AF071004varchar(255) values Accession of EST
intronOrientation 0smallint(6) range Orientation of introns with respect to EST
sizePolyA 10smallint(6) range Number of trailing A's
revSizePolyA 0smallint(6) range Number of trailing A's on reverse strand
signalPos 34smallint(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)
      oviAri3.all_est.qName (via estOrientInfo.name)
      oviAri3.intronEst.qName (via estOrientInfo.name)

Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
896chr114078611040786371AF0710040100340
836chr183294365132943818AF0710070120370
2410chr2239210751239210900AF0710060100300
783chr232607448326074667AF07100503000
1329chrX9752356597523824AJ24913200000
1247chr18684940986854452BG874282360270
1252chr18745989487460570BG87427100000
1380chr1104285707104313947BG87424650000
1388chr1105325449105329672BG87428820000
2387chr1236250980236251384BG87428310000

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