RNA Sequence

representation.scientific.rna_sequence

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

Domain

representation

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