Dm-roX-supplement-codes / exVisualizeR.ipynb
exVisualizeR.ipynb
Raw
library(clusterProfiler)
library(org.Dm.eg.db)
library(dplyr)
library(ggplot2)
library(VennDiagram)

plotTheme = theme(
    axis.title = element_text(family = "Arial", face = "bold", size = 16),
    legend.title = element_text(family = "Arial", face = "bold", size = 16), 
    text = element_text(family = "Arial",size = 14))

载入需要的程辑包:grid

载入需要的程辑包:futile.logger
anaGO = function(geneids,prefix){
    res = enrichGO(geneids,OrgDb = 'org.Dm.eg.db',keyType = 'ENTREZID',ont = 'ALL',readable = TRUE,maxGSSize = 300)
    if(!is.null(res)){
        write.csv(res@result,file = paste0(prefix,'_GO.csv'))
        resTable = res@result[order(res@result$p.adjust),]
        resTable = resTable %>% group_by(ONTOLOGY) %>% top_n(-p.adjust,n = 10)
        p = ggplot(data = resTable,
                   aes(
                       x = reorder(Description,-p.adjust),
                       y = -log10(p.adjust),
                       fill = ONTOLOGY,
                       label = reorder(Count,-p.adjust)
                    )
            )+
            geom_bar(stat = 'identity')+
            geom_text(stat = 'identity',hjust = 1.2)+
            coord_flip()+
            facet_grid(ONTOLOGY~.,scales = 'free',space = 'free')+
            labs(x = '',fill = '')+
            theme_classic()+
            scale_fill_manual(
                breaks = c('BP','CC','MF'),
                labels = c('BP','CC','MF'),
                values = c('#ffc64b','#66CC33','#33ccff')
            )+
            theme(strip.text = element_blank(),
                  axis.line.y = element_blank(),
                  axis.ticks.y = element_blank(),
                  axis.title.x = element_text(size = 14),
                  text = element_text(size = 12),
                  axis.text = element_text(size = 12))+plotTheme
        ggsave(filename = paste0(prefix,'_GO.png'),plot = p,dpi = 300,width = 10,height = 8,bg = 'white')
        p
    }else{
        print(paste0('No GO terms enriched in ',prefix,'!!!!'))
    }
}
pa14DEG = read.csv('pa14_DEG.csv',header = TRUE,row.names = 1)
pa14DEG
A data.frame: 10634 × 4
namespvals_adjlogfoldchangesstatus
<chr><dbl><dbl><chr>
0His3.3B 02.4733067up
1RpS18 00.4799658up
2l(2)gl 01.9522247up
3RpL9 00.3843325up
4UbcE2H 03.0332344up
5larp 02.2568846up
6Imp 01.3166707up
7Cdc42 02.4474810up
8rhea 01.8622605up
9kibra 02.0063440up
10msn 01.9221345up
11Akt1 01.8239098up
12caps 01.3298805up
13pigs 02.1110914up
14RpS16 00.2038773stable
15lncRNA:CR4286201.6077967up
16Hrb27C 00.8023477up
17kst 01.8636534up
18CHES-1-like 01.6736544up
19CG6700 02.4572175up
20Stat92E 01.4018825up
21kis 01.7723155up
22l(3)L1231 01.3570730up
23cv-c 01.0123887up
24mys 01.1617717up
25shot 01.1602663up
26Map205 01.6720357up
27Dys 01.5247252up
28lncRNA:CR3433500.5587293up
29hdc 01.0355312up
⋮⋮⋮⋮⋮
10604RpL6 0-0.5869036down
10605RpS28b 0-0.6134545down
10606RpS3A 0-0.7410227down
10607RpL18 0-0.6139038down
10608RpS20 0-0.7160333down
10609RpL13A 0-0.5750531down
10610RpS21 0-0.6162846down
10611eEF1gamma0-1.2351791down
10612RpL23 0-0.5849683down
10613RpS7 0-0.5962536down
10614RpL38 0-1.0536221down
10615RpL36 0-0.6665472down
10616RpS24 0-0.7449768down
10617RpS19a 0-1.0032190down
10618RpL30 0-1.0786418down
10619RpL18A 0-0.5842592down
10620RpS27 0-0.6730401down
10621RpL39 0-0.8620096down
10622RpL29 0-0.8505455down
10623RpS5a 0-0.8037218down
10624RpS17 0-1.1255785down
10625RpL5 0-1.8739332down
10626RpL23A 0-0.9589633down
10627RpL37A 0-0.8525162down
10628RpS13 0-0.8740362down
10629RpS25 0-0.7977920down
10630RpL24 0-0.9138611down
10631RpL11 0-1.1803279down
10632RpL40 0-1.0874639down
10633RpL22 0-2.3085504down
down = pa14DEG$names[pa14DEG$status=='down']
geneTmp = bitr(down,fromType = 'SYMBOL',toType = 'ENTREZID',OrgDb = 'org.Dm.eg.db',drop = FALSE)
numTmp = sum(is.na(geneTmp[,2]))
print(paste0(numTmp,' genes failed to map.'))
geneTmp[is.na(geneTmp[,2]),]
'select()' returned 1:1 mapping between keys and columns

