consensus_index

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

16 rows where inchi_id = 18706

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28270 28270 8189 8189 18706 1 0.148571428571429
85539 85539 30753 30753 18706 1 0.148571428571429
130683 130683 46484 46484 18706 1 0.149779735682819
235871 235871 80422 80422 18706 1 0.111553784860558
260938 260938 88386 88386 18706 8 0.478260869565217
437077 437077 156733 156733 18706 1 0.111553784860558
447129 447129 160216 160216 18706 8 0.478260869565217
558582 558582 219848 219848 18706 1 0.148571428571429
689560 689560 245901 245901 18706 8 0.625
706391 706391 251074 251074 18706 1 0.122448979591837
803396 803396 280136 280136 18706 1 0.148571428571429
803400 803400 280137 280137 18706 1 0.111553784860558
922678 922678 327495 327495 18706 4 0.6
1624090 1624090 490420 490420 18706 1 0.148571428571429
1636719 1636719 494885 494885 18706 8 0.625
1724997 1724997 528203 528203 18706 1 0.148571428571429 
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)
);