Targets: 33221
Targets requested by the community: 1174
Targets with structures: 220
Structures: 286 (X-ray: 273, NMR: 13)
Structures complexed with ligands: 65
Structures requested by the community: 32
Publications: 228

Target 012882    community request
Title: The crystal structure of short chain dehydrogenase from Rhodobacter sphaeroides
Authors: Z.Zhang, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 012907    community request
Title: CRYSTAL STRUCTURE OF AN ENOLASE (MANDELATE RACEMASE SUBGROUP) FROM PARACOCOCUS DENITRIFICANS PD1222 (TARGET NYSGRC-012907) WITH BOUND MG
Authors: M.W.Vetting, R.Toro, R.Bhosle, S.R.Wasserman, L.L.Morisco, S.Sojitra, S.Chamala, A.Kar, J.Lafleur, G.Villigas, B.Evans, J.Hammonds, A.Gizzi, W.D.Zencheck, B.Hillerich, J.Love, R.D.Seidel, J.B.Bonanno, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 012907    community request
Title: Crystal structure of an enolase (mandelate racemase subgroup) from paracococus denitrificans pd1222 (target nysgrc-012907) with bound cis-4oh-d-proline betaine (product)
Authors: M.W.Vetting, R.Toro, R.Bhosle, S.R.Wasserman, L.L.Morisco, S.Sojitra, S.Chamala, A.Kar, J.Lafleur, G.Villigas, B.Evans, J.Hammonds, A.Gizzi, M.Stead, B.Hillerich, J.Love, R.D.Seidel, J.B.Bonanno, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 012907    community request
Title: CRYSTAL STRUCTURE OF AN ENOLASE (MANDELATE RACEMASE SUBGROUP) FROM PARACOCOCUS DENITRIFICANS PD1222 (TARGET NYSGRC-012907) WITH BOUND L-PROLINE BETAINE (SUBSTRATE)
Authors: M.W.Vetting, R.Toro, R.Bhosle, S.R.Wasserman, L.L.Morisco, S.Sojitra, S.Chamala, A.Kar, J.Lafleur, G.Villigas, B.Evans, J.Hammonds, A.Gizzi, M.Stead, B.Hillerich, J.Love, R.D.Seidel, J.B.Bonanno, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 019589    community request
Title: Crystal structure of an adenosine deaminase homolog from Chromobacterium violaceum (target NYSGRC-019589) bound Zn and 5'-Methylthioadenosine (unproductive complex)
Authors: J.Kim, M.W.Vetting, J.M.Sauder, S.K.Burley, F.M.Raushel, J.B.Bonanno, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 019589    community request
Title: Crystal structure of an adenosine deaminase homolog from Chromobacterium violaceum (target NYSGRC-019589) with bound inosine. DOI:10.2210/pdb4f0s/pdb
Authors: J.Kim, M.W.Vetting, J.M.Sauder, S.K.Burley, F.M.Raushel, J.B.Bonanno, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 019597    community request
Title: Crystal Structure Of a Putative enoyl-coA hydratase (PSI-NYSGRC-019597) from Mycobacterium avium paratuberculosis K-10
Authors: P.R.Kumar, M.Ahmed, J.Attonito, R.Bhosle, S.Chamala, S.Chowdhury, A.S.Glenn, J.Hammonds, B.Hillerich, J.D.Love, R.Seidel, M.Stead, R.Toro, S.R.Wasserman, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 019670    community request
Title: CRYSTAL STRUCTURE OF HYPOTHETICAL PROTEIN SMC04132 FROM SINORHIZOBIUM MELILOTI 1021
Authors: V.N.Malashkevich, R.Bhosle, R.Toro, R.Seidel, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 030813    community request
Title: CRYSTAL STRUCTURE OF GSK3B IN COMPLEX WITH INHIBITOR 15R
Authors: C.Zhan, Y.Wang, J.Wach, P.Sheehan, C.Zhong, R.Harris, Y.Patskovsky, J.Bishop, S.Haggarty, A.Ramek, K.Berry, C.O'Herin, A.N.Koehler, A.W.Hung, D.W.Young, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 030813    community request
Title: CRYSTAL STRUCTURE OF GSK3B IN COMPLEX WITH INHIBITOR 1R
Authors: C.Zhan, Y.Wang, J.Wach, P.Sheehan, C.Zhong, R.Harris, Y.Patskovsky, J.Bishop, S.Haggarty, A.Ramek, K.Berry, C.O'Herin, A.N.Koehler, A.W.Hung, D.W.Young, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200449    community request
Title: CRYSTAL STRUCTURE OF AN ADENOSINE DEAMINASE FROM PSEUDOMONAS AERUGINOSA PAO1 (TARGET NYSGRC-200449) WITH BOUND ZN
Authors: M.W.Vetting, R.Toro, R.Bhosle, S.R.Wasserman, L.L.Morisco, S.Sojitra, S.Chamala, A.Kar, J.Lafleur, G.Villigas, B.Evans, J.Hammonds, A.Gizzi, W.D.Zencheck, B.Hillerich, J.Love, R.D.Seidel, J.B.Bonanno, F.M.Raushel, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200456    community request
Title: Crystal structure of an adenosine deaminase from xanthomonas campestris (target nysgrc-200456) with bound zn
Authors: M.W.Vetting, R.Toro, R.Bhosle, S.R.Wasserman, L.L.Morisco, S.Sojitra, S.Chamala, A.Kar, J.Lafleur, G.Villigas, B.Evans, J.Hammonds, A.Gizzi, W.D.Zencheck, B.Hillerich, J.Love, R.D.Seidel, J.B.Bonanno, F.M.Raushel, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200548    community request
Title: The crystal structure of Mandelate racemase/muconate lactonizing enzyme from Roseiflexus sp.
Authors: Z.Zhang, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200551    community request
Title: CRYSTAL STRUCTURE OF PUTATIVE MANDELATE RACEMASE/MUCONATE LACTONIZING ENZYME (PSI/COM TARGET 200551) FROM SORANGIUM CELLULOSUM
Authors: U.A.Ramagopal, R.Toro, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200555    community request
Title: Crystal structure of NYSGRC enolase target 200555, a putative dipeptide epimerase from Francisella philomiragia : Tartrate bound, no Mg
Authors: M.W.Vetting, B.Hillerich, R.D.Seidel, W.D.Zencheck, R.Toro, H.J.Imker, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200555    community request
Title: Crystal structure of NYSGRC enolase target 200555, a putative dipeptide epimerase from Francisella philomiragia : Tartrate and Mg complex
Authors: M.W.Vetting, B.Hillerich, R.D.Seidel, W.D.Zencheck, R.Toro, H.J.Imker, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200555    community request
Title: Crystal structure of NYSGRC enolase target 200555, a putative dipeptide epimerase from Francisella philomiragia : Mg complex
Authors: M.W.Vetting, B.Hillerich, R.D.Seidel, W.D.Zencheck, R.Toro, H.J.Imker, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200555    community request
Title: Crystal structure of NYSGRC enolase target 200555, a putative dipeptide epimerase from Francisella philomiragia : Mg and Fumarate complex
Authors: M.W.Vetting, B.Hillerich, R.D.Seidel, W.D.Zencheck, R.Toro, H.J.Imker, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200555    community request
Title: Crystal structure of NYSGRC enolase target 200555, a putative dipeptide epimerase from Francisella philomiragia : Complex with L-Ala-L-Glu and L-Ala-D-Glu
Authors: M.W.Vetting, B.Hillerich, R.D.Seidel, W.D.Zencheck, R.Toro, H.J.Imker, J.A.Gerlt, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200604    community request
Title: CRYSTAL STRUCTURE OF A PUTATIVE RACEMASE FROM ROSEOBACTER DENITRIFICANS
Authors: S.Eswaramoorthy, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200636    community request
Title: CRYSTAL STRUCTURE OF A PUTATIVE GALACTONATE DEHYDRATASE
Authors: S.Eswaramoorthy, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200645    community request
Title: CRYSTAL STRUCTURE OF A PUTATIVE MANDELATE RACEMASE/MUCONATE LACTONIZING PROTEIN FROM DINOROSEOBACTER SHIBAE DFL 12
Authors: D.Kumaran, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200688    community request
Title: CRYSTAL STRUCTURE OF MANDELATE RACEMASE/MUCONATE LACTONIZING ENZYME-LIKE PROTEIN FROM ROSEOVARIUS SP. TM1035
Authors: V.N.Malashkevich, R.Toro, R.Seidel, S.Garrett, R.Foti, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200689    community request
Title: Crystal structure of a putative mandelate racemase/muconate lactonizing enzyme family protein from Roseovarius
Authors: R.Agarwal, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200750    community request
Title: Crystal structure of a putative Mandelate racemase/Muconate lactonizing enzyme (Target PSI-200750) from Labrenzia alexandrii DFL-11
Authors: P.R.Kumar, J.Bonanno, S.Chowdhury, R.Foti, A.Gizzi, S.Glen, J.Hammonds, B.Hillerich, B.Matikainen, R.Seidel, R.Toro, W.Zencheck, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200756    community request
Title: The crystal structure of Mandelate racemase/muconate lactonizing enzyme from Rhodobacteraceae bacterium
Authors: Z.Zhang, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200780    community request
Title: Crystal structure of a putative Mandelate racemase/Muconate lactonizing enzyme (Target PSI-200780) from Burkholderia SAR-1
Authors: P.R.Kumar, J.Bonanno, S.Chowdhury, R.Foti, A.Gizzi, J.Hammonds, B.Hillerich, B.Matikainen, R.Seidel, R.Toro, W.Zencheck, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200833    community request
Title: The crystal structure of mandelate racemase/muconate lactonizing enzyme from Sulfitobacter sp
Authors: Z.Zhang, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200834    community request
Title: CRYSTAL STRUCTURE OF A MANDELATE RACEMASE (MUCONATE LACTONIZING ENZYME FAMILY PROTEIN) FROM ROSEOVARIUS NUBINHIBENS
Authors: S.Eswaramoorthy, D.Kumaran, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 200855    community request
Title: CRYSTAL STRUCTURE OF mandelate racemase/muconate lactonizing enzyme from Jannaschia sp. CCS1
Authors: V.N.Malashkevich, R.Bhosle, R.Toro, B.Hillerich, A.Gizzi, S.Garforth, A.Kar, M.K.Chan, J.Lafluer, H.Patel, B.Matikainen, S.Chamala, S.Lim, A.Celikgil, G.Villegas, B.Evans, W.Zenchek, J.Love, A.Fiser, K.Khafizov, R.Seidel, J.B.Bonanno, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

