home / zeropm-v0-0-4

api_results

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

20 rows where query_id = 78662

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
111191 111191 78662 78662 PubChem (compound) 1 44085 44085 1
452655 452655 78662 78662 PubChem (substance) 2 44085 44085 1
715654 715654 78662 78662 PubChem (substance) 2 136707 136707 2
760122 760122 78662 78662 PubChem (substance) 2 239230 239230 3
760123 760123 78662 78662 PubChem (substance) 2 184453 184453 4
760126 760126 78662 78662 PubChem (substance) 2 180081 180081 5
760127 760127 78662 78662 PubChem (substance) 2 156805 156805 6
760128 760128 78662 78662 PubChem (substance) 2 208877 208877 7
760131 760131 78662 78662 PubChem (substance) 2 264395 264395 8
760132 760132 78662 78662 PubChem (substance) 2 320451 320451 9
760134 760134 78662 78662 PubChem (substance) 2 261398 261398 10
760135 760135 78662 78662 PubChem (substance) 2 277351 277351 11
760136 760136 78662 78662 PubChem (substance) 2 222100 222100 12
760138 760138 78662 78662 PubChem (substance) 2 291837 291837 13
760140 760140 78662 78662 PubChem (substance) 2 310678 310678 14
760141 760141 78662 78662 PubChem (substance) 2 217790 217790 15
760143 760143 78662 78662 PubChem (substance) 2 237281 237281 16
760144 760144 78662 78662 PubChem (substance) 2 320807 320807 17
1019544 1019544 78662 78662 CAS Common Chemistry 3 44085 44085 1
1221931 1221931 78662 78662 Computational Toxicology and Exposure Data 4 129979 129979 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 1066.867ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website