consensus_index

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

15 rows where inchi_id = 49147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
160027 160027 57542 57542 49147 1 0.0672538030424339
216084 216084 75029 75029 49147 1 0.0670013606718904
283403 283403 96099 96099 49147 8 0.478260869565217
426425 426425 153808 153808 49147 1 0.0670013606718904
451239 451239 161928 161928 49147 1 0.113207547169811
535453 535453 212486 212486 49147 1 0.0672538030424339
709860 709860 251871 251871 49147 8 0.625
732570 732570 258341 258341 49147 1 0.0672538030424339
808756 808756 281582 281582 49147 8 0.625
808758 808758 281583 281583 49147 7 0.620689655172414
851457 851457 294591 294591 49147 1 0.0670013606718904
935217 935217 333758 333758 49147 1 0.112
1641881 1641881 496839 496839 49147 2 0.136465703364522
1734321 1734321 531262 531262 49147 2 0.136465703364522
1736539 1736539 531985 531985 49147 8 0.625 
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)
);