Target 200881    community request
Title: Crystal structure of mandelate racemase/muconate lactonizing enzyme family protein from Hoeflea phototrophica
Authors: R.Agarwal, S.Chamala, B.Evans, R.Foti, A.Gizzi, B.Hillerich, A.Kar, J.Lafleur, R.Seidel, G.Villigas, W.Zencheck, S.C.Almo, S.Swaminathan, New York Structural Genomics Research Consortium (Nysgrc)

Target 202090    community request
Title: CRYSTAL STRUCTURE OF Putative dehydratase protein from Salmonella enterica subsp. enterica serovar Typhimurium (Salmonella typhimurium)
Authors: V.N.Malashkevich, R.Bhosle, R.Toro, B.Hillerich, A.Gizzi, S.Garforth, A.Kar, M.K.Chan, J.Lafluer, H.Patel, B.Matikainen, S.Chamala, S.Lim, A.Celikgil, G.Villegas, B.Evans, W.Zenchek, J.Love, A.Fiser, K.Khafizov, R.Seidel, J.B.Bonanno, S.C.Almo, New York Structural Genomics Research Consortium (Nysgrc)

(default) 101 queries took 1998 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091098
2SELECT matviewname as name FROM pg_matviews;000
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';1091092
50SELECT matviewname as name FROM pg_matviews;000
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
52SELECT matviewname as name FROM pg_matviews;000
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
54SELECT matviewname as name FROM pg_matviews;000
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
56SELECT matviewname as name FROM pg_matviews;000
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
58SELECT matviewname as name FROM pg_matviews;000
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
60SELECT matviewname as name FROM pg_matviews;000
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
62SELECT matviewname as name FROM pg_matviews;000
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
64SELECT matviewname as name FROM pg_matviews;000
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
66SELECT matviewname as name FROM pg_matviews;000
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
68SELECT matviewname as name FROM pg_matviews;000
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
70SELECT matviewname as name FROM pg_matviews;000
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
72SELECT matviewname as name FROM pg_matviews;000
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
74SELECT matviewname as name FROM pg_matviews;000
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
76SELECT matviewname as name FROM pg_matviews;000
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
78SELECT matviewname as name FROM pg_matviews;000
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
80SELECT matviewname as name FROM pg_matviews;000
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';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 1001
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 1000
95SELECT COUNT(*) AS "count" 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 111124
96SELECT COUNT(*) AS "count" 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 "project" = 'COM (Community Requests)' 1151
97SELECT COUNT(*) AS "count" FROM "deposit" AS "Deposit" LEFT JOIN "structure" AS "Structure" ON ("Deposit"."structure_id" = "Structure"."id") LEFT JOIN "lab" AS "Lab" ON ("Deposit"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("Deposit"."staff_id" = "Staff"."id") LEFT JOIN "protein_target" AS "Target" ON ("Deposit"."target_id" = "Target"."target_id") WHERE "obsolete" = FALSE 11239
98SELECT COUNT(*) AS "count" FROM "nmr_deposit" AS "NmrDeposit" LEFT JOIN "nmr_structure" AS "NmrStructure" ON ("NmrDeposit"."nmr_structure_id" = "NmrStructure"."id") LEFT JOIN "lab" AS "Lab" ON ("NmrDeposit"."lab_id" = "Lab"."short") LEFT JOIN "staff" AS "Staff" ON ("NmrDeposit"."staff_id" = "Staff"."id") LEFT JOIN "protein_target" AS "Target" ON ("NmrDeposit"."target_id" = "Target"."target_id") LEFT JOIN "pdbstructures" AS "Pdbstructures" ON ("NmrDeposit"."pdb_id" = "Pdbstructures"."pdb_id") LEFT JOIN "pdbchains" AS "Pdbchains" ON ("NmrDeposit"."pdb_id" = "Pdbchains"."pdb_id") WHERE "obsolete" = FALSE 11239
99SELECT count(DISTINCT "target_id") FROM "deposit" AS "Deposit" WHERE "obsolete" = FALSE 111
100SELECT count(*) AS count FROM ( SELECT DISTINCT deposit_id FROM deposit_ligand WHERE ligand_type = 'biological' ) AS a111
101SELECT "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", "Structure"."target_id" AS "Structure__target_id", "Target"."project" AS "Target__project" FROM "deposit" AS "Deposit" LEFT JOIN "structure" AS "Structure" ON ("Deposit"."structure_id" = "Structure"."id") LEFT JOIN "protein_target" AS "Target" ON ("Deposit"."target_id" = "Target"."target_id") WHERE obsolete IS FALSE ORDER BY "Deposit"."target_id" ASC, "Deposit"."pdb_id" ASC 273273244
(labdb) 2 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932932
2SELECT matviewname as name FROM pg_matviews;000
(psipubs) 13 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';32325
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 COUNT(*) FROM publication WHERE true AND (status = 'published' AND ((verified = 't' AND (source = 'spreadsheet' OR source = 'mcsg database' OR source = 'email')) OR source = 'psi_interface')) AND (center like '%NYSGRC%' or center like '%NYSGXRC%');114