home / zeropm-v0-0-4

api_results

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

42 rows where query_id = 105299

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
22461 22461 105299 105299 PubChem (compound) 1 68369 68369 1
308077 308077 105299 105299 PubChem (substance) 2 75990 75990 28
309836 309836 105299 105299 PubChem (substance) 2 73282 73282 29
326471 326471 105299 105299 PubChem (substance) 2 51341 51341 21
327943 327943 105299 105299 PubChem (substance) 2 68369 68369 1
327949 327949 105299 105299 PubChem (substance) 2 136400 136400 2
452279 452279 105299 105299 PubChem (substance) 2 29093 29093 3
639209 639209 105299 105299 PubChem (substance) 2 7685 7685 8
639696 639696 105299 105299 PubChem (substance) 2 203301 203301 19
708651 708651 105299 105299 PubChem (substance) 2 169716 169716 5
708654 708654 105299 105299 PubChem (substance) 2 291889 291889 36
708657 708657 105299 105299 PubChem (substance) 2 247892 247892 37
708661 708661 105299 105299 PubChem (substance) 2 228243 228243 39
749582 749582 105299 105299 PubChem (substance) 2 169475 169475 31
749586 749586 105299 105299 PubChem (substance) 2 195124 195124 32
759555 759555 105299 105299 PubChem (substance) 2 237702 237702 22
773018 773018 105299 105299 PubChem (substance) 2 169495 169495 4
773020 773020 105299 105299 PubChem (substance) 2 169405 169405 6
773023 773023 105299 105299 PubChem (substance) 2 169706 169706 7
773024 773024 105299 105299 PubChem (substance) 2 68369 68369 9
773026 773026 105299 105299 PubChem (substance) 2 169405 169405 10
773028 773028 105299 105299 PubChem (substance) 2 234477 234477 11
773030 773030 105299 105299 PubChem (substance) 2 169761 169761 12
773033 773033 105299 105299 PubChem (substance) 2 169770 169770 13
773034 773034 105299 105299 PubChem (substance) 2 186547 186547 14
773037 773037 105299 105299 PubChem (substance) 2 167927 167927 15
773039 773039 105299 105299 PubChem (substance) 2 169716 169716 16
773041 773041 105299 105299 PubChem (substance) 2 202227 202227 17
773044 773044 105299 105299 PubChem (substance) 2 202543 202543 18
773045 773045 105299 105299 PubChem (substance) 2 234408 234408 20
773047 773047 105299 105299 PubChem (substance) 2 186547 186547 23
773049 773049 105299 105299 PubChem (substance) 2 261545 261545 24
773051 773051 105299 105299 PubChem (substance) 2 261546 261546 25
773053 773053 105299 105299 PubChem (substance) 2 261547 261547 26
773055 773055 105299 105299 PubChem (substance) 2 227598 227598 27
773058 773058 105299 105299 PubChem (substance) 2 227609 227609 30
773059 773059 105299 105299 PubChem (substance) 2 173845 173845 33
773062 773062 105299 105299 PubChem (substance) 2 201157 201157 34
773064 773064 105299 105299 PubChem (substance) 2 247743 247743 35
773065 773065 105299 105299 PubChem (substance) 2 322648 322648 38
954709 954709 105299 105299 CAS Common Chemistry 3 68369 68369 1
1154424 1154424 105299 105299 Computational Toxicology and Exposure Data 4 68369 68369 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 481.046ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website