consensus_index

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

8 rows where inventory_id = 287049

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
827019 827019 287049 287049 13330 2 0.200413432654611
827020 827020 287049 287049 58699 2 0.115708749292357
827021 827021 287049 287049 61475 1 0.0801653730618444
827022 827022 287049 287049 63226 10 0.312635792802348
827023 827023 287049 287049 143544 1 0.066804477551537
827024 827024 287049 287049 185989 1 0.066804477551537
827025 827025 287049 287049 197326 1 0.0801653730618444
827026 827026 287049 287049 202204 1 0.0572609807584603 
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)
);