api_results

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

13 rows where query_id = 408362

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
284096 284096 408362 408362 PubChem (compound) 1 227657 227657 1
284098 284098 408362 408362 PubChem (compound) 1 227657 227657 2
284099 284099 408362 408362 PubChem (compound) 1 297485 297485 3
284100 284100 408362 408362 PubChem (compound) 1 228658 228658 4
284101 284101 408362 408362 PubChem (compound) 1 228658 228658 5
341386 341386 408362 408362 PubChem (substance) 2 212057 212057 5
677729 677729 408362 408362 PubChem (substance) 2 227657 227657 1
677731 677731 408362 408362 PubChem (substance) 2 227657 227657 2
677732 677732 408362 408362 PubChem (substance) 2 297485 297485 3
677733 677733 408362 408362 PubChem (substance) 2 228658 228658 4
677734 677734 408362 408362 PubChem (substance) 2 228658 228658 6
1125481 1125481 408362 408362 CAS Common Chemistry 3 77711 77711 1
1339805 1339805 408362 408362 Computational Toxicology and Exposure Data 4 114644 114644 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)
);