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 26 of 167, showing 200 records out of 33221 total, starting on record 5001
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 
NYSGRC ID Priority stage Locus Tag NCBI GI Common Name Sequence
Length
Project Homolog
PDB ID
Homolog
Sequence
Identity
Target Organism
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 |
(default) 114 queries took 7895 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';10910914
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;000
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;000
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';1091093
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;000
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';1091093
12SELECT matviewname as name FROM pg_matviews;000
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';1091093
14SELECT matviewname as name FROM pg_matviews;000
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';1091093
16SELECT matviewname as name FROM pg_matviews;000
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';1091093
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;000
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';1091093
24SELECT matviewname as name FROM pg_matviews;000
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';1091093
26SELECT matviewname as name FROM pg_matviews;000
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';1091093
28SELECT matviewname as name FROM pg_matviews;000
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;000
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';1091093
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';1091093
34SELECT matviewname as name FROM pg_matviews;000
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';1091093
36SELECT matviewname as name FROM pg_matviews;000
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';1091093
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;000
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';1091093
42SELECT matviewname as name FROM pg_matviews;000
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';1091093
44SELECT matviewname as name FROM pg_matviews;000
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;000
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;000
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;000
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';1091093
52SELECT matviewname as name FROM pg_matviews;000
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;000
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';1091093
56SELECT matviewname as name FROM pg_matviews;000
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;000
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';1091093
62SELECT matviewname as name FROM pg_matviews;000
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;000
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;000
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;000
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';1091093
72SELECT matviewname as name FROM pg_matviews;000
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';1091093
74SELECT matviewname as name FROM pg_matviews;000
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';1091093
78SELECT matviewname as name FROM pg_matviews;000
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';1091093
80SELECT matviewname as name FROM pg_matviews;000
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;000
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';1091093
84SELECT matviewname as name FROM pg_matviews;000
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;000
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';1091093
88SELECT matviewname as name FROM pg_matviews;000
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';1091093
90SELECT matviewname as name FROM pg_matviews;000
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;000
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;000
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 33120
98SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE project is not Null ORDER BY "project" ASC 7979557
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 104810481183
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 6916911026
101SELECT DISTINCT COALESCE(priority, -1) AS priority FROM "protein_target" AS "Target" WHERE priority IS NOT NULL 22478
102SELECT "Stage"."name" AS "Stage__name" FROM "stage" AS "Stage" WHERE 1 = 1 ORDER BY "sequence" ASC 12122
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 null44155
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 151511
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 111764
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"."priority" desc LIMIT 200 OFFSET 50002002002381
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 1061067
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 17117112
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 38386
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 21621614
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 224
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 13134
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') 52524
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 ('016821', '016817', '016816', '016828', '016827', '016826', '016825', '016824', '016823', '016822', '016832', '016829', '016818', '016819', '016820', '001346', '001347', '001348', '001349', '001350', '001351', '028817', '024638', '028827', '028790', '024647', '028800', '028802', '026806', '029073', '024621', '029283', '024207', '011009', '011037', '011040', '011027', '011054', '011041', '011022', '011024', '011049', '011048', '011038', '011062', '011056', '011018', '011058', '011020', '011065', '011051', '011047', '011012', '011066', '011017', '011052', '011046', '011025', '011034', '011028', '011059', '011050', '011042', '011057', '011060', '011019', '011014', '011055', '011016', '011021', '011044 ', '011063', '011035', '011023', '011031', '011030', '011007', '011010', '011008', '011064', '011033', '011015', '024957', '027935', '027272', '028205', '028240', '028266', '027933', '028305', '028311', '028317', '028449', '027181', '025909', '028237', '028241', '028464', '025020', '028690', '026336', '029037', '029010', '029022', '025986', '025956', '025927', '029201', '200971', '200474', '012956', '200970', '017793', '017808', '017809', '017792', '017807', '017800', '017801', '017802', '017803', '017799', '017804', '017805', '017806', '019081', '017798', '017797', '017796', '017795', '017794', '024077', '024083', '020237', '024019', '024025', '020234', '020236', '024110', '019556', '024102', '023866', '020235', '023806', '211976', '211868', '031116', '029869', '212139', '211914', '211839', '211901', '212123', '031428', '211922', '029593', '030867', '030003', '211943', '030002', '032815', '211869', '212070', '212209', '029594', '211902', '200075', '011386', '200778', '011398', '011418', '200677', '014205', '014206', '032675', '014210', '014212', '014213', '014216', '018005', '017996', '017997', '017998', '017999', '018000', '018001', '018002', '018003', '017994', '018004', '017995', '031365', '017993', '017992', '017991', '017990', '017989', '017988', '017987', '019057') AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 003
(labdb) 2 queries took 3 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';2932932
2SELECT matviewname as name FROM pg_matviews;001