Warning message in bitr(down, fromType = "SYMBOL", toType = "ENTREZID", OrgDb = "org.Dm.eg.db", :
“5.61% of input gene IDs are fail to map...”


[1] "72 genes failed to map."
A data.frame: 72 × 2
SYMBOLENTREZID
<chr><chr>
29Strumpellin NA
48Sin NA
62CG4662 NA
65CG9723 NA
73CG11453 NA
148Rcp NA
159CG5287 NA
164lncRNA:CR42875NA
165CG10880 NA
195CG16979 NA
198CG5027 NA
229CG5037 NA
235CG7009 NA
239RpI12 NA
319CG1427 NA
327CG5220 NA
352CHORD NA
355CG6388 NA
367CG10960 NA
371CG15440 NA
375CG7638 NA
376CG7206 NA
385CG2911 NA
421CG31357 NA
429CG8311 NA
438CG5734 NA
452CG10166 NA
468CG17337 NA
477l(2)37Cg NA
493CG3756 NA
⋮⋮⋮
697CG9911 NA
728CG9253 NA
755CG5599 NA
779Rpb10 NA
791CG11137 NA
794CG9577 NA
801CG7470 NA
814CG5044 NA
826CG5028 NA
845CG33977 NA
849CG17278 NA
879CG8397 NA
884CG9065 NA
886CG10103 NA
920CG3678 NA
922CG8974 NA
925CG2862 NA
982lncRNA:CR43051NA
996TMS1 NA
1042CG10932 NA
1066CG7834 NA
1069Rpb12 NA
1076CG12163 NA
1090CG6084 NA
1094CG5590 NA
1098smt3 NA
1119Eip55E NA
1135Thiolase NA
1156CtsB1 NA
1183CG7414 NA
anaGO(na.omit(geneTmp[,2]),prefix = 'pa14_down')

png

agingDEG = read.csv('aging_DEG.csv',header = TRUE,row.names = 1)
agingDown = agingDEG$names[agingDEG$status=='down']
venn.diagram(x=list(agingDown,down),category.names = c("aging Down","PA14 Down"),scaled = FALSE,alpha = 0.3,filename = "aging_PA14_Down_venn.png",imagetype = "png",resolution = "720")

1

tmp = intersect(agingDown,down)
geneTmp = bitr(tmp,fromType = 'SYMBOL',toType = 'ENTREZID',OrgDb = 'org.Dm.eg.db',drop = FALSE)
numTmp = sum(is.na(geneTmp[,2]))
print(paste0(numTmp,' genes failed to map.'))
geneTmp[is.na(geneTmp[,2]),]
'select()' returned 1:1 mapping between keys and columns

Warning message in bitr(tmp, fromType = "SYMBOL", toType = "ENTREZID", OrgDb = "org.Dm.eg.db", :
“7.76% of input gene IDs are fail to map...”


[1] "45 genes failed to map."
A data.frame: 45 × 2
SYMBOLENTREZID
<chr><chr>
14CG9723 NA
21CG4662 NA
31Rcp NA
42CG16979 NA
44CG10880 NA
71CG11453 NA
82CG5037 NA
84CG5287 NA
89CG3756 NA
103CG6388 NA
105CG9527 NA
106CHORD NA
107CG31357 NA
108CG1427 NA
157CG5734 NA
159CG10166 NA
163CG32521 NA
169CG9911 NA
175CG11781 NA
178CG5599 NA
185CG17337 NA
191l(2)37Cg NA
195Rpb8 NA
204CG8311 NA
219CG7470 NA
229CG15168 NA
231CG14184 NA
248CG10672 NA
263CG33977 NA
265CG11137 NA
279CG17278 NA
283CG10960 NA
317TMS1 NA
338CG5028 NA
367CG5044 NA
372CG9577 NA
388CG10932 NA
396Rpb12 NA
431CG5590 NA
435CtsB1 NA
443CG6084 NA
453lncRNA:CR43051NA
465Thiolase NA
473Eip55E NA
476CG7834 NA
anaGO(na.omit(geneTmp[,2]),prefix = 'aging_pa14_intersect_down')

png

tmp = intersect(agingDEG$names[agingDEG$status=='up'],pa14DEG$names[pa14DEG$status=='up'])
tmp[grep('^CG',tmp,invert = TRUE)]
  1. 'Nazo'
  2. 'Tsp42Ee'
  3. 'Jupiter'
  4. 'Nrt'
  5. 'Trx-2'
  6. 'hdly'
  7. 'pnt'
  8. 'Lmpt'
  9. 'GstD2'
  10. 'PGRP-LB'
  11. 'mnb'
  12. 'wun2'
  13. 'JhI-26'
  14. 'krimp'
  15. 'rst'
  16. 'msi'
  17. 'h'
  18. 'Lpin'
  19. 'lncRNA:CR46064'
  20. 'sna'
  21. 'Mec2'
  22. 'Ldh'
  23. 'B4'
  24. 'Fkbp14'
  25. 'cnn'
  26. 'GstS1'
  27. 'Pde6'
  28. 'wb'
  29. 'inaE'
  30. 'C1GalTA'
  31. 'Myo61F'
  32. 'Cpr51A'
  33. 'AcCoAS'
  34. 'Swip-1'
  35. 'l(3)02640'
  36. 'Shrm'
  37. 'Gk2'
  38. 'Pen'
  39. 'Dl'
  40. 'del'
  41. 'polo'
  42. 'Rgl'
  43. 'kuk'
  44. 'Rcd2'
  45. 'chn'
  46. 'dve'
  47. 'dpr21'
  48. 'Ant2'
  49. 'arr'
  50. 'fry'
  51. 'dpn'
  52. 'Tsp2A'
  53. 'Cks30A'
  54. 'Btk29A'
  55. 'GstE8'
  56. 'Marf1'
  57. 'cu'
  58. 'pdgy'
  59. 'lncRNA:CR43144'
  60. 'mbc'
  61. 'sog'
  62. 'bves'
  63. 'pch2'
  64. 'Nnf1a'
  65. 'CdGAPr'
  66. 'Kr-h1'
  67. 'msd1'
  68. 'MFS3'
  69. 'GLS'
  70. 'smp-30'
  71. 'Wnt5'
  72. 'kirre'
  73. 'E(spl)m7-HLH'
  74. 'Ntan1'
  75. 'ImpL2'
  76. 'nahoda'
  77. 'GstD5'
  78. 'lncRNA:roX2'
  79. 'Sema2b'
venn.diagram(x=list(agingDEG$names[agingDEG$status=='up'],pa14DEG$names[pa14DEG$status=='up']),category.names = c("aging Up","PA14 Up"),scaled = FALSE,alpha = 0.3,filename = "aging_PA14_Up_venn.png",imagetype = "png",resolution = "720")

1

geneTmp = bitr(tmp,fromType = 'SYMBOL',toType = 'ENTREZID',OrgDb = 'org.Dm.eg.db',drop = FALSE)
numTmp = sum(is.na(geneTmp[,2]))
print(paste0(numTmp,' genes failed to map.'))
geneTmp[is.na(geneTmp[,2]),]
anaGO(na.omit(geneTmp[,2]),prefix = 'aging_pa14_intersect_up')
'select()' returned 1:1 mapping between keys and columns

Warning message in bitr(tmp, fromType = "SYMBOL", toType = "ENTREZID", OrgDb = "org.Dm.eg.db", :
“4.79% of input gene IDs are fail to map...”


[1] "7 genes failed to map."
A data.frame: 7 × 2
SYMBOLENTREZID
<chr><chr>
3CG32368NA
7CG31324NA
50CG17265NA
65CG14906NA
67CG30456NA
90CG13704NA
104Btk29A NA

png