home / zeropm-v0-0-4

api_results

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

25 rows where inchi_id = 29686

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
107607 107607 71561 71561 PubChem (compound) 1 29686 29686 1
107608 107608 71560 71560 PubChem (compound) 1 29686 29686 1
107609 107609 129599 129599 PubChem (compound) 1 29686 29686 1
107610 107610 336393 336393 PubChem (compound) 1 29686 29686 1
107611 107611 312796 312796 PubChem (compound) 1 29686 29686 1
107612 107612 445876 445876 PubChem (compound) 1 29686 29686 1
447798 447798 1259 1259 PubChem (substance) 2 29686 29686 2
447799 447799 71560 71560 PubChem (substance) 2 29686 29686 1
447800 447800 312796 312796 PubChem (substance) 2 29686 29686 1
447801 447801 336393 336393 PubChem (substance) 2 29686 29686 1
447802 447802 129599 129599 PubChem (substance) 2 29686 29686 1
447803 447803 71561 71561 PubChem (substance) 2 29686 29686 1
447804 447804 445876 445876 PubChem (substance) 2 29686 29686 1
1017057 1017057 71560 71560 CAS Common Chemistry 3 29686 29686 1
1017058 1017058 336393 336393 CAS Common Chemistry 3 29686 29686 1
1017059 1017059 445876 445876 CAS Common Chemistry 3 29686 29686 1
1017060 1017060 71561 71561 CAS Common Chemistry 3 29686 29686 1
1017061 1017061 129599 129599 CAS Common Chemistry 3 29686 29686 1
1017062 1017062 312796 312796 CAS Common Chemistry 3 29686 29686 1
1219329 1219329 71560 71560 Computational Toxicology and Exposure Data 4 29686 29686 1
1219330 1219330 336393 336393 Computational Toxicology and Exposure Data 4 29686 29686 1
1219331 1219331 129599 129599 Computational Toxicology and Exposure Data 4 29686 29686 1
1219332 1219332 312796 312796 Computational Toxicology and Exposure Data 4 29686 29686 1
1219333 1219333 71561 71561 Computational Toxicology and Exposure Data 4 29686 29686 1
1219334 1219334 445876 445876 Computational Toxicology and Exposure Data 4 29686 29686 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 1984.951ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website