home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 31831

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
66413 66413 31831 31831 PubChem (compound) 1 131966 131966 1
66416 66416 31831 31831 PubChem (compound) 1 131966 131966 2
66418 66418 31831 31831 PubChem (compound) 1 249847 249847 3
66419 66419 31831 31831 PubChem (compound) 1 274610 274610 4
66420 66420 31831 31831 PubChem (compound) 1 295040 295040 5
390420 390420 31831 31831 PubChem (substance) 2 131966 131966 1
390424 390424 31831 31831 PubChem (substance) 2 131966 131966 2
390426 390426 31831 31831 PubChem (substance) 2 249847 249847 7
390427 390427 31831 31831 PubChem (substance) 2 274610 274610 10
390428 390428 31831 31831 PubChem (substance) 2 295040 295040 11
732135 732135 31831 31831 PubChem (substance) 2 211129 211129 3
732137 732137 31831 31831 PubChem (substance) 2 211129 211129 4
732139 732139 31831 31831 PubChem (substance) 2 245398 245398 5
732140 732140 31831 31831 PubChem (substance) 2 291047 291047 6
732141 732141 31831 31831 PubChem (substance) 2 15544 15544 8
732142 732142 31831 31831 PubChem (substance) 2 289549 289549 9
987098 987098 31831 31831 CAS Common Chemistry 3 15544 15544 1
1190012 1190012 31831 31831 Computational Toxicology and Exposure Data 4 131966 131966 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)
);
Powered by Datasette · Queries took 1207.002ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website