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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
163526 163526 143426 143426 PubChem (compound) 1 68359 68359 1
163528 163528 143426 143426 PubChem (compound) 1 185699 185699 2
163529 163529 143426 143426 PubChem (compound) 1 140132 140132 3
163530 163530 143426 143426 PubChem (compound) 1 254036 254036 4
163531 163531 143426 143426 PubChem (compound) 1 264527 264527 5
163532 163532 143426 143426 PubChem (compound) 1 322067 322067 6
163533 163533 143426 143426 PubChem (compound) 1 326595 326595 7
441029 441029 143426 143426 PubChem (substance) 2 119329 119329 5
522918 522918 143426 143426 PubChem (substance) 2 68359 68359 1
522920 522920 143426 143426 PubChem (substance) 2 185699 185699 2
522922 522922 143426 143426 PubChem (substance) 2 140132 140132 11
522924 522924 143426 143426 PubChem (substance) 2 254036 254036 3
522926 522926 143426 143426 PubChem (substance) 2 264527 264527 10
522928 522928 143426 143426 PubChem (substance) 2 322067 322067 9
522930 522930 143426 143426 PubChem (substance) 2 326595 326595 8
800871 800871 143426 143426 PubChem (substance) 2 185398 185398 4
800872 800872 143426 143426 PubChem (substance) 2 233185 233185 6
800875 800875 143426 143426 PubChem (substance) 2 296430 296430 7
1057845 1057845 143426 143426 CAS Common Chemistry 3 68359 68359 1
1260420 1260420 143426 143426 Computational Toxicology and Exposure Data 4 68359 68359 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 490.32ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website