home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 11416

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21847 21847 11416 11416 PubChem (compound) 1 53082 53082 1
326962 326962 11416 11416 PubChem (substance) 2 53082 53082 1
441892 441892 11416 11416 PubChem (substance) 2 101668 101668 14
707790 707790 11416 11416 PubChem (substance) 2 136493 136493 2
707793 707793 11416 11416 PubChem (substance) 2 238943 238943 3
707799 707799 11416 11416 PubChem (substance) 2 170070 170070 4
707802 707802 11416 11416 PubChem (substance) 2 119335 119335 5
707805 707805 11416 11416 PubChem (substance) 2 173722 173722 6
707811 707811 11416 11416 PubChem (substance) 2 332562 332562 7
707814 707814 11416 11416 PubChem (substance) 2 170217 170217 8
707818 707818 11416 11416 PubChem (substance) 2 239270 239270 9
707821 707821 11416 11416 PubChem (substance) 2 271916 271916 10
707823 707823 11416 11416 PubChem (substance) 2 167093 167093 11
707824 707824 11416 11416 PubChem (substance) 2 248047 248047 12
707825 707825 11416 11416 PubChem (substance) 2 265024 265024 13
707827 707827 11416 11416 PubChem (substance) 2 167683 167683 15
707829 707829 11416 11416 PubChem (substance) 2 176794 176794 16
707832 707832 11416 11416 PubChem (substance) 2 309907 309907 17
954310 954310 11416 11416 CAS Common Chemistry 3 53082 53082 1
1153882 1153882 11416 11416 Computational Toxicology and Exposure Data 4 53082 53082 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 446.432ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website