Genomics and Bioinformatics Group Genomics and Bioinformatics Group Genomics and Bioinformatics Group
Genomics and Bioinformatics Group

2004 Publication

Genomics and Bioinformatics Group
  Home
  Tools
  Molec Maps
  Members
  Contact
Publications
      2020
      2019
      2018
      2017
      2016
      2015
      2014
      2013
      2012
      2011
      2010
      2009
      2008
      2007
      2006
      2005
      2004
      2003
      2002
      2001
      2000
      1999
      Before 1999
      Selected
 

Mistaken Identifiers: Gene Name Errors Can Be Introduced Inadvertently When Using Excel in Bioinformatics

Barry R Zeeberg, Joseph Riss, David W Kane, Kimberly J Bussey, Edward Uchio, Marston Linehan, J. Carl Barrett and John N Weinstein

BMC Bioinformatics 2004, 5:80 doi:10.1186/1471-2105-5-80

Full text (PDF) Link to article Supplement

Abstract:

Background

When processing microarray data sets, we recently noticed that some gene names were being changed inadvertently to non-gene names.


Results

A little detective work traced the problem to default date format conversions and floating-point format conversions in the very useful Excel program package. The date conversions affect at least 30 gene names; the floating-point conversions affect at least 2,000 if Riken identifiers are included. These conversions are irreversible; the original gene names cannot be recovered.

Conclusions

Users of Excel for analyses involving gene names should be aware of this problem, which can cause genes, including medically important ones, to be lost from view and which has contaminated even carefully curated public databases. We provide work-arounds and scripts for circumventing the problem.

Some files in PDF format and require Adobe Acrobat Reader to be viewed. Click here to download.


Genomics and Pharmacology Facility
                Home Page Link to Center for Cancer Research Home Page Link to National Cancer Institute Home Page Link to National Institutes of Health Link to Department of Health & Human Services Home Page