consensus_index

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

12 rows where inventory_id = 321217

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
909564 909564 321217 321217 71644 3 0.145540400169926
909565 909565 321217 321217 95955 1 0.0577577460834031
909566 909566 321217 321217 100660 1 0.231030984333613
909567 909567 321217 321217 143941 2 0.231030984333613
909568 909568 321217 321217 198339 2 0.0385051640556021
909569 909569 321217 321217 226075 1 0.0288788730417016
909570 909570 321217 321217 237873 2 0.0311522115724938
909571 909571 321217 321217 240038 1 0.0462061968667225
909572 909572 321217 321217 240658 1 0.0385051640556021
909573 909573 321217 321217 262072 2 0.0770103281112042
909574 909574 321217 321217 322064 2 0.0298259718260663
909575 909575 321217 321217 332445 1 0.0330044263333732 
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)
);