home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 17142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
37551 37551 17142 17142 PubChem (compound) 1 45927 45927 1
349397 349397 17142 17142 PubChem (substance) 2 45927 45927 1
349399 349399 17142 17142 PubChem (substance) 2 173180 173180 2
426976 426976 17142 17142 PubChem (substance) 2 44478 44478 8
446227 446227 17142 17142 PubChem (substance) 2 97621 97621 15
715801 715801 17142 17142 PubChem (substance) 2 154272 154272 3
715803 715803 17142 17142 PubChem (substance) 2 257306 257306 4
715804 715804 17142 17142 PubChem (substance) 2 241520 241520 5
715806 715806 17142 17142 PubChem (substance) 2 274472 274472 6
715807 715807 17142 17142 PubChem (substance) 2 180082 180082 7
715808 715808 17142 17142 PubChem (substance) 2 239424 239424 9
715809 715809 17142 17142 PubChem (substance) 2 217782 217782 10
715810 715810 17142 17142 PubChem (substance) 2 292532 292532 11
715811 715811 17142 17142 PubChem (substance) 2 177101 177101 12
715812 715812 17142 17142 PubChem (substance) 2 320782 320782 13
715813 715813 17142 17142 PubChem (substance) 2 326502 326502 14
965538 965538 17142 17142 CAS Common Chemistry 3 45927 45927 1
1167295 1167295 17142 17142 Computational Toxicology and Exposure Data 4 45927 45927 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 422.619ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website