How to download the entire C. elegans genome from WormBase into Excel with automated gene descriptions
1
0
Entering edit mode
18 days ago

Hi all,

I’m looking for advice on how best to download the entire Caenorhabditis elegans genome from WormBase in a format that I can open in Excel.

Ideally, I’d like: • One row per gene • One column with the gene name/ID • Another column with Wormbase's automated short description of gene see attached example for unc-1

Does WormBase offer this kind of table directly, or would I need to process a file myself (e.g., using BioMart, WormMine, or a REST API)?

Grateful for any tips, example scripts, or direct links to preformatted downloads.

Thanks so much!

Gene Wormbase Celegans • 756 views
ADD COMMENT
2
Entering edit mode
18 days ago
GenoMax 151k

I’d like: • One row per gene • One column with the gene name/ID • Another column with Wormbase's automated short description

You can go to : https://wormbase.org/tools/mine/simplemine.cgi

Select C. elegans. Under step 3 uncheck the box that says Set All Checkboxes. Then select boxes for Public Name and Concise description (and anything else you want). Finally click on All genes in this species.

You should get a table that looks like this

wormbase

ADD COMMENT
0
Entering edit mode

This is absolutely amazing!! Thank you for such a concise and helpful answer - that's precisely what I wanted! Do you know if there's any way for me to download/save/pull out an excel/data table from this web result? Thanks!!

ADD REPLY
2
Entering edit mode

I'd just set the download results as a tab-delimited file radio button, and try to import the resulting tab-delimited file (about 8MB, no problems during import). Don't forget to change the column type from General to Text to avoid surprise conversions.

ADD REPLY
1
Entering edit mode

Ah yes. I missed that button under step 2 on the query page.

ADD REPLY
0
Entering edit mode

Perfect, thank you! Worked like a charm.

ADD REPLY

Login before adding your answer.

Traffic: 2818 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6