ef4a5ad1ea45eda4fde693f56f2106c553e87d93
chmalee
  Wed May 20 15:24:30 2026 -0700
Add cnv type to myVariants, refs #33808

diff --git src/hg/lib/myVariants.sql src/hg/lib/myVariants.sql
index 57406da1752..7a1b00fe722 100644
--- src/hg/lib/myVariants.sql
+++ src/hg/lib/myVariants.sql
@@ -7,22 +7,24 @@
     name varchar(255) not null,   # Name of item - up to 16 chars
     score int unsigned not null,  # 0-1000.  Higher numbers are darker.
     strand char(1) not null,      # + or - for strand
     thickStart int unsigned not null,    # Start of thick part
     thickEnd int unsigned not null,      # End position of thick part
     itemRgb int unsigned not null,   # RGB 8 bits each as in bed
     blockCount int unsigned not null,    # Number of blocks
     blockSizes longblob not null,        # Comma separated list of block sizes
     chromStarts longblob not null,       # Start positions relative to chromStart
     description longblob not null,   # Longer item description
     db varchar(255) not null,        # database name of this annotation
     ref varchar(255) not null,       # reference allele
     alt varchar(255) not null,       # alternate allele
     project varchar(255) not null,   # project name for grouping variants
     mouseover varchar(255) not null, # short mouseover text for hover display
+    itemType varchar(16) not null default 'snv',  # transcript|snv|cnv
+    cnvType varchar(32) not null default '',      # gnomAD term, empty for snv/transcript
     id int auto_increment,           # Unique ID for item
               #Indices
     PRIMARY KEY(id),
     INDEX(chrom(16),bin),
     INDEX(db),
     INDEX(project)
 ) ENGINE=InnoDB;