Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for gbStatus
  Database: bosTau4    Primary Table: gbStatus    Row Count: 3,135,297
fieldexampleSQL type
acc NM_001001133char(12)
version 1smallint unsigned
modDate 2007-05-14date
type mRNAenum('EST','mRNA')
srcDb RefSeqenum('GenBank','RefSeq')
orgCat nativeenum('native','xeno')
gbSeq 2787313int unsigned
numAligns 1int unsigned
seqRelease 27char(8)
seqUpdate fullchar(10)
metaRelease 27char(8)
metaUpdate fullchar(10)
extRelease 27char(8)
extUpdate fullchar(10)
time 2008-03-12 05:22:17timestamp

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

  Sample Rows
 
accversionmodDatetypesrcDborgCatgbSeqnumAlignsseqReleaseseqUpdatemetaReleasemetaUpdateextReleaseextUpdatetime
NM_00100113312007-05-14mRNARefSeqnative2787313127full27full27full2008-03-12 05:22:17
NM_00100113412007-05-14mRNARefSeqnative2787847127full27full27full2008-03-12 05:22:17
NM_00100113522009-04-14mRNARefSeqnative2784745127full35full35full2009-05-16 13:07:16
NM_00100113622008-01-24mRNARefSeqnative2796833127full27full27full2008-03-12 05:22:17
NM_00100113712007-12-24mRNARefSeqnative2791011127full27full27full2008-03-12 05:22:17
NM_00100113812007-08-25mRNARefSeqnative2788659127full27full27full2008-03-12 05:22:17
NM_00100113912008-12-04mRNARefSeqnative2791245127full33full33full2009-01-25 07:25:18
NM_00100114112007-12-24mRNARefSeqnative2791013127full27full27full2008-03-12 05:22:17
NM_00100114212008-09-22mRNARefSeqnative2784131127full31full31full2008-10-24 13:02:25
NM_00100114322008-10-02mRNARefSeqnative2779551127full32full32full2008-11-23 00:33:11

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