consensus_index

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

14 rows where inventory_id = 418538

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1272061 1272061 418538 418538 1235 2 0.151743199129967
1272062 1272062 418538 418538 9328 1 0.101162132753311
1272063 1272063 418538 418538 31902 8 0.303486398259933
1272064 1272064 418538 418538 48605 1 0.0606972796519867
1272065 1272065 418538 418538 72769 1 0.0758715995649833
1272066 1272066 418538 418538 84210 1 0.0275896725690849
1272067 1272067 418538 418538 171576 1 0.0303486398259933
1272068 1272068 418538 418538 179388 1 0.0505810663766556
1272069 1272069 418538 418538 183363 1 0.0379357997824917
1272070 1272070 418538 418538 183514 1 0.0337207109177704
1272071 1272071 418538 418538 221686 1 0.0433551997514191
1272072 1272072 418538 418538 252412 1 0.0252905331883278
1272073 1272073 418538 418538 253801 1 0.0233451075584564
1272074 1272074 418538 418538 314908 1 0.0216775998757095 
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)
);