api_results

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

10 rows where inchi_id = 20451

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
47465 47465 21410 21410 PubChem (compound) 1 20451 20451 1
47466 47466 21411 21411 PubChem (compound) 1 20451 20451 1
47467 47467 125954 125954 PubChem (compound) 1 20451 20451 1
363361 363361 21410 21410 PubChem (substance) 2 20451 20451 1
363362 363362 21411 21411 PubChem (substance) 2 20451 20451 1
363363 363363 125954 125954 PubChem (substance) 2 20451 20451 1
363364 363364 73334 73334 PubChem (substance) 2 20451 20451 3
972570 972570 73334 73334 CAS Common Chemistry 3 20451 20451 1
972571 972571 21410 21410 CAS Common Chemistry 3 20451 20451 1
972572 972572 125954 125954 CAS Common Chemistry 3 20451 20451 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)
);