Warning (2): Illegal string offset 'id' [/var/www/unitrack/controllers/unitrack_statistics_controller.php, line 552]
New York Center for Structural Genomics - Statistics

Organism Distribution: Targets and Structures

Number of Targets

Organism Number of targets
Sinorhizobium meliloti 1021 4119
Homo sapiens 1315
Toxoplasma gondii GT1 688
Mus musculus 586
Streptomyces avermitilis MA-4680 = NBRC 14893 381
Rhodospirillum rubrum ATCC 11170 337
Rhizobium etli CFN 42 322
Streptococcus pneumoniae TIGR4 308
Cryptosporidium parvum Iowa II 292
Pseudomonas protegens Pf-5 283
Polaromonas sp. JS666 276
Xanthobacter autotrophicus Py2 259
Geobacter metallireducens GS-15 259
Methanosarcina mazei Go1 255
Rhodobacter sphaeroides 2.4.1 247
Chloroflexus aurantiacus J-10-fl 246
Desulfovibrio vulgaris str. Hildenborough 243
Arthrobacter aurescens TC1 240
Ruegeria pomeroyi DSS-3 232
Rhodococcus opacus PD630 230
Bacillus halodurans C-125 227
Colwellia psychrerythraea 34H 226
Methylococcus capsulatus str. Bath 217
Geobacter sulfurreducens PCA 208
Giardia lamblia ATCC 50803 207
Bacillus subtilis subsp. subtilis str. 168 199
Pseudomonas aeruginosa PAO1 190
Bacillus licheniformis DSM 13 = ATCC 14580 190
Agrobacterium fabrum str. C58 186
Vibrio cholerae M66-2 185
Marinobacter aquaeolei VT8 185
Clostridium perfringens ATCC 13124 184
Cryptococcus neoformans var. neoformans JEC21 180
Wolinella succinogenes DSM 1740 179
Rhodopseudomonas palustris BisB18 172
Methanococcus maripaludis X1 170
Human herpesvirus 5 169
Toxoplasma gondii ME49 167
Cupriavidus metallidurans CH34 163
Vibrio parahaemolyticus RIMD 2210633 162
Ralstonia eutropha H16 160
Saccharopolyspora erythraea NRRL 2338 153
Anaeromyxobacter dehalogenans 2CP-C 153
Klebsiella pneumoniae subsp. pneumoniae MGH 78578 152
Bacteroides fragilis NCTC 9343 151
Prochlorococcus marinus str. MIT 9303 149
Haloarcula marismortui ATCC 43049 147
Salinibacter ruber DSM 13855 145
Campylobacter jejuni RM1221 142
Corynebacterium glutamicum ATCC 13032 142
Prochlorococcus marinus str. MIT 9313 141
Legionella pneumophila subsp. pneumophila str. Philadelphia 1 139
Mycobacterium bovis BCG str. Pasteur 1173P2 134
Gloeobacter violaceus PCC 7421 125
Clostridium acetobutylicum ATCC 824 121
Novosphingobium aromaticivorans DSM 12444 121
Idiomarina loihiensis L2TR 120
Klebsiella pneumoniae 342 120
Rhodopseudomonas palustris CGA009 120
Cryptococcus neoformans var. neoformans B-3501A 119
Prochlorococcus marinus str. MIT 9211 116
Sulfolobus solfataricus P2 116
Aeromonas hydrophila subsp. hydrophila ATCC 7966 115
Bacteroides thetaiotaomicron VPI-5482 114
Mycobacterium smegmatis str. MC2 155 111
Acinetobacter baumannii ATCC 17978 110
Burkholderia mallei ATCC 23344 110
Pseudomonas putida KT2440 109
Prochlorococcus marinus str. NATL1A 108
Dyadobacter fermentans DSM 18053 107
Mycobacterium marinum M 107
Chromobacterium violaceum ATCC 12472 106
Prochlorococcus marinus subsp. pastoris str. CCMP1986 106
Nocardioides sp. JS614 106
Sulfolobus acidocaldarius DSM 639 105
Bacteroides vulgatus ATCC 8482 105
Yersinia pestis Angola 104
Brucella abortus bv. 1 str. 9-941 104
Vibrio fischeri ES114 104
Staphylococcus saprophyticus subsp. saprophyticus ATCC 15305 103
Salinispora tropica CNB-440 100
Pseudoalteromonas atlantica T6c 100
Ralstonia solanacearum GMI1000 99
Pectobacterium atrosepticum SCRI1043 98
Nakamurella multipartita DSM 44233 98
Archaeoglobus fulgidus DSM 4304 97
Prochlorococcus marinus subsp. marinus str. CCMP1375 97
Burkholderia ambifaria AMMD 97
Mycobacterium avium subsp. paratuberculosis K-10 97
Cytophaga hutchinsonii ATCC 33406 95
Burkholderia thailandensis E264 93
Photorhabdus luminescens subsp. laumondii TTO1 89
Mycobacterium tuberculosis H37Rv 88
Xanthomonas campestris pv. campestris str. ATCC 33913 88
Synechocystis sp. PCC 6803 88
Salmonella enterica subsp. enterica serovar Typhimurium str. LT2 88
Ruminiclostridium thermocellum ATCC 27405 87
Verminephrobacter eiseniae EF01-2 85
Bacillus cereus ATCC 14579 85
Bradyrhizobium sp. BTAi1 85
Chitinophaga pinensis DSM 2588 85
Encephalitozoon cuniculi GB-M1 84
Hyphomonas neptunium ATCC 15444 84
Danio rerio 84
Burkholderia pseudomallei 1710b 83
Anaeromyxobacter dehalogenans 2CP-1 83
Oenococcus oeni PSU-1 79
Pediococcus pentosaceus ATCC 25745 78
Deinococcus radiodurans R1 77
Pseudomonas syringae pv. tomato str. DC3000 77
Synechococcus elongatus PCC 7942 76
Rhodoferax ferrireducens T118 76
Natronomonas pharaonis DSM 2160 76
Gallus gallus 75
Bordetella parapertussis 12822 75
Burkholderia pseudomallei 668 75
Spirosoma linguale DSM 74 74
Methanothermobacter thermautotrophicus str. Delta H 73
Coxiella burnetii CbuG_Q212 72
Francisella tularensis subsp. holarctica FTNF002-00 71
Thermobifida fusca YX 71
Arthrobacter chlorophenolicus A6 71
Methylobacillus flagellatus KT 70
Methanocaldococcus jannaschii DSM 2661 69
Thermoplasma acidophilum DSM 1728 69
Shewanella oneidensis MR-1 68
Pseudomonas syringae pv. phaseolicola 1448A 68
synthetic construct 68
Thermoplasma volcanium GSS1 67
Debaryomyces hansenii CBS767 65
Toxoplasma gondii VEG 65
Streptosporangium roseum DSM 43021 65
Ashbya gossypii ATCC 10895 64
Methylobacterium radiotolerans JCM 2831 64
Streptococcus thermophilus LMG 18311 64
Lodderomyces elongisporus NRRL YB-4239 64
Streptomyces griseus subsp. griseus NBRC 13350 63
Candida glabrata CBS 138 62
Scheffersomyces stipitis CBS 6054 61
Vibrio cholerae O1 biovar El Tor str. N16961 61
Methanosarcina acetivorans C2A 61
Renibacterium salmoninarum ATCC 33209 60
Bartonella henselae str. Houston-1 60
Burkholderia graminis C4D1M 60
Bacillus anthracis str. 'Ames Ancestor' 60
Gluconobacter oxydans 621H 60
Salmonella enterica subsp. enterica serovar Paratyphi A str. ATCC 9150 59
Agrobacterium radiobacter K84 58
Escherichia coli O26:H11 str. 11368 57
Gordonia bronchialis DSM 43247 57
Pyrococcus furiosus DSM 3638 56
Prochlorococcus marinus str. NATL2A 56
Nostoc punctiforme PCC 73102 55
Prochlorococcus marinus str. MIT 9215 55
Lachnoclostridium phytofermentans ISDg 55
Kluyveromyces lactis NRRL Y-1140 55
Prochlorococcus marinus str. MIT 9515 55
Escherichia coli str. K-12 substr. MG1655 55
Prochlorococcus marinus str. AS9601 54
Enterococcus faecalis V583 54
Desulfovibrio alaskensis G20 52
Leptospira interrogans serovar Copenhageni str. Fiocruz L1-130 52
Acidithiobacillus ferrooxidans ATCC 23270 51
Bordetella pertussis Tohama I 51
Acidothermus cellulolyticus 11B 51
Lactobacillus acidophilus NCFM 50
Planctomyces limnophilus DSM 3776 50
Burkholderia mallei NCTC 10229 50
Porphyromonas gingivalis W83 49
Saccharomyces cerevisiae 49
Geodermatophilus obscurus DSM 43160 49
Desulfovibrio salexigens DSM 2638 49
Rhodobacter sphaeroides ATCC 17029 49
Coxiella burnetii RSA 493 49
Pyrococcus horikoshii OT3 48
Prochlorococcus marinus str. MIT 9312 48
Lactobacillus plantarum WCFS1 47
Prochlorococcus marinus str. MIT 9301 47
Xenorhabdus nematophila ATCC 19061 47
Neisseria meningitidis MC58 47
Photobacterium profundum SS9 47
Haemophilus influenzae Rd KW20 47
Burkholderia pseudomallei K96243 46
Flavobacterium johnsoniae UW101 46
Magnetospirillum magneticum AMB-1 46
Mycobacterium abscessus ATCC 19977 46
Xenopus laevis 45
Campylobacter jejuni subsp. doylei 269.97 45
Escherichia coli CFT073 45
Anabaena variabilis ATCC 29413 44
Streptococcus agalactiae 2603V/R 44
Kineococcus radiotolerans SRS30216 = ATCC BAA-149 44
Actinobacillus succinogenes 130Z 44
Treponema denticola ATCC 35405 43
Xylella fastidiosa Temecula1 43
Nostoc sp. PCC 7120 43
Xenorhabdus bovienii SS-2004 43
Thermomonospora curvata DSM 43183 43
Listeria monocytogenes serotype 4b str. CLIP 80459 42
Mycobacterium leprae Br4923 42
Sebaldella termitidis ATCC 33386 41
Cryptococcus gattii WM276 41
Zymomonas mobilis subsp. mobilis ZM4 = ATCC 31821 40
Escherichia coli str. K-12 substr. DH10B 40
Methylibium petroleiphilum PM1 40
Tsukamurella paurometabola DSM 20162 40
Escherichia coli O157:H7 str. EC4115 40
Bordetella bronchiseptica RB50 40
Chromohalobacter salexigens DSM 3043 39
Methanoculleus marisnigri JR1 39
Thermus thermophilus HB27 39
Methylobacterium extorquens AM1 38
Shewanella pealeana ATCC 700345 38
Drosophila melanogaster 38
Burkholderia multivorans ATCC 17616 37
Rhodothermus marinus DSM 4252 37
Prochlorococcus phage P-SSM2 36
Pseudomonas putida F1 36
Haloferax volcanii DS2 36
Psychrobacter cryohalolentis K5 36
Thiobacillus denitrificans ATCC 25259 36
Sulfurimonas denitrificans DSM 1251 36
Thermotoga maritima MSB8 35
Meiothermus ruber DSM 1279 35
Rhodopseudomonas palustris HaA2 35
Streptomyces cattleya NRRL 8057 = DSM 46488 35
Pedobacter heparinus DSM 2366 35
Wolinella succinogenes 35
Burkholderia pseudomallei 1106a 35
Lactobacillus brevis ATCC 367 34
Aeropyrum pernix K1 34
Methanocorpusculum labreanum Z 34
Haemophilus ducreyi 35000HP 34
Escherichia coli O127:H6 str. E2348/69 34
Caenorhabditis elegans 34
Moorella thermoacetica ATCC 39073 33
Shewanella woodyi ATCC 51908 33
Rhodopseudomonas palustris BisB5 33
Streptomyces coelicolor A3(2) 33
Heliobacterium modesticaldum Ice1 33
Metallosphaera sedula DSM 5348 32
Neisseria gonorrhoeae FA 1090 32
Listeria innocua Clip11262 32
Brevibacterium linens BL2 32
Thermotoga lettingae TMO 32
Fusobacterium nucleatum subsp. nucleatum ATCC 25586 32
Saccharophagus degradans 2-40 32
Brucella abortus S19 31
Acinetobacter sp. ADP1 31
[Bacillus] selenitireducens MLS10 30
Gluconacetobacter diazotrophicus PA1 5 30
Francisella tularensis subsp. mediasiatica FSC147 30
Agrobacterium vitis S4 30
Caulobacter crescentus CB15 30
Micrococcus luteus NCTC 2665 29
Ochrobactrum anthropi ATCC 49188 29
Thermanaerovibrio acidaminovorans DSM 6589 29
Anaerococcus prevotii DSM 20548 28
Lactobacillus delbrueckii subsp. bulgaricus ATCC BAA-365 28
Veillonella parvula DSM 2008 28
Vanderwaltozyma polyspora DSM 70294 28
Pseudomonas aeruginosa PA7 27
Escherichia coli O157:H7 str. EDL933 27
Cryptococcus neoformans var. grubii 27
Sulfurospirillum deleyianum DSM 6946 27
Methanococcus voltae A3 27
Methanococcus maripaludis C5 26
Leptotrichia buccalis C-1013-b 26
Parabacteroides distasonis ATCC 8503 26
Staphylococcus epidermidis ATCC 12228 26
Salmonella enterica subsp. enterica serovar Typhi str. Ty2 26
Candida albicans SC5314 26
Granulibacter bethesdensis CGDNIH1 26
Xenopus (Silurana) tropicalis 26
Halogeometricum borinquense DSM 11551 25
Desulfovibrio desulfuricans subsp. desulfuricans str. ATCC 27774 25
Shewanella putrefaciens CN-32 25
Brachybacterium faecium DSM 4810 25
Mesoplasma florum L1 25
Shewanella denitrificans OS217 25
Undefined organism 25
Methanococcus aeolicus Nankai-3 24
Methanococcus vannielii SB 24
Francisella tularensis subsp. tularensis FSC198 24
Methanobrevibacter smithii ATCC 35061 24
Shewanella loihica PV-4 23
Halomicrobium mukohataei DSM 12286 23
Borrelia burgdorferi B31 23
Citrobacter koseri ATCC BAA-895 23
Eggerthella lenta DSM 2243 23
Chlorobium tepidum TLS 23
Capnocytophaga gingivalis ATCC 33624 22
Thermoanaerobacter pseudethanolicus ATCC 33223 22
Acinetobacter baumannii AYE 22
Ruegeria sp. TM1040 22
Lactobacillus casei ATCC 334 22
Saccharomyces cerevisiae S288c 22
Akkermansia muciniphila ATCC BAA-835 22
Roseobacter denitrificans OCh 114 21
Streptococcus pneumoniae CGSP14 21
Campylobacter lari RM2100 20
Listeria monocytogenes EGD-e 20
Shewanella frigidimarina NCIMB 400 20
Flavobacterium psychrophilum JIP02/86 20
Thermotoga petrophila RKU-1 19
Thermus thermophilus HB8 19
Rattus norvegicus 19
Francisella philomiragia subsp. philomiragia ATCC 25017 19
Finegoldia magna ATCC 29328 19
Methanococcus maripaludis C7 19
Chloroflexus sp. Y-400-fl 19
Cryptobacterium curtum DSM 15641 18
Cellulomonas flavigena DSM 20109 18
Campylobacter concisus 13826 18
Mycobacterium tuberculosis H37Ra 18
Jonesia denitrificans DSM 20603 18
Brucella melitensis ATCC 23457 18
Chaetomium thermophilum var. thermophilum 17
Campylobacter curvus 525.92 17
Campylobacter jejuni subsp. jejuni NCTC 11168 = ATCC 700819 17
Meyerozyma guilliermondii ATCC 6260 17
Staphylococcus aureus subsp. aureus Mu50 17
Xanthomonas oryzae pv. oryzae KACC 10331 17
Porphyromonas gingivalis ATCC 33277 17
Acholeplasma laidlawii PG-8A 17
Mycobacterium abscessus 16
Cyanothece sp. ATCC 51142 16
Prevotella melaninogenica ATCC 25845 16
Bos taurus 16
Yersinia pestis Nepal516 16
Leptospira interrogans serovar Lai str. 56601 16
Helicobacter pylori 26695 16
Shigella dysenteriae Sd197 15
Vibrio cholerae O395 15
Corynebacterium diphtheriae NCTC 13129 15
Burkholderia pseudomallei MSHR346 15
Leuconostoc mesenteroides subsp. mesenteroides ATCC 8293 15
Atopobium rimae ATCC 49626 14
Bacteroides stercoris ATCC 43183 14
Aquifex aeolicus VF5 14
Burkholderia mallei NCTC 10247 14
Bacillus cereus ATCC 10987 14
Salmonella enterica subsp. arizonae serovar 62:z4,z23:- str. RSK2980 14
Escherichia coli O103:H2 str. 12009 13
Escherichia fergusonii ATCC 35469 13
Actinobacillus pleuropneumoniae serovar 1 str. 4074 13
Thermotoga neapolitana DSM 4359 13
Escherichia coli K-12 13
Porphyromonas endodontalis ATCC 35406 13
Sorangium cellulosum So ce56 13
Bacillus thuringiensis serovar konkukian str. 97-27 13
Bifidobacterium longum subsp. infantis ATCC 15697 = JCM 1222 = DSM 20088 12
Burkholderia mallei SAVP1 12
Candida glabrata 12
Streptococcus sanguinis SK36 12
Francisella tularensis subsp. tularensis SCHU S4 12
metagenome 12
Schizosaccharomyces pombe 972h- 12
Salmonella enterica subsp. enterica serovar Typhi str. CT18 12
Escherichia coli O157:H7 str. Sakai 12
Streptobacillus moniliformis DSM 12112 12
Prochlorococcus phage P-SSM4 11
Streptomyces griseus XylebKG-1 11
Synechococcus sp. WH 8102 11
Bacillus cereus E33L 11
Streptococcus uberis 0140J 11
Bacillus anthracis str. A0248 11
Shigella flexneri 5 str. 8401 11
Bacillus anthracis str. Ames 11
Bacillus thuringiensis serovar israelensis ATCC 35646 11
Bacillus anthracis str. Sterne 10
Campylobacter jejuni subsp. jejuni 81-176 10
Shigella boydii Sb227 10
Propionibacterium acnes KPA171202 10
Roseovarius nubinhibens ISM 10
Pan troglodytes 10
Kluyveromyces lactis 10
Yersinia pseudotuberculosis IP 32953 10
Synechococcus sp. CC9311 9
Coxiella burnetii RSA 331 9
Equus caballus 9
Sulfitobacter sp. EE-36 9
Brucella suis 1330 9
Yersinia pseudotuberculosis YPIII 9
Loxodonta africana 9
Desulfovibrio vulgaris DP4 9
Campylobacter upsaliensis RM3195 9
Komagataella pastoris CBS 7435 9
Lactobacillus reuteri DSM 20016 9
Bacillus thuringiensis str. Al Hakam 9
Labrenzia alexandrii DFL-11 9
Ornithorhynchus anatinus 8
Paracoccus denitrificans PD1222 8
Pelagibaca bermudensis HTCC2601 8
Shigella flexneri 2a str. 2457T 8
Monodelphis domestica 8
Escherichia coli O111:H- str. 11128 8
Sus scrofa 8
Bradyrhizobium diazoefficiens USDA 110 8
Bifidobacterium adolescentis ATCC 15703 8
Escherichia coli O55:H7 str. CB9615 8
Clostridium difficile 630 8
Eggerthella sp. 1_3_56FAA 8
Cryptococcus neoformans var. neoformans 8
Weissella paramesenteroides ATCC 33313 8
Callithrix jacchus 8
Ruminiclostridium thermocellum JW20 8
Bacillus thuringiensis IBL 4222 8
Trypanosoma brucei brucei strain 927/4 GUTat10.1 7
Campylobacter coli RM2228 7
Oryctolagus cuniculus 7
Caulobacter crescentus NA1000 7
Thermoanaerobacter brockii subsp. finnii Ako-1 7
Rhodobacteraceae bacterium KLH11 7
Ailuropoda melanoleuca 7
Labrenzia aggregata IAM 12614 7
Mycobacterium bovis AF2122/97 7
Shigella sonnei Ss046 7
Bacillus sp. BT1B_CT2 7
Burkholderia cenocepacia J2315 7
Brucella melitensis bv. 1 str. 16M 7
Lactobacillus gasseri ATCC 33323 7
Mannheimia haemolytica PHL213 6
Lactobacillus reuteri MM4-1A 6
Streptococcus pyogenes MGAS10270 6
Taeniopygia guttata 6
Streptococcus mutans UA159 6
Acinetobacter baumannii 6013113 6
Candidatus Solibacter usitatus Ellin6076 6
Mycobacterium tuberculosis CDC1551 6
Yersinia pestis biovar Microtus str. 91001 6
Mycobacterium bovis BCG str. Mexico 6
Candidatus Koribacter versatilis Ellin345 6
Podospora anserina S mat+ 6
Cavia porcellus 6
Yersinia pseudotuberculosis IP 31758 6
Canis lupus familiaris 6
Sulfitobacter sp. NAS-14.1 6
Synechococcus phage syn9 6
Synechococcus phage S-SM2 6
Cryptococcus neoformans var. grubii H99 5
Macropus eugenii 5
Macaca fascicularis 5
Pongo abelii 5
Prochlorococcus phage P-HM1 5
Neisseria meningitidis FAM18 5
Bifidobacterium longum NCC2705 5
Cronobacter sakazakii ATCC BAA-894 5
Schizosaccharomyces pombe 5
Oenococcus oeni AWRIB429 5
Ochotona princeps 5
Tursiops truncatus 5
Bacteroides sp. 4_3_47FAA 5
Otolemur garnettii 5
Parabacteroides sp. D13 5
Meleagris gallopavo 5
Mesorhizobium loti MAFF303099 5
Thermoanaerobacter sp. X514 5
Pteropus vampyrus 5
Halorhodospira halophila SL1 5
Prevotella denticola F0289 5
Streptococcus thermophilus LMD-9 5
Acinetobacter baumannii 6014059 5
Lactobacillus delbrueckii subsp. bulgaricus ATCC 11842 5
Synechococcus sp. CC9605 5
Synechococcus sp. RCC307 5
Cyanophage PSS2 4
Synechococcus sp. RS9917 4
Streptococcus pneumoniae R6 4
Anolis carolinensis 4
Staphylococcus haemolyticus JCSC1435 4
Myxococcus xanthus DK 1622 4
Synechococcus sp. RS9916 4
Brucella suis ATCC 23445 4
Macaca mulatta 4
Enterococcus faecium DO 4
Treponema denticola F0402 4
Microcebus murinus 4
Felis catus 4
Bordetella parapertussis 4
Methylobacterium sp. 4-46 4
Gramella forsetii KT0803 4
Xanthomonas oryzae pv. oryzae MAFF 311018 4
Rhodopirellula baltica SH 1 4
Enterococcus faecium TX0133a01 4
Synechococcus phage S-ShM2 4
Staphylococcus aureus subsp. aureus USA300_TCH1516 4
Pseudomonas fluorescens 4
Pseudomonas fluorescens Pf0-1 4
Yersinia pestis KIM10+ 4
Synechocystis sp. PCC 6803 substr. PCC-N 4
Lactococcus lactis subsp. lactis Il1403 4
Debaryomyces hansenii 4
Ictidomys tridecemlineatus 3
Methylobacterium extorquens PA1 3
Acinetobacter baumannii AB059 3
Roseiflexus castenholzii DSM 13941 3
Bacteroides fragilis 638R 3
Canis lupus 3
Finegoldia magna BVS033A4 3
Choloepus hoffmanni 3
Bacteroides vulgatus PC510 3
Pan paniscus 3
Synechococcus elongatus PCC 6301 3
Sorex araneus 3
Legionella pneumophila subsp. pneumophila ATCC 43290 3
Vibrio campbellii ATCC BAA-1116 3
Sphingomonas wittichii RW1 3
Streptococcus pyogenes MGAS10750 3
Campylobacter coli JV20 3
Roseobacter litoralis Och 149 3
Mycobacterium africanum K85 3
Bacteroides sp. 2_1_16 3
Bacteroides sp. 3_2_5 3
Acinetobacter baumannii ATCC 19606 = CIP 70.34 3
Burkholderia thailandensis TXDOH 3
Synechococcus sp. BL107 3
Nomascus leucogenys 3
Xanthomonas campestris pv. campestris str. B100 3
Staphylococcus aureus subsp. aureus MW2 3
Veillonella sp. oral taxon 158 str. F0412 3
Oceanobacillus iheyensis HTE831 3
Psychromonas ingrahamii 37 3
Myotis lucifugus 3
Synechococcus sp. WH 5701 3
Maricaulis maris MCS10 3
Arabidopsis thaliana 3
Bacteroides sp. 3_1_19 3
Dechloromonas aromatica RCB 3
Bacillus anthracis str. CDC 684 3
Ralstonia eutropha JMP134 3
Nematostella vectensis 3
Tarsius syrichta 3
Prevotella denticola CRIS 18C-A 3
Streptococcus pyogenes MGAS315 3
Yersinia pestis CO92 3
Stigmatella aurantiaca DW4/3-1 3
Lactobacillus plantarum subsp. plantarum ATCC 14917 3
Lyngbya sp. PCC 8106 3
Hahella chejuensis KCTC 2396 3
Pseudomonas aeruginosa UCBPP-PA14 3
Synechococcus sp. WH 7805 3
Gorilla gorilla gorilla 3
Streptococcus pyogenes M1 GAS 3
Ruegeria sp. R11 3
Bartonella bacilliformis KC583 3
Coleofasciculus chthonoplastes PCC 7420 3
Clostridium perfringens str. 13 3
Clostridium perfringens B str. ATCC 3626 3
Salmonella enterica subsp. enterica serovar Typhimurium str. 14028S 3
Eggerthella sp. HGA1 3
Prochlorococcus phage P-HM2 3
Synechococcus sp. WH 7803 3
Bacillus clausii KSM-K16 3
Vicugna pacos 3
Halobacterium sp. NRC-1 3
Blastopirellula marina DSM 3645 2
Neosartorya fischeri NRRL 181 2
Bifidobacterium longum subsp. longum ATCC 55813 2
Shewanella putrefaciens 200 2
Francisella tularensis subsp. holarctica LVS 2
Shewanella halifaxensis HAW-EB4 2
Bacillus sp. B14905 2
Gemmatimonas aurantiaca T-27 2
Amphimedon queenslandica 2
Phenylobacterium zucineum HLK1 2
Phaeobacter inhibens DSM 17395 2
Arthrospira sp. PCC 8005 2
Aplysia californica 2
Planctomyces maris DSM 8797 2
Salmonella enterica subsp. enterica serovar Typhimurium 2
Roseiflexus sp. RS-1 2
Zymomonas mobilis subsp. mobilis NCIMB 11163 2
Procavia capensis 2
Rickettsia typhi str. Wilmington 2
Geobacillus kaustophilus HTA426 2
Populus trichocarpa 2
Bacillus cereus 95/8201 2
Bacillus cereus F837/76 2
Octadecabacter antarcticus 307 2
Serratia proteamaculans 568 2
Bacteroides sp. 1_1_6 2
Shewanella amazonensis SB2B 2
Oceanibulbus indolifex HEL-45 2
Shewanella baltica OS155 2
Bacillus thuringiensis serovar sotto str. T04001 2
Bacillus thuringiensis serovar kurstaki str. T03a001 2
Bacillus sp. NRRL B-14911 2
Roseobacter sp. GAI101 2
Papio anubis 2
Fusobacterium nucleatum subsp. nucleatum ATCC 23726 2
Oryzias latipes 2
Bacteroides sp. 2_1_7 2
Rhodobacter sphaeroides ATCC 17025 2
Cupriavidus taiwanensis LMG 19424 2
Cupriavidus necator N-1 2
Maribacter sp. HTCC2170 2
Cyanophage NATL2A-133 2
Loktanella vestfoldensis SKA53 2
Cyanothece sp. CCY0110 2
Listeria monocytogenes LO28 2
Listeria monocytogenes serotype 4b str. F2365 2
Cryptosporidium hominis TU502 2
Saimiri boliviensis boliviensis 2
Thermoanaerobacter ethanolicus JW 200 2
Rhodobacteraceae bacterium HTCC2083 2
Streptococcus pyogenes MGAS8232 2
Corynebacterium glutamicum R 2
Pseudoalteromonas haloplanktis TAC125 2
Synechococcus phage S-SM1 2
Marinomonas sp. MED121 2
Staphylococcus aureus subsp. aureus TCH70 2
Cyanothece sp. PCC 8801 2
Dictyostelium discoideum AX4 2
Lactobacillus gasseri 224-1 2
Streptococcus pneumoniae D39 2
Enterobacteria phage 933W 2
Synechococcus sp. JA-3-3Ab 2
Enterococcus faecalis TX0104 2
Escherichia coli 2
Erythrobacter sp. NAP1 2
Synechococcus sp. CC9902 2
Lactobacillus reuteri 100-23 2
Klebsiella sp. 4_1_44FAA 2
Echinops telfairi 2
Streptococcus agalactiae NEM316 2
Dinoroseobacter shibae DFL 12 = DSM 16493 2
Legionella pneumophila str. Paris 2
Streptococcus gordonii str. Challis substr. CH1 2
Pseudomonas savastanoi pv. savastanoi NCPPB 3335 2
Streptococcus mitis NCTC 12261 2
Leeuwenhoekiella blandensis MED217 2
Vibrio fischeri MJ11 2
Methanococcus maripaludis S2 2
Finegoldia magna ACS-171-V-Col3 2
Helicobacter hepaticus ATCC 51449 2
Burkholderia xenovorans LB400 2
Hoeflea phototrophica DFL-43 2
Salinispora arenicola CNS-205 2
Prochlorococcus phage Syn33 2
Clostridium botulinum A str. ATCC 3502 2
Variovorax paradoxus S110 2
Verrucomicrobiae bacterium DG1235 2
Burkholderia ambifaria MC40-6 2
Mycobacterium tuberculosis str. Haarlem 2
Sinorhizobium medicae WSM419 2
Roseovarius sp. 217 2
Helicobacter pylori J99 2
Burkholderia multivorans CGD1 2
Rhodobacter sphaeroides KD131 2
Staphylococcus aureus subsp. aureus M013 2
Tupaia belangeri 2
Staphylococcus aureus subsp. aureus N315 2
Rhodococcus jostii RHA1 2
Roseobacter sp. MED193 2
Rhodobacterales bacterium HTCC2255 2
Jannaschia sp. CCS1 2
Chloroflexus aggregans DSM 9485 2
Rubrobacter xylanophilus DSM 9941 2
Methanopyrus kandleri AV19 2
Pseudomonas syringae pv. syringae B728a 2
Escherichia fergusonii ECD227 2
Trichodesmium erythraeum IMS101 2
Campylobacter jejuni subsp. jejuni CF93-6 2
Shigella flexneri 2a str. 301 2
Micrococcus luteus SK58 2
Roseovarius sp. TM1035 2
Mycobacterium ulcerans Agy99 2
Candida dubliniensis CD36 2
Roseobacter sp. SK209-2-6 1
Salinibacter ruber M8 1
Ruminiclostridium thermocellum DSM 2360 1
Roseobacter sp. CCS2 1
Sagittula stellata E-37 1
Roseobacter sp. AzwK-3b 1
Ruminococcus gnavus ATCC 29149 1
Streptomyces griseus 1
Thermotoga naphthophila RKU-10 1
Thermofilum pendens Hrk 5 1
Thermoanaerobacter wiegelii Rt8.B1 1
Thermoanaerobacter sp. X513 1
Thermotoga sp. RQ2 1
Toxoplasma gondii 1
Veillonella sp. 6_1_27 1
uncultured marine bacterium 582 1
Trichomonas vaginalis G3 1
Treponema pallidum subsp. pallidum str. Nichols 1
Thermoanaerobacter ethanolicus CCSD1 1
Thalassobium sp. R2A62 1
Synechococcus phage Syn19 1
Synechococcus phage S-SSM7 1
Synechococcus phage S-SSM5 1
Sulfolobus sp. NOB8H2 1
Synechococcus sp. JA-2-3B'a(2-13) 1
Synechococcus sp. PCC 7335 1
Tetraodon nigroviridis 1
Teredinibacter turnerae T7901 1
Talaromyces stipitatus ATCC 10500 1
Vibrio cholerae 2740-80 1
Vibrio cholerae 623-39 1
Yersinia pestis Java 9 1
Yersinia pestis biovar Orientalis str. MG05-1020 1
Yersinia enterocolitica subsp. enterocolitica 8081 1
Yersinia bercovieri ATCC 43970 1
Yersinia pestis Z176003 1
Yersinia pseudotuberculosis PB1/+ 1
Zymomonas mobilis subsp. mobilis ATCC 10988 1
Zymomonas mobilis 1
Zea mays 1
Xylella fastidiosa subsp. fastidiosa GB514 1
Xylella fastidiosa M23 1
Vibrio cholerae RC385 1
Vibrio cholerae MO10 1
Vibrio cholerae IEC224 1
Vibrio cholerae BX 330286 1
Vibrio natriegens 1
Vibrio splendidus 12B01 1
Xylella fastidiosa M12 1
Xanthomonas campestris pv. campestris str. 8004 1
Vibrio vulnificus YJ016 1
Sulfolobus islandicus Y.G.57.14 1
Strongylocentrotus purpuratus 1
Staphylococcus aureus 1
Sphingobium sp. SYK-6 1
Sphaerobacter thermophilus DSM 20745 1
Sinorhizobium meliloti AK83 1
Staphylococcus aureus A5948 1
Staphylococcus aureus A8796 1
Staphylococcus aureus subsp. aureus str. JKD6009 1
Staphylococcus aureus subsp. aureus MRSA131 1
Staphylococcus aureus subsp. aureus JH9 1
Sinorhizobium fredii NGR234 1
Shigella flexneri 5a str. M90T 1
Salpingoeca rosetta 1
Salmo salar 1
Salmonella enterica subsp. enterica serovar Typhi str. E98-0664 1
Salmonella enterica subsp. enterica serovar Typhimurium str. ST4/74 1
Schmidtea mediterranea S2F2 1
Selenomonas ruminantium 1
Shewanella piezotolerans WP3 1
Shewanella baltica OS223 1
Serratia entomophila 1
Staphylococcus aureus subsp. aureus VC40 1
Staphylococcus epidermidis M23864:W2(grey) 1
Streptococcus pyogenes MGAS5005 1
Streptococcus pyogenes MGAS1882 1
Streptococcus pneumoniae TCH8431/19A 1
Streptococcus pneumoniae GA08825 1
Streptococcus pyogenes SSI-1 1
Streptococcus sp. SK597 1
Streptomyces violaceoruber 1
Streptomyces pristinaespiralis ATCC 25486 1
Streptomyces coelicolor 1
Streptococcus pneumoniae ATCC 700669 1
Streptococcus parasanguinis ATCC 903 1
Streptococcus agalactiae 1
Starkeya novella DSM 506 1
Staphylothermus marinus F1 1
Staphylococcus epidermidis RP62A 1
Streptococcus agalactiae A909 1
Streptococcus agalactiae ATCC 13813 1
Streptococcus dysgalactiae 1
Streptococcus agalactiae FSL S3-026 1
Streptococcus agalactiae CJB111 1
Salmonella enterica subsp. enterica serovar Paratyphi A str. AKU_12601 1
Methanococcus maripaludis C6 1
Corynebacterium glutamicum 1
Corynebacterium jeikeium K411 1
Cricetulus griseus 1
Corynebacterium diphtheriae 241 1
Corynebacterium diphtheriae 1
Clostridium perfringens SM101 1
Comamonas testosteroni KF-1 1
Crocosphaera watsonii WH 8501 1
Cryptococcus neoformans 1
Cyanothece sp. PCC 7424 1
Cyanothece sp. PCC 7822 1
Deinococcus deserti VCD115 1
Cyanophage P-SSP2 1
Cyanophage NATL1A-7 1
Cryptosporidium parvum 1
Cyanobium sp. PCC 7001 1
Clostridium perfringens NCTC 8239 1
Clostridium perfringens D str. JGS1721 1
Cavia 1
Chelativorans sp. BNC1 1
Chlamydia trachomatis D/UW-3/CX 1
Caulobacter sp. K31 1
CAS virus 1
Candidatus Kuenenia stuttgartiensis 1
Capra hircus 1
Chlamydophila abortus S26/3 1
Chlamydophila caviae GPIC 1
[Clostridium asparagiforme] DSM 15981 1
Clostridium beijerinckii NCIMB 8052 1
Clostridium botulinum A str. ATCC 19397 1
Clostridium acetobutylicum EA 2018 1
Cloning vector pQRBL 1
Chlamydophila pneumoniae CWL029 1
Chlorobium phaeovibrioides DSM 265 1
Delftia acidovorans SPH-1 1
Desulfitobacterium hafniense DCB-2 1
Escherichia coli O157:H7 str. LSU-61 1
Escherichia coli str. K-12 substr. W3110 1
Escherichia coli UTI89 1
Escherichia coli O157:H7 str. EC4113 1
Escherichia coli M863 1
Escherichia coli E110019 1
Escherichia coli E24377A 1
Escherichia fergusonii B253 1
Exiguobacterium sibiricum 255-15 1
Francisella philomiragia subsp. philomiragia ATCC 25015 1
Francisella tularensis subsp. novicida U112 1
Francisella tularensis subsp. tularensis WY96-3418 1
Flavobacteria bacterium MS024-2A 1
Ferroplasma acidarmanus fer1 1
Exiguobacterium sp. AT1b 1
Expression vector pcDNA3.1/NT-GFP-TOPO 1
Escherichia coli DH1 1
Escherichia coli DEC3F 1
Enterococcus faecalis EnGen0297 1
Enterococcus faecalis Merz96 1
Enterococcus faecalis T2 1
Enterococcus faecalis DAPTO 516 1
Drosophila sechellia 1
Desulfitobacterium hafniense Y51 1
Desulfovibrio vulgaris RCH1 1
Enterococcus faecalis TX0102 1
Enterococcus faecium E1071 1
Escherichia coli ABU 83972 1
Escherichia coli BL21(DE3) 1
Escherichia coli 101-1 1
Erinaceus europaeus 1
Enterococcus faecium TX0082 1
Enterococcus sp. GMD1E 1
Candidatus Korarchaeum cryptofilum OPF8 1
Candida albicans WO-1 1
Bacillus cereus G9241 1
Bacillus cereus G9842 1
Bacillus cereus Rock3-42 1
Bacillus cereus AH676 1
Azorhizobium caulinodans ORS 571 1
Arthrobacter sp. FB24 1
Aspergillus terreus NIH2624 1
Bacillus halodurans 1
Bacillus subtilis subsp. natto BEST195 1
Bacillus thuringiensis serovar huazhongensis BGSC 4BD1 1
Bacteroides dorei 5_1_36/D4 1
Bacteroides intestinalis DSM 17393 1
Bacillus thuringiensis serovar andalousiensis BGSC 4AW1 1
Bacillus thuringiensis Bt407 1
Bacillus subtilis subsp. subtilis str. NCIB 3610 1
Bacillus thuringiensis BMB171 1
Arcobacter butzleri RM4018 1
Anas platyrhynchos 1
Acinetobacter baumannii AB307-0294 1
Acinetobacter baumannii ACICU 1
Acinetobacter baumannii SDF 1
Acidobacterium capsulatum ATCC 51196 1
Acidithiobacillus ferrooxidans ATCC 53993 1
Acidaminococcus sp. D21 1
Acidiphilium cryptum JF-5 1
Acinetobacter sp. RUH2624 1
Acinetobacter sp. SH024 1
Alkalilimnicola ehrlichii MLHE-1 1
alpha proteobacterium BAL199 1
Anaeromyxobacter sp. K 1
Algoriphagus machipongonensis 1
Agrobacterium tumefaciens 1
Actinobacillus pleuropneumoniae serovar 3 str. JL03 1
Actinobacillus pleuropneumoniae serovar 4 str. M62 1
Bacteroides sp. 2_1_33B 1
Bacteroides sp. D20 1
Burkholderia thailandensis Bt4 1
Burkholderia ubonensis Bu 1
Burkholderia vietnamiensis G4 1
Burkholderia sp. H160 1
Burkholderia pseudomallei 1
Burkholderia phymatum STM815 1
Burkholderia phytofirmans PsJN 1
Caenorhabditis remanei 1
Camelus ferus 1
Campylobacter jejuni subsp. jejuni ICDCCJ07001 1
Campylobacter jejuni subsp. jejuni S3 1
Candida albicans 1
Campylobacter jejuni subsp. jejuni IA3902 1
Campylobacter jejuni subsp. jejuni HB93-13 1
Campylobacter hominis ATCC BAA-381 1
Campylobacter jejuni subsp. jejuni 84-25 1
Burkholderia mallei GB8 horse 4 1
Burkholderia cenocepacia MC0-3 1
Borrelia burgdorferi 118a 1
Borrelia burgdorferi 29805 1
Borrelia burgdorferi 64b 1
Borrelia burgdorferi 1
Bordetella petrii DSM 12804 1
Bdellovibrio bacteriovorus HD100 1
Bifidobacterium longum subsp. infantis CCUG 52486 1
Borrelia burgdorferi N40 1
Borrelia garinii PBi 1
Burkholderia ambifaria MEX-5 1
Burkholderia cenocepacia AU 1054 1
Brucella abortus 2308 1
Branchiostoma floridae 1
Bos mutus 1
Bradyrhizobium sp. ORS 278 1
Frankia alni ACN14a 1
Frankia sp. EAN1pec 1
Oryza sativa Japonica Group 1
Ovis aries 1
Parabacteroides sp. 20_3 1
Octadecabacter arcticus 238 1
Oceanicola granulosus HTCC2516 1
Oceanicaulis sp. HTCC2633 1
Oceanicola batsensis HTCC2597 1
Parvimonas micra ATCC 33270 1
Paulinella chromatophora 1
Peptoclostridium difficile QCD-23m63 1
Photobacterium profundum 3TCK 1
Photobacterium sp. SKA34 1
Pelodictyon phaeoclathratiforme BU-1 1
Pelobacter propionicus DSM 2379 1
Pectobacterium carotovorum subsp. carotovorum PC1 1
Pelobacter carbinolicus DSM 2380 1
Novosphingobium aromaticivorans 1
'Nostoc azollae' 0708 1
Mycoplasma pneumoniae M129 1
Myotis brandtii 1
Natranaerobius thermophilus JW/NM-WN-LF 1
Mycoplasma penetrans HF-2 1
Mycoplasma agalactiae PG2 1
Mycobacterium tuberculosis T92 1
Mycobacterium vanbaalenii PYR-1 1
Nautilia profundicola AmH 1
Nectria haematococca mpVI 77-13-4 1
Neospora caninum Liverpool 1
Nitrosomonas eutropha C91 1
Nodularia spumigena CCY9414 1
Neisseria meningitidis Z2491 1
Neisseria meningitidis alpha14 1
Neisseria gonorrhoeae F62 1
Neisseria gonorrhoeae PID18 1
Picrophilus torridus DSM 9790 1
Piriformospora indica DSM 11827 1
Rhizobium leguminosarum bv. trifolii WSM2304 1
Rhodobacteraceae bacterium HTCC2150 1
Rhodobacterales bacterium Y4I 1
Rhizobium etli CNPAF512 1
Pyrobaculum aerophilum str. IM2 1
Pseudomonas syringae pv. tomato str. JL1065 1
Pseudovibrio sp. JE062 1
Rhodobacter sphaeroides WS8N 1
Rhodococcus erythropolis PR4 1
Rhodospirillum rubrum F11 1
Ricinus communis 1
Rickettsia rickettsii str. Iowa 1
Rhodopseudomonas palustris BisA53 1
Rhodococcus opacus B4 1
Rhodococcus erythropolis SK121 1
Rhodococcus hoagii 1
Pseudomonas syringae pv. tomato NCPPB 1108 1
Pseudomonas syringae pv. tabaci str. ATCC 11528 1
Prochlorococcus phage P-RSM4 1
Prochlorococcus phage P-SSM7 1
Prochlorococcus phage P-SSP7 1
Prevotella tannerae ATCC 51259 1
Porphyromonas gingivalis 1
Plasmodium falciparum 3D7 1
Plasmodium yoelii yoelii 17XNL 1
Prochlorococcus phage Syn1 1
Pseudoalteromonas tunicata D2 1
Pseudomonas putida GB-1 1
Pseudomonas putida W619 1
Pseudomonas putida DOT-T1E 1
Pseudomonas mendocina ymp 1
Pseudomonas aeruginosa 2192 1
Pseudomonas aeruginosa PAb1 1
Mycobacterium tuberculosis T46 1
Mycobacterium tuberculosis SUMu012 1
Lactobacillus fermentum IFO 3956 1
Lactobacillus gasseri 202-4 1
Lactobacillus gasseri MV-22 1
Lactobacillus delbrueckii subsp. bulgaricus 2038 1
Lactobacillus casei str. Zhang 1
Kordia algicida OT-1 1
Lachancea thermotolerans CBS 6340 1
Lactobacillus johnsonii NCC 533 1
Lactobacillus plantarum JDM1 1
Legionella pneumophila str. Lens 1
Leishmania braziliensis MHOM/BR/75/M2904 1
Leishmania major strain Friedlin 1
Lactococcus lactis subsp. cremoris SK11 1
Lactococcus lactis subsp. cremoris MG1363 1
Lactobacillus plantarum subsp. plantarum ST-III 1
Lactobacillus reuteri SD2112 1
Klebsiella pneumoniae subsp. rhinoscleromatis ATCC 13884 1
Klebsiella pneumoniae subsp. pneumoniae NTUH-K2044 1
Giardia lamblia P15 1
Gorilla gorilla 1
Haemophilus influenzae 1
Geobacter sulfurreducens KN400 1
Geobacter lovleyi SZ 1
gamma proteobacterium NOR5-3 1
Gasterosteus aculeatus 1
Haemophilus influenzae F3031 1
Haemophilus influenzae RdAW 1
Klebsiella 1
Klebsiella pneumoniae subsp. pneumoniae HS11286 1
Jaculus jaculus 1
Heterocephalus glaber 1
Halothermothrix orenii H 168 1
Herpetosiphon aurantiacus DSM 785 1
Leptothrix cholodnii SP-6 1
Leuconostoc citreum KM20 1
Mus sp. 1
Mycobacterium abscessus subsp. bolletii CCUG 48898 = JCM 15300 1
Mycobacterium africanum GM041182 1
Millerozyma farinosa CBS 7064 1
Microcystis aeruginosa PCC 7806 1
Methanospirillum hungatei JF-1 1
Microcystis aeruginosa NIES-843 1
Mycobacterium avium 104 1
Mycobacterium avium subsp. avium ATCC 25291 1
Mycobacterium tuberculosis CCDC5079 1
Mycobacterium tuberculosis KZN 4207 1
Mycobacterium tuberculosis KZN V2475 1
Mycobacterium tuberculosis C 1
Mycobacterium tuberculosis 210 1
Mycobacterium sp. MCS 1
Mycobacterium tuberculosis 1
Mesocricetus auratus 1
Meiothermus ruber 1
Listeria monocytogenes FSL N3-165 1
Listeria monocytogenes HPB2262 1
Mannheimia haemolytica 1
Listeria ivanovii FSL F6-596 1
Listeria innocua FSL J1-023 1
Leuconostoc mesenteroides subsp. mesenteroides J18 1
Leuconostoc pseudomesenteroides KCTC 3652 1
Mannheimia succiniciproducens MBEL55E 1
Marburg marburgvirus 1
Marinobacter hydrocarbonoclasticus ATCC 49840 1
Marvinbryantia formatexigens DSM 14469 1
marine gamma proteobacterium HTCC2148 1
marine gamma proteobacterium HTCC2143 1
marine bacterium 01-004080 1
marine gamma proteobacterium HTCC2080 1
Robiginitalea biformata HTCC2501 1

