Excel Data S1. Spreadsheet used in the statistical analysis of 1809 genera
Legend for Excel Data S1 for the report “Paleozoic geomagnetism shapes vertebrate evolution”. This spreadsheet was compiled from data of four sources: From paleobiology.org (Feb 9, 2017, upgraded Sept 17, 2017 ), we downloaded all occurrences of Paleozoic Chordata (accepted names only) with “output options” for “Classification”, “Stratigraphy”, and “Extended Stratigraphy”. We deleted all columns from the resulting spreadsheet except: “early_interval”, “late_interval”, “max_ma”, “min_ma”, “phylum”, “class”, “order”, “family”, “genus”, and the “stratcomments”. We added genera from Sepkoski’s 2002 Compendium of fossil marine animal genera (we used donaldkenney.x10.mx/SEPKOSKI.HTM for access). For Benton compilation we used data from “The first half of tetrapod evolution, sampling proxies, and fossil record quality” in the Dryad Digital Repository. Zhoa and Zhu’s 2010 portion of the spreadsheet is taken from their “Siluro-Devonian vertebrate biostratigraphy and biogeography of China).” We used fossilworks.org whenever needed for age-dating or taxonomy.
Column Headings in bold.
"File" names the 7 spreadsheets used in this report.
CRC Numbers represent taxonomy for CRC (Competitive Replacement Clades).
20G Numbers represent taxonomy for 20G clades (first 20 million years).
Source 4 sources (Paleobiology, Sepkoski, Benton, Zhoa&Zhu).
Clade Major clades used for this report.
SubClade Supportive taxonomy at the class level.
“Family” Supportive taxonomy at the family level.
EarlyStage Earliest geologic stage for each genus.
LateStage Latest geologic stage for range of age for the earliest species.
Max Maximum age of the geologic stage (Ma, millions of years).
Min Minimum age of the geologic stage (Ma).
Mean Mean age of the geologic stage (all ages are Ma).
Diff Interval of geologic stages (ages are from Gradstein 2012 when available, otherwise Paleobiology).
The following six columns are for calculating proportional dating of stages:
DnCRC CRC Denominator (this is the total number of genera in a geologic stage).
NmCRC CRC Numerator. A series of numbers (1 to one less than the total number—the newest genera are centered in the series).
AgeCRC CRC Age (equals Max minus Diff times the numerator divided by the denominator).
Dn20G 20G Denominator.
Nm20G 20G Numerator.
Age20G 20G Age (equals Max minus Diff times numerator divided by the denominator).
ZnMd Polarity zone using the mean age of a geologic stage.
Mid+/- Polarity zone (1=high polarity zones; 0=low polarity zones).
Age1Md Age of the earliest species of a clade or natural group, using mean age of its geologic stage.
DiffMd Difference, Age1Md minus the Mean age of the genus.
ZnMx Polarity zone using the maximum age of a geologic stage.
Mx+/- Polarity zone (1=high polarity zones; 0=low polarity zones).
Age1Mx Age of the earliest species of a clade or natural group using the maximum age of its geologic stage.
DiffMx Difference in Age1Mx minus the Max age of a genus.
Genera Repeat of the genus name.
ComA Comments, generally age related.
ComT Comments, generally taxonomy related. i