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

Targets

Filter Targets:

 Download data as tab-separated value (TSV) file (which can be used as a input for Microsoft Office Excel and Open Office Calc)
Jump to Target:
Page 1 of 61, showing 100 records out of 6088 total, starting on record 1
previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 
CSGID ID Priority stage Screening Locus Tag NCBI GI Gene
Name		 Common Name Sequence
Length		 Justification Selection
Phase		 Homolog
PDB ID		 Homolog
Sequence
Identity		 Target Organism TIGR Main Role TIGR Subrole
previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |
(default) 163 queries took 1184 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 = '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 position0949
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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 position066
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 position0278
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 position0247
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 position066
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 = '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
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 DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE project is not Null ORDER BY "project" ASC 0933
46SELECT DISTINCT "TigrMainRole"."name" AS "TigrMainRole__name" FROM "tigr_main_roles" AS "TigrMainRole" WHERE name is not null 01912
47SELECT DISTINCT "Organism"."name_text" AS "Organism__name_text", "Organism"."tax_id" AS "Organism__tax_id" FROM "protein_target" AS "Target" LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') WHERE "Target"."ncbi_taxon_id" is not null AND "Organism"."name_text" is not null ORDER BY "Organism"."name_text" ASC 019274
48SELECT DISTINCT "Species"."name_text" AS "Species__name_text", "Species"."tax_id" AS "Species__tax_id" FROM "protein_target" AS "Target" LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') WHERE "Target"."species_taxon_id" is not null AND "Species"."name_text" is not null ORDER BY "Species"."name_text" ASC 010976
49SELECT DISTINCT COALESCE(priority, -1) AS priority FROM "protein_target" AS "Target" WHERE priority IS NOT NULL 0413
50SELECT DISTINCT "Target"."stage" AS "Target__stage" FROM "protein_target" AS "Target" WHERE stage is not null 01228
51SELECT DISTINCT l.short, l.full_name FROM clone AS c LEFT JOIN lab AS l ON(l.short=c.lab_id) UNION SELECT DISTINCT l.short, l.full_name FROM clone as c LEFT JOIN lab as l ON(l.short=c.shipped_to_lab_id) WHERE l.short is not null0895
52SELECT DISTINCT "RequestPerson"."person_id" AS "RequestPerson__person_id", "RequestPerson"."firstname" AS "RequestPerson__firstname", "RequestPerson"."lastname" AS "RequestPerson__lastname", "RequestPerson"."person_id" AS "RequestPerson__person_id" FROM "request_target" AS "RequestTarget" LEFT JOIN "request_person" AS "RequestPerson" ON ("RequestTarget"."person_id" = "RequestPerson"."person_id") WHERE firstname !='' AND lastname !='' AND target_id is not null 01089
53SELECT COUNT(*) AS "count" FROM "protein_target" AS "Target" LEFT JOIN "tigr_main_roles" AS "TigrMainRole" ON ("Target"."tigr_main_role_id" = "TigrMainRole"."id") LEFT JOIN "tigr_sub_roles" AS "TigrSubRole" ON ("Target"."tigr_sub_role_id" = "TigrSubRole"."id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE "hidden" = FALSE 01444
54SELECT "Target"."target_id" AS "Target__target_id", "Target"."priority" AS "Target__priority", "Target"."stage" AS "Target__stage", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."gene_name" AS "Target__gene_name", "Target"."common_name" AS "Target__common_name", length("Target"."sequence"), "Target"."justification" AS "Target__justification", "Target"."project" AS "Target__project", "TigrMainRole"."name" AS "TigrMainRole__name", "TigrSubRole"."name" AS "TigrSubRole__name", "Target"."hidden" AS "Target__hidden", "Organism"."name_text" AS "Organism__name_text", "ProteinPdbHomolog"."pdb_id" AS "ProteinPdbHomolog__pdb_id", "ProteinPdbHomolog"."chain_id" AS "ProteinPdbHomolog__chain_id", "ProteinPdbHomolog"."organism" AS "ProteinPdbHomolog__organism", "ProteinPdbHomolog"."sequence_identity" AS "ProteinPdbHomolog__sequence_identity", (EXISTS(SELECT 1 FROM vs_assay WHERE "Target"."target_id" = "vs_assay"."target_id")) AS "Target__has_screening" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_id") LEFT JOIN "tigr_main_roles" AS "TigrMainRole" ON ("Target"."tigr_main_role_id" = "TigrMainRole"."id") LEFT JOIN "tigr_sub_roles" AS "TigrSubRole" ON ("Target"."tigr_sub_role_id" = "TigrSubRole"."id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE "hidden" = FALSE ORDER BY "Target"."target_id" ASC LIMIT 100010051
55SELECT "SubTarget"."id" AS "SubTarget__id", "SubTarget"."target_id" AS "SubTarget__target_id", "SubTarget"."sequence_start" AS "SubTarget__sequence_start", "SubTarget"."sequence_end" AS "SubTarget__sequence_end", "SubTarget"."mutation" AS "SubTarget__mutation", "SubTarget"."sequence" AS "SubTarget__sequence", "SubTarget"."dna_sequence" AS "SubTarget__dna_sequence", "SubTarget"."sequence_comments" AS "SubTarget__sequence_comments", "SubTarget"."date_selected" AS "SubTarget__date_selected", "SubTarget"."priority" AS "SubTarget__priority", "SubTarget"."inserted" AS "SubTarget__inserted", "SubTarget"."updated" AS "SubTarget__updated", "SubTarget"."type" AS "SubTarget__type", "SubTarget"."batch" AS "SubTarget__batch", "SubTarget"."predicted_cox_ligand" AS "SubTarget__predicted_cox_ligand" FROM "protein_subtarget" AS "SubTarget" WHERE "SubTarget"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 01415
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"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 03008
57SELECT "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"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 02606
58SELECT "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"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 053711
59SELECT "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"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 0244
60SELECT "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims" FROM "dataset" AS "Dataset" WHERE "Dataset"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 01215
61SELECT "Screening"."id" AS "Screening__id", "Screening"."target_id" AS "Screening__target_id", "Screening"."pdb_id" AS "Screening__pdb_id", "Screening"."chain_id" AS "Screening__chain_id", "Screening"."surface_id" AS "Screening__surface_id", "Screening"."method" AS "Screening__method", "Screening"."surface_pdb_file" AS "Screening__surface_pdb_file", "Screening"."docking_file" AS "Screening__docking_file", "Screening"."date_started" AS "Screening__date_started", "Screening"."date_ended" AS "Screening__date_ended", "Screening"."staff_id" AS "Screening__staff_id", "Screening"."inserted" AS "Screening__inserted", "Screening"."updated" AS "Screening__updated", "Screening"."run_id" AS "Screening__run_id", "Screening"."library_id" AS "Screening__library_id", (SELECT COUNT(*) FROM vs_assay_data WHERE "vs_assay_data"."vs_assay_id" = "Screening"."id") AS "Screening__compounds_count", (SELECT conc_comma("substance_name") FROM "hts"."vs_assay_data" WHERE rank < 5 AND vs_assay_id = "Screening"."id") AS "Screening__top_hits" FROM "vs_assay" AS "Screening" WHERE "Screening"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 01712
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"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') 066012
63SELECT "Justification"."id" AS "Justification__id", "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "JustificationCodeProteinTarget"."id" AS "JustificationCodeProteinTarget__id", "JustificationCodeProteinTarget"."target_id" AS "JustificationCodeProteinTarget__target_id", "JustificationCodeProteinTarget"."justification_code_id" AS "JustificationCodeProteinTarget__justification_code_id" FROM "justification_code" AS "Justification" JOIN "justification_code_map" AS "JustificationCodeProteinTarget" ON ("JustificationCodeProteinTarget"."target_id" IN ('IDP00001', 'IDP00002', 'IDP00003', 'IDP00004', 'IDP00005', 'IDP00006', 'IDP00007', 'IDP00008', 'IDP00009', 'IDP00010', 'IDP00011', 'IDP00012', 'IDP00013', 'IDP00014', 'IDP00015', 'IDP00016', 'IDP00017', 'IDP00018', 'IDP00019', 'IDP00020', 'IDP00021', 'IDP00022', 'IDP00023', 'IDP00024', 'IDP00025', 'IDP00026', 'IDP00027', 'IDP00028', 'IDP00029', 'IDP00030', 'IDP00031', 'IDP00032', 'IDP00033', 'IDP00034', 'IDP00035', 'IDP00036', 'IDP00037', 'IDP00038', 'IDP00039', 'IDP00040', 'IDP00041', 'IDP00042', 'IDP00043', 'IDP00044', 'IDP00045', 'IDP00046', 'IDP00047', 'IDP00048', 'IDP00049', 'IDP00050', 'IDP00051', 'IDP00052', 'IDP00053', 'IDP00054', 'IDP00055', 'IDP00056', 'IDP00057', 'IDP00058', 'IDP00059', 'IDP00060', 'IDP00061', 'IDP00062', 'IDP00063', 'IDP00064', 'IDP00065', 'IDP00066', 'IDP00067', 'IDP00068', 'IDP00069', 'IDP00070', 'IDP00071', 'IDP00072', 'IDP00073', 'IDP00074', 'IDP00075', 'IDP00076', 'IDP00077', 'IDP00078', 'IDP00079', 'IDP00080', 'IDP00081', 'IDP00082', 'IDP00083', 'IDP00084', 'IDP00085', 'IDP00086', 'IDP00087', 'IDP00088', 'IDP00089', 'IDP00090', 'IDP00091', 'IDP00092', 'IDP00093', 'IDP00094', 'IDP00095', 'IDP00096', 'IDP00097', 'IDP00098', 'IDP00099', 'IDP00100') AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 001
64SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00001' 000
65SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00002' 000
66SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00003' 000
67SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00004' 000
68SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00005' 000
69SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00006' 000
70SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00007' 000
71SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00008' 000
72SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00009' 000
73SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00010' 000
74SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00011' 000
75SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00012' 000
76SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00013' 000
77SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00014' 000
78SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00015' 000
79SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00016' 000
80SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00017' 000
81SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00018' 000
82SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00019' 000
83SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00020' 000
84SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00021' 000
85SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00022' 000
86SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00023' 000
87SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00024' 000
88SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00025' 000
89SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00026' 000
90SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00027' 000
91SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00028' 000
92SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00029' 000
93SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00030' 000
94SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00031' 000
95SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00032' 000
96SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00033' 000
97SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00034' 000
98SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00035' 000
99SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00036' 000
100SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00037' 000
101SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00038' 000
102SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00039' 000
103SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00040' 000
104SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00041' 000
105SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00042' 000
106SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00043' 000
107SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00044' 000
108SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00045' 000
109SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00046' 000
110SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00047' 000
111SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00048' 000
112SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00049' 000
113SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00050' 000
114SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00051' 000
115SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00052' 000
116SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00053' 000
117SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00054' 000
118SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00055' 000
119SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00056' 000
120SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00057' 000
121SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00058' 000
122SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00059' 000
123SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00060' 000
124SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00061' 000
125SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00062' 000
126SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00063' 000
127SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00064' 000
128SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00065' 000
129SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00066' 000
130SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00067' 000
131SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00068' 000
132SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00069' 000
133SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00070' 000
134SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00071' 000
135SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00072' 000
136SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00073' 000
137SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00074' 000
138SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00075' 000
139SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00076' 000
140SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00077' 000
141SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00078' 000
142SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00079' 000
143SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00080' 000
144SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00081' 000
145SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00082' 000
146SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00083' 000
147SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00084' 000
148SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00085' 000
149SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00086' 000
150SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00087' 000
151SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00088' 000
152SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00089' 000
153SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00090' 000
154SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00091' 000
155SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00092' 000
156SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00093' 000
157SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00094' 000
158SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00095' 000
159SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00096' 000
160SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00097' 000
161SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00098' 000
162SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00099' 000
163SELECT "Justification"."short" AS "Justification__short", "Justification"."name" AS "Justification__name", "Justification"."description" AS "Justification__description", "Justification"."id" AS "Justification__id" FROM "justification_code_map" AS "JustificationCodeProteinTarget" LEFT JOIN "justification_code" AS "Justification" ON ("JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") WHERE "target_id" = 'IDP00100' 000