I have a list of differential genes (list1) and another list where I have the ID of the genes and the name (list2) and I want to name the genes from list1 taking the name from list2, how can I do this?
I will appreciate your support, thanks.
Diff_lgn_vs_WT=read.table("lgn_vs_WT.txt", header = TRUE, sep="\t") Diff_lgn_vs_WT<-as.data.frame(Diff_lgn_vs_WT) head(Diff_lgn_vs_WT) X baseMean log2FoldChange lfcSE stat pvalue padj 1 Zm00001eb000090 83.74241 -1.073630 0.2899722 -3.702525 0.000213464 0.001506448 2 Zm00001eb000270 45.96920 -1.141293 0.2798026 -4.078921 0.000045200 0.000404480 3 Zm00001eb000280 10.95653 -1.537141 0.5425272 -2.833298 0.004607039 0.018931911 4 Zm00001eb000370 83.58504 1.739356 0.3392983 5.126333 0.000000295 0.000005260 5 Zm00001eb000540 41.87663 -1.064135 0.3750895 -2.837017 0.004553724 0.018768199 6 Zm00001eb000740 97.93517 -1.001488 0.2542629 -3.938789 0.000081900 0.000667588
anot_MaizMine=read.csv("anot_MaizMine_limpia.csv",header = TRUE,sep=",") head(anot_MaizMine) X NAME 1 Zm00001eb000010 transcription termination factor MTERF2 2 Zm00001eb000020 E3 ubiquitin ligase complex SCF subunit 3 Zm00001eb000170 MSC domain-containing protein 4 Zm00001eb000180 Ribose-phosphate diphosphokinase 5 Zm00001eb000190 tRNA/rRNA methyltransferase (SpoU) family protein 6 Zm00001eb000200 Oleosin
Have you looked at the
If I understood correctly, you want to merge list1 and list2 by gene name. If so, make sure the gene names in both list1 and list2 are under a column that has the same name, for example, "gene_name" in both dataframes, then do:
mergeshould automatically merge the two dataframes based on the columns with the same name.
What I really want is to look up the ids (column 1) from list1 in list2 and if found, return the name of those ids according to list2. List2 has all gene ID and description (NAME) and in list1 only a small number of genes which I don't know what name they have.
In that case, check out the
Thanks so much.