consensus_index

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

13 rows where inchi_id = 54717

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42316 42316 12876 12876 54717 7 0.517241379310345
132590 132590 47132 47132 54717 1 0.073884546042618
206843 206843 73314 73314 54717 1 0.0738509679180676
210679 210679 73974 73974 54717 1 0.0737321637364248
231220 231220 79123 79123 54717 2 0.0551951083876825
502753 502753 201160 201160 54717 1 0.0833223118635101
511658 511658 205937 205937 54717 1 0.0737321637364248
520916 520916 207946 207946 54717 2 0.0551951083876825
552356 552356 218151 218151 54717 1 0.0737321637364248
792270 792270 276578 276578 54717 2 0.0551951083876825
815884 815884 283400 283400 54717 1 0.0737321637364248
946665 946665 339264 339264 54717 1 0.0657295365633234
1737199 1737199 532169 532169 54717 4 0.506024096385542 
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)
);