consensus_index

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

14 rows where inventory_id = 475004

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1573800 1573800 475004 475004 367 2 0.0975059358321326
1573801 1573801 475004 475004 26471 2 0.0731294518740995
1573802 1573802 475004 475004 75626 8 0.292517807496398
1573803 1573803 475004 475004 100884 3 0.146258903748199
1573804 1573804 475004 475004 153502 1 0.0487529679160663
1573805 1573805 475004 475004 199841 1 0.0243764839580332
1573806 1573806 475004 475004 200381 1 0.0325019786107109
1573807 1573807 475004 475004 201272 1 0.0585035614992796
1573808 1573808 475004 475004 201480 1 0.0292517807496398
1573809 1573809 475004 475004 201482 1 0.026592527954218
1573810 1573810 475004 475004 201519 1 0.0417882582137711
1573811 1573811 475004 475004 201520 1 0.0365647259370497
1573812 1573812 475004 475004 214961 1 0.0225013698074152
1573813 1573813 475004 475004 241952 1 0.0585035614992796 
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)
);