home / zeropm-v0-0-4

api_results

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

29 rows where inchi_id = 167

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
43383 43383 120783 120783 PubChem (compound) 1 167 167 1
43384 43384 102716 102716 PubChem (compound) 1 167 167 1
43385 43385 438652 438652 PubChem (compound) 1 167 167 1
43386 43386 19460 19460 PubChem (compound) 1 167 167 1
43387 43387 19461 19461 PubChem (compound) 1 167 167 1
283503 283503 403504 403504 PubChem (compound) 1 167 167 1
357324 357324 120783 120783 PubChem (substance) 2 167 167 1
357325 357325 19460 19460 PubChem (substance) 2 167 167 1
357326 357326 19461 19461 PubChem (substance) 2 167 167 1
357327 357327 438652 438652 PubChem (substance) 2 167 167 1
357328 357328 102716 102716 PubChem (substance) 2 167 167 1
676754 676754 438652 438652 PubChem (substance) 2 167 167 2
676755 676755 403504 403504 PubChem (substance) 2 167 167 1
676756 676756 102716 102716 PubChem (substance) 2 167 167 2
676757 676757 19460 19460 PubChem (substance) 2 167 167 2
676758 676758 19461 19461 PubChem (substance) 2 167 167 2
676759 676759 120783 120783 PubChem (substance) 2 167 167 2
969908 969908 403504 403504 CAS Common Chemistry 3 167 167 1
969909 969909 19460 19460 CAS Common Chemistry 3 167 167 1
969910 969910 120783 120783 CAS Common Chemistry 3 167 167 1
969911 969911 19461 19461 CAS Common Chemistry 3 167 167 1
969912 969912 438652 438652 CAS Common Chemistry 3 167 167 1
969913 969913 102716 102716 CAS Common Chemistry 3 167 167 1
1172142 1172142 120783 120783 Computational Toxicology and Exposure Data 4 167 167 1
1172143 1172143 102716 102716 Computational Toxicology and Exposure Data 4 167 167 1
1172144 1172144 19460 19460 Computational Toxicology and Exposure Data 4 167 167 1
1172145 1172145 19461 19461 Computational Toxicology and Exposure Data 4 167 167 1
1172146 1172146 403504 403504 Computational Toxicology and Exposure Data 4 167 167 1
1172147 1172147 438652 438652 Computational Toxicology and Exposure Data 4 167 167 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 451.054ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website