Project

General

Profile

Actions

Bug #509

open

Clean up runt variants imported by PharmGKB

Added by Tom Clegg almost 14 years ago. Updated about 13 years ago.

Status:
New
Priority:
Normal
Assigned To:
Target version:
-
Story points:
-

Description

The PharmGKB importing robot has managed to create several variants that show up in reports as "CETP 1" (gene='CETP', aa_pos=1, aa_from=!_, aa_to is null), and a couple with stuff like gene='SLC1A1', aa_pos=3780412, aa_from=!_, aa_to='Ala'.

mysql> select distinct fullname from variants v
 left join edits e on v.variant_id=e.variant_id
 left join eb_users on oid=edit_oid
 where variant_aa_from=_;
+--------------------------+
| fullname                 |
+--------------------------+
| [[PharmGKB]] Importing Robot | 
+--------------------------+
1 row in set (0.10 sec)
mysql> select * from variants where variant_aa_from=_ and variant_rsid is null;
Actions #1

Updated by Ward Vandewege about 13 years ago

  • Project changed from 19 to GET-Evidence
  • Category deleted (GET-Evidence)
Actions #2

Updated by Madeleine Ball about 13 years ago

  • Priority changed from High to Normal
Actions

Also available in: Atom PDF