cc9815dcc544d9bfaa660557feefa1ab4364ecb6
max
  Thu Jun 19 05:45:56 2025 -0700
add triangles to clinvar tracks, add clinvar lollies to archive, add a validation to the clinvar sub lollies script, refs #35750

diff --git src/hg/utils/otto/clinvar/clinvarSub.sql src/hg/utils/otto/clinvar/clinvarSub.sql
index bb3aa5c14c0..9f3406729fe 100644
--- src/hg/utils/otto/clinvar/clinvarSub.sql
+++ src/hg/utils/otto/clinvar/clinvarSub.sql
@@ -8,18 +8,19 @@
     varId int not null,	# the identifier assigned by ClinVar and used to build the URL, namely https://ncbi.nlm.nih.gov/clinvar/VariationID
     clinSign varchar(255) not null,	# interpretation of the variation-condition relationship
     dateLastEval varchar(255) not null,	# the last date the variation-condition relationship was evaluated by this submitter
     description longblob not null,	# an optional free text description of the basis of the interpretation
     subPhenoInfo longblob not null,	# the name(s) or identifier(s)  submitted for the condition that was interpreted relative to the variant
     repPhenoInfo longblob not null,	# the MedGen identifier/name combinations ClinVar uses to report the condition that was interpreted. 'na' means there is no public identifer in MedGen for the condition.
     revStatus varchar(255) not null,	# the level of review for this submission, namely http//www.ncbi.nlm.nih.gov/clinvar/docs/variation_report/#review_status
     collMethod varchar(255) not null,	# the method by which the submitter obtained the information provided
     originCounts varchar(255) not null,	# origin and the number of observations for each origin
     submitter varchar(255) not null,	# the submitter of this record
     scv varchar(255) not null,	# the accession and current version assigned by ClinVar to the submitted interpretation of the variation-condition relationship
     subGeneSymbol varchar(255) not null,	# the gene symbol reported in this record
     explOfInterp longblob not null,	# more details if ClinicalSignificance is 'other' or 'drug response'
     somClinImpact longblob not null,    #    the somatic classification of clinical impact on this submitted record
     oncogenicity varchar(255) not null,  #  the somatic classification of oncogenicity on this submitted record
+    contrToAggrClass varchar(255) not null,  #  indicates if the SCV contributes to the aggregate classification
               #Indices
     INDEX(varId)
 );