Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Queries to assess use of BP-to-BP relations in Noctua models #828

Open
vanaukenk opened this issue Apr 5, 2023 · 2 comments
Open

Queries to assess use of BP-to-BP relations in Noctua models #828

vanaukenk opened this issue Apr 5, 2023 · 2 comments
Assignees

Comments

@vanaukenk
Copy link

We are working on annotation documentation for BP-to-BP relations and would like to assess the extent to which relations, other than 'part of', have been used to link BPs to BPs in Noctua.

Can we get a list of all models that contain non 'part of' relations between BPs, grouped by the relation?

@balhoff @ukemi @pgaudet @vanaukenk

@balhoff
Copy link
Member

balhoff commented Apr 14, 2023

Here's a query grouping as requested:

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX part_of: <http://purl.obolibrary.org/obo/BFO_0000050>
PREFIX BP: <http://purl.obolibrary.org/obo/GO_0008150>

SELECT (STR(MIN(?rel_label)) AS ?rel_name) (GROUP_CONCAT(DISTINCT ?cam ; separator=" | ") AS ?models)
WHERE {
  ?rel a owl:ObjectProperty .
  # This pattern selects asserted GO-CAM graphs
  ?cam <http://geneontology.org/lego/modelstate> ?state .
  GRAPH ?cam {
    ?bp1 ?rel ?bp2 .
  }
  GRAPH ?cam {
    ?bp1 rdf:type ?asserted_bp1_type .
  }
  GRAPH ?cam {
    ?bp2 rdf:type ?asserted_bp2_type .
  }
  ?asserted_bp1_type rdfs:subClassOf BP: .
  FILTER(?asserted_bp1_type != BP:)
  FILTER(?asserted_bp1_type != owl:NamedIndividual)
  ?asserted_bp2_type rdfs:subClassOf BP: .
  FILTER(?asserted_bp2_type != BP:)
  FILTER(?asserted_bp2_type != owl:NamedIndividual)
  ?rel rdfs:label ?rel_label .
  FILTER(?rel != part_of:)
  FILTER(isIRI(?bp1))
  FILTER(isIRI(?bp2))
  FILTER(isIRI(?asserted_bp1_type))
  FILTER(isIRI(?asserted_bp2_type))
}
GROUP BY ?rel

@balhoff
Copy link
Member

balhoff commented Apr 14, 2023

