consensus_index

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

12 rows where inventory_id = 58133

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
162036 162036 58133 58133 13695 1 0.112285401756849
162037 162037 58133 58133 22433 2 0.129656013860764
162038 162038 58133 58133 32268 1 0.0449141607027396
162039 162039 58133 58133 42635 1 0.0280713504392122
162040 162040 58133 58133 46116 1 0.0561427008784244
162041 162041 58133 58133 47171 1 0.0320815433590997
162042 162042 58133 58133 57336 1 0.024952311501522
162043 162043 58133 58133 74125 4 0.188840783645315
162044 162044 58133 58133 75455 14 0.203399091045116
162045 162045 58133 58133 93334 1 0.037428467252283
162046 162046 58133 58133 116210 1 0.112285401756849
162047 162047 58133 58133 128835 1 0.0224570803513698 
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)
);