Seqanswers Leaderboard Ad

Collapse

Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Select entries in Trinotate annot. report that match separate list

    Hi,

    I have a Trinotate annotation report saved as Excel CSV. The annotation report has 15 columns for every entry. There are ~700,000 entries of annotation info.

    I also have a list of Trinity transcript ID's (1 column, ~14,000 rows).

    Some of the Trinity transcript ID's in my single-column list match up to the transcript ID's in my Trinotate annotation report. I would like to extract (or remove - whatever is easier) the entries from my Trinotate annotation report, based on the column of transcript ID's, that match my separate list of Trinity transcript ID's,

    The Trinity transcript ID's are found in the second column of my Trinotate report, and the transcript ID's in the separate list are in the first and only column. I want to remove all Trinotate annotation report entries, based on "transcript_id" in column 2, that do not match my separate list of Trinity transcript ID's.

    I'm trying to filter these in Excel, but my lap top may soon catch fire as the Worksheet is too big. I'm sure a simple line of syntax using awk or sed could accomplish this, I'm just not very savvy with text processing program language yet (but I'm working on it!). Any help with this would be very appreciated! Thanks for considering my post.

    M

  • #2
    Do you have access to a linux machine? If so save the two files in plain text format from excel (tab delimited for the annotation is fine). Then you can do something like
    Code:
    grep -f file_with_ID transcript_annotation_file > transcript_annot_for_ID_you_want
    file_with_ID should list your ID's one per line.

    Comment


    • #3
      Sorry, GenoMax, I meant to specify that I wanted to run this on a linux machine.

      Seems like it'll work! Thanks so much for the help.

      M

      Comment

      Latest Articles

      Collapse

      • seqadmin
        Strategies for Sequencing Challenging Samples
        by seqadmin


        Despite advancements in sequencing platforms and related sample preparation technologies, certain sample types continue to present significant challenges that can compromise sequencing results. Pedro Echave, Senior Manager of the Global Business Segment at Revvity, explained that the success of a sequencing experiment ultimately depends on the amount and integrity of the nucleic acid template (RNA or DNA) obtained from a sample. “The better the quality of the nucleic acid isolated...
        03-22-2024, 06:39 AM
      • seqadmin
        Techniques and Challenges in Conservation Genomics
        by seqadmin



        The field of conservation genomics centers on applying genomics technologies in support of conservation efforts and the preservation of biodiversity. This article features interviews with two researchers who showcase their innovative work and highlight the current state and future of conservation genomics.

        Avian Conservation
        Matthew DeSaix, a recent doctoral graduate from Kristen Ruegg’s lab at The University of Colorado, shared that most of his research...
        03-08-2024, 10:41 AM

      ad_right_rmr

      Collapse

      News

      Collapse

      Topics Statistics Last Post
      Started by seqadmin, Yesterday, 06:37 PM
      0 responses
      12 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, Yesterday, 06:07 PM
      0 responses
      10 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 03-22-2024, 10:03 AM
      0 responses
      51 views
      0 likes
      Last Post seqadmin  
      Started by seqadmin, 03-21-2024, 07:32 AM
      0 responses
      68 views
      0 likes
      Last Post seqadmin  
      Working...
      X