src/hg/lib/genomicSuperDups.sql 1.5

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 1000000 -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
@@ -1,42 +1,42 @@
 # first.sql was originally generated by the autoSql program, which also 
 # generated first.c and first.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Summary of large genomic Duplications (>1KB >90% similar)
 CREATE TABLE genomicSuperDups (
     bin smallint not null,      # Index field
     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
     alignB int unsigned not null,	# bases Aligned
     matchB int unsigned not null,	# aligned bases that match
     mismatchB int unsigned not null,	# aligned bases that do not match
     transitionsB int unsigned not null,	# number of transitions
     transversionsB int unsigned not null,	# number of transversions
     fracMatch float not null,	# fraction of matching bases
     fracMatchIndel float not null,	# fraction of matching bases with indels
     jcK float not null,	# K-value calculated with Jukes-Cantor
     k2K float not null,	# Kimura K
               #Indices
     INDEX (name(32)),
     INDEX (chrom(8), bin),
     INDEX (chrom(8), chromStart)
 );