consensus_index

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

15 rows where inchi_id = 42871

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
28554 28554 8280 8280 42871 1 0.0287856047074205
84779 84779 30510 30510 42871 1 0.0287856047074205
133710 133710 47434 47434 42871 1 0.0288658870275659
233570 233570 79828 79828 42871 6 0.514285714285714
703866 703866 250631 250631 42871 10 0.523489932885906
707706 707706 251349 251349 42871 1 0.0288658870275659
800820 800820 279361 279361 42871 8 0.519685039370079
800823 800823 279362 279362 42871 7 0.517241379310345
805427 805427 280646 280646 42871 1 0.0287856047074205
934639 934639 333321 333321 42871 4 0.506024096385542
1059417 1059417 374311 374311 42871 1 0.0287856047074205
1283403 1283403 422028 422028 42871 1 0.0287856047074205
1498975 1498975 463762 463762 42871 1 0.0287856047074205
1600156 1600156 483389 483389 42871 1 0.0287856047074205
1624464 1624464 490556 490556 42871 1 0.0287856047074205 
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)
);