Tables, columns and units
This page lists what each SynDB table contains, the columns you can select or filter on, and the unit each column is in — or that the unit is not settled yet.
How the data is arranged
A compartment is one structural part of a neuron — its synapses, its
dendrites, its mitochondria. Each compartment is stored in one table, and
every table carries dataset_id, so a query can span datasets or stay inside
one. Which tables a dataset has is metadata, not a fixed schema: a dataset only
has rows in the compartments it was imported with.
The live schema is versioned and public:
curl https://api.syndb.xyz/v1/neurodata/schema/tables
curl https://api.syndb.xyz/v1/neurodata/schema/tables/synapses
Version 5 was serving on 2026-11-15. The column names and types below come from that endpoint; the ontology links are in Controlled vocabulary columns.
Units are per source
SynDB does not convert every measurement to one unit. Each importer keeps the convention of the source dataset it reads: FlyWire morphometry is stored in micrometres, mesh-connectomics morphometry is stored in micrometres, and MICrONS mitochondria record voxel counts. The same column name can therefore hold different units in different datasets, and an average of a geometry column across datasets is meaningless until you convert.
Two rules decide the Unit column:
- A column name that states its unit wins.
length_umis micrometres,volume_um3is cubic micrometres,diameter_nmis nanometres. - Otherwise a unit is stated only where it was verified against the
importer that writes the column. If it depends on the source, or has not
been verified, the cell says so.
unit: to be confirmedmeans exactly that: do not assume one.
Verified units by source
| Source | Column | Unit |
|---|---|---|
| FlyWire FAFB | neurons.cable_length | µm |
| FlyWire FAFB | neurons.surface_area | µm² |
| FlyWire FAFB | neurons.volume | µm³ |
| Hemibrain v1.2.1 | neurons.volume | µm³ |
| mesh-connectomics | neurons.cable_length, neurons.max_axis_length | µm |
| mesh-connectomics | neurons.surface_area, neurons.mesh_surface_area | µm² |
| mesh-connectomics | neurons.volume, neurons.mesh_volume | µm³ |
| mesh-connectomics | neurons.mesh_area_volume_ratio | µm⁻¹ |
| mesh-connectomics | neurons.centroid_x, neurons.centroid_y, neurons.centroid_z | nm |
| MICrONS mm³ (nucleus detections) | neurons.voxel_volume | µm³ (fractional nucleus volume) |
| MICrONS (Phase 1 and L2/3) | mitochondria.voxel_volume | voxel count |
| MICrONS (Phase 1 and L2/3) | mitochondria.volume_um3 | µm³ |
| MICrONS (Phase 1 and L2/3) | mitochondria.centroid_x, mitochondria.centroid_y, mitochondria.centroid_z | nm |
| Hemibrain LC (Dryad) | mitochondria.voxel_volume | voxel count |
| Hemibrain LC (Dryad) | mitochondria.volume_um3 | µm³ |
| Hemibrain LC (Dryad) | mitochondria.mesh_surface_area | µm² |
| Hemibrain LC (Dryad) | mitochondria.centroid_x, mitochondria.centroid_y, mitochondria.centroid_z | nm |
| Dryad Sager 2025 | mitochondria.volume_um3, mitochondria.mesh_volume | µm³ |
| Dryad Sager 2025 | mitochondria.mesh_surface_area | µm² |
| Dryad Sager 2025 | mitochondria.centroid_x, mitochondria.centroid_y, mitochondria.centroid_z | nm |
If a column is not in this table and its name does not state a unit, treat its
unit as unconfirmed. The per-table listings below repeat the verified cases for
the source named, and mark everything else unit: to be confirmed.
One name is misleading: voxel_volume is not always a voxel count. In MICrONS
mm³ nucleus-detection neurons it holds a fractional µm³ nucleus volume, while in
mitochondria rows it is a voxel count.
Columns shared by every table
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
metadata | text (JSON) | free-form JSON |
created_at | timestamp | timestamp (UTC) |
Tables
neurons
One row per reconstructed neuron. Measures its morphology and its chemical profile.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
name | ascii | text label |
brain_structure | ascii | text label |
polarity | ascii | text label |
cell_type | ascii | text label |
cell_class | ascii | text label |
cell_subclass | ascii | text label |
species | ascii | text label |
majority_neurotransmitter | ascii | text label |
gaba_avg | float | unit: to be confirmed |
acetylcholine_avg | float | unit: to be confirmed |
glutamate_avg | float | unit: to be confirmed |
octopamine_avg | float | unit: to be confirmed |
serine_avg | float | unit: to be confirmed |
dopamine_avg | float | unit: to be confirmed |
tyramine_avg | float | unit: to be confirmed |
betaine_avg | float | unit: to be confirmed |
cable_length | float | µm for FlyWire and mesh-connectomics; unit: to be confirmed for other sources |
is_tree | boolean | boolean |
n_branches | int | count |
n_skeletons | int | count |
n_trees | int | count |
surface_area | float | µm² for FlyWire and mesh-connectomics; unit: to be confirmed for other sources |
max_axis_length | float | µm for mesh-connectomics; unit: to be confirmed for other sources |
volume | float | µm³ for FlyWire, Hemibrain v1.2.1 and mesh-connectomics; unit: to be confirmed for other sources |
voxel_volume | float | µm³ for MICrONS mm³ (nucleus detections); unit: to be confirmed for other sources |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | µm³ for mesh-connectomics; unit: to be confirmed for other sources |
mesh_surface_area | float | µm² for mesh-connectomics; unit: to be confirmed for other sources |
mesh_area_volume_ratio | float | µm⁻¹ for mesh-connectomics; unit: to be confirmed for other sources |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | nm for mesh-connectomics; unit: to be confirmed for other sources |
centroid_y | int | nm for mesh-connectomics; unit: to be confirmed for other sources |
centroid_z | int | nm for mesh-connectomics; unit: to be confirmed for other sources |
s3_swb_location | int | internal storage handle |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
neuron_relations
One row per directed, non-synaptic neuron-to-neuron relation.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
relation_id | uuid | identifier (UUID) |
pre_neuron_id | uuid | identifier (UUID) |
post_neuron_id | uuid | identifier (UUID) |
relation_type | ascii | text label |
neurotransmitter | ascii | text label |
strength | float | unit: to be confirmed |
relation_count | int | count |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
dendrites
One row per dendritic segment or branch.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
dendrite_id | uuid | identifier (UUID) |
dendrite_type | ascii | text label |
length_um | float | µm |
spine_count | int | count |
mitochondria_count | int | count |
total_mitochondria_volume | float | unit: to be confirmed |
voxel_volume | float | unit: to be confirmed |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | unit: to be confirmed |
mesh_surface_area | float | unit: to be confirmed |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
axons
One row per axonal segment.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
axon_id | uuid | identifier (UUID) |
terminal_count | int | count |
mitochondria_count | int | count |
total_mitochondria_volume | float | unit: to be confirmed |
voxel_volume | float | unit: to be confirmed |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | unit: to be confirmed |
mesh_surface_area | float | unit: to be confirmed |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
pre_synaptic_terminals
One row per pre-synaptic terminal (bouton).
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
terminal_id | uuid | identifier (UUID) |
vesicle_count | int | count |
total_vesicle_volume | float | unit: to be confirmed |
mitochondria_count | int | count |
total_mitochondria_volume | float | unit: to be confirmed |
forms_synapse_with | uuid | identifier (UUID) |
voxel_volume | float | unit: to be confirmed |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | unit: to be confirmed |
mesh_surface_area | float | unit: to be confirmed |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
synapses
One row per synapse, or per connected neuron pair with a synapse count, depending on the dataset.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
synapse_id | uuid | identifier (UUID) |
pre_neuron_id | uuid | identifier (UUID) |
post_neuron_id | uuid | identifier (UUID) |
synapse_type | ascii | text label |
neurotransmitter | ascii | text label |
strength | float | unit: to be confirmed |
synapse_count | int | count |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
dendritic_spines
One row per dendritic spine.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
dendrite_id | uuid | identifier (UUID) |
spine_id | uuid | identifier (UUID) |
spine_type | ascii | text label |
voxel_volume | float | unit: to be confirmed |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | unit: to be confirmed |
mesh_surface_area | float | unit: to be confirmed |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
vesicles
One row per segmented synaptic vesicle.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
terminal_id | uuid | identifier (UUID) |
vesicle_id | uuid | identifier (UUID) |
neurotransmitter | ascii | text label |
diameter_nm | float | nm |
vesicle_type | ascii | text label |
docked | boolean | boolean |
distance_to_active_zone | float | unit: to be confirmed |
minimum_normal_length | float | unit: to be confirmed |
voxel_volume | float | unit: to be confirmed |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | unit: to be confirmed |
mesh_surface_area | float | unit: to be confirmed |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | unit: to be confirmed |
centroid_y | int | unit: to be confirmed |
centroid_z | int | unit: to be confirmed |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
mitochondria
One row per segmented mitochondrion.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
neuron_id | uuid | identifier (UUID) |
mitochondria_id | uuid | identifier (UUID) |
compartment | ascii | text label |
volume_um3 | float | µm³ |
voxel_volume | float | voxel count for MICrONS and Hemibrain LC; unit: to be confirmed for other sources |
voxel_radius | float | unit: to be confirmed |
s3_mesh_location | int | internal storage handle |
mesh_volume | float | µm³ for Dryad Sager 2025; unit: to be confirmed for other sources |
mesh_surface_area | float | µm² for Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources |
mesh_area_volume_ratio | float | unit: to be confirmed |
mesh_sphericity | float | unitless (0–1) |
centroid_x | int | nm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources |
centroid_y | int | nm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources |
centroid_z | int | nm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources |
parent_id | uuid | identifier (UUID) |
parent_enum | int | compartment code (1–12) |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
meshes
One row per stored 3D mesh, pointing at the file rather than holding geometry inline.
| Column | Type | Unit |
|---|---|---|
dataset_id | uuid | identifier (UUID) |
mesh_id | uuid | identifier (UUID) |
entity_type | ascii | text label |
entity_id | uuid | identifier (UUID) |
vertex_count | int | count |
face_count | int | count |
storage_uri | ascii | text (URI) |
format | ascii | text label |
metadata | text | free-form JSON |
created_at | timestamp | timestamp (UTC) |
Controlled vocabulary columns
These columns carry ontology terms. The schema endpoint returns the vocabulary URI per column, so you can join or map them without guessing what a label means.
| Column | Tables | Vocabulary |
|---|---|---|
brain_structure | neurons | UBERON (UBERON_0000955, brain) |
cell_type | neurons | Cell Ontology (CL_0000540, neuron) |
dendrite_type | dendrites | Gene Ontology (GO_0030425, dendrite) |
majority_neurotransmitter | neurons | ChEBI |
neurotransmitter | neuron_relations, synapses, vesicles | ChEBI |
polarity | neurons | Gene Ontology (GO_0098916) |
relation_type | neuron_relations | Gene Ontology (GO_0045202, synapse) |
species | neurons | NCBI Taxonomy |
spine_type | dendritic_spines | Gene Ontology (GO_0043197, dendritic spine) |
synapse_type | synapses | Gene Ontology (GO_0045202) |
vesicle_type | vesicles | Gene Ontology (GO_0099503) |
Which table do I need?
| Question | Table(s) |
|---|---|
| How many neurons does a dataset have? | neurons |
| How many synapses connect two neurons? | synapses |
| What does one neuron’s morphology look like? | neurons (whole-cell measures) or dendrites / axons (segments) |
| How big are the mitochondria? | mitochondria |
| How are vesicles distributed near the active zone? | vesicles |
| Where is the mesh file for a structure? | meshes |
Two cautions when you count:
- In some datasets one
synapsesrow is a single annotated synapse; in others it is one connected neuron pair carrying asynapse_count. The corpus endpoint reports which, per dataset, as the table’s row unit (synapse,connectionorcontact), so check it before counting rows. contactrows are membrane contact patches derived from meshes, not annotated synapses. Do not pool them with synapse annotations.