Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for gbSeq
  Database: bosTau4    Primary Table: gbSeq    Row Count: 3,145,129
fieldexampleSQL type
id 1int unsigned
acc AB004856char(12)
version 1smallint unsigned
size 297int unsigned
gbExtFile 1251int unsigned
file_offset 8881bigint
file_size 315int unsigned
type mRNAenum('EST','mRNA','PEP')
srcDb GenBankenum('GenBank','RefSeq','Other')

  Connected Tables and Joining Fields
        bosTau4.all_est.qName (via gbSeq.acc)
      bosTau4.all_mrna.qName (via gbSeq.acc)
      bosTau4.estOrientInfo.name (via gbSeq.acc)
      bosTau4.gbCdnaInfo.acc (via gbSeq.acc)
      bosTau4.gbStatus.acc (via gbSeq.acc)
      bosTau4.imageClone.acc (via gbSeq.acc)
      bosTau4.intronEst.qName (via gbSeq.acc)
      bosTau4.mgcFullMrna.qName (via gbSeq.acc)
      bosTau4.mgcGenes.name (via gbSeq.acc)
      bosTau4.mrnaOrientInfo.name (via gbSeq.acc)
      bosTau4.refFlat.name (via gbSeq.acc)
      bosTau4.refGene.name (via gbSeq.acc)
      bosTau4.refLink.mrnaAcc (via gbSeq.acc)
      bosTau4.refSeqAli.qName (via gbSeq.acc)
      bosTau4.refSeqStatus.mrnaAcc (via gbSeq.acc)
      bosTau4.refSeqSummary.mrnaAcc (via gbSeq.acc)
      bosTau4.xenoMrna.qName (via gbSeq.acc)
      bosTau4.gbExtFile.id (via gbSeq.gbExtFile)

  Sample Rows
 
idaccversionsizegbExtFilefile_offsetfile_sizetypesrcDb
1AB004856129712518881315mRNAGenBank
2AB005263114312519196158mRNAGenBank
3AB011407143112519650452mRNAGenBank
4AB012144111311251101021166mRNAGenBank
5AB012145111091251112681144mRNAGenBank
6AB017109143471251235024446mRNAGenBank
7AB0196211652125132496678mRNAGenBank
8AB026157216211251435441666mRNAGenBank
9AB0277421430125145210451mRNAGenBank
10AB0277431430125145661451mRNAGenBank

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