home / zeropm-v0-0-4

api_results

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

38 rows where query_id = 438420

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
41989 41989 438420 438420 PubChem (compound) 1 190604 190604 1
329055 329055 438420 438420 PubChem (substance) 2 76359 76359 2
355459 355459 438420 438420 PubChem (substance) 2 190604 190604 1
360529 360529 438420 438420 PubChem (substance) 2 29751 29751 13
462968 462968 438420 438420 PubChem (substance) 2 44588 44588 12
493705 493705 438420 438420 PubChem (substance) 2 3200 3200 10
503691 503691 438420 438420 PubChem (substance) 2 27153 27153 33
506887 506887 438420 438420 PubChem (substance) 2 33226 33226 11
515228 515228 438420 438420 PubChem (substance) 2 48362 48362 3
523883 523883 438420 438420 PubChem (substance) 2 72566 72566 19
526489 526489 438420 438420 PubChem (substance) 2 852 852 8
544450 544450 438420 438420 PubChem (substance) 2 21013 21013 15
619983 619983 438420 438420 PubChem (substance) 2 17770 17770 4
670818 670818 438420 438420 PubChem (substance) 2 83336 83336 9
701156 701156 438420 438420 PubChem (substance) 2 165753 165753 26
717808 717808 438420 438420 PubChem (substance) 2 158417 158417 5
717810 717810 438420 438420 PubChem (substance) 2 158769 158769 6
717813 717813 438420 438420 PubChem (substance) 2 143910 143910 7
717815 717815 438420 438420 PubChem (substance) 2 143721 143721 14
717817 717817 438420 438420 PubChem (substance) 2 144245 144245 16
717820 717820 438420 438420 PubChem (substance) 2 144246 144246 17
717822 717822 438420 438420 PubChem (substance) 2 217342 217342 18
717824 717824 438420 438420 PubChem (substance) 2 165742 165742 20
717826 717826 438420 438420 PubChem (substance) 2 187617 187617 21
717827 717827 438420 438420 PubChem (substance) 2 241395 241395 22
717830 717830 438420 438420 PubChem (substance) 2 241396 241396 23
717832 717832 438420 438420 PubChem (substance) 2 187967 187967 24
717835 717835 438420 438420 PubChem (substance) 2 165752 165752 25
717837 717837 438420 438420 PubChem (substance) 2 165754 165754 27
717838 717838 438420 438420 PubChem (substance) 2 165757 165757 28
717841 717841 438420 438420 PubChem (substance) 2 139077 139077 29
717843 717843 438420 438420 PubChem (substance) 2 144240 144240 30
717845 717845 438420 438420 PubChem (substance) 2 144525 144525 31
717847 717847 438420 438420 PubChem (substance) 2 142701 142701 32
717849 717849 438420 438420 PubChem (substance) 2 167936 167936 34
717851 717851 438420 438420 PubChem (substance) 2 217369 217369 35
968884 968884 438420 438420 CAS Common Chemistry 3 74879 74879 1
1171037 1171037 438420 438420 Computational Toxicology and Exposure Data 4 133426 133426 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.86ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website