Re: [Treebase-devel] number of leaves

[William P. <wil...@ya...>]

On Feb 10, 2012, at 1:05 AM, Hilmar Lapp wrote:

> Can anyone give me a quick estimate of how many tip nodes all published trees in TreeBASE amount to?




SELECT count(*) 
FROM study 
JOIN phylotree USING (study_id) 
JOIN phylotreenode USING (phylotree_id)
WHERE studystatus_id = 3
AND child_id IS NULL;

Number of tip nodes on all published trees = 480,596

SELECT count(*) FROM (
	SELECT DISTINCT ptn.name  
	FROM study 
	JOIN phylotree USING (study_id) 
	JOIN phylotreenode ptn USING (phylotree_id)
	WHERE studystatus_id = 3
	AND child_id IS NULL
) cnt;

Size of the set of all distinct taxon labels on tips of all published trees = 189,012

SELECT count(*) FROM (
	SELECT DISTINCT taxon_id  
	FROM study 
	JOIN phylotree USING (study_id) 
	JOIN phylotreenode USING (phylotree_id) 
	JOIN taxonlabel USING (taxonlabel_id)
	JOIN taxonvariant USING (taxonvariant_id) 
	WHERE studystatus_id = 3
	AND child_id IS NULL 
) cnt

Number of distinct "taxa" that map to all published trees = 83,742