enriched_sample_sheet¶
Info¶
Data contract for the Sample Sheet table of the dna domain of the Biocloud. Contains information about sample sheets from the lab. - name: Sample Sheet - version: 0.0.2 - status: active
Terms of Use¶
Purpose¶
Data contract for the Sample Sheet table of the dna domain of the Biocloud. Contains information about sample sheets from the lab.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: dna_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
sample_sheet¶
The sample sheet table contains information about sample sheets from the lab. These sheets document DNA extraction workflows and sample tracking information.
| Field | Type | Attributes |
|---|---|---|
| sample_sheet_id | bigint | Biocloud generated identifier for the sample sheet record. • primaryKey• primaryKeyPosition: 1 • required |
| plate_serial_number | string | Serial number of the plate used in the DNA extraction process. • examples: ['PLATE2024001', 'SN12345678'] |
| plate_be_number | string | BE number identifier for the plate. Should be the same number per sheet. |
| project_id | string | The string ID of the associated project from the source system. • examples: ['24026-5004000', '22033-375157'] |
| plate_position | string | Position of the sample on the plate (well position). Represented from a letter from A:H and a number from 01-12. • examples: ['A1', 'H12', 'D6'] |
| material_entity_source_id | string | The source system ID of the specimen/material entity. |
| material_sample_id | string | Registration number of the material sample. • examples: ['RMNH.5143366', 'RMNH.INS.123456'] |
| field_number | string | Field collection number of the specimen. |
| retry | boolean | Indicates if this is a retry of a previous DNA extraction attempt. |
| creator | string | Name of the person who entered the data in the sample sheet. |
| date_entered | timestamp | Timestamp when the row was entered in the sample sheet. |
| material_entity_type | string | Type of material entity being processed. • examples: ['specimen', 'tissue', 'environmental sample'] |
| extraction_method | string | Method used for DNA extraction. Can be either extraction of subsamples, non-destructive extraction or destructive extraction. • examples: ['extraction of subsamples', 'non-destructive extraction', 'destructive extraction'] |
| buffer_protocol | string | Buffer protocol used in the DNA extraction. |
| content | string | Description of the sample content. |
| priority | string | Priority level assigned to this sample. |
| source_id | string | The ID of this record in the source system. This can be used to track the origin of the data. • required |
| source | string | The name of the source system used to create this record in the table. • required |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |