api_results

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

9 rows where query_id = 237832

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
240938 240938 237832 237832 PubChem (compound) 1 153704 153704 1
622125 622125 237832 237832 PubChem (substance) 2 153704 153704 1
753457 753457 237832 237832 PubChem (substance) 2 239268 239268 3
841484 841484 237832 237832 PubChem (substance) 2 259183 259183 2
841486 841486 237832 237832 PubChem (substance) 2 225733 225733 4
841488 841488 237832 237832 PubChem (substance) 2 233713 233713 5
841489 841489 237832 237832 PubChem (substance) 2 287938 287938 6
841490 841490 237832 237832 PubChem (substance) 2 223207 223207 7
841491 841491 237832 237832 PubChem (substance) 2 296618 296618 8 
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)
);