api_results

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

19 rows where query_id = 3905

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
7384 7384 3905 3905 PubChem (compound) 1 60355 60355 1
305554 305554 3905 3905 PubChem (substance) 2 2054 2054 16
305731 305731 3905 3905 PubChem (substance) 2 60355 60355 1
309852 309852 3905 3905 PubChem (substance) 2 63043 63043 10
341479 341479 3905 3905 PubChem (substance) 2 4065 4065 11
351411 351411 3905 3905 PubChem (substance) 2 51044 51044 3
646679 646679 3905 3905 PubChem (substance) 2 149874 149874 6
671613 671613 3905 3905 PubChem (substance) 2 120281 120281 12
697784 697784 3905 3905 PubChem (substance) 2 255399 255399 14
697840 697840 3905 3905 PubChem (substance) 2 296183 296183 2
697843 697843 3905 3905 PubChem (substance) 2 204914 204914 4
697846 697846 3905 3905 PubChem (substance) 2 147746 147746 5
697849 697849 3905 3905 PubChem (substance) 2 169840 169840 7
697852 697852 3905 3905 PubChem (substance) 2 192411 192411 8
697855 697855 3905 3905 PubChem (substance) 2 220244 220244 9
697858 697858 3905 3905 PubChem (substance) 2 208139 208139 13
697861 697861 3905 3905 PubChem (substance) 2 253780 253780 15
943582 943582 3905 3905 CAS Common Chemistry 3 60355 60355 1
1141252 1141252 3905 3905 Computational Toxicology and Exposure Data 4 60355 60355 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)
);