home / zeropm-v0-0-4

api_results

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

18 rows where query_id = 157219

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
55904 55904 157219 157219 PubChem (compound) 1 130559 130559 1
99506 99506 157219 157219 PubChem (compound) 1 109130 109130 2
99511 99511 157219 157219 PubChem (compound) 1 270968 270968 4
176493 176493 157219 157219 PubChem (compound) 1 145660 145660 3
374725 374725 157219 157219 PubChem (substance) 2 130559 130559 2
374731 374731 157219 157219 PubChem (substance) 2 130559 130559 3
374734 374734 157219 157219 PubChem (substance) 2 216106 216106 7
436402 436402 157219 157219 PubChem (substance) 2 109130 109130 1
436404 436404 157219 157219 PubChem (substance) 2 276590 276590 12
436409 436409 157219 157219 PubChem (substance) 2 270968 270968 5
540382 540382 157219 157219 PubChem (substance) 2 145660 145660 4
724891 724891 157219 157219 PubChem (substance) 2 248146 248146 6
724894 724894 157219 157219 PubChem (substance) 2 276591 276591 9
724895 724895 157219 157219 PubChem (substance) 2 253117 253117 8
749761 749761 157219 157219 PubChem (substance) 2 126800 126800 11
810168 810168 157219 157219 PubChem (substance) 2 109130 109130 10
1011625 1011625 157219 157219 CAS Common Chemistry 3 30788 30788 1
1213714 1213714 157219 157219 Computational Toxicology and Exposure Data 4 109130 109130 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 420.933ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website