home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 204663

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
220313 220313 204663 204663 PubChem (compound) 1 77920 77920 1
596657 596657 204663 204663 PubChem (substance) 2 102535 102535 15
596661 596661 204663 204663 PubChem (substance) 2 77920 77920 1
596871 596871 204663 204663 PubChem (substance) 2 186083 186083 2
596874 596874 204663 204663 PubChem (substance) 2 145062 145062 3
596875 596875 204663 204663 PubChem (substance) 2 185611 185611 4
596877 596877 204663 204663 PubChem (substance) 2 218214 218214 9
596880 596880 204663 204663 PubChem (substance) 2 288107 288107 8
596884 596884 204663 204663 PubChem (substance) 2 297681 297681 16
833141 833141 204663 204663 PubChem (substance) 2 230532 230532 13
833143 833143 204663 204663 PubChem (substance) 2 309884 309884 14
833213 833213 204663 204663 PubChem (substance) 2 140042 140042 7
833215 833215 204663 204663 PubChem (substance) 2 259348 259348 6
833217 833217 204663 204663 PubChem (substance) 2 169561 169561 5
833218 833218 204663 204663 PubChem (substance) 2 203663 203663 10
833219 833219 204663 204663 PubChem (substance) 2 190212 190212 11
833220 833220 204663 204663 PubChem (substance) 2 233180 233180 12
1097577 1097577 204663 204663 CAS Common Chemistry 3 77920 77920 1
1299421 1299421 204663 204663 Computational Toxicology and Exposure Data 4 77920 77920 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 448.551ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website