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

Purification

Target
IDP00422  
Purification ID
A4221  
Expression
M9 minimal + semet (Oct 14, 2008)  
Experiment Date Start
Oct 21, 2008  
Experiment Date End
Oct 23, 2008  
Person
Min Zhou  
Lab
Argonne National Laboratory  
Protocol
standard purification_ANL  
Status
success  
Description
IMAC-I, SEC, IMAC-II::ÄKTAxpress IMAC-II program flow-through (20 mM imidazole)::concentration and buffer exchange (Amicon 3k or 10k)  
Affinity Tag Status
cleaved  
SeMet Status
semet  
Final Buffer
50 mM HEPES pH 8.0, 500 mM NaCl, 5 % Glycerol, 10 mM ß-mercaptoethanol, 250 mM Imidazole  
Final Concentration (mg/mL)
109  
Final Volume (μL)
1000  
Shipped To Lab Id
ANL  
Shipped Date
Oct 23, 2008  
Inserted
Jul 29, 2011  

Related Crystallization Drops

Experiment
Date		 Person Lab Protocol Status Method Drop
Precipitant
Contents		 Screen Screen
Component		 pH Plate
Type
(default) 64 queries took 670 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 = '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 position0317
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 = '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 position03210
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 = '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 position09411
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_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 position055
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 = '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 position025
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_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 position025
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 = '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 position045
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 = '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 position025
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 = '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 position0206
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_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 position075
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 = '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 position0165
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 = '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 position0155
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_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 position065
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 = '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 position0396
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 = '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 position075
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 = '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 position0195
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 = '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 position085
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 = '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 position0346
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 = '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 position0105
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 = '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 position0276
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 position0567
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 position0246
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 position0125
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 position0467
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 position0195
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 position0226
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 position0226
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 position095
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 position055
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 position075
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 position045
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 position065
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 position0105
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 position0155
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 position055
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 "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", "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", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."ec" AS "Target__ec", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."type" AS "Target__type", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening", "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 "purification" AS "Purification" LEFT JOIN "expression" AS "Expression" ON ("Purification"."expression_id" = "Expression"."id") LEFT JOIN "protein_target" AS "Target" ON ("Purification"."target_id" = "Target"."target_id") LEFT JOIN "lab" AS "Lab" ON ("Purification"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Purification"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("Purification"."protocol_id" = "Protocol"."short") WHERE "Purification"."id" = '6371' LIMIT 1013
46SELECT "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" FROM "crystallization_drop" AS "CrystallizationDrop" WHERE "CrystallizationDrop"."purification_id" = ('6371') 01114
47SELECT "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" = ('6371') 000
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", "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", "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 "purification" AS "Purification" LEFT JOIN "expression" AS "Expression" ON ("Purification"."expression_id" = "Expression"."id") LEFT JOIN "lab" AS "Lab" ON ("Purification"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Purification"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("Purification"."protocol_id" = "Protocol"."short") WHERE "Purification"."id" = '6371' LIMIT 1012
49SELECT "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"."id" = '12966' 010
50SELECT "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
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" = '125' 010
52SELECT "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
53SELECT "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
54SELECT "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 purification_ANL') 0010
55SELECT "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 purification_ANL') 009
56SELECT "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 purification_ANL') 0328656
57SELECT "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" FROM "crystallization_drop" AS "CrystallizationDrop" WHERE "CrystallizationDrop"."purification_id" = ('6371') 01110
58SELECT "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
59SELECT "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" = '125' 010
60SELECT "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" = ('6371') 000
61SELECT "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
62SELECT "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", "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", "Target"."id" AS "Target__id", "Target"."target_id" AS "Target__target_id", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_geneid" AS "Target__ncbi_geneid", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", "Target"."ncbi_coded_by_region" AS "Target__ncbi_coded_by_region", "Target"."ncbi_note" AS "Target__ncbi_note", "Target"."tigr_main_role_id" AS "Target__tigr_main_role_id", "Target"."tigr_sub_role_id" AS "Target__tigr_sub_role_id", "Target"."comment" AS "Target__comment", "Target"."justification" AS "Target__justification", "Target"."sequence" AS "Target__sequence", "Target"."sequence_length" AS "Target__sequence_length", "Target"."dna_sequence" AS "Target__dna_sequence", "Target"."dna_sequence_ncbi" AS "Target__dna_sequence_ncbi", "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."selection_phase" AS "Target__selection_phase", "Target"."date_selected" AS "Target__date_selected", "Target"."date_approved" AS "Target__date_approved", "Target"."completion_code" AS "Target__completion_code", "Target"."pi" AS "Target__pi", "Target"."tms" AS "Target__tms", "Target"."sp" AS "Target__sp", "Target"."core_genome" AS "Target__core_genome", "Target"."gram_minus_gene_homolog" AS "Target__gram_minus_gene_homolog", "Target"."gram_plus_gene_homolog" AS "Target__gram_plus_gene_homolog", "Target"."protease_motifs" AS "Target__protease_motifs", "Target"."glycosyl_group_metabolism" AS "Target__glycosyl_group_metabolism", "Target"."cell_wall" AS "Target__cell_wall", "Target"."drug_target_homologs" AS "Target__drug_target_homologs", "Target"."virulence_genes" AS "Target__virulence_genes", "Target"."essential_genes_homologs" AS "Target__essential_genes_homologs", "Target"."dna_binding_motifs" AS "Target__dna_binding_motifs", "Target"."inserted" AS "Target__inserted", "Target"."updated" AS "Target__updated", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."ins_user_id" AS "Target__ins_user_id", "Target"."upd_user_id" AS "Target__upd_user_id", "Target"."stage" AS "Target__stage", "Target"."hidden" AS "Target__hidden", "Target"."submitter_id" AS "Target__submitter_id", "Target"."selection_db_id" AS "Target__selection_db_id", "Target"."dna_source_taxon_id" AS "Target__dna_source_taxon_id", "Target"."batch" AS "Target__batch", "Target"."genus_taxon_id" AS "Target__genus_taxon_id", "Target"."seguid" AS "Target__seguid", "Target"."uniprot_id" AS "Target__uniprot_id", "Target"."target_family" AS "Target__target_family", "Target"."tar_designpool_id" AS "Target__tar_designpool_id", "Target"."community_nominated" AS "Target__community_nominated", "Target"."partnership_nominated" AS "Target__partnership_nominated", "Target"."biomedical" AS "Target__biomedical", "Target"."metagenomic" AS "Target__metagenomic", "Target"."structural_coverage" AS "Target__structural_coverage", "Target"."psi2" AS "Target__psi2", "Target"."translated_dna_sequence" AS "Target__translated_dna_sequence", "Target"."family_coverage" AS "Target__family_coverage", "Target"."family_coverage_date" AS "Target__family_coverage_date", "Target"."distribution_lab" AS "Target__distribution_lab", "Target"."uniprot_accession" AS "Target__uniprot_accession", "Target"."protocol_id" AS "Target__protocol_id", "Target"."ensembl_protein_id" AS "Target__ensembl_protein_id", "Target"."ensembl_gene_id" AS "Target__ensembl_gene_id", "Target"."protein_production_for_partnerships" AS "Target__protein_production_for_partnerships", "Target"."ligand_studies" AS "Target__ligand_studies", "Target"."ec" AS "Target__ec", "Target"."legacy" AS "Target__legacy", "Target"."complex_with_biological_partner" AS "Target__complex_with_biological_partner", "Target"."functional_mutant" AS "Target__functional_mutant", "Target"."conformational_state" AS "Target__conformational_state", "Target"."disease" AS "Target__disease", "Target"."individual_organism" AS "Target__individual_organism", "Target"."protein_family_of_high_biological_importance" AS "Target__protein_family_of_high_biological_importance", "Target"."general_domain_family" AS "Target__general_domain_family", "Target"."eukaryotic_domain_family" AS "Target__eukaryotic_domain_family", "Target"."first_structure_of_class" AS "Target__first_structure_of_class", "Target"."functional_follow_up" AS "Target__functional_follow_up", "Target"."technology_development" AS "Target__technology_development", "Target"."membrane_protein" AS "Target__membrane_protein", "Target"."single_domain_protein" AS "Target__single_domain_protein", "Target"."multidomain_protein" AS "Target__multidomain_protein", "Target"."eukaryotic_protein" AS "Target__eukaryotic_protein", "Target"."protein_protein_complex" AS "Target__protein_protein_complex", "Target"."protein_nucleic_acid_complex" AS "Target__protein_nucleic_acid_complex", "Target"."protein_ligand_complex" AS "Target__protein_ligand_complex", "Target"."de_novo_designed_protein" AS "Target__de_novo_designed_protein", "Target"."post_translational_modification" AS "Target__post_translational_modification", "Target"."oligomeric_protein" AS "Target__oligomeric_protein", "Target"."type" AS "Target__type", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening", "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 "purification" AS "Purification" LEFT JOIN "expression" AS "Expression" ON ("Purification"."expression_id" = "Expression"."id") LEFT JOIN "protein_target" AS "Target" ON ("Purification"."target_id" = "Target"."target_id") LEFT JOIN "lab" AS "Lab" ON ("Purification"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Purification"."staff_id" = "Staff"."id") LEFT JOIN "protocol" AS "Protocol" ON ("Purification"."protocol_id" = "Protocol"."short") WHERE "Purification"."id" = '6371' LIMIT 1013
63SELECT "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" FROM "crystallization_drop" AS "CrystallizationDrop" WHERE "CrystallizationDrop"."purification_id" = ('6371') 01113
64SELECT "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" = ('6371') 000