home / zeropm-v0-0-4

api_results

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

22 rows where query_id = 362559

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
306908 306908 362559 362559 PubChem (substance) 2 60356 60356 3
326626 326626 362559 362559 PubChem (substance) 2 52187 52187 17
462053 462053 362559 362559 PubChem (substance) 2 43805 43805 16
756372 756372 362559 362559 PubChem (substance) 2 256614 256614 4
915817 915817 362559 362559 PubChem (substance) 2 219116 219116 1
915818 915818 362559 362559 PubChem (substance) 2 241051 241051 2
915819 915819 362559 362559 PubChem (substance) 2 238658 238658 5
915820 915820 362559 362559 PubChem (substance) 2 262263 262263 6
915821 915821 362559 362559 PubChem (substance) 2 203292 203292 7
915822 915822 362559 362559 PubChem (substance) 2 241455 241455 8
915823 915823 362559 362559 PubChem (substance) 2 218045 218045 9
915824 915824 362559 362559 PubChem (substance) 2 218046 218046 10
915825 915825 362559 362559 PubChem (substance) 2 218048 218048 11
915826 915826 362559 362559 PubChem (substance) 2 218047 218047 12
915827 915827 362559 362559 PubChem (substance) 2 176465 176465 13
915828 915828 362559 362559 PubChem (substance) 2 176462 176462 14
915829 915829 362559 362559 PubChem (substance) 2 180005 180005 15
915830 915830 362559 362559 PubChem (substance) 2 323519 323519 18
915831 915831 362559 362559 PubChem (substance) 2 200872 200872 19
915832 915832 362559 362559 PubChem (substance) 2 220314 220314 20
915833 915833 362559 362559 PubChem (substance) 2 183435 183435 21
915834 915834 362559 362559 PubChem (substance) 2 179387 179387 22
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 470.101ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website