legumeinfo / legumemine

An InterMine which contains multiple legumes
GNU Lesser General Public License v3.0
0 stars 0 forks source link

Sequence Feature Displayer on Gene pages never displays #11

Closed adf-ncgr closed 6 years ago

adf-ncgr commented 6 years ago

should it? or should it be suppressed? not sure what it should display

sammyjava commented 6 years ago

I used to suppress it but thought I'd try to figure out what's going on with it. And didn't get around to it. Not sure what it's supposed to do. May end up disabling it again if I don't get around to it in this round.

sammyjava commented 6 years ago

Here it is. The sequenceontologyterm associated with genes is getting blown away, except for 296 At genes. WTF. Merging. Will track down loader by loader.

legumemine=> select distinct sequenceontologytermid,count(*) from gene group by sequenceontologytermid;
 sequenceontologytermid | count  
------------------------+--------
                6000001 | 505240
               84000002 |  30762
               86000000 |    296
(3 rows)

legumemine=> select * from ontologyterm where id=6000001;
 identifier | description | id | obsolete | name | namespace | ontologyid | class 
------------+-------------+----+----------+------+-----------+------------+-------
(0 rows)

legumemine=> select * from ontologyterm where id=84000002;
 identifier | description | id | obsolete | name | namespace | ontologyid | class 
------------+-------------+----+----------+------+-----------+------------+-------
(0 rows)

legumemine=> select * from ontologyterm where id=86000000;
 identifier |                                                                                                    description                                                             
                                        |    id    | obsolete | name | namespace | ontologyid |             class              
------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------+----------+----------+------+-----------+------------+--------------------------------
 SO:0000704 | A region (or regions) that includes all of the sequence elements necessary to encode a functional transcript. A gene may include regulatory regions, transcribed regions an
d/or other functional sequence regions. | 86000000 | f        | gene | sequence  |    1000000 | org.intermine.model.bio.SOTerm
(1 row)
sammyjava commented 6 years ago

This is fixed by cleaning up the merges a bit. Note that Sequence Feature Displayer changes its name to "Genome feature" when it decides that it's displaying a genome feature. It's not very exciting.