api_results

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

6 rows where query_id = 148956

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
168376 168376 148956 148956 PubChem (compound) 1 6369 6369 1
529058 529058 148956 148956 PubChem (substance) 2 5957 5957 2
529587 529587 148956 148956 PubChem (substance) 2 6369 6369 1
804360 804360 148956 148956 PubChem (substance) 2 205747 205747 3
1061663 1061663 148956 148956 CAS Common Chemistry 3 6369 6369 1
1263918 1263918 148956 148956 Computational Toxicology and Exposure Data 4 6369 6369 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)
);