consensus_index

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

14 rows where inventory_id = 418536

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1272033 1272033 418536 418536 1235 2 0.151743199129967
1272034 1272034 418536 418536 9328 1 0.101162132753311
1272035 1272035 418536 418536 31902 8 0.303486398259933
1272036 1272036 418536 418536 48605 1 0.0606972796519867
1272037 1272037 418536 418536 72769 1 0.0758715995649833
1272038 1272038 418536 418536 84210 1 0.0275896725690849
1272039 1272039 418536 418536 171576 1 0.0303486398259933
1272040 1272040 418536 418536 179388 1 0.0505810663766556
1272041 1272041 418536 418536 183363 1 0.0379357997824917
1272042 1272042 418536 418536 183514 1 0.0337207109177704
1272043 1272043 418536 418536 221686 1 0.0433551997514191
1272044 1272044 418536 418536 252412 1 0.0252905331883278
1272045 1272045 418536 418536 253801 1 0.0233451075584564
1272046 1272046 418536 418536 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)
);