Hi,
currently I am using the following code to extract "phyla" part of a long label in a new column of dataset ITS_counts.
ITS_counts3 <- ITS_counts |> mutate(Phyla = str_extract(taxonomy, "(?<=;p__).+;c"))
this allows me to isolate the part of the taxonomy column that I want, but leaves the ;c on the end, which I want to get rid of. How would I do this? Thanks.