Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

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:

  1. A column name that states its unit wins. length_um is micrometres, volume_um3 is cubic micrometres, diameter_nm is nanometres.
  2. 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 confirmed means exactly that: do not assume one.

Verified units by source

SourceColumnUnit
FlyWire FAFBneurons.cable_lengthµm
FlyWire FAFBneurons.surface_areaµm²
FlyWire FAFBneurons.volumeµm³
Hemibrain v1.2.1neurons.volumeµm³
mesh-connectomicsneurons.cable_length, neurons.max_axis_lengthµm
mesh-connectomicsneurons.surface_area, neurons.mesh_surface_areaµm²
mesh-connectomicsneurons.volume, neurons.mesh_volumeµm³
mesh-connectomicsneurons.mesh_area_volume_ratioµm⁻¹
mesh-connectomicsneurons.centroid_x, neurons.centroid_y, neurons.centroid_znm
MICrONS mm³ (nucleus detections)neurons.voxel_volumeµm³ (fractional nucleus volume)
MICrONS (Phase 1 and L2/3)mitochondria.voxel_volumevoxel 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_znm
Hemibrain LC (Dryad)mitochondria.voxel_volumevoxel 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_znm
Dryad Sager 2025mitochondria.volume_um3, mitochondria.mesh_volumeµm³
Dryad Sager 2025mitochondria.mesh_surface_areaµm²
Dryad Sager 2025mitochondria.centroid_x, mitochondria.centroid_y, mitochondria.centroid_znm

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

ColumnTypeUnit
dataset_iduuididentifier (UUID)
metadatatext (JSON)free-form JSON
created_attimestamptimestamp (UTC)

Tables

neurons

One row per reconstructed neuron. Measures its morphology and its chemical profile.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
nameasciitext label
brain_structureasciitext label
polarityasciitext label
cell_typeasciitext label
cell_classasciitext label
cell_subclassasciitext label
speciesasciitext label
majority_neurotransmitterasciitext label
gaba_avgfloatunit: to be confirmed
acetylcholine_avgfloatunit: to be confirmed
glutamate_avgfloatunit: to be confirmed
octopamine_avgfloatunit: to be confirmed
serine_avgfloatunit: to be confirmed
dopamine_avgfloatunit: to be confirmed
tyramine_avgfloatunit: to be confirmed
betaine_avgfloatunit: to be confirmed
cable_lengthfloatµm for FlyWire and mesh-connectomics; unit: to be confirmed for other sources
is_treebooleanboolean
n_branchesintcount
n_skeletonsintcount
n_treesintcount
surface_areafloatµm² for FlyWire and mesh-connectomics; unit: to be confirmed for other sources
max_axis_lengthfloatµm for mesh-connectomics; unit: to be confirmed for other sources
volumefloatµm³ for FlyWire, Hemibrain v1.2.1 and mesh-connectomics; unit: to be confirmed for other sources
voxel_volumefloatµm³ for MICrONS mm³ (nucleus detections); unit: to be confirmed for other sources
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatµm³ for mesh-connectomics; unit: to be confirmed for other sources
mesh_surface_areafloatµm² for mesh-connectomics; unit: to be confirmed for other sources
mesh_area_volume_ratiofloatµm⁻¹ for mesh-connectomics; unit: to be confirmed for other sources
mesh_sphericityfloatunitless (0–1)
centroid_xintnm for mesh-connectomics; unit: to be confirmed for other sources
centroid_yintnm for mesh-connectomics; unit: to be confirmed for other sources
centroid_zintnm for mesh-connectomics; unit: to be confirmed for other sources
s3_swb_locationintinternal storage handle
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

neuron_relations

One row per directed, non-synaptic neuron-to-neuron relation.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
relation_iduuididentifier (UUID)
pre_neuron_iduuididentifier (UUID)
post_neuron_iduuididentifier (UUID)
relation_typeasciitext label
neurotransmitterasciitext label
strengthfloatunit: to be confirmed
relation_countintcount
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

dendrites

One row per dendritic segment or branch.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
dendrite_iduuididentifier (UUID)
dendrite_typeasciitext label
length_umfloatµm
spine_countintcount
mitochondria_countintcount
total_mitochondria_volumefloatunit: to be confirmed
voxel_volumefloatunit: to be confirmed
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatunit: to be confirmed
mesh_surface_areafloatunit: to be confirmed
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

axons

