RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJNA400171" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJNA400171 · 34 ✖

analysis 1

  • diamond · 34 ✖

tax_clade 0

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
2964637 2964637 PRJNA400171_S_NODE_7083_length_170_cov_2.453901_g6993_i0 PRJNA400171 7083 170 2.453901 4.1716317 Methylobacterium radiotolerans 31998 Bacteria Bacteria 118 1.2099999999999999e-31   NR PJI52933.1 31998 g6993 i0 98.2 0.988235294117647 56 1 98.8 0 170 3 99 154 PJI52933.1 FMN-dependent NADH-azoreductase [Methylobacterium radiotolerans] diamond 168 118 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
26632268 26632268 PRJNA400171_S_NODE_961_length_343_cov_3.410828_g871_i0 PRJNA400171 961 343 3.410828 11.69914004 Methylobacterium radiotolerans 31998 Bacteria Bacteria 128 2.71e-36   NR PJI51969.1 31998 g871 i0 82.1 0.58600583090379 67 12 58.6 0 39 239 1 67 PJI51969.1 hypothetical protein CTI14_50510, partial [Methylobacterium radiotolerans] diamond 201 128 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
26854161 26854161 PRJNA400171_S_NODE_8981_length_153_cov_2.717742_g8891_i0 PRJNA400171 8981 153 2.717742 4.15814526 Methylobacterium radiotolerans 31998 Bacteria Bacteria 102 1.35e-23   NR PJI54188.1 31998 g8891 i0 98 1.96078431372549 50 1 98 0 2 151 207 256 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 300 102 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
26917241 26917241 PRJNA400171_S_NODE_2362_length_256_cov_2.696035_g2272_i0 PRJNA400171 2362 256 2.696035 6.9018496 Methylobacterium radiotolerans 31998 Bacteria Bacteria 138 9.89e-39   NR PJI54401.1 31998 g2272 i0 83.8 0.9375 80 13 93.8 0 240 1 9 88 PJI54401.1 hypothetical protein CTI14_15935 [Methylobacterium radiotolerans] diamond 240 138 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
27408449 27408449 PRJNA400171_S_NODE_7823_length_163_cov_2.261194_g7733_i0 PRJNA400171 7823 163 2.261194 3.68574622 Burkholderiales 80840 Bacteria Bacteria 70.1 2.73e-12   NR WP_128901930.1 2497863 g7733 i0 66.7 5.96319018404908 54 17 97.5 1 3 161 234 287 WP_128901930.1 arsenical pump-driving ATPase [Janthinobacterium sp. 17J80-10] diamond 972 70.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Janthinobacterium Janthinobacterium sp. 17J80-10
27440082 27440082 PRJNA400171_S_NODE_3043_length_234_cov_4.390244_g2953_i0 PRJNA400171 3043 234 4.390244 10.27317096 Bacteria 2 Bacteria Bacteria 55.1 1.32e-6   NR WP_121584097.1 1827501 g2953 i0 51.1 1.71794871794872 45 22 57.7 0 136 2 1 45 WP_121584097.1 STM4504/CBY_0614 family protein [Mesorhizobium sp. YM1C-6-2] diamond 402 55.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium sp. YM1C-6-2
27959776 27959776 PRJNA400171_S_NODE_7185_length_169_cov_2.357143_g7095_i0 PRJNA400171 7185 169 2.357143 3.98357167 Ancylobacter sp. 1872567 Bacteria Bacteria 41.2 0.0491   NR HEY9212371.1 1872567 g7095 i0 46.8 0.834319526627219 47 23 79.9 2 157 23 303 349 HEY9212371.1 hypothetical protein [Ancylobacter sp.] diamond 141 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae Ancylobacter Ancylobacter sp.
28054455 28054455 PRJNA400171_S_NODE_1185_length_320_cov_3.024055_g1095_i0 PRJNA400171 1185 320 3.024055 9.676976 Luteimonas salinisoli 2752307 Bacteria Bacteria 59.3 1.33e-7   NR WP_180677994.1 2752307 g1095 i0 48.5 1.6125 68 33 61.9 1 208 11 341 408 WP_180677994.1 hypothetical protein [Luteimonas salinisoli] diamond 516 59.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Luteimonas Luteimonas salinisoli
28370232 28370232 PRJNA400171_S_NODE_126_length_762_cov_3.852660_g62_i0 PRJNA400171 126 762 3.85266 29.3572692 Jannaschia formosa 2259592 Bacteria Bacteria 47.8 0.0242   NR WP_115384024.1 2259592 g62 i0 35.7 0.846456692913386 98 58 37 3 283 2 91 187 WP_115384024.1 class I SAM-dependent methyltransferase [Jannaschia formosa] diamond 645 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Jannaschia Jannaschia formosa
28528351 28528351 PRJNA400171_S_NODE_2327_length_257_cov_23.394737_g2237_i0 PRJNA400171 2327 257 23.394737 60.12447409 Roseomonas mucosa 207340 Bacteria Bacteria 51.2 1.5e-6   NR MDU7525378.1 207340 g2237 i0 100 0.245136186770428 21 0 24.5 0 253 191 15 35 MDU7525378.1 hypothetical protein [Roseomonas mucosa] diamond 63 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Roseomonas Roseomonas mucosa
28970229 28970229 PRJNA400171_S_NODE_2208_length_262_cov_2.549356_g2118_i0 PRJNA400171 2208 262 2.549356 6.67931272 Bradyrhizobium sp. S3.9.2 3156432 Bacteria Bacteria 79 1.4e-16   NR WP_354099622.1 3156432 g2118 i0 82.2 3.56106870229008 45 8 51.5 0 127 261 14 58 WP_354099622.1 hypothetical protein [Bradyrhizobium sp. S3.9.2] diamond 933 79 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. S3.9.2
29033602 29033602 PRJNA400171_S_NODE_548_length_412_cov_4.772846_g458_i0 PRJNA400171 548 412 4.772846 19.66412552 Methylobacterium radiotolerans 31998 Bacteria Bacteria 175 5.38e-53   NR PJI53365.1 31998 g458 i0 95.5 0.640776699029126 88 4 64.1 0 411 148 90 177 PJI53365.1 hypothetical protein CTI14_29605 [Methylobacterium radiotolerans] diamond 264 175 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
29145093 29145093 PRJNA400171_S_NODE_4229_length_208_cov_2.284916_g4139_i0 PRJNA400171 4229 208 2.284916 4.75262528 Bacteria 2 Bacteria Bacteria 128 1.04e-32   NR PJI54188.1 31998 g4139 i0 100 1.99038461538462 69 0 99.5 0 208 2 358 426 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 414 128 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
29222969 29222969 PRJNA400171_S_NODE_6289_length_178_cov_3.308725_g6199_i0 PRJNA400171 6289 178 3.308725 5.8895305 Candidatus Paracaedibacteraceae bacterium 2746922 Bacteria Bacteria 63.9 4.28e-10   NR MDP3372021.1 2746922 g6199 i0 54.9 5.52808988764045 51 23 86 0 176 24 272 322 MDP3372021.1 GDP-mannose 4,6-dehydratase [Candidatus Paracaedibacteraceae bacterium] diamond 984 63.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Holosporales Candidatus Paracaedibacteraceae   Candidatus Paracaedibacteraceae bacterium
29380642 29380642 PRJNA400171_S_NODE_1289_length_311_cov_3.329787_g1199_i0 PRJNA400171 1289 311 3.329787 10.35563757 Seohaeicola zhoushanensis 1569283 Bacteria Bacteria 136 8.85e-35   NR MFD2855723.1 1569283 g1199 i0 62.1 4.96784565916399 103 39 99.4 0 309 1 194 296 MFD2855723.1 DUF1156 domain-containing protein [Seohaeicola zhoushanensis] diamond 1545 136 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Seohaeicola Seohaeicola zhoushanensis
29428711 29428711 PRJNA400171_S_NODE_7229_length_168_cov_3.640288_g7139_i0 PRJNA400171 7229 168 3.640288 6.11568384 Bacteria 2 Bacteria Bacteria 120 6.3000000000000005e-30   NR PJI54188.1 31998 g7139 i0 100 1.96428571428571 55 0 98.2 0 166 2 260 314 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 330 120 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
29428713 29428713 PRJNA400171_S_NODE_869_length_357_cov_3.033537_g779_i0 PRJNA400171 869 357 3.033537 10.82972709 Bacteria 2 Bacteria Bacteria 249 2.16e-77   NR PJI54188.1 31998 g779 i0 100 2 119 0 100 0 357 1 95 213 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 714 249 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
29649525 29649525 PRJNA400171_S_NODE_4190_length_208_cov_3.435754_g4100_i0 PRJNA400171 4190 208 3.435754 7.14636832 Bacteria 2 Bacteria Bacteria 142 6.73e-38   NR PJI54188.1 31998 g4100 i0 100 1.96153846153846 68 0 98.1 0 3 206 514 581 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 408 142 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
29664446 29664446 PRJNA400171_S_NODE_3810_length_216_cov_2.679144_g3720_i0 PRJNA400171 3810 216 2.679144 5.78695104 Neisseria shayeganii 607712 Bacteria Bacteria 45.8 0.00223   NR WP_040660049.1 607712 g3720 i0 50 0.722222222222222 52 23 68.1 1 186 40 71 122 WP_040660049.1 tape measure protein [Neisseria shayeganii] diamond 156 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria shayeganii
29727693 29727693 PRJNA400171_S_NODE_250_length_551_cov_4.892720_g172_i0 PRJNA400171 250 551 4.89272 26.9588872 Beggiatoa sp. PS 422289 Bacteria Bacteria 106 1.84e-25   NR EDN68253.1 422289 g172 i0 44.6 0.707803992740472 130 61 69.7 2 384 1 15 135 EDN68253.1 conserved hypothetical protein [Beggiatoa sp. PS] diamond 390 106 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Thiotrichaceae Beggiatoa Beggiatoa sp. PS
30075290 30075290 PRJNA400171_S_NODE_2712_length_244_cov_2.916279_g2622_i0 PRJNA400171 2712 244 2.916279 7.11572076 Burkholderia cepacia 292 Bacteria Bacteria 70.1 1.09e-12   NR WP_081078293.1 292 g2622 i0 47 3.01229508196721 83 41 98.4 1 241 2 90 172 WP_081078293.1 NUMOD4 domain-containing protein [Burkholderia cepacia] diamond 735 70.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia cepacia
30106908 30106908 PRJNA400171_S_NODE_6012_length_182_cov_2.503268_g5922_i0 PRJNA400171 6012 182 2.503268 4.55594776 Methylobacterium radiotolerans 31998 Bacteria Bacteria 112 1.81e-29   NR PJI53153.1 31998 g5922 i0 85 0.989010989010989 60 9 98.9 0 2 181 79 138 PJI53153.1 hypothetical protein CTI14_32365 [Methylobacterium radiotolerans] diamond 180 112 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
30170060 30170060 PRJNA400171_S_NODE_3992_length_212_cov_3.054645_g3902_i0 PRJNA400171 3992 212 3.054645 6.4758474 Pseudoxanthomonas sp. SE1 1664560 Bacteria Bacteria 42.4 0.035   NR WP_277729393.1 1664560 g3902 i0 40.3 0.94811320754717 67 36 94.8 1 1 201 157 219 WP_277729393.1 beta strand repeat-containing protein [Pseudoxanthomonas sp. SE1] diamond 201 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Pseudoxanthomonas Pseudoxanthomonas sp. SE1
30218436 30218436 PRJNA400171_S_NODE_2792_length_241_cov_3.476415_g2702_i0 PRJNA400171 2792 241 3.476415 8.37816015 Pseudomonadati 3379134 Bacteria Bacteria 45.1 0.00535   NR WP_322516554.1 1076 g2702 i0 44.2 1.29460580912863 43 24 53.5 0 5 133 190 232 WP_322516554.1 HNH endonuclease [Rhodopseudomonas palustris] diamond 312 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Rhodopseudomonas Rhodopseudomonas palustris
30675585 30675585 PRJNA400171_S_NODE_8133_length_160_cov_2.465649_g8043_i0 PRJNA400171 8133 160 2.465649 3.9450384 Chitinibacter bivalviorum 2739434 Bacteria Bacteria 60.5 6.75e-9   NR WP_179358082.1 2739434 g8043 i0 50.9 0.99375 53 26 99.4 0 2 160 528 580 WP_179358082.1 lamin tail domain-containing protein [Chitinibacter bivalviorum] diamond 159 60.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinibacter Chitinibacter bivalviorum
31149240 31149240 PRJNA400171_S_NODE_7515_length_166_cov_2.233577_g7425_i0 PRJNA400171 7515 166 2.233577 3.70773782 methane-oxidizing endosymbiont of Gigantopelta aegis 2794938 Bacteria Bacteria 61.2 3.01e-9   NR WP_198243424.1 2794938 g7425 i0 62 3.56024096385542 50 19 90.4 0 161 12 4 53 WP_198243424.1 LysR family transcriptional regulator [methane-oxidizing endosymbiont of Gigantopelta aegis] diamond 591 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       methane-oxidizing endosymbiont of Gigantopelta aegis
31466087 31466087 PRJNA400171_S_NODE_2116_length_265_cov_3.576271_g2026_i0 PRJNA400171 2116 265 3.576271 9.47711815 Skermanella mucosa 1789672 Bacteria Bacteria 53.5 7.57e-6   NR WP_202685638.1 1789672 g2026 i0 42.5 0.826415094339623 73 42 82.6 0 224 6 52 124 WP_202685638.1 effector-associated domain EAD1-containing protein [Skermanella mucosa] diamond 219 53.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Azospirillaceae Skermanella Skermanella mucosa
31592590 31592590 PRJNA400171_S_NODE_1796_length_281_cov_2.757937_g1706_i0 PRJNA400171 1796 281 2.757937 7.74980297 Variovorax paradoxus 34073 Bacteria Bacteria 59.7 5.3e-9   NR WP_208510797.1 34073 g1706 i0 79.3 0.309608540925267 29 6 31 0 276 190 87 115 WP_208510797.1 nuclear transport factor 2 family protein [Variovorax paradoxus] diamond 87 59.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax paradoxus
31640690 31640690 PRJNA400171_S_NODE_956_length_344_cov_2.726984_g866_i0 PRJNA400171 956 344 2.726984 9.38082496 Bacteria 2 Bacteria Bacteria 45.1 0.0192   NR MDX2263429.1 1909294 g866 i0 30.2 2.33720930232558 106 64 88.1 3 312 10 421 521 MDX2263429.1 DUF4214 domain-containing protein [Hyphomicrobiales bacterium] diamond 804 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales bacterium
32003723 32003723 PRJNA400171_S_NODE_6218_length_179_cov_2.846667_g6128_i0 PRJNA400171 6218 179 2.846667 5.09553393 Methylobacterium radiotolerans 31998 Bacteria Bacteria 112 2.4599999999999996e-29   NR PJI53153.1 31998 g6128 i0 91.5 0.988826815642458 59 5 98.9 0 3 179 100 158 PJI53153.1 hypothetical protein CTI14_32365 [Methylobacterium radiotolerans] diamond 177 112 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
32130393 32130393 PRJNA400171_S_NODE_3018_length_235_cov_2.941748_g2928_i0 PRJNA400171 3018 235 2.941748 6.9131078 Methylobacterium radiotolerans 31998 Bacteria Bacteria 105 3.62e-24   NR PJI54188.1 31998 g2928 i0 98.5 0.829787234042553 65 1 83 0 41 235 1 65 PJI54188.1 hypothetical protein CTI14_18515 [Methylobacterium radiotolerans] diamond 195 105 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium radiotolerans
32351933 32351933 PRJNA400171_S_NODE_5899_length_183_cov_2.818182_g5809_i0 PRJNA400171 5899 183 2.818182 5.15727306 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 51.2 8.43e-6   NR HUX80640.1 1913988 g5809 i0 46.2 0.852459016393443 52 28 85.2 0 168 13 118 169 HUX80640.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 156 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32415109 32415109 PRJNA400171_S_NODE_3639_length_219_cov_3.184211_g3549_i0 PRJNA400171 3639 219 3.184211 6.97342209 Ensifer sp. BRP08 2793825 Bacteria Bacteria 47.4 5.86e-4   NR MCA1408637.1 2793825 g3549 i0 88.9 0.36986301369863 27 3 37 0 81 1 1 27 MCA1408637.1 hypothetical protein [Ensifer sp. BRP08] diamond 81 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Ensifer Ensifer sp. BRP08
32510179 32510179 PRJNA400171_S_NODE_6599_length_175_cov_2.883562_g6509_i0 PRJNA400171 6599 175 2.883562 5.0462335 Abyssibacter sp. 2320200 Bacteria Bacteria 59.7 1.49e-8   NR WP_347205419.1 2320200 g6509 i0 50.9 1.97142857142857 57 28 97.7 0 3 173 271 327 WP_347205419.1 alginate O-acetyltransferase AlgX-related protein [Abyssibacter sp.] diamond 345 59.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Oceanococcaceae Abyssibacter Abyssibacter sp.

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