[Gusdev-gusdev] RAD3 Schema Question

[Paul B. <pcb...@en...>]

Hi again all,

One more question about the RAD3 schema, if I may:

The BioMaterialImp table has three main views:
- BioSource	==> raw sample
- BioSample	==> treated sample
- LabeledExtract	==> labeled sample

How can I relate the bio_material_id of a BioSource with those of its 
BioSamples and LabeledExtracts?  The treatment table appears to detail the 
treatments performed on a BioSource, but not what the resulting BioSample is 
called.

Let me specify the biological case, in case I'm being unclear.  We have animals 
(BioSources) that are sacrificed, and the resulting tissues handled in 
different ways (BioSamples), then labeled (LabeledExtracts) and run on arrays.  
I'm struggling to see how to relate a particular BioSource to all the 
BioSamples that have been derived from it.  The same idea could correspond to, 
for instance, taking different tissues from the same animal.

Thanks in advance for any suggestions/explanations -- very much appreciated.
Paul

----------------------------------------
This mail sent through www.mywaterloo.ca