home / zeropm-v0-0-4

api_results

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

21 rows where query_id = 28004

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
60725 60725 28004 28004 PubChem (compound) 1 105684 105684 1
60728 60728 28004 28004 PubChem (compound) 1 147618 147618 2
60731 60731 28004 28004 PubChem (compound) 1 216577 216577 3
60734 60734 28004 28004 PubChem (compound) 1 193567 193567 4
60736 60736 28004 28004 PubChem (compound) 1 296001 296001 5
381767 381767 28004 28004 PubChem (substance) 2 105684 105684 1
381773 381773 28004 28004 PubChem (substance) 2 147618 147618 2
381776 381776 28004 28004 PubChem (substance) 2 216577 216577 3
381780 381780 28004 28004 PubChem (substance) 2 193567 193567 8
381783 381783 28004 28004 PubChem (substance) 2 296001 296001 10
445545 445545 28004 28004 PubChem (substance) 2 189973 189973 12
542565 542565 28004 28004 PubChem (substance) 2 19319 19319 4
588557 588557 28004 28004 PubChem (substance) 2 193072 193072 5
657495 657495 28004 28004 PubChem (substance) 2 169623 169623 9
727836 727836 28004 28004 PubChem (substance) 2 237718 237718 6
727838 727838 28004 28004 PubChem (substance) 2 243322 243322 7
727840 727840 28004 28004 PubChem (substance) 2 190442 190442 11
727841 727841 28004 28004 PubChem (substance) 2 231646 231646 13
727843 727843 28004 28004 PubChem (substance) 2 240733 240733 14
727845 727845 28004 28004 PubChem (substance) 2 308220 308220 15
727846 727846 28004 28004 PubChem (substance) 2 147619 147619 16
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 421.863ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website