home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 190042

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
207650 207650 190042 190042 PubChem (compound) 1 61256 61256 1
207651 207651 190042 190042 PubChem (compound) 1 216474 216474 2
207652 207652 190042 190042 PubChem (compound) 1 113823 113823 3
580557 580557 190042 190042 PubChem (substance) 2 61256 61256 1
580559 580559 190042 190042 PubChem (substance) 2 216474 216474 2
580561 580561 190042 190042 PubChem (substance) 2 113823 113823 6
717696 717696 190042 190042 PubChem (substance) 2 181915 181915 3
828126 828126 190042 190042 PubChem (substance) 2 210015 210015 4
828127 828127 190042 190042 PubChem (substance) 2 243745 243745 5
828128 828128 190042 190042 PubChem (substance) 2 294854 294854 7
828129 828129 190042 190042 PubChem (substance) 2 146375 146375 8
828130 828130 190042 190042 PubChem (substance) 2 245475 245475 9
828131 828131 190042 190042 PubChem (substance) 2 289285 289285 10
1089113 1089113 190042 190042 CAS Common Chemistry 3 61256 61256 1
1290836 1290836 190042 190042 Computational Toxicology and Exposure Data 4 113823 113823 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 505.464ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website