api_results

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

9 rows where inchi_id = 20160

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47407 47407 21389 21389 PubChem (compound) 1 20160 20160 2
47408 47408 439437 439437 PubChem (compound) 1 20160 20160 2
363282 363282 21388 21388 PubChem (substance) 2 20160 20160 2
363283 363283 21389 21389 PubChem (substance) 2 20160 20160 2
363284 363284 439437 439437 PubChem (substance) 2 20160 20160 2
972527 972527 21388 21388 CAS Common Chemistry 3 20160 20160 1
972528 972528 439437 439437 CAS Common Chemistry 3 20160 20160 1
972529 972529 21389 21389 CAS Common Chemistry 3 20160 20160 1
972530 972530 409523 409523 CAS Common Chemistry 3 20160 20160 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)
);