home / zeropm-v0-0-4

consensus_index

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

11 rows where inventory_id = 12369

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
40779 40779 12369 12369 50109 5 0.155589220553896
40780 40780 12369 12369 97357 2 0.23582915916398
40781 40781 12369 12369 159142 1 0.058957289790995
40782 40782 12369 12369 187011 1 0.0786097197213267
40783 40783 12369 12369 187012 4 0.23582915916398
40784 40784 12369 12369 196929 2 0.0430563167305294
40785 40785 12369 12369 203968 2 0.0527330030967277
40786 40786 12369 12369 244168 1 0.0262032399071089
40787 40787 12369 12369 244216 1 0.0393048598606634
40788 40788 12369 12369 246653 1 0.0336898798805686
40789 40789 12369 12369 247846 1 0.0294786448954975
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 865.669ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website