consensus_index

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

18 rows where inventory_id = 304298

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
877516 877516 304298 304298 11858 1 0.0187479868730927
877517 877517 304298 304298 26363 1 0.20622785560402
877518 877518 304298 304298 109786 2 0.11906570794738
877519 877519 304298 304298 189193 1 0.0229142061782244
877520 877520 304298 304298 195009 1 0.041245571120804
877521 877521 304298 304298 195348 2 0.10311392780201
877522 877522 304298 304298 198853 2 0.20622785560402
877523 877523 304298 304298 216870 1 0.0257784819505025
877524 877524 304298 304298 230609 2 0.0595328539736901
877525 877525 304298 304298 256760 1 0.0137485237069347
877526 877526 304298 304298 256761 1 0.0158636812003092
877527 877527 304298 304298 261012 1 0.0294611222291457
877528 877528 304298 304298 271050 2 0.0420960847481848
877529 877529 304298 304298 292537 1 0.020622785560402
877530 877530 304298 304298 296498 1 0.0171856546336683
877531 877531 304298 304298 309419 1 0.0147305611145728
877532 877532 304298 304298 320266 2 0.02305697519923
877533 877533 304298 304298 334573 1 0.0121310503296482 
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)
);