home / zeropm-v0-0-4

api_results

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

64 rows where query_id = 12967

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
26225 26225 12967 12967 PubChem (compound) 1 85229 85229 1
330192 330192 12967 12967 PubChem (substance) 2 81213 81213 19
333239 333239 12967 12967 PubChem (substance) 2 85229 85229 1
335948 335948 12967 12967 PubChem (substance) 2 91481 91481 24
335957 335957 12967 12967 PubChem (substance) 2 91482 91482 6
341983 341983 12967 12967 PubChem (substance) 2 5239 5239 14
342496 342496 12967 12967 PubChem (substance) 2 6264 6264 13
344425 344425 12967 12967 PubChem (substance) 2 9016 9016 3
352892 352892 12967 12967 PubChem (substance) 2 55649 55649 7
352903 352903 12967 12967 PubChem (substance) 2 55650 55650 5
352907 352907 12967 12967 PubChem (substance) 2 55657 55657 57
353027 353027 12967 12967 PubChem (substance) 2 56111 56111 10
353526 353526 12967 12967 PubChem (substance) 2 57207 57207 16
353530 353530 12967 12967 PubChem (substance) 2 57209 57209 4
358082 358082 12967 12967 PubChem (substance) 2 4260 4260 15
358710 358710 12967 12967 PubChem (substance) 2 5740 5740 40
360327 360327 12967 12967 PubChem (substance) 2 29246 29246 36
369335 369335 12967 12967 PubChem (substance) 2 39762 39762 43
371512 371512 12967 12967 PubChem (substance) 2 44776 44776 29
382765 382765 12967 12967 PubChem (substance) 2 548 548 46
393102 393102 12967 12967 PubChem (substance) 2 20316 20316 33
395009 395009 12967 12967 PubChem (substance) 2 24092 24092 52
395237 395237 12967 12967 PubChem (substance) 2 24685 24685 53
413176 413176 12967 12967 PubChem (substance) 2 192721 192721 37
424758 424758 12967 12967 PubChem (substance) 2 84059 84059 18
434592 434592 12967 12967 PubChem (substance) 2 14703 14703 25
446331 446331 12967 12967 PubChem (substance) 2 40457 40457 48
455060 455060 12967 12967 PubChem (substance) 2 122536 122536 38
466323 466323 12967 12967 PubChem (substance) 2 57210 57210 8
466328 466328 12967 12967 PubChem (substance) 2 57099 57099 2
474927 474927 12967 12967 PubChem (substance) 2 91451 91451 22
474935 474935 12967 12967 PubChem (substance) 2 91453 91453 27
480157 480157 12967 12967 PubChem (substance) 2 39751 39751 45
483641 483641 12967 12967 PubChem (substance) 2 48799 48799 20
484932 484932 12967 12967 PubChem (substance) 2 53085 53085 56
486383 486383 12967 12967 PubChem (substance) 2 56112 56112 12
486387 486387 12967 12967 PubChem (substance) 2 56113 56113 30
486960 486960 12967 12967 PubChem (substance) 2 57096 57096 11
486963 486963 12967 12967 PubChem (substance) 2 57097 57097 31
487020 487020 12967 12967 PubChem (substance) 2 57208 57208 17
510852 510852 12967 12967 PubChem (substance) 2 40730 40730 44
515576 515576 12967 12967 PubChem (substance) 2 48874 48874 47
524067 524067 12967 12967 PubChem (substance) 2 73005 73005 28
551811 551811 12967 12967 PubChem (substance) 2 28568 28568 49
627183 627183 12967 12967 PubChem (substance) 2 124073 124073 23
652742 652742 12967 12967 PubChem (substance) 2 101980 101980 59
664103 664103 12967 12967 PubChem (substance) 2 37780 37780 58
664925 664925 12967 12967 PubChem (substance) 2 58822 58822 34
665113 665113 12967 12967 PubChem (substance) 2 40728 40728 41
679035 679035 12967 12967 PubChem (substance) 2 50191 50191 26
710434 710434 12967 12967 PubChem (substance) 2 157773 157773 9
710435 710435 12967 12967 PubChem (substance) 2 138864 138864 21
710436 710436 12967 12967 PubChem (substance) 2 159876 159876 32
710437 710437 12967 12967 PubChem (substance) 2 160426 160426 35
710438 710438 12967 12967 PubChem (substance) 2 161379 161379 39
710441 710441 12967 12967 PubChem (substance) 2 162007 162007 42
710442 710442 12967 12967 PubChem (substance) 2 165532 165532 50
710443 710443 12967 12967 PubChem (substance) 2 166271 166271 51
710445 710445 12967 12967 PubChem (substance) 2 142558 142558 54
710446 710446 12967 12967 PubChem (substance) 2 144459 144459 55
710447 710447 12967 12967 PubChem (substance) 2 168016 168016 60
710448 710448 12967 12967 PubChem (substance) 2 168070 168070 61
957395 957395 12967 12967 CAS Common Chemistry 3 85229 85229 1
1157625 1157625 12967 12967 Computational Toxicology and Exposure Data 4 85229 85229 1
CREATE TABLE [api_results] (
        [query_id] integer,
        [api_id] integer,
        [inchi_id] integer,
        [rank] integer,
        FOREIGN KEY (query_id) REFERENCES api_ready_query(query_id),
        FOREIGN KEY (api_id) REFERENCES api_services(api_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1642.563ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website