src/hg/lib/genomicSuperDups.sql 1.5

1.5 2010/02/04 19:21:58 hartera
Changed descriptions for table columns based on feedback from data provider.
Index: src/hg/lib/genomicSuperDups.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/genomicSuperDups.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -b -B -U 4 -r1.4 -r1.5
--- src/hg/lib/genomicSuperDups.sql	2 Jun 2006 20:11:47 -0000	1.4
+++ src/hg/lib/genomicSuperDups.sql	4 Feb 2010 19:21:58 -0000	1.5
@@ -9,20 +9,20 @@
     chrom varchar(255) not null,	# Human chromosome or FPC contig
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# Other chromosome involved
-    score int unsigned not null,	# Score from 900-1000.  1000 is best
+    score int unsigned not null,	# Score from 900-1000. 1000 is the best
     strand char(1) not null,	# Value should be + or -
     otherChrom varchar(255) not null,	# Other Human chromosome or FPC contig
     otherStart int unsigned not null,	# Start in other  sequence
     otherEnd int unsigned not null,	# End in other  sequence
-    otherSize int unsigned not null,	# Total size of other sequence
-    uid int unsigned not null,	# unique id
-    posBasesHit int unsigned not null,	# HitPositive UnCovered
-    testResult varchar(255) not null,	# HitPositive (yes or no) UnCovered (covered=0)
-    verdict varchar(255) not null,	# Real or Allele
-    chits varchar(255) not null,
-    ccov varchar(255) not null,
+    otherSize int unsigned not null,	# Total size of other sequence (otherEnd - otherStart)
+    uid int unsigned not null,	# unique id shared by the query and subject of a hit
+    posBasesHit int unsigned not null,	# For future use
+    testResult varchar(255) not null,	# For future use
+    verdict varchar(255) not null,	# For future use
+    chits varchar(255) not null, 	# For future use
+    ccov varchar(255) not null,		# For future use
     alignfile varchar(255) not null,	# alignment file path
     alignL int unsigned not null,	# spaces/positions in alignment
     indelN int unsigned not null,	# number of indels
     indelS int unsigned not null,	# indel spaces