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

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
264889 264889 340067 340067 PubChem (compound) 1 51679 51679 1
264890 264890 340067 340067 PubChem (compound) 1 224086 224086 2
264891 264891 340067 340067 PubChem (compound) 1 139441 139441 3
264892 264892 340067 340067 PubChem (compound) 1 149743 149743 4
264893 264893 340067 340067 PubChem (compound) 1 289590 289590 5
264894 264894 340067 340067 PubChem (compound) 1 320483 320483 6
264895 264895 340067 340067 PubChem (compound) 1 309940 309940 7
652198 652198 340067 340067 PubChem (substance) 2 51679 51679 1
652202 652202 340067 340067 PubChem (substance) 2 224086 224086 2
652210 652210 340067 340067 PubChem (substance) 2 139441 139441 3
652215 652215 340067 340067 PubChem (substance) 2 149743 149743 4
652216 652216 340067 340067 PubChem (substance) 2 289590 289590 8
652217 652217 340067 340067 PubChem (substance) 2 320483 320483 9
652218 652218 340067 340067 PubChem (substance) 2 309940 309940 16
652225 652225 340067 340067 PubChem (substance) 2 51711 51711 15
652226 652226 340067 340067 PubChem (substance) 2 149744 149744 10
652233 652233 340067 340067 PubChem (substance) 2 232294 232294 17
912630 912630 340067 340067 PubChem (substance) 2 259290 259290 5
912631 912631 340067 340067 PubChem (substance) 2 240280 240280 6
912632 912632 340067 340067 PubChem (substance) 2 51679 51679 7
912633 912633 340067 340067 PubChem (substance) 2 224086 224086 11
912634 912634 340067 340067 PubChem (substance) 2 167647 167647 12
912635 912635 340067 340067 PubChem (substance) 2 288176 288176 13
912636 912636 340067 340067 PubChem (substance) 2 273961 273961 14
1115502 1115502 340067 340067 CAS Common Chemistry 3 51679 51679 1
1327289 1327289 340067 340067 Computational Toxicology and Exposure Data 4 51679 51679 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 416.983ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website