api_results

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

11 rows where query_id = 92428

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
31811 31811 92428 92428 PubChem (compound) 1 119555 119555 1
31819 31819 92428 92428 PubChem (compound) 1 258451 258451 4
31825 31825 92428 92428 PubChem (compound) 1 212213 212213 3
118457 118457 92428 92428 PubChem (compound) 1 188050 188050 2
340868 340868 92428 92428 PubChem (substance) 2 119555 119555 1
340873 340873 92428 92428 PubChem (substance) 2 258451 258451 7
340882 340882 92428 92428 PubChem (substance) 2 192603 192603 5
340884 340884 92428 92428 PubChem (substance) 2 212213 212213 6
462808 462808 92428 92428 PubChem (substance) 2 188050 188050 2
712805 712805 92428 92428 PubChem (substance) 2 247521 247521 4
712812 712812 92428 92428 PubChem (substance) 2 167912 167912 3 
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)
);