home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 38423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
102588 102588 62234 62234 PubChem (compound) 1 38423 38423 1
102589 102589 91451 91451 PubChem (compound) 1 38423 38423 1
102590 102590 62235 62235 PubChem (compound) 1 38423 38423 1
102591 102591 133338 133338 PubChem (compound) 1 38423 38423 1
440876 440876 14931 14931 PubChem (substance) 2 38423 38423 3
440877 440877 91451 91451 PubChem (substance) 2 38423 38423 1
440878 440878 62234 62234 PubChem (substance) 2 38423 38423 1
440879 440879 98225 98225 PubChem (substance) 2 38423 38423 2
440880 440880 62235 62235 PubChem (substance) 2 38423 38423 1
440881 440881 85676 85676 PubChem (substance) 2 38423 38423 3
440882 440882 133338 133338 PubChem (substance) 2 38423 38423 1
440883 440883 108499 108499 PubChem (substance) 2 38423 38423 2
1013678 1013678 62234 62234 CAS Common Chemistry 3 38423 38423 1
1013679 1013679 91451 91451 CAS Common Chemistry 3 38423 38423 1
1013680 1013680 133338 133338 CAS Common Chemistry 3 38423 38423 1
1013681 1013681 62235 62235 CAS Common Chemistry 3 38423 38423 1
1215843 1215843 62235 62235 Computational Toxicology and Exposure Data 4 38423 38423 1
1215844 1215844 62234 62234 Computational Toxicology and Exposure Data 4 38423 38423 1
1215845 1215845 133338 133338 Computational Toxicology and Exposure Data 4 38423 38423 1
1215846 1215846 91451 91451 Computational Toxicology and Exposure Data 4 38423 38423 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)
);
Powered by Datasette · Queries took 2080.447ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website