Okay, so here I go. Forewarning, I'm probably not going to explain this in the most concise and effective way, so please bear with me.
I worked with a professor to write code in R Studio that will take a list in .txt format. This list was acquired from flybase.org, and it's basically just of genes their functions. This list was used to organize sample data from a mass spec analysis. The result was what I wanted; all the data I wanted from the mass spec, was organized into nice neat columns, and the output was .xlsx file.
Now, I want to convert all the data in column H from an "FBpp" ID to the correlated "FBgn" ID, which I downloaded a .txt format list of from flybase.org as well. I would also like to add another column with the matching gene symbol, which is also found in the .txt list of IDs.
Finally, I would like to remove specific genes related to muscle tissue from the final result. The reason is that the muscle is contamination of the relevant proteins in the mass spec sample that I care about. I haven't figured out a way to compile the necessary list of muscle genes I need removed from my results as of yet, but that's a problem for another day, in another forum.
A screenshot of my original code is posted below. As a new member I can only post 1 image. Any helpful thoughts/input?
Thanks in advance.