home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 316553

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45122 45122 316553 316553 PubChem (compound) 1 49591 49591 1
45126 45126 316553 316553 PubChem (compound) 1 215814 215814 4
217371 217371 316553 316553 PubChem (compound) 1 71526 71526 3
260345 260345 316553 316553 PubChem (compound) 1 215711 215711 2
260347 260347 316553 316553 PubChem (compound) 1 215816 215816 5
360096 360096 316553 316553 PubChem (substance) 2 49591 49591 1
360102 360102 316553 316553 PubChem (substance) 2 215814 215814 4
483628 483628 316553 316553 PubChem (substance) 2 48795 48795 9
593067 593067 316553 316553 PubChem (substance) 2 71526 71526 3
645257 645257 316553 316553 PubChem (substance) 2 215711 215711 2
645261 645261 316553 316553 PubChem (substance) 2 215816 215816 5
719849 719849 316553 316553 PubChem (substance) 2 161855 161855 7
719853 719853 316553 316553 PubChem (substance) 2 334455 334455 10
769575 769575 316553 316553 PubChem (substance) 2 232097 232097 8
848092 848092 316553 316553 PubChem (substance) 2 170060 170060 6
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 497.311ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website