src/hg/lib/genomicSuperDups.sql 1.6
1.6 2010/02/08 19:42:34 hartera
Minor edits.
Index: src/hg/lib/genomicSuperDups.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/genomicSuperDups.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -b -B -U 1000000 -r1.5 -r1.6
--- src/hg/lib/genomicSuperDups.sql 4 Feb 2010 19:21:58 -0000 1.5
+++ src/hg/lib/genomicSuperDups.sql 8 Feb 2010 19:42:34 -0000 1.6
@@ -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 the best
strand char(1) not null, # Value should be + or -
- otherChrom varchar(255) not null, # Other Human chromosome or FPC contig
+ otherChrom varchar(255) not null, # Other chromosome or scaffold
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 (otherEnd - otherStart)
- uid int unsigned not null, # unique id shared by the query and subject of a hit
+ 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)
);