Classify EM parameters depending on its class

[antolinos]

There are some parameters that seem to belong to either movie or acquisition however today most of them are in the same table. List of parameters that need classification:

magnification (unit: X)
total_absorbed_dose (Unit: e-/A^2 for EM)
binning (1 or 2. Number of pixels to process as 1. (Use mean value.)
particle_diameter (Unit: nm)
box_size_ctf (Unit: pixels)
min_resolution (Unit: A)
min_defocus (Unit: A)
max_defocus (Unit: A)
defocus_step_size (Unit: A)
amount_astigmatism (Unit: A)
extract_size (Unit: pixels)
bg_radius (Unit: nm)
voltage (Unit: kV)
obj_aperture (Unit: um)
c1aperture (Unit: um)
c2aperture (Unit: um)
c3aperture (Unit: um)
c1lens (Unit: %)
c2lens (Unit: %)
c3lens (Unit: %)
FFT of the raw micrograph
FFT of the (motion?) corrected micrograph
full path to a .png of the summed (motion?) corrected micrograph

Proposed hierarchy:

[antolinos]

First iteration, information about particles are omitted.

Two more tables have been created:

Micrograph 1 -----  N Movie
CTF 1 ---- micrograph

Comments about some params:

box_size_ctf to be saved within the output files
min_resolution needs a definition (It is probably coming from MX)

Data model is now like:

[antolinos]

Second iteration:

[antolinos]

3rd Iteration:

[stufisher]

Hello all,

I have taken Alex's model above, input from our EM and SciSoft staff here at DLS, and input from EM people on the EPN campus and mapped this against the existing ISPyB database structure. I think what we have is pretty complete. I have tried to annotate what i can, if anything doesnt make sense please shout. There will probably be some further minor changes to this. Tables in yellow will not be implemented at this time as it seems the software architecture is moving very fast.

Ta Stu

[antolinos]

Thanks for this! Should it be moved to https://github.com/ispyb/ispyb-database-modeling?

[stufisher]

Yep sounds good. I am on site if you want to have a chat about this too