Results and Runs

Table Overview

Name	$raw Filters	Description
`assay_result_schema`		Lists all result schemas
`result`	archived$ column is not True review_status is 'ACCEPTED' validation_status is 'VALID', 'PARTIALLY_VALID' or null	Lists all results across result schemas
`assay_run_schema`		Lists all run schemas
`bnch$unit`	archived$ column is not True	Lists all units
`bnch$unit_type`		Lists all unit types

Example Result and Run schemas are shown at the end of this page.

`assay_result_schema`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	assaysch_FM5lqwnV	Primary key for a table
schema_type	Schema type selected for schema of object	Text	assay_result	See Schema table for more information
name	Name of object in Benchling	Text	Mycoplasma Testing
system_name	Name of warehouse table for this schema	Text	mycoplasma_testing
archived$	Archival state for object in Benchling	Boolean	false, true	true = object archived
archive_purpose$	Archival reason for object in Benchling	Text	Made in Error, Retired, Other, etc	null = object not archived
parent_schema_id	Unique identifier for schema which object is derived from	Foreign key for schema.id	ts_XDQ0OW6s

`result`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	576ede31-3d78-43f1-b580-f7029a849aed
source_id	The project or registry that the object's permissions comes from	Foreign key for project.id or registry ID	src_hh9ffHqV	If an object isn't in a project, the permissions will be derived from the Registry
archived$	Archival state for object in Benchling	Boolean	false, true
archive_purpose$	Archival reason for object in Benchling	Text	Made in Error, Retired, Other, etc	null = object not archived
creator_id	Unique identifier for creator of object	Foreign key for user.id	ent_yXrL3BjX
created_at	Date created for object	Timestamp without timezone	2025-05-09T18:32:17.038287
modified_at	Date object was modified in Benchling	Timestamp without timezone	2025-05-09T18:32:17.038287
run_id	Unique identifier for Run	Foreign key for run.id	9d024eed-6038-4245-81fd-80282fbf10f6	null = result captured outside of a run
entry_id	Unique identifier for Entry	Foreign key for entry.id	etr_GtcscEZq	See Entry table for more information
entity_id	Unique identifier for Entity	Foreign key for registry_entity.id	bfi_cooUBrYb	The entity the result is mapped to
schema_id	Unique identifier for schema containing object	Foreign key for schema.id	assaysch_sIX0jz0b
validation_status	Validation status for individual result object	Text	VALID, INVALID
validation_comment	Validation comment for individual result object	Text	"Standard curve failure"
v3_id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	result_cO897erfBc6DVEsDIlNGG1	API identifier used in future versions of the Benchling API. May be `null` while in development.

`assay_run_schema`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	576ede31-3d78-43f1-b580-f7029a849aed	Primary key for a table
schema_type	Schema type selected for schema of object	Text	assay_run	See Schema table for more information
name	Name of object in Benchling	Text	Biotek Run
system_name	Name of warehouse table for this schema	Text	biotek_run
archived$	Archival state for object in Benchling	Boolean	false, true	true = object archived
archive_purpose$	Archival reason for object in Benchling	Text	Made in Error, Retired, Other, etc	null = object not archived
parent_schema_id	Unique identifier for schema which object is derived from	Foreign key for schema.id	ts_XDQ0OW6s

`bnch$unit`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	unit_J2USvfuP
archived$	Archival state for object in Benchling	Boolean	TRUE, FALSE	true = object archived
archive_purpose$	Archival reason for object in Benchling	Text	null, Made in Error, Retired, Other, etc	null = object not archived
name	Name of object in Benchling	Character Varying	microliter
symbol	Symbolic representation of the unit	Character Varying	uL
aliases	Alternative symbols for the unit	JSONB	["µL"]
unit_type_id	Unit type (mass, time, length, concentration etc)	Foreign key for unit_type.id	qnty_YKHhyKbz
conversion_factor	Multiplication factor to convert unit to base unit	Floating Point	0.000001	Multiply by 0.000001 to convert uL to L

`bnch$unit_type`

Table Row	Definition	Value Type	Example values (if applicable)
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	qnty_YKHhyKbz
name	Name of object in Benchling	Character Varying	Volume
base_unit_id	Base unit for unit type	Foreign key for unit.id	unit_UoDSVwEL

`EXAMPLE Result Schema`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc	Primary key for a table
v3_id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table		API identifier used in future versions of the Benchling API. May be `null` while in development.
source_id	The project or registry that the object's permissions comes from	Foreign key for project.id or registry ID	src_RWL0Oekn	If an object isn't in a project, the permissions will be derived from the Registry
schema	Unique Schema name for object	Text	"Fermentation Results"
created_at$	Date created for object	Timestamp without time zone	2020-06-04T00:11:56.132400
modfiied_at$	Date object was modified in Benchling	Timestamp without timezone	2019-12-08T22:34:55.174635
archived$	Whether the Run was archived	Boolean	false
archive_purpose$	Reason for why the run was archived, if archived	Character varying	null
custom$	Any custom created columns will be shown here	JSONB		Custom Columns are created after a result table has been entered into a Notebook entry
entity	The Entity an object is mapped to	Foreign key for registry_entity.id	bfi_cooUBrYb
entry_id$	Unique identifier for Entry	Foreign key for entry.id	etr_nLrUvmPx
run_id$	Unique identifier for Run	Foreign key for run ID	a11d82b2-8df3-44ae-bb2e-89086c8b69a4
creator_id	Unique identifier for creator of object	Foreign key for user.id	ent_yXrL3BjX
validation_status$	Validation status for individual result object	VALID, INVALID	VALID, INVALID
validation_comment$	Validation comment for individual result object	Text	"Standard curve failure"
field_validation$	Validation comment for each field of the Result object	JSONB	`{"timestamp":{"validation_comment": null, "validation_status": "VALID"}, "fluorescence_rfu":{"validation_comment": null, "validation_status": "VALID"}, "entity":{"validation_comment": null, "validation_status": "VALID"}}`
Speed (EXAMPLE)	Individual field of Result object	Floating Point	48.7	Value dependent on field type. See field table for more information.
Color (EXAMPLE)	Individual field of Result object	Text	"Green"	Value dependent on field type. See field table for more information.
Resistance (EXAMPLE)	Individual field of Result object	Text	["Ampicillin", "Streptomycin"]	Value dependent on field type. See field table for more information.
result_field (EXAMPLE)	Individual field of Result object	Value dependent on field type	Integer, Floating point, Text, Blob link, etc	Value dependent on field type. See field table for more information.

`EXAMPLE Run Schema`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique identifier of the Run	Character varying	ee6da040-fa64-4e47-9a5e-98892fa32580
v3_id	Unique identifier of the Run	Character varying		API identifier used in future versions of the Benchling API. May be `null` while in development.
source_id	Project that the run is in	Character varying	src_RWL0Oekn
schema	Run schema this Run is part of	Character varying	transfection_v1_schema
created_at$	When the Run was created	Timestamp without time zone	2020-06-04T00:11:56.132400
creator_id$	Who created it	Character varying	ent_naLWig4C
entry_id$	Which entry it was created in	Character varying	etr_nLrUvmPx
archived$	Whether the Run was archived	Boolean	false
archive_purpose$	Reason for why the run was archived, if archived	Character varying	null
validation_status$	Validation status	Character varying	VALID
validation_comment$	Validation information	Character varying	null
plate	Custom created columns as part of the run configuration	Character varying	plt_2Q09VfYn