Host_Plant_Data <- read.csv("C:/Users/HRLJXP/OneDrive - Plant and Food Research/2025/Xylella/Xylella Plant Host Table/CSVs/20240520_Host Plant Data.csv")
Field_Trial_sites <- read.csv("C:/Users/HRLJXP/OneDrive - Plant and Food Research/2025/Xylella/Xylella Plant Host Table/CSVs/Field trial sites 2020_2023.csv")##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionThis table only include the tree species that have been idenitified to genus. Unknowns/other species was excluded for this round but can be altered to include other species as needed.
knitr::kable(summary_table1)| Plant.binomial.name | Bathyllus | Carystoterpa | Philaenus |
|---|---|---|---|
| Adult, Nymph, Nymph | Adult | Adult, Nymph | |
| Acer | Nymph | ||
| Achillea millefolium | Adult | ||
| Aciphylla | Adult, Nymph | ||
| Anaphalioides bellidioides | Nymph | ||
| Artistea ecklonii | Nymph | ||
| Asplenium gracillimum | Adult | ||
| Calendula officinalis | Nymph | ||
| Carmichaelia | Adult, Nymph | ||
| Carpobrotus chilensis | Nymph | ||
| Celmisia | Nymph | ||
| Cenchrus clandestinus | Nymph | ||
| Cirsium vulgare | Nymph | ||
| Claytonia perfoliata | Nymph | ||
| Conyza sumatrensis | Nymph | ||
| Coprosma | Nymph | Adult, Nymph | |
| Coprosma acerosa | Nymph | ||
| Coprosma crassifolia | Nymph | ||
| Coprosma grandifolia | Adult | ||
| Coprosma lucida | Nymph | ||
| Coprosma macrocarpa | Adult | ||
| Coprosma propinqua | Nymph | ||
| Coprosma repens | Adult | Nymph | |
| Coprosma rhamnoides | Nymph | ||
| Coprosma robusta | Adult, Nymph | Nymph | |
| Coprosma rugosa | Nymph | ||
| Cotoneaster | Adult | ||
| Crataegus monogyna | Nymph | ||
| Cynara cardunculus var. scolymus | Nymph | ||
| Cytisus scoparius | Nymph | ||
| Discaria | Nymph | ||
| Discaria toumatou | Nymph | ||
| Dodonaea viscosa | Nymph | ||
| Echium vulgare | Nymph | ||
| Euonymus europaeus | Nymph | ||
| Fabaceae | Adult, Nymph | ||
| Foeniculum vulgare | Adult, Nymph | ||
| Fuchsia | Nymph | ||
| Fuchsia excorticata | Adult, Nymph | ||
| Galium aparine | Nymph | ||
| Geniostoma ligustrifolium | Nymph | ||
| Haloragis erecta | Nymph | ||
| Hoheria sexstylosa | Nymph | ||
| Holcus lanatus | Nymph | ||
| Hypericum | Adult | ||
| Hypochaeris radicata | Nymph | ||
| Hypolepis ambigua | Nymph | ||
| Jacobaea vulgaris | Nymph | ||
| Kniphofia | Nymph | ||
| Kunzea ericoides | Nymph | ||
| Kunzea robusta | Nymph | ||
| Lonicera japonica | Nymph | ||
| Lythrum hyssopifolia� | Nymph | ||
| Malus domestica | Nymph | ||
| Marrubium vulgare | Nymph | ||
| Medicago lupulina | Nymph | ||
| Medicago sativa | Adult | ||
| Melicope simplex | Nymph | ||
| Melicytus orarius | Nymph | ||
| Melicytus ramiflorus | Adult, Nymph | Adult | |
| Modiola caroliniana | Nymph | ||
| Muehlenbeckia | Adult | ||
| Muehlenbeckia australis | Adult | Nymph | |
| Muehlenbeckia complexa | Nymph | ||
| Myoporum laetum | Adult, Nymph | Nymph | |
| Myosotis� | Nymph | ||
| Olearia paniculata | Nymph | ||
| Olearia solandri | Nymph | ||
| Ozothamnus leptophyllus | Adult, Nymph | ||
| Paspalum dilatatum | Nymph | ||
| Petroselinum | Adult | ||
| Pittosporum eugenioides | Nymph | ||
| Pittosporum tenuifolium | Nymph | ||
| Plagianthus | Nymph | ||
| Plagianthus divaricatus | Nymph | ||
| Populus nigra | Nymph | ||
| Prunus armeniaca | Adult | ||
| Pseudopanax | Nymph | ||
| Pseudopanax arboreus | Nymph | Adult, Nymph | |
| Pyrus calleryana | Nymph | ||
| Rheum � rhabarbarum | Adult | ||
| Rubus | Nymph | ||
| Rumex pulcher | Nymph | ||
| Schoenus apogon | Nymph | ||
| Solanum aviculare | Nymph | ||
| Stellaria media | Nymph | ||
| Taraxacum | Nymph | ||
| Tragopogon | Adult | ||
| Trifolium arvense | Nymph | ||
| Trifolium repens | Nymph | ||
| Ulex europaeus | Nymph | ||
| Verbascum blattaria | Nymph | ||
| Veronica | Adult | Nymph | |
| Veronica speciosa | Nymph | ||
| Veronica stricta | Nymph | ||
| Veronica strictissima | Adult | ||
| �Brachyglottis repanda | Adult |
This table provides the same results as below but also has the tube numbers so we can double check.
knitr::kable(summary_table)| Plant.binomial.name | Insect.life.stage_Bathyllus | Insect.life.stage_Carystoterpa | Insect.life.stage_Philaenus | Tube.number_Bathyllus | Tube.number_Carystoterpa | Tube.number_Philaenus |
|---|---|---|---|---|---|---|
| Adult, Nymph, Nymph | Adult | Adult, Nymph | 1394, 1396, 1398, 1390, 1799, 1803 | 1731, 1918, 1919, 1920, 1925, 1926 | 1126, 1151, 1152, 1153, 1154, 1155, 1156.1, 1156.2, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1817, 1900, 1090, 1841, 1909, 1912 | |
| Acer | Nymph | 1445 | ||||
| Achillea millefolium | Adult | 436 | ||||
| Aciphylla | Adult, Nymph | 1623, 1623.1, 1622.1 | ||||
| Anaphalioides bellidioides | Nymph | 1644 | ||||
| Artistea ecklonii | Nymph | 1326 | ||||
| Asplenium gracillimum | Adult | 1671 | ||||
| Calendula officinalis | Nymph | 1484 | ||||
| Carmichaelia | Adult, Nymph | 186, 259, 260, 261, 262, 263, 271, 272, 41 | ||||
| Carpobrotus chilensis | Nymph | 1505 | ||||
| Celmisia | Nymph | 1620 | ||||
| Cenchrus clandestinus | Nymph | 1330 | ||||
| Cirsium vulgare | Nymph | 1340 | ||||
| Claytonia perfoliata | Nymph | 430 | ||||
| Conyza sumatrensis | Nymph | 420 | ||||
| Coprosma | Nymph | Adult, Nymph | 1096 | 703, 704, 705, 701, 1527, 1553 | ||
| Coprosma acerosa | Nymph | 1646 | ||||
| Coprosma crassifolia | Nymph | 1524 | ||||
| Coprosma grandifolia | Adult | 1208, 1209 | ||||
| Coprosma lucida | Nymph | 1363 | ||||
| Coprosma macrocarpa | Adult | 1366 | ||||
| Coprosma propinqua | Nymph | 1519, 1657 | ||||
| Coprosma repens | Adult | Nymph | 1895 | 1552, 1649 | ||
| Coprosma rhamnoides | Nymph | 1520 | ||||
| Coprosma robusta | Adult, Nymph | Nymph | 1147.1, 1147.2, 1148.1, 1148.2, 1148.3, 1148.4, 1148.5, 1148.6, 1148.7, 1148.8, 1149.1, 1149.2, 1149.3, 1149.4, 1149.5, 1149.6, 1149.7, 1149.8, 1149.9, 1370, 1379, 1381, 1384, 1384.1, 1384.2, 1385, 1455, 1456, 1457, 1458, 1458.1, 1459, 1921, 1923, 1148.9, 1350, 1350.1 | 1539, 1559 | ||
| Coprosma rugosa | Nymph | 1115 | ||||
| Cotoneaster | Adult | 148 | ||||
| Crataegus monogyna | Nymph | 1586 | ||||
| Cynara cardunculus var. scolymus | Nymph | 1515 | ||||
| Cytisus scoparius | Nymph | 1509 | ||||
| Discaria | Nymph | 1523 | ||||
| Discaria toumatou | Nymph | 44, 1518 | ||||
| Dodonaea viscosa | Nymph | 1543 | ||||
| Echium vulgare | Nymph | 1588 | ||||
| Euonymus europaeus | Nymph | 534 | ||||
| Fabaceae | Adult, Nymph | 116, 117, 118, 120, 121, 122, 123, 124, 297, 1592 | ||||
| Foeniculum vulgare | Adult, Nymph | 395, 401 | ||||
| Fuchsia | Nymph | 1655 | ||||
| Fuchsia excorticata | Adult, Nymph | 679, 680, 681, 682, 683, 687, 673, 674, 675, 676, 677, 678, 684, 685, 686 | ||||
| Galium aparine | Nymph | 354, 1447.1 | ||||
| Geniostoma ligustrifolium | Nymph | 1324 | ||||
| Haloragis erecta | Nymph | 1658 | ||||
| Hoheria sexstylosa | Nymph | 1497 | ||||
| Holcus lanatus | Nymph | 1338 | ||||
| Hypericum | Adult | 959, 961 | ||||
| Hypochaeris radicata | Nymph | 1336, 1571 | ||||
| Hypolepis ambigua | Nymph | 1624 | ||||
| Jacobaea vulgaris | Nymph | 1521 | ||||
| Kniphofia | Nymph | 423 | ||||
| Kunzea ericoides | Nymph | 698, 1556 | ||||
| Kunzea robusta | Nymph | 1143 | ||||
| Lonicera japonica | Nymph | 1531 | ||||
| Lythrum hyssopifolia� | Nymph | 1332 | ||||
| Malus domestica | Nymph | 1474 | ||||
| Marrubium vulgare | Nymph | 1584 | ||||
| Medicago lupulina | Nymph | 55 | ||||
| Medicago sativa | Adult | 305 | ||||
| Melicope simplex | Nymph | 1522 | ||||
| Melicytus orarius | Nymph | 1535 | ||||
| Melicytus ramiflorus | Adult, Nymph | Adult | 1134, 1451 | 1670 | ||
| Modiola caroliniana | Nymph | 419 | ||||
| Muehlenbeckia | Adult | 185 | ||||
| Muehlenbeckia australis | Adult | Nymph | 690 | 1634 | ||
| Muehlenbeckia complexa | Nymph | 1091 | ||||
| Myoporum laetum | Adult, Nymph | Nymph | 1542, 1661, 1662, 1663, 1541, 1541.1 | 1479 | ||
| Myosotis� | Nymph | 1577 | ||||
| Olearia paniculata | Nymph | 695 | ||||
| Olearia solandri | Nymph | 1511 | ||||
| Ozothamnus leptophyllus | Adult, Nymph | 179, 180, 235, 236, 237, 1528 | ||||
| Paspalum dilatatum | Nymph | 1325 | ||||
| Petroselinum | Adult | 1388 | ||||
| Pittosporum eugenioides | Nymph | 370 | ||||
| Pittosporum tenuifolium | Nymph | 1319 | ||||
| Plagianthus | Nymph | 1493 | ||||
| Plagianthus divaricatus | Nymph | 1507, 1507.1 | ||||
| Populus nigra | Nymph | 424 | ||||
| Prunus armeniaca | Adult | 184 | ||||
| Pseudopanax | Nymph | 1653 | ||||
| Pseudopanax arboreus | Nymph | Adult, Nymph | 1093, 1547 | 1132, 1485 | ||
| Pyrus calleryana | Nymph | 1471 | ||||
| Rheum � rhabarbarum | Adult | 1508 | ||||
| Rubus | Nymph | 1341 | ||||
| Rumex pulcher | Nymph | 1475 | ||||
| Schoenus apogon | Nymph | 1343 | ||||
| Solanum aviculare | Nymph | 1482 | ||||
| Stellaria media | Nymph | 1581 | ||||
| Taraxacum | Nymph | 1560 | ||||
| Tragopogon | Adult | 1125, 1130 | ||||
| Trifolium arvense | Nymph | 1570 | ||||
| Trifolium repens | Nymph | 1565 | ||||
| Ulex europaeus | Nymph | 1355 | ||||
| Verbascum blattaria | Nymph | 1567 | ||||
| Veronica | Adult | Nymph | 697 | 1320, 1513, 1650 | ||
| Veronica speciosa | Nymph | 1651 | ||||
| Veronica stricta | Nymph | 1549 | ||||
| Veronica strictissima | Adult | 1207 | ||||
| �Brachyglottis repanda | Adult | 1922 |