Skip to main content
Schema for fileLocation
  Database: visiGene    Primary Table: fileLocation    Row Count: 14   Data last updated: 2007-03-12
Format description: Location of image, typically a file directory
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of location
name http://genome.ucsc.edu/visi...longblob   Directory path usually

Connected Tables and Joining Fields
        visiGene.imageFile.fullLocation (via fileLocation.id)
      visiGene.imageFile.thumbLocation (via fileLocation.id)

Sample Rows
 
idname
1http://genome.ucsc.edu/visiGene/full/inSitu/Mouse/mahoney/wholeMount
2http://genome.ucsc.edu/visiGene/200/inSitu/Mouse/mahoney/wholeMount
3http://genome.ucsc.edu/visiGene/full/inSitu/Mouse/mahoney/slices
4http://genome.ucsc.edu/visiGene/200/inSitu/Mouse/mahoney/slices
5http://genome.ucsc.edu/visiGene/full/inSitu/Mouse/jax
6http://genome.ucsc.edu/visiGene/200/inSitu/Mouse/jax
7http://genome.ucsc.edu/visiGene/full/inSitu/XenopusLaevis/nibb
8http://genome.ucsc.edu/visiGene/200/inSitu/XenopusLaevis/nibb
9http://genome.ucsc.edu/visiGene/full/inSitu/Mouse/gensat
10http://genome.ucsc.edu/visiGene/200/inSitu/Mouse/gensat

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