R script for Gene ID Mapping?

Hey everyone,

I have two files;

enter image description here

I want to create a new file with two columns ie. reaction ID and its corresponding Gene ID.

Is there a command similar to grep in R? if so, how can I use it in this scenario?

I would really appreciate any input/suggestions regarding this. Thank you!!

mapping r idmapping geneid

• 1,123 views • link

updated 5.2 years ago by Ram

• written 5.2 years ago by shrgur •

Please search StackOverflow or any forum online for the merge or dplyr::join functions. R does have a grep but it won't be of much use here.

You'll need to use tidyr::separate_rows on the second column of the first dataset, then dplyr::inner_join on the datasets to get your results.

0 answers

No answers yet.

More posts like this

How to do preprocessing from fastqc
written 2.2 years ago by Lulu •

Could someone provide a detailed guide on downstream preprocessing steps based on my FASTQC report? I conducted FASTQC analysis on a paired sample, and here …
nanopore data analysis methylation modification
written 2.6 years ago by Domi •

Hi all I have two sets of nanopore DNA sequencing data (experimental group and control group). Using the mCaller tool, I extracted the 6mA methylation …
how to solve the problem "Invalid character (+) in sequence"
written 3.0 years ago by alice005201314 •

When I annotated the metagenomic data with args_oap_3.2.3, the following error was reported. ![enter image description here][1] I found the contents of the line in …
DESEQ2 analysis - PCA plot
written 3.0 years ago by shome •

![enter image description here][1]![enter image description here][2] I am not getting a lot of genes from my DESEQ2 analysis hence I was checking the PCA …
original single cell data downloaded from GEO yielded only two files with 150bp
written 3.0 years ago by chenglei1865 •

Hi, Recently, I downloaded original single cell data from GEO (SRR13403717), and converted it: `fastq-dump --split-files --gzip SRR13403717`, two files `SRR13403717_1.fastq.gz` (40G) and `SRR13403717_1.fastq.gz` (38G), …
interpreting SnpEff output
written 3.6 years ago by Alireza •

Hi all. I ran GATK germline variant discovery on my WES samples. By running SnpEff on VCF files, many intron variants have been reported. ![enter …
How tp Extract SNPs values
written 4.3 years ago by Raju •

Hello I have two files MaleSNPsList.txt (in which I have a list of SNPs) and MaleSNPsValues.ped (in which I have SNPs values extracted for SNPs). …
R - Merging and aligning two CSVs using common values in multiple columns
written 4.5 years ago by Michael •

I currently have two .csv files that look like this: File 1: ![enter image description here][1] File 2: ![enter image description here][2] I would like …
How to open the genotype information in a bed file in R or Ubuntu
written 4.5 years ago by Phylicia •

My question is that how could I open a bed file and see the individual genotype? I searched the two posts previously, but they did …
Can not plot degree distribution in Cytoscape Network Analyzer on logscale
written 4.8 years ago by bhodai •

I am using Cytoscape 3.9.0. When I tried - Tools > Analyze Network, the following window poped-up ![enter image description here][1] When I clicked on …