consensus_index

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

22 rows where inchi_id = 47897

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4458 4458 1346 1346 47897 8 0.625
4467 4467 1349 1349 47897 4 0.336999550721545
20351 20351 5976 5976 47897 8 0.625
144381 144381 51473 51473 47897 3 0.332803373808473
160085 160085 57559 57559 47897 16 0.642857142857143
237543 237543 80859 80859 47897 8 0.625
334930 334930 112896 112896 47897 4 0.336999550721545
437640 437640 156888 156888 47897 8 0.625
475760 475760 173258 173258 47897 3 0.332803373808473
521318 521318 208054 208054 47897 8 0.625
521320 521320 208055 208055 47897 8 0.625
521322 521322 208056 208056 47897 8 0.625
528776 528776 210024 210024 47897 3 0.332803373808473
528779 528779 210025 210025 47897 4 0.336999550721545
556438 556438 219242 219242 47897 8 0.625
569182 569182 223233 223233 47897 4 0.336999550721545
662930 662930 237692 237692 47897 12 0.636363636363636
708892 708892 251626 251626 47897 12 0.636363636363636
807528 807528 281184 281184 47897 8 0.625
807530 807530 281185 281185 47897 5 0.608695652173913
1725509 1725509 528330 528330 47897 4 0.6
1750574 1750574 536235 536235 47897 3 0.332803373808473 
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)
);