Data dictionary
What each column of the collection data holds, and how the three files fit together.
The downloads hold three tables, each as CSV and as JSON: species, held lines and media recipes. A held line is a cell line the lab still keeps, live, in cryo, or with neither yet recorded. The README in the zip describes the same columns, in the same words.
How the files fit together
- A held line's
species_idnames its species in the species file. - The Media Codes in a held line's
mediaare themediumof recipes in the media file. A medium may have no recipe there yet. - Each line and species has a page of its own:
line/and its Culture ID (spaces as hyphens), andspecies/and itsspecies_id.
Species
pccl-species-2026-11-12.csv and pccl-species-2026-11-12.json. One row per species with at least one held line.
species_id- PCCL's ID for the species, as in its page address. Never given to another species.
name- The species' accepted scientific name, as the lab uses it.
genus- Its genus.
family- Its family.
order- Its order.
common_names- Its common names, separated by "; ".
species_activities- Bioactivities reported for the species, separated by "; ".
genus_activities- Bioactivities reported for its genus, separated by "; ".
wfo_id- Its World Flora Online ID, where the name has been matched. Empty otherwise.
ipni_id- Its International Plant Names Index (IPNI) ID, where the name has been matched. Empty otherwise.
held_lines- How many held lines of the species the collection has.
Held lines
pccl-lines-2026-11-12.csv and pccl-lines-2026-11-12.json. One row per held line: a cell line the lab still keeps, live, in cryo, or with neither yet recorded. A line can be kept as more than one stock, on different media: the CSV gives the line one row that combines its stocks, and the JSON lists each stock with its own medium, status and growth.
line_id- PCCL's ID for the line. Never given to another line.
culture_id- The lab's Culture ID. The line's page address is the Culture ID with spaces as hyphens.
species_id- The species' ID, as in the species file.
species- The species' accepted name.
status- Live & cryopreserved, Cryopreserved, or Not recorded: live if any of its stocks is kept live, cryopreserved if any is cryopreserved.
media- The Media Codes of the media its stocks are kept on, separated by "; ". Empty where none is recorded. A medium may have no recipe in the media file yet.
growth- The highest growth rate recorded for its stocks, from 1 (slow) to 5 (fast). Empty where none is recorded.
available_to_request- true if the line can be requested.
stocks- In the JSON only: each stock the line is kept as, with its own medium (a Media Code, or null where none is recorded), status and growth, where the CSV combines them in one row.
Media recipes
pccl-media-2026-11-12.csv and pccl-media-2026-11-12.json. One row per reagent of each recipe, in the order the medium is made. Amounts are per liter of medium.
medium- The Media Code, as in the lines file and the medium's page address.
ph- The pH the medium is adjusted to.
step- When the reagent goes in. components: dissolved first, before the volume is made up to 1 L and the pH adjusted. gel: the gelling agent, added before autoclaving. vitamins: added after autoclaving, before pouring.
reagent- The reagent.
stock- The concentration of the stock solution it is added from, where it is added from one.
amount- How much to add per liter of medium, in the unit given.
unit- The unit of the amount.
vendor- The supplier the lab buys it from.
catalog_number- The supplier's catalog number.
steps- In the JSON only: the recipe's reagents under the step each goes in (components, gel, vitamins), each with its reagent, stock, amount, unit, vendor and catalog_number, as in the CSV.
Questions about the data: write to cellag@tufts.edu.