Schema for expressionLevel
  Database: visiGene    Primary Table: expressionLevel    Row Count: 221,630   Data last updated: 2006-06-07
Format description: Annotated expression level if any
On download server: MariaDB table dump directory
fieldexampleSQL type info description
imageProbe 54122int(11) range Image and probe
bodyPart 758int(11) range Location of expression
level 1float range Expression level (0.0 to 1.0)
cellType 3int(11) range Cell type expression seen in
cellSubtype 0int(11) range Cell subtype expression seen in
expressionPattern 0int(11) range  

Connected Tables and Joining Fields
        visiGene.bodyPart.id (via expressionLevel.bodyPart)
      visiGene.specimen.bodyPart (via expressionLevel.bodyPart)
      visiGene.cellSubtype.id (via expressionLevel.cellSubtype)
      visiGene.cellType.id (via expressionLevel.cellType)
      visiGene.expressionPattern.id (via expressionLevel.expressionPattern)
      visiGene.imageProbe.id (via expressionLevel.imageProbe)

Sample Rows
 
imageProbebodyPartlevelcellTypecellSubtypeexpressionPattern
541227581300
541227571300
541217581300
541217571300
541207581300
541207571300
541197561200
541197501200
54119801210
541193421200

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