home / zeropm-v0-0-4

api_results

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

21 rows where inchi_id = 31172

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
122582 122582 100431 100431 PubChem (compound) 1 31172 31172 1
122583 122583 100432 100432 PubChem (compound) 1 31172 31172 1
122584 122584 100430 100430 PubChem (compound) 1 31172 31172 1
122585 122585 130266 130266 PubChem (compound) 1 31172 31172 1
122586 122586 155448 155448 PubChem (compound) 1 31172 31172 1
122587 122587 410388 410388 PubChem (compound) 1 31172 31172 1
122590 122590 100431 100431 PubChem (compound) 1 31172 31172 4
468619 468619 100430 100430 PubChem (substance) 2 31172 31172 1
468620 468620 410388 410388 PubChem (substance) 2 31172 31172 1
468621 468621 155447 155447 PubChem (substance) 2 31172 31172 2
468622 468622 155448 155448 PubChem (substance) 2 31172 31172 1
468623 468623 100431 100431 PubChem (substance) 2 31172 31172 1
468624 468624 100432 100432 PubChem (substance) 2 31172 31172 1
468625 468625 130266 130266 PubChem (substance) 2 31172 31172 1
468629 468629 100430 100430 PubChem (substance) 2 31172 31172 2
468630 468630 100431 100431 PubChem (substance) 2 31172 31172 4
1027225 1027225 100431 100431 CAS Common Chemistry 3 31172 31172 1
1027226 1027226 100430 100430 CAS Common Chemistry 3 31172 31172 1
1229920 1229920 100430 100430 Computational Toxicology and Exposure Data 4 31172 31172 1
1229921 1229921 130266 130266 Computational Toxicology and Exposure Data 4 31172 31172 1
1229922 1229922 100431 100431 Computational Toxicology and Exposure Data 4 31172 31172 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 966.359ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website