api_results

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

20 rows where inchi_id = 9857

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
98247 98247 58438 58438 PubChem (compound) 1 9857 9857 1
98248 98248 58439 58439 PubChem (compound) 1 9857 9857 1
98249 98249 437260 437260 PubChem (compound) 1 9857 9857 1
98250 98250 109906 109906 PubChem (compound) 1 9857 9857 1
434552 434552 58439 58439 PubChem (substance) 2 9857 9857 1
434553 434553 58438 58438 PubChem (substance) 2 9857 9857 1
434554 434554 107000 107000 PubChem (substance) 2 9857 9857 3
434555 434555 109906 109906 PubChem (substance) 2 9857 9857 1
434556 434556 437260 437260 PubChem (substance) 2 9857 9857 1
748754 748754 58438 58438 PubChem (substance) 2 9857 9857 3
748755 748755 58438 58438 PubChem (substance) 2 9857 9857 4
748756 748756 109906 109906 PubChem (substance) 2 9857 9857 3
1010802 1010802 109906 109906 CAS Common Chemistry 3 9857 9857 1
1010803 1010803 58439 58439 CAS Common Chemistry 3 9857 9857 1
1010804 1010804 437260 437260 CAS Common Chemistry 3 9857 9857 1
1010805 1010805 58438 58438 CAS Common Chemistry 3 9857 9857 1
1212890 1212890 58438 58438 Computational Toxicology and Exposure Data 4 9857 9857 1
1212891 1212891 109906 109906 Computational Toxicology and Exposure Data 4 9857 9857 1
1212892 1212892 437260 437260 Computational Toxicology and Exposure Data 4 9857 9857 1
1212893 1212893 58439 58439 Computational Toxicology and Exposure Data 4 9857 9857 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)
);