api_results

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

10 rows where query_id = 52612

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
90655 90655 52612 52612 PubChem (compound) 1 48177 48177 1
424050 424050 52612 52612 PubChem (substance) 2 48177 48177 1
743907 743907 52612 52612 PubChem (substance) 2 160120 160120 2
743911 743911 52612 52612 PubChem (substance) 2 201292 201292 3
743912 743912 52612 52612 PubChem (substance) 2 199468 199468 4
743913 743913 52612 52612 PubChem (substance) 2 204114 204114 5
743914 743914 52612 52612 PubChem (substance) 2 205958 205958 6
743915 743915 52612 52612 PubChem (substance) 2 205929 205929 7
1005296 1005296 52612 52612 CAS Common Chemistry 3 48177 48177 1
1207194 1207194 52612 52612 Computational Toxicology and Exposure Data 4 100981 100981 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)
);