home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 349645

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
12384 12384 349645 349645 PubChem (compound) 1 3193 3193 1
302061 302061 349645 349645 PubChem (substance) 2 3191 3191 10
312101 312101 349645 349645 PubChem (substance) 2 9870 9870 11
313115 313115 349645 349645 PubChem (substance) 2 3193 3193 1
314646 314646 349645 349645 PubChem (substance) 2 83480 83480 15
323447 323447 349645 349645 PubChem (substance) 2 90718 90718 18
369928 369928 349645 349645 PubChem (substance) 2 42021 42021 12
530701 530701 349645 349645 PubChem (substance) 2 8236 8236 2
542533 542533 349645 349645 PubChem (substance) 2 19291 19291 14
654442 654442 349645 349645 PubChem (substance) 2 133647 133647 5
701115 701115 349645 349645 PubChem (substance) 2 157575 157575 16
701119 701119 349645 349645 PubChem (substance) 2 170848 170848 3
701123 701123 349645 349645 PubChem (substance) 2 169925 169925 4
701125 701125 349645 349645 PubChem (substance) 2 168038 168038 6
701128 701128 349645 349645 PubChem (substance) 2 204830 204830 7
701132 701132 349645 349645 PubChem (substance) 2 205252 205252 8
701134 701134 349645 349645 PubChem (substance) 2 204213 204213 9
701138 701138 349645 349645 PubChem (substance) 2 147812 147812 13
701143 701143 349645 349645 PubChem (substance) 2 173008 173008 17
947336 947336 349645 349645 CAS Common Chemistry 3 3193 3193 1
1145651 1145651 349645 349645 Computational Toxicology and Exposure Data 4 3193 3193 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.786ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website