{"action":"created","issue":{"url":"https://api.github.com/repos/geneontology/helpdesk/issues/126","repository_url":"https://api.github.com/repos/geneontology/helpdesk","labels_url":"https://api.github.com/repos/geneontology/helpdesk/issues/126/labels{/name}","comments_url":"https://api.github.com/repos/geneontology/helpdesk/issues/126/comments","events_url":"https://api.github.com/repos/geneontology/helpdesk/issues/126/events","html_url":"https://github.com/geneontology/helpdesk/issues/126","id":321859174,"node_id":"MDU6SXNzdWUzMjE4NTkxNzQ=","number":126,"title":"Help needed moving away from the MySQL database","user":{"login":"juanjoDiaz","id":3322485,"node_id":"MDQ6VXNlcjMzMjI0ODU=","avatar_url":"https://avatars0.githubusercontent.com/u/3322485?v=4","gravatar_id":"","url":"https://api.github.com/users/juanjoDiaz","html_url":"https://github.com/juanjoDiaz","followers_url":"https://api.github.com/users/juanjoDiaz/followers","following_url":"https://api.github.com/users/juanjoDiaz/following{/other_user}","gists_url":"https://api.github.com/users/juanjoDiaz/gists{/gist_id}","starred_url":"https://api.github.com/users/juanjoDiaz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanjoDiaz/subscriptions","organizations_url":"https://api.github.com/users/juanjoDiaz/orgs","repos_url":"https://api.github.com/users/juanjoDiaz/repos","events_url":"https://api.github.com/users/juanjoDiaz/events{/privacy}","received_events_url":"https://api.github.com/users/juanjoDiaz/received_events","type":"User","site_admin":false},"labels":[{"id":549902752,"node_id":"MDU6TGFiZWw1NDk5MDI3NTI=","url":"https://api.github.com/repos/geneontology/helpdesk/labels/Software","name":"Software","color":"0e8a16","default":false},{"id":549184199,"node_id":"MDU6TGFiZWw1NDkxODQxOTk=","url":"https://api.github.com/repos/geneontology/helpdesk/labels/accepted","name":"accepted","color":"1d76db","default":false}],"state":"open","locked":false,"assignee":{"login":"dougli1sqrd","id":1422171,"node_id":"MDQ6VXNlcjE0MjIxNzE=","avatar_url":"https://avatars2.githubusercontent.com/u/1422171?v=4","gravatar_id":"","url":"https://api.github.com/users/dougli1sqrd","html_url":"https://github.com/dougli1sqrd","followers_url":"https://api.github.com/users/dougli1sqrd/followers","following_url":"https://api.github.com/users/dougli1sqrd/following{/other_user}","gists_url":"https://api.github.com/users/dougli1sqrd/gists{/gist_id}","starred_url":"https://api.github.com/users/dougli1sqrd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dougli1sqrd/subscriptions","organizations_url":"https://api.github.com/users/dougli1sqrd/orgs","repos_url":"https://api.github.com/users/dougli1sqrd/repos","events_url":"https://api.github.com/users/dougli1sqrd/events{/privacy}","received_events_url":"https://api.github.com/users/dougli1sqrd/received_events","type":"User","site_admin":false},"assignees":[{"login":"dougli1sqrd","id":1422171,"node_id":"MDQ6VXNlcjE0MjIxNzE=","avatar_url":"https://avatars2.githubusercontent.com/u/1422171?v=4","gravatar_id":"","url":"https://api.github.com/users/dougli1sqrd","html_url":"https://github.com/dougli1sqrd","followers_url":"https://api.github.com/users/dougli1sqrd/followers","following_url":"https://api.github.com/users/dougli1sqrd/following{/other_user}","gists_url":"https://api.github.com/users/dougli1sqrd/gists{/gist_id}","starred_url":"https://api.github.com/users/dougli1sqrd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dougli1sqrd/subscriptions","organizations_url":"https://api.github.com/users/dougli1sqrd/orgs","repos_url":"https://api.github.com/users/dougli1sqrd/repos","events_url":"https://api.github.com/users/dougli1sqrd/events{/privacy}","received_events_url":"https://api.github.com/users/dougli1sqrd/received_events","type":"User","site_admin":false}],"milestone":null,"comments":14,"created_at":"2018-05-10T08:59:10Z","updated_at":"2018-10-31T07:49:10Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI've been using the MySQL dump of GO in the past for my Cytoscape app (http://apps.cytoscape.org/apps/gfdnet)\r\n\r\nI would like to move to the new model which I understand that is based on blazegraph or OBO files.\r\n\r\nEssentially, given a gene network, I was using GO to:\r\n\r\n- Get the list of possible genus and species so the user can select the right one for the analysis.\r\n- Match all the synonyms of a gene (in case a non-standard name is used)\r\n- Match each gene with its associated gene products (including synonyms)\r\n- Match each gene product with its associated GO terms\r\n- Construct the DAG (Tree) from the annotations of those gene products all the way to the ontology root.\r\n \r\nYou can see my DB queries in https://github.com/juanjoDiaz/gfdnet/tree/master/src/main/java/org/cytoscape/gfdnet/model/dataaccess/go\r\n\r\nAny help to port the tool to the latest available data (either Blazegraph, OBO files, or whatnot) would be really appreciated."},"comment":{"url":"https://api.github.com/repos/geneontology/helpdesk/issues/comments/434591971","html_url":"https://github.com/geneontology/helpdesk/issues/126#issuecomment-434591971","issue_url":"https://api.github.com/repos/geneontology/helpdesk/issues/126","id":434591971,"node_id":"MDEyOklzc3VlQ29tbWVudDQzNDU5MTk3MQ==","user":{"login":"juanjoDiaz","id":3322485,"node_id":"MDQ6VXNlcjMzMjI0ODU=","avatar_url":"https://avatars0.githubusercontent.com/u/3322485?v=4","gravatar_id":"","url":"https://api.github.com/users/juanjoDiaz","html_url":"https://github.com/juanjoDiaz","followers_url":"https://api.github.com/users/juanjoDiaz/followers","following_url":"https://api.github.com/users/juanjoDiaz/following{/other_user}","gists_url":"https://api.github.com/users/juanjoDiaz/gists{/gist_id}","starred_url":"https://api.github.com/users/juanjoDiaz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/juanjoDiaz/subscriptions","organizations_url":"https://api.github.com/users/juanjoDiaz/orgs","repos_url":"https://api.github.com/users/juanjoDiaz/repos","events_url":"https://api.github.com/users/juanjoDiaz/events{/privacy}","received_events_url":"https://api.github.com/users/juanjoDiaz/received_events","type":"User","site_admin":false},"created_at":"2018-10-31T07:49:10Z","updated_at":"2018-10-31T07:49:10Z","author_association":"NONE","body":"Hi @suzialeksander ,\r\n\r\nFeel free to close this tickets. hen I finally can start working on this I'll create more specific tickets as questions arise.\r\n\r\nThanks everyone for the help!"}}
{"actor":{"display_login":"juanjoDiaz"}}