home / zeropm-v0-0-4

api_results

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

26 rows where inchi_id = 47596

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ query_id api_id inchi_id rank
133221 133221 231990 231990 PubChem (compound) 1 47596 47596 1
133222 133222 113851 113851 PubChem (compound) 1 47596 47596 1
133223 133223 113852 113852 PubChem (compound) 1 47596 47596 1
133224 133224 149680 149680 PubChem (compound) 1 47596 47596 1
133225 133225 243391 243391 PubChem (compound) 1 47596 47596 1
133226 133226 339412 339412 PubChem (compound) 1 47596 47596 1
483151 483151 16548 16548 PubChem (substance) 2 47596 47596 4
483152 483152 113852 113852 PubChem (substance) 2 47596 47596 1
483153 483153 231990 231990 PubChem (substance) 2 47596 47596 1
483154 483154 56204 56204 PubChem (substance) 2 47596 47596 1
483155 483155 149680 149680 PubChem (substance) 2 47596 47596 1
483156 483156 337224 337224 PubChem (substance) 2 47596 47596 2
483157 483157 113851 113851 PubChem (substance) 2 47596 47596 1
483158 483158 136931 136931 PubChem (substance) 2 47596 47596 3
483159 483159 149816 149816 PubChem (substance) 2 47596 47596 3
483160 483160 56203 56203 PubChem (substance) 2 47596 47596 2
483161 483161 243391 243391 PubChem (substance) 2 47596 47596 1
483162 483162 149681 149681 PubChem (substance) 2 47596 47596 1
483163 483163 88828 88828 PubChem (substance) 2 47596 47596 2
483164 483164 136932 136932 PubChem (substance) 2 47596 47596 2
483165 483165 95287 95287 PubChem (substance) 2 47596 47596 3
483166 483166 339412 339412 PubChem (substance) 2 47596 47596 1
1034891 1034891 113851 113851 CAS Common Chemistry 3 47596 47596 1
1034892 1034892 113852 113852 CAS Common Chemistry 3 47596 47596 1
1034893 1034893 149680 149680 CAS Common Chemistry 3 47596 47596 1
1034894 1034894 339412 339412 CAS Common Chemistry 3 47596 47596 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 1157.991ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website