User:Lindenb/Notebook/UMR915/20100811

20100810        Top        20100812       

working on UCSC mapability: http://hgdownload.cse.ucsc.edu/goldenPath/hg18/encodeDCC/wgEncodeMapability/

CREATE TABLE `mapability` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `variation_id` int(10) unsigned NOT NULL,
 `wgEncodeBroadMapabilityAlign36mer` tinyint default NULL,
 `wgEncodeDukeUniqueness20` float default NULL,
 `wgEncodeDukeUniqueness24` float default NULL,
 `wgEncodeDukeUniqueness35` float default NULL,
 PRIMARY KEY  (`id`),
 KEY `variation_id` (`variation_id`),
 CONSTRAINT `mapability_ibfk_1` FOREIGN KEY (`variation_id`) REFERENCES `variation` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8

Table filled by Mapability2SQL.java