How to - EXCEL作富集GOterm图.pdf

How to: 鐢 EXCEL 浣 GO-term 瀵岄泦缁撴灉鍥 by: nemo13 -- ver.1.0 How to: 鐢‥XCEL浣淕O-term瀵岄泦缁撴灉鍥 鏈€缁堟晥鏋滐細 鈫愮旱鍚戞晥鏋滃浘 鈫撴í鍚戞晥鏋滃浘 涓昏杩囩▼锛 鍑嗗 鏁版嵁澶勭悊 鍥捐〃 瀵煎嚭鍥剧墖 鈥㈡暟鎹 鈥 瀵煎叆 鈥㈡彃鍏ュ浘琛 鈥 涓嬭浇瀹夎 鈥㈣绠楁寚鏍囧€ 鈥㈣缃浘琛ㄦ牸寮 XL Toolbox 鈥㈡帓搴 鈥㈠鍔犲浘渚 鈥㈤€夋嫨浣滃浘鐩爣 1/ 14 How to: 鐢 EXCEL 浣 GO-term 瀵岄泦缁撴灉鍥 by: nemo13 -- ver.1.0 璇︾粏姝ラ锛 鍑嗗锛 飩 鏁版嵁锛氳繘琛孏O-term enrichment 锛 灏嗗瘜闆嗙粨鏋滅矘璐村埌EXCEL 涓 飩 杞欢锛歑L_Toolbox 锛欵XCEL 鐨勫姞杞介」锛屽彲浠ョ洿鎺ュ皢EXCEL 涓殑鍥惧鍑轰负300dpi 鐨則iff 涓嬭浇鍦板潃锛歨ttp://xltoolbox.sourceforge.net/welcome/ XL Toolbox - Download 浣跨敤璇存槑锛歨ttp://xltoolbox.sourceforge.net/scientificpublishing/ 涓嬭浇鍚庡湪鍏抽棴EXCEL 鐨勬儏鍐典笅涓€閿畨瑁呭嵆鍙紝鍚姩鍚庝細鍑虹幇鍦‥XCEL 鐨勫伐鍏锋爮涓 鏁版嵁澶勭悊锛 鍘熸暟鎹涓嬪浘锛 璁＄畻鎸囨爣鍊硷細 -ln(FDR) 肀烅雹肀掜睙饊仸饊仏肀№睊肀? 肀烅雹肀掜睙饊仸肀○€仠肀○€亷肀 鎴 enrichment score = 肀燀睊肀擆€仏肀№睊肀 /肀燀睊肀擁薄饊仠肀○€亷肀 2 / 14 How to: 鐢 EXCEL 浣 GO-term 瀵岄泦缁撴灉鍥 by: nemo13 -- ver.1.0 鎺掑簭骞堕€夋嫨鏁版嵁锛 鎸夌収 -ln(FDR) 浠庡皬鍒板ぇ鎺掑簭鍙栨瘡绫 GO-terms 鐨勫墠5 涓紝鎴栨寜鐓 enrichment-score 浠庡ぇ鍒板皬鎺掑簭鍙栨瘡绫诲墠5 涓紝绮樿创鍒版柊琛ㄦ牸涓 锛堝彲浠ュ垹闄ゅ浣欑殑鏁版嵁锛夛紝姣忎袱绫诲瀷涓棿鐣欎竴琛岀┖琛 锛堝浘鐗囨柟妗嗗锛 鍥捐〃锛 鎻掑叆鍥捐〃锛 绾靛悜锛氭彃鍏 - 鍥捐〃 - 鎻掑叆鏉″舰鍥 - 浜岀淮鏉″舰鍥 - 绨囩姸鏉″舰鍥 妯悜锛氭彃鍏 - 鍥捐〃 - 鎻掑叆鏌卞舰鍥 - 浜岀淮鏌卞舰鍥 - 绨囩姸鏌卞舰鍥 瀹屾垚鍚庝細鍑虹幇绌虹櫧鐨勫浘琛 3 / 14 How to: 鐢 EXCEL 浣 GO-term 瀵岄泦缁撴灉鍥 by: nemo13 -- ver.1.0 涓哄浘琛ㄩ€夋嫨鏁版嵁