Evolutionary age

From CSBLwiki

Revision as of 10:07, 12 August 2010 (view source) Igchoi (Talk | contribs) (→Data set) ← Older edit		Revision as of 10:29, 12 August 2010 (view source) Igchoi (Talk | contribs) (→Evolutionary age of protein domains) Newer edit →
Line 1:		Line 1:
	==Evolutionary age of protein domains==		==Evolutionary age of protein domains==
	(Based on this reference)		(Based on this reference)
-	<pubmed>16959887</pubmed>	+	<biblio>Reference pmid=16959887</biblio>
	===Data set===		===Data set===
	*The [http://pfam.sanger.ac.uk Pfam] database		*The [http://pfam.sanger.ac.uk Pfam] database

---

Revision as of 10:29, 12 August 2010

Evolutionary age of protein domains

(Based on this reference)

1. Error fetching PMID 16959887: [Reference]

Data set

• The Pfam database
  • ftp current_release
  • User manual (the pfam format)
  • Tip: use Mysql dump <- easy to handle the content

# download total DB (estimated ~2 days)
wget -c ftp://ftp.sanger.ac.uk/pub/databases/Pfam/current_release/database.tar &

• Loading into MySQL
  • Not all DBs were imported (only a few key DBs for this study)
  • pfamseq, genome_seqs, ncbi_taxonomy, genome_species, pfamA, gene_ontology

mysql -u user -p
mysql>create DATABASE pfam24; \q
mysql -u user -p pfam < FULL_PATH/pfamseq.sql
mysql -u user -p
mysql>use pfam24
mysql>load data local infile 'pfamseq.txt' into table pfamseq FIELDS ENCLOSED BY '"';

• MySQL로 로딩시, 테이블 작성 순서대로 할것 - 에러발생 (작성하지 않은 테이블의 키인덱스 링크 관련 키워드
• Tree data
  • Silva: SSU rRNA database

Procedure

• Extract the taxonomic origins of each protein
• Get the Taxonomy info. of each origin
• Non-redundant (NR) set of taxonomic origins
• Collect all Small Subunit (SSU) rRNA sequences of the NR set
• Build the universal tree of life using SSU sequences
• Mapping the each protein belonging to a given domain into the universal tree
• Check which node is the most recent common ancestor (MRCA) node
• Calculate the branch length between MRCA and LCA (last common ancestor)