IDR / idr0064-goglia-erkdynamics

Metadata files for the idr0064 submission
1 stars 3 forks source link

Trailing whitespace in compound names #2

Closed will-moore closed 1 year ago

will-moore commented 2 years ago

See https://github.com/IDR/idr0094-ellinger-sarscov2/issues/14

Several of the compound names in that list have a trailing whitespace in idr0064.

Repeat of that query on idr-next, which has fixes for idr0094 and idr0088 applied, gives...

[wmoore@prod111-omeroreadwrite ~]$ /opt/omero/server/OMERO.server/bin/omero hql "select mv.value from MapAnnotation m join m.mapValue as mv where mv.value like '% ' and m.ns='openmicroscopy.org/mapr/compound'"

Created session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
 #  | Col1                                    
----+-----------------------------------------
 0  | Dovitinib Dilactic Acid                 
 1  | AG-1024                                 
 2  | CX-6258 HCl                             
 3  | Tyrphostin 9                            
 4  | EHop-016                                
 5  | PIK-75                                  
 6  | BMS-582949                              
 7  | Olmutinib                               
 8  | VX-11e                                  
 9  | PF-299804                               
 10 | 4,2,4'-Tribenzyloxy-6'-hydroxychalcone  
(11 rows)
will-moore commented 2 years ago

All apart from PIK-75, PF-299804 and 4,2,4'-Tribenzyloxy-6'-hydroxychalcone were found in annotations.csv for idr0064