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 43 of 167, showing 200 records out of 33221 total, starting on record 8401
 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 
NYSGRC ID Priority stage Locus Tag NCBI GI Common Name Sequence
Length
Project Homolog
PDB ID
Homolog
Sequence
Identity
Target Organism
| 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 |
(default) 114 queries took 9521 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';10910918
2SELECT matviewname as name FROM pg_matviews;001
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
4SELECT matviewname as name FROM pg_matviews;001
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
6SELECT matviewname as name FROM pg_matviews;001
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
8SELECT matviewname as name FROM pg_matviews;001
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
10SELECT matviewname as name FROM pg_matviews;001
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
12SELECT matviewname as name FROM pg_matviews;001
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
14SELECT matviewname as name FROM pg_matviews;001
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
16SELECT matviewname as name FROM pg_matviews;001
17SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
18SELECT matviewname as name FROM pg_matviews;001
19SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
20SELECT matviewname as name FROM pg_matviews;001
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
22SELECT matviewname as name FROM pg_matviews;001
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
24SELECT matviewname as name FROM pg_matviews;001
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
26SELECT matviewname as name FROM pg_matviews;001
27SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
28SELECT matviewname as name FROM pg_matviews;001
29SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
30SELECT matviewname as name FROM pg_matviews;001
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
32SELECT matviewname as name FROM pg_matviews;001
33SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
34SELECT matviewname as name FROM pg_matviews;001
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
36SELECT matviewname as name FROM pg_matviews;001
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
38SELECT matviewname as name FROM pg_matviews;001
39SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
40SELECT matviewname as name FROM pg_matviews;001
41SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
42SELECT matviewname as name FROM pg_matviews;001
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
44SELECT matviewname as name FROM pg_matviews;001
45SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
46SELECT matviewname as name FROM pg_matviews;001
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
48SELECT matviewname as name FROM pg_matviews;001
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
50SELECT matviewname as name FROM pg_matviews;001
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
52SELECT matviewname as name FROM pg_matviews;001
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
54SELECT matviewname as name FROM pg_matviews;001
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
56SELECT matviewname as name FROM pg_matviews;001
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
58SELECT matviewname as name FROM pg_matviews;001
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
60SELECT matviewname as name FROM pg_matviews;001
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
62SELECT matviewname as name FROM pg_matviews;001
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
64SELECT matviewname as name FROM pg_matviews;001
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
66SELECT matviewname as name FROM pg_matviews;001
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
68SELECT matviewname as name FROM pg_matviews;001
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
70SELECT matviewname as name FROM pg_matviews;001
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
72SELECT matviewname as name FROM pg_matviews;001
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
74SELECT matviewname as name FROM pg_matviews;001
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
76SELECT matviewname as name FROM pg_matviews;001
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
78SELECT matviewname as name FROM pg_matviews;001
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
80SELECT matviewname as name FROM pg_matviews;001
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
82SELECT matviewname as name FROM pg_matviews;001
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
84SELECT matviewname as name FROM pg_matviews;001
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
86SELECT matviewname as name FROM pg_matviews;001
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
88SELECT matviewname as name FROM pg_matviews;001
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
90SELECT matviewname as name FROM pg_matviews;001
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
92SELECT matviewname as name FROM pg_matviews;001
93SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
94SELECT matviewname as name FROM pg_matviews;001
95SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "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", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1002
96SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "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", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
97SELECT DISTINCT "Target"."partnership_nominated" AS "Target__partnership_nominated" FROM "protein_target" AS "Target" WHERE partnership_nominated is not null ORDER BY "partnership_nominated" ASC 33170
98SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE project is not Null ORDER BY "project" ASC 7979587
99SELECT 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 104810481453
100SELECT 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"."tax_id" IS NOT NULL 6916911388
101SELECT DISTINCT COALESCE(priority, -1) AS priority FROM "protein_target" AS "Target" WHERE priority IS NOT NULL 22601
102SELECT "Stage"."name" AS "Stage__name" FROM "stage" AS "Stage" WHERE 1 = 1 ORDER BY "sequence" ASC 12121
103SELECT 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 null44143
104SELECT 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 ORDER BY "RequestPerson"."lastname" ASC 151514
105SELECT COUNT(*) AS "count" FROM "protein_target" AS "Target" 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 1 = 1 112260
106SELECT "Target"."target_id" AS "Target__target_id", "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"."common_name" AS "Target__common_name", length("Target"."sequence"), "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "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" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_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 1 = 1 ORDER BY "Target"."ncbi_gi" asc LIMIT 200 OFFSET 84002002002611
107SELECT "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" FROM "protein_subtarget" AS "SubTarget" WHERE "SubTarget"."target_id" IN ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 2032037
108SELECT "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", "ProteinClone"."type" AS "ProteinClone__type", "ProteinClone"."clone_annotation" AS "ProteinClone__clone_annotation", "ProteinClone"."optimized_dna_sequence" AS "ProteinClone__optimized_dna_sequence", "ProteinClone"."optimized" AS "ProteinClone__optimized", "ProteinClone"."truncated" AS "ProteinClone__truncated", "ProteinClone"."synthetic" AS "ProteinClone__synthetic" FROM "clone" AS "ProteinClone" WHERE "ProteinClone"."target_id" IN ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 37237220
109SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 27277
110SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 36836814
111SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 004
112SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 004
113SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') 664
114SELECT "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 ('018652', '030544', '030179', '030214', '030264', '024707', '032963', '016681', '030227', '030374', '030492', '030176', '030203', '030262', '030349', '030539', '030392', '030317', '030830', '030240', '030532', '030281', '028017', '030347', '030307', '026134', '030272', '030261', '016682', '030233', '005513', '011490', '024789', '030390', '030344', '030322', '020021', '030235', '032191', '020022', '016683', '016684', '030580', '030581', '016685', '024694', '019512', '020356', '010726', '005689', '019175', '031157', '200353', '005533', '005488', '200419', '200490', '012873', '012874', '024679', '026135', '031821', '031877', '024666', '029440', '027397', '031824', '024737', '024724', '024783', '029441', '027053', '031631', '031823', '032687', '028983', '024657', '024665', '027402', '024785', '028609', '031822', '028995', '032192', '024681', '006093', '005617', '005774', '006225', '031158', '006282', '033757', '005719', '005821', '011214', '011315', '004072', '005473', '005475', '004073', '005478', '004074', '005476', '005474', '005477', '004075', '004076', '006031', '029189', '020023', '029442', '016686', '032193', '019513', '032194', '020024', '016687', '032195', '024205', '024148', '011451', '016688', '016689', '027294', '032688', '027526', '016690', '016691', '016692', '016693', '200442', '016694', '020025', '016695', '016696', '016697', '024248', '005807', '020337', '011494', '018750', '016698', '003625', '016699', '011356', '016700', '016701', '003626', '003627', '016702', '016703', '016704', '016705', '016706', '016707', '016708', '016709', '016710', '016711', '016712', '016713', '016714', '016715', '016716', '031565', '016717', '016718', '003628', '016719', '005332', '019514', '016720', '016721', '016722', '016723', '016724', '003629', '005333', '003630', '003631', '006214', '010874', '012371', '033955', '033743', '019493', '012342', '005637', '033698', '010820', '010787', '010841', '034018', '012344', '006098', '009448', '009449', '009450', '009451', '009452') AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 003
(labdb) 2 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932935
2SELECT matviewname as name FROM pg_matviews;002