Schema for strain
  Database: visiGene    Primary Table: strain    Row Count: 339   Data last updated: 2006-04-03
Format description: Name of strain (eg C57BL for a mouse)
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of strain
taxon 10090int(11) range NCBI taxon of organism
name C57BLvarchar(255) values Name of strain

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

Sample Rows
 
idtaxonname
110090C57BL
210090(C57BL/6 x CBA)F1
310090NMRI
410090either: BALB/c or C57BL/6J
510090involves: C57BL/Ws * CBA/Ca
610090(Parkes x NIH)F1
710090(C57BL/6 x SJL)F1
810090(ICR x Swiss Webster)F1
910090Swiss
1010090either: C57BL/6 or Swiss

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