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!
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!!
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.Ah yes. I missed that button under step 2 on the query page.
Perfect, thank you! Worked like a charm.