home / zeropm-v0-0-4

api_results

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

28 rows where query_id = 38742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
77225 77225 38742 38742 PubChem (compound) 1 49167 49167 1
77232 77232 38742 38742 PubChem (compound) 1 65004 65004 2
77234 77234 38742 38742 PubChem (compound) 1 173801 173801 3
77236 77236 38742 38742 PubChem (compound) 1 261485 261485 4
77238 77238 38742 38742 PubChem (compound) 1 49167 49167 5
77240 77240 38742 38742 PubChem (compound) 1 177752 177752 6
77241 77241 38742 38742 PubChem (compound) 1 287579 287579 7
77242 77242 38742 38742 PubChem (compound) 1 49167 49167 8
405256 405256 38742 38742 PubChem (substance) 2 49167 49167 1
405263 405263 38742 38742 PubChem (substance) 2 65004 65004 4
405267 405267 38742 38742 PubChem (substance) 2 173801 173801 5
405271 405271 38742 38742 PubChem (substance) 2 261485 261485 6
405274 405274 38742 38742 PubChem (substance) 2 49167 49167 7
405275 405275 38742 38742 PubChem (substance) 2 177752 177752 18
405276 405276 38742 38742 PubChem (substance) 2 287579 287579 13
405277 405277 38742 38742 PubChem (substance) 2 49167 49167 16
643833 643833 38742 38742 PubChem (substance) 2 186649 186649 2
643840 643840 38742 38742 PubChem (substance) 2 216556 216556 11
643842 643842 38742 38742 PubChem (substance) 2 211530 211530 10
643848 643848 38742 38742 PubChem (substance) 2 241986 241986 14
737214 737214 38742 38742 PubChem (substance) 2 239027 239027 3
737217 737217 38742 38742 PubChem (substance) 2 174264 174264 8
737221 737221 38742 38742 PubChem (substance) 2 216556 216556 9
737222 737222 38742 38742 PubChem (substance) 2 295058 295058 12
737223 737223 38742 38742 PubChem (substance) 2 320897 320897 15
737224 737224 38742 38742 PubChem (substance) 2 326525 326525 17
994643 994643 38742 38742 CAS Common Chemistry 3 49167 49167 1
1197683 1197683 38742 38742 Computational Toxicology and Exposure Data 4 49167 49167 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 663.576ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website