consensus_index

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

13 rows where inchi_id = 26147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
56342 56342 17697 17697 26147 8 0.625
64712 64712 21129 21129 26147 3 0.324564967020841
80753 80753 29123 29123 26147 8 0.625
80755 80755 29124 29124 26147 3 0.324564967020841
334169 334169 112648 112648 26147 7 0.620689655172414
371823 371823 126641 126641 26147 2 0.317269534863648
693925 693925 247507 247507 26147 8 0.625
718097 718097 253969 253969 26147 4 0.33774999640942
737048 737048 259899 259899 26147 1 0.188976377952756
781772 781772 273345 273345 26147 8 0.625
781774 781774 273346 273346 26147 4 0.6
1671036 1671036 506993 506993 26147 8 0.625
1687699 1687699 513424 513424 26147 3 0.331914073803468 
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)
);