DNA Sequence

representation.scientific.dna_sequence

Deoxyribonucleic acid sequence in IUPAC notation (letters: A, T, G, C, and ambiguity codes).

Domain

representation

Try it

CLI

$ finetype infer -i "ATGCAGC"
→ representation.scientific.dna_sequence

DuckDB

Detect

SELECT finetype('ATGCAGC');
-- → 'representation.scientific.dna_sequence'

Cast expression

UPPER(CAST({col} AS VARCHAR))

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.scientific.dna_sequence';

Struct Expansion

Expression

gc_content: CAST(REGEXP_COUNT({col}, '[GC]') AS DOUBLE) / LENGTH({col})
length: LENGTH({col})

JSON Schema

finetype schema representation.scientific.dna_sequence

{
  "$id": "https://meridian.online/schemas/representation.scientific.dna_sequence",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Deoxyribonucleic acid sequence in IUPAC notation (letters: A, T, G, C, and ambiguity codes).",
  "examples": [
    "ATGCAGC",
    "GCTAGCTAGCTAG",
    "ATGATGATG"
  ],
  "pattern": "^[ATGCRYSWKMBDHVN]+$",
  "title": "DNA Sequence",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}

Examples

ATGCAGCGCTAGCTAGCTAGATGATGATG

Aliases

dna