Home    Target List    Selection    Community Requests    Clones    Screenings    XML files    Diffraction Images    Progress    Homolog Search    Clustering    Statistics    News    Help    Log In

Crystallization Drop

Target
IDP90797  
Crystallization Drop ID
A3001  
Local Crystallization Drop ID
3001  
Purification
151mg/mL (Nov 13, 2009)  
Experiment Date
Nov 18, 2009  
Person
Magdalena Makowska-Grzyska  
Lab
Argonne National Laboratory  
Protocol
standard crystallization_ANL  
Status
crystal  
Method
sitting drop  
Protein Volume (μL)
0.4  
Precip Volume (μL)
0.4  
Screen
ANL-1  
Screen Component
32  
Reservoir Volume (μL)
135  
Growth Time
3 days  
Incubation Temperature (K)
18  
Plate Type
CrystalQuick standard profile, LBR round bottom plate  
Inserted
Jul 29, 2011  
(default) 62 queries took 338 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts';0922
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'crystallization_drop' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0348
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'purification' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0318
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'expression' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0328
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'protein_target' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position09412
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'protein_pdb_homolog_table' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position056
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'tigr_main_roles' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position026
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'tigr_sub_roles' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position026
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'names' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position046
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'stage' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position026
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'request_target' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0207
12SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'request_person' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position077
13SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'target_planning' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0167
14SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'protein_subtarget' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0157
15SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'protein_subtarget_assignment' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position067
16SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'clone' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0398
17SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'lab' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position077
18SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'staff' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0197
19SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'center_user' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position087
20SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'crystal_harvest' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0278
21SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'protocol' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0107
22SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'dataset' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0569
23SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'structure_solution' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0248
24SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'software' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0127
25SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'structure' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0469
26SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'deposit' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0197
27SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'pdbstructures' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0227
28SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'pdbchains' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0227
29SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'ligand' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position097
30SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'deposit_ligand' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position056
31SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'detector' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position077
32SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'beamline' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position046
33SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'synchrotron' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position067
34SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'mr_clone' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0107
35SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vs_assay' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0157
36SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'library' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position056
37SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vs_assay_data' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position097
38SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'substance' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0137
39SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'justification_code' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position046
40SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'justification_code_map' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position036
41SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'hsqc' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0167
42SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'nmr_structure' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0147
43SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'nmr_deposit' AND (table_schema = 'public' OR table_schema = 'mr' OR table_schema = 'csgid' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'mypdb' OR table_schema = 'tigr' OR table_schema = 'community' OR table_schema = 'homology' OR table_schema = 'ncbi' OR table_schema = 'experiments' OR table_schema = 'users' OR table_schema = 'synchrotrons' OR table_schema = 'targets' OR table_schema = 'hts') ORDER BY position0177
44SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager" FROM "center_user" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
45SELECT "CrystallizationDrop"."id" AS "CrystallizationDrop__id", "CrystallizationDrop"."target_id" AS "CrystallizationDrop__target_id", "CrystallizationDrop"."crystallization_drop_suffix" AS "CrystallizationDrop__crystallization_drop_suffix", "CrystallizationDrop"."purification_id" AS "CrystallizationDrop__purification_id", "CrystallizationDrop"."local_purification_id" AS "CrystallizationDrop__local_purification_id", "CrystallizationDrop"."local_protein_target_id" AS "CrystallizationDrop__local_protein_target_id", "CrystallizationDrop"."local_crystallization_drop" AS "CrystallizationDrop__local_crystallization_drop", "CrystallizationDrop"."experiment_date" AS "CrystallizationDrop__experiment_date", "CrystallizationDrop"."staff_id" AS "CrystallizationDrop__staff_id", "CrystallizationDrop"."other_people" AS "CrystallizationDrop__other_people", "CrystallizationDrop"."lab_id" AS "CrystallizationDrop__lab_id", "CrystallizationDrop"."protocol_id" AS "CrystallizationDrop__protocol_id", "CrystallizationDrop"."status" AS "CrystallizationDrop__status", "CrystallizationDrop"."method" AS "CrystallizationDrop__method", "CrystallizationDrop"."drop_protein_volume" AS "CrystallizationDrop__drop_protein_volume", "CrystallizationDrop"."drop_precip_volume" AS "CrystallizationDrop__drop_precip_volume", "CrystallizationDrop"."drop_precip_contents" AS "CrystallizationDrop__drop_precip_contents", "CrystallizationDrop"."screen" AS "CrystallizationDrop__screen", "CrystallizationDrop"."screen_component" AS "CrystallizationDrop__screen_component", "CrystallizationDrop"."ph" AS "CrystallizationDrop__ph", "CrystallizationDrop"."reservoir_volume" AS "CrystallizationDrop__reservoir_volume", "CrystallizationDrop"."growth_time" AS "CrystallizationDrop__growth_time", "CrystallizationDrop"."plate_type" AS "CrystallizationDrop__plate_type", "CrystallizationDrop"."incubation_temperature" AS "CrystallizationDrop__incubation_temperature", "CrystallizationDrop"."inserted" AS "CrystallizationDrop__inserted", "CrystallizationDrop"."ins_user_id" AS "CrystallizationDrop__ins_user_id", "CrystallizationDrop"."update" AS "CrystallizationDrop__update", "CrystallizationDrop"."upd_user_id" AS "CrystallizationDrop__upd_user_id", "CrystallizationDrop"."present_in_lims" AS "CrystallizationDrop__present_in_lims", "CrystallizationDrop"."proteolysis_enzyme" AS "CrystallizationDrop__proteolysis_enzyme", "CrystallizationDrop"."modification" AS "CrystallizationDrop__modification", "CrystallizationDrop"."lims_date" AS "CrystallizationDrop__lims_date", "CrystallizationDrop"."dummy" AS "CrystallizationDrop__dummy", "CrystallizationDrop"."protein_concentration" AS "CrystallizationDrop__protein_concentration", "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield", "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Protocol"."id" AS "Protocol__id", "Protocol"."short" AS "Protocol__short", "Protocol"."type" AS "Protocol__type", "Protocol"."name" AS "Protocol__name", "Protocol"."description" AS "Protocol__description", "Protocol"."lab_id" AS "Protocol__lab_id", "Protocol"."staff_id" AS "Protocol__staff_id", "Protocol"."inserted" AS "Protocol__inserted", "Protocol"."updated" AS "Protocol__updated", "Protocol"."targettrack" AS "Protocol__targettrack" FROM "crystallization_drop" AS "CrystallizationDrop" LEFT JOIN "purification" AS "Purification" ON ("CrystallizationDrop"."purification_id" = "Purification"."id") LEFT JOIN "lab" AS "Lab" ON ("CrystallizationDrop"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("CrystallizationDrop"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("CrystallizationDrop"."protocol_id" = "Protocol"."short") WHERE "CrystallizationDrop"."id" = '213428' LIMIT 1012
46SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."crystallization_drop_id" = ('213428') 002
47SELECT "CrystallizationDrop"."id" AS "CrystallizationDrop__id", "CrystallizationDrop"."target_id" AS "CrystallizationDrop__target_id", "CrystallizationDrop"."crystallization_drop_suffix" AS "CrystallizationDrop__crystallization_drop_suffix", "CrystallizationDrop"."purification_id" AS "CrystallizationDrop__purification_id", "CrystallizationDrop"."local_purification_id" AS "CrystallizationDrop__local_purification_id", "CrystallizationDrop"."local_protein_target_id" AS "CrystallizationDrop__local_protein_target_id", "CrystallizationDrop"."local_crystallization_drop" AS "CrystallizationDrop__local_crystallization_drop", "CrystallizationDrop"."experiment_date" AS "CrystallizationDrop__experiment_date", "CrystallizationDrop"."staff_id" AS "CrystallizationDrop__staff_id", "CrystallizationDrop"."other_people" AS "CrystallizationDrop__other_people", "CrystallizationDrop"."lab_id" AS "CrystallizationDrop__lab_id", "CrystallizationDrop"."protocol_id" AS "CrystallizationDrop__protocol_id", "CrystallizationDrop"."status" AS "CrystallizationDrop__status", "CrystallizationDrop"."method" AS "CrystallizationDrop__method", "CrystallizationDrop"."drop_protein_volume" AS "CrystallizationDrop__drop_protein_volume", "CrystallizationDrop"."drop_precip_volume" AS "CrystallizationDrop__drop_precip_volume", "CrystallizationDrop"."drop_precip_contents" AS "CrystallizationDrop__drop_precip_contents", "CrystallizationDrop"."screen" AS "CrystallizationDrop__screen", "CrystallizationDrop"."screen_component" AS "CrystallizationDrop__screen_component", "CrystallizationDrop"."ph" AS "CrystallizationDrop__ph", "CrystallizationDrop"."reservoir_volume" AS "CrystallizationDrop__reservoir_volume", "CrystallizationDrop"."growth_time" AS "CrystallizationDrop__growth_time", "CrystallizationDrop"."plate_type" AS "CrystallizationDrop__plate_type", "CrystallizationDrop"."incubation_temperature" AS "CrystallizationDrop__incubation_temperature", "CrystallizationDrop"."inserted" AS "CrystallizationDrop__inserted", "CrystallizationDrop"."ins_user_id" AS "CrystallizationDrop__ins_user_id", "CrystallizationDrop"."update" AS "CrystallizationDrop__update", "CrystallizationDrop"."upd_user_id" AS "CrystallizationDrop__upd_user_id", "CrystallizationDrop"."present_in_lims" AS "CrystallizationDrop__present_in_lims", "CrystallizationDrop"."proteolysis_enzyme" AS "CrystallizationDrop__proteolysis_enzyme", "CrystallizationDrop"."modification" AS "CrystallizationDrop__modification", "CrystallizationDrop"."lims_date" AS "CrystallizationDrop__lims_date", "CrystallizationDrop"."dummy" AS "CrystallizationDrop__dummy", "CrystallizationDrop"."protein_concentration" AS "CrystallizationDrop__protein_concentration", "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Protocol"."id" AS "Protocol__id", "Protocol"."short" AS "Protocol__short", "Protocol"."type" AS "Protocol__type", "Protocol"."name" AS "Protocol__name", "Protocol"."description" AS "Protocol__description", "Protocol"."lab_id" AS "Protocol__lab_id", "Protocol"."staff_id" AS "Protocol__staff_id", "Protocol"."inserted" AS "Protocol__inserted", "Protocol"."updated" AS "Protocol__updated", "Protocol"."targettrack" AS "Protocol__targettrack" FROM "crystallization_drop" AS "CrystallizationDrop" LEFT JOIN "purification" AS "Purification" ON ("CrystallizationDrop"."purification_id" = "Purification"."id") LEFT JOIN "staff" AS "Staff" ON ("CrystallizationDrop"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("CrystallizationDrop"."protocol_id" = "Protocol"."short") WHERE "CrystallizationDrop"."id" = '213428' LIMIT 1012
48SELECT "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield" FROM "purification" AS "Purification" WHERE "Purification"."id" = '6470' 010
49SELECT "Protocol"."id" AS "Protocol__id", "Protocol"."short" AS "Protocol__short", "Protocol"."type" AS "Protocol__type", "Protocol"."name" AS "Protocol__name", "Protocol"."description" AS "Protocol__description", "Protocol"."lab_id" AS "Protocol__lab_id", "Protocol"."staff_id" AS "Protocol__staff_id", "Protocol"."inserted" AS "Protocol__inserted", "Protocol"."updated" AS "Protocol__updated", "Protocol"."targettrack" AS "Protocol__targettrack" FROM "protocol" AS "Protocol" WHERE "Protocol"."short" = 'standard purification_ANL' 010
50SELECT "Hsqc"."id" AS "Hsqc__id", "Hsqc"."target_id" AS "Hsqc__target_id", "Hsqc"."purification_id" AS "Hsqc__purification_id", "Hsqc"."local_hsqc_id" AS "Hsqc__local_hsqc_id", "Hsqc"."experiment_date" AS "Hsqc__experiment_date", "Hsqc"."staff_id" AS "Hsqc__staff_id", "Hsqc"."other_people" AS "Hsqc__other_people", "Hsqc"."lab_id" AS "Hsqc__lab_id", "Hsqc"."protocol_id" AS "Hsqc__protocol_id", "Hsqc"."inserted" AS "Hsqc__inserted", "Hsqc"."ins_user_id" AS "Hsqc__ins_user_id", "Hsqc"."update" AS "Hsqc__update", "Hsqc"."upd_user_id" AS "Hsqc__upd_user_id", "Hsqc"."spectrum_quality" AS "Hsqc__spectrum_quality", "Hsqc"."acquisition_temperature" AS "Hsqc__acquisition_temperature", "Hsqc"."sample_buffer" AS "Hsqc__sample_buffer" FROM "hsqc" AS "Hsqc" WHERE "Hsqc"."purification_id" = ('6470') 000
51SELECT "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager" FROM "staff" AS "Staff" WHERE "Staff"."id" = '160' 010
52SELECT "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix" FROM "lab" AS "Lab" WHERE "Lab"."short" = 'ANL' 010
53SELECT "Deposit"."id" AS "Deposit__id", "Deposit"."structure_id" AS "Deposit__structure_id", "Deposit"."target_id" AS "Deposit__target_id", "Deposit"."pdb_id" AS "Deposit__pdb_id", "Deposit"."staff_id" AS "Deposit__staff_id", "Deposit"."lab_id" AS "Deposit__lab_id", "Deposit"."submission_date" AS "Deposit__submission_date", "Deposit"."deposition_date" AS "Deposit__deposition_date", "Deposit"."release_date" AS "Deposit__release_date", "Deposit"."authors" AS "Deposit__authors", "Deposit"."title" AS "Deposit__title", "Deposit"."obsolete" AS "Deposit__obsolete", "Deposit"."obsolete_date" AS "Deposit__obsolete_date", "Deposit"."replacement_pdb_id" AS "Deposit__replacement_pdb_id", "Deposit"."casp" AS "Deposit__casp", "Deposit"."inserted" AS "Deposit__inserted", "Deposit"."ins_user_id" AS "Deposit__ins_user_id", "Deposit"."update" AS "Deposit__update", "Deposit"."upd_user_id" AS "Deposit__upd_user_id" FROM "deposit" AS "Deposit" WHERE "Deposit"."staff_id" = ('160') 001
54SELECT "Protocol"."id" AS "Protocol__id", "Protocol"."short" AS "Protocol__short", "Protocol"."type" AS "Protocol__type", "Protocol"."name" AS "Protocol__name", "Protocol"."description" AS "Protocol__description", "Protocol"."lab_id" AS "Protocol__lab_id", "Protocol"."staff_id" AS "Protocol__staff_id", "Protocol"."inserted" AS "Protocol__inserted", "Protocol"."updated" AS "Protocol__updated", "Protocol"."targettrack" AS "Protocol__targettrack" FROM "protocol" AS "Protocol" WHERE "Protocol"."short" = 'standard crystallization_ANL' 010
55SELECT "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix" FROM "lab" AS "Lab" WHERE "Lab"."short" = 'ANL' 010
56SELECT "ProteinClone"."id" AS "ProteinClone__id", "ProteinClone"."target_id" AS "ProteinClone__target_id", "ProteinClone"."clone_suffix" AS "ProteinClone__clone_suffix", "ProteinClone"."sequence_start" AS "ProteinClone__sequence_start", "ProteinClone"."sequence_end" AS "ProteinClone__sequence_end", "ProteinClone"."sequence" AS "ProteinClone__sequence", "ProteinClone"."sequence_comments" AS "ProteinClone__sequence_comments", "ProteinClone"."local_protein_target_id" AS "ProteinClone__local_protein_target_id", "ProteinClone"."local_clone_plate_id" AS "ProteinClone__local_clone_plate_id", "ProteinClone"."local_clone_id" AS "ProteinClone__local_clone_id", "ProteinClone"."experiment_date_start" AS "ProteinClone__experiment_date_start", "ProteinClone"."experiment_date_end" AS "ProteinClone__experiment_date_end", "ProteinClone"."staff_id" AS "ProteinClone__staff_id", "ProteinClone"."other_people" AS "ProteinClone__other_people", "ProteinClone"."lab_id" AS "ProteinClone__lab_id", "ProteinClone"."protocol_id" AS "ProteinClone__protocol_id", "ProteinClone"."status" AS "ProteinClone__status", "ProteinClone"."vector" AS "ProteinClone__vector", "ProteinClone"."pcr_primer_forward" AS "ProteinClone__pcr_primer_forward", "ProteinClone"."pcr_primer_backward" AS "ProteinClone__pcr_primer_backward", "ProteinClone"."shipped_to_lab_id" AS "ProteinClone__shipped_to_lab_id", "ProteinClone"."shipped_date" AS "ProteinClone__shipped_date", "ProteinClone"."inserted" AS "ProteinClone__inserted", "ProteinClone"."ins_user_id" AS "ProteinClone__ins_user_id", "ProteinClone"."update" AS "ProteinClone__update", "ProteinClone"."upd_user_id" AS "ProteinClone__upd_user_id", "ProteinClone"."secondary_shipped_to_lab_id" AS "ProteinClone__secondary_shipped_to_lab_id", "ProteinClone"."secondary_shipped_date" AS "ProteinClone__secondary_shipped_date", "ProteinClone"."external_source" AS "ProteinClone__external_source", "ProteinClone"."mutation" AS "ProteinClone__mutation", "ProteinClone"."bei_available" AS "ProteinClone__bei_available", "ProteinClone"."bei_number" AS "ProteinClone__bei_number", "ProteinClone"."reference_sequence_variance" AS "ProteinClone__reference_sequence_variance", "ProteinClone"."confirmed_dna_sequence" AS "ProteinClone__confirmed_dna_sequence", "ProteinClone"."confirmed_protein_sequence" AS "ProteinClone__confirmed_protein_sequence", "ProteinClone"."present_in_lims" AS "ProteinClone__present_in_lims", "ProteinClone"."template_dna_sequence" AS "ProteinClone__template_dna_sequence", "ProteinClone"."lims_date" AS "ProteinClone__lims_date", "ProteinClone"."dummy" AS "ProteinClone__dummy" FROM "clone" AS "ProteinClone" WHERE "ProteinClone"."protocol_id" = ('standard crystallization_ANL') 0010
57SELECT "Expression"."id" AS "Expression__id", "Expression"."target_id" AS "Expression__target_id", "Expression"."expression_suffix" AS "Expression__expression_suffix", "Expression"."clone_id" AS "Expression__clone_id", "Expression"."clone_suffix" AS "Expression__clone_suffix", "Expression"."local_clone_id" AS "Expression__local_clone_id", "Expression"."local_protein_target_id" AS "Expression__local_protein_target_id", "Expression"."local_expression_id" AS "Expression__local_expression_id", "Expression"."experiment_date_start" AS "Expression__experiment_date_start", "Expression"."experiment_date_end" AS "Expression__experiment_date_end", "Expression"."staff_id" AS "Expression__staff_id", "Expression"."other_people" AS "Expression__other_people", "Expression"."lab_id" AS "Expression__lab_id", "Expression"."protocol_id" AS "Expression__protocol_id", "Expression"."status" AS "Expression__status", "Expression"."expression_organism" AS "Expression__expression_organism", "Expression"."expression_strain" AS "Expression__expression_strain", "Expression"."media_type" AS "Expression__media_type", "Expression"."media_volume" AS "Expression__media_volume", "Expression"."growth_temperature" AS "Expression__growth_temperature", "Expression"."induction_temperature" AS "Expression__induction_temperature", "Expression"."induction_reagent" AS "Expression__induction_reagent", "Expression"."experiment_type" AS "Expression__experiment_type", "Expression"."expression_level" AS "Expression__expression_level", "Expression"."solubility_level" AS "Expression__solubility_level", "Expression"."inserted" AS "Expression__inserted", "Expression"."ins_user_id" AS "Expression__ins_user_id", "Expression"."update" AS "Expression__update", "Expression"."upd_user_id" AS "Expression__upd_user_id", "Expression"."present_in_lims" AS "Expression__present_in_lims", "Expression"."lims_date" AS "Expression__lims_date", "Expression"."dummy" AS "Expression__dummy" FROM "expression" AS "Expression" WHERE "Expression"."protocol_id" = ('standard crystallization_ANL') 009
58SELECT "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield" FROM "purification" AS "Purification" WHERE "Purification"."protocol_id" = ('standard crystallization_ANL') 004
59SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."crystallization_drop_id" = ('213428') 002
60SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager" FROM "center_user" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
61SELECT "CrystallizationDrop"."id" AS "CrystallizationDrop__id", "CrystallizationDrop"."target_id" AS "CrystallizationDrop__target_id", "CrystallizationDrop"."crystallization_drop_suffix" AS "CrystallizationDrop__crystallization_drop_suffix", "CrystallizationDrop"."purification_id" AS "CrystallizationDrop__purification_id", "CrystallizationDrop"."local_purification_id" AS "CrystallizationDrop__local_purification_id", "CrystallizationDrop"."local_protein_target_id" AS "CrystallizationDrop__local_protein_target_id", "CrystallizationDrop"."local_crystallization_drop" AS "CrystallizationDrop__local_crystallization_drop", "CrystallizationDrop"."experiment_date" AS "CrystallizationDrop__experiment_date", "CrystallizationDrop"."staff_id" AS "CrystallizationDrop__staff_id", "CrystallizationDrop"."other_people" AS "CrystallizationDrop__other_people", "CrystallizationDrop"."lab_id" AS "CrystallizationDrop__lab_id", "CrystallizationDrop"."protocol_id" AS "CrystallizationDrop__protocol_id", "CrystallizationDrop"."status" AS "CrystallizationDrop__status", "CrystallizationDrop"."method" AS "CrystallizationDrop__method", "CrystallizationDrop"."drop_protein_volume" AS "CrystallizationDrop__drop_protein_volume", "CrystallizationDrop"."drop_precip_volume" AS "CrystallizationDrop__drop_precip_volume", "CrystallizationDrop"."drop_precip_contents" AS "CrystallizationDrop__drop_precip_contents", "CrystallizationDrop"."screen" AS "CrystallizationDrop__screen", "CrystallizationDrop"."screen_component" AS "CrystallizationDrop__screen_component", "CrystallizationDrop"."ph" AS "CrystallizationDrop__ph", "CrystallizationDrop"."reservoir_volume" AS "CrystallizationDrop__reservoir_volume", "CrystallizationDrop"."growth_time" AS "CrystallizationDrop__growth_time", "CrystallizationDrop"."plate_type" AS "CrystallizationDrop__plate_type", "CrystallizationDrop"."incubation_temperature" AS "CrystallizationDrop__incubation_temperature", "CrystallizationDrop"."inserted" AS "CrystallizationDrop__inserted", "CrystallizationDrop"."ins_user_id" AS "CrystallizationDrop__ins_user_id", "CrystallizationDrop"."update" AS "CrystallizationDrop__update", "CrystallizationDrop"."upd_user_id" AS "CrystallizationDrop__upd_user_id", "CrystallizationDrop"."present_in_lims" AS "CrystallizationDrop__present_in_lims", "CrystallizationDrop"."proteolysis_enzyme" AS "CrystallizationDrop__proteolysis_enzyme", "CrystallizationDrop"."modification" AS "CrystallizationDrop__modification", "CrystallizationDrop"."lims_date" AS "CrystallizationDrop__lims_date", "CrystallizationDrop"."dummy" AS "CrystallizationDrop__dummy", "CrystallizationDrop"."protein_concentration" AS "CrystallizationDrop__protein_concentration", "Purification"."id" AS "Purification__id", "Purification"."target_id" AS "Purification__target_id", "Purification"."purification_suffix" AS "Purification__purification_suffix", "Purification"."expression_id" AS "Purification__expression_id", "Purification"."local_expression_id" AS "Purification__local_expression_id", "Purification"."local_protein_target_id" AS "Purification__local_protein_target_id", "Purification"."local_purification_id" AS "Purification__local_purification_id", "Purification"."experiment_date_start" AS "Purification__experiment_date_start", "Purification"."experiment_date_end" AS "Purification__experiment_date_end", "Purification"."staff_id" AS "Purification__staff_id", "Purification"."other_people" AS "Purification__other_people", "Purification"."lab_id" AS "Purification__lab_id", "Purification"."protocol_id" AS "Purification__protocol_id", "Purification"."status" AS "Purification__status", "Purification"."description" AS "Purification__description", "Purification"."affinity_tag_status" AS "Purification__affinity_tag_status", "Purification"."semet_status" AS "Purification__semet_status", "Purification"."covalent_modification" AS "Purification__covalent_modification", "Purification"."final_buffer" AS "Purification__final_buffer", "Purification"."final_concentration" AS "Purification__final_concentration", "Purification"."final_volume" AS "Purification__final_volume", "Purification"."shipped_to_lab_id" AS "Purification__shipped_to_lab_id", "Purification"."shipped_date" AS "Purification__shipped_date", "Purification"."inserted" AS "Purification__inserted", "Purification"."ins_user_id" AS "Purification__ins_user_id", "Purification"."update" AS "Purification__update", "Purification"."upd_user_id" AS "Purification__upd_user_id", "Purification"."present_in_lims" AS "Purification__present_in_lims", "Purification"."lims_date" AS "Purification__lims_date", "Purification"."dummy" AS "Purification__dummy", "Purification"."yield" AS "Purification__yield", "Lab"."id" AS "Lab__id", "Lab"."short" AS "Lab__short", "Lab"."full_name" AS "Lab__full_name", "Lab"."display_name" AS "Lab__display_name", "Lab"."main" AS "Lab__main", "Lab"."active" AS "Lab__active", "Lab"."prefix" AS "Lab__prefix", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Protocol"."id" AS "Protocol__id", "Protocol"."short" AS "Protocol__short", "Protocol"."type" AS "Protocol__type", "Protocol"."name" AS "Protocol__name", "Protocol"."description" AS "Protocol__description", "Protocol"."lab_id" AS "Protocol__lab_id", "Protocol"."staff_id" AS "Protocol__staff_id", "Protocol"."inserted" AS "Protocol__inserted", "Protocol"."updated" AS "Protocol__updated", "Protocol"."targettrack" AS "Protocol__targettrack" FROM "crystallization_drop" AS "CrystallizationDrop" LEFT JOIN "purification" AS "Purification" ON ("CrystallizationDrop"."purification_id" = "Purification"."id") LEFT JOIN "lab" AS "Lab" ON ("CrystallizationDrop"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("CrystallizationDrop"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("CrystallizationDrop"."protocol_id" = "Protocol"."short") WHERE "CrystallizationDrop"."id" = '213428' LIMIT 1012
62SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."crystallization_drop_id" = ('213428') 001