home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 189642

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
207301 207301 189642 189642 PubChem (compound) 1 60703 60703 1
580122 580122 189642 189642 PubChem (substance) 2 60703 60703 1
671511 671511 189642 189642 PubChem (substance) 2 73680 73680 2
827916 827916 189642 189642 PubChem (substance) 2 137109 137109 7
827919 827919 189642 189642 PubChem (substance) 2 139927 139927 5
827921 827921 189642 189642 PubChem (substance) 2 195468 195468 14
827923 827923 189642 189642 PubChem (substance) 2 227615 227615 23
827925 827925 189642 189642 PubChem (substance) 2 186025 186025 3
827927 827927 189642 189642 PubChem (substance) 2 140019 140019 4
827928 827928 189642 189642 PubChem (substance) 2 273449 273449 6
827929 827929 189642 189642 PubChem (substance) 2 230535 230535 8
827930 827930 189642 189642 PubChem (substance) 2 137108 137108 9
827931 827931 189642 189642 PubChem (substance) 2 60703 60703 10
827933 827933 189642 189642 PubChem (substance) 2 232954 232954 11
827934 827934 189642 189642 PubChem (substance) 2 258644 258644 12
827935 827935 189642 189642 PubChem (substance) 2 287640 287640 13
827936 827936 189642 189642 PubChem (substance) 2 297582 297582 15
827937 827937 189642 189642 PubChem (substance) 2 310018 310018 16
827938 827938 189642 189642 PubChem (substance) 2 311045 311045 17
827939 827939 189642 189642 PubChem (substance) 2 169423 169423 18
827940 827940 189642 189642 PubChem (substance) 2 320179 320179 19
827941 827941 189642 189642 PubChem (substance) 2 237212 237212 20
827943 827943 189642 189642 PubChem (substance) 2 224674 224674 21
827944 827944 189642 189642 PubChem (substance) 2 266473 266473 22
827945 827945 189642 189642 PubChem (substance) 2 335215 335215 24
827946 827946 189642 189642 PubChem (substance) 2 343642 343642 25
1088884 1088884 189642 189642 CAS Common Chemistry 3 60703 60703 1
1290608 1290608 189642 189642 Computational Toxicology and Exposure Data 4 60703 60703 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 1480.2ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website