home / zeropm-v0-0-4

api_results

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

27 rows where query_id = 87234

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
115578 115578 87234 87234 PubChem (compound) 1 73021 73021 1
458763 458763 87234 87234 PubChem (substance) 2 73021 73021 1
483776 483776 87234 87234 PubChem (substance) 2 177126 177126 24
763743 763743 87234 87234 PubChem (substance) 2 136833 136833 2
763745 763745 87234 87234 PubChem (substance) 2 233670 233670 3
763746 763746 87234 87234 PubChem (substance) 2 189213 189213 5
763750 763750 87234 87234 PubChem (substance) 2 326693 326693 19
763753 763753 87234 87234 PubChem (substance) 2 169544 169544 8
763757 763757 87234 87234 PubChem (substance) 2 206004 206004 7
763758 763758 87234 87234 PubChem (substance) 2 199940 199940 6
763764 763764 87234 87234 PubChem (substance) 2 237226 237226 4
763767 763767 87234 87234 PubChem (substance) 2 234343 234343 20
763770 763770 87234 87234 PubChem (substance) 2 309854 309854 22
763774 763774 87234 87234 PubChem (substance) 2 232239 232239 9
763775 763775 87234 87234 PubChem (substance) 2 202175 202175 10
763776 763776 87234 87234 PubChem (substance) 2 200834 200834 11
763777 763777 87234 87234 PubChem (substance) 2 202590 202590 12
763778 763778 87234 87234 PubChem (substance) 2 195314 195314 13
763779 763779 87234 87234 PubChem (substance) 2 195542 195542 14
763780 763780 87234 87234 PubChem (substance) 2 200110 200110 15
763781 763781 87234 87234 PubChem (substance) 2 202722 202722 16
763782 763782 87234 87234 PubChem (substance) 2 195707 195707 17
763783 763783 87234 87234 PubChem (substance) 2 246955 246955 18
763784 763784 87234 87234 PubChem (substance) 2 308240 308240 21
763785 763785 87234 87234 PubChem (substance) 2 210040 210040 23
1022622 1022622 87234 87234 CAS Common Chemistry 3 73021 73021 1
1224991 1224991 87234 87234 Computational Toxicology and Exposure Data 4 73021 73021 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 1342.219ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website