How to collate sequence data from different databases in excel ?

07 July 2016 1 8K Report

Hi there

I am analyzing SNPs from two different datasets that once collated will provide a complete picture of haplotype blocks. The issue I am facing here is there are SNPs that are found in both datasets and when I try to sort the collated file I can see duplication of these. Is there an easy way to collate the info into one row in excel like writing a code or something? Really need help from a computation biologist here!

Daniele Avancini

So, If i got it right you are trying to remove duplicates from your file.

The solution in excel can be found here :

https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

There is a specific option for removing duplicates. To be honest, a command-line approach would be the best option here.

Daniele

Badges
Science topic

Similar topics
Bioinformatics
Bioinformatics and Computational Biology

More Abbas Raza's questions See All

Testosterone or DHT deficient mice or conditional knockout available?

Hi there I've a congenic strain of mice that exhibits a phenotype dependent on testis (lost following orchiectomy) and was wondering if i can assess the contribution of Testosterone or DHT using a...

09 October 2018 2,551 2 View

Looking for some help converting genomic coordinates to genes?

Hi there I've a total of 8000 list of genomic coordinates from mouse that I want to convert to gene names, is there a software out there that can do it quickly rather than I doing them manually...

06 July 2016 4,013 6 View

Mouse SNP query: duplication of strain data?

I am looking at SNPs between different strains of mice for a particular interval. When I try to use the MGI for SNP analysis http://www.informatics.jax.org/ I find strains that have multiple data...

06 July 2016 4,133 1 View

How much Retro-orbital blood can we safely withdraw from mice?

Hi, i am planning to measure some cytokines in mouse serum at different time points in my model and was wondering if anyone has done these retro-orbital blood collection and the amount that one...

08 September 2015 7,838 3 View

What is the dihydrotestosterone dosage in mice for oral administration?

Hi there, i am looking for the appropriate dosage of DHT in C57BL/6 mice that can be given orally to compensate for gdx. I haven't found an appropriate study that has used it. If any investigator...

05 June 2015 8,424 5 View

Does anyone know about silastic tubing for implants in mice?

Hi there, i am looking for some guidelines to using silastic tubing for implanting hormones in mice. I need to provide 50ug of drug released every day. Has anyone worked with them and would be...

05 June 2015 2,511 5 View

Ubiquitin turnover controlled by?

I am looking for an explanation regarding ubiquitin-proteosome-system of protein degradation: 1. How is ubiquitin itself turned over? 2. Why proteosome don't break peptide bonds in ubiquitn when...

03 April 2015 591 0 View

How can I get around the fact that the H1R GPCR multimer upon lysate preparation gets denatured and aggregates on the SDS PAGE gel?

I am working with histamine receptor 1, a G protein couple receptor (GPCR), and when i prep my lysate for SDS page gel run I heat them up at 95C/3 min. I am getting protein aggregation in my...

02 March 2015 4,363 6 View

Has anyone come across S-myc tag rather than the conventional c-myc protein tag? Can we detect this protein tag using anti-c-myc antibodies or not?

Has anyone come across using S-myc tag rather than the conventional c-myc protein tag? I received a construct that had S-myc and I am not sure if this is the same tag as c-myc. There is no...

01 February 2015 10,129 6 View

Has anyone found double positive TCRb and TCRgd immune cells?

I was analyzing CNS cells for any infiltration of T cells in one of our disease models and found dual staining of TCRgd and TCRb, has anyone found this or maybe its an articraft? any thoughts?

01 February 2015 8,286 7 View

Can I base on reverse DNA sequences to perform alignment, convert to amino acids and GenBank submission?

I have reverse sequences (AB1 format), can I base on reverse DNA sequences to perform nucleotide alignment, convert nucleotides to amino acids and deposit the sequence in GenBank database?

11 August 2024 5,138 1 View

Which Scopus Journal provides the most affordable fees?

"PUBLISHING IN A SCOPUS JOURNAL" Researchers are now at a cross road. The critical need to publish in a Scopus or ISI, etc journal is ever vital. Journal Publication fees must be submitted....

10 August 2024 8,621 1 View

Seeking Advice on Viability and Execution of Undergraduate Thesis Topic?

Hello everyone, I am currently developing a thesis proposal and would appreciate your input on its viability and how to effectively carry it out. My proposed topic is: "Does the perceived threat...

10 August 2024 8,992 0 View

Who will be moral responsible for the death of thousands of people in the event of an earthquake?

Who will bear moral responsibility for the deaths of thousands of people in the event of an earthquake? Weeks and months remain before the onset of strong earthquakes that bring death to...

08 August 2024 6,134 12 View

How to confirm the site-directed mutagenesis result without performing NGS?

I'm cloning a fragment of 3200 nts into plasmid. The cloning was successful, however, 02 amino acids were mutated. Now I want to fix these 02 aa by site-directed mutagenesis technique using...

08 August 2024 4,645 2 View

I can't see the ssDNA band after performing asymmetric PCR. Is there any way to do this?

After performing symmetric PCR, PCR purification was performed. Afterwards, asymmetric PCR was performed using the PCR purification product as a template, but no ssDNA band was confirmed in the...

08 August 2024 1,668 3 View

Are there any instruments for studying time similar to the way it is in space?

There are a huge number of methods for studying objects in space, according to the senses (and not only). Mechanical, thermal, optical, acoustic, electrical, magnetic, based on particle beams,...

06 August 2024 7,102 0 View

Weak DAPI staining after immunohistochemistry - how to improve?

After immunohistochemistry of previously fixed in PFA and EtOH and then frozen 20 μm sections of zebrafish brain, DAPI staining is very weak (right) compared to the same sections stained without...

05 August 2024 9,637 2 View

How to convert a privately loaded document into a public document?

I attempted to make a privately uploaded text public but a window appeared that said an error occurred. There was no explanation provided as to why there was an error or what might be done to...

05 August 2024 8,025 7 View

Why did the authors extrapolate a phenotype that they experimentally proved in one bacterial strain across the whole genus of the organism?

I aim to be as skeptical as possible regarding whether a pair of orthologous genes results in the same phenotype in their different but related bacterial organisms under similar environmental...

05 August 2024 6,787 4 View