api_results

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

10 rows where query_id = 388550

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
277336 277336 388550 388550 PubChem (compound) 1 216722 216722 1
327196 327196 388550 388550 PubChem (substance) 2 56065 56065 4
595878 595878 388550 388550 PubChem (substance) 2 91697 91697 5
668907 668907 388550 388550 PubChem (substance) 2 216722 216722 1
926486 926486 388550 388550 PubChem (substance) 2 177777 177777 2
926487 926487 388550 388550 PubChem (substance) 2 177776 177776 3
926488 926488 388550 388550 PubChem (substance) 2 231764 231764 6
926489 926489 388550 388550 PubChem (substance) 2 216722 216722 7
926490 926490 388550 388550 PubChem (substance) 2 308669 308669 8
1121990 1121990 388550 388550 CAS Common Chemistry 3 38120 38120 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)
);