home / zeropm-v0-0-4

api_results

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

23 rows where query_id = 331945

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
39363 39363 331945 331945 PubChem (compound) 1 53255 53255 3
39368 39368 331945 331945 PubChem (compound) 1 157286 157286 2
262785 262785 331945 331945 PubChem (compound) 1 12623 12623 1
262786 262786 331945 331945 PubChem (compound) 1 209612 209612 4
262787 262787 331945 331945 PubChem (compound) 1 177447 177447 5
262788 262788 331945 331945 PubChem (compound) 1 234209 234209 6
262789 262789 331945 331945 PubChem (compound) 1 254912 254912 7
262790 262790 331945 331945 PubChem (compound) 1 334587 334587 8
351860 351860 331945 331945 PubChem (substance) 2 53255 53255 3
351866 351866 331945 331945 PubChem (substance) 2 157286 157286 2
351872 351872 331945 331945 PubChem (substance) 2 130558 130558 5
648782 648782 331945 331945 PubChem (substance) 2 12623 12623 1
648784 648784 331945 331945 PubChem (substance) 2 209612 209612 4
648787 648787 331945 331945 PubChem (substance) 2 177447 177447 12
648788 648788 331945 331945 PubChem (substance) 2 234209 234209 10
648789 648789 331945 331945 PubChem (substance) 2 254912 254912 11
648790 648790 331945 331945 PubChem (substance) 2 334587 334587 13
716853 716853 331945 331945 PubChem (substance) 2 222916 222916 7
716868 716868 331945 331945 PubChem (substance) 2 247413 247413 9
909706 909706 331945 331945 PubChem (substance) 2 227124 227124 6
909708 909708 331945 331945 PubChem (substance) 2 209613 209613 8
1114700 1114700 331945 331945 CAS Common Chemistry 3 12623 12623 1
1326047 1326047 331945 331945 Computational Toxicology and Exposure Data 4 12623 12623 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 1677.43ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website