home / zeropm-v0-0-4

api_results

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

26 rows where query_id = 171742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
140546 140546 171742 171742 PubChem (compound) 1 111443 111443 1
190417 190417 171742 171742 PubChem (compound) 1 170805 170805 2
190418 190418 171742 171742 PubChem (compound) 1 216196 216196 3
190419 190419 171742 171742 PubChem (compound) 1 240423 240423 4
492818 492818 171742 171742 PubChem (substance) 2 111443 111443 1
558453 558453 171742 171742 PubChem (substance) 2 170805 170805 2
558456 558456 171742 171742 PubChem (substance) 2 216196 216196 3
558459 558459 171742 171742 PubChem (substance) 2 240423 240423 4
785379 785379 171742 171742 PubChem (substance) 2 183190 183190 10
818689 818689 171742 171742 PubChem (substance) 2 239194 239194 5
818690 818690 171742 171742 PubChem (substance) 2 34976 34976 6
818691 818691 171742 171742 PubChem (substance) 2 276388 276388 7
818692 818692 171742 171742 PubChem (substance) 2 239194 239194 8
818693 818693 171742 171742 PubChem (substance) 2 292548 292548 9
818694 818694 171742 171742 PubChem (substance) 2 280846 280846 11
818695 818695 171742 171742 PubChem (substance) 2 275728 275728 12
818696 818696 171742 171742 PubChem (substance) 2 292680 292680 13
818697 818697 171742 171742 PubChem (substance) 2 294492 294492 14
818698 818698 171742 171742 PubChem (substance) 2 297605 297605 15
818699 818699 171742 171742 PubChem (substance) 2 307911 307911 16
818700 818700 171742 171742 PubChem (substance) 2 309860 309860 17
818701 818701 171742 171742 PubChem (substance) 2 321403 321403 18
818702 818702 171742 171742 PubChem (substance) 2 265198 265198 19
818703 818703 171742 171742 PubChem (substance) 2 294829 294829 20
1077323 1077323 171742 171742 CAS Common Chemistry 3 34976 34976 1
1278733 1278733 171742 171742 Computational Toxicology and Exposure Data 4 111443 111443 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 488.73ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website