home / zeropm-v0-0-4

api_results

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

24 rows where query_id = 364000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
113710 113710 364000 364000 PubChem (compound) 1 52227 52227 1
369052 369052 364000 364000 PubChem (substance) 2 171056 171056 7
456084 456084 364000 364000 PubChem (substance) 2 52227 52227 1
476964 476964 364000 364000 PubChem (substance) 2 7608 7608 9
519232 519232 364000 364000 PubChem (substance) 2 56848 56848 14
722763 722763 364000 364000 PubChem (substance) 2 189155 189155 6
762019 762019 364000 364000 PubChem (substance) 2 137623 137623 2
772064 772064 364000 364000 PubChem (substance) 2 137477 137477 4
772069 772069 364000 364000 PubChem (substance) 2 233183 233183 3
772073 772073 364000 364000 PubChem (substance) 2 294563 294563 15
772078 772078 364000 364000 PubChem (substance) 2 333120 333120 19
772081 772081 364000 364000 PubChem (substance) 2 330539 330539 20
772082 772082 364000 364000 PubChem (substance) 2 219156 219156 5
772086 772086 364000 364000 PubChem (substance) 2 237356 237356 8
772088 772088 364000 364000 PubChem (substance) 2 195256 195256 10
772089 772089 364000 364000 PubChem (substance) 2 261510 261510 11
772091 772091 364000 364000 PubChem (substance) 2 262053 262053 12
772094 772094 364000 364000 PubChem (substance) 2 192156 192156 13
772096 772096 364000 364000 PubChem (substance) 2 320214 320214 16
772098 772098 364000 364000 PubChem (substance) 2 327063 327063 17
772099 772099 364000 364000 PubChem (substance) 2 234864 234864 18
772102 772102 364000 364000 PubChem (substance) 2 207085 207085 21
1028653 1028653 364000 364000 CAS Common Chemistry 3 52227 52227 1
1178684 1178684 364000 364000 Computational Toxicology and Exposure Data 4 52227 52227 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 472.505ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website