home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 83799

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
45090 45090 83799 83799 PubChem (compound) 1 10872 10872 1
359981 359981 83799 83799 PubChem (substance) 2 10872 10872 1
359987 359987 83799 83799 PubChem (substance) 2 138375 138375 5
359997 359997 83799 83799 PubChem (substance) 2 136608 136608 4
360012 360012 83799 83799 PubChem (substance) 2 188062 188062 2
360024 360024 83799 83799 PubChem (substance) 2 246747 246747 11
360028 360028 83799 83799 PubChem (substance) 2 230904 230904 8
360043 360043 83799 83799 PubChem (substance) 2 240719 240719 10
360050 360050 83799 83799 PubChem (substance) 2 241752 241752 14
456096 456096 83799 83799 PubChem (substance) 2 284744 284744 17
719705 719705 83799 83799 PubChem (substance) 2 250733 250733 13
719714 719714 83799 83799 PubChem (substance) 2 200265 200265 6
719728 719728 83799 83799 PubChem (substance) 2 217308 217308 7
719738 719738 83799 83799 PubChem (substance) 2 260068 260068 3
719746 719746 83799 83799 PubChem (substance) 2 237274 237274 9
719768 719768 83799 83799 PubChem (substance) 2 288705 288705 12
719782 719782 83799 83799 PubChem (substance) 2 288896 288896 15
719788 719788 83799 83799 PubChem (substance) 2 189566 189566 16
970887 970887 83799 83799 CAS Common Chemistry 3 10872 10872 1
1173408 1173408 83799 83799 Computational Toxicology and Exposure Data 4 10872 10872 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 471.731ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website