Schema for genotype
  Database: visiGene    Primary Table: genotype    Row Count: 980   Data last updated: 2006-04-03
Format description: How different from wild type. Associated with genotypeAllele table
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range Genotype ID
taxon 10090int(11) range NCBI Taxon of organism
strain 1int(11) range Strain of organism
alleles wild type,longblob   Comma-separated list of gene:allele in alphabetical order

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

Sample Rows
 
idtaxonstrainalleles
1100901wild type,
2100902
3100903
4100904
5100905
6100906
7100907
8100908
9100909
101009010

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