consensus_index

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

24 rows where inventory_id = 8292

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28606 28606 8292 8292 46626 3 0.148647145622254
28607 28607 8292 8292 91226 1 0.0535965704752796
28608 28608 8292 8292 111687 6 0.214386281901118
28609 28609 8292 8292 219343 1 0.00974483099550537
28610 28610 8292 8292 224391 1 0.0102088705667199
28611 28611 8292 8292 225157 1 0.0107193140950559
28612 28612 8292 8292 225451 1 0.0133991426188199
28613 28613 8292 8292 225574 2 0.107193140950559
28614 28614 8292 8292 230632 1 0.0267982852376398
28615 28615 8292 8292 230958 1 0.0714620939670394
28616 28616 8292 8292 230971 1 0.0535965704752796
28617 28617 8292 8292 230975 1 0.0428772563802236
28618 28618 8292 8292 230990 1 0.0357310469835197
28619 28619 8292 8292 231006 1 0.0306266117001597
28620 28620 8292 8292 231011 1 0.0214386281901118
28621 28621 8292 8292 231050 1 0.0194896619910107
28622 28622 8292 8292 248098 1 0.0126109577588893
28623 28623 8292 8292 248141 1 0.0178655234917598
28624 28624 8292 8292 248161 1 0.0119103489945066
28625 28625 8292 8292 248170 1 0.0112834885211115
28626 28626 8292 8292 248181 1 0.0142924187934079
28627 28627 8292 8292 248322 1 0.0164912524539322
28628 28628 8292 8292 248429 1 0.0153133058500799
28629 28629 8292 8292 314190 1 0.0238206979890131 
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)
);