home / zeropm-v0-0-4

api_results

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

15 rows where query_id = 376793

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
270279 270279 376793 376793 PubChem (compound) 1 5754 5754 1
357969 357969 376793 376793 PubChem (substance) 2 4112 4112 8
660144 660144 376793 376793 PubChem (substance) 2 4436 4436 6
660149 660149 376793 376793 PubChem (substance) 2 5754 5754 1
660267 660267 376793 376793 PubChem (substance) 2 5755 5755 10
670922 670922 376793 376793 PubChem (substance) 2 9567 9567 2
920376 920376 376793 376793 PubChem (substance) 2 241895 241895 3
920377 920377 376793 376793 PubChem (substance) 2 206034 206034 4
920379 920379 376793 376793 PubChem (substance) 2 239221 239221 5
920381 920381 376793 376793 PubChem (substance) 2 5754 5754 7
920382 920382 376793 376793 PubChem (substance) 2 236996 236996 9
920383 920383 376793 376793 PubChem (substance) 2 225322 225322 11
920384 920384 376793 376793 PubChem (substance) 2 5754 5754 12
1118219 1118219 376793 376793 CAS Common Chemistry 3 5754 5754 1
1329968 1329968 376793 376793 Computational Toxicology and Exposure Data 4 5754 5754 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 665.338ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website