Gene name errors: Lessons not learned
- PMID: 34329294
- PMCID: PMC8357140
- DOI: 10.1371/journal.pcbi.1008984
Gene name errors: Lessons not learned
Abstract
Erroneous conversion of gene names into other dates and other data types has been a frustration for computational biologists for years. We hypothesized that such errors in supplementary files might diminish after a report in 2016 highlighting the extent of the problem. To assess this, we performed a scan of supplementary files published in PubMed Central from 2014 to 2020. Overall, gene name errors continued to accumulate unabated in the period after 2016. An improved scanning software we developed identified gene name errors in 30.9% (3,436/11,117) of articles with supplementary Excel gene lists; a figure significantly higher than previously estimated. This is due to gene names being converted not just to dates and floating-point numbers, but also to internal date format (five-digit numbers). These findings further reinforce that spreadsheets are ill-suited to use with large genomic data.
Conflict of interest statement
The authors have declared that no competing interests exist.
Figures
Comment in
-
Six tips for better spreadsheets.Nature. 2022 Aug;608(7921):229-230. doi: 10.1038/d41586-022-02076-1. Nature. 2022. PMID: 35918522 No abstract available.
References
-
- Panko R. What we know about spreadsheet errors. Journal of Organizational and End User Computing. 1998;10: 15–21.
MeSH terms
LinkOut - more resources
Full Text Sources
Medical
