representation.scientific.protein_sequenceAmino acid sequence in single-letter IUPAC notation (20 standard amino acids plus ambiguity codes).
$ finetype infer -i "MKVLLIVGS"
→ representation.scientific.protein_sequenceSELECT finetype('MKVLLIVGS');
-- → 'representation.scientific.protein_sequence'UPPER(CAST({col} AS VARCHAR))-- 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.protein_sequence';length: LENGTH({col})
molecular_weight_estimate: LENGTH({col}) * 110{
"$id": "https://meridian.online/schemas/representation.scientific.protein_sequence",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Amino acid sequence in single-letter IUPAC notation (20 standard amino acids plus ambiguity codes).",
"examples": [
"MKVLLIVGS",
"ACDEFGHIKLMNPQRSTVWYFL",
"MPKTAYIAKQRQISFVKSHFSRQLEERLGLIEVQAPILSRVG"
],
"pattern": "^[ACDEFGHIKLMNPQRSTVWXY*]+$",
"title": "Protein Sequence",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}MKVLLIVGSACDEFGHIKLMNPQRSTVWYFLMPKTAYIAKQRQISFVKSHFSRQLEERLGLIEVQAPILSRVG