Schema for probe
  Database: visiGene    Primary Table: probe    Row Count: 26,611   Data last updated: 2007-02-09
Format description: Info on a probe
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of probe
gene 1int(11) range Associated gene, if any
antibody 0int(11) range Associated antibody, if any
probeType 1int(11) range Type of probe - antibody, RNA, etc.
fPrimer CCGGAATTCGGAATCCGGATGGTTTGA...varchar(255) values Forward PCR primer, if any
rPrimer CCCAAGCTTATGGCAGTAGGTGAGCTC...varchar(255) values Reverse PCR primer, if any
seq  longblob   Associated sequence, if any
bac 0int(11) range  

Connected Tables and Joining Fields
        visiGene.antibody.id (via probe.antibody)
      visiGene.antibodySource.antibody (via probe.antibody)
      visiGene.bac.id (via probe.bac)
      visiGene.allele.gene (via probe.gene)
      visiGene.gene.id (via probe.gene)
      visiGene.geneSynonym.gene (via probe.gene)
      visiGene.imageProbe.probe (via probe.id)
      visiGene.vgPrbMap.probe (via probe.id)
      visiGene.probeType.id (via probe.probeType)

Sample Rows
 
idgeneantibodyprobeTypefPrimerrPrimerseqbac
1101CCGGAATTCGGAATCCGGATGGTTTGAGAGCCCCAAGCTTATGGCAGTAGGTGAGCTCAGGC0
2201CGCGGATCCAAGGACATCTTGGACCTTCCGCCCAAGCTTGCATGTGCTGCAGCGACTGCG0
3301CGCGGATCCGAACAGGATGCGAAGCCTAGGGCCCAAGCTTACCAGTTCCAGGAGACCAGAGC0
4401CCGGAATTCGGAAGAGGAAGAGGACGACGACCCCAAGCTTGGACTCTCGTGGTAGAGCACCGG0
5501CGCGGATCCTGGAGGAGAGTGAGGACTTCGCCCGCTCGAGTCTCCCACTGATGGTACTAGC0
6601CGCGGATCCTGACGCACTTGGAGCCAAAGGCCCAAGCTTGAAGGAGTGGTTGTTGCCCAGC0
7701CCGGAATTCAAGGGCTCCTACTGGACGCTGCCCCAAGCTTGCACGGGTCTGGAATACACACC0
8801CGCGGATCCACATCTCGCTCATCACCATGGCCCCAAGCTTGTGCATGACCTGTTCGTAGGCC0
9901CGCGGATCCTGGACCGCTTCCCCTACTACCGCCCAAGCTTGGCGAGTTCGAGAGCAGGGTGG0
101001TGCTCTAGAACGCAGTGAAGGACAAGGAGGCCGCTCGAGAGAGCTGCTGCTGGTCGCTGG0

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