NIH report

Export data as: CSV, TSV, XLS

Target	Category	Partnership	MW [kDa]	Homolog at selection	Relative identity at selection	Homolog at deposition	Relative identity at deposition	Family size	Resolution	R	Rfree	PDB ID	Deposition date	Structure factors deposited	New fold	Function suggested by analysis of the structure	Function, if it has been established experimentally	Structure features
012132	biomedical		34.2	3BA1	42.5	3BA1	42.5		2.3	.146	.169	5J23	2016-03-29	N/A	no
491003			68.6	1AO6	73.3	3V08	96	900	2.4	.195	.255	5IJE	2016-03-01	N/A	no
030805	biomedical		27.1	1NKV	71.8	5BP7	81		1.9	#.###	.167	5EPE	2015-11-11	N/A	no
491003			68.6	1AO6	73.3	3V08	96	900	2.2	.181	.241	5DQF	2015-09-14	N/A	no
028317	community		27.4	1UIY	35.8	4OLQ	100		2.1	.198	.232	5C9G	2015-06-26	Yes	no
014667	biomedical		33.9	3KBO	35.2	4ZQB	100		2.2	.197	.252	5C5I	2015-06-19	N/A	no
030807	biomedical		17.3			4QVG	25.7		1.8	.150	.188	5BXY	2015-06-09	N/A	no
014307	biomedical		35.4	3KBO	33.6	4WEQ	60.5		1.5	.139	.165	5BQF	2015-05-29	N/A	no
030788	biomedical		27.1	1NKV	74.6	1NKV	74.6		2.1	.186	.223	5BP7	2015-05-27	N/A	no
030801	biomedical		29.0	2WAF	34.6	2WAF	34.6		1.5	.134	.179	5BP9	2015-05-27	N/A	no
011884	biomedical		34.6	3KBO	35.4	4WEQ	100		1.7	#.###	.150	4Z0P	2015-03-26	Yes	no
022189	biomedical		57.0	2QNE	40.4	2QNE	40.4		1.6	.139	.165	4YYC	2015-03-23	Yes	no
014260	biomedical		37.3	1LQA	33.1	1LQA	33.1		1.9	.161	.185	4XK2	2015-01-09	N/A	no
014307	biomedical		35.4	3KBO	33.6	4WEQ	60.5		1.4	.151	.178	4XCV	2014-12-18	N/A	no
012048	biomedical		30.7	3D3F	34.9	4PMJ	100		2.2	.160	.225	4XAP	2014-12-15	N/A	no
015257	biomedical		34.6	3KBO	38.9	3KBO	38.9		1.9	.163	.209	4XA8	2014-12-12	N/A	no
022550	biomedical		33.0	2G5C	32.3	2G5C	32.3		1.4	.115	.159	4WJI	2014-09-30	Yes	no
013574	biomedical		31.6	3D3F	32.8	4PMJ	51.4		1.8	#.###	.185	4WGH	2014-09-18	N/A	no
011884	biomedical		34.6	3KBO	35.4	4N18	39.2		2.0	#.###	.196	4WEQ	2014-09-10	N/A	no
021011	biomedical		57.4	1ZLQ	28.4	4OER	29.9		2.3	#.###	.228	4WED	2014-09-09	N/A	no
028014	community		26.6	3OC7	34.9	4OLQ	37.4		1.8	.168	.193	4WCZ	2014-09-05	N/A	no
021736	biomedical		39.5	3LY1	28.1	4R2N	32.4		1.6	#.###	.163	4WBT	2014-09-03	N/A	no
021002	biomedical		11.5						2.3	#.###	.224	4U13	2014-07-14	N/A	no
012048	biomedical		30.7	3D3F	34.9	3D3F	34.9		2.2	.170	.217	4PMJ	2014-05-21	N/A	no
028034	community		29.1	3SLL	32.8	4JVT	100	13723	1.9	.155	.181	4OMR	2014-01-27	N/A	no
028317	community		27.4	1UIY	35.8	1UIY	35.8		2.7	.229	.262	4OLQ	2014-01-24	N/A	no
028010	community		29.1	2EJ5	33.6	2EJ5	33.6		2.0	.168	.197	4OG1	2014-01-15	Yes	no
014094	biomedical		34.4	2XHZ	29.4	2XHZ	29.4		1.9	.150	.189	4O9K	2014-01-02	Yes	no
028313	community		26.9	3FDU	40.2	3FDU	40.2		2.3	.178	.207	4NEK	2013-10-29	N/A	no
012711		IFN	25.9	1AH1	31.7	1AH1	31.7		2.3	.175	.212	4N8P	2013-10-17	Yes	no
005804		IFN	120.7	3JXA	21.9	3JXA	21.9		1.8	.172	.219	4N68	2013-10-11	Yes	no
006240		IFN	211.7	1LAR	30.2	1LAR	30.2		1.5	.164	.198	4N5U	2013-10-10	Yes	no
013675	biomedical		34.2	3KBO	37.7	3KBO	37.7		2.0	.183	.220	4N18	2013-10-03	Yes	no
028282	community		28.8	1UIY	32	4LK5	34.5		2.2	.173	.211	4MOU	2013-09-12	N/A	no
021389	biomedical		26.5	3ERF	24.8	3ERF	24.8		1.8	.163	.190	4MDC	2013-08-22	Yes	no
029452	community		34.8	3PQD	64.7	4LMR	100	5640	1.9	.210	.241	4LN1	2013-07-11	Yes	no
029362	community		29.8	1M73	47.1	1M73	47.1		2.1	.174	.216	4LNA	2013-07-11	Yes	no
029437	community		25.5	1A69	54.7	1A69	54.7	5519	2.4	.165	.195	4LKR	2013-07-08	Yes	no
029521	community		26.5	1PR0	57.8	1PR0	57.8	5713	1.5	.164	.187	4LDN	2013-06-24	N/A	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.7	.178	.237	4LBX	2013-06-21	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.202	.248	4LCA	2013-06-21	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.7	.186	.238	4LC4	2013-06-21	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.174	.210	4LBG	2013-06-20	Yes	no
012251	biomedical		41.2	1IVH	64.6	1IVH	64.6	15186	2.1	.180	.227	4KTO	2013-05-20	Yes	no
019597	community		27.3	3OC7	98.5	3OC7	98.5	13397	1.9	.135	.165	4KNP	2013-05-10	N/A	no
012704		IFN	24.4	1I85	47.5	1I85	47.5	10329	2.2	.192	.241	4KKN	2013-05-06	N/A	no
028416	community		28.2	3HRX	34	3HRX	34	13606	2.2	.182	.230	4KD6	2013-04-24	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.8	.160	.217	4KBE	2013-04-23	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.165	.199	4KAL	2013-04-22	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.7	.170	.223	4KAD	2013-04-22	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.172	.201	4KAN	2013-04-22	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.8	.159	.208	4KAH	2013-04-22	Yes	no
011676	structural coverage		51.2	1JFU	9.2	2LJA	12.7	21874	1.8	.202	.247	4K9Z	2013-04-21	N/A	no
011676	structural coverage		51.2	1JFU	9.2	2LJA	12.7	21874	2.1	.208	.270	4KA0	2013-04-21	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.197	.226	4K93	2013-04-19	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.177	.199	4K9C	2013-04-19	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.7	.189	.243	4K9I	2013-04-19	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.182	.218	4K8K	2013-04-18	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.7	.246	.304	4K8T	2013-04-18	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.188	.236	4K8P	2013-04-18	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.211	.249	4K8C	2013-04-18	Yes	no
011441			17.7	3ERW	23.7	2LS5	26.3		-	-	-	2M72	2013-04-16	N/A	no
011447			19.7	1TIF	26.2	1TIF	26.2		-	-	-	2M71	2013-04-16	N/A	no
028219	community		29.3	3QKA	31.4	3QKA	31.4	26755	2.3	.197	.227	4K3W	2013-04-11	Yes	no
028235	community		28.0	3H81	37.1	3H81	37.1	25696	2.0	.196	.212	4K2N	2013-04-09	Yes	no
028229	community		29.5	3QXI	35	3QXI	35	27164	1.7	.182	.198	4K29	2013-04-08	Yes	no
028058	community		26.4	2PBP	35	2PBP	35	12997	2.4	.159	.190	4JYL	2013-03-29	Yes	no	Enoyl-CoA hydratase
490008			23.6	3LOC	99.5	3LOC	99.5	11088	1.5	.136	.176	4JYK	2013-03-29	N/A	no
028011	community		30.0	3T3W	27.5	3T3W	27.5	13489	2.2	.157	.207	4JYJ	2013-03-29	N/A	no
022848	biomedical		20.1	1YVO	40.6	1YVO	40.6	28110	1.1	.114	.135	4JXR	2013-03-28	Yes	no
022848	biomedical		20.1	1YVO	40.6	1YVO	40.6	28110	1.1	.122	.153	4JXQ	2013-03-28	Yes	no
021705	biomedical		32.0	1A3G	28.3	1A3G	28.3	4861	2.4	.169	.212	4JXU	2013-03-28	N/A	no
029304	community		25.5	3NM4	49	4JOS	53.2	6298	2.0	.178	.193	4JWT	2013-03-27	N/A	no
028051	community		27.3	3R9T	39.5	3R9T	39.5	13171	2.1	.143	.179	4JWV	2013-03-27	N/A	no
028034	community		29.1	3SLL	32.8	4JSB	99.6	13723	1.6	.137	.154	4JVT	2013-03-26	N/A	no
028034	community		29.1	3SLL	32.8	3SLL	32.8	13723	1.9	.142	.164	4JSB	2013-03-22	N/A	no
029335	community		25.1	3NM4	50.9	3NM4	50.9	5969	1.5	.152	.175	4JOS	2013-03-18	N/A	no
027999	community		26.8	3L3S	33	3L3S	33	12146	1.9	.194	.220	4JOT	2013-03-18	Yes	no
020441		NUP	58.3	2JPS	20	2JPS	20	3482	3.0	.187	.237	4JLQ	2013-03-12	N/A	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.168	.202	4JKS	2013-03-11	Yes	no
014306	biomedical		35.7	1LIO	27.7	4E3A	100	22713	1.5	.168	.205	4JKU	2013-03-11	Yes	no
005624		IFN	55.4	3ALP	19	4FRW	41.6	13098	2.2	.226	.292	4JJH	2013-03-07	N/A	no
026814	community		15.6	1OTG	24.1	4JCU	31	5924	1.8	.213	.234	4JJ9	2013-03-07	Yes	no
016193		IFN	38.3	1C1Z	94.2	1C1Z	94.2	39262	3.0	.211	.250	4JHS	2013-03-05	N/A	no
206359			42.0	3SJN	27.3	3SJN	27.3	6152	2.8	.197	.253	4JHM	2013-03-05	Yes	no
005691		IFN	25.9	1L6Z	30.5	1L6Z	30.5	12110	2.7	.204	.222	4JGJ	2013-03-01	N/A	no
028172	community		27.1	4FZW	38.3	4FZW	38.3	13378	2.2	.170	.211	4JFC	2013-02-28	Yes	no
026786	community		14.3	1OTG	40.6	1OTG	40.6	887	2.4	.207	.262	4JCU	2013-02-22	Yes	no
028137	community		28.9	4FZW	35.6	4FZW	35.6	24541	1.8	.211	.234	4JCS	2013-02-22	Yes	no
030813			46.8	1I09	99.8	1I09	99.8	29932	2.3	.191	.234	4J71	2013-02-12	N/A	no
012230	biomedical		38.3	2EIH	30.9	4EYE	31.3	20870	2.8	.157	.203	4J6F	2013-02-11	Yes	no
010744		CELLMAT	183.6	3H0G	5.3	3H0G	5.3	15560	-	-	-	2M4N	2013-02-07	N/A	no
019428		NUP	44.7	3P3D	9.9	3P3D	9.9	275	-	-	-	2M4M	2013-02-07	N/A	no
200855	community		43.5	2GL5	32.5	3RCY	69.2	5677	2.5	.213	.245	4J3Z	2013-02-06	Yes	no
028067	community		36.7	3BPT	37.4	4HDT	41	11485	2.0	.191	.244	4J2U	2013-02-05	Yes	no
021602	biomedical		27.2	1V6Z	32.7	1V6Z	32.7	9909	2.0	.248	.287	4J3C	2013-02-05	Yes	no
011708	biomedical		26.6	1VL8	41.1	4HP8	45.5	29890	2.1	.190	.215	4J2H	2013-02-04	Yes	no
012907	community		39.4	2PMQ	63.5	4E8G	100	4807	1.6	.159	.181	4J1O	2013-02-01	N/A	no
030813			46.8	1I09	99.8	1I09	99.8	29932	2.7	.174	.193	4J1R	2013-02-01	N/A	no
012907	community		39.4	2PMQ	63.5	4E8G	100	4807	1.7	.167	.197	4IZG	2013-01-29	N/A	no
011934	biomedical		53.5	1T90	40.9	4E4G	100	18637	2.2	.167	.209	4IYM	2013-01-28	Yes	no
016205	biomedical		27.9					2336	2.8	.194	.220	4IX1	2013-01-24	Yes	no
014123	biomedical		25.7	2PH3	39.9	4E3Z	65.3	29999	1.9	.150	.173	4IQG	2013-01-11	N/A	no
019330		NUP	191.5					580	3.2	.191	.243	4IFQ	2012-12-14	Yes	no
005598		IFN	51.3	1DGI	35.3	4FQP	35.7	9770	1.7	.188	.226	4HZA	2012-11-14	Yes	no
206080			49.3	1EC7	65.9	4G8T	66.1	5246	1.8	.165	.200	4HYR	2012-11-14	N/A	no
014483	biomedical		37.2	1YGY	24.5	1YGY	24.5	8864	2.8	.208	.292	4HY3	2012-11-12	Yes	no
005836		IFN	40.6	1B6U	16.3	3RJD	23.2	7867	2.0	.186	.229	4HWN	2012-11-08	Yes	no
005912		IFN	92.0	2PSQ	43.2	2PSQ	43.2	9316	2.9	.228	.252	4HWU	2012-11-08	Yes	no
020638	biomedical		20.3	2YJZ	31.3	2YJZ	31.3	22916	1.8	.207	.234	4HUJ	2012-11-02	Yes	no
012776		IFN	11.7	1M31	100	1M31	100	7486	2.2	.231	.277	4HSZ	2012-10-31	Yes	no
012831	biomedical		23.0	1AUG	52.6	4GXH	100	753	1.5	.174	.200	4HPS	2012-10-24	N/A	no
206066			51.0	3P0W	78.2	3P0W	78.2	5958	2.2	.178	.222	4HN8	2012-10-19	Yes	no
014990	biomedical		11.0	1X7V	31.3	1X7V	31.3	3288	1.9	.241	.273	4HL9	2012-10-16	N/A	no
026035			50.1	1YIR	40.9	1YIR	40.9	1884	1.8	.163	.201	4HL7	2012-10-16	Yes	no
016600	biomedical		36.5	1V8G	44.3	1V8G	44.3	2412	2.0	.189	.227	4HKM	2012-10-15	N/A	no
012312	biomedical		35.1	3EUW	45.6	3EUW	45.6	10060	2.0	.188	.232	4HKT	2012-10-15	N/A	no
018989	biomedical		50.2	3E04	64.5	3E04	64.5	22916	2.1	.199	.234	4HGV	2012-10-08	Yes	no
019494	biomedical		24.3	3R6H	84.8	4FN7	100	12300	2.5	.186	.249	4HC8	2012-09-28	N/A	no
012791	biomedical		45.6	2RGJ	28.5	2RGJ	28.5	10075	1.9	.177	.218	4HB9	2012-09-27	N/A	no
014311	biomedical		36.8	3RBV	30.2	3RBV	30.2	9570	2.0	.176	.206	4HAD	2012-09-26	Yes	no
011812	biomedical		26.9	3AI1	35.5	3AI1	35.5	29796	2.0	.164	.178	4H16	2012-09-10	Yes	no
011812	biomedical		26.9	3AI1	35.5	3AI1	35.5	29796	1.5	.150	.167	4H15	2012-09-10	Yes	no
012831	biomedical		23.0	1AUG	52.6	1AUG	52.6	753	2.7	.178	.219	4GXH	2012-09-04	Yes	no
011827	biomedical		19.3	1NWA	76.1	1NWA	76.1	2482	1.2	.160	.180	4GWB	2012-09-01	Yes	no
013655	biomedical		42.8	3EZY	24.4	4FB5	34.4	8783	2.4	.188	.230	4GQA	2012-08-22	N/A	no
014034	biomedical		47.0	1K75	39.7	4G07	48.4	13203	2.0	.195	.228	4GIC	2012-08-08	N/A	no
013613	biomedical		29.3	1QR2	37.7	1QR2	37.7	5619	1.8	.145	.163	4GI5	2012-08-08	N/A	no
012601	biomedical		27.8	1IM8	69.3	1IM8	69.3	21784	1.5	.172	.203	4GEK	2012-08-02	N/A	no
020704	biomedical		26.9	2AF7	13.4	2AF7	13.4	2513	1.8	.176	.192	4G9Q	2012-07-24	Yes	no
013445	biomedical		20.5	2ISJ	33	4DN2	75	6056	2.2	.165	.197	4G8S	2012-07-23	Yes	no
011107		IFN	16.6	2R30	58.8	2R30	58.8	441	1.9	.209	.244	4G4F	2012-07-16	Yes	no
028566			74.4	3S88	10.7	3S88	10.7	132	1.9	.198	.244	4G2K	2012-07-12	N/A	no
014285	biomedical		35.2	2CUK	38.4	2CUK	38.4	7573	1.7	.191	.218	4G2N	2012-07-12	Yes	no
011086		IFN	30.4	1JMA	57.2	1JMA	57.2	6918	2.2	.280	.292	4FHQ	2012-06-06	Yes	no
014337	biomedical		25.9	3TOX	39	3VC7	40.5	29997	1.8	.204	.226	4FGS	2012-06-04	Yes	no
012249	biomedical		17.0	1Q6W	38.1	1Q6W	38.1	4301	1.8	.168	.197	4FFU	2012-06-01	Yes	no
014359	biomedical		41.0	1EVJ	28.3	1EVJ	28.3	8707	2.6	.210	.266	4FB5	2012-05-22	Yes	no
013560	biomedical		112.1	3HAZ	29	3HAZ	29	15245	2.2	.188	.227	4F9I	2012-05-18	N/A	no
031145			24.4	1JYS	96.1	4F1W	99.6	6273	1.9	.188	.233	4F3C	2012-05-09	Yes	no
001582	biomedical		28.4	2UXA	27.3	4DZ1	100	12180	2.1	.191	.221	4F3S	2012-05-09	N/A	no
031145			24.4	1JYS	96.1	4F1W	99.6	6273	1.9	.179	.215	4F3K	2012-05-09	Yes	no
012061	biomedical		51.2	1WNB	60.9	4DAL	100	21524	2.0	.183	.233	4F3X	2012-05-09	Yes	no
031145			24.4	1JYS	96.1	4F1W	99.6	6273	1.6	.165	.193	4F2P	2012-05-08	Yes	no
031145			24.4	1JYS	96.1	4F1W	99.6	6273	2.0	.179	.216	4F2W	2012-05-08	Yes	no
031145			24.4	1JYS	96.1	1JYS	96.1	6273	1.4	.115	.146	4F1W	2012-05-07	Yes	no
019589	community		47.4	3LNP	46.4	4DYK	48.2	12494	1.9	.158	.185	4F0S	2012-05-04	Yes	no
011484			17.3	2KUC	20.9	2KUC	20.9	19733	-	-	-	2LST	2012-05-04	N/A	no
019589	community		47.4	3LNP	46.4	4DYK	48.2	12494	1.8	.165	.199	4F0R	2012-05-04	Yes	no
012024	biomedical		30.5	3QSG	35.1	3QSG	35.1	9961	2.1	.196	.244	4EZB	2012-05-02	Yes	no
014363	biomedical		33.7	3E18	23.9	3E18	23.9	8898	2.3	.246	.293	4EW6	2012-04-26	Yes	no
006047		IFN	29.8	1P6F	16	4ESK	38	9755	1.9	.202	.228	4ETY	2012-04-24	Yes	no
012776		IFN	11.7	1M31	100	1M31	100	7486	1.5	.211	.251	4ETO	2012-04-24	Yes	no
012068	biomedical		26.4	2CFC	34.4	3VC7	99.6	29448	1.9	.195	.234	4ESO	2012-04-23	Yes	no
006047		IFN	29.8	1P6F	16	1P6F	16	9755	1.8	.185	.216	4ESK	2012-04-23	Yes	no
020344		IFN	24.7	1SL6	26.9	1SL6	26.9	4301	-	-	-	2LS8	2012-04-23	N/A	no
011533			21.8	2YWN	22.5	2LRN	23	13613	-	-	-	2LS5	2012-04-20	N/A	no
011327			42.9	3FW2	11.5	3FW2	11.5	15029	-	-	-	2LRT	2012-04-13	N/A	no
011104		IFN	26.3	2O0O	22.9	2O0O	22.9	871	2.6	.236	.286	4EN0	2012-04-12	Yes	no
011666			44.8	2HYX	12.8	2HYX	12.8	16748	-	-	-	2LRN	2012-04-10	N/A	no
012003	biomedical		36.1	3IP1	32.8	3IP1	32.8	17180	2.1	.186	.220	4EJM	2012-04-06	N/A	no
012003	biomedical		36.1	3IP1	32.8	3IP1	32.8	17180	1.9	.177	.202	4EJ6	2012-04-06	N/A	no
012907	community		39.4	2PMQ	63.5	2PMQ	63.5	4807	2.0	.165	.202	4E8G	2012-03-20	N/A	no
012078	biomedical		27.2	1K2W	80.6	1K2W	80.6	29997	2.1	.163	.206	4E6P	2012-03-15	Yes	no
202090	community		44.4	2GL5	99.5	2GL5	99.5	5357	1.8	.175	.206	4E6M	2012-03-15	Yes	no
200750	community		44.2	2POD	32.8	4E4U	63.5	4763	2.9	.168	.242	4E5T	2012-03-14	Yes	no
200780	community		44.7	2QQ6	31.6	3RCY	52.3	4853	1.4	.134	.146	4E4U	2012-03-13	Yes	no
011119		IFN	19.7	3B93	51.7	4DB5	55.1	405	2.0	.148	.178	4E4S	2012-03-13	Yes	no
011934	biomedical		53.5	1T90	40.9	1T90	40.9	18637	2.9	.192	.269	4E4G	2012-03-12	Yes	no
014458	biomedical		25.9	1ULS	38.8	1ULS	38.8	29998	2.0	.168	.215	4E3Z	2012-03-11	Yes	no
013012	biomedical		38.7	2BI0	26.7	2BI0	26.7	3555	1.9	.143	.188	4E3E	2012-03-09	Yes	no
014306	biomedical		35.7	1LIO	27.7	3UBO	76.1	22713	1.6	.172	.228	4E3A	2012-03-09	Yes	no
013402	biomedical		36.6	2W8Z	32.9	2W8Z	32.9	6211	2.3	.198	.240	4E21	2012-03-07	Yes	no
012403	biomedical		54.4	3G25	55.9	3G25	55.9	4220	2.3	.233	.289	4E1J	2012-03-06	N/A	no
200456	community		48.5	3LNP	45.3	4DYK	48.1	10932	1.5	.209	.233	4DZH	2012-03-01	Yes	no
200449	community		48.5	3LNP	51.5	3LNP	51.5	10903	2.0	.177	.224	4DYK	2012-02-29	Yes	no
015235	biomedical		26.0	2EHD	34	4DRY	62	29997	1.8	.168	.205	4DYV	2012-02-29	N/A	no
014515	biomedical		36.5	3FBG	38.1	3FBG	38.1	15877	2.0	.165	.206	4DVJ	2012-02-23	N/A	no
014350	biomedical		34.8	2J8Z	37.5	2J8Z	37.5	16284	2.5	.225	.293	4DUP	2012-02-22	Yes	no
014181	biomedical		32.9	1V19	36	1V19	36	7099	2.7	.231	.295	4DU5	2012-02-21	N/A	no
012321	biomedical		26.5	2Q2Q	34.9	2Q2Q	34.9	29755	2.5	.209	.264	4DRY	2012-02-17	Yes	no
014530	biomedical		26.9	2D1Y	38.8	2D1Y	38.8	29997	2.0	.161	.198	4DQX	2012-02-16	N/A	no
013905	biomedical		11.4	2BBE	28.1	2BBE	28.1	3219	2.7	.238	.283	4DPO	2012-02-13	N/A	no
019670	community		42.2					3664	2.5	.177	.240	4DNH	2012-02-08	Yes	no
013409	biomedical		20.4	3GE5	36.6	3GE5	36.6	5601	1.5	.154	.194	4DN2	2012-02-08	Yes	no
012035	biomedical		49.9	3O0H	58.5	3O0H	58.5	17543	2.8	.211	.272	4DNA	2012-02-08	Yes	no
000360	biomedical		52.8	3PQA	36.1	3R64	44.9	12260	2.5	.185	.256	4DNG	2012-02-08	Yes	no
013101	biomedical		10.4					2971	2.0	.162	.226	4DN9	2012-02-08	Yes	no
012365		CELLMAT	28.1	1LVF	30.1	1LVF	30.1	163	1.4	.164	.200	4DND	2012-02-08	Yes	no
013885	biomedical		44.4	1VH4	10.8	1VH4	10.8	1836	1.6	.169	.232	4DN7	2012-02-08	Yes	no
014180	biomedical		31.3	1YB4	40.6	1YB4	40.6	7940	2.1	.221	.278	4DLL	2012-02-06	Yes	no
012131	biomedical		39.7	1F8G	57.3	1F8G	57.3	10015	2.6	.235	.287	4DIO	2012-01-31	Yes	no
011686	biomedical		33.6	3BA1	41	3BA1	41	6690	2.3	.298	.316	4DGS	2012-01-26	Yes	no
011123		IFN	20.0	2R32	50.6	2R32	50.6	490	1.5	.161	.176	4DB5	2012-01-13	Yes	no
012061	biomedical		51.2	1WNB	60.9	1WNB	60.9	21524	2.3	.187	.237	4DAL	2012-01-12	Yes	no
012178	biomedical		26.5	3OSU	36.2	3OSU	36.2	30000	2.5	.180	.231	4DA9	2012-01-12	Yes	no
012068	biomedical		26.4	2CFC	34.4	3V2G	34.8	29448	2.2	.182	.228	3VC7	2012-01-03	Yes	no
012316	biomedical		27.4	2P68	35.4	3TOX	36.9	29605	2.7	.190	.255	3V8B	2011-12-22	Yes	no
011931	biomedical		42.2	2GQF	43	2GQF	43	17262	2.5	.199	.251	3V76	2011-12-20	Yes	no
012133	biomedical		42.8	3DTY	38.1	3DTY	38.1	7698	2.8	.188	.252	3V5N	2011-12-16	Yes	no
490004			28.9	3FOB	26.3	3FOB	26.3	22429	2.1	.172	.226	3V48	2011-12-14	N/A	no	the α/β hydrolase with new putative catalytic triad, probable new family	protein enhances the rate of hydrolysis of aminoacrylate to malonic semialdehyde	difficult crystallization, difficult data processing
490003			13.7	2DYY	31.2	2DYY	31.2	4478	2.0	.195	.217	3V4D	2011-12-14	N/A	no	YjgF/YER057c/UK114 family of proteins, involved in removing potentially toxic secondary products of cellular enzymes	A possible function for the RutC protein is to reduce peroxy-aminoacrylate to aminoacrylate, as a part of detoxification process	difficult crystallization, difficult data processing
012211	biomedical		53.2	1EYY	45	1EYY	45	11981	1.9	.174	.225	3V4C	2011-12-14	Yes	no
012300	biomedical		27.2	1WMB	55.1	1WMB	55.1	29619	3.0	.229	.287	3V2H	2011-12-12	Yes	no
012233	biomedical		25.3	3ICC	42	3U5T	43.1	29996	2.3	.169	.205	3V2G	2011-12-12	Yes	no
491001			69.3	1AO6	72.6	1AO6	72.6	1845	2.7	.205	.256	3V03	2011-12-07	Yes	no	identification of residues responsible for calcium binding; identification of potential allergenic epitopes	maintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxide	difficult crystallization; see the database for details
491005			68.9	1AO6	71.4	1AO6	71.4	4892	2.3	.195	.243	3V09	2011-12-07	N/A	no	identification of new ligand binding site; identification of potential allergenic epitopes	maintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxide	difficult crystallization; see the database for details
491003			68.6	1AO6	73.3	1AO6	73.3	900	2.5	.206	.245	3V08	2011-12-07	Yes	no	identification of potential allergenic epitopes	maintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxide
012882	community		24.6	3AK4	37.9	3AK4	37.9	29662	2.1	.172	.212	3UXY	2011-12-05	Yes	no
012026	biomedical		45.2	1LWD	68.6	1LWD	68.6	3451	2.2	.182	.237	3US8	2011-11-23	Yes	no
012149	biomedical		48.7	1DXL	56.4	1DXL	56.4	17589	1.9	.187	.227	3URH	2011-11-22	Yes	no
011958	biomedical		30.3	1A80	38.2	1A80	38.2	11484	2.0	.212	.240	3UP8	2011-11-17	Yes	no
011697	biomedical		34.8	1VBI	36.4	1VBI	36.4	702	2.3	.192	.245	3UOE	2011-11-16	Yes	no
012081	biomedical		36.1	2EIH	36.4	2EIH	36.4	15060	2.2	.209	.249	3UOG	2011-11-16	Yes	no
012205	biomedical		25.4	1PR9	35.7	1PR9	35.7	29987	2.5	.188	.241	3UN1	2011-11-15	Yes	no
011952	biomedical		17.0	2WFC	49.7	2WFC	49.7	8370	2.2	.214	.241	3UMA	2011-11-12	Yes	no
001462	biomedical		38.6	2X26	13.8	2X26	13.8	9850	2.6	.199	.278	3UIF	2011-11-04	Yes	no
012102	biomedical		38.5	1KQ3	47.2	1KQ3	47.2	4970	2.3	.200	.264	3UHJ	2011-11-03	Yes	no
012406	biomedical		35.3	1LIO	28.8	1LIO	28.8	6638	2.6	.237	.267	3UBO	2011-10-24	Yes	no
200548	community		38.7	3IK4	51.5	3S5S	61.1	4305	2.4	.246	.285	3U9I	2011-10-19	Yes	no
012499	biomedical		32.0	3M1A	29	3M1A	29	29945	2.1	.187	.236	3U9L	2011-10-19	Yes	no
010986		CELLMAT	84.3	1H4R	9.4	1H4R	9.4	1036	2.5	.237	.309	3U7D	2011-10-13	Yes	no
012235	biomedical		25.0	3FTP	44.7	3FTP	44.7	29995	2.4	.246	.285	3U5T	2011-10-11	Yes	no
012111	biomedical		20.8	2YWI	45.6	2YWI	45.6	10947	2.0	.184	.232	3U5R	2011-10-11	Yes	no
012519	biomedical		53.7	1BI9	39.9	1BI9	39.9	10619	2.0	.189	.224	3U4J	2011-10-08	Yes	no
200834	community		41.0	3N4E	31.7	3TCS	84.1	4216	1.9	.182	.207	3U4F	2011-10-07	Yes	no
011880	biomedical		37.0	2P2S	42.9	2P2S	42.9	7081	2.8	.202	.253	3U3X	2011-10-06	Yes	no
012416	biomedical		45.8	2FIQ	46.7	2FIQ	46.7	1690	2.8	.243	.293	3TXV	2011-09-23	Yes	no
011673			49.6	2YP6	9.5	2YP6	9.5	2916	-	-	-	2LJA	2011-09-09	N/A	no
012473	biomedical		26.3	1UAY	58.8	1UAY	58.8	29226	2.3	.215	.270	3TPC	2011-09-07	N/A	no
012424	biomedical		25.3	2A4K	43.8	2A4K	43.8	29574	1.9	.203	.255	3TOX	2011-09-06	N/A	no
000283	biomedical		37.3	2QMI	31.3	2QMI	31.3	4212	2.2	.195	.230	3TG9	2011-08-17	Yes	no
000524	biomedical		24.7	3DUL	55.8	3DUL	55.8	20047	1.9	.206	.244	3TFW	2011-08-16	Yes	no
000529	biomedical		25.4	2YYT	45.8	2YYT	45.8	4922	2.2	.207	.252	3TFX	2011-08-16	Yes	no
012478	biomedical		25.1	2JAH	42	2JAH	42	29518	2.1	.178	.219	3TFO	2011-08-16	N/A	no
200604	community		41.2	3N4E	31.9	3T8Q	69.9	4301	1.9	.209	.216	3TCS	2011-08-09	Yes	no
200689	community		40.5	3N4E	28.4	3T8Q	65.8	4246	2.0	.183	.219	3T9P	2011-08-03	Yes	no
200881	community		41.1	3N4E	29.6	3N4E	29.6	4788	2.0	.153	.193	3T8Q	2011-08-01	N/A	no
012388	biomedical		31.7	3R1X	35.6	3R1X	35.6	214	2.5	.220	.277	3T69	2011-07-28	Yes	no
012386	biomedical		19.3	1KNQ	40.5	1KNQ	40.5	5787	2.2	.237	.250	3T61	2011-07-28	Yes	no
000813	biomedical		59.4	1ZLQ	24.3	3RQT	28.8	6363	2.8	.222	.274	3T66	2011-07-28	Yes	no
200833	community		44.2	2POD	31.2	3RCY	83.2	5314	2.5	.186	.240	3T4W	2011-07-26	Yes	no
200636	community		43.7	3BJS	29.8	3SQS	89.3	4255	1.9	.166	.185	3STP	2011-07-11	Yes	no
200756	community		44.0	2PPG	29.9	3SQS	86.7	4242	2.4	.186	.235	3SSZ	2011-07-08	Yes	no
200645	community		43.8	2OG9	29.4	2OG9	29.4	4502	1.9	.187	.208	3SQS	2011-07-06	Yes	no
012591	biomedical		77.5	2QY6	23.3	3PVC	98.9	7629	2.7	.184	.259	3SGL	2011-06-15	Yes	no
200551	community		37.2	3IK4	54.2	3IK4	54.2	4654	2.4	.196	.263	3S5S	2011-05-23	Yes	no
006165		IFN	26.3			3Q0H	47.5	9907	2.7	.208	.253	3RQ3	2011-04-27	Yes	no
005977		IFN	31.4	3KGR	35.2	3KGR	35.2	6875	2.6	.217	.293	3RP1	2011-04-26	Yes	no
000531	biomedical		50.4	3EFV	37.6	3EFV	37.6	17530	1.9	.192	.222	3ROS	2011-04-26	Yes	no
001422	biomedical		32.9	2H3H	24.9	2H3H	24.9	15710	1.9	.220	.254	3ROT	2011-04-26	Yes	no
000310	biomedical		45.5	1RF4	52.7	1RF4	52.7	4500	2.8	.226	.286	3RMT	2011-04-21	Yes	no
000337	biomedical		56.6	2BHP	50.4	3QAN	73.4	17320	2.2	.224	.292	3RJL	2011-04-15	Yes	no
000544	biomedical		14.3	2KJZ	45.2	2KJZ	45.2	14032	2.0	.219	.241	3RHE	2011-04-11	Yes	no
000584	biomedical		52.0	3EK1	46.3	3EK1	46.3	18128	2.6	.191	.252	3RH9	2011-04-11	Yes	no
000017	biomedical		51.1	1EUH	38.8	3PQA	100	17426	2.2	.182	.238	3RHD	2011-04-11	Yes	no
000308	biomedical		51.4	1EUH	57.6	3PRL	100	17541	2.3	.235	.297	3RHH	2011-04-11	Yes	no
000233	biomedical		49.9	2C72	32.7	2C72	32.7	10167	2.0	.159	.195	3RHA	2011-04-11	Yes	no
200688	community		44.2	2O56	31.5	2O56	31.5	9541	2.0	.148	.181	3RCY	2011-03-31	Yes	no
005622		IFN	44.6	1EVT	12.2	1EVT	12.2	9876	2.3	.201	.233	3RBG	2011-03-29	N/A	no
000196	biomedical		23.8	1W8G	38.9	1W8G	38.9	7532	1.9	.244	.245	3R79	2011-03-22	Yes	no
000469	biomedical		51.1	1BXS	36.1	1BXS	36.1	17674	2.6	.235	.282	3R64	2011-03-21	Yes	no
000084	biomedical		13.5					14304	1.8	.218	.234	3R6A	2011-03-21	Yes	no
000193	biomedical		15.4					13381	2.5	.230	.296	3R4Q	2011-03-17	N/A	no
000563	biomedical		24.7	3CBG	46.8	3CBG	46.8	18333	2.7	.265	.290	3R3H	2011-03-15	N/A	no
000191	biomedical		52.2	2WME	54.9	2WME	54.9	17499	2.2	.197	.245	3R31	2011-03-15	N/A	no
000560	biomedical		36.1	3KHJ	39.8	3KHJ	39.8	10040	1.9	.181	.207	3R2G	2011-03-14	N/A	no
200555	community		39.1	3JVA	33.1	3PX5	99.7	7520	1.9	.159	.185	3R1Z	2011-03-11	Yes	no
200555	community		39.1	3JVA	33.1	3PX5	99.7	7520	2.0	.161	.191	3R10	2011-03-09	Yes	no
200555	community		39.1	3JVA	33.1	3PX5	99.7	7520	1.9	.161	.195	3R0U	2011-03-09	Yes	no
200555	community		39.1	3JVA	33.1	3PX5	99.7	7520	2.0	.151	.181	3R11	2011-03-09	Yes	no
200555	community		39.1	3JVA	33.1	3JVA	33.1	7520	2.0	.167	.197	3R0K	2011-03-08	Yes	no
005598		IFN	51.3	1DGI	35.3	1DGI	35.3	9770	1.3	.153	.173	3R0N	2011-03-08	Yes	no
000296	biomedical		56.6	2BHP	49.9	2BHP	49.9	17552	2.0	.218	.280	3QAN	2011-01-11	Yes	no
006165		IFN	26.3					9907	1.7	.209	.237	3Q0H	2010-12-15	N/A	no
012591	biomedical		77.5	2QY6	23.3	3PS9	58.9	7629	2.3	.173	.231	3PVC	2010-12-06	Yes	no
000408	biomedical		34.3	3IM8	47.4	3IM8	47.4	6781	2.1	.220	.265	3PTW	2010-12-03	Yes	no
012590	biomedical		74.4	2QY6	36.2	2QY6	36.2	10356	2.5	.185	.247	3PS9	2010-12-01	Yes	no
000308	biomedical		51.4	1EUH	57.6	1EUH	57.6	17541	2.0	.251	.306	3PRL	2010-11-29	Yes	no
000017	biomedical		51.1	1EUH	38.8	1EUH	38.8	17426	1.5	.189	.222	3PQA	2010-11-25	Yes	no
011326			17.6	3KCM	27.7	3KCM	27.7	16768	-	-	-	2L5O	2010-11-03	N/A	no
011324			17.7	3HXS	49.7	3HXS	49.7	12270	-	-	-	2L5L	2010-11-02	N/A	no
011325			16.4					13293	-	-	-	2L57	2010-10-26	N/A	no
000290	biomedical		20.5	2YWR	38.3	2YWR	38.3	5475	1.9	.193	.226	3P9X	2010-10-18	Yes	no
000379	biomedical		35.0	1ZSW	35.9	1ZSW	35.9	7365	1.4	.182	.225	3OAJ	2010-08-05	Yes	no
000295	biomedical		15.3	3GM5	31.7	3GM5	31.7	11316	1.9	.198	.234	3OA4	2010-08-04	Yes	no

