home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 37431

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
152965 152965 311567 311567 PubChem (compound) 1 37431 37431 1
152966 152966 132911 132911 PubChem (compound) 1 37431 37431 1
152967 152967 132912 132912 PubChem (compound) 1 37431 37431 1
152968 152968 410959 410959 PubChem (compound) 1 37431 37431 1
509157 509157 410959 410959 PubChem (substance) 2 37431 37431 1
509158 509158 132911 132911 PubChem (substance) 2 37431 37431 1
509159 509159 132912 132912 PubChem (substance) 2 37431 37431 1
509160 509160 311567 311567 PubChem (substance) 2 37431 37431 1
793823 793823 132911 132911 PubChem (substance) 2 37431 37431 3
793824 793824 132912 132912 PubChem (substance) 2 37431 37431 3
793825 793825 410959 410959 PubChem (substance) 2 37431 37431 3
793826 793826 311567 311567 PubChem (substance) 2 37431 37431 3
1049957 1049957 410959 410959 CAS Common Chemistry 3 37431 37431 1
1049958 1049958 311567 311567 CAS Common Chemistry 3 37431 37431 1
1049959 1049959 132912 132912 CAS Common Chemistry 3 37431 37431 1
1049960 1049960 132911 132911 CAS Common Chemistry 3 37431 37431 1
1252726 1252726 311567 311567 Computational Toxicology and Exposure Data 4 37431 37431 1
1252727 1252727 132911 132911 Computational Toxicology and Exposure Data 4 37431 37431 1
1252728 1252728 132912 132912 Computational Toxicology and Exposure Data 4 37431 37431 1
1252729 1252729 410959 410959 Computational Toxicology and Exposure Data 4 37431 37431 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 2507.126ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website