api_results

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

14 rows where inchi_id = 181557

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
119654 119654 314867 314867 PubChem (compound) 1 181557 181557 1
119655 119655 94538 94538 PubChem (compound) 1 181557 181557 1
464334 464334 84886 84886 PubChem (substance) 2 181557 181557 2
464335 464335 8774 8774 PubChem (substance) 2 181557 181557 3
464336 464336 94537 94537 PubChem (substance) 2 181557 181557 1
464337 464337 323072 323072 PubChem (substance) 2 181557 181557 2
464338 464338 94538 94538 PubChem (substance) 2 181557 181557 1
464339 464339 346534 346534 PubChem (substance) 2 181557 181557 2
464340 464340 293589 293589 PubChem (substance) 2 181557 181557 2
464341 464341 346535 346535 PubChem (substance) 2 181557 181557 2
464342 464342 158141 158141 PubChem (substance) 2 181557 181557 2
464343 464343 319931 319931 PubChem (substance) 2 181557 181557 2
464344 464344 146412 146412 PubChem (substance) 2 181557 181557 2
464345 464345 314867 314867 PubChem (substance) 2 181557 181557 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)
);