User:Lindenb/Notebook/UMR915/20100813

From OpenWetWare
Revision as of 07:14, 16 August 2010 by Lindenb (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

20100812        Top        20100816       


Belgium

blasted the strange seq with insert vs NCBI blast nr+est: no signifiant result. Insert was never found in the public DB

Phastcons

Looking at the phastcons data at the UCSC (vertebrate): http://hgdownload.cse.ucsc.edu/goldenPath/hg18/phastCons44way/vertebrate/ Will create a new annotation track for our variations see PhastCons2SQL.java


 CREATE TABLE `phastCons44way` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `variation_id` int(10) unsigned NOT NULL,
 `score` float NOT NULL,
 PRIMARY KEY  (`id`),
 KEY `variation_id` (`variation_id`),
 CONSTRAINT `phastCons44way_ibfk_1` FOREIGN KEY (`variation_id`) REFERENCES `variation` (`id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8