api_results

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

25 rows where inchi_id = 38

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
15924 15924 8518 8518 PubChem (compound) 1 38 38 1
15925 15925 8520 8520 PubChem (compound) 1 38 38 1
15926 15926 8519 8519 PubChem (compound) 1 38 38 1
15927 15927 101556 101556 PubChem (compound) 1 38 38 1
15928 15928 323059 323059 PubChem (compound) 1 38 38 1
15929 15929 346524 346524 PubChem (compound) 1 38 38 1
15930 15930 323060 323060 PubChem (compound) 1 38 38 1
15931 15931 320012 320012 PubChem (compound) 1 38 38 1
15932 15932 230779 230779 PubChem (compound) 1 38 38 1
318016 318016 8518 8518 PubChem (substance) 2 38 38 1
318017 318017 8520 8520 PubChem (substance) 2 38 38 1
318018 318018 101556 101556 PubChem (substance) 2 38 38 1
318019 318019 8519 8519 PubChem (substance) 2 38 38 1
318020 318020 323059 323059 PubChem (substance) 2 38 38 1
318021 318021 230779 230779 PubChem (substance) 2 38 38 1
318022 318022 323060 323060 PubChem (substance) 2 38 38 1
318023 318023 320012 320012 PubChem (substance) 2 38 38 1
318024 318024 346524 346524 PubChem (substance) 2 38 38 1
950052 950052 8520 8520 CAS Common Chemistry 3 38 38 1
950053 950053 320012 320012 CAS Common Chemistry 3 38 38 1
950054 950054 8519 8519 CAS Common Chemistry 3 38 38 1
950055 950055 8518 8518 CAS Common Chemistry 3 38 38 1
950056 950056 101556 101556 CAS Common Chemistry 3 38 38 1
950057 950057 346524 346524 CAS Common Chemistry 3 38 38 1
950058 950058 323060 323060 CAS Common Chemistry 3 38 38 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)
);