consensus_index

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

20 rows where inchi_id = 63497

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14644 14644 4533 4533 63497 5 0.380952380952381
66198 66198 21844 21844 63497 5 0.380952380952381
94549 94549 33570 33570 63497 6 0.384615384615385
108324 108324 37967 37967 63497 1 0.142379063238347
154550 154550 55581 55581 63497 8 0.387096774193548
241174 241174 81971 81971 63497 1 0.239130434782609
377463 377463 128943 128943 63497 5 0.380952380952381
382293 382293 130861 130861 63497 1 0.138563686300929
439181 439181 157400 157400 63497 1 0.239130434782609
492005 492005 185118 185118 63497 1 0.147299509001637
521774 521774 208199 208199 63497 1 0.239130434782609
551369 551369 217877 217877 63497 1 0.239130434782609
721315 721315 254937 254937 63497 6 0.384615384615385
827606 827606 287184 287184 63497 3 0.375
827609 827609 287185 287185 63497 6 0.384615384615385
863538 863538 298347 298347 63497 3 0.375
915048 915048 324074 324074 63497 1 0.147299509001637
1692264 1692264 515340 515340 63497 6 0.384615384615385
1697332 1697332 517470 517470 63497 1 0.142379063238347
1758524 1758524 539389 539389 63497 6 0.384615384615385 
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)
);