利用VBA查找核酸数据库DNA保守序列

Searching conservative sequences in nuclear acid database by VBA programs

采用VBA编写了查找核酸数据库保守序列的四个相关程序,"导入DNA序列"程序可以将Fasta格式的DNA序列文本文件存放到Excel Sheet1的A列中,保留每个序列的Gi号,删除多余的注释部分;"整理DNA序列"程序可以将DNA序列Gi号存放到A列中,B列为对应Gi号的完整序列;"DNA随机序列"程序可以产生DNA随机序列;"发现DNA保守序列"程序可以将随机序列与下载的DNA序列比对,查找每一种随机序列的出现频率。以大豆基因组序列为实例,说明了这些程序的应用方法。该程序弥补了流行序列比对软件的不足,为PCR设计引物、分析基因功能以及种质资源鉴定等方面提供新的工具。

The four VBA （visual basic for application） programs were written for searching conservative sequences in nuclear acid database.The programs included importing-DNA-sequence,sorting-DNA-sequence,DNA-random-sequence and finding-DNA-conservative-sequence.The DNA sequences saved as fasta format in text file could be imported into column A of Excel Sheet1 by the program of importing-DNA-sequence,at same time,the Gi numbers were reserved and the redundant notes were deleted.Then,the Gi numbers were sorted into column A and corresponding DNA integrate sequences were arranged into column B by the program of sorting-DNA-sequence.DNA random sequences could be made by the program of DNA-random-sequence.The program of finding-DNA-conservative-sequence could help us searching conservative sequences in DNA databases by alignment with the DNA random sequences.As an example of the programs application,the conservative sequences of soybean genome survey sequences were searched.The programs were the supplementary tools of prevalent sequence alignment software,could contribute to design PCR primers,to analyze the genes function,and to identify breeding resource.