consensus_index

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

13 rows where inchi_id = 83813

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18986 18986 5577 5577 83813 8 0.625
116803 116803 40741 40741 83813 8 0.625
160271 160271 57628 57628 83813 8 0.625
216789 216789 75249 75249 83813 8 0.478260869565217
335010 335010 112920 112920 83813 4 0.438024437775896
426876 426876 153950 153950 83813 8 0.478260869565217
475827 475827 173283 173283 83813 4 0.438024437775896
534438 534438 212089 212089 83813 12 0.483870967741935
733567 733567 258700 258700 83813 8 0.625
853238 853238 295201 295201 83813 8 0.625
853240 853240 295202 295202 83813 5 0.608695652173913
1612333 1612333 486747 486747 83813 8 0.625
1671473 1671473 507139 507139 83813 3 0.332803373808473 
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)
);