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
Publications
012132biomedical 34.23BA142.53BA142.5 2.3 .146 .1695J232016-03-29N/Ano
491003 68.61AO673.33V0896900 2.4 .195 .2555IJE2016-03-01N/Ano
030805biomedical 27.11NKV71.85BP781 1.9 #.### .1675EPE2015-11-11N/Ano
491003 68.61AO673.33V0896900 2.2 .181 .2415DQF2015-09-14N/Ano
028317community 27.41UIY35.84OLQ100 2.1 .198 .2325C9G2015-06-26Yesno
014667biomedical 33.93KBO35.24ZQB100 2.2 .197 .2525C5I2015-06-19N/Ano
030807biomedical 17.34QVG25.7 1.8 .150 .1885BXY2015-06-09N/Ano
014307biomedical 35.43KBO33.64WEQ60.5 1.5 .139 .1655BQF2015-05-29N/Ano
030788biomedical 27.11NKV74.61NKV74.6 2.1 .186 .2235BP72015-05-27N/Ano
030801biomedical 29.02WAF34.62WAF34.6 1.5 .134 .1795BP92015-05-27N/Ano
011884biomedical 34.63KBO35.44WEQ100 1.7 #.### .1504Z0P2015-03-26Yesno
022189biomedical 57.02QNE40.42QNE40.4 1.6 .139 .1654YYC2015-03-23Yesno
014260biomedical 37.31LQA33.11LQA33.1 1.9 .161 .1854XK22015-01-09N/Ano
014307biomedical 35.43KBO33.64WEQ60.5 1.4 .151 .1784XCV2014-12-18N/Ano
012048biomedical 30.73D3F34.94PMJ100 2.2 .160 .2254XAP2014-12-15N/Ano
015257biomedical 34.63KBO38.93KBO38.9 1.9 .163 .2094XA82014-12-12N/Ano
022550biomedical 33.02G5C32.32G5C32.3 1.4 .115 .1594WJI2014-09-30Yesno
013574biomedical 31.63D3F32.84PMJ51.4 1.8 #.### .1854WGH2014-09-18N/Ano
011884biomedical 34.63KBO35.44N1839.2 2.0 #.### .1964WEQ2014-09-10N/Ano
021011biomedical 57.41ZLQ28.44OER29.9 2.3 #.### .2284WED2014-09-09N/Ano
028014community 26.63OC734.94OLQ37.4 1.8 .168 .1934WCZ2014-09-05N/Ano
021736biomedical 39.53LY128.14R2N32.4 1.6 #.### .1634WBT2014-09-03N/Ano
021002biomedical 11.5 2.3 #.### .2244U132014-07-14N/Ano
012048biomedical 30.73D3F34.93D3F34.9 2.2 .170 .2174PMJ2014-05-21N/Ano
028034community 29.13SLL32.84JVT10013723 1.9 .155 .1814OMR2014-01-27N/Ano
028317community 27.41UIY35.81UIY35.8 2.7 .229 .2624OLQ2014-01-24N/Ano
028010community 29.12EJ533.62EJ533.6 2.0 .168 .1974OG12014-01-15Yesno
014094biomedical 34.42XHZ29.42XHZ29.4 1.9 .150 .1894O9K2014-01-02Yesno
028313community 26.93FDU40.23FDU40.2 2.3 .178 .2074NEK2013-10-29N/Ano
012711IFN 25.91AH131.71AH131.7 2.3 .175 .2124N8P2013-10-17Yesno
005804IFN 120.73JXA21.93JXA21.9 1.8 .172 .2194N682013-10-11Yesno
006240IFN 211.71LAR30.21LAR30.2 1.5 .164 .1984N5U2013-10-10Yesno
013675biomedical 34.23KBO37.73KBO37.7 2.0 .183 .2204N182013-10-03Yesno
028282community 28.81UIY324LK534.5 2.2 .173 .2114MOU2013-09-12N/Ano
021389biomedical 26.53ERF24.83ERF24.8 1.8 .163 .1904MDC2013-08-22Yesno
029452community 34.83PQD64.74LMR1005640 1.9 .210 .2414LN12013-07-11Yesno
029362community 29.81M7347.11M7347.1 2.1 .174 .2164LNA2013-07-11Yesno
029437community 25.51A6954.71A6954.75519 2.4 .165 .1954LKR2013-07-08Yesno
029521community 26.51PR057.81PR057.85713 1.5 .164 .1874LDN2013-06-24N/Ano
014306biomedical 35.71LIO27.74E3A10022713 1.7 .178 .2374LBX2013-06-21Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .202 .2484LCA2013-06-21Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.7 .186 .2384LC42013-06-21Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .174 .2104LBG2013-06-20Yesno
012251biomedical 41.21IVH64.61IVH64.615186 2.1 .180 .2274KTO2013-05-20Yesno
019597community 27.33OC798.53OC798.513397 1.9 .135 .1654KNP2013-05-10N/Ano
012704IFN 24.41I8547.51I8547.510329 2.2 .192 .2414KKN2013-05-06N/Ano
028416community 28.23HRX343HRX3413606 2.2 .182 .2304KD62013-04-24Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.8 .160 .2174KBE2013-04-23Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .165 .1994KAL2013-04-22Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.7 .170 .2234KAD2013-04-22Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .172 .2014KAN2013-04-22Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.8 .159 .2084KAH2013-04-22Yesno
011676structural coverage 51.21JFU9.22LJA12.721874 1.8 .202 .2474K9Z2013-04-21N/Ano
011676structural coverage 51.21JFU9.22LJA12.721874 2.1 .208 .2704KA02013-04-21Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .197 .2264K932013-04-19Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .177 .1994K9C2013-04-19Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.7 .189 .2434K9I2013-04-19Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .182 .2184K8K2013-04-18Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.7 .246 .3044K8T2013-04-18Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .188 .2364K8P2013-04-18Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .211 .2494K8C2013-04-18Yesno
011441 17.73ERW23.72LS526.3---2M722013-04-16N/Ano
011447 19.71TIF26.21TIF26.2---2M712013-04-16N/Ano
028219community 29.33QKA31.43QKA31.426755 2.3 .197 .2274K3W2013-04-11Yesno
028235community 28.03H8137.13H8137.125696 2.0 .196 .2124K2N2013-04-09Yesno
028229community 29.53QXI353QXI3527164 1.7 .182 .1984K292013-04-08Yesno
028058community 26.42PBP352PBP3512997 2.4 .159 .1904JYL2013-03-29YesnoEnoyl-CoA hydratase
490008 23.63LOC99.53LOC99.511088 1.5 .136 .1764JYK2013-03-29N/Ano
028011community 30.03T3W27.53T3W27.513489 2.2 .157 .2074JYJ2013-03-29N/Ano
022848biomedical 20.11YVO40.61YVO40.628110 1.1 .114 .1354JXR2013-03-28Yesno
022848biomedical 20.11YVO40.61YVO40.628110 1.1 .122 .1534JXQ2013-03-28Yesno
021705biomedical 32.01A3G28.31A3G28.34861 2.4 .169 .2124JXU2013-03-28N/Ano
029304community 25.53NM4494JOS53.26298 2.0 .178 .1934JWT2013-03-27N/Ano
028051community 27.33R9T39.53R9T39.513171 2.1 .143 .1794JWV2013-03-27N/Ano
028034community 29.13SLL32.84JSB99.613723 1.6 .137 .1544JVT2013-03-26N/Ano
028034community 29.13SLL32.83SLL32.813723 1.9 .142 .1644JSB2013-03-22N/Ano
029335community 25.13NM450.93NM450.95969 1.5 .152 .1754JOS2013-03-18N/Ano
027999community 26.83L3S333L3S3312146 1.9 .194 .2204JOT2013-03-18Yesno
020441NUP 58.32JPS202JPS203482 3.0 .187 .2374JLQ2013-03-12N/Ano
014306biomedical 35.71LIO27.74E3A10022713 1.5 .168 .2024JKS2013-03-11Yesno
014306biomedical 35.71LIO27.74E3A10022713 1.5 .168 .2054JKU2013-03-11Yesno
005624IFN 55.43ALP194FRW41.613098 2.2 .226 .2924JJH2013-03-07N/Ano
026814community 15.61OTG24.14JCU315924 1.8 .213 .2344JJ92013-03-07Yesno
016193IFN 38.31C1Z94.21C1Z94.239262 3.0 .211 .2504JHS2013-03-05N/Ano
206359 42.03SJN27.33SJN27.36152 2.8 .197 .2534JHM2013-03-05Yesno
005691IFN 25.91L6Z30.51L6Z30.512110 2.7 .204 .2224JGJ2013-03-01N/Ano
028172community 27.14FZW38.34FZW38.313378 2.2 .170 .2114JFC2013-02-28Yesno
026786community 14.31OTG40.61OTG40.6887 2.4 .207 .2624JCU2013-02-22Yesno
028137community 28.94FZW35.64FZW35.624541 1.8 .211 .2344JCS2013-02-22Yesno
030813 46.81I0999.81I0999.829932 2.3 .191 .2344J712013-02-12N/Ano
012230biomedical 38.32EIH30.94EYE31.320870 2.8 .157 .2034J6F2013-02-11Yesno
010744 CELLMAT 183.63H0G5.33H0G5.315560---2M4N2013-02-07N/Ano
019428 NUP 44.73P3D9.93P3D9.9275---2M4M2013-02-07N/Ano
200855community 43.52GL532.53RCY69.25677 2.5 .213 .2454J3Z2013-02-06Yesno
028067community 36.73BPT37.44HDT4111485 2.0 .191 .2444J2U2013-02-05Yesno
021602biomedical 27.21V6Z32.71V6Z32.79909 2.0 .248 .2874J3C2013-02-05Yesno
011708biomedical 26.61VL841.14HP845.529890 2.1 .190 .2154J2H2013-02-04Yesno
012907community 39.42PMQ63.54E8G1004807 1.6 .159 .1814J1O2013-02-01N/Ano
030813 46.81I0999.81I0999.829932 2.7 .174 .1934J1R2013-02-01N/Ano
012907community 39.42PMQ63.54E8G1004807 1.7 .167 .1974IZG2013-01-29N/Ano
011934biomedical 53.51T9040.94E4G10018637 2.2 .167 .2094IYM2013-01-28Yesno
016205biomedical 27.92336 2.8 .194 .2204IX12013-01-24Yesno
014123biomedical 25.72PH339.94E3Z65.329999 1.9 .150 .1734IQG2013-01-11N/Ano
019330NUP 191.5580 3.2 .191 .2434IFQ2012-12-14Yesno
005598IFN 51.31DGI35.34FQP35.79770 1.7 .188 .2264HZA2012-11-14Yesno
206080 49.31EC765.94G8T66.15246 1.8 .165 .2004HYR2012-11-14N/Ano
014483biomedical 37.21YGY24.51YGY24.58864 2.8 .208 .2924HY32012-11-12Yesno
005836IFN 40.61B6U16.33RJD23.27867 2.0 .186 .2294HWN2012-11-08Yesno
005912IFN 92.02PSQ43.22PSQ43.29316 2.9 .228 .2524HWU2012-11-08Yesno
020638biomedical 20.32YJZ31.32YJZ31.322916 1.8 .207 .2344HUJ2012-11-02Yesno
012776IFN 11.71M311001M311007486 2.2 .231 .2774HSZ2012-10-31Yesno
012831biomedical 23.01AUG52.64GXH100753 1.5 .174 .2004HPS2012-10-24N/Ano
206066 51.03P0W78.23P0W78.25958 2.2 .178 .2224HN82012-10-19Yesno
014990biomedical 11.01X7V31.31X7V31.33288 1.9 .241 .2734HL92012-10-16N/Ano
026035 50.11YIR40.91YIR40.91884 1.8 .163 .2014HL72012-10-16Yesno
016600biomedical 36.51V8G44.31V8G44.32412 2.0 .189 .2274HKM2012-10-15N/Ano
012312biomedical 35.13EUW45.63EUW45.610060 2.0 .188 .2324HKT2012-10-15N/Ano
018989biomedical 50.23E0464.53E0464.522916 2.1 .199 .2344HGV2012-10-08Yesno
019494biomedical 24.33R6H84.84FN710012300 2.5 .186 .2494HC82012-09-28N/Ano
012791biomedical 45.62RGJ28.52RGJ28.510075 1.9 .177 .2184HB92012-09-27N/Ano
014311biomedical 36.83RBV30.23RBV30.29570 2.0 .176 .2064HAD2012-09-26Yesno
011812biomedical 26.93AI135.53AI135.529796 2.0 .164 .1784H162012-09-10Yesno
011812biomedical 26.93AI135.53AI135.529796 1.5 .150 .1674H152012-09-10Yesno
012831biomedical 23.01AUG52.61AUG52.6753 2.7 .178 .2194GXH2012-09-04Yesno
011827biomedical 19.31NWA76.11NWA76.12482 1.2 .160 .1804GWB2012-09-01Yesno
013655biomedical 42.83EZY24.44FB534.48783 2.4 .188 .2304GQA2012-08-22N/Ano
014034biomedical 47.01K7539.74G0748.413203 2.0 .195 .2284GIC2012-08-08N/Ano
013613biomedical 29.31QR237.71QR237.75619 1.8 .145 .1634GI52012-08-08N/Ano
012601biomedical 27.81IM869.31IM869.321784 1.5 .172 .2034GEK2012-08-02N/Ano
020704biomedical 26.92AF713.42AF713.42513 1.8 .176 .1924G9Q2012-07-24Yesno
013445biomedical 20.52ISJ334DN2756056 2.2 .165 .1974G8S2012-07-23Yesno
011107IFN 16.62R3058.82R3058.8441 1.9 .209 .2444G4F2012-07-16Yesno
028566 74.43S8810.73S8810.7132 1.9 .198 .2444G2K2012-07-12N/Ano
014285biomedical 35.22CUK38.42CUK38.47573 1.7 .191 .2184G2N2012-07-12Yesno
011086IFN 30.41JMA57.21JMA57.26918 2.2 .280 .2924FHQ2012-06-06Yesno
014337biomedical 25.93TOX393VC740.529997 1.8 .204 .2264FGS2012-06-04Yesno
012249biomedical 17.01Q6W38.11Q6W38.14301 1.8 .168 .1974FFU2012-06-01Yesno
014359biomedical 41.01EVJ28.31EVJ28.38707 2.6 .210 .2664FB52012-05-22Yesno
013560biomedical 112.13HAZ293HAZ2915245 2.2 .188 .2274F9I2012-05-18N/Ano
031145 24.41JYS96.14F1W99.66273 1.9 .188 .2334F3C2012-05-09Yesno
001582biomedical 28.42UXA27.34DZ110012180 2.1 .191 .2214F3S2012-05-09N/Ano
031145 24.41JYS96.14F1W99.66273 1.9 .179 .2154F3K2012-05-09Yesno
012061biomedical 51.21WNB60.94DAL10021524 2.0 .183 .2334F3X2012-05-09Yesno
031145 24.41JYS96.14F1W99.66273 1.6 .165 .1934F2P2012-05-08Yesno
031145 24.41JYS96.14F1W99.66273 2.0 .179 .2164F2W2012-05-08Yesno
031145 24.41JYS96.11JYS96.16273 1.4 .115 .1464F1W2012-05-07Yesno
019589community 47.43LNP46.44DYK48.212494 1.9 .158 .1854F0S2012-05-04Yesno
011484 17.32KUC20.92KUC20.919733---2LST2012-05-04N/Ano
019589community 47.43LNP46.44DYK48.212494 1.8 .165 .1994F0R2012-05-04Yesno
012024biomedical 30.53QSG35.13QSG35.19961 2.1 .196 .2444EZB2012-05-02Yesno
014363biomedical 33.73E1823.93E1823.98898 2.3 .246 .2934EW62012-04-26Yesno
006047IFN 29.81P6F164ESK389755 1.9 .202 .2284ETY2012-04-24Yesno
012776IFN 11.71M311001M311007486 1.5 .211 .2514ETO2012-04-24Yesno
012068biomedical 26.42CFC34.43VC799.629448 1.9 .195 .2344ESO2012-04-23Yesno
006047IFN 29.81P6F161P6F169755 1.8 .185 .2164ESK2012-04-23Yesno
020344 IFN 24.71SL626.91SL626.94301---2LS82012-04-23N/Ano
011533 21.82YWN22.52LRN2313613---2LS52012-04-20N/Ano
011327 42.93FW211.53FW211.515029---2LRT2012-04-13N/Ano
011104IFN 26.32O0O22.92O0O22.9871 2.6 .236 .2864EN02012-04-12Yesno
011666 44.82HYX12.82HYX12.816748---2LRN2012-04-10N/Ano
012003biomedical 36.13IP132.83IP132.817180 2.1 .186 .2204EJM2012-04-06N/Ano
012003biomedical 36.13IP132.83IP132.817180 1.9 .177 .2024EJ62012-04-06N/Ano
012907community 39.42PMQ63.52PMQ63.54807 2.0 .165 .2024E8G2012-03-20N/Ano
012078biomedical 27.21K2W80.61K2W80.629997 2.1 .163 .2064E6P2012-03-15Yesno
202090community 44.42GL599.52GL599.55357 1.8 .175 .2064E6M2012-03-15Yesno
200750community 44.22POD32.84E4U63.54763 2.9 .168 .2424E5T2012-03-14Yesno
200780community 44.72QQ631.63RCY52.34853 1.4 .134 .1464E4U2012-03-13Yesno
011119IFN 19.73B9351.74DB555.1405 2.0 .148 .1784E4S2012-03-13Yesno
011934biomedical 53.51T9040.91T9040.918637 2.9 .192 .2694E4G2012-03-12Yesno
014458biomedical 25.91ULS38.81ULS38.829998 2.0 .168 .2154E3Z2012-03-11Yesno
013012biomedical 38.72BI026.72BI026.73555 1.9 .143 .1884E3E2012-03-09Yesno
014306biomedical 35.71LIO27.73UBO76.122713 1.6 .172 .2284E3A2012-03-09Yesno
013402biomedical 36.62W8Z32.92W8Z32.96211 2.3 .198 .2404E212012-03-07Yesno
012403biomedical 54.43G2555.93G2555.94220 2.3 .233 .2894E1J2012-03-06N/Ano
200456community 48.53LNP45.34DYK48.110932 1.5 .209 .2334DZH2012-03-01Yesno
200449community 48.53LNP51.53LNP51.510903 2.0 .177 .2244DYK2012-02-29Yesno
015235biomedical 26.02EHD344DRY6229997 1.8 .168 .2054DYV2012-02-29N/Ano
014515biomedical 36.53FBG38.13FBG38.115877 2.0 .165 .2064DVJ2012-02-23N/Ano
014350biomedical 34.82J8Z37.52J8Z37.516284 2.5 .225 .2934DUP2012-02-22Yesno
014181biomedical 32.91V19361V19367099 2.7 .231 .2954DU52012-02-21N/Ano
012321biomedical 26.52Q2Q34.92Q2Q34.929755 2.5 .209 .2644DRY2012-02-17Yesno
014530biomedical 26.92D1Y38.82D1Y38.829997 2.0 .161 .1984DQX2012-02-16N/Ano
013905biomedical 11.42BBE28.12BBE28.13219 2.7 .238 .2834DPO2012-02-13N/Ano
019670community 42.23664 2.5 .177 .2404DNH2012-02-08Yesno
013409biomedical 20.43GE536.63GE536.65601 1.5 .154 .1944DN22012-02-08Yesno
012035biomedical 49.93O0H58.53O0H58.517543 2.8 .211 .2724DNA2012-02-08Yesno
000360biomedical 52.83PQA36.13R6444.912260 2.5 .185 .2564DNG2012-02-08Yesno
013101biomedical 10.42971 2.0 .162 .2264DN92012-02-08Yesno
012365CELLMAT 28.11LVF30.11LVF30.1163 1.4 .164 .2004DND2012-02-08Yesno
013885biomedical 44.41VH410.81VH410.81836 1.6 .169 .2324DN72012-02-08Yesno
014180biomedical 31.31YB440.61YB440.67940 2.1 .221 .2784DLL2012-02-06Yesno
012131biomedical 39.71F8G57.31F8G57.310015 2.6 .235 .2874DIO2012-01-31Yesno
011686biomedical 33.63BA1413BA1416690 2.3 .298 .3164DGS2012-01-26Yesno
011123IFN 20.02R3250.62R3250.6490 1.5 .161 .1764DB52012-01-13Yesno
012061biomedical 51.21WNB60.91WNB60.921524 2.3 .187 .2374DAL2012-01-12Yesno
012178biomedical 26.53OSU36.23OSU36.230000 2.5 .180 .2314DA92012-01-12Yesno
012068biomedical 26.42CFC34.43V2G34.829448 2.2 .182 .2283VC72012-01-03Yesno
012316biomedical 27.42P6835.43TOX36.929605 2.7 .190 .2553V8B2011-12-22Yesno
011931biomedical 42.22GQF432GQF4317262 2.5 .199 .2513V762011-12-20Yesno
012133biomedical 42.83DTY38.13DTY38.17698 2.8 .188 .2523V5N2011-12-16Yesno
490004 28.93FOB26.33FOB26.322429 2.1 .172 .2263V482011-12-14N/Anothe α/β hydrolase with new putative catalytic triad, probable new familyprotein enhances the rate of hydrolysis of aminoacrylate to malonic semialdehydedifficult crystallization, difficult data processing
490003 13.72DYY31.22DYY31.24478 2.0 .195 .2173V4D2011-12-14N/AnoYjgF/YER057c/UK114 family of proteins, involved in removing potentially toxic secondary products of cellular enzymesA possible function for the RutC protein is to reduce peroxy-aminoacrylate to aminoacrylate, as a part of detoxification processdifficult crystallization, difficult data processing
012211biomedical 53.21EYY451EYY4511981 1.9 .174 .2253V4C2011-12-14Yesno
012300biomedical 27.21WMB55.11WMB55.129619 3.0 .229 .2873V2H2011-12-12Yesno
012233biomedical 25.33ICC423U5T43.129996 2.3 .169 .2053V2G2011-12-12Yesno
491001 69.31AO672.61AO672.61845 2.7 .205 .2563V032011-12-07Yesnoidentification of residues responsible for calcium binding; identification of potential allergenic epitopesmaintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxidedifficult crystallization; see the database for details
491005 68.91AO671.41AO671.44892 2.3 .195 .2433V092011-12-07N/Anoidentification of new ligand binding site; identification of potential allergenic epitopesmaintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxidedifficult crystallization; see the database for details
491003 68.61AO673.31AO673.3900 2.5 .206 .2453V082011-12-07Yesnoidentification of potential allergenic epitopesmaintaining the osmotic pressure; transporter for a diverse range of metabolites, drugs, nutrients, metals and other molecules; reservoir of the signaling agent nitric oxide
012882community 24.63AK437.93AK437.929662 2.1 .172 .2123UXY2011-12-05Yesno
012026biomedical 45.21LWD68.61LWD68.63451 2.2 .182 .2373US82011-11-23Yesno
012149biomedical 48.71DXL56.41DXL56.417589 1.9 .187 .2273URH2011-11-22Yesno
011958biomedical 30.31A8038.21A8038.211484 2.0 .212 .2403UP82011-11-17Yesno
011697biomedical 34.81VBI36.41VBI36.4702 2.3 .192 .2453UOE2011-11-16Yesno
012081biomedical 36.12EIH36.42EIH36.415060 2.2 .209 .2493UOG2011-11-16Yesno
012205biomedical 25.41PR935.71PR935.729987 2.5 .188 .2413UN12011-11-15Yesno
011952biomedical 17.02WFC49.72WFC49.78370 2.2 .214 .2413UMA2011-11-12Yesno
001462biomedical 38.62X2613.82X2613.89850 2.6 .199 .2783UIF2011-11-04Yesno
012102biomedical 38.51KQ347.21KQ347.24970 2.3 .200 .2643UHJ2011-11-03Yesno
012406biomedical 35.31LIO28.81LIO28.86638 2.6 .237 .2673UBO2011-10-24Yesno
200548community 38.73IK451.53S5S61.14305 2.4 .246 .2853U9I2011-10-19Yesno
012499biomedical 32.03M1A293M1A2929945 2.1 .187 .2363U9L2011-10-19Yesno
010986CELLMAT 84.31H4R9.41H4R9.41036 2.5 .237 .3093U7D2011-10-13Yesno
012235biomedical 25.03FTP44.73FTP44.729995 2.4 .246 .2853U5T2011-10-11Yesno
012111biomedical 20.82YWI45.62YWI45.610947 2.0 .184 .2323U5R2011-10-11Yesno
012519biomedical 53.71BI939.91BI939.910619 2.0 .189 .2243U4J2011-10-08Yesno
200834community 41.03N4E31.73TCS84.14216 1.9 .182 .2073U4F2011-10-07Yesno
011880biomedical 37.02P2S42.92P2S42.97081 2.8 .202 .2533U3X2011-10-06Yesno
012416biomedical 45.82FIQ46.72FIQ46.71690 2.8 .243 .2933TXV2011-09-23Yesno
011673 49.62YP69.52YP69.52916---2LJA2011-09-09N/Ano
012473biomedical 26.31UAY58.81UAY58.829226 2.3 .215 .2703TPC2011-09-07N/Ano
012424biomedical 25.32A4K43.82A4K43.829574 1.9 .203 .2553TOX2011-09-06N/Ano
000283biomedical 37.32QMI31.32QMI31.34212 2.2 .195 .2303TG92011-08-17Yesno
000524biomedical 24.73DUL55.83DUL55.820047 1.9 .206 .2443TFW2011-08-16Yesno
000529biomedical 25.42YYT45.82YYT45.84922 2.2 .207 .2523TFX2011-08-16Yesno
012478biomedical 25.12JAH422JAH4229518 2.1 .178 .2193TFO2011-08-16N/Ano
200604community 41.23N4E31.93T8Q69.94301 1.9 .209 .2163TCS2011-08-09Yesno
200689community 40.53N4E28.43T8Q65.84246 2.0 .183 .2193T9P2011-08-03Yesno
200881community 41.13N4E29.63N4E29.64788 2.0 .153 .1933T8Q2011-08-01N/Ano
012388biomedical 31.73R1X35.63R1X35.6214 2.5 .220 .2773T692011-07-28Yesno
012386biomedical 19.31KNQ40.51KNQ40.55787 2.2 .237 .2503T612011-07-28Yesno
000813biomedical 59.41ZLQ24.33RQT28.86363 2.8 .222 .2743T662011-07-28Yesno
200833community 44.22POD31.23RCY83.25314 2.5 .186 .2403T4W2011-07-26Yesno
200636community 43.73BJS29.83SQS89.34255 1.9 .166 .1853STP2011-07-11Yesno
200756community 44.02PPG29.93SQS86.74242 2.4 .186 .2353SSZ2011-07-08Yesno
200645community 43.82OG929.42OG929.44502 1.9 .187 .2083SQS2011-07-06Yesno
012591biomedical 77.52QY623.33PVC98.97629 2.7 .184 .2593SGL2011-06-15Yesno
200551community 37.23IK454.23IK454.24654 2.4 .196 .2633S5S2011-05-23Yesno
006165IFN 26.33Q0H47.59907 2.7 .208 .2533RQ32011-04-27Yesno
005977IFN 31.43KGR35.23KGR35.26875 2.6 .217 .2933RP12011-04-26Yesno
000531biomedical 50.43EFV37.63EFV37.617530 1.9 .192 .2223ROS2011-04-26Yesno
001422biomedical 32.92H3H24.92H3H24.915710 1.9 .220 .2543ROT2011-04-26Yesno
000310biomedical 45.51RF452.71RF452.74500 2.8 .226 .2863RMT2011-04-21Yesno
000337biomedical 56.62BHP50.43QAN73.417320 2.2 .224 .2923RJL2011-04-15Yesno
000544biomedical 14.32KJZ45.22KJZ45.214032 2.0 .219 .2413RHE2011-04-11Yesno
000584biomedical 52.03EK146.33EK146.318128 2.6 .191 .2523RH92011-04-11Yesno
000017biomedical 51.11EUH38.83PQA10017426 2.2 .182 .2383RHD2011-04-11Yesno
000308biomedical 51.41EUH57.63PRL10017541 2.3 .235 .2973RHH2011-04-11Yesno
000233biomedical 49.92C7232.72C7232.710167 2.0 .159 .1953RHA2011-04-11Yesno
200688community 44.22O5631.52O5631.59541 2.0 .148 .1813RCY2011-03-31Yesno
005622IFN 44.61EVT12.21EVT12.29876 2.3 .201 .2333RBG2011-03-29N/Ano
000196biomedical 23.81W8G38.91W8G38.97532 1.9 .244 .2453R792011-03-22Yesno
000469biomedical 51.11BXS36.11BXS36.117674 2.6 .235 .2823R642011-03-21Yesno
000084biomedical 13.514304 1.8 .218 .2343R6A2011-03-21Yesno
000193biomedical 15.413381 2.5 .230 .2963R4Q2011-03-17N/Ano
000563biomedical 24.73CBG46.83CBG46.818333 2.7 .265 .2903R3H2011-03-15N/Ano
000191biomedical 52.22WME54.92WME54.917499 2.2 .197 .2453R312011-03-15N/Ano
000560biomedical 36.13KHJ39.83KHJ39.810040 1.9 .181 .2073R2G2011-03-14N/Ano
200555community 39.13JVA33.13PX599.77520 1.9 .159 .1853R1Z2011-03-11Yesno
200555community 39.13JVA33.13PX599.77520 2.0 .161 .1913R102011-03-09Yesno
200555community 39.13JVA33.13PX599.77520 1.9 .161 .1953R0U2011-03-09Yesno
200555community 39.13JVA33.13PX599.77520 2.0 .151 .1813R112011-03-09Yesno
200555community 39.13JVA33.13JVA33.17520 2.0 .167 .1973R0K2011-03-08Yesno
005598IFN 51.31DGI35.31DGI35.39770 1.3 .153 .1733R0N2011-03-08Yesno
000296biomedical 56.62BHP49.92BHP49.917552 2.0 .218 .2803QAN2011-01-11Yesno
006165IFN 26.39907 1.7 .209 .2373Q0H2010-12-15N/Ano
012591biomedical 77.52QY623.33PS958.97629 2.3 .173 .2313PVC2010-12-06Yesno
000408biomedical 34.33IM847.43IM847.46781 2.1 .220 .2653PTW2010-12-03Yesno
012590biomedical 74.42QY636.22QY636.210356 2.5 .185 .2473PS92010-12-01Yesno
000308biomedical 51.41EUH57.61EUH57.617541 2.0 .251 .3063PRL2010-11-29Yesno
000017biomedical 51.11EUH38.81EUH38.817426 1.5 .189 .2223PQA2010-11-25Yesno
011326 17.63KCM27.73KCM27.716768---2L5O2010-11-03N/Ano
011324 17.73HXS49.73HXS49.712270---2L5L2010-11-02N/Ano
011325 16.413293---2L572010-10-26N/Ano
000290biomedical 20.52YWR38.32YWR38.35475 1.9 .193 .2263P9X2010-10-18Yesno
000379biomedical 35.01ZSW35.91ZSW35.97365 1.4 .182 .2253OAJ2010-08-05Yesno
000295biomedical 15.33GM531.73GM531.711316 1.9 .198 .2343OA42010-08-04Yesno
(default) 95 queries took 743 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';10910918
2SELECT matviewname as name FROM pg_matviews;001
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
4SELECT matviewname as name FROM pg_matviews;001
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
6SELECT matviewname as name FROM pg_matviews;001
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
8SELECT matviewname as name FROM pg_matviews;001
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
10SELECT matviewname as name FROM pg_matviews;001
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
12SELECT matviewname as name FROM pg_matviews;001
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
14SELECT matviewname as name FROM pg_matviews;001
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
16SELECT matviewname as name FROM pg_matviews;001
17SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
18SELECT matviewname as name FROM pg_matviews;001
19SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
20SELECT matviewname as name FROM pg_matviews;001
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
22SELECT matviewname as name FROM pg_matviews;001
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
24SELECT matviewname as name FROM pg_matviews;001
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
26SELECT matviewname as name FROM pg_matviews;001
27SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
28SELECT matviewname as name FROM pg_matviews;001
29SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
30SELECT matviewname as name FROM pg_matviews;001
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
32SELECT matviewname as name FROM pg_matviews;001
33SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
34SELECT matviewname as name FROM pg_matviews;001
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
36SELECT matviewname as name FROM pg_matviews;001
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
38SELECT matviewname as name FROM pg_matviews;001
39SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
40SELECT matviewname as name FROM pg_matviews;001
41SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
42SELECT matviewname as name FROM pg_matviews;001
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
44SELECT matviewname as name FROM pg_matviews;001
45SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
46SELECT matviewname as name FROM pg_matviews;001
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
48SELECT matviewname as name FROM pg_matviews;001
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
50SELECT matviewname as name FROM pg_matviews;001
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
52SELECT matviewname as name FROM pg_matviews;001
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
54SELECT matviewname as name FROM pg_matviews;001
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
56SELECT matviewname as name FROM pg_matviews;001
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
58SELECT matviewname as name FROM pg_matviews;001
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
60SELECT matviewname as name FROM pg_matviews;001
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
62SELECT matviewname as name FROM pg_matviews;001
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
64SELECT matviewname as name FROM pg_matviews;001
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
66SELECT matviewname as name FROM pg_matviews;001
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
68SELECT matviewname as name FROM pg_matviews;001
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
70SELECT matviewname as name FROM pg_matviews;001
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
72SELECT matviewname as name FROM pg_matviews;001
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
74SELECT matviewname as name FROM pg_matviews;001
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
76SELECT matviewname as name FROM pg_matviews;001
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
78SELECT matviewname as name FROM pg_matviews;001
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
80SELECT matviewname as name FROM pg_matviews;001
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
82SELECT matviewname as name FROM pg_matviews;001
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
84SELECT matviewname as name FROM pg_matviews;001
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
86SELECT matviewname as name FROM pg_matviews;001
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
88SELECT matviewname as name FROM pg_matviews;001
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
90SELECT matviewname as name FROM pg_matviews;001
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
92SELECT matviewname as name FROM pg_matviews;001
93SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1003
94SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
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 ; 286286534
(labdb) 2 queries took 9 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';2932937
2SELECT matviewname as name FROM pg_matviews;002