User:Lindenb/Notebook/UMR915/20100811

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=latin1

Table filled by Mapability2SQL.java