home / zeropm-v0-0-4

api_results

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

25 rows where query_id = 335672

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
263628 263628 335672 335672 PubChem (compound) 1 25328 25328 1
650019 650019 335672 335672 PubChem (substance) 2 25328 25328 1
650024 650024 335672 335672 PubChem (substance) 2 162557 162557 2
738124 738124 335672 335672 PubChem (substance) 2 144633 144633 18
910452 910452 335672 335672 PubChem (substance) 2 177273 177273 3
910453 910453 335672 335672 PubChem (substance) 2 177274 177274 4
910454 910454 335672 335672 PubChem (substance) 2 177275 177275 5
910455 910455 335672 335672 PubChem (substance) 2 201930 201930 6
910456 910456 335672 335672 PubChem (substance) 2 201931 201931 7
910457 910457 335672 335672 PubChem (substance) 2 206784 206784 8
910458 910458 335672 335672 PubChem (substance) 2 206785 206785 9
910459 910459 335672 335672 PubChem (substance) 2 206786 206786 10
910460 910460 335672 335672 PubChem (substance) 2 206787 206787 11
910461 910461 335672 335672 PubChem (substance) 2 178426 178426 12
910462 910462 335672 335672 PubChem (substance) 2 195322 195322 13
910463 910463 335672 335672 PubChem (substance) 2 195444 195444 14
910464 910464 335672 335672 PubChem (substance) 2 173824 173824 15
910465 910465 335672 335672 PubChem (substance) 2 173904 173904 16
910466 910466 335672 335672 PubChem (substance) 2 140793 140793 17
910467 910467 335672 335672 PubChem (substance) 2 206928 206928 19
910468 910468 335672 335672 PubChem (substance) 2 206929 206929 20
910469 910469 335672 335672 PubChem (substance) 2 206930 206930 21
910470 910470 335672 335672 PubChem (substance) 2 221363 221363 22
1115015 1115015 335672 335672 CAS Common Chemistry 3 25328 25328 1
1326510 1326510 335672 335672 Computational Toxicology and Exposure Data 4 25328 25328 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 1563.209ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website