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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
100617 100617 60645 60645 PubChem (compound) 1 21585 21585 1
308042 308042 60645 60645 PubChem (substance) 2 358 358 3
438111 438111 60645 60645 PubChem (substance) 2 21585 21585 1
488046 488046 60645 60645 PubChem (substance) 2 58854 58854 14
558836 558836 60645 60645 PubChem (substance) 2 35348 35348 12
703471 703471 60645 60645 PubChem (substance) 2 170223 170223 7
750857 750857 60645 60645 PubChem (substance) 2 168284 168284 2
750858 750858 60645 60645 PubChem (substance) 2 168424 168424 4
750861 750861 60645 60645 PubChem (substance) 2 168425 168425 5
750862 750862 60645 60645 PubChem (substance) 2 168426 168426 6
750865 750865 60645 60645 PubChem (substance) 2 168925 168925 8
750867 750867 60645 60645 PubChem (substance) 2 180750 180750 9
750868 750868 60645 60645 PubChem (substance) 2 186523 186523 10
750871 750871 60645 60645 PubChem (substance) 2 270531 270531 11
750872 750872 60645 60645 PubChem (substance) 2 173816 173816 13
750875 750875 60645 60645 PubChem (substance) 2 214916 214916 15
750877 750877 60645 60645 PubChem (substance) 2 145093 145093 16
750879 750879 60645 60645 PubChem (substance) 2 178969 178969 17
1012368 1012368 60645 60645 CAS Common Chemistry 3 21585 21585 1
1214509 1214509 60645 60645 Computational Toxicology and Exposure Data 4 21585 21585 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 425.039ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website