home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 21401

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47435 47435 21401 21401 PubChem (compound) 1 130562 130562 1
47439 47439 21401 21401 PubChem (compound) 1 141278 141278 2
47442 47442 21401 21401 PubChem (compound) 1 130562 130562 3
47443 47443 21401 21401 PubChem (compound) 1 332385 332385 4
47446 47446 21401 21401 PubChem (compound) 1 20331 20331 5
363323 363323 21401 21401 PubChem (substance) 2 130562 130562 1
363330 363330 21401 21401 PubChem (substance) 2 141278 141278 2
363337 363337 21401 21401 PubChem (substance) 2 130562 130562 3
363339 363339 21401 21401 PubChem (substance) 2 332385 332385 4
363342 363342 21401 21401 PubChem (substance) 2 20331 20331 6
720966 720966 21401 21401 PubChem (substance) 2 291065 291065 5
720969 720969 21401 21401 PubChem (substance) 2 250810 250810 7
720970 720970 21401 21401 PubChem (substance) 2 148903 148903 8
720971 720971 21401 21401 PubChem (substance) 2 237644 237644 9
972554 972554 21401 21401 CAS Common Chemistry 3 20331 20331 1
1175224 1175224 21401 21401 Computational Toxicology and Exposure Data 4 130562 130562 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 461.136ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website