api_results

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

16 rows where inchi_id = 20142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
68346 68346 32893 32893 PubChem (compound) 1 20142 20142 1
68347 68347 355226 355226 PubChem (compound) 1 20142 20142 1
68348 68348 92420 92420 PubChem (compound) 1 20142 20142 1
68349 68349 334303 334303 PubChem (compound) 1 20142 20142 1
393032 393032 32893 32893 PubChem (substance) 2 20142 20142 1
393033 393033 92420 92420 PubChem (substance) 2 20142 20142 1
393034 393034 56958 56958 PubChem (substance) 2 20142 20142 1
393035 393035 355226 355226 PubChem (substance) 2 20142 20142 1
393036 393036 334303 334303 PubChem (substance) 2 20142 20142 1
393037 393037 32894 32894 PubChem (substance) 2 20142 20142 1
988657 988657 32893 32893 CAS Common Chemistry 3 20142 20142 1
988658 988658 56958 56958 CAS Common Chemistry 3 20142 20142 1
988659 988659 334303 334303 CAS Common Chemistry 3 20142 20142 1
1191515 1191515 32893 32893 Computational Toxicology and Exposure Data 4 20142 20142 1
1191516 1191516 404218 404218 Computational Toxicology and Exposure Data 4 20142 20142 1
1191517 1191517 334303 334303 Computational Toxicology and Exposure Data 4 20142 20142 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)
);