<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
hi, I am trying ot use this method in order to get only the
variation I am interested in using phenotype as a filter:<br>
<table class="memname">
<tbody>
<tr>
<td class="memname">public Reference
Bio::EnsEMBL::Variation::DBSQL::VariationFeatureAdaptor::fetch_all_with_phenotype_by_Slice
</td>
<td>(</td>
<td class="paramname"><br>
</td>
<td>)</td>
<td><br>
</td>
</tr>
</tbody>
</table>
<pre> Arg [1] : Bio::EnsEMBL:Variation::<a class="elRef" doxygen="ensembl.tag:../core-api//" href="http://www.ensembl.org/info/docs/Doxygen/core-api/classBio_1_1EnsEMBL_1_1Slice.html">Slice</a> $slice
Arg [2] : $variation_feature_source [optional]
Arg [3] : $phenotype_source [optional]
Arg [4] : $phenotype_name [optional]
Example :</pre>
<div class="fragment">
<pre class="fragment"> my @vfs = @{$vfa->fetch_all_with_phenotype_by_Slice($slice)};
</pre>
</div>
<pre> Description: Retrieves all germline variation features associated with phenotypes for
a given slice.
The optional $variation_feature_source argument can be used to
retrieve only variation features from a paricular source.
The optional $phenotype source argument can be used to
retrieve only variation features with phenotypes provided by
a particular source.
The optional $phenotype_name argument can
be used to retrieve only variation features associated with
that phenotype - this can also be a phenotype's dbID.
Returntype : reference to list <a class="el" href="http://www.ensembl.org/info/docs/Doxygen/variation-api/classBio_1_1EnsEMBL_1_1Variation_1_1VariationFeature.html">Bio::EnsEMBL::Variation::VariationFeature</a>
Exceptions : throw on bad argument
Caller : general
Status : Stable</pre>
I have 2 questions<br>
1-I first tried to use this without any option<br>
my $vf_adaptor = Bio::EnsEMBL::Registry->get_adaptor('human',
'variation', 'variationfeature'); <br>
my @vfs =
@{$vf_adaptor->fetch_all_with_phenotype_by_Slice($human_slice)};<br>
this is the output I get, any idea?<br>
DBD::mysql::st execute failed: Unknown column 'pf.seq_region_id' in
'where clause' at
/src/ensembl-variation/modules/Bio/EnsEMBL/Variation/DBSQL/VariationFeatureAdaptor.pm
line 446, <> line 2.<br>
DBD::mysql::st execute failed: Unknown column 'pf.seq_region_id' in
'where clause' at
/src/ensembl-variation/modules/Bio/EnsEMBL/Variation/DBSQL/VariationFeatureAdaptor.pm
line 446, <> line 2.<br>
<br>
2-the optional $phenotype_name argument can be used, where can I
find a lit of all phenotype name please?<br>
<br>
Many thanks<br>
Nathalie<br>
<br>
<pre class="moz-signature" cols="72">--
</pre>
</body>
</html>