I am looking for tidy tabular dataset that contains known bacteria and fungi down to the species level. Basically a table that includes genus and species names and other higher-level information. For example, whether it is gram-positive or negative, or anaerobic etc. A database with API would work too.
I found https://bacteria.ensembl.org/, but this is not so easy to use/automate.