home / zeropm-v0-0-4

api_results

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

20 rows where inchi_id = 3287

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
127600 127600 108239 108239 PubChem (compound) 1 3287 3287 1
127601 127601 348217 348217 PubChem (compound) 1 3287 3287 1
127602 127602 406491 406491 PubChem (compound) 1 3287 3287 1
127603 127603 108240 108240 PubChem (compound) 1 3287 3287 1
475611 475611 348218 348218 PubChem (substance) 2 3287 3287 2
475612 475612 108239 108239 PubChem (substance) 2 3287 3287 1
475613 475613 14579 14579 PubChem (substance) 2 3287 3287 2
475614 475614 135586 135586 PubChem (substance) 2 3287 3287 2
475615 475615 375377 375377 PubChem (substance) 2 3287 3287 2
475616 475616 124295 124295 PubChem (substance) 2 3287 3287 3
475617 475617 301240 301240 PubChem (substance) 2 3287 3287 2
475618 475618 406491 406491 PubChem (substance) 2 3287 3287 1
475619 475619 108241 108241 PubChem (substance) 2 3287 3287 2
475620 475620 108240 108240 PubChem (substance) 2 3287 3287 1
475621 475621 124296 124296 PubChem (substance) 2 3287 3287 4
475622 475622 348217 348217 PubChem (substance) 2 3287 3287 1
1030732 1030732 108239 108239 CAS Common Chemistry 3 3287 3287 1
1030733 1030733 348217 348217 CAS Common Chemistry 3 3287 3287 1
1030734 1030734 108240 108240 CAS Common Chemistry 3 3287 3287 1
1030735 1030735 406491 406491 CAS Common Chemistry 3 3287 3287 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 612.363ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website