dereplicate sequences in count table

Question

[sankadinesh]

Dear All, I have a count table file, I want to remove sequences present more than one time and keep only representative sequence and merge counts. First column contains sequences (175 character) and subsequent columns contain their counts with regard to samples. Please check the image for example.

https://www.dropbox.com/s/6dqe1r79o52fe1s/Screenshot%202021-01-12%20at%204.31.43%20PM.png?dl=0

Note 1. All sequences are of same length (175) 2. Number of samples are variable from file to file.

Thanks to all Regards, Dinesh S L

[Ram]

Please see How to add images to a Biostars post to add your images properly - we recommend imgbb as an image hosting service, as it seems to work all over the world and doesn't need a user account to be created.

Your image seems to be screenshot of plain tabular text. See this post on how to format tabular text for pretty display as using screenshots of plain text is counterproductive.

[rpolicastro]

What do you mean when you say you want to keep only the representative sequence?