RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA229468", tax_phylum = "Bacteroidota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 11 ✖

tax_phylum 1

  • Bacteroidota · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA229468 · 11 ✖

analysis 1

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
5470636 5470636 PRJNA229468_S_NODE_665_length_201_cov_1.006579_g652_i0 PRJNA229468 665 201 1.006579 2.02322379 Bacteroidota bacterium 1898104 Bacteria Bacteria 147 4.2299999999999985e-43   NR MBL0342960.1 1898104 g652 i0 97 2 67 2 100 0 201 1 49 115 MBL0342960.1 GTP-binding protein [Bacteroidota bacterium] diamond 402 147 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26915766 26915766 PRJNA229468_S_NODE_142_length_405_cov_1.609551_g129_i0 PRJNA229468 142 405 1.609551 6.51868155 Bacteroidota bacterium 1898104 Bacteria Bacteria 54.7 1.58e-5   NR MEI6750133.1 1898104 g129 i0 42.1 0.985185185185185 133 52 91.9 9 402 31 254 370 MEI6750133.1 Ig-like domain-containing protein [Bacteroidota bacterium] diamond 399 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27895133 27895133 PRJNA229468_S_NODE_645_length_203_cov_0.824675_g632_i0 PRJNA229468 645 203 0.824675 1.67409025 Bacteroidota bacterium 1898104 Bacteria Bacteria 129 8.03e-36   NR MBL0342960.1 1898104 g632 i0 88.1 0.990147783251232 67 8 99 0 1 201 77 143 MBL0342960.1 GTP-binding protein [Bacteroidota bacterium] diamond 201 129 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
28905372 28905372 PRJNA229468_S_NODE_888_length_178_cov_2.372093_g875_i0 PRJNA229468 888 178 2.372093 4.22232554 Saprospiraceae bacterium 2202734 Bacteria Bacteria 48.9 1.06e-4   NR MEO6131142.1 2202734 g875 i0 53.3 0.758426966292135 45 21 75.8 0 43 177 433 477 MEO6131142.1 T9SS type A sorting domain-containing protein [Saprospiraceae bacterium] diamond 135 48.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
29081326 29081326 PRJNA229468_S_NODE_988_length_171_cov_1.401639_g975_i0 PRJNA229468 988 171 1.401639 2.39680269 Bacteroidota 976 Bacteria Bacteria 85.9 1.26e-18   NR WP_312398580.1 341027 g975 i0 74.5 8.66666666666667 55 14 96.5 0 6 170 162 216 WP_312398580.1 SDR family oxidoreductase [Sphingobacterium sp.] diamond 1482 86.7 0.990772779700115 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium sp.
29649187 29649187 PRJNA229468_S_NODE_1090_length_166_cov_1.102564_g1077_i0 PRJNA229468 1090 166 1.102564 1.83025624 Bacteroidota 976 Bacteria Bacteria 75.1 1.37e-14   NR WP_104381618.1 2050894 g1077 i0 63 8.90963855421687 54 20 97.6 0 1 162 13 66 WP_104381618.1 SDR family oxidoreductase [Sphingobacterium sp. HMA12] diamond 1479 75.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Sphingobacterium Sphingobacterium sp. HMA12
29916215 29916215 PRJNA229468_S_NODE_691_length_197_cov_1.378378_g678_i0 PRJNA229468 691 197 1.378378 2.71540466 Flavobacterium sp. RNTU_13 3375145 Bacteria Bacteria 90.1 3.8e-20   NR WP_411426549.1 3375145 g678 i0 67.7 0.989847715736041 65 21 99 0 2 196 65 129 WP_411426549.1 SDR family oxidoreductase [Flavobacterium sp. RNTU_13] diamond 195 90.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. RNTU_13
30010963 30010963 PRJNA229468_S_NODE_251_length_315_cov_1.424812_g238_i0 PRJNA229468 251 315 1.424812 4.4881578 Bacteroidota bacterium 1898104 Bacteria Bacteria 128 2.75e-36   NR MBL0342957.1 1898104 g238 i0 74.7 0.79047619047619 83 20 78.1 1 2 247 1 83 MBL0342957.1 glutathione S-transferase family protein [Bacteroidota bacterium] diamond 249 128 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30642554 30642554 PRJNA229468_S_NODE_833_length_182_cov_1.834586_g820_i0 PRJNA229468 833 182 1.834586 3.33894652 Tenacibaculum amylolyticum 104269 Bacteria Bacteria 43.1 0.0121   NR WP_408038153.1 104269 g820 i0 48.8 0.675824175824176 41 20 67.6 1 151 29 322 361 WP_408038153.1 cytochrome P450 [Tenacibaculum amylolyticum] diamond 123 43.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Tenacibaculum Tenacibaculum amylolyticum
31323997 31323997 PRJNA229468_S_NODE_1135_length_165_cov_0.879310_g1122_i0 PRJNA229468 1135 165 0.87931 1.4508615 Bacteroidota 976 Bacteria Bacteria 85.1 6.71e-18   NR MFK7771206.1 2202734 g1122 i0 84 12.0545454545455 50 8 90.9 0 2 151 155 204 MFK7771206.1 zinc-binding alcohol dehydrogenase family protein [Saprospiraceae bacterium] diamond 1989 85.9 0.990686845168801 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
32192147 32192147 PRJNA229468_S_NODE_518_length_220_cov_1.192982_g505_i0 PRJNA229468 518 220 1.192982 2.6245604 Arundinibacter roseus 2070510 Bacteria Bacteria 54.7 1.46e-6   NR WP_132121071.1 2070510 g505 i0 36.5 1.00909090909091 74 45 98.2 1 216 1 205 278 WP_132121071.1 SDR family oxidoreductase [Arundinibacter roseus] diamond 222 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Spirosomataceae Arundinibacter Arundinibacter roseus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;