Lectins of possible pathogen
Order by
SQL Error:
SELECT protein.protein_id, COUNT(protein.protein_id) AS nbprot, cluster, name, nbdomain, type, length, species, gene, gene_begin, gene_end, domain, score FROM propeller_view WHERE cluster != '' AND ( species LIKE 'Absidia corymbifera%' OR species LIKE 'Achorion gallinae%' OR species LIKE 'Acinetobacter %' OR species LIKE 'Acinetobacter baumannii%' OR species LIKE 'Acinetobacter lwoffii%' OR species LIKE 'Actinobacillus pleuropneumoniae%' OR species LIKE 'Actinomadura %' OR species LIKE 'Actinomyces %' OR species LIKE 'Actinomyces naeslundii%' OR species LIKE 'Actinomyces spp.%' OR species LIKE 'Actinomyces viscosus%' OR species LIKE 'Actinomycetes %' OR species LIKE 'Adenovirus%' OR species LIKE 'Adenovirus Human%' OR species LIKE 'Aeromonas %' OR species LIKE 'Ajellomyces dermatididis%' OR species LIKE 'Alcaligenes faecalis%' OR species LIKE 'Alcaligenes spp./Achromobacter spp.%' OR species LIKE 'Alcaligenes xylosoxidans%' OR species LIKE 'Aleurisma brasiliensis%' OR species LIKE 'Allersheria boydii%' OR species LIKE 'Arbovirus%' OR species LIKE 'Arthroderma %' OR species LIKE 'Ascaris lumbricoides%' OR species LIKE 'Aspergillus %' OR species LIKE 'Astrovirus%' OR species LIKE 'Bacillus anthracis%' OR species LIKE 'Bacillus cereus%' OR species LIKE 'Bacillus subtilis%' OR species LIKE 'Bacteriodes fragilis%' OR species LIKE 'Bartonella quintana%' OR species LIKE 'Basidiobolus %' OR species LIKE 'Blastocystis hominis%' OR species LIKE 'Blastomyces %' OR species LIKE 'Bordetella pertussis%' OR species LIKE 'Borrelia burgdorferi%' OR species LIKE 'Borrelia duttoni%' OR species LIKE 'Borrelia hermsii%' OR species LIKE 'Borrelia recurrentis%' OR species LIKE 'Brevundimonas diminuta%' OR species LIKE 'Brevundimonas vesicularis%' OR species LIKE 'Brucella %' OR species LIKE 'Burkholderia %' OR species LIKE 'Burkholderia cenocepacia%' OR species LIKE 'Burkholderia cepacia%' OR species LIKE 'Burkholderia mallei%' OR species LIKE 'Burkholderia oklahomensis%' OR species LIKE 'Burkholderia pseudomallei%' OR species LIKE 'Cadophora %' OR species LIKE 'Campylobacter jejuni%' OR species LIKE 'Campylobacter jejuni / coli%' OR species LIKE 'Campylobacter upsaliensis%' OR species LIKE 'Candida albicans%' OR species LIKE 'Candida auris%' OR species LIKE 'Candida krusei%' OR species LIKE 'Candida parapsilosis%' OR species LIKE 'Cercospora apii%' OR species LIKE 'Chikungunya virus%' OR species LIKE 'Chlamydia pneumoniae%' OR species LIKE 'Chlamydia psittaci%' OR species LIKE 'Chlamydia trachomatis%' OR species LIKE 'Chrysosporium %' OR species LIKE 'Citrobacter %' OR species LIKE 'Cladosporium %' OR species LIKE 'Cladothrix asteroids%' OR species LIKE 'Clostridium %' OR species LIKE 'Clostridium botulinum%' OR species LIKE 'Clostridium difficile%' OR species LIKE 'Clostridium difficle%' OR species LIKE 'Clostridium perfringens%' OR species LIKE 'Clostridium tetani%' OR species LIKE 'Coccidioides immitis%' OR species LIKE 'Coronavirus%' OR species LIKE 'Coronavirus Betacoronavirus%' OR species LIKE 'Corynebacterium %' OR species LIKE 'Corynebacterium diphtheriae%' OR species LIKE 'Corynebacterium pseudotuberculosis%' OR species LIKE 'Corynebacterium ulcerans%' OR species LIKE 'Coxiella burnetii%' OR species LIKE 'Coxsackievirus%' OR species LIKE 'Crimean-Congo haemorrhagic fever virus%' OR species LIKE 'Cryptococcus neoformans%' OR species LIKE 'Cryptosporidium hominis%' OR species LIKE 'Cryptosporidium parvum%' OR species LIKE 'Cunninghamella elegans%' OR species LIKE 'Cyclospora cayetanensis%' OR species LIKE 'Cytomegalovirus%' OR species LIKE 'Dematium wernecke%' OR species LIKE 'Dengue virus%' OR species LIKE 'Dientamoeba fragilis%' OR species LIKE 'Discomyces israelii%' OR species LIKE 'EAEC %' OR species LIKE 'Ebola virus%' OR species LIKE 'Echinococcus %' OR species LIKE 'Echovirus%' OR species LIKE 'EHEC %' OR species LIKE 'Emmonsia %' OR species LIKE 'Emmonsiella capsulate%' OR species LIKE 'Endomyces geotrichum%' OR species LIKE 'Entamoeba dispar%' OR species LIKE 'Entamoeba histolytica%' OR species LIKE 'Enterobacter aerogenes%' OR species LIKE 'Enterobacter cloacae%' OR species LIKE 'Enterobacteriaceae spp.%' OR species LIKE 'Enterobius vermicularis%' OR species LIKE 'Enterococcus faecalis%' OR species LIKE 'Enterococcus faecium%' OR species LIKE 'Enterococcus hirae%' OR species LIKE 'Entomophthora coronate%' OR species LIKE 'Epidermophyton%' OR species LIKE 'Epidermophyton floccosum%' OR species LIKE 'Epstein-Barr virus%' OR species LIKE 'Escherichia coli%' OR species LIKE 'ETEC %' OR species LIKE 'Filarial worms%' OR species LIKE 'Filobasidiella neoformans%' OR species LIKE 'Fonsecaea %' OR species LIKE 'Foot-and-mouth disease virus%' OR species LIKE 'Francisella tularensis%' OR species LIKE 'Fusobacterium nucleatum%' OR species LIKE 'Geotrichum candidum%' OR species LIKE 'Giardia lamblia%' OR species LIKE 'Glenospora khartoumensis%' OR species LIKE 'Gymnoascus gypseus%' OR species LIKE 'Haemophilus influenzae%' OR species LIKE 'Haemophilus parainfluenzae%' OR species LIKE 'Hantavirus%' OR species LIKE 'Haplosporangium parvum%' OR species LIKE 'Has two%' OR species LIKE 'Helicobacter bilis%' OR species LIKE 'Helicobacter canis%' OR species LIKE 'Helicobacter felis%' OR species LIKE 'Helicobacter hepaticus%' OR species LIKE 'Helicobacter mustelae%' OR species LIKE 'Helicobacter pylori%' OR species LIKE 'Helminths %' OR species LIKE 'Hepatitis %' OR species LIKE 'Herpes simplex virus%' OR species LIKE 'Histoplasma %' OR species LIKE 'Histoplasma capsulatum%' OR species LIKE 'Hormiscium dermatididis%' OR species LIKE 'Hormodendrum%' OR species LIKE 'Human enterovirus%' OR species LIKE 'Human immunodeficiency virus%' OR species LIKE 'Human metapneumovirus%' OR species LIKE 'Human papillomavirus%' OR species LIKE 'Hymenolepsis nana%' OR species LIKE 'Influenza %' OR species LIKE 'Influenza 1918%' OR species LIKE 'Influenza A%' OR species LIKE 'Influenza B%' OR species LIKE 'Influenza C%' OR species LIKE 'Influenza virus%' OR species LIKE 'Influenzavirus A%' OR species LIKE 'Keratinomyces %' OR species LIKE 'Klebsiella granulomatis%' OR species LIKE 'Klebsiella oxytoca%' OR species LIKE 'Klebsiella pneumoniae%' OR species LIKE 'Lactobacillus casei%' OR species LIKE 'Lactobacillus johnsonii%' OR species LIKE 'Langeronia soudanense%' OR species LIKE 'Lassa virus%' OR species LIKE 'Leclercia adecarboxylata%' OR species LIKE 'Legionella pneumophila%' OR species LIKE 'Leishmania %' OR species LIKE 'Lentivirus %' OR species LIKE 'Lentivirus Human%' OR species LIKE 'Leptosphaeria senegalensis%' OR species LIKE 'Leptospira interrogans%' OR species LIKE 'Leuconostoc pseudomesenteroides%' OR species LIKE 'Lichtheimia corymbifera%' OR species LIKE 'Listeria monocytogenes%' OR species LIKE 'Lobmyces loboi%' OR species LIKE 'Loboa loboi%' OR species LIKE 'Lobomycosis %' OR species LIKE 'Madurella %' OR species LIKE 'Malassezia furfur%' OR species LIKE 'Marburg virus%' OR species LIKE 'Measles virus%' OR species LIKE 'Micrococcus luteus%' OR species LIKE 'Micrococcus pelletieri%' OR species LIKE 'Microsporum %' OR species LIKE 'Molluscipoxvirus%' OR species LIKE 'Monilia %' OR species LIKE 'Moraxella catarrhalis%' OR species LIKE 'Morganella %' OR species LIKE 'Mucor %' OR species LIKE 'Mumps virus%' OR species LIKE 'Mycobacterium chimaera%' OR species LIKE 'Mycobacterium leprae%' OR species LIKE 'Mycobacterium tuberculosis%' OR species LIKE 'Mycoplasma gallisepticum%' OR species LIKE 'Mycoplasma genitalium%' OR species LIKE 'Mycoplasma pneumoniae%' OR species LIKE 'Naegleria fowleri%' OR species LIKE 'Nannizzia %' OR species LIKE 'Neisseria gonorrhoeae%' OR species LIKE 'Neisseria meningitidis%' OR species LIKE 'Neotestudina rosatii%' OR species LIKE 'Nocardia %' OR species LIKE 'Norovirus%' OR species LIKE 'Norovirus norwalk%' OR species LIKE 'Oidium albicans%' OR species LIKE 'Oospora lactis%' OR species LIKE 'Opisthorchis viverrini%' OR species LIKE 'Opportunistic pathogen%' OR species LIKE 'Orientia tsutsugamushi%' OR species LIKE 'Pantoea agglomerans%' OR species LIKE 'Paracoccidioides brasiliensis%' OR species LIKE 'Paracoccus yeei%' OR species LIKE 'Parainfluenza virus%' OR species LIKE 'Parvovirus%' OR species LIKE 'Pasteurella haemolytica%' OR species LIKE 'Pediculus humanus capitis%' OR species LIKE 'Pediculus humanus corporis%' OR species LIKE 'Petriellidium boydii%' OR species LIKE 'Phialophora %' OR species LIKE 'Piedraia hortae%' OR species LIKE 'Pityrosporum furfur%' OR species LIKE 'Plasmodium %' OR species LIKE 'Plasmodium falciparum%' OR species LIKE 'Pneumocystis jiroveci%' OR species LIKE 'Poliovirus%' OR species LIKE 'Polyomavirus%' OR species LIKE 'Polyomavirus %' OR species LIKE 'Polyomavirus Human%' OR species LIKE 'Polyomavirus Murine%' OR species LIKE 'Prevotella %' OR species LIKE 'Prions %' OR species LIKE 'Propionibacterium granulosum%' OR species LIKE 'Propionibacterium sp.%' OR species LIKE 'Propionibacterium species%' OR species LIKE 'Proteus mirabilis%' OR species LIKE 'Proteus vulgaris%' OR species LIKE 'Providencia rettgeri%' OR species LIKE 'Providencia stuartii%' OR species LIKE 'Pseudomonas %' OR species LIKE 'Pseudomonas aeruginosa%' OR species LIKE 'Pullularia gougerotii%' OR species LIKE 'Pyrenochaeta romeroi%' OR species LIKE 'Pythium %' OR species LIKE 'Rabies virus%' OR species LIKE 'Ralstonia %' OR species LIKE 'Ramose %' OR species LIKE 'Reovirus %' OR species LIKE 'Respiratory syncytial virus%' OR species LIKE 'Respirovirus %' OR species LIKE 'Respirovirus Parainfluenza%' OR species LIKE 'Respirovirus Sendai%' OR species LIKE 'Rhinosporidium seeberi%' OR species LIKE 'Rhinovirus%' OR species LIKE 'Ricin toxin%' OR species LIKE 'Rickettsia prowazekii%' OR species LIKE 'Rickettsia typhi%' OR species LIKE 'Ringworm %' OR species LIKE 'Roseomonas gilardii%' OR species LIKE 'Rotavirus%' OR species LIKE 'Rotavirus %' OR species LIKE 'Rotavirus Bovine%' OR species LIKE 'Rotavirus Human%' OR species LIKE 'Rotavirus Simian%' OR species LIKE 'Rotavirus Unclassified%' OR species LIKE 'Rubella virus%' OR species LIKE 'Sabouraudites %' OR species LIKE 'Saccharomyces cerevisiae%' OR species LIKE 'Salmonella enteritidis%' OR species LIKE 'Salmonella paratyphi%' OR species LIKE 'Salmonella sp.%' OR species LIKE 'Salmonella typhi%' OR species LIKE 'Salmonella typhimurium%' OR species LIKE 'Sapovirus%' OR species LIKE 'Sarcoptes scabiei%' OR species LIKE 'Sartorya fumigate%' OR species LIKE 'Schistosoma mansoni%' OR species LIKE 'Sepedonium %' OR species LIKE 'Serratia marcescens%' OR species LIKE 'Shiga toxin%' OR species LIKE 'Shiga-like toxin%' OR species LIKE 'Shigella dysenteriae%' OR species LIKE 'Shigella flexneri%' OR species LIKE 'Shigella sonnei%' OR species LIKE 'Shigella toxin%' OR species LIKE 'Sphingomonas species%' OR species LIKE 'Sporothrix schenckii%' OR species LIKE 'Sporotrichum %' OR species LIKE 'Staphylococcal enterotoxin-B%' OR species LIKE 'Staphylococcus aureus%' OR species LIKE 'Staphylococcus capitis%' OR species LIKE 'Staphylococcus epidermidis%' OR species LIKE 'Staphylococcus haemolyticus%' OR species LIKE 'Staphylococcus hominis%' OR species LIKE 'Staphylococcus lugdunensis%' OR species LIKE 'Staphylococcus pasteuri%' OR species LIKE 'Staphylococcus saprophyticus%' OR species LIKE 'STEC %' OR species LIKE 'Stenotrophomonas maltophilia%' OR species LIKE 'Streptococcus %' OR species LIKE 'Streptococcus gordonii%' OR species LIKE 'Streptococcus mitis%' OR species LIKE 'Streptococcus pneumoniae%' OR species LIKE 'Streptococcus pyogenes%' OR species LIKE 'Streptococcus sanguinis%' OR species LIKE 'Streptococcus suis%' OR species LIKE 'Strongyloides stercoralis%' OR species LIKE 'Taenia solium%' OR species LIKE 'TBE virus%' OR species LIKE 'Tinea %' OR species LIKE 'Torula %' OR species LIKE 'Toxoplasma gondii%' OR species LIKE 'Treponema pallidum%' OR species LIKE 'Trichinella spiralis%' OR species LIKE 'Trichomonas vaginalis%' OR species LIKE 'Trichophyton %' OR species LIKE 'Trichuris trichiura%' OR species LIKE 'Trypanosoma brucei gambiense%' OR species LIKE 'Trypanosoma brucei rhodesiense%' OR species LIKE 'Trypanosoma cruzi%' OR species LIKE 'UPEC %' OR species LIKE 'UPEC Lab%' OR species LIKE 'Usutu virus%' OR species LIKE 'Vaccinia virus%' OR species LIKE 'Varicella zoster virus%' OR species LIKE 'Variola virus%' OR species LIKE 'Verotoxin %' OR species LIKE 'Vibrio cholerae%' OR species LIKE 'Vibrio damsela%' OR species LIKE 'Vibrio furnissii%' OR species LIKE 'Vibrio harveyi%' OR species LIKE 'VTEC 107/86(serotype%' OR species LIKE 'West Nile virus%' OR species LIKE 'Yellow fever virus%' OR species LIKE 'Yersinia enterocolitica%' OR species LIKE 'Yersinia pestis%' OR species LIKE 'Yersinia pseudotuberculosis%' OR species LIKE 'Zika virus%' OR species LIKE 'Zopfia rosatii%' ) GROUP BY cluster, species ORDER BY species, score DESC
Unknown column 'protein.protein_id' in 'field list'
speciesnbprotproteinnamedomaingenescorenbdomainaction