consensus_index

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

10 rows where inchi_id = 55340

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10909 10909 3343 3343 55340 1 0.0248199381726179
15071 15071 4703 4703 55340 1 0.0266100548734144
103825 103825 36632 36632 55340 1 0.0266100548734144
126543 126543 45212 45212 55340 1 0.0228405189164371
241912 241912 82237 82237 55340 8 0.9
708135 708135 251433 251433 55340 1 0.0266100548734144
806195 806195 280818 280818 55340 1 0.0266100548734144
920261 920261 326506 326506 55340 4 0.833333333333333
1607963 1607963 485740 485740 55340 1 0.0266100548734144
1627797 1627797 491702 491702 55340 1 0.310344827586207 
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)
);