consensus_index

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

20 rows where inchi_id = 57836

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23214 23214 6810 6810 57836 1 0.139192139737991
30783 30783 8995 8995 57836 6 0.336442904715727
55825 55825 17502 17502 57836 2 0.153357725263387
86972 86972 31157 31157 57836 8 0.425531914893617
134537 134537 47721 47721 57836 1 0.0596495951910911
134544 134544 47722 47722 57836 8 0.425531914893617
243766 243766 82932 82932 57836 8 0.422040627607163
243772 243772 82933 82933 57836 1 0.0596495951910911
440340 440340 157864 157864 57836 8 0.422040627607163
440346 440346 157865 157865 57836 1 0.0596495951910911
522018 522018 208291 208291 57836 8 0.422040627607163
549060 549060 217028 217028 57836 1 0.0596495951910911
549067 549067 217029 217029 57836 8 0.422040627607163
717707 717707 253852 253852 57836 8 0.379577447624007
717716 717716 253854 253854 57836 1 0.0598456465553552
821320 821320 285171 285171 57836 8 0.379577447624007
821325 821325 285172 285172 57836 8 0.425531914893617
821330 821330 285173 285173 57836 5 0.41958041958042
952081 952081 341575 341575 57836 4 0.417633410672854
1628055 1628055 491810 491810 57836 8 0.42368278109723 
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)
);