knitr::opts_chunk$set(tidy = FALSE, cache = FALSE)
options(knitr.kable.NA = '')
library(srppp)
library(dplyr)
library(knitr)The following list was used to identify product categories containing microorganisms.
| category_de | n |
|---|---|
| Akarizid | 59 |
| Bakterizid | 24 |
| Desinfektionsmittel | 3 |
| Fungizid | 269 |
| Herbizid | 332 |
| Insektizid | 133 |
| Insektizid (Insektenlockstoff, Pheromon) | 25 |
| Insektizid (Seifenpräparat) | 7 |
| Lebende Organismen (Bakterien) | 2 |
| Lebende Organismen (Insekten) | 113 |
| Lebende Organismen (Insektenviren) | 11 |
| Lebende Organismen (Milben) | 31 |
| Lebende Organismen (Nematoden) | 22 |
| Lebende Organismen (Pilze) | 12 |
| Lebende Organismen (gegen Pilze) | 7 |
| Molluskizid | 31 |
| Nematizid | 2 |
| Netz- und Haftmittel | 36 |
| Phytoregulator | 69 |
| Rodentizid | 8 |
| Saatbeizmittel | 26 |
| Stimulator der natürlichen Abwehrkräfte | 4 |
| Virizid | 1 |
| Vorratsschutzmittel | 19 |
| Wildabhaltemittel | 3 |
| Wundverschlussmittel | 1 |
The resulting product categories containing microorganisms were defined as follows:
microorganism_categories = c(
"Lebende Organismen (Bakterien)",
"Lebende Organismen (Pilze)",
"Lebende Organismen (gegen Pilze)")
kable(data.frame(Category = microorganism_categories))| Category |
|---|
| Lebende Organismen (Bakterien) |
| Lebende Organismen (Pilze) |
| Lebende Organismen (gegen Pilze) |
The corresponding products are shown below.
products_in_microorganism_categories <- srppp$products |>
filter(!isSalePermission) |>
left_join(srppp$categories, by = "pNbr") |>
filter(category_de %in% microorganism_categories) |>
select(pNbr, wNbr, name, category_de) |>
arrange(pNbr)
n_in_categories <- nrow(products_in_microorganism_categories)
kable(products_in_microorganism_categories)| pNbr | wNbr | name | category_de |
|---|---|---|---|
| 4594 | 4574 | Beauveria-Schweizer | Lebende Organismen (Pilze) |
| 7650 | 6423 | Metarhizium Schweizer | Lebende Organismen (Pilze) |
| 8025 | 6919 | Botector | Lebende Organismen (gegen Pilze) |
| 8029 | 6881 | BioAct WG | Lebende Organismen (Pilze) |
| 8119 | 6872 | Prestop | Lebende Organismen (gegen Pilze) |
| 8258 | 7151 | Amylo-X | Lebende Organismen (gegen Pilze) |
| 8309 | 6847 | Lalstop K61 WP | Lebende Organismen (gegen Pilze) |
| 8374 | 6912 | Deposan | Lebende Organismen (Bakterien) |
| 8926 | 7580 | Wormox | Lebende Organismen (Bakterien) |
| 8946 | 7504 | Taegro | Lebende Organismen (gegen Pilze) |
| 9014 | 7259 | AQ 10 | Lebende Organismen (Pilze) |
| 9049 | 7316 | Naturalis-L | Lebende Organismen (Pilze) |
| 9052 | 7324 | Rotstop | Lebende Organismen (gegen Pilze) |
| 9173 | 7378 | Beauveria-Maschinenring | Lebende Organismen (Pilze) |
| 9174 | 7379 | Metarhizium-Maschinenring | Lebende Organismen (Pilze) |
| 9384 | 7528 | Beauveria FL-Maschinenring | Lebende Organismen (Pilze) |
| 9385 | 7529 | Metarhizium FL-Maschinenring | Lebende Organismen (Pilze) |
| 9389 | 7477 | Melocont GR | Lebende Organismen (Pilze) |
| 9390 | 7478 | GranMet GR | Lebende Organismen (Pilze) |
| 9479 | 7498 | Lalstop Contans WG | Lebende Organismen (gegen Pilze) |
| 9481 | 7500 | Lalguard M52 GR | Lebende Organismen (Pilze) |
The following lists of active substances in insecticides and fungicides were used to establish filter criteria active substances that are microorganisms.
srppp$products |>
filter(!isSalePermission) |>
left_join(srppp$categories, by = "pNbr") |>
filter(category_de == "Insektizid") |>
left_join(srppp$ingredients, by = "pNbr", relationship = "many-to-many") |>
left_join(srppp$substances, by = "pk") |>
select(substance_de) |>
unique() |>
arrange(substance_de) |>
kable()| substance_de |
|---|
| 1,2-Benzisothiazol-3(2H)-on |
| 3,6-Dimethyl-4-octin-3,6-diol |
| Abamectin |
| Acetamiprid |
| Alcohols, C12-15, ethoxylated |
| Anastatus bifasciatus |
| Azadirachtin A |
| Bacillus thuringiensis var. aizawai |
| Bacillus thuringiensis var. israeliensis |
| Bacillus thuringiensis var. kurstaki |
| Bacillus thuringiensis var. tenebrionis |
| Beauveria brongniartii |
| Benzolsulfonsäure |
| Benzolsulfonsäure, Mono-C11-13-verzweigte Alkylderivate, Calciumsalze |
| Buprofezin |
| C14-C16-Alkanehydroxysulfonic acids sodium salts |
| Calcium Dodecylbenzene Sulfonate |
| Calciumcarbonat |
| Chlorantraniliprol |
| Cypermethrin |
| Deltamethrin |
| Emamectinbenzoat |
| Etofenprox |
| Eupeodes corollae |
| Fettsäuren |
| Flonicamid |
| Gamma Butyrolacton |
| Heterorhabditis bacteriophora |
| Heterorhabditis downesi |
| Hydrocarbons, C10-C13, aromatics, <1% naphthalene |
| Kaliumhydrogencarbonat |
| Kaolin |
| Lambda-Cyhalothrin |
| Lösungsmittelnaphtha (Erdöl), leichte aromatische |
| Maltodextrin |
| Metarhizium anisopliae |
| Oleylamin ethoxyliert, Dodecylbenzensulfonsalz |
| Orangenöl |
| Paraffinöl |
| Piperonyl butoxid |
| Pirimicarb |
| Pyrethrine |
| Quassiaextrakt |
| Rapsöl |
| Sesamöl raffiniert |
| Solvent Naphtha |
| Solvent naphtha (petroleum), heavy arom.; Kerosine - unspecified |
| Sphaerophoria rueppellii |
| Spinetoram |
| Spinosad |
| Spirotetramat |
| Steinernema carpocapsae |
| Steinernema carpocapsae all strain |
| Steinernema feltiae |
| Sulfurylfluorid |
| Tebufenozide |
| Tefluthrin |
| Tetrahydrofurfuryl-Alkohol |
| Trichogramma brassicae Bezdenko |
| Trichogramma cacoeciae |
| Trichogramma evanescens |
| Weisses Mineralöl (Petroleum) |
| Xenorhabdus bovienii |
| Xylol |
| alcohols, (c12-14), ethoxylated, monoethers with sulfuric acid, sodium salts |
| alcohols, c11-15-secondary, ethoxylated |
srppp$products |>
filter(!isSalePermission) |>
left_join(srppp$categories, by = "pNbr") |>
filter(category_de == "Fungizid") |>
left_join(srppp$ingredients, by = "pNbr", relationship = "many-to-many") |>
left_join(srppp$substances, by = "pk") |>
select(substance_de) |>
unique() |>
arrange(substance_de) |>
kable()| substance_de |
|---|
| (Z)-9-Octadecen-1-ol ethoxylated |
| 1,2-Benzisothiazol-3(2H)-on |
| 1,2-benzisothiazol-3(2H)-one; 1,2-benzisothiazolin-1 3-one |
| 1,2-benzisothiazol-3(2H)-one; 1,2-benzisothiazolin-3-one |
| 1-Butanol |
| 1-Octyl-2-pyrrolidon |
| 2,2’,2’’-(hexahydro-1,3,5-triazine-1,3,5-triyl)triethanol / 1,3,5-tris(2-hydroxyethyl)hexahydro-1,3,5-triazine |
| 2-Ethylhexyl-S-Lactat |
| 2-Ethylhexyllaktat |
| 2-Methyl-2H-isothiazol-3-on |
| Alcohols C9-11, ethoxylated propoxylated |
| Alcohols, C12-15, ethoxylated |
| Alcohols, C9-11, ethoxylated |
| Aluminiumfosetyl (Fosetyl-Al) |
| Ametoctradin |
| Amisulbrom |
| Ampelomyces quisqualis |
| Anethol (1-methoxyl-(1-Propenyl) benzen) |
| Aureobasidium pullulans |
| Azoxystrobin |
| Bacillus amyloliquefaciens |
| Benalaxyl-M |
| Benthiavalicarb-isopropyl |
| Benzolsulfonsäure |
| Benzolsulfonsäure, 4-C10-13-sec-Alkylderivate |
| Benzovindiflupyr |
| Benzylalkohol |
| Bixafen |
| Boscalid |
| Bupirimate |
| C14-C16-Alkanehydroxysulfonic acids sodium salts |
| Calcium Dodecylbenzene Sulfonate |
| Captan |
| Cyazofamid |
| Cyflufenamid |
| Cymoxanil |
| Cyprodinil |
| Dazomet (DMTT) |
| Decanamide, N, N- dimethyl |
| Destillate (Erdöl) |
| Difenoconazol |
| Dimethomorph |
| Dinatriumphosphonat |
| Dipenten; Limonen |
| Disodium maleate |
| Dithianon |
| Docusatnatrium |
| Dodecylbenzolsulfonsäure, Verbindung mit 2-Aminoethanol (1:1) |
| Dodine |
| Estragol |
| Ethylenediamine, ethoxylated and propoxylated |
| Fenhexamid |
| Fenpropidin |
| Fenpyrazamin |
| Fluazinam |
| Fludioxonil |
| Fluopicolide |
| Fluopyram |
| Fluoxastrobin |
| Flutolanil |
| Fluxapyroxad |
| Folpet |
| Fosetyl |
| Gemisch aus: 2-Ethylhexyl-mono-D-glucopyranosid und 2-Ethylhexyl-di-D-glucopyranosid |
| Imazalil |
| Iprovalicarb |
| Kaliumhydrogencarbonat |
| Kaliumphosphonat |
| Kresoxim-methyl |
| Kupfer (als Hydroxid) |
| Kupfer (als Kalkpräparat, Bordeaux-Brühe) |
| Kupfer (als Octanoat) |
| Kupfer (als Oxychlorid) |
| Kupfer (als Tribasisches Kupfersulfat) |
| Lösungsmittelnaphtha (Erdöl), leichte aromatische |
| Mandipropamid |
| Mefentrifluconazole |
| Mepanipyrim |
| Mepiquatchlorid |
| Metalaxyl-M |
| Metconazole |
| Methenamin; Hexamethylenetetramin |
| Metiram |
| Metrafenone |
| N,N-Dimethyloctanamide |
| Naphtalin |
| Naphtha (Erdoel), schwere Alkylat- [Enthält weniger als 0.1 % Benzol] |
| Naphthalenesulfonic acid, methyl-, polymer with formaldehyde, sodium salt |
| Natrium-di-butyl-naphtalinsulfonat |
| Natriumdiisopropylnaphtalinsulfonat |
| Natriumhydroxid |
| Oleum foeniculi |
| Orangenöl |
| Paclobutrazol |
| Penconazole |
| Pentanol, verzweigt und linear |
| Penthiopyrad |
| Phlebia gigantea |
| Pin-2(3)-en |
| Propamocarb |
| Propyllaktat |
| Proquinazid |
| Prothioconazole |
| Pseudomonas sp. Stamm DSMZ 13134 |
| Pyraclostrobin |
| Pyrimethanil |
| Pyriofenon |
| Quarz |
| Schachtelhalmextrakt |
| Schwefel |
| Schwefelkalk (Calciumpolysulfid) |
| Schwefelsaure Tonerde |
| Solvent Naphtha |
| Solvent naphtha (petroleum), heavy arom.; Kerosine - unspecified |
| Spiroxamine |
| Tebuconazole |
| Tetranatriumpyrophosphat |
| Thiabendazole |
| Trifloxystrobin |
| Valifenalate |
| Zoxamid |
| alcohols, (c12-14), ethoxylated, monoethers with sulfuric acid, sodium salts |
| alcohols, c11-15-secondary, ethoxylated |
| linalyl alcohol |
| pentanoic acid, 5-(dimethylamino)-2-methyl-5-oxo-, methyl ester |
| poly(oxy-1,2-ethanediyl),alphaisotridecyl-omegahydroxy |
| polyoxyethylene trimethyldecyl alcohol |
The following genus names were established as filtering criteria.
microorganism_genus_names <- c(
"Bacillus",
"Beauveria",
"Metarhizium",
"Xenorhabdus",
"Phlebia",
"Pseudomonas")
kable(data.frame("Genus names" = microorganism_genus_names, check.names = FALSE))| Genus names |
|---|
| Bacillus |
| Beauveria |
| Metarhizium |
| Xenorhabdus |
| Phlebia |
| Pseudomonas |
This results in the following list of active ingredients.
microorganism_regexp <- paste(microorganism_genus_names, collapse = "|")
microorganism_ingredients <- srppp$substances |>
filter(grepl(microorganism_regexp, substance_de)) |>
select(pk, substance_de)
kable(microorganism_ingredients)| pk | substance_de |
|---|---|
| 849 | Beauveria brongniartii |
| 935 | Bacillus thuringiensis var. israeliensis |
| 937 | Bacillus thuringiensis var. aizawai |
| 939 | Bacillus thuringiensis var. kurstaki |
| 960 | Metarhizium anisopliae |
| 970 | Bacillus thuringiensis var. tenebrionis |
| 972 | Beauveria bassiana |
| 984 | Phlebia gigantea |
| 1369 | Pseudomonas chlororaphis |
| 1442 | Xenorhabdus bovienii |
| 1584 | Pseudomonas sp. Stamm DSMZ 13134 |
| 1748 | Bacillus amyloliquefaciens ssp. plantarum |
| 1939 | Bacillus amyloliquefaciens |
The following products contain one of these active ingredients.
additional_products_containing_microorganisms <- srppp$products |>
filter(!isSalePermission) |>
left_join(srppp$ingredients, by = "pNbr", relationship = "many-to-many") |>
filter(pk %in% microorganism_ingredients$pk) |>
select(-pk) |>
left_join(srppp$categories, by = "pNbr") |>
select(pNbr, wNbr, name, category_de) |>
arrange(pNbr)
n_additional <- nrow(additional_products_containing_microorganisms)
kable(additional_products_containing_microorganisms)| pNbr | wNbr | name | category_de |
|---|---|---|---|
| 4594 | 4574 | Beauveria-Schweizer | Lebende Organismen (Pilze) |
| 6415 | 5277 | Traunem | Lebende Organismen (Nematoden) |
| 6415 | 5277 | Traunem | Insektizid |
| 6427 | 5386 | Entonem | Lebende Organismen (Nematoden) |
| 6861 | 5745 | Solbac-Tabs | Insektizid |
| 6862 | 5744 | Solbac | Insektizid |
| 7023 | 5925 | Novodor 3 FC | Insektizid |
| 7088 | 5978 | Nemaplus | Lebende Organismen (Nematoden) |
| 7241 | 6081 | Novodor 3 % FC | Insektizid |
| 7496 | 6449 | Cerall | Saatbeizmittel |
| 7498 | 6486 | Cedomon | Saatbeizmittel |
| 7650 | 6423 | Metarhizium Schweizer | Lebende Organismen (Pilze) |
| 7766 | 6882 | Agree WP | Insektizid |
| 7773 | 6472 | FZB 24 flüssig | Phytoregulator |
| 7773 | 6472 | FZB 24 flüssig | Fungizid |
| 7870 | 6552 | Delfin | Insektizid |
| 8007 | 6888 | XenTari WG | Insektizid |
| 8040 | 6777 | Dipel DF | Insektizid |
| 8258 | 7151 | Amylo-X | Lebende Organismen (gegen Pilze) |
| 8296 | 6835 | Dipel DF | Insektizid |
| 8374 | 6912 | Deposan | Lebende Organismen (Bakterien) |
| 8374 | 6912 | Deposan | Fungizid |
| 8457 | 6929 | Proradix | Saatbeizmittel |
| 8519 | 6966 | XenTari WG | Insektizid |
| 8596 | 7253 | Serenade ASO | Bakterizid |
| 8596 | 7253 | Serenade ASO | Fungizid |
| 8926 | 7580 | Wormox | Lebende Organismen (Bakterien) |
| 8926 | 7580 | Wormox | Insektizid |
| 8946 | 7504 | Taegro | Lebende Organismen (gegen Pilze) |
| 8946 | 7504 | Taegro | Fungizid |
| 9019 | 7272 | Bio Buxus | Insektizid |
| 9020 | 7273 | Bio Raupen Stopp | Insektizid |
| 9049 | 7316 | Naturalis-L | Lebende Organismen (Pilze) |
| 9052 | 7324 | Rotstop | Lebende Organismen (gegen Pilze) |
| 9052 | 7324 | Rotstop | Fungizid |
| 9139 | 7574 | Capirel | Lebende Organismen (Nematoden) |
| 9173 | 7378 | Beauveria-Maschinenring | Insektizid |
| 9173 | 7378 | Beauveria-Maschinenring | Lebende Organismen (Pilze) |
| 9174 | 7379 | Metarhizium-Maschinenring | Insektizid |
| 9174 | 7379 | Metarhizium-Maschinenring | Lebende Organismen (Pilze) |
| 9384 | 7528 | Beauveria FL-Maschinenring | Insektizid |
| 9384 | 7528 | Beauveria FL-Maschinenring | Lebende Organismen (Pilze) |
| 9385 | 7529 | Metarhizium FL-Maschinenring | Insektizid |
| 9385 | 7529 | Metarhizium FL-Maschinenring | Lebende Organismen (Pilze) |
| 9389 | 7477 | Melocont GR | Lebende Organismen (Pilze) |
| 9390 | 7478 | GranMet GR | Lebende Organismen (Pilze) |
| 9481 | 7500 | Lalguard M52 GR | Insektizid |
| 9481 | 7500 | Lalguard M52 GR | Lebende Organismen (Pilze) |
In summary, out of 1694 products, there are 21 in the microorganism categories as shown above, and 48 products in the insecticide and fungicide categories which contain an active substance that has a name that contains one of the microorganism genus names listed above.
products_containing_microorganisms <- rbind(
products_in_microorganism_categories,
additional_products_containing_microorganisms) |>
arrange(pNbr, category_de) |>
unique()
n_unique <- length(unique(products_containing_microorganisms$pNbr))The consolidated list of the 42 unique products identified in this way is shown below. Some of these products are listed twice, because they were identified via both ways.
| pNbr | wNbr | name | category_de |
|---|---|---|---|
| 4594 | 4574 | Beauveria-Schweizer | Lebende Organismen (Pilze) |
| 6415 | 5277 | Traunem | Insektizid |
| 6415 | 5277 | Traunem | Lebende Organismen (Nematoden) |
| 6427 | 5386 | Entonem | Lebende Organismen (Nematoden) |
| 6861 | 5745 | Solbac-Tabs | Insektizid |
| 6862 | 5744 | Solbac | Insektizid |
| 7023 | 5925 | Novodor 3 FC | Insektizid |
| 7088 | 5978 | Nemaplus | Lebende Organismen (Nematoden) |
| 7241 | 6081 | Novodor 3 % FC | Insektizid |
| 7496 | 6449 | Cerall | Saatbeizmittel |
| 7498 | 6486 | Cedomon | Saatbeizmittel |
| 7650 | 6423 | Metarhizium Schweizer | Lebende Organismen (Pilze) |
| 7766 | 6882 | Agree WP | Insektizid |
| 7773 | 6472 | FZB 24 flüssig | Fungizid |
| 7773 | 6472 | FZB 24 flüssig | Phytoregulator |
| 7870 | 6552 | Delfin | Insektizid |
| 8007 | 6888 | XenTari WG | Insektizid |
| 8025 | 6919 | Botector | Lebende Organismen (gegen Pilze) |
| 8029 | 6881 | BioAct WG | Lebende Organismen (Pilze) |
| 8040 | 6777 | Dipel DF | Insektizid |
| 8119 | 6872 | Prestop | Lebende Organismen (gegen Pilze) |
| 8258 | 7151 | Amylo-X | Lebende Organismen (gegen Pilze) |
| 8296 | 6835 | Dipel DF | Insektizid |
| 8309 | 6847 | Lalstop K61 WP | Lebende Organismen (gegen Pilze) |
| 8374 | 6912 | Deposan | Fungizid |
| 8374 | 6912 | Deposan | Lebende Organismen (Bakterien) |
| 8457 | 6929 | Proradix | Saatbeizmittel |
| 8519 | 6966 | XenTari WG | Insektizid |
| 8596 | 7253 | Serenade ASO | Bakterizid |
| 8596 | 7253 | Serenade ASO | Fungizid |
| 8926 | 7580 | Wormox | Insektizid |
| 8926 | 7580 | Wormox | Lebende Organismen (Bakterien) |
| 8946 | 7504 | Taegro | Fungizid |
| 8946 | 7504 | Taegro | Lebende Organismen (gegen Pilze) |
| 9014 | 7259 | AQ 10 | Lebende Organismen (Pilze) |
| 9019 | 7272 | Bio Buxus | Insektizid |
| 9020 | 7273 | Bio Raupen Stopp | Insektizid |
| 9049 | 7316 | Naturalis-L | Lebende Organismen (Pilze) |
| 9052 | 7324 | Rotstop | Fungizid |
| 9052 | 7324 | Rotstop | Lebende Organismen (gegen Pilze) |
| 9139 | 7574 | Capirel | Lebende Organismen (Nematoden) |
| 9173 | 7378 | Beauveria-Maschinenring | Insektizid |
| 9173 | 7378 | Beauveria-Maschinenring | Lebende Organismen (Pilze) |
| 9174 | 7379 | Metarhizium-Maschinenring | Insektizid |
| 9174 | 7379 | Metarhizium-Maschinenring | Lebende Organismen (Pilze) |
| 9384 | 7528 | Beauveria FL-Maschinenring | Insektizid |
| 9384 | 7528 | Beauveria FL-Maschinenring | Lebende Organismen (Pilze) |
| 9385 | 7529 | Metarhizium FL-Maschinenring | Insektizid |
| 9385 | 7529 | Metarhizium FL-Maschinenring | Lebende Organismen (Pilze) |
| 9389 | 7477 | Melocont GR | Lebende Organismen (Pilze) |
| 9390 | 7478 | GranMet GR | Lebende Organismen (Pilze) |
| 9479 | 7498 | Lalstop Contans WG | Lebende Organismen (gegen Pilze) |
| 9481 | 7500 | Lalguard M52 GR | Insektizid |
| 9481 | 7500 | Lalguard M52 GR | Lebende Organismen (Pilze) |