Table of 20 relations
rel_name models
positively regulates http://model.geneontology.org/6115be0900000695 | http://model.geneontology.org/6115be0900001004 | http://model.geneontology.org/5df932e000000833 | http://model.geneontology.org/6115be0900000553 | http://model.geneontology.org/5db9c9a500000677 | http://model.geneontology.org/613aae0000000915 | http://model.geneontology.org/5e72450500001203 | http://model.geneontology.org/5d29221b00000131 | http://model.geneontology.org/5e72450500003254 | http://model.geneontology.org/5d29221b00001310 | http://model.geneontology.org/5e72450500002742 | http://model.geneontology.org/5ae3b0f600001114 | http://model.geneontology.org/598826eb00000296 | http://model.geneontology.org/5941cdbd00000002 | http://model.geneontology.org/5900dc7400000744 | http://model.geneontology.org/586fc17a00001194 | http://model.geneontology.org/586fc17a00001637 | http://model.geneontology.org/586fc17a00000273 | http://model.geneontology.org/586fc17a00002173 | http://model.geneontology.org/586fc17a00000381 | http://model.geneontology.org/581e072c00000127 | http://model.geneontology.org/581e072c00000128 | http://model.geneontology.org/57c82fad00000451 | http://model.geneontology.org/57e48f9400000043 | http://model.geneontology.org/57c82fad00000103 | http://model.geneontology.org/57c4867e00000233 | http://model.geneontology.org/57c4867e00000002 | http://model.geneontology.org/5745387b00001750 | http://model.geneontology.org/56d1143000003195 | http://model.geneontology.org/5716c41300000464 | http://model.geneontology.org/56d1143000003178 | http://model.geneontology.org/56d1143000000189 | http://model.geneontology.org/567b544200000138 | http://model.geneontology.org/5667fdd400000077 | http://model.geneontology.org/568b0f9600000294 | http://model.geneontology.org/568b0f9600000405 | http://model.geneontology.org/5666dc6c00000621 | http://model.geneontology.org/5666dc6c00000623 | http://model.geneontology.org/5666dc6c00000417 | http://model.geneontology.org/5362b2ed00000016 | http://model.geneontology.org/5525a0fc00000003 | http://model.geneontology.org/5ce58dde00001215 | http://model.geneontology.org/60418ffa00001019 | http://model.geneontology.org/60418ffa00001337 | http://model.geneontology.org/5c4605cc00000369 | http://model.geneontology.org/5ae3b0f600000998 | http://model.geneontology.org/5ae3b0f600001037 | http://model.geneontology.org/5824c51a00000007 | http://model.geneontology.org/57c82fad00000528 | http://model.geneontology.org/57c82fad00000847 | http://model.geneontology.org/57c82fad00000868 | http://model.geneontology.org/5ae3b0f600000395 | http://model.geneontology.org/59bee34700000000 | http://model.geneontology.org/580fe05a00000102
negatively regulates http://model.geneontology.org/6115be0900001004 | http://model.geneontology.org/5f46c3b700000630 | http://model.geneontology.org/5e72450500001203 | http://model.geneontology.org/5f46c3b700003503 | http://model.geneontology.org/5e72450500003254 | http://model.geneontology.org/622aace900000298 | http://model.geneontology.org/5f46c3b700003482 | http://model.geneontology.org/5ae3b0f600000031 | http://model.geneontology.org/61f34dd300000398 | http://model.geneontology.org/595a9ee700000139 | http://model.geneontology.org/5970219a00000546 | http://model.geneontology.org/586fc17a00001637 | http://model.geneontology.org/586fc17a00000366 | http://model.geneontology.org/57c82fad00000020 | http://model.geneontology.org/57c82fad00000719 | http://model.geneontology.org/56d1143000003315 | http://model.geneontology.org/567b544200000138 | http://model.geneontology.org/568b0f9600000033 | http://model.geneontology.org/568b0f9600000405 | http://model.geneontology.org/5b528b1100000489 | http://model.geneontology.org/5ce58dde00001215 | http://model.geneontology.org/5b528b1100001416 | http://model.geneontology.org/5fce9b7300000367 | http://model.geneontology.org/59a6110e00000067 | http://model.geneontology.org/5ae3b0f600001037 | http://model.geneontology.org/57c82fad00000847 | http://model.geneontology.org/586fc17a00000705 | http://model.geneontology.org/580e952200000046 | http://model.geneontology.org/57c82fad00000868 | http://model.geneontology.org/56d1143000003824
causally upstream of or within http://model.geneontology.org/5d29221b00001471 | http://model.geneontology.org/5dd88cab00000027 | http://model.geneontology.org/5da4ff8500000350 | http://model.geneontology.org/5db9c9a500000431 | http://model.geneontology.org/5df932e000001066 | http://model.geneontology.org/5da4ff8500000030 | http://model.geneontology.org/5df932e000000920 | http://model.geneontology.org/5df932e000000000 | http://model.geneontology.org/5e72450500003294 | http://model.geneontology.org/5b91dbd100002332 | http://model.geneontology.org/5ce58dde00001749 | http://model.geneontology.org/5ce58dde00000282 | http://model.geneontology.org/5f46c3b700004144 | http://model.geneontology.org/5b91dbd100000370 | http://model.geneontology.org/5b528b1100001637 | http://model.geneontology.org/5e72450500000522 | http://model.geneontology.org/5a7e68a100001507 | http://model.geneontology.org/59bee34700000110 | http://model.geneontology.org/5993df9e00000138 | http://model.geneontology.org/59dc728000000430 | http://model.geneontology.org/59b38c1100000189 | http://model.geneontology.org/6197061700003613 | http://model.geneontology.org/593423e000000554 | http://model.geneontology.org/586fc17a00000273 | http://model.geneontology.org/586fc17a00000381 | http://model.geneontology.org/57f1b14b00000442 | http://model.geneontology.org/57c82fad00000535 | http://model.geneontology.org/57c82fad00000103 | http://model.geneontology.org/57c812be00000001 | http://model.geneontology.org/5667fdd400000077 | http://model.geneontology.org/5ee8120100001217 | http://model.geneontology.org/5e72450500002112 | http://model.geneontology.org/5df932e000000775 | http://model.geneontology.org/5df932e000000958 | http://model.geneontology.org/5df932e000000890 | http://model.geneontology.org/5dd88cab00000081 | http://model.geneontology.org/5db9c9a500000052 | http://model.geneontology.org/5d29221b00002905 | http://model.geneontology.org/5da4ff8500000377 | http://model.geneontology.org/5e72450500000328 | http://model.geneontology.org/5c4605cc00003149 | http://model.geneontology.org/600ced8500001182 | http://model.geneontology.org/5c4605cc00002514 | http://model.geneontology.org/5b528b1100001416 | http://model.geneontology.org/5f46c3b700004207 | http://model.geneontology.org/59c8885900000227 | http://model.geneontology.org/5b528b1100000965 | http://model.geneontology.org/5a7e68a100000157 | http://model.geneontology.org/5ee8120100003623 | http://model.geneontology.org/5745387b00001665 | http://model.geneontology.org/5ee8120100002184 | http://model.geneontology.org/5745387b00001770 | http://model.geneontology.org/5b91dbd100000025 | http://model.geneontology.org/586fc17a00001826 | http://model.geneontology.org/5ae3b0f600001186 | http://model.geneontology.org/580fe05a00000102
causally upstream of, positive effect http://model.geneontology.org/5df932e000000833 | http://model.geneontology.org/5c4605cc00002573 | http://model.geneontology.org/5f46c3b700000630 | http://model.geneontology.org/5b318d0900000838 | http://model.geneontology.org/5fadbcf000000317 | http://model.geneontology.org/5f46c3b700003482 | http://model.geneontology.org/5ae3b0f600000083 | http://model.geneontology.org/5ae3b0f600001114 | http://model.geneontology.org/59c8885900000169 | http://model.geneontology.org/5b528b1100000489 | http://model.geneontology.org/5ee8120100000040 | http://model.geneontology.org/5ee8120100000250 | http://model.geneontology.org/5e72450500001740 | http://model.geneontology.org/5e72450500000789 | http://model.geneontology.org/5d29221b00001552 | http://model.geneontology.org/5ce58dde00000811 | http://model.geneontology.org/5b91dbd100000574 | http://model.geneontology.org/5b528b1100001416 | http://model.geneontology.org/5b91dbd100001325 | http://model.geneontology.org/5fce9b7300000409 | http://model.geneontology.org/5b528b1100000023 | http://model.geneontology.org/5a5fc23a00000137 | http://model.geneontology.org/59dc728000000555 | http://model.geneontology.org/5ee8120100001898 | http://model.geneontology.org/5993df9e00000254
causally upstream of http://model.geneontology.org/5f46c3b700000893 | http://model.geneontology.org/5f46c3b700000586 | http://model.geneontology.org/5ce58dde00001062 | http://model.geneontology.org/5e72450500002742 | http://model.geneontology.org/5c4605cc00000939 | http://model.geneontology.org/5c4605cc00000432 | http://model.geneontology.org/5d29221b00000268 | http://model.geneontology.org/5e72450500003254 | http://model.geneontology.org/5df932e000002299 | http://model.geneontology.org/61e0e55600000120 | http://model.geneontology.org/598826eb00000296 | http://model.geneontology.org/5941cdbd00000221 | http://model.geneontology.org/593423e000001008 | http://model.geneontology.org/5941cdbd00000169 | http://model.geneontology.org/5941cdbd00000134 | http://model.geneontology.org/5970219a00000537 | http://model.geneontology.org/6197061700003613 | http://model.geneontology.org/5900dc7400000568 | http://model.geneontology.org/586fc17a00000206 | http://model.geneontology.org/593423e000000001 | http://model.geneontology.org/586fc17a00000381 | http://model.geneontology.org/586fc17a00000033 | http://model.geneontology.org/583f430000000096 | http://model.geneontology.org/580fe05a00000029 | http://model.geneontology.org/57f1b14b00000492 | http://model.geneontology.org/57ea2dae00000114 | http://model.geneontology.org/57c82fad00000451 | http://model.geneontology.org/57c4867e00000426 | http://model.geneontology.org/5745387b00001783 | http://model.geneontology.org/57c4867e00000835 | http://model.geneontology.org/57c4867e00000244 | http://model.geneontology.org/57c4867e00000002 | http://model.geneontology.org/5716c41300000192 | http://model.geneontology.org/5745387b00000453 | http://model.geneontology.org/5745387b00000052 | http://model.geneontology.org/56d1143000003284 | http://model.geneontology.org/56d1143000003353 | http://model.geneontology.org/56d1143000003178 | http://model.geneontology.org/56d1143000000189 | http://model.geneontology.org/56cbaef000000079 | http://model.geneontology.org/5667fdd400000077 | http://model.geneontology.org/56aac7ad00000236 | http://model.geneontology.org/56aac7ad00000029 | http://model.geneontology.org/5662325600000049 | http://model.geneontology.org/56d1143000000072 | http://model.geneontology.org/56aac7ad00000206 | http://model.geneontology.org/56170d5200000012 | http://model.geneontology.org/5362b2ed00000016 | http://model.geneontology.org/5e72450500004119 | http://model.geneontology.org/5e72450500005307 | http://model.geneontology.org/5e72450500004237 | http://model.geneontology.org/5e72450500001073 | http://model.geneontology.org/5e72450500000067 | http://model.geneontology.org/60ff660000000298 | http://model.geneontology.org/5db9c9a500000104 | http://model.geneontology.org/5d29221b00001723 | http://model.geneontology.org/60418ffa00002199 | http://model.geneontology.org/60418ffa00001019 | http://model.geneontology.org/5ce58dde00001596 | http://model.geneontology.org/5c4605cc00003149 | http://model.geneontology.org/5c4605cc00002140 | http://model.geneontology.org/61e0e55600000565 | http://model.geneontology.org/5b91dbd100001176 | http://model.geneontology.org/5b91dbd100000738 | http://model.geneontology.org/5fce9b7300000451 | http://model.geneontology.org/5b91dbd100001325 | http://model.geneontology.org/5966411600000170 | http://model.geneontology.org/5824c51a00000007 | http://model.geneontology.org/5825564b00000099 | http://model.geneontology.org/57c82fad00000403 | http://model.geneontology.org/57c82fad00000847 | http://model.geneontology.org/57ea2dae00000004 | http://model.geneontology.org/5ae3b0f600001600 | http://model.geneontology.org/5ee8120100001898 | http://model.geneontology.org/5745387b00001459 | http://model.geneontology.org/57c82fad00000868 | http://model.geneontology.org/586fc17a00000729 | http://model.geneontology.org/56aac7ad00000079 | http://model.geneontology.org/5716c41300000127 | http://model.geneontology.org/5fa76ad400000125 | http://model.geneontology.org/5c4605cc00002828 | http://model.geneontology.org/586fc17a00002056 | http://model.geneontology.org/59bee34700000000 | http://model.geneontology.org/5c4605cc00002729 | http://model.geneontology.org/580fe05a00000102 | http://model.geneontology.org/5900dc7400000468 | http://model.geneontology.org/56170d5200000093 | http://model.geneontology.org/598826eb00000503
regulates http://model.geneontology.org/613aae0000000915 | http://model.geneontology.org/5f46c3b700000610 | http://model.geneontology.org/5c4605cc00000396 | http://model.geneontology.org/59c8885900000169 | http://model.geneontology.org/59dc728000000445 | http://model.geneontology.org/59cde02c00000053 | http://model.geneontology.org/586fc17a00001194 | http://model.geneontology.org/586fc17a00001477 | http://model.geneontology.org/5745387b00001783 | http://model.geneontology.org/56d1143000003223 | http://model.geneontology.org/56d1143000000320 | http://model.geneontology.org/5666dc6c00000623 | http://model.geneontology.org/5666dc6c00000417 | http://model.geneontology.org/5ce58dde00000811 | http://model.geneontology.org/5fce9b7300001439 | http://model.geneontology.org/57c82fad00000847 | http://model.geneontology.org/57c82fad00000868 | http://model.geneontology.org/59b38c1100000041 | http://model.geneontology.org/586fc17a00001826 | http://model.geneontology.org/5993df9e00000254
causally upstream of, negative effect http://model.geneontology.org/5d29221b00002451 | http://model.geneontology.org/5fadbcf000000317 | http://model.geneontology.org/5ce58dde00002120 | http://model.geneontology.org/5fce9b7300001742 | http://model.geneontology.org/5b91dbd100001104 | http://model.geneontology.org/5b528b1100000451
causally upstream of or within, positive effect http://model.geneontology.org/60418ffa00000096 | http://model.geneontology.org/5c4605cc00003572 | http://model.geneontology.org/5f46c3b700003482 | http://model.geneontology.org/5df932e000000521 | http://model.geneontology.org/5b528b1100001416 | http://model.geneontology.org/5b91dbd100000154 | http://model.geneontology.org/5fce9b7300000409
directly provides input for http://model.geneontology.org/5d29221b00000268 | http://model.geneontology.org/5900dc7400000568 | http://model.geneontology.org/57c82fad00000020 | http://model.geneontology.org/56d1143000003315 | http://model.geneontology.org/586fc17a00001826
causally upstream of or within, negative effect http://model.geneontology.org/5a7e68a100001507
directly positively regulates http://model.geneontology.org/59bee34700000193 | http://model.geneontology.org/56d1143000003195 | http://model.geneontology.org/568b0f9600000093
happens during http://model.geneontology.org/596ef51500000022 | http://model.geneontology.org/5970219a00000008 | http://model.geneontology.org/596ef51500000068 | http://model.geneontology.org/598826eb00000001 | http://model.geneontology.org/596a6e0600000002 | http://model.geneontology.org/598826eb00000085 | http://model.geneontology.org/596a6e0600000110 | http://model.geneontology.org/5966411600000858 | http://model.geneontology.org/598826eb00000120 | http://model.geneontology.org/5966411600000413 | http://model.geneontology.org/598826eb00000123 | http://model.geneontology.org/584b49fa00000245 | http://model.geneontology.org/583f430000000096 | http://model.geneontology.org/57c4867e00000026 | http://model.geneontology.org/5745387b00000051 | http://model.geneontology.org/539a033300000004 | http://model.geneontology.org/WB_WBGene00001912 | http://model.geneontology.org/WB_WBGene00001900 | http://model.geneontology.org/WB_WBGene00001938 | http://model.geneontology.org/WB_WBGene00001941 | http://model.geneontology.org/5ee8120100000932 | http://model.geneontology.org/5ee8120100001114 | http://model.geneontology.org/5e72450500002902 | http://model.geneontology.org/617b481400000981 | http://model.geneontology.org/60e7989d00001485 | http://model.geneontology.org/60e7989d00000165 | http://model.geneontology.org/6205c24300000538 | http://model.geneontology.org/5b528b1100002293 | http://model.geneontology.org/5fadbcf000001405 | http://model.geneontology.org/56d1143000003824 | http://model.geneontology.org/598826eb00000261 | http://model.geneontology.org/539b93ec00000010
enabled by http://model.geneontology.org/5966411600000233
immediately causally upstream of http://model.geneontology.org/580fe05a00000166 | http://model.geneontology.org/57c4867e00000026 | http://model.geneontology.org/56d1143000003824
directly activates http://model.geneontology.org/57c82fad00000020 | http://model.geneontology.org/5667fdd400000077 | http://model.geneontology.org/55dce5d200000383
involved in http://model.geneontology.org/56d1143000003547
precedes http://model.geneontology.org/567b544200000029
directly inhibits http://model.geneontology.org/5667fdd400000077
regulates transport of http://model.geneontology.org/56d1143000003824
starts before http://model.geneontology.org/598826eb00000503

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Development

No branches or pull requests

2 participants