The project includes small codes for manipulating sequence and structural data of protein and nucleotide sequence. These code are developed for those user who do not know perl. They can directly use the code to get the output.
文 件 列 表
perlbioinfo lib doc bin .project .svn all-wcprops .svn
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000896s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.081025s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001455s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001220s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000975s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003207s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000811s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003720s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016116s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.000950s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 263021 [ RunTime:0.018306s ]
