sequence_feature_vt Data
Data Type: sequence_feature_vt
Primary Key: id
Attributes
-
additional_metadata
(array of case insensitive strings)
- Curator or pipeline tags that don’t merit hard-coded columns (e.g. “allele_freq: 0.38”, “primer_set: ARTIC v4”). Lets BV-BRC keep provenance without schema bloat. [ "allele_freq: 0.38", "qc_status: PASS" ]
-
comments
(array of case insensitive strings)
- Observations or caveats such as “low depth at position 6”, “ambiguous insertion”. Stored one per array slot for atomic display. [ "homopolymer region prone to error" ]
-
date_inserted
(date)
- ISO-8601 UTC when the variant-tracking (VT) record was created. Enables incremental sync. "2023-07-15T11:24:02Z"
-
date_modified
(date)
- Updated whenever any field changes; clients poll for newer date_modified to refresh caches. "2025-04-20T08:55:33Z"
-
id
*
(string)
- Unique BV-BRC identifier for the VT record, usually concatenation sfvt_id or `sf_id
-
sf_category
(string)
- High-level label: SNP, insertion, deletion, peptide_motif, etc.; mirrors sequence_feature.sf_category so browsers can colour by type. "SNP"
-
sf_id
(string)
- Links the VT record back to the base definition in sequence_feature — e.g. WHO/CDC mutation catalog ID. "SF_HCoV2_D614"
-
sf_name
(case insensitive string)
- Friendly human-readable tag (e.g. “D614 (reference)”). "D614 (reference)"
-
sf_sequence
(string)
- Reference AA/NT string for the sequence feature before variation. "D"
-
sf_sequence_md5
(string)
- 32-char digest enabling fast joins and deduplication. "f1d2d2f924e986ac86fdf7b36c94bcdf"
-
sfvt_genome_count
(string)
- Stored as a string for historical reasons; drives prevalence charts. "12 845"
-
sfvt_genome_ids
(array of strings)
- List of genome_ids (public only) that contain sfvt_sequence; used to fetch exemplars quickly. [ "336082.4", "336083.4", "…" ]
-
sfvt_id
(string)
- Stable identifier for the specific variant sequence (reference + change) independent of genome context. "SFVT_HCoV2_D614G"
-
sfvt_sequence
(string)
- Altered AA/NT string actually observed (e.g. “G”). "G"
-
sfvt_sequence_md5
(string)
- Digest lets BV-BRC collapse identical variant sequences across runs. "3c59dc048e8850243be8079a5c74d079"
-
sfvt_variations
(string)
- Textual description of the difference between sf_sequence and sfvt_sequence; often HGVS (p.D614G, c.14408C>T). "p.D614G"
API
GET :id
Retrieve a sequence_feature_vt data object by id
EXAMPLE
https://www.bv-brc.org/api/sequence_feature_vt/:ID
Try It!
QUERY :query
Query for sequence_feature_vt data objects with an RQL Query
Return Formats
Requests may include an HTTP ACCEPT header from this list to transform the data into the requested type.
-
application/json - Returns results as an array of JSON objects
-
application/solr+json - Results results in SOLR JSON response format
-
text/csv - Returns results in Comma Separated values (CSV) format. Columns are separated by ','. Multi-value columns are separated by ';'. Rows are separated by new line
-
text/tsv - Returns results in Tab Separated values (TSV) format. Columns are separated by a tab. Multi-value columns are separated by ';'. Rows are separated by new line
-
application/vnd.openxmlformats - Returns objects as an MS Excel document
EXAMPLE
- Query for sequence_feature_vt data objects with a id equal to :ID. Return results as a JSON Array.
https://www.bv-brc.org/api/sequence_feature_vt/?eq(id,:ID)
Try It!