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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
9916 9916 100065 100065 PubChem (compound) 1 52074 52074 1
9923 9923 100065 100065 PubChem (compound) 1 119540 119540 2
17528 17528 100065 100065 PubChem (compound) 1 1568 1568 3
122398 122398 100065 100065 PubChem (compound) 1 25826 25826 4
122399 122399 100065 100065 PubChem (compound) 1 295039 295039 5
309404 309404 100065 100065 PubChem (substance) 2 52074 52074 1
309419 309419 100065 100065 PubChem (substance) 2 119540 119540 2
320423 320423 100065 100065 PubChem (substance) 2 1568 1568 3
322408 322408 100065 100065 PubChem (substance) 2 9134 9134 6
468292 468292 100065 100065 PubChem (substance) 2 25826 25826 4
468297 468297 100065 100065 PubChem (substance) 2 295039 295039 8
666571 666571 100065 100065 PubChem (substance) 2 129471 129471 5
699321 699321 100065 100065 PubChem (substance) 2 232415 232415 7
945470 945470 100065 100065 CAS Common Chemistry 3 52074 52074 1
1143449 1143449 100065 100065 Computational Toxicology and Exposure Data 4 52074 52074 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 450.984ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website