consensus_index

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

9 rows where inventory_id = 100572

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
297406 297406 100572 100572 16417 2 0.0651635274133668
297407 297407 100572 100572 21585 1 0.0746541992305208
297408 297408 100572 100572 75286 8 0.298616796922083
297409 297409 100572 100572 75300 1 0.0497694661536806
297410 297410 100572 100572 75665 1 0.0373270996152604
297411 297411 100572 100572 76004 1 0.149308398461042
297412 297412 100572 100572 132768 1 0.0995389323073611
297413 297413 100572 100572 192344 1 0.149308398461042
297414 297414 100572 100572 241703 1 0.0597233593844167 
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)
);