RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA666695", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Gemmatimonadota · 21 ✖

tax_kingdom 1

tax_clade 1

  • FCB group · 21 ✖

bioproject 1

  • PRJNA666695 · 21 ✖

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
26860318 26860318 PRJNA666695_S_NODE_105761_length_214_cov_1.502890_g104667_i0 PRJNA666695 105761 214 1.50289 3.2161846 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 53.5 4.07e-6   NR HSY80453.1 2026741 g104667 i0 41.7 1.00934579439252 72 39 96.7 1 5 211 583 654 HSY80453.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium] diamond 216 53.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
26998548 26998548 PRJNA666695_S_NODE_152882_length_175_cov_3.350746_g151788_i0 PRJNA666695 152882 175 3.350746 5.8638055 Pseudomonadati 3379134 Bacteria Bacteria 56.2 2.62e-7   NR MEO8199279.1 2026742 g151788 i0 66.7 5.10857142857143 39 13 66.9 0 175 59 560 598 MEO8199279.1 long-chain fatty acid--CoA ligase [Gemmatimonadota bacterium] diamond 894 56.2 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27049975 27049975 PRJNA666695_S_NODE_103242_length_216_cov_2.840000_g102148_i0 PRJNA666695 103242 216 2.84 6.1344 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 70.9 2.83e-12   NR MDH3292322.1 2026742 g102148 i0 55.2 2.73611111111111 67 29 93.1 1 212 12 312 377 MDH3292322.1 dipeptidase [Gemmatimonadota bacterium] diamond 591 70.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27144346 27144346 PRJNA666695_S_NODE_42922_length_311_cov_5.437037_g41828_i0 PRJNA666695 42922 311 5.437037 16.90918507 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 70.9 4.28e-12   NR MFQ5691091.1 2026742 g41828 i0 48.6 0.713826366559486 74 38 71.4 0 301 80 186 259 MFQ5691091.1 enoyl-CoA hydratase/isomerase family protein [Gemmatimonadota bacterium] diamond 222 70.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27271182 27271182 PRJNA666695_S_NODE_54943_length_283_cov_1.900826_g53849_i0 PRJNA666695 54943 283 1.900826 5.37933758 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 46.6 0.00254   NR NNE08582.1 2026742 g53849 i0 35.9 0.826855123674912 78 44 82.7 1 237 4 77 148 NNE08582.1 tetratricopeptide repeat protein [Gemmatimonadota bacterium] diamond 234 46.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
27492417 27492417 PRJNA666695_S_NODE_60383_length_272_cov_5.047619_g59289_i0 PRJNA666695 60383 272 5.047619 13.72952368 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 77.4 3.38e-14   NR HEY0997147.1 2026741 g59289 i0 41.4 0.959558823529412 87 47 91.5 1 23 271 596 682 HEY0997147.1 Ig-like domain-containing protein [Gemmatimonadaceae bacterium] diamond 261 77.4 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
27839499 27839499 PRJNA666695_S_NODE_70084_length_256_cov_4.734884_g68990_i0 PRJNA666695 70084 256 4.734884 12.12130304 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 59.3 5.39e-8   NR MBI2402109.1 2026742 g68990 i0 45.2 1.7109375 73 26 85.5 1 254 36 262 320 MBI2402109.1 quinone oxidoreductase [Gemmatimonadota bacterium] diamond 438 59.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28660631 28660631 PRJNA666695_S_NODE_164247_length_168_cov_1.811024_g163153_i0 PRJNA666695 164247 168 1.811024 3.04252032 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 47 4.22e-4   NR MEZ4423831.1 2026742 g163153 i0 45.1 0.910714285714286 51 28 91.1 0 164 12 289 339 MEZ4423831.1 ankyrin repeat domain-containing protein [Gemmatimonadota bacterium] diamond 153 47 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
28692322 28692322 PRJNA666695_S_NODE_166167_length_167_cov_1.492063_g165073_i0 PRJNA666695 166167 167 1.492063 2.49174521 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 52 6.2e-6   NR HEY7479968.1 2448054 g165073 i0 43.4 2.87425149700599 53 30 95.2 0 2 160 190 242 HEY7479968.1 SDR family NAD(P)-dependent oxidoreductase [Gemmatimonadales bacterium] diamond 480 52 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
29797071 29797071 PRJNA666695_S_NODE_14231_length_473_cov_4.555556_g13144_i0 PRJNA666695 14231 473 4.555556 21.54777988 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 76.3 6.73e-13   NR HEX5819052.1 2448054 g13144 i0 48.3 0.551797040169133 87 45 55.2 0 446 186 301 387 HEX5819052.1 threonine/serine exporter family protein [Gemmatimonadales bacterium] diamond 261 76.3 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
30219942 30219942 PRJNA666695_S_NODE_20092_length_414_cov_3.739946_g19000_i0 PRJNA666695 20092 414 3.739946 15.48337644 Bacteria 2 Bacteria Bacteria 156 8.309999999999999e-45   NR WP_170039648.1 1639882 g19000 i0 70.9 10.1739130434783 117 34 84.8 0 62 412 1 117 WP_170039648.1 NADPH-dependent F420 reductase [Longimicrobium terrae] diamond 4212 157 0.993630573248408 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium terrae
30586915 30586915 PRJNA666695_S_NODE_65633_length_263_cov_4.558559_g64539_i0 PRJNA666695 65633 263 4.558559 11.98901017 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 84 1.98e-17   NR MFC1529522.1 2026742 g64539 i0 52.5 3.87832699619772 80 32 91.3 1 5 244 152 225 MFC1529522.1 DUF4386 domain-containing protein [Gemmatimonadota bacterium] diamond 1020 84 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
30725466 30725466 PRJNA666695_S_NODE_15694_length_455_cov_26.299517_g14603_i0 PRJNA666695 15694 455 26.299517 119.66280235 Pseudomonadati 3379134 Bacteria Bacteria 147 1.32e-39   NR MFO8175328.1 2910168 g14603 i0 52.9 2.81538461538462 140 57 91.6 3 453 37 227 358 MFO8175328.1 NADH:flavin oxidoreductase/NADH oxidase [Longimicrobiales bacterium] diamond 1281 147 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales     Longimicrobiales bacterium
30946882 30946882 PRJNA666695_S_NODE_49774_length_294_cov_2.592885_g48680_i0 PRJNA666695 49774 294 2.592885 7.6230819 root 1 Root_unresolved Root_unresolved 44.7 0.00816   NR CAA9319038.1 246130 g48680 i0 45 1.33673469387755 40 22 40.8 0 28 147 46 85 CAA9319038.1 MAG: CBM13 [uncultured Gemmatimonadaceae bacterium] diamond 393 44.7 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   uncultured Gemmatimonadaceae bacterium
31567158 31567158 PRJNA666695_S_NODE_65536_length_263_cov_9.157658_g64442_i0 PRJNA666695 65536 263 9.157658 24.08464054 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 71.6 3.17e-12   NR MCZ6824184.1 2026742 g64442 i0 44.7 1.93916349809886 85 47 97 0 3 257 484 568 MCZ6824184.1 gamma-glutamyltransferase [Gemmatimonadota bacterium] diamond 510 71.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32104622 32104622 PRJNA666695_S_NODE_132278_length_190_cov_4.812081_g131184_i0 PRJNA666695 132278 190 4.812081 9.1429539 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 85.5 1.59e-17   NR MBI1722475.1 2026742 g131184 i0 70.7 5.63684210526316 58 17 91.6 0 7 180 502 559 MBI1722475.1 anion permease [Gemmatimonadota bacterium] diamond 1071 85.5 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32136387 32136387 PRJNA666695_S_NODE_142338_length_183_cov_1.619718_g141244_i0 PRJNA666695 142338 183 1.619718 2.96408394 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 66.6 5.21e-11   NR MCC6769576.1 2026741 g141244 i0 54.7 0.868852459016393 53 24 86.9 0 161 3 134 186 MCC6769576.1 threonine/serine dehydratase [Gemmatimonadaceae bacterium] diamond 159 66.6 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium
32275175 32275175 PRJNA666695_S_NODE_100098_length_219_cov_4.393258_g99004_i0 PRJNA666695 100098 219 4.393258 9.62123502 Bacteria 2 Bacteria Bacteria 55.1 1.19e-6   NR MCK5649790.1 2026742 g99004 i0 49.1 3.42465753424658 53 26 71.2 1 218 63 484 536 MCK5649790.1 UvrD-helicase domain-containing protein [Gemmatimonadota bacterium] diamond 750 55.5 0.992792792792793 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32484511 32484511 PRJNA666695_S_NODE_185259_length_156_cov_1.200000_g184165_i0 PRJNA666695 185259 156 1.2 1.872 Gemmatimonadales bacterium 2448054 Bacteria Bacteria 53.9 1.31e-6   NR TVR52068.1 2448054 g184165 i0 54.9 1.96153846153846 51 22 96.2 1 1 150 272 322 TVR52068.1 MAG: PilT/PilU family type 4a pilus ATPase [Gemmatimonadales bacterium] diamond 306 53.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales     Gemmatimonadales bacterium
32547913 32547913 PRJNA666695_S_NODE_173339_length_162_cov_4.181818_g172245_i0 PRJNA666695 173339 162 4.181818 6.77454516 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 68.9 6.98e-12   NR MCH9014914.1 2026742 g172245 i0 58 2.7962962962963 50 21 92.6 0 11 160 594 643 MCH9014914.1 oligopeptide transporter, OPT family [Gemmatimonadota bacterium] diamond 453 68.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota bacterium
32768115 32768115 PRJNA666695_S_NODE_51060_length_291_cov_3.052000_g49966_i0 PRJNA666695 51060 291 3.052 8.88132 Gemmatimonadaceae bacterium 2026741 Bacteria Bacteria 43.9 0.0266   NR HJU76188.1 2026741 g49966 i0 35.5 0.639175257731959 62 40 63.9 0 58 243 277 338 HJU76188.1 cell surface protein SprA [Gemmatimonadaceae bacterium] diamond 186 43.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Gemmatimonadia Gemmatimonadales Gemmatimonadaceae   Gemmatimonadaceae bacterium

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);;