home / zeropm-v0-0-4

api_results

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

23 rows where inchi_id = 171145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
54763 54763 68886 68886 PubChem (compound) 1 171145 171145 1
54764 54764 24742 24742 PubChem (compound) 1 171145 171145 2
54765 54765 397839 397839 PubChem (compound) 1 171145 171145 3
54766 54766 68885 68885 PubChem (compound) 1 171145 171145 1
106129 106129 68886 68886 PubChem (compound) 1 171145 171145 4
106130 106130 397839 397839 PubChem (compound) 1 171145 171145 2
373096 373096 405092 405092 PubChem (substance) 2 171145 171145 2
373097 373097 24741 24741 PubChem (substance) 2 171145 171145 1
373098 373098 24742 24742 PubChem (substance) 2 171145 171145 3
373099 373099 68886 68886 PubChem (substance) 2 171145 171145 1
373100 373100 138748 138748 PubChem (substance) 2 171145 171145 3
373101 373101 397839 397839 PubChem (substance) 2 171145 171145 3
373102 373102 301959 301959 PubChem (substance) 2 171145 171145 3
373103 373103 325702 325702 PubChem (substance) 2 171145 171145 3
373104 373104 68885 68885 PubChem (substance) 2 171145 171145 2
445827 445827 24741 24741 PubChem (substance) 2 171145 171145 3
445828 445828 24742 24742 PubChem (substance) 2 171145 171145 5
445829 445829 301959 301959 PubChem (substance) 2 171145 171145 5
445830 445830 68886 68886 PubChem (substance) 2 171145 171145 4
445831 445831 325702 325702 PubChem (substance) 2 171145 171145 5
445832 445832 138748 138748 PubChem (substance) 2 171145 171145 5
445833 445833 397839 397839 PubChem (substance) 2 171145 171145 2
445834 445834 68885 68885 PubChem (substance) 2 171145 171145 5
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 1047.367ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website