[InterMine Dev] bioseg lower limit of range greater than upper

Richard Smith richard at flymine.org
Wed Feb 29 12:02:29 GMT 2012


You can join on the featureid column of location with the
SequenceFeature table, which should show you the type and identifiers
of the incorrect features:

select * from location l, sequencefeature f where l.intermine_start > 
l.intermine_end and l.featureid = f.id;


Richard.



On 29/02/2012 11:21, Dr. Intikhab Alam wrote:
> Dear Richard,
>
> It shows about 127 entries of the following sort:
>
> cbrcredseamine=# select * from location where intermine_start>
> intermine_end;
>   intermine_start | intermine_end | strand |    id    | featureid |
> locatedonid |              class
> -----------------+---------------+--------+----------+-----------+---------
> ----+----------------------------------
>               802 |           801 | 1      | 62000128 |  62000127 |
> 57000933 | org.intermine.model.bio.Location
>               466 |           465 | 1      | 62000158 |  62000157 |
> 57001134 | org.intermine.model.bio.Location
>               535 |           534 | 1      | 62000190 |  62000189 |
> 57001301 | org.intermine.model.bio.Location
>
>
>
> How can I check which features are these so that I could check how these
> values went through?
>
> Thanks,
>
> Intikhab
>
>
>
>
>
> On 2/29/12 10:34 AM, "Richard Smith"<richard at flymine.org>  wrote:
>
>> select * from location where intermine_start>  intermine_end;
>
>




More information about the dev mailing list