api_results

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

10 rows where inchi_id = 140554

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
260431 260431 317250 317250 PubChem (compound) 1 140554 140554 1
645387 645387 27621 27621 PubChem (substance) 2 140554 140554 3
645388 645388 7469 7469 PubChem (substance) 2 140554 140554 3
645389 645389 84648 84648 PubChem (substance) 2 140554 140554 2
645390 645390 370963 370963 PubChem (substance) 2 140554 140554 3
645391 645391 19959 19959 PubChem (substance) 2 140554 140554 2
645392 645392 317250 317250 PubChem (substance) 2 140554 140554 1
645393 645393 7470 7470 PubChem (substance) 2 140554 140554 3
645394 645394 79151 79151 PubChem (substance) 2 140554 140554 3
645395 645395 351089 351089 PubChem (substance) 2 140554 140554 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)
);