api_results

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

10 rows where inchi_id = 24071

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
48151 48151 21709 21709 PubChem (compound) 1 24071 24071 2
48152 48152 92004 92004 PubChem (compound) 1 24071 24071 2
364289 364289 21709 21709 PubChem (substance) 2 24071 24071 4
364290 364290 92004 92004 PubChem (substance) 2 24071 24071 4
973113 973113 92004 92004 CAS Common Chemistry 3 24071 24071 1
973114 973114 21709 21709 CAS Common Chemistry 3 24071 24071 1
973115 973115 301820 301820 CAS Common Chemistry 3 24071 24071 1
973116 973116 55687 55687 CAS Common Chemistry 3 24071 24071 1
973117 973117 409812 409812 CAS Common Chemistry 3 24071 24071 1
973118 973118 356049 356049 CAS Common Chemistry 3 24071 24071 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)
);