MeridianMERIDIAN

RNA Sequence

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

RNA Sequence

representation.scientific.rna_sequence

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

Domain
representation
Category
scientific
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "AUGCAGC"
→ representation.scientific.rna_sequence

DuckDB

Detect
SELECT finetype('AUGCAGC');
-- → 'representation.scientific.rna_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.rna_sequence';

Struct Expansion

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

JSON Schema

finetype schema representation.scientific.rna_sequence
{
  "$id": "https://meridian.online/schemas/representation.scientific.rna_sequence",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Ribonucleic acid sequence in IUPAC notation (letters: A, U, G, C, and ambiguity codes).",
  "examples": [
    "AUGCAGC",
    "GCUAGCUAGCUAG",
    "AUGAUGAUG"
  ],
  "pattern": "^[AUGCRYSWKMBDHVN]+$",
  "title": "RNA Sequence",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}

Examples

AUGCAGCGCUAGCUAGCUAGAUGAUGAUG

Aliases

rna

Type Registry