Data for: Marine and freshwater fishes of Alabama: a revised checklist and discussion of taxonomic issues

Published: 29 December 2022| Version 1 | DOI: 10.17632/5y43cn9x4g.1
Contributor:
Justin Bagley

Description

OVERVIEW In support of the manuscript by Bagley et al. (submitted), this repository provides (1) the final cleaned FishNet2 collections database used in our study, (2) the FishNet2 database subsetted to the species in our final checklist, as well as (3) additional supplementary data and figures. These supplementary data are provided in a single Excel spreadsheet file named "Bagley_et_al_Supplementary_Data.xlsx." Sites shown in Figure 1 of the manuscript correspond directly to localities provided (with latitude and longitude in decimal degrees) in the spreadsheet file in this data accession. SUPPLEMENTARY DATA The enclosed Excel file contains the following supplementary datasets and figures: Table S1. Curated FishNet2 database for marine and freshwater fishes of Alabama and the Mobile River Basin (Bagley et al. submitted). Table S2. Subset of the final FishNet2 database from Bagley et al. (submitted) including records with cleaned, non-duplicate geographical coordinates. The 'Drainage' column was only used to designate Tombigbee River coordinates (many of which were from Mississippi) and separate them from the main set of coordinates, which were primarily from within the boundaries of the state of Alabama. Table S3. Subset of the final FishNet2 database from Bagley et al. (submitted) including records with cleaned, non-duplicate geographical coordinates from taxa scored as freshwater only in ecological habit ('F' designations in 'Habitat' column). Table S4. Subset of the final FishNet2 database from Bagley et al. (submitted) including records with cleaned, non-duplicate geographical coordinates from taxa scored as marine in ecological habit ('M' designations in 'Habitat' column). Table S5. Subset of the final FishNet2 database from Bagley et al. (submitted) including records with cleaned, non-duplicate geographical coordinates from taxa scored as both freshwater and marine in ecological habit ('F, M' designations in 'Habitat' column). Table S6. Subset of the final FishNet2 database from Bagley et al. (submitted) including records corresponding only to the species in our final checklist (Table 2 of manuscript). Table S7. Summary of number of collections (lots with records in database) by year of collection in the modified FishNet2 database of Bagley et al. (submitted). Figure S1. Line plot showing the number of collection records (lots) per year for fishes of Alabama and the Mobile River Basin represented in the final FishNet2 database of Bagley et al. (submitted). *Note: supplementary table/figure numbers given here may not be referenced in the corresponding manuscript; instead, the manuscript points users to this online data accession. REFERENCES Bagley JC, Johnson CC, Breitman MF, McGregor SW, O'Neil PE (submitted) Marine and freshwater fishes of Alabama: a revised checklist and discussion of taxonomic issues. Zootaxa. [Submission date: 27 December 2022.]

Files

Steps to reproduce

- Download regional fish collections records from FishNet2 database (http://www.fishnet2.net/). Here, our region was Alabama and the Mobile River Basin, which drains much of the area of the state and also extends into outlying areas of Mississippi and Georgia as well as a very small portion of southeastern Tennessee. The FishNet2 data have the advantage of backing collection localities/records with specimens accessioned in natural history museums. - Clean and edit records to (1) remove nonsense names, hybrid specimens, pet shop specimens, and collections with erroneous locality information; (2) fix taxonomic names of species and families to currently accepted names wherever possible; (3) keep only taxa meeting criteria for inclusion; and (4) fix incorrect or improperly formatted geographical coordinates (latitude/longitude, with conversion to decimal degrees format if possible) or set as missing/null ("–") for record. o Recommended: clean dataset using spreadsheet operations, as well as accurate and customized search and replace steps based on regular expressions (computer language of choice; we used BBEdit and UNIX command line software for this purpose). - Score each record by the (presumed) ecological habitat preferences ("Habitat") of the corresponding fish species/taxon; records scored with categorical variable labels 'F' (freshwater), 'M' (marine), or 'F, M' (freshwater and marine) for taxa that are diadromous or are known to occur in both habitat types during their lifetimes. - Map collection localities, both overall and after subsetting locality (site) data by habitat, using GIS software. - Use reasonable criteria (e.g., species, distribution, distance/area, provenance) to develop/expanded checklist of marine and freshwater fishes occurring in the study region based on the collections data. - Save working datasets and final datasets in Microsoft Excel and place in short-term and long-term storage according to data management plan.

Institutions

Geological Survey of Alabama, Auburn University at Montgomery

Categories

Systematics, Ichthyology, Fish, Freshwater Fish, Marine Fish, River Basin, Species Diversity, Animal Species, Alabama

License