home / zeropm-v0-0-4

api_results

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

19 rows where query_id = 100062

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21875 21875 100062 100062 PubChem (compound) 1 54009 54009 1
327003 327003 100062 100062 PubChem (substance) 2 54009 54009 1
695877 695877 100062 100062 PubChem (substance) 2 315679 315679 7
707896 707896 100062 100062 PubChem (substance) 2 314248 314248 2
707904 707904 100062 100062 PubChem (substance) 2 232270 232270 5
707910 707910 100062 100062 PubChem (substance) 2 262660 262660 4
707916 707916 100062 100062 PubChem (substance) 2 317246 317246 14
707920 707920 100062 100062 PubChem (substance) 2 320650 320650 15
709557 709557 100062 100062 PubChem (substance) 2 315681 315681 8
709574 709574 100062 100062 PubChem (substance) 2 315682 315682 9
762630 762630 100062 100062 PubChem (substance) 2 315480 315480 10
769085 769085 100062 100062 PubChem (substance) 2 315368 315368 3
769087 769087 100062 100062 PubChem (substance) 2 313959 313959 6
769090 769090 100062 100062 PubChem (substance) 2 315327 315327 11
769093 769093 100062 100062 PubChem (substance) 2 313832 313832 12
769094 769094 100062 100062 PubChem (substance) 2 314509 314509 13
769096 769096 100062 100062 PubChem (substance) 2 324642 324642 16
954329 954329 100062 100062 CAS Common Chemistry 3 54009 54009 1
1153915 1153915 100062 100062 Computational Toxicology and Exposure Data 4 54009 54009 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 1052.439ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website