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 = 363717

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96507 96507 363717 363717 PubChem (compound) 1 51340 51340 1
432040 432040 363717 363717 PubChem (substance) 2 51340 51340 1
435023 435023 363717 363717 PubChem (substance) 2 101837 101837 5
477339 477339 363717 363717 PubChem (substance) 2 9045 9045 4
482362 482362 363717 363717 PubChem (substance) 2 107048 107048 12
641838 641838 363717 363717 PubChem (substance) 2 136303 136303 2
662913 662913 363717 363717 PubChem (substance) 2 272462 272462 11
747609 747609 363717 363717 PubChem (substance) 2 149548 149548 3
747613 747613 363717 363717 PubChem (substance) 2 149549 149549 9
747617 747617 363717 363717 PubChem (substance) 2 217184 217184 10
771824 771824 363717 363717 PubChem (substance) 2 232081 232081 6
771827 771827 363717 363717 PubChem (substance) 2 232174 232174 7
771829 771829 363717 363717 PubChem (substance) 2 232175 232175 8
771831 771831 363717 363717 PubChem (substance) 2 334327 334327 13
1009597 1009597 363717 363717 CAS Common Chemistry 3 51340 51340 1
1211620 1211620 363717 363717 Computational Toxicology and Exposure Data 4 51340 51340 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 802.715ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website