consensus_index

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

8 rows where inventory_id = 31145

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
86907 86907 31145 31145 3457 1 0.0667993096220394
86908 86908 31145 31145 3458 9 0.343579837393396
86909 86909 31145 31145 19475 1 0.0500994822165296
86910 86910 31145 31145 136395 1 0.200397928866118
86911 86911 31145 31145 188271 1 0.133598619244079
86912 86912 31145 31145 232972 1 0.0445328730813596
86913 86913 31145 31145 243753 1 0.0801591715464473
86914 86914 31145 31145 270863 1 0.0572565511046052 
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)
);