home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 50141

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54560 54560 24645 24645 PubChem (compound) 1 50141 50141 1
54561 54561 24646 24646 PubChem (compound) 1 50141 50141 1
54562 54562 138449 138449 PubChem (compound) 1 50141 50141 1
54563 54563 363170 363170 PubChem (compound) 1 50141 50141 1
372833 372833 24645 24645 PubChem (substance) 2 50141 50141 1
372834 372834 294916 294916 PubChem (substance) 2 50141 50141 1
372835 372835 363170 363170 PubChem (substance) 2 50141 50141 1
372836 372836 24646 24646 PubChem (substance) 2 50141 50141 1
372837 372837 99454 99454 PubChem (substance) 2 50141 50141 1
372838 372838 363172 363172 PubChem (substance) 2 50141 50141 1
372839 372839 83705 83705 PubChem (substance) 2 50141 50141 2
372840 372840 138449 138449 PubChem (substance) 2 50141 50141 1
372841 372841 363169 363169 PubChem (substance) 2 50141 50141 1
978050 978050 24645 24645 CAS Common Chemistry 3 50141 50141 1
978051 978051 363172 363172 CAS Common Chemistry 3 50141 50141 1
978052 978052 294916 294916 CAS Common Chemistry 3 50141 50141 1
978053 978053 83705 83705 CAS Common Chemistry 3 50141 50141 1
978054 978054 363169 363169 CAS Common Chemistry 3 50141 50141 1
978055 978055 99454 99454 CAS Common Chemistry 3 50141 50141 1
978056 978056 363170 363170 CAS Common Chemistry 3 50141 50141 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)
);
Powered by Datasette · Queries took 780.284ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website