Number of Structures

Organism Number of targets/structures
Sinorhizobium meliloti 1021 61/69
Homo sapiens 15/20
Rhizobium etli CFN 42 11/30
Bacillus halodurans C-125 7/8
Polaromonas sp. JS666 6/6
Novosphingobium aromaticivorans DSM 12444 4/4
Legionella pneumophila subsp. pneumophila str. Philadelphia 1 4/4
Mus musculus 3/4
Klebsiella pneumoniae 342 3/3
Rhodobacter sphaeroides 2.4.1 3/3
Geobacter sulfurreducens PCA 3/3
Methanosarcina mazei Go1 3/3
Agrobacterium fabrum str. C58 3/3
Xanthobacter autotrophicus Py2 3/3
Francisella philomiragia subsp. philomiragia ATCC 25017 2/6
Escherichia coli O55:H7 str. CB9615 2/2
Roseovarius sp. TM1035 2/2
Marinobacter aquaeolei VT8 2/2
Magnetospirillum magneticum AMB-1 2/2
Chloroflexus aurantiacus J-10-fl 2/2
Arthrobacter aurescens TC1 2/2
Lactobacillus acidophilus NCFM 2/2
Geobacter metallireducens GS-15 2/2
Methylococcus capsulatus str. Bath 2/2
Deinococcus radiodurans R1 2/2
Bacillus subtilis subsp. subtilis str. 168 2/2
Xanthomonas campestris pv. campestris str. ATCC 33913 2/2
Oryctolagus cuniculus 2/2
Bos taurus 2/2
Saccharomyces cerevisiae 2/2
Salmonella enterica subsp. enterica serovar Typhi str. CT18 1/5
Paracoccus denitrificans PD1222 1/3
Thermobifida fusca YX 1/3
Equus caballus 1/3
Bacteroides vulgatus ATCC 8482 1/2
Xenorhabdus bovienii SS-2004 1/2
Chromobacterium violaceum ATCC 12472 1/2
Methanocaldococcus jannaschii DSM 2661 1/2
Hyphomonas neptunium ATCC 15444 1/2
Yersinia pestis KIM10+ 1/2
Acidaminococcus sp. D21 1/1
Rhodococcus opacus PD630 1/1
Escherichia coli str. K-12 substr. MG1655 1/1
Spirosoma linguale DSM 74 1/1
Rhodobacteraceae bacterium KLH11 1/1
Sorangium cellulosum So ce56 1/1
Pseudovibrio sp. JE062 1/1
Hoeflea phototrophica DFL-43 1/1
Pseudomonas mendocina ymp 1/1
Dinoroseobacter shibae DFL 12 = DSM 16493 1/1
Burkholderia graminis C4D1M 1/1
Labrenzia aggregata IAM 12614 1/1
Roseobacter denitrificans OCh 114 1/1
Escherichia coli 101-1 1/1
Roseiflexus sp. RS-1 1/1
Escherichia coli E24377A 1/1
Sulfurimonas denitrificans DSM 1251 1/1
Sulfitobacter sp. NAS-14.1 1/1
Vibrio fischeri ES114 1/1
Salinibacter ruber DSM 13855 1/1
Thiobacillus denitrificans ATCC 25259 1/1
Jannaschia sp. CCS1 1/1
Bacillus licheniformis DSM 13 = ATCC 14580 1/1
Thermoplasma volcanium GSS1 1/1
Klebsiella pneumoniae subsp. pneumoniae MGH 78578 1/1
Bacteroides fragilis NCTC 9343 1/1
Rhodospirillum rubrum ATCC 11170 1/1
Cupriavidus metallidurans CH34 1/1
Methylobacillus flagellatus KT 1/1
Mycobacterium avium subsp. paratuberculosis K-10 1/1
Bordetella bronchiseptica RB50 1/1
metagenome 1/1
Labrenzia alexandrii DFL-11 1/1
Vibrio cholerae O1 biovar El Tor str. N16961 1/1
Photorhabdus luminescens subsp. laumondii TTO1 1/1
Bacillus cereus ATCC 14579 1/1
Shewanella oneidensis MR-1 1/1
Pseudomonas aeruginosa PAO1 1/1
Corynebacterium glutamicum ATCC 13032 1/1
Clostridium perfringens ATCC 13124 1/1
Salmonella enterica subsp. enterica serovar Typhimurium str. LT2 1/1
Salmonella enterica subsp. enterica serovar Typhimurium 1/1
Roseovarius nubinhibens ISM 1/1
Mycobacterium tuberculosis H37Rv 1/1
Otolemur garnettii 1/1
Marburg marburgvirus 1/1
Ochotona princeps 1/1
Ornithorhynchus anatinus 1/1
Klebsiella 1/1

