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 = 47700

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
122820 122820 137384 137384 PubChem (compound) 1 47700 47700 1
122821 122821 100845 100845 PubChem (compound) 1 47700 47700 1
122822 122822 100843 100843 PubChem (compound) 1 47700 47700 1
122823 122823 100844 100844 PubChem (compound) 1 47700 47700 1
122824 122824 411815 411815 PubChem (compound) 1 47700 47700 1
468920 468920 347903 347903 PubChem (substance) 2 47700 47700 6
468921 468921 100843 100843 PubChem (substance) 2 47700 47700 1
468922 468922 137384 137384 PubChem (substance) 2 47700 47700 1
468923 468923 4160 4160 PubChem (substance) 2 47700 47700 6
468924 468924 108109 108109 PubChem (substance) 2 47700 47700 6
468925 468925 100845 100845 PubChem (substance) 2 47700 47700 1
468926 468926 100844 100844 PubChem (substance) 2 47700 47700 1
468927 468927 411815 411815 PubChem (substance) 2 47700 47700 1
1027364 1027364 137384 137384 CAS Common Chemistry 3 47700 47700 1
1027365 1027365 100843 100843 CAS Common Chemistry 3 47700 47700 1
1027366 1027366 100844 100844 CAS Common Chemistry 3 47700 47700 1
1027367 1027367 411815 411815 CAS Common Chemistry 3 47700 47700 1
1027368 1027368 100845 100845 CAS Common Chemistry 3 47700 47700 1
1230081 1230081 100843 100843 Computational Toxicology and Exposure Data 4 47700 47700 1
1230082 1230082 411815 411815 Computational Toxicology and Exposure Data 4 47700 47700 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 1383.567ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website