Blast2GO 本地化

1
2

#> cat /etc/redhat-release
CentOS Linux release 7.7.1908 (Core)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

# 下载源
#> wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

# 安装源
#> rpm -ivh mysql-community-release-el7-5.noarch.rpm

# 安装
#> yum install -y mysql-server

# 查看版本信息
#> mysql -V
mysql  Ver 14.14 Distrib 5.6.49, for Linux (x86_64) using  EditLine wrapper

# 启动mysql服务
#> systemctl start mysqld

# 设定mysql root密码
#> /usr/bin/mysqladmin -u root password 'your password'

# 查看状态
#> systemctl status mysqld

# 设定开机启动
#> systemctl enable mysqld

1
2
3
4

$> java -version
openjdk version "1.8.0_242"
OpenJDK Runtime Environment (build 1.8.0_242-b08)
OpenJDK 64-Bit Server VM (build 25.242-b08, mixed mode)

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

# 创建 `gene2accession` `gene_info` `gi2uniprot` 这三个表
#> mysql -uroot -p < b2gdb.sql

# 利用 go_monthly-assocdb 创建其它的表
# `assoc_rel` `association` `association_isoform` `association_property` `association_qualifier` `association_species_qualifier` `db` `dbxref` `evidence` `evidence_dbxref` `gene_product` `gene_product_ancestor` `gene_product_count` `gene_product_dbxref` `gene_product_homology` `gene_product_homolset` `gene_product_phylotree` `gene_product_property` `gene_product_seq` `gene_product_subset` `gene_product_synonym`  `graph_path` `graph_path2term` `homolset` `instance_data` `intersection_of` `phylotree` `phylotree_property` `relation_composition``relation_properties` `seq` `seq_dbxref` `seq_property` `source_audit` `species` `term` `term2term` `term2term_metadata` `term_audit` `term_dbxref` `term_definition` `term_property` `term_subset` `term_synonym`
#> mysql -uroot -p b2g < go_monthly-assocdb-data

# 将文件 gene2accession 导入 表 `gene2accession`
#> mysql -uroot -p b2g -e"LOAD DATA LOCAL INFILE 'gene2accession' INTO TABLE gene2accession FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';"

# 导入各种id映射关系
#> java -cp .:mysql-connector-java-5.0.8-bin.jar: ImportIdMapping idmapping.tb localhost b2g blast2go blast4it

1
2
3
4
5

// GO and B2G Data Access Basic
Dbacces.dbname=b2g
Dbacces.dbhost=localhost
Dbacces.dbuser=blast2go
Dbacces.dbpasswd=blast4it