consensus_index

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

10 rows where inventory_id = 538023

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1755446 1755446 538023 538023 22580 1 0.0336243077577043
1755447 1755447 538023 538023 46470 3 0.163196550132278
1755448 1755448 538023 538023 135194 2 0.23537015430393
1755449 1755449 538023 538023 150808 3 0.186813415271988
1755450 1755450 538023 538023 215980 2 0.166431832197233
1755451 1755451 538023 538023 224983 1 0.0294212692879912
1755452 1755452 538023 538023 227581 1 0.0588425385759825
1755453 1755453 538023 538023 235065 1 0.039228359050655
1755454 1755454 538023 538023 260043 1 0.047074030860786
1755455 1755455 538023 538023 273683 1 0.0261522393671033 
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)
);