home / zeropm-v0-0-4

api_results

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

16 rows where inchi_id = 71069

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
138059 138059 118396 118396 PubChem (compound) 1 71069 71069 1
138060 138060 118395 118395 PubChem (compound) 1 71069 71069 1
138061 138061 438402 438402 PubChem (compound) 1 71069 71069 1
138062 138062 343246 343246 PubChem (compound) 1 71069 71069 1
489624 489624 61996 61996 PubChem (substance) 2 71069 71069 2
489625 489625 118395 118395 PubChem (substance) 2 71069 71069 1
489626 489626 438402 438402 PubChem (substance) 2 71069 71069 1
489627 489627 244579 244579 PubChem (substance) 2 71069 71069 2
489628 489628 125205 125205 PubChem (substance) 2 71069 71069 2
489629 489629 118396 118396 PubChem (substance) 2 71069 71069 1
489630 489630 343246 343246 PubChem (substance) 2 71069 71069 1
1038709 1038709 118395 118395 CAS Common Chemistry 3 71069 71069 1
1038710 1038710 118396 118396 CAS Common Chemistry 3 71069 71069 1
1038711 1038711 438402 438402 CAS Common Chemistry 3 71069 71069 1
1038712 1038712 343246 343246 CAS Common Chemistry 3 71069 71069 1
1038713 1038713 246853 246853 CAS Common Chemistry 3 71069 71069 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 860.417ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website