(default) 95 queries took 997 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT 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';	109	109	14
2	SELECT matviewname as name FROM pg_matviews;	0	0	1
3	SELECT 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';	109	109	3
4	SELECT matviewname as name FROM pg_matviews;	0	0	1
5	SELECT 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';	109	109	3
6	SELECT matviewname as name FROM pg_matviews;	0	0	1
7	SELECT 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';	109	109	3
8	SELECT matviewname as name FROM pg_matviews;	0	0	1
9	SELECT 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';	109	109	3
10	SELECT matviewname as name FROM pg_matviews;	0	0	1
11	SELECT 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';	109	109	3
12	SELECT matviewname as name FROM pg_matviews;	0	0	1
13	SELECT 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';	109	109	3
14	SELECT matviewname as name FROM pg_matviews;	0	0	1
15	SELECT 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';	109	109	5
16	SELECT matviewname as name FROM pg_matviews;	0	0	1
17	SELECT 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';	109	109	5
18	SELECT matviewname as name FROM pg_matviews;	0	0	1
19	SELECT 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';	109	109	5
20	SELECT matviewname as name FROM pg_matviews;	0	0	1
21	SELECT 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';	109	109	5
22	SELECT matviewname as name FROM pg_matviews;	0	0	1
23	SELECT 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';	109	109	5
24	SELECT matviewname as name FROM pg_matviews;	0	0	1
25	SELECT 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';	109	109	5
26	SELECT matviewname as name FROM pg_matviews;	0	0	1
27	SELECT 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';	109	109	5
28	SELECT matviewname as name FROM pg_matviews;	0	0	1
29	SELECT 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';	109	109	5
30	SELECT matviewname as name FROM pg_matviews;	0	0	1
31	SELECT 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';	109	109	4
32	SELECT matviewname as name FROM pg_matviews;	0	0	1
33	SELECT 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';	109	109	3
34	SELECT matviewname as name FROM pg_matviews;	0	0	1
35	SELECT 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';	109	109	3
36	SELECT matviewname as name FROM pg_matviews;	0	0	1
37	SELECT 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';	109	109	3
38	SELECT matviewname as name FROM pg_matviews;	0	0	1
39	SELECT 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';	109	109	3
40	SELECT matviewname as name FROM pg_matviews;	0	0	1
41	SELECT 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';	109	109	3
42	SELECT matviewname as name FROM pg_matviews;	0	0	1
43	SELECT 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';	109	109	3
44	SELECT matviewname as name FROM pg_matviews;	0	0	1
45	SELECT 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';	109	109	3
46	SELECT matviewname as name FROM pg_matviews;	0	0	1
47	SELECT 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';	109	109	3
48	SELECT matviewname as name FROM pg_matviews;	0	0	1
49	SELECT 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';	109	109	3
50	SELECT matviewname as name FROM pg_matviews;	0	0	1
51	SELECT 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';	109	109	3
52	SELECT matviewname as name FROM pg_matviews;	0	0	1
53	SELECT 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';	109	109	3
54	SELECT matviewname as name FROM pg_matviews;	0	0	1
55	SELECT 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';	109	109	3
56	SELECT matviewname as name FROM pg_matviews;	0	0	1
57	SELECT 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';	109	109	3
58	SELECT matviewname as name FROM pg_matviews;	0	0	1
59	SELECT 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';	109	109	3
60	SELECT matviewname as name FROM pg_matviews;	0	0	1
61	SELECT 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';	109	109	3
62	SELECT matviewname as name FROM pg_matviews;	0	0	1
63	SELECT 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';	109	109	3
64	SELECT matviewname as name FROM pg_matviews;	0	0	1
65	SELECT 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';	109	109	3
66	SELECT matviewname as name FROM pg_matviews;	0	0	1
67	SELECT 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';	109	109	3
68	SELECT matviewname as name FROM pg_matviews;	0	0	1
69	SELECT 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';	109	109	3
70	SELECT matviewname as name FROM pg_matviews;	0	0	1
71	SELECT 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';	109	109	3
72	SELECT matviewname as name FROM pg_matviews;	0	0	1
73	SELECT 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';	109	109	3
74	SELECT matviewname as name FROM pg_matviews;	0	0	1
75	SELECT 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';	109	109	3
76	SELECT matviewname as name FROM pg_matviews;	0	0	1
77	SELECT 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';	109	109	3
78	SELECT matviewname as name FROM pg_matviews;	0	0	1
79	SELECT 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';	109	109	3
80	SELECT matviewname as name FROM pg_matviews;	0	0	1
81	SELECT 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';	109	109	3
82	SELECT matviewname as name FROM pg_matviews;	0	0	1
83	SELECT 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';	109	109	3
84	SELECT matviewname as name FROM pg_matviews;	0	0	1
85	SELECT 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';	109	109	3
86	SELECT matviewname as name FROM pg_matviews;	0	0	1
87	SELECT 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';	109	109	3
88	SELECT matviewname as name FROM pg_matviews;	0	0	1
89	SELECT 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';	109	109	3
90	SELECT matviewname as name FROM pg_matviews;	0	0	1
91	SELECT 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';	109	109	3
92	SELECT matviewname as name FROM pg_matviews;	0	0	1
93	SELECT "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 1	0	0	2
94	SELECT "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 1	0	0	1
95	(select distinct dp.target_id as a, ( (case when t.structural_coverage = true then 'structural coverage' else '' end) \|\| (case when t.community_nominated = true and t.structural_coverage = true then ', ' else '' end) \|\| (case when t.community_nominated = true then 'community' else '' end) \|\| (case when t.metagenomic = true and (t.structural_coverage = true or t.community_nominated = true) then ', ' else '' end) \|\| (case when t.metagenomic = true then 'metagenomic' else '' end) \|\| (case when t.biomedical = true and (t.structural_coverage = true or t.community_nominated = true or t.metagenomic = true) then ', ' else '' end) \|\| (case when t.biomedical = true then 'biomedical' else '' end) ) as cat, t.partnership_nominated as partner, to_char(mw(sequence)/1000,'999D9') as c, (select homolog_pdb_id from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as d, (select relative_identity from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as e, (select homolog_pdb_id from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as d1, (select relative_identity from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as e1, t.family_coverage as f, to_char(ref_resolution,'9D9') as g, to_char(ref_r,'9D999') as h, to_char(ref_rfree,'9D999') as i, dp.pdb_id as l, dp.deposition_date as m, mypdb.sf as n, new_fold as r, functional_assignment as s, function_determined_experimentally as t, nih_raport_complicated_structure as v, nih_other_information as text from protein_target as t, (deposit as dp LEFT JOIN mypdb.pdbentry as mypdb on dp.pdb_id=mypdb.pdb_id LEFT JOIN deposit_annotation as an on dp.id=an.deposit_id LEFT JOIN structure as s on dp.structure_id=s.id ) where t.stage='in_pdb' and obsolete='f' and t.target_id=dp.target_id) UNION (select distinct dp.target_id as a, ' ' as cat, t.partnership_nominated as partner, to_char(mw(sequence)/1000,'999D9') as c, (select homolog_pdb_id from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as d, (select relative_identity from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as e, (select homolog_pdb_id from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as d1, (select relative_identity from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as e1, t.family_coverage as f, '-' as g, '-' as h, '-' as i, pdb_id as l, deposition_date as m, cast ('f' as boolean) as n, new_fold as r, functional_assignment as s, function_determined_experimentally as t, nih_raport_complicated_structure as v, nih_other_information as text from protein_target as t, (nmr_deposit as dp LEFT JOIN deposit_annotation as an on dp.id=an.deposit_id) where stage='in_pdb' and obsolete='f' and t.target_id=dp.target_id) order by m desc ;	286	286	782

(default) 95 queries took 997 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT 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';

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

109

SELECT matviewname as name FROM pg_matviews;

SELECT "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 1

(select distinct dp.target_id as a, ( (case when t.structural_coverage = true then 'structural coverage' else '' end) || (case when t.community_nominated = true and t.structural_coverage = true then ', ' else '' end) || (case when t.community_nominated = true then 'community' else '' end) || (case when t.metagenomic = true and (t.structural_coverage = true or t.community_nominated = true) then ', ' else '' end) || (case when t.metagenomic = true then 'metagenomic' else '' end) || (case when t.biomedical = true and (t.structural_coverage = true or t.community_nominated = true or t.metagenomic = true) then ', ' else '' end) || (case when t.biomedical = true then 'biomedical' else '' end) ) as cat, t.partnership_nominated as partner, to_char(mw(sequence)/1000,'999D9') as c, (select homolog_pdb_id from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as d, (select relative_identity from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as e, (select homolog_pdb_id from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as d1, (select relative_identity from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as e1, t.family_coverage as f, to_char(ref_resolution,'9D9') as g, to_char(ref_r,'9D999') as h, to_char(ref_rfree,'9D999') as i, dp.pdb_id as l, dp.deposition_date as m, mypdb.sf as n, new_fold as r, functional_assignment as s, function_determined_experimentally as t, nih_raport_complicated_structure as v, nih_other_information as text from protein_target as t, (deposit as dp LEFT JOIN mypdb.pdbentry as mypdb on dp.pdb_id=mypdb.pdb_id LEFT JOIN deposit_annotation as an on dp.id=an.deposit_id LEFT JOIN structure as s on dp.structure_id=s.id ) where t.stage='in_pdb' and obsolete='f' and t.target_id=dp.target_id) UNION (select distinct dp.target_id as a, ' ' as cat, t.partnership_nominated as partner, to_char(mw(sequence)/1000,'999D9') as c, (select homolog_pdb_id from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as d, (select relative_identity from deposit_pdb_homolog_at_selection_table where pdb_id=dp.pdb_id) as e, (select homolog_pdb_id from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as d1, (select relative_identity from deposit_pdb_homolog_at_deposition_table where pdb_id=dp.pdb_id) as e1, t.family_coverage as f, '-' as g, '-' as h, '-' as i, pdb_id as l, deposition_date as m, cast ('f' as boolean) as n, new_fold as r, functional_assignment as s, function_determined_experimentally as t, nih_raport_complicated_structure as v, nih_other_information as text from protein_target as t, (nmr_deposit as dp LEFT JOIN deposit_annotation as an on dp.id=an.deposit_id) where stage='in_pdb' and obsolete='f' and t.target_id=dp.target_id) order by m desc ;

286

782

(labdb) 2 queries took 3 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';		293	293	2
2	SELECT matviewname as name FROM pg_matviews;		0	0	1

(labdb) 2 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';

293

SELECT matviewname as name FROM pg_matviews;