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 = 32801

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47635 47635 32801 32801 PubChem (compound) 1 112748 112748 4
47642 47642 32801 32801 PubChem (compound) 1 210051 210051 1
47648 47648 32801 32801 PubChem (compound) 1 112748 112748 3
47659 47659 32801 32801 PubChem (compound) 1 112748 112748 2
68183 68183 32801 32801 PubChem (compound) 1 227351 227351 5
363595 363595 32801 32801 PubChem (substance) 2 112748 112748 6
363599 363599 32801 32801 PubChem (substance) 2 210051 210051 1
363607 363607 32801 32801 PubChem (substance) 2 112748 112748 10
363615 363615 32801 32801 PubChem (substance) 2 112748 112748 4
363630 363630 32801 32801 PubChem (substance) 2 112748 112748 2
392808 392808 32801 32801 PubChem (substance) 2 227351 227351 11
707270 707270 32801 32801 PubChem (substance) 2 14536 14536 7
721028 721028 32801 32801 PubChem (substance) 2 14536 14536 3
733035 733035 32801 32801 PubChem (substance) 2 14536 14536 5
733037 733037 32801 32801 PubChem (substance) 2 253140 253140 8
733041 733041 32801 32801 PubChem (substance) 2 266055 266055 9
733042 733042 32801 32801 PubChem (substance) 2 14536 14536 12
733047 733047 32801 32801 PubChem (substance) 2 296468 296468 13
988517 988517 32801 32801 CAS Common Chemistry 3 14536 14536 1
1191379 1191379 32801 32801 Computational Toxicology and Exposure Data 4 97375 97375 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 496.6ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website