home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 104757

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
124707 124707 104757 104757 PubChem (compound) 1 49226 49226 1
471636 471636 104757 104757 PubChem (substance) 2 49226 49226 1
677251 677251 104757 104757 PubChem (substance) 2 137106 137106 2
677255 677255 104757 104757 PubChem (substance) 2 170703 170703 6
712095 712095 104757 104757 PubChem (substance) 2 262638 262638 16
771615 771615 104757 104757 PubChem (substance) 2 254605 254605 4
771617 771617 104757 104757 PubChem (substance) 2 215544 215544 17
771621 771621 104757 104757 PubChem (substance) 2 170699 170699 3
771624 771624 104757 104757 PubChem (substance) 2 192055 192055 5
771629 771629 104757 104757 PubChem (substance) 2 242127 242127 15
771630 771630 104757 104757 PubChem (substance) 2 153093 153093 7
771631 771631 104757 104757 PubChem (substance) 2 176509 176509 8
771632 771632 104757 104757 PubChem (substance) 2 180069 180069 9
771633 771633 104757 104757 PubChem (substance) 2 200687 200687 10
771634 771634 104757 104757 PubChem (substance) 2 195363 195363 11
771635 771635 104757 104757 PubChem (substance) 2 200073 200073 12
771636 771636 104757 104757 PubChem (substance) 2 145414 145414 13
771637 771637 104757 104757 PubChem (substance) 2 190092 190092 14
771638 771638 104757 104757 PubChem (substance) 2 250904 250904 18
1028527 1028527 104757 104757 CAS Common Chemistry 3 49226 49226 1
1231333 1231333 104757 104757 Computational Toxicology and Exposure Data 4 49226 49226 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 767.373ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website