api_results

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

9 rows where query_id = 335739

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
263666 263666 335739 335739 PubChem (compound) 1 203775 203775 1
650070 650070 335739 335739 PubChem (substance) 2 203775 203775 1
650449 650449 335739 335739 PubChem (substance) 2 164863 164863 2
910492 910492 335739 335739 PubChem (substance) 2 240653 240653 3
910493 910493 335739 335739 PubChem (substance) 2 261991 261991 4
910494 910494 335739 335739 PubChem (substance) 2 291221 291221 5
910495 910495 335739 335739 PubChem (substance) 2 309828 309828 6
910496 910496 335739 335739 PubChem (substance) 2 334600 334600 7
1326524 1326524 335739 335739 Computational Toxicology and Exposure Data 4 131229 131229 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)
);