Publication

ID 2576
PubMed ID 24372145
Authors Zheng H, Hou J, Zimmerman MD, Wlodawer A, Minor W
Title The future of crystallography in drug discovery.
Journal Expert Opin Drug Discov
ISSN
Year 2014
Volume 9
Pages 125-37
Center CSGID+MCSG+NYSGRC
Target ID
PDB ID(s)
Type method
Remark
Times Cited 24
Citation Number Update 2019-08-24 13:56:30.02759-04
(psipubs) 20 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32324
2SELECT matviewname as name FROM pg_matviews;000
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
4SELECT matviewname as name FROM pg_matviews;000
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
6SELECT matviewname as name FROM pg_matviews;000
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
8SELECT matviewname as name FROM pg_matviews;000
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
10SELECT matviewname as name FROM pg_matviews;000
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32321
12SELECT matviewname as name FROM pg_matviews;000
13SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Publication"."times_cited_status" AS "Publication__times_cited_status", "Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited", "Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update", "Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status", "Publication"."cover_image" AS "Publication__cover_image", "Publication"."initiative_id" AS "Publication__initiative_id", "Publication"."pmcid" AS "Publication__pmcid", "Publication"."doi" AS "Publication__doi", "Publication"."date_pubmed_created" AS "Publication__date_pubmed_created", "Publication"."date_pubmed_updated" AS "Publication__date_pubmed_updated", "Publication"."pub_month" AS "Publication__pub_month", "Publication"."pub_day" AS "Publication__pub_day", "Publication"."date_accepted" AS "Publication__date_accepted", "Publication"."date_pubmed_history" AS "Publication__date_pubmed_history", "Publication"."date_aheadofprint" AS "Publication__date_aheadofprint", "Publication"."cite_error_id" AS "Publication__cite_error_id", "Publication"."times_cited_UA" AS "Publication__times_cited_UA", "Publication"."times_cited_DRCI" AS "Publication__times_cited_DRCI", "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id", "Initiative"."id" AS "Initiative__id", "Initiative"."short_name" AS "Initiative__short_name", "Initiative"."name" AS "Initiative__name", "PubAbstract"."id" AS "PubAbstract__id", "PubAbstract"."publication_id" AS "PubAbstract__publication_id", "PubAbstract"."abstract" AS "PubAbstract__abstract" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") LEFT JOIN "initiative" AS "Initiative" ON ("Publication"."initiative_id" = "Initiative"."id") LEFT JOIN "abstract" AS "PubAbstract" ON ("PubAbstract"."publication_id" = "Publication"."id") WHERE "Publication"."id" = '2576' LIMIT 1118
14SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE "PublicationPdb"."publication_id" = ('2576') 001
15SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Publication"."times_cited_status" AS "Publication__times_cited_status", "Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited", "Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update", "Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status", "Publication"."cover_image" AS "Publication__cover_image", "Publication"."initiative_id" AS "Publication__initiative_id", "Publication"."pmcid" AS "Publication__pmcid", "Publication"."doi" AS "Publication__doi", "Publication"."date_pubmed_created" AS "Publication__date_pubmed_created", "Publication"."date_pubmed_updated" AS "Publication__date_pubmed_updated", "Publication"."pub_month" AS "Publication__pub_month", "Publication"."pub_day" AS "Publication__pub_day", "Publication"."date_accepted" AS "Publication__date_accepted", "Publication"."date_pubmed_history" AS "Publication__date_pubmed_history", "Publication"."date_aheadofprint" AS "Publication__date_aheadofprint", "Publication"."cite_error_id" AS "Publication__cite_error_id", "Publication"."times_cited_UA" AS "Publication__times_cited_UA", "Publication"."times_cited_DRCI" AS "Publication__times_cited_DRCI", "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id", "Initiative"."id" AS "Initiative__id", "Initiative"."short_name" AS "Initiative__short_name", "Initiative"."name" AS "Initiative__name", "PubAbstract"."id" AS "PubAbstract__id", "PubAbstract"."publication_id" AS "PubAbstract__publication_id", "PubAbstract"."abstract" AS "PubAbstract__abstract" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") LEFT JOIN "initiative" AS "Initiative" ON ("Publication"."initiative_id" = "Initiative"."id") LEFT JOIN "abstract" AS "PubAbstract" ON ("PubAbstract"."publication_id" = "Publication"."id") WHERE "Publication"."id" = '2576' LIMIT 1112
16SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE "PublicationPdb"."publication_id" = ('2576') 000
17SELECT "Publication"."id" AS "Publication__id", "Publication"."pmid" AS "Publication__pmid", "Publication"."authors" AS "Publication__authors", "Publication"."title" AS "Publication__title", "Publication"."journal_short" AS "Publication__journal_short", "Publication"."issn" AS "Publication__issn", "Publication"."year" AS "Publication__year", "Publication"."vol" AS "Publication__vol", "Publication"."pages" AS "Publication__pages", "Publication"."center" AS "Publication__center", "Publication"."target_id" AS "Publication__target_id", "Publication"."pdb_id" AS "Publication__pdb_id", "Publication"."type" AS "Publication__type", "Publication"."status" AS "Publication__status", "Publication"."source" AS "Publication__source", "Publication"."remark" AS "Publication__remark", "Publication"."verified" AS "Publication__verified", "Publication"."frozen" AS "Publication__frozen", "Publication"."times_cited" AS "Publication__times_cited", "Publication"."times_cited_update" AS "Publication__times_cited_update", "Publication"."inserted" AS "Publication__inserted", "Publication"."updated" AS "Publication__updated", "Publication"."times_cited_status" AS "Publication__times_cited_status", "Publication"."pubmed_times_cited" AS "Publication__pubmed_times_cited", "Publication"."pubmed_times_cited_update" AS "Publication__pubmed_times_cited_update", "Publication"."pubmed_times_cited_status" AS "Publication__pubmed_times_cited_status", "Publication"."cover_image" AS "Publication__cover_image", "Publication"."initiative_id" AS "Publication__initiative_id", "Publication"."pmcid" AS "Publication__pmcid", "Publication"."doi" AS "Publication__doi", "Publication"."date_pubmed_created" AS "Publication__date_pubmed_created", "Publication"."date_pubmed_updated" AS "Publication__date_pubmed_updated", "Publication"."pub_month" AS "Publication__pub_month", "Publication"."pub_day" AS "Publication__pub_day", "Publication"."date_accepted" AS "Publication__date_accepted", "Publication"."date_pubmed_history" AS "Publication__date_pubmed_history", "Publication"."date_aheadofprint" AS "Publication__date_aheadofprint", "Publication"."cite_error_id" AS "Publication__cite_error_id", "Publication"."times_cited_UA" AS "Publication__times_cited_UA", "Publication"."times_cited_DRCI" AS "Publication__times_cited_DRCI", "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "publication" AS "Publication" LEFT JOIN "journal_alias" AS "JournalAlias" ON ("Publication"."journal_short" = "JournalAlias"."name") WHERE "id" = '2576' LIMIT 1111
18SELECT "JournalAlias"."name" AS "JournalAlias__name", "JournalAlias"."journal_id" AS "JournalAlias__journal_id" FROM "journal_alias" AS "JournalAlias" WHERE "JournalAlias"."name" = 'Expert Opin Drug Discov' 110
19SELECT "Journal"."id" AS "Journal__id", "Journal"."display_name" AS "Journal__display_name", "Journal"."issn" AS "Journal__issn", "Journal"."impact_factor" AS "Journal__impact_factor", "Journal"."impact_factor_year" AS "Journal__impact_factor_year", "Journal"."journal_type" AS "Journal__journal_type" FROM "journal" AS "Journal" WHERE "Journal"."id" = '296' 111
20SELECT "PublicationPdb"."id" AS "PublicationPdb__id", "PublicationPdb"."publication_id" AS "PublicationPdb__publication_id", "PublicationPdb"."pdb_id" AS "PublicationPdb__pdb_id" FROM "publication_pdb" AS "PublicationPdb" WHERE "PublicationPdb"."publication_id" = ('2576') 000
(default) 94 queries took 98 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';10910910
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;000
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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';1091092
32SELECT matviewname as name FROM pg_matviews;000
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';1091092
34SELECT matviewname as name FROM pg_matviews;000
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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';1091092
38SELECT matviewname as name FROM pg_matviews;000
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';1091092
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';1091091
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';1091091
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';1091091
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';1091091
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';1091091
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';1091091
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';1091092
82SELECT matviewname as name FROM pg_matviews;000
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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 "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1002
94SELECT "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
(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