(default) 108 queries took 7786 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';1091097
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';1091095
4SELECT matviewname as name FROM pg_matviews;000
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
6SELECT matviewname as name FROM pg_matviews;000
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
8SELECT matviewname as name FROM pg_matviews;000
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
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';1091094
12SELECT matviewname as name FROM pg_matviews;000
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
14SELECT matviewname as name FROM pg_matviews;000
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
16SELECT matviewname as name FROM pg_matviews;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;000
19SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
20SELECT matviewname as name FROM pg_matviews;000
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
22SELECT matviewname as name FROM pg_matviews;000
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
24SELECT matviewname as name FROM pg_matviews;000
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
26SELECT matviewname as name FROM pg_matviews;000
27SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
28SELECT matviewname as name FROM pg_matviews;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';1091092
30SELECT matviewname as name FROM pg_matviews;000
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
32SELECT matviewname as name FROM pg_matviews;000
33SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
34SELECT matviewname as name FROM pg_matviews;000
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
36SELECT matviewname as name FROM pg_matviews;000
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
38SELECT matviewname as name FROM pg_matviews;000
39SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
40SELECT matviewname as name FROM pg_matviews;000
41SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
42SELECT matviewname as name FROM pg_matviews;000
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091095
44SELECT matviewname as name FROM pg_matviews;001
45SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091094
46SELECT matviewname as name FROM pg_matviews;000
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
48SELECT matviewname as name FROM pg_matviews;000
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091091
50SELECT matviewname as name FROM pg_matviews;000
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
52SELECT matviewname as name FROM pg_matviews;000
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
54SELECT matviewname as name FROM pg_matviews;000
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
56SELECT matviewname as name FROM pg_matviews;000
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
58SELECT matviewname as name FROM pg_matviews;000
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091091
60SELECT matviewname as name FROM pg_matviews;000
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
62SELECT matviewname as name FROM pg_matviews;000
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
64SELECT matviewname as name FROM pg_matviews;000
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
66SELECT matviewname as name FROM pg_matviews;000
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
68SELECT matviewname as name FROM pg_matviews;000
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
70SELECT matviewname as name FROM pg_matviews;000
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091091
72SELECT matviewname as name FROM pg_matviews;000
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
74SELECT matviewname as name FROM pg_matviews;000
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
76SELECT matviewname as name FROM pg_matviews;000
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
78SELECT matviewname as name FROM pg_matviews;000
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
80SELECT matviewname as name FROM pg_matviews;000
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
82SELECT matviewname as name FROM pg_matviews;000
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
84SELECT matviewname as name FROM pg_matviews;000
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
86SELECT matviewname as name FROM pg_matviews;000
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
88SELECT matviewname as name FROM pg_matviews;000
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
90SELECT matviewname as name FROM pg_matviews;000
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
92SELECT matviewname as name FROM pg_matviews;000
93SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
94SELECT matviewname as name FROM pg_matviews;000
95SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091092
96SELECT matviewname as name FROM pg_matviews;000
97SELECT "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 1004
98SELECT "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
99SELECT name_text, tax_id, COUNT(*) FROM taxonomy.names AS t, protein_target AS tr WHERE tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048760
100SELECT COUNT(*) AS "count" FROM "protein_target" AS "Target" LEFT JOIN "protein_pdb_homolog_table" AS "Project" ON ("Target"."target_id" = "Project"."protein_target_id") LEFT JOIN "names" AS "Organism" ON ("Target"."ncbi_taxon_id" = "Organism"."tax_id" AND "Organism"."name_class" = 'scientific name') LEFT JOIN "names" AS "Species" ON ("Target"."species_taxon_id" = "Species"."tax_id" AND "Species"."name_class" = 'scientific name') LEFT JOIN "stage" AS "Stage" ON ("Target"."stage" = "Stage"."name") LEFT JOIN "protein_pdb_homolog_table" AS "ProteinPdbHomolog" ON ("ProteinPdbHomolog"."protein_target_id" = "Target"."target_id") LEFT JOIN "request_target" AS "RequestTarget" ON ("RequestTarget"."target_id" = "Target"."target_id") LEFT JOIN "target_planning" AS "TargetPlanning" ON ("TargetPlanning"."target_id" = "Target"."target_id") WHERE 1 = 1 111147
101SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN clone as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048864
102SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN expression as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND d.status='success' GROUP BY t.name_text, t.tax_id;536536870
103SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN expression as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND d.solubility_level>=10 GROUP BY t.name_text, t.tax_id;524524566
104SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN purification as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND d.status='success' GROUP BY t.name_text, t.tax_id;418418773
105SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN crystal_harvest as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048724
106SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN dataset as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048727
107SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN structure as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048614
108SELECT name_text, tax_id, COUNT(DISTINCT d.target_id), COUNT(d.target_id) as experiments FROM taxonomy.names AS t, protein_target AS tr LEFT JOIN deposit as d on(d.target_id=tr.target_id) WHERE 1=1 AND tr.ncbi_taxon_id=t.tax_id AND t.name_class='scientific name' AND 1=1 GROUP BY t.name_text, t.tax_id;10481048619
(labdb) 2 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932935
2SELECT matviewname as name FROM pg_matviews;001