api_results

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

10 rows where query_id = 381609

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
273417 273417 381609 381609 PubChem (compound) 1 110282 110282 1
663985 663985 381609 381609 PubChem (substance) 2 110282 110282 1
694251 694251 381609 381609 PubChem (substance) 2 212355 212355 2
923096 923096 381609 381609 PubChem (substance) 2 320405 320405 3
923097 923097 381609 381609 PubChem (substance) 2 279162 279162 4
923098 923098 381609 381609 PubChem (substance) 2 237216 237216 5
923099 923099 381609 381609 PubChem (substance) 2 237280 237280 6
923100 923100 381609 381609 PubChem (substance) 2 255292 255292 7
923101 923101 381609 381609 PubChem (substance) 2 334576 334576 8
1332314 1332314 381609 381609 Computational Toxicology and Exposure Data 4 110282 110282 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)
);