consensus_index

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

13 rows where inchi_id = 45395

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
90796 90796 32400 32400 45395 1 0.3125
170046 170046 60642 60642 45395 11 0.634146341463415
181775 181775 64927 64927 45395 8 0.240376241072984
208141 208141 73663 73663 45395 2 0.182647423110619
235941 235941 80446 80446 45395 8 0.625
421627 421627 153006 153006 45395 2 0.182647423110619
558323 558323 219817 219817 45395 8 0.625
706530 706530 251092 251092 45395 8 0.625
706799 706799 251133 251133 45395 2 0.184138505033529
803484 803484 280154 280154 45395 8 0.625
803486 803486 280155 280155 45395 5 0.608695652173913
1607707 1607707 485697 485697 45395 1 0.3125
1714283 1714283 525330 525330 45395 1 0.3125 
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)
);