How do I access certain columns through an API Query

for the CSV export, see https://forum.inaturalist.org/t/not-possible-to-select-from-all-existing-observation-field-values-during-data-export/32133

not sure what you mean about API defaults. you should be able to specify whatever you like via the API.