Schema for specimen
  Database: visiGene    Primary Table: specimen    Row Count: 4,766   Data last updated: 2006-06-07
Format description: A biological specimen - something mounted, possibly sliced up
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range Specimen ID
name  varchar(255) values Name of specimen, frequently blank
taxon 10090int(11) range NCBI Taxon of organism
genotype 1int(11) range Genotype of specimen
bodyPart 1int(11) range Body part of specimen
sex 0int(11) range Sex - male, female or hermaphrodite
age 10.5float range Age in days since conception
minAge 10float range Minimum age
maxAge 11float range Maximum age - may differ from minAge if uncertain of age
notes  longblob   Any notes on specimen

Connected Tables and Joining Fields
        visiGene.bodyPart.id (via specimen.bodyPart)
      visiGene.expressionLevel.bodyPart (via specimen.bodyPart)
      visiGene.genotype.id (via specimen.genotype)
      visiGene.genotypeAllele.genotype (via specimen.genotype)
      visiGene.image.specimen (via specimen.id)
      visiGene.sex.id (via specimen.sex)
      uniProt.accToTaxon.taxon (via specimen.taxon)
      uniProt.commonName.taxon (via specimen.taxon)
      uniProt.taxon.id (via specimen.taxon)
      visiGene.antibody.taxon (via specimen.taxon)
      visiGene.gene.taxon (via specimen.taxon)
      visiGene.genotype.taxon (via specimen.taxon)
      visiGene.lifeStageScheme.taxon (via specimen.taxon)
      visiGene.lifeTime.taxon (via specimen.taxon)
      visiGene.strain.taxon (via specimen.taxon)

Sample Rows
 
idnametaxongenotypebodyPartsexageminAgemaxAgenotes
11009011010.51011
21009012013.51314
310090120191920
41009020012.512.512.5
51009020112.512.512.5
61009030010.510.510.5
71009030011.511.511.5
81009030012.512.512.5
91009030014.514.514.5
101009030017.517.517.5

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