enriched_dna_extract¶
Info¶
Data contract for the DNA Extract table of the dna domain of the Biocloud. - name: DNA Extract - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the DNA Extract table of the dna domain of the Biocloud.
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¶
dna_extract¶
The DNA extract table contains information about DNA extracts. These are samples of extracted DNA from biological specimens used in sequencing workflows.
| Field | Type | Attributes |
|---|---|---|
| dna_extract_golden_id | bigint | Biocloud generated golden identifier for the DNA extract. A Golden ID is a unique system generated identifier assigned to each record to ensure that each record is uniquely identifiable within our Data Lake. • primaryKey• primaryKeyPosition: 1 • required |
| material_entity_id | bigint | Foreign key to the material entity table, linking the DNA extract to its source specimen or material. |
| dna_extract_id | string | The string ID of the DNA extract used in the source system to identify the sample. • required• examples: ['e1100039674', 'e1100113138'] |
| catalog_number | string | Catalog number of the specimen from which the DNA was extracted, used to link to the material entity. • examples: ['RMNH.5143366', 'RMNH.5143390'] |
| stock_plate_id | string | Identifier of the stock plate containing the DNA extract sample. • examples: ['NCBN001711', 'ARISE_STOCK_001'] |
| last_updated_source | string | The name of the source system that last updated this record in the table. |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |