consensus_index

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

11 rows where inventory_id = 463317

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1497150 1497150 463317 463317 44226 8 0.320941142197944
1497151 1497151 463317 463317 138015 2 0.0926477274210044
1497152 1497152 463317 463317 147385 1 0.0458487345997063
1497153 1497153 463317 463317 166742 3 0.106980380732648
1497154 1497154 463317 463317 188910 3 0.080235285549486
1497155 1497155 463317 463317 190981 2 0.0453879316019844
1497156 1497156 463317 463317 191884 2 0.0436745575472767
1497157 1497157 463317 463317 216644 3 0.118235727706685
1497158 1497158 463317 463317 217178 2 0.0428875641223072
1497159 1497159 463317 463317 218194 2 0.0585955677377623
1497160 1497160 463317 463317 334231 2 0.0342124407122947 
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)
);