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 49 of 167, showing 200 records out of 33221 total, starting on record 9601
 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 
NYSGRC ID Priority stage Locus Tag NCBI GI Common Name Sequence
Length
Project Homolog
PDB ID
Homolog
Sequence
Identity
Target Organism
| 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 |
(default) 114 queries took 5551 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';1091098
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';1091092
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';1091092
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';1091092
8SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
18SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
22SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091092
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';1091092
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;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';1091092
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';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';1091095
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
58SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091092
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';1091092
66SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
76SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091092
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';1091097
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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';1091092
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 1003
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 3383
98SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE project is not Null ORDER BY "project" ASC 7979354
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 10481048951
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 691691990
101SELECT DISTINCT COALESCE(priority, -1) AS priority FROM "protein_target" AS "Target" WHERE priority IS NOT NULL 22481
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 null44103
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 151510
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 111213
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"."target_id" asc LIMIT 200 OFFSET 96002002001201
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 1761764
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 50150113
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 1141144
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 58158111
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 773
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 662
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') 11112
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 ('010957', '010958', '010959', '010960', '010961', '010962', '010963', '010964', '010965', '010966', '010967', '010968', '010969', '010970', '010971', '010972', '010973', '010975', '010976', '010984', '010985', '010986', '010987', '010988', '010989', '010990', '010991', '010992', '010993', '010994', '010995', '010996', '010997', '010998', '010999', '011002', '011003', '011004', '011005', '011006', '011007', '011008', '011009', '011010', '011012', '011014', '011015', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011028', '011030', '011031', '011033', '011034', '011035', '011037', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011054', '011055', '011056', '011057', '011058', '011059', '011060', '011062', '011063', '011064', '011065', '011066', '011067', '011068', '011069', '011070', '011071', '011072', '011073', '011074', '011075', '011076', '011077', '011078', '011079', '011080', '011081', '011082', '011083', '011084', '011085', '011086', '011087', '011088', '011089', '011090', '011091', '011092', '011093', '011094', '011095', '011096', '011097', '011098', '011099', '011100', '011101', '011102', '011103', '011104', '011105', '011106', '011107', '011108', '011109', '011110', '011111', '011112', '011113', '011114', '011115', '011116', '011117', '011118', '011119', '011120', '011121', '011122', '011123', '011124', '011125', '011126', '011127', '011128', '011129', '011131', '011132', '011133', '011134', '011135', '011136', '011137', '011138', '011139', '011140', '011141', '011142', '011143', '011144', '011145', '011146', '011147', '011148', '011149', '011150', '011151', '011152', '011153', '011154', '011155', '011156', '011157', '011158', '011159', '011160', '011161', '011163', '011164', '011166', '011167', '011168', '011169', '011170', '011171', '011172', '011173', '011175', '011176', '011177', '011178', '011179', '011180', '011181') AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 001
(labdb) 2 queries took 4 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';2932933
2SELECT matviewname as name FROM pg_matviews;001