Home     Genomes     Genome Browser     Blat     Tables     PCR     Session    FAQ     Help  
  Schema for gbCdnaInfo
  Database: bosTau4    Primary Table: gbCdnaInfo    Row Count: 3,135,297
Format description: Links together various info associated with a GenBank mRNA or EST
fieldexampleSQL type description
id 1int unsigned Unique numerical id for cDNA
acc AB004856char(12) Genbank/EMBL accession (without .version)
version 1smallint unsigned Version number in Genbank
moddate 2008-11-23date Date last modified, in SQL DATE format/ascii YYYY-MM-DD
type mRNAenum('EST','mRNA') Either EST or mRNA. In SQL an ENUM
direction 0enum('5','3','0') Enum 5, 3 for read direction 5'/3', or 0 unknown.
source 1int unsigned Link to id in source table saying where cDNA came from
organism 1int unsigned Link to id in organism table.
library 0int unsigned Link to id in library table.
mrnaClone 0int unsigned Link to id in mrnaClone table.
sex 0int unsigned Link to id in sex table
tissue 0int unsigned Link to id in tissue table
development 0int unsigned Link to id in development table
cell 0int unsigned Link to id in cell table
cds 1int unsigned Link to id in cds table
keyword 6int unsigned Link to id in keyword table
description 0int unsigned Link to id in description table
geneName 1int unsigned Link to id in geneName table
productName 1int unsigned Link to id in productName table
author 1int unsigned Link to id in author table
gi 3036932int unsigned Genbank identifier
mol mRNAenum('DNA','RNA','ds-RNA','ds-mRNA','ds-rRNA','mRNA','ms-DNA','ms-RNA','rRNA','scRNA','snRNA','snoRNA','ss-DNA','ss-RNA','ss-snoRNA','tRNA','cRNA','ss-cRNA','ds-cRNA') molecule type

  Connected Tables and Joining Fields
        bosTau4.all_est.qName (via gbCdnaInfo.acc)
      bosTau4.all_mrna.qName (via gbCdnaInfo.acc)
      bosTau4.estOrientInfo.name (via gbCdnaInfo.acc)
      bosTau4.gbMiscDiff.acc (via gbCdnaInfo.acc)
      bosTau4.gbSeq.acc (via gbCdnaInfo.acc)
      bosTau4.gbStatus.acc (via gbCdnaInfo.acc)
      bosTau4.gbWarn.acc (via gbCdnaInfo.acc)
      bosTau4.imageClone.acc (via gbCdnaInfo.acc)
      bosTau4.intronEst.qName (via gbCdnaInfo.acc)
      bosTau4.mgcFullMrna.qName (via gbCdnaInfo.acc)
      bosTau4.mgcGenes.name (via gbCdnaInfo.acc)
      bosTau4.mrnaOrientInfo.name (via gbCdnaInfo.acc)
      bosTau4.refFlat.name (via gbCdnaInfo.acc)
      bosTau4.refGene.name (via gbCdnaInfo.acc)
      bosTau4.refLink.mrnaAcc (via gbCdnaInfo.acc)
      bosTau4.refSeqAli.qName (via gbCdnaInfo.acc)
      bosTau4.refSeqStatus.mrnaAcc (via gbCdnaInfo.acc)
      bosTau4.refSeqSummary.mrnaAcc (via gbCdnaInfo.acc)
      bosTau4.xenoMrna.qName (via gbCdnaInfo.acc)
      bosTau4.author.id (via gbCdnaInfo.author)
      bosTau4.cds.id (via gbCdnaInfo.cds)
      bosTau4.cell.id (via gbCdnaInfo.cell)
      bosTau4.description.id (via gbCdnaInfo.description)
      bosTau4.development.id (via gbCdnaInfo.development)
      bosTau4.geneName.id (via gbCdnaInfo.geneName)
      bosTau4.refLink.geneName (via gbCdnaInfo.geneName)
      bosTau4.keyword.id (via gbCdnaInfo.keyword)
      bosTau4.library.id (via gbCdnaInfo.library)
      bosTau4.mrnaClone.id (via gbCdnaInfo.mrnaClone)
      bosTau4.organism.id (via gbCdnaInfo.organism)
      bosTau4.productName.id (via gbCdnaInfo.productName)
      bosTau4.refLink.prodName (via gbCdnaInfo.productName)
      bosTau4.sex.id (via gbCdnaInfo.sex)
      bosTau4.source.id (via gbCdnaInfo.source)
      bosTau4.tissue.id (via gbCdnaInfo.tissue)

  Sample Rows
 
idaccversionmoddatetypedirectionsourceorganismlibrarymrnaClonesextissuedevelopmentcellcdskeyworddescriptiongeneNameproductNameauthorgimol
1AB00485612008-11-23mRNA0110000001601113036932mRNA
2AB00526312008-11-23mRNA0110000002602213036936mRNA
3AB01140712008-11-03mRNA0110000003600314190955mRNA
4AB01214411999-01-24mRNA0220100004403023882098mRNA
5AB01214511999-04-01mRNA0330200005500034730806mRNA
6AB01710912006-11-27mRNA0440000006605444239966mRNA
7AB01962111999-07-01mRNA0550000007700554586513mRNA
8AB02615721999-08-01mRNA0660300008800665811598mRNA
9AB02774212008-11-16mRNA0770400009606776277212mRNA
10AB02774312008-11-16mRNA0880500009606776277218mRNA

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