consensus_index

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

27 rows where inchi_id = 7794

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
25628 25628 7522 7522 7794 8 0.528144933878572
25631 25631 7523 7523 7794 1 0.0466146645776593
86524 86524 31039 31039 7794 1 0.0466146645776593
92565 92565 32976 32976 7794 8 0.528144933878572
142601 142601 50821 50821 7794 1 0.0275836903625129
150244 150244 53859 53859 7794 10 0.523489932885906
226665 226665 78013 78013 7794 6 0.517241379310345
226668 226668 78014 78014 7794 1 0.0486085850018782
433792 433792 155894 155894 7794 7 0.517241379310345
433795 433795 155895 155895 7794 1 0.0486085850018782
502553 502553 200961 200961 7794 3 0.524040820577346
585153 585153 228552 228552 7794 1 0.0503915687948088
585160 585160 228553 228553 7794 4 0.506024096385542
679625 679625 242887 242887 7794 8 0.528144933878572
679639 679639 242892 242892 7794 1 0.0466146645776593
757372 757372 266020 266020 7794 8 0.528144933878572
757375 757375 266021 266021 7794 8 0.519685039370079
757414 757414 266035 266035 7794 1 0.0466146645776593
757421 757421 266036 266036 7794 1 0.0472011935937975
757429 757429 266037 266037 7794 1 0.0387968265543684
757437 757437 266038 266038 7794 1 0.0503915687948088
757444 757444 266039 266039 7794 1 0.0503915687948088
947303 947303 339546 339546 7794 1 0.0503915687948088
1619981 1619981 489196 489196 7794 8 0.528144933878572
1619984 1619984 489197 489197 7794 1 0.0393343606437979
1722429 1722429 527520 527520 7794 8 0.528144933878572
1722432 1722432 527521 527521 7794 1 0.0466146645776593 
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)
);