api_results

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

10 rows where query_id = 158867

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
178084 178084 158867 158867 PubChem (compound) 1 128040 128040 1
542385 542385 158867 158867 PubChem (substance) 2 128040 128040 1
691076 691076 158867 158867 PubChem (substance) 2 19159 19159 6
811266 811266 158867 158867 PubChem (substance) 2 143524 143524 2
811267 811267 158867 158867 PubChem (substance) 2 282065 282065 3
811268 811268 158867 158867 PubChem (substance) 2 241675 241675 4
811269 811269 158867 158867 PubChem (substance) 2 241604 241604 5
811270 811270 158867 158867 PubChem (substance) 2 206086 206086 7
1068969 1068969 158867 158867 CAS Common Chemistry 3 19159 19159 1
1270464 1270464 158867 158867 Computational Toxicology and Exposure Data 4 128040 128040 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)
);