home / zeropm-v0-0-4

api_results

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

18 rows where inchi_id = 42951

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
155448 155448 135324 135324 PubChem (compound) 1 42951 42951 1
155449 155449 411434 411434 PubChem (compound) 1 42951 42951 1
512349 512349 135324 135324 PubChem (substance) 2 42951 42951 1
512350 512350 135325 135325 PubChem (substance) 2 42951 42951 3
512351 512351 65185 65185 PubChem (substance) 2 42951 42951 2
512352 512352 411434 411434 PubChem (substance) 2 42951 42951 1
512353 512353 56566 56566 PubChem (substance) 2 42951 42951 2
746893 746893 135325 135325 PubChem (substance) 2 42951 42951 2
746894 746894 56566 56566 PubChem (substance) 2 42951 42951 4
746895 746895 65185 65185 PubChem (substance) 2 42951 42951 3
746896 746896 135324 135324 PubChem (substance) 2 42951 42951 2
746897 746897 411434 411434 PubChem (substance) 2 42951 42951 2
746898 746898 104816 104816 PubChem (substance) 2 42951 42951 2
1051846 1051846 135324 135324 CAS Common Chemistry 3 42951 42951 1
1051847 1051847 411434 411434 CAS Common Chemistry 3 42951 42951 1
1211134 1211134 104816 104816 Computational Toxicology and Exposure Data 4 42951 42951 1
1211135 1211135 56566 56566 Computational Toxicology and Exposure Data 4 42951 42951 1
1211136 1211136 411434 411434 Computational Toxicology and Exposure Data 4 42951 42951 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 435.66ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website