home / zeropm-v0-0-4

api_results

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

17 rows where query_id = 1692

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
3267 3267 1692 1692 PubChem (compound) 1 53042 53042 1
300068 300068 1692 1692 PubChem (substance) 2 53042 53042 1
373144 373144 1692 1692 PubChem (substance) 2 52588 52588 3
550880 550880 1692 1692 PubChem (substance) 2 27568 27568 14
694645 694645 1692 1692 PubChem (substance) 2 259234 259234 2
694651 694651 1692 1692 PubChem (substance) 2 181574 181574 4
694654 694654 1692 1692 PubChem (substance) 2 232008 232008 5
694661 694661 1692 1692 PubChem (substance) 2 232009 232009 6
694667 694667 1692 1692 PubChem (substance) 2 232032 232032 7
694676 694676 1692 1692 PubChem (substance) 2 232033 232033 8
694681 694681 1692 1692 PubChem (substance) 2 232034 232034 9
694684 694684 1692 1692 PubChem (substance) 2 149542 149542 10
694693 694693 1692 1692 PubChem (substance) 2 232035 232035 11
694696 694696 1692 1692 PubChem (substance) 2 167932 167932 12
694698 694698 1692 1692 PubChem (substance) 2 137664 137664 13
940474 940474 1692 1692 CAS Common Chemistry 3 53042 53042 1
1137638 1137638 1692 1692 Computational Toxicology and Exposure Data 4 53042 53042 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 417.925ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website