One row per axonal segment.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
axon_iduuididentifier (UUID)
terminal_countintcount
mitochondria_countintcount
total_mitochondria_volumefloatunit: to be confirmed
voxel_volumefloatunit: to be confirmed
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatunit: to be confirmed
mesh_surface_areafloatunit: to be confirmed
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

pre_synaptic_terminals

One row per pre-synaptic terminal (bouton).

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
terminal_iduuididentifier (UUID)
vesicle_countintcount
total_vesicle_volumefloatunit: to be confirmed
mitochondria_countintcount
total_mitochondria_volumefloatunit: to be confirmed
forms_synapse_withuuididentifier (UUID)
voxel_volumefloatunit: to be confirmed
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatunit: to be confirmed
mesh_surface_areafloatunit: to be confirmed
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

synapses

One row per synapse, or per connected neuron pair with a synapse count, depending on the dataset.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
synapse_iduuididentifier (UUID)
pre_neuron_iduuididentifier (UUID)
post_neuron_iduuididentifier (UUID)
synapse_typeasciitext label
neurotransmitterasciitext label
strengthfloatunit: to be confirmed
synapse_countintcount
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

dendritic_spines

One row per dendritic spine.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
dendrite_iduuididentifier (UUID)
spine_iduuididentifier (UUID)
spine_typeasciitext label
voxel_volumefloatunit: to be confirmed
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatunit: to be confirmed
mesh_surface_areafloatunit: to be confirmed
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

vesicles

One row per segmented synaptic vesicle.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
terminal_iduuididentifier (UUID)
vesicle_iduuididentifier (UUID)
neurotransmitterasciitext label
diameter_nmfloatnm
vesicle_typeasciitext label
dockedbooleanboolean
distance_to_active_zonefloatunit: to be confirmed
minimum_normal_lengthfloatunit: to be confirmed
voxel_volumefloatunit: to be confirmed
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatunit: to be confirmed
mesh_surface_areafloatunit: to be confirmed
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintunit: to be confirmed
centroid_yintunit: to be confirmed
centroid_zintunit: to be confirmed
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

mitochondria

One row per segmented mitochondrion.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
neuron_iduuididentifier (UUID)
mitochondria_iduuididentifier (UUID)
compartmentasciitext label
volume_um3floatµm³
voxel_volumefloatvoxel count for MICrONS and Hemibrain LC; unit: to be confirmed for other sources
voxel_radiusfloatunit: to be confirmed
s3_mesh_locationintinternal storage handle
mesh_volumefloatµm³ for Dryad Sager 2025; unit: to be confirmed for other sources
mesh_surface_areafloatµm² for Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources
mesh_area_volume_ratiofloatunit: to be confirmed
mesh_sphericityfloatunitless (0–1)
centroid_xintnm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources
centroid_yintnm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources
centroid_zintnm for MICrONS, Dryad Sager 2025 and Hemibrain LC; unit: to be confirmed for other sources
parent_iduuididentifier (UUID)
parent_enumintcompartment code (1–12)
metadatatextfree-form JSON
created_attimestamptimestamp (UTC)

meshes

One row per stored 3D mesh, pointing at the file rather than holding geometry inline.

ColumnTypeUnit
dataset_iduuididentifier (UUID)
mesh_iduuididentifier (UUID)
entity_typeasciitext label
entity_iduuididentifier (UUID)
vertex_countintcount
face_countintcount
storage_uriasciitext (URI)
formatasciitext label
metadatatextfree-form JSON
created_attimestamptimestamp (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.

ColumnTablesVocabulary
brain_structureneuronsUBERON (UBERON_0000955, brain)
cell_typeneuronsCell Ontology (CL_0000540, neuron)
dendrite_typedendritesGene Ontology (GO_0030425, dendrite)
majority_neurotransmitterneuronsChEBI
neurotransmitterneuron_relations, synapses, vesiclesChEBI
polarityneuronsGene Ontology (GO_0098916)
relation_typeneuron_relationsGene Ontology (GO_0045202, synapse)
speciesneuronsNCBI Taxonomy
spine_typedendritic_spinesGene Ontology (GO_0043197, dendritic spine)
synapse_typesynapsesGene Ontology (GO_0045202)
vesicle_typevesiclesGene Ontology (GO_0099503)

Which table do I need?

QuestionTable(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 synapses row is a single annotated synapse; in others it is one connected neuron pair carrying a synapse_count. The corpus endpoint reports which, per dataset, as the table’s row unit (synapse, connection or contact), so check it before counting rows.
  • contact rows are membrane contact patches derived from meshes, not annotated synapses. Do not pool them with synapse annotations.