api_results

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

9 rows where query_id = 130718

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
150815 150815 130718 130718 PubChem (compound) 1 32233 32233 1
506331 506331 130718 130718 PubChem (substance) 2 32233 32233 1
792445 792445 130718 130718 PubChem (substance) 2 157429 157429 2
792447 792447 130718 130718 PubChem (substance) 2 141583 141583 4
792453 792453 130718 130718 PubChem (substance) 2 32233 32233 3
792455 792455 130718 130718 PubChem (substance) 2 322733 322733 5
792456 792456 130718 130718 PubChem (substance) 2 208721 208721 6
1048352 1048352 130718 130718 CAS Common Chemistry 3 32233 32233 1
1251185 1251185 130718 130718 Computational Toxicology and Exposure Data 4 32233 32233 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)
);