home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 67523

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22403 22403 67523 67523 PubChem (compound) 1 8748 8748 4
22420 22420 67523 67523 PubChem (compound) 1 136302 136302 3
27217 27217 67523 67523 PubChem (compound) 1 138100 138100 1
27221 27221 67523 67523 PubChem (compound) 1 91910 91910 2
105433 105433 67523 67523 PubChem (compound) 1 169133 169133 5
105434 105434 67523 67523 PubChem (compound) 1 198625 198625 6
327827 327827 67523 67523 PubChem (substance) 2 8748 8748 4
327858 327858 67523 67523 PubChem (substance) 2 136302 136302 3
334508 334508 67523 67523 PubChem (substance) 2 138100 138100 1
334517 334517 67523 67523 PubChem (substance) 2 91910 91910 2
334526 334526 67523 67523 PubChem (substance) 2 218160 218160 16
444904 444904 67523 67523 PubChem (substance) 2 169133 169133 6
444906 444906 67523 67523 PubChem (substance) 2 198625 198625 7
710910 710910 67523 67523 PubChem (substance) 2 47902 47902 5
710916 710916 67523 67523 PubChem (substance) 2 253221 253221 17
710922 710922 67523 67523 PubChem (substance) 2 191920 191920 10
710929 710929 67523 67523 PubChem (substance) 2 198142 198142 11
710934 710934 67523 67523 PubChem (substance) 2 198143 198143 12
710942 710942 67523 67523 PubChem (substance) 2 206967 206967 13
710950 710950 67523 67523 PubChem (substance) 2 206968 206968 14
710958 710958 67523 67523 PubChem (substance) 2 207043 207043 15
755355 755355 67523 67523 PubChem (substance) 2 186263 186263 8
755356 755356 67523 67523 PubChem (substance) 2 270443 270443 9
958142 958142 67523 67523 CAS Common Chemistry 3 47902 47902 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 1100.356ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website