Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel

Jiaqi Zou, Na Li

Research output: Contribution to journalArticle

3 Citations (Scopus)

Abstract

Proper design of nucleic acid sequences is crucial for many applications. We have previously established a thermodynamics-based quantitative model to help design aptamer-based nucleic acid probes by predicting equilibrium concentrations of all interacting species. To facilitate customization of this thermodynamic model for different applications, here we present a generic and easy-to-use platform to implement the algorithm of the model with Microsoft® Excel formulas and VBA (Visual Basic for Applications) macros. Two Excel spreadsheets have been developed: one for the applications involving only nucleic acid species, the other for the applications involving both nucleic acid and non-nucleic acid species. The spreadsheets take the nucleic acid sequences and the initial concentrations of all species as input, guide the user to retrieve the necessary thermodynamic constants, and finally calculate equilibrium concentrations for all species in various bound and unbound conformations. The validity of both spreadsheets has been verified by comparing the modeling results with the experimental results on nucleic acid sequences reported in the literature. This Excel-based platform described here will allow biomedical researchers to rationalize the sequence design of nucleic acid probes using the thermodynamics-based modeling even without relevant theoretical and computational skills.

Original languageEnglish
Pages (from-to)755-762
Number of pages8
JournalComputer Methods and Programs in Biomedicine
Volume111
Issue number3
DOIs
StatePublished - Sep 1 2013

Fingerprint

Nucleic acids
Thermodynamics
Nucleic Acids
Nucleic acid sequences
Spreadsheets
Acids
Nucleic Acid Probes
Macros
Conformations
Research Personnel

Keywords

  • Equilibrium analysis
  • Excel
  • Nucleic acid probes
  • Sequence design
  • Thermodynamics

ASJC Scopus subject areas

  • Computer Science Applications
  • Software
  • Health Informatics

Cite this

Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel. / Zou, Jiaqi; Li, Na.

In: Computer Methods and Programs in Biomedicine, Vol. 111, No. 3, 01.09.2013, p. 755-762.

Research output: Contribution to journalArticle

@article{2b2a80ebc7384ee78434d65fef4c29fa,
title = "Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel",
abstract = "Proper design of nucleic acid sequences is crucial for many applications. We have previously established a thermodynamics-based quantitative model to help design aptamer-based nucleic acid probes by predicting equilibrium concentrations of all interacting species. To facilitate customization of this thermodynamic model for different applications, here we present a generic and easy-to-use platform to implement the algorithm of the model with Microsoft{\circledR} Excel formulas and VBA (Visual Basic for Applications) macros. Two Excel spreadsheets have been developed: one for the applications involving only nucleic acid species, the other for the applications involving both nucleic acid and non-nucleic acid species. The spreadsheets take the nucleic acid sequences and the initial concentrations of all species as input, guide the user to retrieve the necessary thermodynamic constants, and finally calculate equilibrium concentrations for all species in various bound and unbound conformations. The validity of both spreadsheets has been verified by comparing the modeling results with the experimental results on nucleic acid sequences reported in the literature. This Excel-based platform described here will allow biomedical researchers to rationalize the sequence design of nucleic acid probes using the thermodynamics-based modeling even without relevant theoretical and computational skills.",
keywords = "Equilibrium analysis, Excel, Nucleic acid probes, Sequence design, Thermodynamics",
author = "Jiaqi Zou and Na Li",
year = "2013",
month = "9",
day = "1",
doi = "10.1016/j.cmpb.2013.06.008",
language = "English",
volume = "111",
pages = "755--762",
journal = "Computer Methods and Programs in Biomedicine",
issn = "0169-2607",
publisher = "Elsevier Ireland Ltd",
number = "3",

}

TY - JOUR

T1 - Quantitative thermodynamic predication of interactions between nucleic acid and non-nucleic acid species using Microsoft excel

AU - Zou, Jiaqi

AU - Li, Na

PY - 2013/9/1

Y1 - 2013/9/1

N2 - Proper design of nucleic acid sequences is crucial for many applications. We have previously established a thermodynamics-based quantitative model to help design aptamer-based nucleic acid probes by predicting equilibrium concentrations of all interacting species. To facilitate customization of this thermodynamic model for different applications, here we present a generic and easy-to-use platform to implement the algorithm of the model with Microsoft® Excel formulas and VBA (Visual Basic for Applications) macros. Two Excel spreadsheets have been developed: one for the applications involving only nucleic acid species, the other for the applications involving both nucleic acid and non-nucleic acid species. The spreadsheets take the nucleic acid sequences and the initial concentrations of all species as input, guide the user to retrieve the necessary thermodynamic constants, and finally calculate equilibrium concentrations for all species in various bound and unbound conformations. The validity of both spreadsheets has been verified by comparing the modeling results with the experimental results on nucleic acid sequences reported in the literature. This Excel-based platform described here will allow biomedical researchers to rationalize the sequence design of nucleic acid probes using the thermodynamics-based modeling even without relevant theoretical and computational skills.

AB - Proper design of nucleic acid sequences is crucial for many applications. We have previously established a thermodynamics-based quantitative model to help design aptamer-based nucleic acid probes by predicting equilibrium concentrations of all interacting species. To facilitate customization of this thermodynamic model for different applications, here we present a generic and easy-to-use platform to implement the algorithm of the model with Microsoft® Excel formulas and VBA (Visual Basic for Applications) macros. Two Excel spreadsheets have been developed: one for the applications involving only nucleic acid species, the other for the applications involving both nucleic acid and non-nucleic acid species. The spreadsheets take the nucleic acid sequences and the initial concentrations of all species as input, guide the user to retrieve the necessary thermodynamic constants, and finally calculate equilibrium concentrations for all species in various bound and unbound conformations. The validity of both spreadsheets has been verified by comparing the modeling results with the experimental results on nucleic acid sequences reported in the literature. This Excel-based platform described here will allow biomedical researchers to rationalize the sequence design of nucleic acid probes using the thermodynamics-based modeling even without relevant theoretical and computational skills.

KW - Equilibrium analysis

KW - Excel

KW - Nucleic acid probes

KW - Sequence design

KW - Thermodynamics

UR - http://www.scopus.com/inward/record.url?scp=84880644942&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84880644942&partnerID=8YFLogxK

U2 - 10.1016/j.cmpb.2013.06.008

DO - 10.1016/j.cmpb.2013.06.008

M3 - Article

C2 - 23849929

AN - SCOPUS:84880644942

VL - 111

SP - 755

EP - 762

JO - Computer Methods and Programs in Biomedicine

JF - Computer Methods and Programs in Biomedicine

SN - 0169-2607

IS - 3

ER -