RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_clade = "FCB group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • FCB group · 29 ✖

bioproject 1

  • PRJEB12237 · 29 ✖

analysis 1

  • diamond · 29 ✖
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
3846918 3846918 PRJEB12237_P_NODE_6624_length_223_cov_1.691489_g6428_i0 PRJEB12237 6624 223 1.691489 3.77202047 Bacteroidota 976 Bacteria Bacteria 103 2.27e-25   NR WP_132221738.1 653929 g6428 i0 73.8 15.5784753363229 61 16 82.1 0 41 223 2 62 WP_132221738.1 peroxiredoxin [Albibacterium bauzanense] diamond 3474 104 0.990384615384615 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Albibacterium Albibacterium bauzanense
7672865 7672865 PRJEB12237_P_NODE_11947_length_152_cov_0.974359_g11751_i0 PRJEB12237 11947 152 0.974359 1.48102568 Bacteria 2 Bacteria Bacteria 92.8 1.7e-20   NR TXH22270.1 1869212 g11751 i0 92.9 20.8026315789474 42 3 82.9 0 127 2 110 151 TXH22270.1 MAG: NADP-dependent isocitrate dehydrogenase [Chitinophagaceae bacterium] diamond 3162 92.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
8947676 8947676 PRJEB12237_P_NODE_4628_length_291_cov_1.167969_g4432_i0 PRJEB12237 4628 291 1.167969 3.39878979 Bacteria 2 Bacteria Bacteria 147 4.52e-40   NR HFA50269.1 1898104 g4432 i0 78.3 17.9896907216495 92 20 94.8 0 15 290 1 92 HFA50269.1 adenosylhomocysteinase [Bacteroidota bacterium] diamond 5235 147 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
13739011 13739011 PRJEB12237_P_NODE_4111_length_318_cov_2.180212_g3915_i0 PRJEB12237 4111 318 2.180212 6.93307416 Bacteroidota bacterium 1898104 Bacteria Bacteria 142 7.77e-37   NR MCY4171440.1 1898104 g3915 i0 59.6 3.89622641509434 104 42 98.1 0 1 312 193 296 MCY4171440.1 acetate--CoA ligase [Bacteroidota bacterium] diamond 1239 142 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
20421332 20421332 PRJEB12237_P_NODE_237_length_1374_cov_7.062733_g174_i0 PRJEB12237 237 1374 7.062733 97.04195142 Bacteroidota 976 Bacteria Bacteria 686 1.28e-244   NR WP_298153774.1 239 g174 i0 79.1 45.438864628821 417 87 91 0 1373 123 85 501 WP_298153774.1 aldehyde dehydrogenase family protein [Flavobacterium sp.] diamond 62433 691 0.992764109985528 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp.
26684675 26684675 PRJEB12237_P_NODE_9421_length_175_cov_1.864286_g9225_i0 PRJEB12237 9421 175 1.864286 3.2625005 Cytophagaceae bacterium 2026729 Bacteria Bacteria 84 1.64e-18   NR RYF44926.1 2026729 g9225 i0 64.3 0.96 56 20 96 0 2 169 51 106 RYF44926.1 MAG: hypothetical protein EOO38_16935 [Cytophagaceae bacterium] diamond 168 84 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Cytophagaceae   Cytophagaceae bacterium
26709785 26709785 PRJEB12237_P_NODE_10241_length_166_cov_1.221374_g10045_i0 PRJEB12237 10241 166 1.221374 2.02748084 Bacteria 2 Bacteria Bacteria 67 3.49e-11   NR RMG82831.1 1898104 g10045 i0 61.1 1.96987951807229 54 20 97.6 1 1 162 312 364 RMG82831.1 MAG: ornithine--oxo-acid transaminase [Bacteroidota bacterium] diamond 327 67 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26747693 26747693 PRJEB12237_P_NODE_7821_length_198_cov_1.472393_g7625_i0 PRJEB12237 7821 198 1.472393 2.91533814 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 99.4 7.31e-23   NR MDP2060000.1 1871037 g7625 i0 70.3 0.96969696969697 64 19 97 0 2 193 98 161 MDP2060000.1 hypothetical protein [Flavobacteriaceae bacterium] diamond 192 99.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
26779880 26779880 PRJEB12237_P_NODE_5441_length_257_cov_1.261261_g5245_i0 PRJEB12237 5441 257 1.261261 3.24144077 Flammeovirgaceae bacterium 2026740 Bacteria Bacteria 53.1 3.73e-7   NR MFM7858723.1 2026740 g5245 i0 53.7 0.478599221789883 41 19 47.9 0 257 135 19 59 MFM7858723.1 hypothetical protein [Flammeovirgaceae bacterium] diamond 123 53.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flammeovirgaceae   Flammeovirgaceae bacterium
26805084 26805084 PRJEB12237_P_NODE_9501_length_174_cov_2.014388_g9305_i0 PRJEB12237 9501 174 2.014388 3.50503512 root 1 Root_unresolved Root_unresolved 60.8 5.55e-9   NR MEN9381916.1 1898104 g9305 i0 76.5 2.13793103448276 34 8 58.6 0 72 173 1 34 MEN9381916.1 hypothetical protein [Bacteroidota bacterium] diamond 372 60.8 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26843332 26843332 PRJEB12237_P_NODE_8181_length_192_cov_2.038217_g7985_i0 PRJEB12237 8181 192 2.038217 3.91337664 Segetibacter sp. 2231182 Bacteria Bacteria 41.6 0.0499   NR HEX8460059.1 2231182 g7985 i0 37 0.71875 46 29 71.9 0 52 189 344 389 HEX8460059.1 TonB-dependent receptor plug domain-containing protein [Segetibacter sp.] diamond 138 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Segetibacter Segetibacter sp.
27285838 27285838 PRJEB12237_P_NODE_5503_length_255_cov_1.240909_g5307_i0 PRJEB12237 5503 255 1.240909 3.16431795 Flavobacteriales bacterium 2021391 Bacteria Bacteria 57 4.26e-7   NR MFK7755906.1 2021391 g5307 i0 37.1 3.16470588235294 89 49 97.6 2 1 249 29 116 MFK7755906.1 hypothetical protein [Flavobacteriales bacterium] diamond 807 57 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
27349311 27349311 PRJEB12237_P_NODE_9323_length_177_cov_1.091549_g9127_i0 PRJEB12237 9323 177 1.091549 1.93204173 Flavobacteriales bacterium 2021391 Bacteria Bacteria 64.3 3.29e-10   NR HYG50423.1 2021391 g9127 i0 66 6.64406779661017 47 15 79.7 1 175 35 303 348 HYG50423.1 isocitrate dehydrogenase (NADP(+)) [Flavobacteriales bacterium] diamond 1176 64.3 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales     Flavobacteriales bacterium
28012361 28012361 PRJEB12237_P_NODE_3645_length_345_cov_1.287097_g3449_i0 PRJEB12237 3645 345 1.287097 4.44048465 Mesoflavibacter sp. CH_XMU14 1930902 Bacteria Bacteria 118 4.6e-31   NR WP_336065623.1 3107766 g3449 i0 59.8 0.88695652173913 102 40 87.8 1 303 1 21 122 WP_336065623.1 glycoside hydrolase family 19 protein [Mesoflavibacter sp. CH_XMU1404-2] diamond 306 118 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Mesoflavibacter Mesoflavibacter sp. CH_XMU1404-2
28043743 28043743 PRJEB12237_P_NODE_45_length_2309_cov_5.848285_g28_i0 PRJEB12237 45 2309 5.848285 135.03690065 Bacteroidia bacterium 2044936 Bacteria Bacteria 122 2.44e-25   NR GJQ22129.1 2044936 g28 i0 28.1 0.615851017756605 474 246 56.9 14 586 1899 5 419 GJQ22129.1 MAG: hypothetical protein HBSIN02_24840 [Bacteroidia bacterium] diamond 1422 122 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
28232933 28232933 PRJEB12237_P_NODE_7426_length_205_cov_1.411765_g7230_i0 PRJEB12237 7426 205 1.411765 2.89411825 Mesoflavibacter sp. CH_XMU14 1930902 Bacteria Bacteria 66.6 1.4e-11   NR WP_336065623.1 3107766 g7230 i0 50 0.965853658536585 66 32 95.1 1 195 1 22 87 WP_336065623.1 glycoside hydrolase family 19 protein [Mesoflavibacter sp. CH_XMU1404-2] diamond 198 66.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Mesoflavibacter Mesoflavibacter sp. CH_XMU1404-2
28542844 28542844 PRJEB12237_P_NODE_1607_length_570_cov_2.168224_g1427_i0 PRJEB12237 1607 570 2.168224 12.358876800000001 Chitinophagaceae 563835 Bacteria Bacteria 55.1 4.83e-5   NR WP_294992018.1 796894 g1427 i0 35.4 1.44736842105263 147 80 73.7 5 566 147 202 340 WP_294992018.1 cadherin-like beta sandwich domain-containing protein [uncultured Sediminibacterium sp.] diamond 825 55.1 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Sediminibacterium uncultured Sediminibacterium sp.
28953338 28953338 PRJEB12237_P_NODE_2568_length_438_cov_2.071960_g2372_i0 PRJEB12237 2568 438 2.07196 9.0751848 Pseudomonadati 3379134 Bacteria Bacteria 116 4.18e-28   NR PHI21521.1 2014804 g2372 i0 56.7 10.9315068493151 90 38 61.6 1 20 289 249 337 PHI21521.1 pirin [Lewinellaceae bacterium SD302] diamond 4788 116 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Lewinellaceae   Lewinellaceae bacterium SD302
29300408 29300408 PRJEB12237_P_NODE_11089_length_158_cov_1.626016_g10893_i0 PRJEB12237 11089 158 1.626016 2.56910528 Pseudomonadati 3379134 Bacteria Bacteria 76.3 1.77e-14   NR MYE04204.1 2604895 g10893 i0 71.7 3.5886075949367102 46 13 87.3 0 21 158 442 487 MYE04204.1 glutamine synthetase type III [Bacteroidetes bacterium SB0662_bin_6] diamond 567 76.6 0.996083550913838 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidetes bacterium SB0662_bin_6
29559172 29559172 PRJEB12237_P_NODE_5970_length_240_cov_1.756098_g5774_i0 PRJEB12237 5970 240 1.756098 4.2146352 Bacteroidota bacterium 1898104 Bacteria Bacteria 89.4 1.41e-18   NR MFN4976141.1 1898104 g5774 i0 65.6 0.7625 61 20 76.3 1 17 199 1130 1189 MFN4976141.1 RNase H-like domain-containing protein [Bacteroidota bacterium] diamond 183 89.4 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
30690104 30690104 PRJEB12237_P_NODE_1813_length_533_cov_2.335341_g1629_i0 PRJEB12237 1813 533 2.335341 12.44736753 Candidatus Opimibacter 2981997 Bacteria Bacteria 99.4 1.62e-20   NR HQW25704.1 2202734 g1629 i0 44.8 2.11069418386492 125 63 67.5 3 158 517 833 956 HQW25704.1 HYR domain-containing protein [Saprospiraceae bacterium] diamond 1125 99.4 1 Bacteria FCB group Pseudomonadati Bacteroidota Saprospiria Saprospirales Saprospiraceae   Saprospiraceae bacterium
30943112 30943112 PRJEB12237_P_NODE_7294_length_208_cov_1.468208_g7098_i0 PRJEB12237 7294 208 1.468208 3.05387264 Sphingobacteriaceae 84566 Bacteria Bacteria 54.7 1.4e-6   NR RZK79528.1 1411316 g7098 i0 63.6 7.02403846153846 33 12 47.6 0 107 9 788 820 RZK79528.1 MAG: response regulator [Pedobacter sp.] diamond 1461 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Sphingobacteriia Sphingobacteriales Sphingobacteriaceae Pedobacter Pedobacter sp.
31322151 31322151 PRJEB12237_P_NODE_12195_length_150_cov_1.043478_g11999_i0 PRJEB12237 12195 150 1.043478 1.565217 root 1 Root_unresolved Root_unresolved 68.9 1.57e-12   NR MDC1301475.1 1871037 g11999 i0 60.9 50.3 46 18 92 0 3 140 1 46 MDC1301475.1 His/Gly/Thr/Pro-type tRNA ligase C-terminal domain-containing protein [Flavobacteriaceae bacterium] diamond 7545 68.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
31486911 31486911 PRJEB12237_P_NODE_2636_length_432_cov_2.455919_g2440_i0 PRJEB12237 2636 432 2.455919 10.60957008 Bacteroidota bacterium 1898104 Bacteria Bacteria 158 2.44e-44   NR MEM8763436.1 1898104 g2440 i0 66.3 3.44444444444444 104 35 72.2 0 431 120 79 182 MEM8763436.1 pirin family protein [Bacteroidota bacterium] diamond 1488 158 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31676363 31676363 PRJEB12237_P_NODE_2757_length_419_cov_2.395833_g2561_i0 PRJEB12237 2757 419 2.395833 10.03854027 Longimicrobium sp. 2029185 Bacteria Bacteria 77 4.05e-14   NR HEX2080112.1 2029185 g2561 i0 37.4 2.29116945107399 123 68 83.1 3 415 68 88 208 HEX2080112.1 hypothetical protein [Longimicrobium sp.] diamond 960 77 1 Bacteria FCB group Pseudomonadati Gemmatimonadota Longimicrobiia Longimicrobiales Longimicrobiaceae Longimicrobium Longimicrobium sp.
31765001 31765001 PRJEB12237_P_NODE_10577_length_163_cov_1.250000_g10381_i0 PRJEB12237 10577 163 1.25 2.0375 Bacteroidota 976 Bacteria Bacteria 83.2 5.79e-17   NR MCR9289495.1 1898104 g10381 i0 74.5 5.76073619631902 51 13 93.9 0 4 156 353 403 MCR9289495.1 fumarylacetoacetase [Bacteroidota bacterium] diamond 939 83.2 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31866081 31866081 PRJEB12237_P_NODE_6537_length_225_cov_1.473684_g6341_i0 PRJEB12237 6537 225 1.473684 3.315789 Bacteroidota bacterium 1898104 Bacteria Bacteria 42.7 0.0305   NR MDQ2658379.1 1898104 g6341 i0 40.3 0.893333333333333 67 36 88 2 207 10 395 458 MDQ2658379.1 ABC transporter permease [Bacteroidota bacterium] diamond 201 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
31866083 31866083 PRJEB12237_P_NODE_8477_length_188_cov_1.045752_g8281_i0 PRJEB12237 8477 188 1.045752 1.96601376 Aureitalea marina 930804 Bacteria Bacteria 42.7 0.0179   NR WP_104813816.1 930804 g8281 i0 36.2 0.925531914893617 58 37 92.6 0 174 1 329 386 WP_104813816.1 adenylate/guanylate cyclase domain-containing protein [Aureitalea marina] diamond 174 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Aureitalea Aureitalea marina
32151084 32151084 PRJEB12237_P_NODE_8338_length_190_cov_1.225806_g8142_i0 PRJEB12237 8338 190 1.225806 2.3290314 Gemmatimonadota bacterium 2026742 Bacteria Bacteria 75.9 3.69e-14   NR MEO8030508.1 2026742 g8142 i0 64.6 0.757894736842105 48 17 75.8 0 7 150 41 88 MEO8030508.1 aspartate aminotransferase family protein [Gemmatimonadota bacterium] diamond 144 75.9 1 Bacteria FCB group Pseudomonadati Gemmatimonadota         Gemmatimonadota 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);;