api_results

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

13 rows where query_id = 150658

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
169973 169973 150658 150658 PubChem (compound) 1 9146 9146 1
169977 169977 150658 150658 PubChem (compound) 1 146414 146414 2
169978 169978 150658 150658 PubChem (compound) 1 208521 208521 3
531705 531705 150658 150658 PubChem (substance) 2 9146 9146 1
531710 531710 150658 150658 PubChem (substance) 2 146414 146414 2
531716 531716 150658 150658 PubChem (substance) 2 208521 208521 3
805434 805434 150658 150658 PubChem (substance) 2 172220 172220 4
805435 805435 150658 150658 PubChem (substance) 2 243023 243023 5
805438 805438 150658 150658 PubChem (substance) 2 195162 195162 6
805439 805439 150658 150658 PubChem (substance) 2 165883 165883 7
805440 805440 150658 150658 PubChem (substance) 2 196242 196242 8
1062876 1062876 150658 150658 CAS Common Chemistry 3 9146 9146 1
1264957 1264957 150658 150658 Computational Toxicology and Exposure Data 4 131070 131070 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)
);