consensus_index

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

17 rows where inchi_id = 43297

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
149460 149460 53685 53685 43297 12 0.636363636363636
177365 177365 63205 63205 43297 1 0.259842519685039
279482 279482 94770 94770 43297 7 0.620689655172414
280920 280920 95275 95275 43297 1 0.259842519685039
453872 453872 163008 163008 43297 8 0.625
454451 454451 163245 163245 43297 1 0.259842519685039
704092 704092 250701 250701 43297 8 0.625
801230 801230 279500 279500 43297 8 0.625
801232 801232 279501 279501 43297 4 0.6
801234 801234 279502 279502 43297 4 0.6
801236 801236 279503 279503 43297 4 0.6
1055984 1055984 373317 373317 43297 8 0.625
1279258 1279258 420851 420851 43297 8 0.625
1496303 1496303 463012 463012 43297 8 0.625
1599715 1599715 483241 483241 43297 8 0.625
1645220 1645220 498049 498049 43297 8 0.625
1645828 1645828 498282 498282 43297 1 0.259842519685039 
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)
);