home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 375379

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
268457 268457 375379 375379 PubChem (compound) 1 242906 242906 1
268458 268458 375379 375379 PubChem (compound) 1 264870 264870 2
268459 268459 375379 375379 PubChem (compound) 1 265892 265892 3
268460 268460 375379 375379 PubChem (compound) 1 265892 265892 4
268461 268461 375379 375379 PubChem (compound) 1 214058 214058 5
268462 268462 375379 375379 PubChem (compound) 1 214058 214058 6
268463 268463 375379 375379 PubChem (compound) 1 242906 242906 7
268464 268464 375379 375379 PubChem (compound) 1 214058 214058 8
268465 268465 375379 375379 PubChem (compound) 1 287471 287471 9
657833 657833 375379 375379 PubChem (substance) 2 242906 242906 1
657834 657834 375379 375379 PubChem (substance) 2 264870 264870 5
657835 657835 375379 375379 PubChem (substance) 2 265892 265892 8
657836 657836 375379 375379 PubChem (substance) 2 265892 265892 4
657837 657837 375379 375379 PubChem (substance) 2 214058 214058 6
657838 657838 375379 375379 PubChem (substance) 2 214058 214058 9
657839 657839 375379 375379 PubChem (substance) 2 242906 242906 13
657840 657840 375379 375379 PubChem (substance) 2 214058 214058 11
657841 657841 375379 375379 PubChem (substance) 2 287471 287471 14
917680 917680 375379 375379 PubChem (substance) 2 278178 278178 2
917681 917681 375379 375379 PubChem (substance) 2 291904 291904 3
917682 917682 375379 375379 PubChem (substance) 2 333121 333121 7
917683 917683 375379 375379 PubChem (substance) 2 261300 261300 10
917684 917684 375379 375379 PubChem (substance) 2 287471 287471 12
1117637 1117637 375379 375379 CAS Common Chemistry 3 6412 6412 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 428.448ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website