Update Downloads Page

From DictyWiki

Jump to: navigation, search

Contents


NOW ALL AUTOMATED - THANKS TO YULIA !


Gene Information

Phenotype Annotations

Phenotype Ontology Done

* Open the latest obo file in word
* Replace ^p by <br>^p
* Add header  
<!--#set var="title" value="Dictyostelium Phenotype Ontology"-->
<!--#include virtual="/inc/header_noSide.html"-->

* Add footer: 
<p align="right">
<a href="#top">BACK TO TOP</a> - <a href="index.html">BACK TO DOWNLOADS INDEX</a>
</p><br>
<!--#include virtual="/inc/footer_noSide.html"-->


* Save as 'dicty_phenotypes.html' in Downloads folder

References Done

QUERY:
select distinct r.pubmed, d.gene_name, d.PRIMARY_FEATURE_DICTYBASEID  from reference r
join LOCUS_GENE_INFO i on r.reference_no=i.reference_no
JOIN cgm_chado.v_gene_dictybaseid d on i.locus_no = d.GENE_FEATURE_ID 
inner JOIN cgm_chado.v_gene_features l on l.feature_id = i.locus_no 
where r.pubmed is not null order by r.pubmed

* Save as DDBID_PMID.xls, .txt
* Save in data\general folder


[Back to Internal Documentation]

Personal tools