api_results

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

14 rows where query_id = 81456

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
44293 44293 81456 81456 PubChem (compound) 1 5403 5403 1
348079 348079 81456 81456 PubChem (substance) 2 44014 44014 3
358636 358636 81456 81456 PubChem (substance) 2 5403 5403 1
658451 658451 81456 81456 PubChem (substance) 2 43934 43934 6
718840 718840 81456 81456 PubChem (substance) 2 169167 169167 2
718842 718842 81456 81456 PubChem (substance) 2 203453 203453 4
761027 761027 81456 81456 PubChem (substance) 2 169790 169790 5
761029 761029 81456 81456 PubChem (substance) 2 192413 192413 7
761030 761030 81456 81456 PubChem (substance) 2 192463 192463 8
761032 761032 81456 81456 PubChem (substance) 2 194301 194301 9
761034 761034 81456 81456 PubChem (substance) 2 198517 198517 10
761035 761035 81456 81456 PubChem (substance) 2 203738 203738 11
761036 761036 81456 81456 PubChem (substance) 2 212407 212407 12
970549 970549 81456 81456 CAS Common Chemistry 3 5403 5403 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)
);