consensus_index

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

11 rows where inchi_id = 197705

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
87423 87423 31293 31293 197705 1 0.0980392156862745
194958 194958 69201 69201 197705 1 0.099502487562189
242959 242959 82628 82628 197705 2 0.0742316963591522
439913 439913 157706 157706 197705 2 0.0742316963591522
549725 549725 217363 217363 197705 2 0.115339007260255
716958 716958 253577 253577 197705 1 0.099502487562189
820146 820146 284633 284633 197705 1 0.0991501416430595
820152 820152 284634 284634 197705 1 0.099502487562189
926642 926642 329551 329551 197705 1 0.0980392156862745
1627530 1627530 491599 491599 197705 1 0.099502487562189
1726960 1726960 528818 528818 197705 1 0.099502487562189 
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)
);