7ab28d1f5d3428156b5d5831426591e9df121b08
angie
  Fri Sep 13 12:19:12 2013 -0700
New and improved Database of Genomic Variants (DGV).  It is now acomposite track as requested by the submitter, and the tables have
more columns than the older dgv tables.
The track description needs to be updated to make more clear what
DGV gets from dbVar/DGVa and what it adds.
refs #11200

diff --git src/hg/lib/dgvPlus.sql src/hg/lib/dgvPlus.sql
new file mode 100644
index 0000000..7b5414a
--- /dev/null
+++ src/hg/lib/dgvPlus.sql
@@ -0,0 +1,34 @@
+# dgvPlus.sql was originally generated by the autoSql program, which also 
+# generated dgvPlus.c and dgvPlus.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#Database of Genomic Variants incorporating dbVar, July 2013 and later
+CREATE TABLE dgvPlus (
+    bin smallint not null,      # Bin number for browser speedup
+    chrom varchar(255) not null,	# Reference sequence chromosome or scaffold
+    chromStart int unsigned not null,	# Start position in chromosome
+    chromEnd int unsigned not null,	# End position in chromosome
+    name varchar(255) not null,	# ID of merged variant or supporting variant
+    score int unsigned not null,	# Score from 0-1000 (placeholder for BED 9+ format)
+    strand char(1) not null,	# + or - (placeholder for BED 9+ format)
+    thickStart int unsigned not null,	# Same as chromStart (placeholder for BED 9+ format)
+    thickEnd int unsigned not null,	# Same as chromEnd (placeholder for BED 9+ format)
+    itemRgb int unsigned not null,	# Item R,G,B color.
+    varType varchar(255) not null,	# Type of variation
+    reference varchar(255) not null,	# Literature reference for the study that included this variant
+    pubMedId int unsigned not null,	# For linking to pubMed abstract of reference
+    method longblob not null,	# Brief description of method
+    platform longblob not null,	# Sequencing platform (if specified)
+    mergedVariants varchar(255) not null,	# If this is a supporting variant, ID of merged variant
+    supportingVariants longblob not null,	# If this is a merged variant, IDs of supporting variants
+    sampleSize int unsigned not null,	# Number of samples in study
+    observedGains int unsigned not null,	# Number of samples with copy number gains
+    observedLosses int unsigned not null,	# Number of samples with copy number losses
+    cohortDescription longblob not null,	# Description of sample population for the study
+    genes longblob not null,	# Genes overlapping this variant
+    samples longblob not null,	# Sample IDs if available
+              #Indices
+    INDEX (chrom,bin),
+    INDEX (name)
+);