Treefam::Family

 use Treefam::DBConnection;

 my $dbc = new Treefam::DBConnection ();

 my $famh = $dbc->get_FamilyHandle();

 my $family = $famh->get_by_id('TF101001');

 my $symbol= $family->symbol();
 my $date = $family->creation_date();
 my $desc = $family->description();

 Representation of a Treefam family.

  my $self = shift;
  $self->{'ID'} = shift if @_;
  return $self->{'ID'};

  my $self = shift;
  $self->{'ID'} = shift if @_;
  return $self->{'ID'};

  my $self = shift;
  $self->{'creation_date'} = shift if @_;
  if (!defined $self->{'creation_date'}) {
    my $familyID = $self->{'ID'};
    my $type = $self->{'type'};
    my $dbc = $self->{'DBConnection'};
    my $dbh = $dbc->{'database_handle'};
    my $sth = $dbh->prepare("SELECT created FROM $type WHERE AC = ?");
    $sth->execute($familyID);
    ($self->{'creation_date'}) = $sth->fetchrow_array();
    $sth->finish();
  }

  return $self->{'creation_date'};

  my $self = shift;
  $self->{'description'} = shift if @_;
  if (!defined $self->{'description'}) {
    my $familyID = $self->{'ID'};
    my $dbc = $self->{'DBConnection'};
    my $dbh = $dbc->{'database_handle'};
    my $sth = $dbh->prepare("SELECT f.desc FROM familyA f WHERE f.AC = ?");
    $sth->execute($familyID);
    ($self->{'description'}) = $sth->fetchrow_array();
    $sth->finish();
  }

  return $self->{'description'};

  my $self = shift;
  my $cutoff = shift if @_;
  if(!$cutoff) {
    $cutoff = 1e-2;
  }
  if (!$self->{'domains'}) {
    my $dbc = $self->{'DBConnection'};
    my $dbh = $dbc->{'database_handle'};
    my @genes = $self->get_genes;
    my %seen;
    foreach my $gene(@genes) {
      my $geneID = $gene->sequence_id;
      my $query = qq(SELECT DISTINCT PFAM_ID FROM pfam WHERE ID= ? AND EVALUE<$cutoff);
      my $sth = $dbh->prepare($query);
      $sth->execute($geneID);
      while (my ($pfamid) = $sth->fetchrow_array()) {
	push @{$self->{'domains'}},$pfamid unless $seen{$pfamid}++;
      }
    }
  }

  return @{$self->{'domains'}} if (defined($self->{'domains'}));

  my $self = shift;
  my $tree_type = shift if @_;
  my $dbc = $self->{'DBConnection'};
  my $dbh = $dbc->{'database_handle'};
  my $familyID = $self->ID;
  my @genes;
  if (!$tree_type) {
    my $family_type = $self->type eq 'familyA' ? 'famA_gene' : 'famB_gene';
    my $sth = $dbh->prepare("SELECT DISTINCT g.GID
                             FROM genes g, $family_type t1
                             WHERE t1.AC= ? AND t1.ID=g.ID");
    $sth->execute($familyID);
    while (my ($geneID) = $sth->fetchrow_array()) {
      my $gh = $dbc->get_GeneHandle;
      my $gene = $gh->get_by_id($geneID);
      push @genes,$gene;
    }
  }
  else {
    my $tree = $self->get_tree(uc($tree_type));
    @genes = $tree->get_genes;
  }
  return @genes;

  my $self = shift;
  my $type = shift if @_;
  my $tree_type = shift if @_;
  my $dbc = $self->{'DBConnection'};
  my $dbh = $dbc->{'database_handle'};
  my $familyID = $self->ID;
  my @species;
  my $taxname = lc($type) eq 'swcode' ? 'SWCODE' : 'TAXNAME';
  if (!$tree_type) {
    my $family_type = $self->type eq 'familyA' ? 'famA_gene' : 'famB_gene';
    my $sth = $dbh->prepare("SELECT DISTINCT s.$taxname
                             FROM genes g, species s, $family_type t1
                             WHERE t1.AC= ? AND t1.ID=g.ID
                             AND g.TAX_ID = s.TAX_ID");
    $sth->execute($familyID);
    while (my ($species) = $sth->fetchrow_array()) {
      push @species,$species;
    }
  }
  else {
    my $tree = $self->tree(uc($tree_type));
    @species = $tree->get_species;
  }

  return @species;

  my $self = shift;
  my $type = shift if @_;
  my $dbc = $self->{'DBConnection'};
  my $species_tree = Treefam::Tree->new($dbc,undef,'species',undef);
  @{$species_tree->{_nodes}} = ();
  my %seen;
  my @node_names = $self->get_species('latin');
  my $dbh = $dbc->{'database_handle'};
  my $query = qq(SELECT t2.name FROM spec_nodes t1 LEFT JOIN spec_nodes t2 ON t1.parent_id=t2.taxon_id WHERE t1.name=?);
  my $sth = $dbh->prepare($query);
  while (my $name = shift(@node_names)) {
    my $node;
    if ($seen{$name}) {
      $node = $seen{$name};
    }
    else {
      $node = Treefam::Node->new($dbc);
      $node->name($name);
      $node->branch_length(0.1);
      $seen{$name} = $node;
    }
    push @{$species_tree->{_nodes}},$node;
    $sth->execute($name);
    my ($n) = $sth->fetchrow_array();
    if ($n) {
      my $parent;
      if ($seen{$n}) {
	$parent = $seen{$n};
      }
      else {
	$parent = Treefam::Node->new($dbc);
	$parent->name($n);
	$parent->branch_length(0.1);
	push @node_names,$n;
	$seen{$n} = $parent;
      }
      $node->parent($parent);
      push @{$parent->{C}},$node;
    }
    else { # no parent, this is the root
      $species_tree->{_root} = $node;
    }
  }

  unless (defined($type) && (lc($type) eq 'complete' || lc($type) eq 'full')) { 
    foreach my $node (@{$species_tree->{_nodes}}) {
      # delete node if it has only 1 child,
      # child becomes child of grand-parent keeping its original distance from it
      if ($node->children && scalar($node->children)==1) {
	my ($child) = $node->children;
	my $parent = $node->parent;
	my $nodeID = $node->internalID;
	my @chldrn;
	if ($parent) {
	  foreach my $n ($parent->children) {
	    if ($n->internalID eq $nodeID) {
	      push @chldrn,$child;
	      $child->{P} = $parent;
	      weaken($child->{P});
	      undef %{$n};
	      undef $n;
	    }
	    else {
	      push @chldrn,$n;
	    }
	  }
	  $parent->children(@chldrn);
	}
      }
    }

    # remove root if it has one child
    while (scalar($species_tree->{_root}->children) ==1) {
      my ($child) = $species_tree->{_root}->children;
      $species_tree->{_root} = $child;
    }
  }
  @{$species_tree->{_nodes}} = grep { $_->internalID } @{$species_tree->{_nodes}};
  return $species_tree;

  my $self = shift;
  my $tree_type = shift || 'FULL';
  my $familyID = $self->{'ID'};
  my $dbc = $self->{'DBConnection'};
  my $th = $dbc->get_TreeHandle;
  my $tree = $th->get_by_id($familyID,$tree_type);

  return $tree;

  my ($class,$dbc,$familyID,$type) = @_;
  my $self = {};
  $self->{'DBConnection'} = $dbc;
  weaken($self->{'DBConnection'});
  my $dbh = $dbc->{'database_handle'};

  $self->{'ID'} = $familyID;
  $self->{'type'} = $type;

  bless ($self, $class);

  return $self;

  my $self = shift;
  $self->{'symbol'} = shift if @_;
  if (!defined $self->{'symbol'}) {
    my $familyID = $self->{'ID'};
    my $dbc = $self->{'DBConnection'};
    my $dbh = $dbc->{'database_handle'};
    my $sth = $dbh->prepare("SELECT symbol FROM familyA WHERE AC = ?");
    $sth->execute($familyID);
    ($self->{'symbol'}) = $sth->fetchrow_array();
    $sth->finish();
  }

  return $self->{'symbol'};

  my $self = shift;
  $self->{'type'} = shift if @_;
  return $self->{'type'};

 jkh1@sanger.ac.uk