consensus_index

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

8 rows where inchi_id = 8742

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
227143 227143 78131 78131 8742 6 0.342857142857143
277650 277650 94139 94139 8742 1 0.310344827586207
433988 433988 155949 155949 8742 3 0.375
453247 453247 162741 162741 8742 1 0.3
681286 681286 243348 243348 8742 9 0.345323741007194
932866 932866 332365 332365 8742 3 0.375
1620265 1620265 489274 489274 8742 6 0.384615384615385
1722613 1722613 527562 527562 8742 6 0.384615384615385 
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)
);