Schema for image
  Database: visiGene    Primary Table: image    Row Count: 124,186   Data last updated: 2007-02-09
Format description: An image. There may be multiple images within an imageFile
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of image
submissionSet 1int(11) range Submission set this is part of
imageFile 1int(11) range ID of image file
imagePos 0int(11) range Position in image file, starting with 0
paneLabel  varchar(255) values Label of this pane in image file
sectionSet 0int(11) range Set of sections this is part of, or 0 if none
sectionIx 0int(11) range Position (0-based) within set of sections
specimen 1int(11) range Pointer to info on specimen
preparation 1int(11) range Pointer to info on how specimen prepared

Connected Tables and Joining Fields
        hg17.knownToVisiGene.value (via image.id)
      hg18.knownToVisiGene.value (via image.id)
      hg19.knownToVisiGene.value (via image.id)
      hg38.knownToVisiGene.value (via image.id)
      knownGeneV39.knownToVisiGene.value (via image.id)
      mm10.knownToVisiGene.value (via image.id)
      mm39.knownToVisiGene.value (via image.id)
      mm7.knownToVisiGene.value (via image.id)
      mm8.knownToVisiGene.value (via image.id)
      mm9.knownToVisiGene.value (via image.id)
      visiGene.imageProbe.image (via image.id)
      visiGene.imageFile.id (via image.imageFile)
      visiGene.imageFileFwd.fromIf (via image.imageFile)
      visiGene.imageFileFwd.toIf (via image.imageFile)
      visiGene.preparation.id (via image.preparation)
      visiGene.sectionSet.id (via image.sectionSet)
      visiGene.specimen.id (via image.specimen)
      visiGene.imageFile.submissionSet (via image.submissionSet)
      visiGene.submissionContributor.submissionSet (via image.submissionSet)
      visiGene.submissionSet.id (via image.submissionSet)

Sample Rows
 
idsubmissionSetimageFileimagePospaneLabelsectionSetsectionIxspecimenpreparation
11100011
21200011
31300011
41400012
51500013
61600012
71700013
81800012
91900013
1011000012

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