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 47 of 167, showing 200 records out of 33221 total, starting on record 9201
 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 
NYSGRC ID Priority stage Locus Tag NCBI GI Common Name Sequence
Length
Project Homolog
PDB ID
Homolog
Sequence
Identity
Target Organism
| 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 |
(default) 114 queries took 9992 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';10910917
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';1091094
4SELECT matviewname as name FROM pg_matviews;001
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
6SELECT matviewname as name FROM pg_matviews;001
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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;001
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
12SELECT matviewname as name FROM pg_matviews;001
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
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';1091093
16SELECT matviewname as name FROM pg_matviews;001
17SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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';1091094
20SELECT matviewname as name FROM pg_matviews;001
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
22SELECT matviewname as name FROM pg_matviews;001
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
24SELECT matviewname as name FROM pg_matviews;001
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
26SELECT matviewname as name FROM pg_matviews;001
27SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
28SELECT matviewname as name FROM pg_matviews;001
29SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
30SELECT matviewname as name FROM pg_matviews;001
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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';1091093
36SELECT matviewname as name FROM pg_matviews;001
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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;001
41SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
42SELECT matviewname as name FROM pg_matviews;001
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
44SELECT matviewname as name FROM pg_matviews;001
45SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
46SELECT matviewname as name FROM pg_matviews;001
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
48SELECT matviewname as name FROM pg_matviews;001
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
50SELECT matviewname as name FROM pg_matviews;001
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
52SELECT matviewname as name FROM pg_matviews;001
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
54SELECT matviewname as name FROM pg_matviews;001
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
56SELECT matviewname as name FROM pg_matviews;001
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
58SELECT matviewname as name FROM pg_matviews;001
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
60SELECT matviewname as name FROM pg_matviews;001
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
62SELECT matviewname as name FROM pg_matviews;001
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
64SELECT matviewname as name FROM pg_matviews;001
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
66SELECT matviewname as name FROM pg_matviews;001
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
68SELECT matviewname as name FROM pg_matviews;001
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
70SELECT matviewname as name FROM pg_matviews;001
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
72SELECT matviewname as name FROM pg_matviews;001
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
74SELECT matviewname as name FROM pg_matviews;001
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
76SELECT matviewname as name FROM pg_matviews;001
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
78SELECT matviewname as name FROM pg_matviews;001
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
80SELECT matviewname as name FROM pg_matviews;001
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
82SELECT matviewname as name FROM pg_matviews;001
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
84SELECT matviewname as name FROM pg_matviews;001
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
86SELECT matviewname as name FROM pg_matviews;001
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
88SELECT matviewname as name FROM pg_matviews;001
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
90SELECT matviewname as name FROM pg_matviews;001
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
92SELECT matviewname as name FROM pg_matviews;001
93SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
94SELECT matviewname as name FROM pg_matviews;001
95SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 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 33155
98SELECT DISTINCT "Target"."project" AS "Target__project" FROM "protein_target" AS "Target" WHERE project is not Null ORDER BY "project" ASC 7979607
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 104810481456
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 6916911283
101SELECT DISTINCT COALESCE(priority, -1) AS priority FROM "protein_target" AS "Target" WHERE priority IS NOT NULL 22593
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 null44140
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 151515
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 112199
106SELECT "Target"."target_id" AS "Target__target_id", "Target"."stage" AS "Target__stage", "Target"."locus_tag" AS "Target__locus_tag", "Target"."ncbi_gi" AS "Target__ncbi_gi", "Target"."ncbi_accession" AS "Target__ncbi_accession", "Target"."ncbi_taxon_id" AS "Target__ncbi_taxon_id", "Target"."species_taxon_id" AS "Target__species_taxon_id", "Target"."common_name" AS "Target__common_name", length("Target"."sequence"), "Target"."priority" AS "Target__priority", "Target"."project" AS "Target__project", "Target"."hidden" AS "Target__hidden", "Organism"."name_text" AS "Organism__name_text", "ProteinPdbHomolog"."pdb_id" AS "ProteinPdbHomolog__pdb_id", "ProteinPdbHomolog"."chain_id" AS "ProteinPdbHomolog__chain_id", "ProteinPdbHomolog"."organism" AS "ProteinPdbHomolog__organism", "ProteinPdbHomolog"."sequence_identity" AS "ProteinPdbHomolog__sequence_identity" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE 1 = 1 ORDER BY "Target"."ncbi_gi" asc LIMIT 200 OFFSET 92002002003258
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 37376
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 818131
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 14147
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 71718
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 004
112SELECT "Dataset"."id" AS "Dataset__id", "Dataset"."target_id" AS "Dataset__target_id", "Dataset"."crystal_harvest_id" AS "Dataset__crystal_harvest_id", "Dataset"."structure_solution_id" AS "Dataset__structure_solution_id", "Dataset"."experiment_date" AS "Dataset__experiment_date", "Dataset"."staff_id" AS "Dataset__staff_id", "Dataset"."other_people" AS "Dataset__other_people", "Dataset"."lab_id" AS "Dataset__lab_id", "Dataset"."detector_id" AS "Dataset__detector_id", "Dataset"."beamline_id" AS "Dataset__beamline_id", "Dataset"."sca_filename" AS "Dataset__sca_filename", "Dataset"."sca_uploaded" AS "Dataset__sca_uploaded", "Dataset"."wavelength" AS "Dataset__wavelength", "Dataset"."wavelength_type" AS "Dataset__wavelength_type", "Dataset"."diffraction_resolution" AS "Dataset__diffraction_resolution", "Dataset"."experiment_temperature" AS "Dataset__experiment_temperature", "Dataset"."a" AS "Dataset__a", "Dataset"."b" AS "Dataset__b", "Dataset"."c" AS "Dataset__c", "Dataset"."alpha" AS "Dataset__alpha", "Dataset"."beta" AS "Dataset__beta", "Dataset"."gamma" AS "Dataset__gamma", "Dataset"."z" AS "Dataset__z", "Dataset"."matthew_coeff" AS "Dataset__matthew_coeff", "Dataset"."spacegroup" AS "Dataset__spacegroup", "Dataset"."sca_number_reflns_obs" AS "Dataset__sca_number_reflns_obs", "Dataset"."sca_rmerge_i_obs" AS "Dataset__sca_rmerge_i_obs", "Dataset"."sca_chi_squared" AS "Dataset__sca_chi_squared", "Dataset"."sca_redundancy" AS "Dataset__sca_redundancy", "Dataset"."sca_shell_rmerge_i_obs" AS "Dataset__sca_shell_rmerge_i_obs", "Dataset"."sca_shell_chi_squared" AS "Dataset__sca_shell_chi_squared", "Dataset"."sca_shell_redundancy" AS "Dataset__sca_shell_redundancy", "Dataset"."sca_average_i" AS "Dataset__sca_average_i", "Dataset"."sca_average_i_sigma" AS "Dataset__sca_average_i_sigma", "Dataset"."sca_shell_i" AS "Dataset__sca_shell_i", "Dataset"."sca_shell_i_sigma" AS "Dataset__sca_shell_i_sigma", "Dataset"."data_collection_program_id" AS "Dataset__data_collection_program_id", "Dataset"."data_collection_programs_other" AS "Dataset__data_collection_programs_other", "Dataset"."data_scaling_program_id" AS "Dataset__data_scaling_program_id", "Dataset"."data_scaling_programs_other" AS "Dataset__data_scaling_programs_other", "Dataset"."intensity_integration_program_id" AS "Dataset__intensity_integration_program_id", "Dataset"."intensity_integration_programs_other" AS "Dataset__intensity_integration_programs_other", "Dataset"."shipped_to_lab_id" AS "Dataset__shipped_to_lab_id", "Dataset"."shipped_date" AS "Dataset__shipped_date", "Dataset"."inserted" AS "Dataset__inserted", "Dataset"."ins_user_id" AS "Dataset__ins_user_id", "Dataset"."update" AS "Dataset__update", "Dataset"."upd_user_id" AS "Dataset__upd_user_id", "Dataset"."sca_shell_res_low" AS "Dataset__sca_shell_res_low", "Dataset"."sca_shell_res_high" AS "Dataset__sca_shell_res_high", "Dataset"."sca_number_reflns_all" AS "Dataset__sca_number_reflns_all", "Dataset"."local_protein_target_id" AS "Dataset__local_protein_target_id", "Dataset"."local_dataset_id" AS "Dataset__local_dataset_id", "Dataset"."local_crystal_harvest_id" AS "Dataset__local_crystal_harvest_id", "Dataset"."dataset_suffix" AS "Dataset__dataset_suffix", "Dataset"."present_in_lims" AS "Dataset__present_in_lims" FROM "dataset" AS "Dataset" WHERE "Dataset"."target_id" IN ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 004
113SELECT "CrystalHarvest"."id" AS "CrystalHarvest__id", "CrystalHarvest"."target_id" AS "CrystalHarvest__target_id", "CrystalHarvest"."crystal_harvest_suffix" AS "CrystalHarvest__crystal_harvest_suffix", "CrystalHarvest"."crystallization_drop_id" AS "CrystalHarvest__crystallization_drop_id", "CrystalHarvest"."local_crystallization_drop_id" AS "CrystalHarvest__local_crystallization_drop_id", "CrystalHarvest"."local_protein_target_id" AS "CrystalHarvest__local_protein_target_id", "CrystalHarvest"."local_crystal_harvest_id" AS "CrystalHarvest__local_crystal_harvest_id", "CrystalHarvest"."experiment_date" AS "CrystalHarvest__experiment_date", "CrystalHarvest"."staff_id" AS "CrystalHarvest__staff_id", "CrystalHarvest"."other_people" AS "CrystalHarvest__other_people", "CrystalHarvest"."lab_id" AS "CrystalHarvest__lab_id", "CrystalHarvest"."protocol_id" AS "CrystalHarvest__protocol_id", "CrystalHarvest"."cryo_solution" AS "CrystalHarvest__cryo_solution", "CrystalHarvest"."soaking_solution" AS "CrystalHarvest__soaking_solution", "CrystalHarvest"."ligand" AS "CrystalHarvest__ligand", "CrystalHarvest"."diffraction_limit" AS "CrystalHarvest__diffraction_limit", "CrystalHarvest"."crystal_quality" AS "CrystalHarvest__crystal_quality", "CrystalHarvest"."shipped_to_lab_id" AS "CrystalHarvest__shipped_to_lab_id", "CrystalHarvest"."shipped_date" AS "CrystalHarvest__shipped_date", "CrystalHarvest"."inserted" AS "CrystalHarvest__inserted", "CrystalHarvest"."ins_user_id" AS "CrystalHarvest__ins_user_id", "CrystalHarvest"."update" AS "CrystalHarvest__update", "CrystalHarvest"."upd_user_id" AS "CrystalHarvest__upd_user_id", "CrystalHarvest"."final_pdb_id" AS "CrystalHarvest__final_pdb_id", "CrystalHarvest"."present_in_lims" AS "CrystalHarvest__present_in_lims", "CrystalHarvest"."lims_date" AS "CrystalHarvest__lims_date", "CrystalHarvest"."dummy" AS "CrystalHarvest__dummy" FROM "crystal_harvest" AS "CrystalHarvest" WHERE "CrystalHarvest"."target_id" IN ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') 004
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 ('009695', '009696', '009697', '009698', '009699', '009700', '009701', '009702', '009703', '009704', '029930', '009705', '009706', '009707', '009708', '009709', '009710', '009711', '009712', '009713', '009714', '009715', '009716', '009717', '009718', '009719', '009720', '009721', '009722', '009723', '009724', '009725', '009726', '009727', '009728', '009730', '009731', '009732', '009733', '009734', '009735', '009736', '009737', '009738', '009739', '009740', '009741', '009742', '009743', '009744', '009745', '009746', '009747', '009748', '009749', '009750', '009751', '009752', '009753', '009754', '009755', '009756', '009757', '009758', '009759', '009760', '009761', '009762', '009763', '009764', '009765', '009766', '009767', '009768', '009769', '009770', '009771', '009772', '009773', '009774', '009775', '009776', '009777', '009778', '009779', '009780', '009781', '026808', '009782', '009783', '009784', '009785', '009786', '009787', '009788', '009789', '009790', '009791', '009792', '009793', '009795', '009796', '009797', '009799', '030489', '030407', '030510', '030358', '011007', '011008', '011009', '011010', '011012', '011063', '011014', '011016', '011017', '011018', '011019', '011020', '011021', '011022', '011023', '011024', '011025', '011027', '011064', '011030', '011031', '011033', '011034', '011035', '011065', '011038', '011040', '011041', '011042', '011044 ', '011046', '011047', '011048', '011049', '011050', '011051', '011052', '011066', '011054', '011055', '011056', '011057', '011058', '011059', '011062', '005822', '005666', '012346', '032966', '001595', '011596', '032779', '023923', '024739', '032780', '028804', '024706', '001596', '030773', '024685', '032781', '016833', '024641', '032782', '016834', '025651', '001597', '016835', '024698', '001598', '024788', '001599', '028806', '016836', '018661', '024733', '018662', '025832', '018663', '001600', '024712', '016837', '032211', '001601', '032783', '031194', '020043', '020044', '020045', '001602', '016838', '001603') AND "JustificationCodeProteinTarget"."justification_code_id" = "Justification"."id") 003
(labdb) 2 queries took 7 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932935
2SELECT matviewname as name FROM pg_matviews;002