Export All query results to one file vs separate in MariaDB?

I am querying hundreds of different databases and wondering if there is anyway to export the results into one file vs one file per result. The result view is appended into one tab and I was hoping "export all" meant all results into one file vs hundreds of files. Is this simply because I am querying different databases or is there a workaround? Most solutions I've read about are for exporting for back up and not results of a query. Thank you for any help.