home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 104719

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124655 124655 104719 104719 PubChem (compound) 1 48085 48085 1
124657 124657 104719 104719 PubChem (compound) 1 137607 137607 2
124660 124660 104719 104719 PubChem (compound) 1 215421 215421 3
124661 124661 104719 104719 PubChem (compound) 1 216987 216987 4
471559 471559 104719 104719 PubChem (substance) 2 48085 48085 1
471561 471561 104719 104719 PubChem (substance) 2 137607 137607 4
471564 471564 104719 104719 PubChem (substance) 2 215421 215421 3
471566 471566 104719 104719 PubChem (substance) 2 216987 216987 6
771531 771531 104719 104719 PubChem (substance) 2 137274 137274 2
771532 771532 104719 104719 PubChem (substance) 2 251681 251681 5
771533 771533 104719 104719 PubChem (substance) 2 154174 154174 7
771535 771535 104719 104719 PubChem (substance) 2 266449 266449 8
771536 771536 104719 104719 PubChem (substance) 2 277427 277427 9
771537 771537 104719 104719 PubChem (substance) 2 292581 292581 10
771538 771538 104719 104719 PubChem (substance) 2 294546 294546 11
771539 771539 104719 104719 PubChem (substance) 2 295298 295298 12
771540 771540 104719 104719 PubChem (substance) 2 186273 186273 13
771541 771541 104719 104719 PubChem (substance) 2 307756 307756 14
771542 771542 104719 104719 PubChem (substance) 2 48084 48084 15
771543 771543 104719 104719 PubChem (substance) 2 321406 321406 16
771544 771544 104719 104719 PubChem (substance) 2 333157 333157 17
1028494 1028494 104719 104719 CAS Common Chemistry 3 48085 48085 1
1231298 1231298 104719 104719 Computational Toxicology and Exposure Data 4 48085 48085 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 502.975ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website