Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for estOrientInfo
  Database: bosTau4    Primary Table: estOrientInfo    Row Count: 1,575,361
Format description: Extra information on ESTs - calculated by polyInfo program
fieldexampleSQL type description
bin 753smallint unsigned Indexing field to speed chromosome range queries.
chrom chr11varchar(255) Reference sequence chromosome or scaffold
chromStart 22132846int unsigned Start position in chromosome
chromEnd 22133430int unsigned End position in chromosome
name AA908029varchar(255) Accession of EST
intronOrientation 0smallint Orientation of introns with respect to EST
sizePolyA 0smallint Number of trailing A's
revSizePolyA 6smallint Number of trailing A's on reverse strand
signalPos 0smallint Position of start of polyA signal relative to end of EST or 0 if no signal
revSignalPos 0smallint PolyA signal position on reverse strand if any

  Connected Tables and Joining Fields
        bosTau4.all_est.qName (via estOrientInfo.name)
      bosTau4.gbCdnaInfo.acc (via estOrientInfo.name)
      bosTau4.gbSeq.acc (via estOrientInfo.name)
      bosTau4.gbStatus.acc (via estOrientInfo.name)
      bosTau4.imageClone.acc (via estOrientInfo.name)
      bosTau4.intronEst.qName (via estOrientInfo.name)

  Sample Rows
 
binchromchromStartchromEndnameintronOrientationsizePolyArevSizePolyAsignalPosrevSignalPos
753chr112213284622133430AA90802900600
753chr112213410522134518AA90802800100
755chr112229025222290716AA90802500000
886chr113947629739477847AA961327-2016042
886chr113947629839477844AA9613282190430
959chr114908030949085281AA90802610000
1276chr119066786690668462AA9080190320044
841chr133367810433678529AA9613310017041
841chr133367810533678840AA9613290118041
841chr133367823133678529AA96133000000

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