Name of User Agent data file to be able to ideniitify and remove malicious bot traffic from the database

General questions
1

We want to be able to identify the user agent Example Petalbot.
The purpose is to be able to remove malicious user agent bot data from the database and reports and provide an accurate report.
Using phpMyAdmin we are able to output a SQL file that lists the visiting IP addresses (location_ip)
What INET6_NTOA should be used to generate an SQL file with the list of user agents?

2

This user-agent seems unknown. Have a look at:
http://www.useragentstring.com/pages/useragentstring.php

For Matomo and bots, have a look at the plugin:

3

Additional note: GitHub page of the Bot tracker project:

4

Matomo uses DeviceDetector to parse the sent User Agents and I think also ignore bots by default. So you can use https://devicedetector.lw1.at to see if it is already detected and otherwise contribute it here:
https://github.com/matomo-org/device-detector/issues