home / zeropm-v0-0-4

consensus_index

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

16 rows where inchi_id = 201720

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6188 6188 1890 1890 201720 1 0.111553784860558
47488 47488 14622 14622 201720 1 0.111553784860558
112398 112398 39301 39301 201720 1 0.111553784860558
162163 162163 58162 58162 201720 1 0.114537444933921
300187 300187 101659 101659 201720 1 0.172413793103448
526765 526765 209546 209546 201720 1 0.121495327102804
526770 526770 209547 209547 201720 1 0.121495327102804
596034 596034 232068 232068 201720 1 0.11214953271028
597031 597031 235290 235290 201720 1 0.171428571428571
669206 669206 239733 239733 201720 1 0.111888111888112
737917 737917 260158 260158 201720 1 0.121495327102804
737923 737923 260159 260159 201720 1 0.111553784860558
737927 737927 260160 260160 201720 1 0.137931034482759
948276 948276 339992 339992 201720 1 0.168674698795181
1654616 1654616 501344 501344 201720 1 0.111553784860558
1741990 1741990 533582 533582 201720 1 0.111553784860558
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 740.029ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website