api_results

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

12 rows where inchi_id = 71951

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
164148 164148 144033 144033 PubChem (compound) 1 71951 71951 1
164149 164149 144032 144032 PubChem (compound) 1 71951 71951 1
164150 164150 413037 413037 PubChem (compound) 1 71951 71951 1
523718 523718 144033 144033 PubChem (substance) 2 71951 71951 1
523719 523719 144032 144032 PubChem (substance) 2 71951 71951 1
523720 523720 323901 323901 PubChem (substance) 2 71951 71951 9366
523721 523721 413037 413037 PubChem (substance) 2 71951 71951 1
1058302 1058302 144032 144032 CAS Common Chemistry 3 71951 71951 1
1058303 1058303 413037 413037 CAS Common Chemistry 3 71951 71951 1
1260875 1260875 413037 413037 Computational Toxicology and Exposure Data 4 71951 71951 1
1260876 1260876 144033 144033 Computational Toxicology and Exposure Data 4 71951 71951 1
1260877 1260877 144032 144032 Computational Toxicology and Exposure Data 4 71951 71951 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)
);