home / zeropm-v0-0-4

api_results

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

9 rows where inchi_id = 7795

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
266613 266613 350990 350990 PubChem (compound) 1 7795 7795 5
655178 655178 15851 15851 PubChem (substance) 2 7795 7795 2
655179 655179 350990 350990 PubChem (substance) 2 7795 7795 7
962901 962901 437210 437210 CAS Common Chemistry 3 7795 7795 1
962902 962902 15851 15851 CAS Common Chemistry 3 7795 7795 1
962903 962903 350991 350991 CAS Common Chemistry 3 7795 7795 1
962904 962904 15852 15852 CAS Common Chemistry 3 7795 7795 1
962905 962905 406696 406696 CAS Common Chemistry 3 7795 7795 1
962906 962906 350990 350990 CAS Common Chemistry 3 7795 7795 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 489.223ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website