home / zeropm-v0-0-4

api_results

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

16 rows where query_id = 435647

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
21871 21871 435647 435647 PubChem (compound) 1 1340 1340 1
326993 326993 435647 435647 PubChem (substance) 2 1340 1340 2
348585 348585 435647 435647 PubChem (substance) 2 136277 136277 4
437582 437582 435647 435647 PubChem (substance) 2 139024 139024 5
656796 656796 435647 435647 PubChem (substance) 2 54007 54007 1
706991 706991 435647 435647 PubChem (substance) 2 132595 132595 3
707869 707869 435647 435647 PubChem (substance) 2 265325 265325 7
707874 707874 435647 435647 PubChem (substance) 2 255356 255356 6
707877 707877 435647 435647 PubChem (substance) 2 254902 254902 10
707882 707882 435647 435647 PubChem (substance) 2 270213 270213 11
707886 707886 435647 435647 PubChem (substance) 2 169012 169012 12
707892 707892 435647 435647 PubChem (substance) 2 231807 231807 8
707894 707894 435647 435647 PubChem (substance) 2 197707 197707 9
954325 954325 435647 435647 CAS Common Chemistry 3 54007 54007 1
1153905 1153905 435647 435647 Computational Toxicology and Exposure Data 4 54007 54007 2
1153910 1153910 435647 435647 Computational Toxicology and Exposure Data 4 28601 28601 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 473.224ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website