api_results

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

15 rows where inchi_id = 137874

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
18654 18654 9845 9845 PubChem (compound) 1 137874 137874 1
18655 18655 9846 9846 PubChem (compound) 1 137874 137874 1
18656 18656 110902 110902 PubChem (compound) 1 137874 137874 1
18657 18657 404664 404664 PubChem (compound) 1 137874 137874 1
18658 18658 100787 100787 PubChem (compound) 1 137874 137874 1
322024 322024 9845 9845 PubChem (substance) 2 137874 137874 1
322025 322025 404664 404664 PubChem (substance) 2 137874 137874 1
322026 322026 9846 9846 PubChem (substance) 2 137874 137874 1
322027 322027 110902 110902 PubChem (substance) 2 137874 137874 1
322028 322028 100787 100787 PubChem (substance) 2 137874 137874 1
322029 322029 355175 355175 PubChem (substance) 2 137874 137874 3
322030 322030 336949 336949 PubChem (substance) 2 137874 137874 1
705177 705177 9845 9845 PubChem (substance) 2 137874 137874 2
705178 705178 21366 21366 PubChem (substance) 2 137874 137874 4
705179 705179 125718 125718 PubChem (substance) 2 137874 137874 2 
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)
);