{"action":"opened","issue":{"url":"https://api.github.com/repos/statonlab/tripal_cv_xray/issues/27","repository_url":"https://api.github.com/repos/statonlab/tripal_cv_xray","labels_url":"https://api.github.com/repos/statonlab/tripal_cv_xray/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/statonlab/tripal_cv_xray/issues/27/comments","events_url":"https://api.github.com/repos/statonlab/tripal_cv_xray/issues/27/events","html_url":"https://github.com/statonlab/tripal_cv_xray/issues/27","id":322413169,"number":27,"title":"browser shows all entities with that term, not just those that map to anchor entity","user":{"login":"bradfordcondon","id":7063154,"avatar_url":"https://avatars2.githubusercontent.com/u/7063154?v=4","gravatar_id":"","url":"https://api.github.com/users/bradfordcondon","html_url":"https://github.com/bradfordcondon","followers_url":"https://api.github.com/users/bradfordcondon/followers","following_url":"https://api.github.com/users/bradfordcondon/following{/other_user}","gists_url":"https://api.github.com/users/bradfordcondon/gists{/gist_id}","starred_url":"https://api.github.com/users/bradfordcondon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bradfordcondon/subscriptions","organizations_url":"https://api.github.com/users/bradfordcondon/orgs","repos_url":"https://api.github.com/users/bradfordcondon/repos","events_url":"https://api.github.com/users/bradfordcondon/events{/privacy}","received_events_url":"https://api.github.com/users/bradfordcondon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-11T19:45:34Z","updated_at":"2018-05-11T19:45:34Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"http://160.36.205.61:8095/organism/Fraxinus/excelsior?tripal_pane=group_ontologies\r\n\r\nthere are 24 'sexual reproduction' records (+1 from a child term).\r\n\r\n<img width=\"684\" alt=\"screen shot 2018-05-11 at 3 42 52 pm\" src=\"https://user-images.githubusercontent.com/7063154/39943802-2fcab4ee-5532-11e8-8a15-d32ee6c395ef.png\">\r\n\r\n```\r\nselect F.uniquename FROM chado.feature F\r\nINNER JOIN chado.feature_cvterm FC ON FC.feature_id = F.feature_id\r\nINNER JOIN chado.cvterm C ON FC.cvterm_id = C.cvterm_id\r\nWHERE C.name = 'sexual reproduction';\r\n``` \r\nthis has 24 records\r\n```\r\nFRAEX38873_v2_000064050.1\r\nFRAEX38873_v2_000232540.1\r\nFRAEX38873_v2_000008220.1\r\nFRAEX38873_v2_000161920.1\r\nFRAEX38873_v2_000235380.1\r\nFRAEX38873_v2_000027030.1\r\nFRAEX38873_v2_000382030.1\r\nFRAEX38873_v2_000383640.1\r\nFRAEX38873_v2_000038400.1\r\nFRAEX38873_v2_000375130.1\r\nQlobV1.0_scaffold1599_0000090-RA\r\nQlobV1.0_scaffold1599_0000050-RA\r\nQlobV1.0_scaffold1599_0000070-RA\r\nQlobV1.0_C390613_0000010-RA\r\nQlobV1.0_C390613_0000030-RA\r\nQlobV1.0_scaffold2470_0000040-RA\r\nQlobV1.0_scaffold9085_0000050-RA\r\nQlobV1.0_scaffold9085_0000040-RA\r\nQlobV1.0_scaffold4048_0000040-RA\r\nQlobV1.0_scaffold11844_0000020-RA\r\nQlobV1.0_scaffold6219_0000030-RA\r\nQlobV1.0_scaffold5269_0000120-RA\r\nQlobV1.0_scaffold5269_0000320-RA\r\nQlobV1.0_scaffold8298_0000050-RA\r\n\r\n```\r\n\r\nSo its getting both the Q. lobata and F. excelsior results, not just F excelsior."}}
{"actor":{"display_login":"bradfordcondon"}}