home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 392581

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
64798 64798 392581 392581 PubChem (compound) 1 203237 203237 2
64802 64802 392581 392581 PubChem (compound) 1 187220 187220 3
266965 266965 392581 392581 PubChem (compound) 1 203237 203237 4
279559 279559 392581 392581 PubChem (compound) 1 294909 294909 1
388047 388047 392581 392581 PubChem (substance) 2 203237 203237 2
388055 388055 392581 392581 PubChem (substance) 2 187220 187220 5
388059 388059 392581 392581 PubChem (substance) 2 216034 216034 4
388062 388062 392581 392581 PubChem (substance) 2 323194 323194 12
655749 655749 392581 392581 PubChem (substance) 2 203237 203237 6
671765 671765 392581 392581 PubChem (substance) 2 294909 294909 1
929014 929014 392581 392581 PubChem (substance) 2 250452 250452 3
929015 929015 392581 392581 PubChem (substance) 2 277528 277528 7
929016 929016 392581 392581 PubChem (substance) 2 288026 288026 8
929017 929017 392581 392581 PubChem (substance) 2 309090 309090 9
929018 929018 392581 392581 PubChem (substance) 2 250452 250452 10
929019 929019 392581 392581 PubChem (substance) 2 226532 226532 11
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 459.487ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website