api_results

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

16 rows where query_id = 104851

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96505 96505 104851 104851 PubChem (compound) 1 51340 51340 1
432038 432038 104851 104851 PubChem (substance) 2 51340 51340 1
435025 435025 104851 104851 PubChem (substance) 2 101837 101837 5
477338 477338 104851 104851 PubChem (substance) 2 9045 9045 4
482361 482361 104851 104851 PubChem (substance) 2 107048 107048 12
641837 641837 104851 104851 PubChem (substance) 2 136303 136303 2
662911 662911 104851 104851 PubChem (substance) 2 272462 272462 11
747610 747610 104851 104851 PubChem (substance) 2 149548 149548 3
747614 747614 104851 104851 PubChem (substance) 2 149549 149549 9
747616 747616 104851 104851 PubChem (substance) 2 217184 217184 10
771823 771823 104851 104851 PubChem (substance) 2 232081 232081 6
771826 771826 104851 104851 PubChem (substance) 2 232174 232174 7
771828 771828 104851 104851 PubChem (substance) 2 232175 232175 8
771830 771830 104851 104851 PubChem (substance) 2 334327 334327 13
1009595 1009595 104851 104851 CAS Common Chemistry 3 51340 51340 1
1211618 1211618 104851 104851 Computational Toxicology and Exposure Data 4 51340 51340 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)
);