home / zeropm-v0-0-4

api_results

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

43 rows where query_id = 170703

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
96300 96300 170703 170703 PubChem (compound) 1 33625 33625 1
431735 431735 170703 170703 PubChem (substance) 2 33625 33625 1
431739 431739 170703 170703 PubChem (substance) 2 275453 275453 13
650650 650650 170703 170703 PubChem (substance) 2 186838 186838 5
747488 747488 170703 170703 PubChem (substance) 2 136744 136744 3
747489 747489 170703 170703 PubChem (substance) 2 185884 185884 2
747492 747492 170703 170703 PubChem (substance) 2 200908 200908 10
747493 747493 170703 170703 PubChem (substance) 2 200483 200483 4
747496 747496 170703 170703 PubChem (substance) 2 258838 258838 12
747498 747498 170703 170703 PubChem (substance) 2 297594 297594 40
747499 747499 170703 170703 PubChem (substance) 2 202991 202991 8
747502 747502 170703 170703 PubChem (substance) 2 148642 148642 6
747503 747503 170703 170703 PubChem (substance) 2 276386 276386 11
747506 747506 170703 170703 PubChem (substance) 2 247265 247265 14
747511 747511 170703 170703 PubChem (substance) 2 204337 204337 9
747514 747514 170703 170703 PubChem (substance) 2 309925 309925 36
747516 747516 170703 170703 PubChem (substance) 2 254897 254897 15
747517 747517 170703 170703 PubChem (substance) 2 323929 323929 37
747520 747520 170703 170703 PubChem (substance) 2 187778 187778 16
747521 747521 170703 170703 PubChem (substance) 2 334598 334598 39
817872 817872 170703 170703 PubChem (substance) 2 193583 193583 7
817873 817873 170703 170703 PubChem (substance) 2 199452 199452 17
817874 817874 170703 170703 PubChem (substance) 2 199618 199618 18
817875 817875 170703 170703 PubChem (substance) 2 201183 201183 19
817876 817876 170703 170703 PubChem (substance) 2 201184 201184 20
817877 817877 170703 170703 PubChem (substance) 2 192682 192682 21
817878 817878 170703 170703 PubChem (substance) 2 193071 193071 22
817879 817879 170703 170703 PubChem (substance) 2 204204 204204 23
817880 817880 170703 170703 PubChem (substance) 2 185881 185881 24
817881 817881 170703 170703 PubChem (substance) 2 185882 185882 25
817882 817882 170703 170703 PubChem (substance) 2 185883 185883 26
817883 817883 170703 170703 PubChem (substance) 2 185885 185885 27
817884 817884 170703 170703 PubChem (substance) 2 185886 185886 28
817885 817885 170703 170703 PubChem (substance) 2 199952 199952 29
817886 817886 170703 170703 PubChem (substance) 2 203133 203133 30
817887 817887 170703 170703 PubChem (substance) 2 206287 206287 31
817888 817888 170703 170703 PubChem (substance) 2 205019 205019 32
817889 817889 170703 170703 PubChem (substance) 2 200211 200211 33
817890 817890 170703 170703 PubChem (substance) 2 199784 199784 34
817891 817891 170703 170703 PubChem (substance) 2 200445 200445 35
817892 817892 170703 170703 PubChem (substance) 2 243428 243428 38
1009480 1009480 170703 170703 CAS Common Chemistry 3 33625 33625 1
1211503 1211503 170703 170703 Computational Toxicology and Exposure Data 4 33625 33625 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 1630.0ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website