consensus_index

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

27 rows where inchi_id = 282478

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
44 44 10 10 282478 1 0.194805194805195
1900 1900 501 501 282478 1 0.176991150442478
64661 64661 21118 21118 282478 5 0.0593036413824779
100485 100485 35520 35520 282478 5 0.0593282851343279
169262 169262 60356 60356 282478 4 0.0579108262758139
179430 179430 64027 64027 282478 1 0.176470588235294
187438 187438 66755 66755 282478 2 0.0505308364460056
194763 194763 69123 69123 282478 1 0.241935483870968
199219 199219 70865 70865 282478 1 0.194805194805195
202136 202136 71677 71677 282478 1 0.175
371638 371638 126583 126583 282478 5 0.0593036413824779
514267 514267 206360 206360 282478 1 0.175
514270 514270 206361 206361 282478 1 0.173228346456693
528196 528196 209875 209875 282478 1 0.239130434782609
528199 528199 209876 209876 282478 1 0.239130434782609
666552 666552 238588 238588 282478 1 0.173228346456693
717950 717950 253919 253919 282478 6 0.0722740864638745
730337 730337 257636 257636 282478 1 0.175
762663 762663 267451 267451 282478 2 0.0505308364460056
772678 772678 270323 270323 282478 1 0.239130434782609
821660 821660 285294 285294 282478 4 0.0579108262758139
821676 821676 285295 285295 282478 4 0.0387727425412797
821689 821689 285296 285296 282478 5 0.0548000102004832
828667 828667 287504 287504 282478 1 0.113636363636364
848084 848084 293315 293315 282478 1 0.173228346456693
886894 886894 309142 309142 282478 4 0.0579108262758139
1687434 1687434 513348 513348 282478 4 0.055767949619384 
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)
);