consensus_index

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

12 rows where inchi_id = 150142

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
123143 123143 42784 42784 150142 2 0.393679336829636
183876 183876 65699 65699 150142 2 0.333533570866482
305518 305518 103274 103274 150142 2 0.333533570866482
373003 373003 127119 127119 150142 1 0.307692307692308
464535 464535 166950 166950 150142 2 0.333533570866482
587807 587807 229597 229597 150142 2 0.333533570866482
677118 677118 241938 241938 150142 2 0.393679336829636
956346 956346 343660 343660 150142 1 0.389707755240917
1658592 1658592 502615 502615 150142 2 0.393679336829636
1689092 1689092 513988 513988 150142 1 0.3125
1689099 1689099 513991 513991 150142 1 0.307692307692308
1743983 1743983 534101 534101 150142 2 0.333533570866482 
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)
);