api_results

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

17 rows where query_id = 80882

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
310545 310545 80882 80882 PubChem (substance) 2 26874 26874 1
311374 311374 80882 80882 PubChem (substance) 2 73281 73281 2
330195 330195 80882 80882 PubChem (substance) 2 81213 81213 5
452059 452059 80882 80882 PubChem (substance) 2 153429 153429 6
453884 453884 80882 80882 PubChem (substance) 2 56936 56936 4
453910 453910 80882 80882 PubChem (substance) 2 46724 46724 3
567483 567483 80882 80882 PubChem (substance) 2 46158 46158 7
649901 649901 80882 80882 PubChem (substance) 2 192102 192102 8
657847 657847 80882 80882 PubChem (substance) 2 18980 18980 12
700407 700407 80882 80882 PubChem (substance) 2 173730 173730 9
760848 760848 80882 80882 PubChem (substance) 2 148425 148425 10
760849 760849 80882 80882 PubChem (substance) 2 237372 237372 11
760850 760850 80882 80882 PubChem (substance) 2 142905 142905 13
945962 945962 80882 80882 CAS Common Chemistry 3 26874 26874 2
946432 946432 80882 80882 CAS Common Chemistry 3 73281 73281 1
1144001 1144001 80882 80882 Computational Toxicology and Exposure Data 4 26874 26874 2
1144569 1144569 80882 80882 Computational Toxicology and Exposure Data 4 73281 73281 3 
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)
);