home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 147223

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96935 96935 57435 57435 PubChem (compound) 1 147223 147223 1
96936 96936 60812 60812 PubChem (compound) 1 147223 147223 1
96937 96937 96727 96727 PubChem (compound) 1 147223 147223 1
96938 96938 327469 327469 PubChem (compound) 1 147223 147223 1
96939 96939 57435 57435 PubChem (compound) 1 147223 147223 2
96940 96940 180241 180241 PubChem (compound) 1 147223 147223 1
96941 96941 60813 60813 PubChem (compound) 1 147223 147223 1
432731 432731 25980 25980 PubChem (substance) 2 147223 147223 6
432732 432732 180241 180241 PubChem (substance) 2 147223 147223 2
432733 432733 57435 57435 PubChem (substance) 2 147223 147223 1
432734 432734 57436 57436 PubChem (substance) 2 147223 147223 3
432735 432735 60813 60813 PubChem (substance) 2 147223 147223 2
432736 432736 122158 122158 PubChem (substance) 2 147223 147223 3
432737 432737 327469 327469 PubChem (substance) 2 147223 147223 2
432738 432738 21486 21486 PubChem (substance) 2 147223 147223 10
432739 432739 57435 57435 PubChem (substance) 2 147223 147223 2
432740 432740 105119 105119 PubChem (substance) 2 147223 147223 1
432741 432741 96727 96727 PubChem (substance) 2 147223 147223 1
432742 432742 327469 327469 PubChem (substance) 2 147223 147223 1
432743 432743 329251 329251 PubChem (substance) 2 147223 147223 9
432744 432744 180241 180241 PubChem (substance) 2 147223 147223 1
432745 432745 60812 60812 PubChem (substance) 2 147223 147223 1
432746 432746 60813 60813 PubChem (substance) 2 147223 147223 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 2238.955ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website