consensus_index

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

10 rows where inventory_id = 174831

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
478723 478723 174831 174831 30788 3 0.102480014727835
478724 478724 174831 174831 97386 1 0.0422290734875193
478725 478725 174831 174831 109130 3 0.295603514412635
478726 478726 174831 174831 126800 1 0.0985345048042117
478727 478727 174831 174831 145660 1 0.147801757206318
478728 478728 174831 174831 240054 2 0.0853333843097671
478729 478729 174831 174831 270968 2 0.0418046499167499
478730 478730 174831 174831 276590 2 0.0934780389894337
478731 478731 174831 174831 297114 1 0.0369504393015794
478732 478732 174831 174831 307858 2 0.0402265431380227 
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)
);