home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 118488

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102481 102481 118488 118488 PubChem (compound) 1 73748 73748 1
440738 440738 118488 118488 PubChem (substance) 2 73748 73748 1
676057 676057 118488 118488 PubChem (substance) 2 185836 185836 9
676083 676083 118488 118488 PubChem (substance) 2 22218 22218 11
676087 676087 118488 118488 PubChem (substance) 2 136280 136280 2
676097 676097 118488 118488 PubChem (substance) 2 185837 185837 10
752520 752520 118488 118488 PubChem (substance) 2 186822 186822 4
752521 752521 118488 118488 PubChem (substance) 2 149657 149657 3
752526 752526 118488 118488 PubChem (substance) 2 192594 192594 5
752532 752532 118488 118488 PubChem (substance) 2 321400 321400 16
783688 783688 118488 118488 PubChem (substance) 2 206725 206725 6
783689 783689 118488 118488 PubChem (substance) 2 202059 202059 7
783690 783690 118488 118488 PubChem (substance) 2 199440 199440 8
783691 783691 118488 118488 PubChem (substance) 2 205797 205797 12
783692 783692 118488 118488 PubChem (substance) 2 195407 195407 13
783693 783693 118488 118488 PubChem (substance) 2 195544 195544 14
783694 783694 118488 118488 PubChem (substance) 2 173414 173414 15
783695 783695 118488 118488 PubChem (substance) 2 215403 215403 17
1013601 1013601 118488 118488 CAS Common Chemistry 3 73748 73748 1
1215774 1215774 118488 118488 Computational Toxicology and Exposure Data 4 73748 73748 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 713.862ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website