RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA380660" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA380660 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
1677016 1677016 PRJNA380660_P_NODE_6422_length_297_cov_1.723881_g6022_i0 PRJNA380660 6422 297 1.723881 5.11992657 Alphaproteobacteria 28211 Bacteria Bacteria 125 6.299999999999999e-31   NR MEX2453849.1 1898112 g6022 i0 61.6 8.87878787878788 99 37 100 1 297 1 745 842 MEX2453849.1 ATP-dependent chaperone ClpB [Rhodospirillaceae bacterium] diamond 2637 125 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae   Rhodospirillaceae bacterium
4229400 4229400 PRJNA380660_P_NODE_1124_length_814_cov_5.408917_g862_i0 PRJNA380660 1124 814 5.408917 44.02858438 Pseudomonadota 1224 Bacteria Bacteria 434 8.769999999999998e-150   NR WP_147074132.1 171865 g862 i0 81.5 13.7653562653563 249 46 91.8 0 812 66 150 398 WP_147074132.1 NAD-dependent formate dehydrogenase [Sulfuriferula plumbiphila] diamond 11205 437 0.993135011441648 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sulfuricellaceae Sulfuriferula Sulfuriferula plumbiphila
8055507 8055507 PRJNA380660_P_NODE_2807_length_500_cov_3.135881_g2438_i0 PRJNA380660 2807 500 3.135881 15.679405 Bacteria 2 Bacteria Bacteria 233 3.2e-69   NR MEZ5593625.1 1913989 g2438 i0 67.7 13.998 167 52 99.6 2 498 1 536 701 MEZ5593625.1 malate synthase G [Gammaproteobacteria bacterium] diamond 6999 233 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
10002351 10002351 PRJNA380660_P_NODE_3828_length_417_cov_4.528351_g3437_i0 PRJNA380660 3828 417 4.528351 18.88322367 Pseudomonadota bacterium 1977087 Bacteria Bacteria 148 1.45e-38   NR MEO0542248.1 1977087 g3437 i0 63.1 0.935251798561151 130 48 93.5 0 3 392 473 602 MEO0542248.1 molecular chaperone DnaK [Pseudomonadota bacterium] diamond 390 148 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
10606015 10606015 PRJNA380660_P_NODE_9389_length_218_cov_1.941799_g8989_i0 PRJNA380660 9389 218 1.941799 4.23312182 Pseudomonadota bacterium 1977087 Bacteria Bacteria 69.7 4.01e-12   NR MEC8165732.1 1977087 g8989 i0 67.8 6.46788990825688 59 18 79.8 1 2 175 197 255 MEC8165732.1 chaperonin GroEL [Pseudomonadota bacterium] diamond 1410 69.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27137790 27137790 PRJNA380660_P_NODE_5002_length_354_cov_2.172308_g4604_i0 PRJNA380660 5002 354 2.172308 7.68997032 Magnetococcales bacterium 2026759 Bacteria Bacteria 52.4 5.83e-5   NR MBF0461945.1 2026759 g4604 i0 36.1 0.822033898305085 97 54 80.5 4 68 352 129 219 MBF0461945.1 hypothetical protein [Magnetococcales bacterium] diamond 291 52.4 1 Bacteria   Pseudomonadati Pseudomonadota Magnetococcia Magnetococcales     Magnetococcales bacterium
27169595 27169595 PRJNA380660_P_NODE_1022_length_852_cov_3.809235_g775_i0 PRJNA380660 1022 852 3.809235 32.4546822 Salmonella enterica 28901 Bacteria Bacteria 82 5.62e-16   NR WP_348246255.1 28901 g775 i0 44.4 0.285211267605634 81 43 27.8 1 331 567 1 81 WP_348246255.1 hypothetical protein, partial [Salmonella enterica] diamond 243 82 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
27422911 27422911 PRJNA380660_P_NODE_4663_length_371_cov_1.657895_g4266_i0 PRJNA380660 4663 371 1.657895 6.15079045 Klebsiella pneumoniae 573 Bacteria Bacteria 49.3 5.3e-5   NR WP_416493070.1 573 g4266 i0 53.1 0.39622641509434 49 23 39.6 0 147 1 1 49 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 147 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27612231 27612231 PRJNA380660_P_NODE_4324_length_389_cov_3.669444_g3928_i0 PRJNA380660 4324 389 3.669444 14.27413716 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 199 1.9e-61   NR MAL63273.1 1913988 g3928 i0 72 0.96401028277635 125 35 96.4 0 387 13 22 146 MAL63273.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 375 199 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
27675516 27675516 PRJNA380660_P_NODE_2024_length_596_cov_3.783069_g1690_i0 PRJNA380660 2024 596 3.783069 22.54709124 Caulobacteraceae bacterium 1978230 Bacteria Bacteria 48.9 0.00647   NR NBW12416.1 1978230 g1690 i0 25.4 0.971476510067114 193 89 96.1 5 574 2 329 468 NBW12416.1 tail fiber domain-containing protein [Caulobacteraceae bacterium] diamond 579 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae   Caulobacteraceae bacterium
27675518 27675518 PRJNA380660_P_NODE_7404_length_265_cov_2.025424_g7004_i0 PRJNA380660 7404 265 2.025424 5.3673736 Pseudomonadota bacterium 1977087 Bacteria Bacteria 76.6 2.67e-15   NR MEL6702514.1 1977087 g7004 i0 45.6 0.894339622641509 79 39 86 2 36 263 31 108 MEL6702514.1 hypothetical protein [Pseudomonadota bacterium] diamond 237 76.6 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27833053 27833053 PRJNA380660_P_NODE_5224_length_343_cov_2.748408_g4826_i0 PRJNA380660 5224 343 2.748408 9.42703944 endosymbiont of Pachyrhynchus infernalis 1971488 Bacteria Bacteria 45.4 0.0125   NR WP_130579040.1 1971488 g4826 i0 37 0.638483965014577 73 42 63 2 52 267 173 242 WP_130579040.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [endosymbiont of Pachyrhynchus infernalis] diamond 219 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria     Candidatus Nardonella endosymbiont of Pachyrhynchus infernalis
28054037 28054037 PRJNA380660_P_NODE_1525_length_687_cov_4.059271_g1216_i0 PRJNA380660 1525 687 4.059271 27.88719177 Salmonella enterica 28901 Bacteria Bacteria 90.5 1.08e-19   NR WP_348246255.1 28901 g1216 i0 62.7 0.25764192139738 59 22 25.8 0 1 177 22 80 WP_348246255.1 hypothetical protein, partial [Salmonella enterica] diamond 177 90.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
28685845 28685845 PRJNA380660_P_NODE_11367_length_182_cov_1.856209_g10967_i0 PRJNA380660 11367 182 1.856209 3.37830038 Candidatus Paracaedibacter symbiosus 244582 Bacteria Bacteria 42.4 0.021   NR WP_198027379.1 244582 g10967 i0 43.5 1.61538461538462 46 26 75.8 0 12 149 152 197 WP_198027379.1 hypothetical protein [Candidatus Paracaedibacter symbiosus] diamond 294 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Holosporales Candidatus Paracaedibacteraceae Candidatus Paracaedibacter Candidatus Paracaedibacter symbiosus
28860406 28860406 PRJNA380660_P_NODE_11368_length_182_cov_1.764706_g10968_i0 PRJNA380660 11368 182 1.764706 3.21176492 Gammaproteobacteria 1236 Bacteria Bacteria 76.3 1.03e-14   NR MBW6452982.1 2020875 g10968 i0 57.4 4.4010989010989 54 23 89 0 165 4 27 80 MBW6452982.1 AMP-binding protein [Methyloprofundus sp.] diamond 801 76.6 0.996083550913838 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales Methylococcaceae Methyloprofundus Methyloprofundus sp.
29664050 29664050 PRJNA380660_P_NODE_8310_length_240_cov_2.985782_g7910_i0 PRJNA380660 8310 240 2.985782 7.1658768 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 53.1 6.34e-6   NR MCP4411634.1 1913989 g7910 i0 37.2 0.975 78 43 97.5 3 7 240 19 90 MCP4411634.1 YchF/TatD family DNA exonuclease [Gammaproteobacteria bacterium] diamond 234 53.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30043351 30043351 PRJNA380660_P_NODE_1471_length_700_cov_3.272727_g1165_i0 PRJNA380660 1471 700 3.272727 22.909089 Pseudomonadota bacterium 1977087 Bacteria Bacteria 58.2 6.55e-6   NR MEY2920990.1 1977087 g1165 i0 35.2 0.522857142857143 122 69 48 3 196 531 165 286 MEY2920990.1 hypothetical protein [Pseudomonadota bacterium] diamond 366 58.2 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30091845 30091845 PRJNA380660_P_NODE_11952_length_170_cov_1.560284_g11552_i0 PRJNA380660 11952 170 1.560284 2.6524828 Rhodovulum 34008 Bacteria Bacteria 71.6 8.99e-13   NR WP_125408489.1 68291 g11552 i0 64.8 5.57647058823529 54 16 95.3 1 162 1 1190 1240 WP_125408489.1 pre-peptidase C-terminal domain-containing protein [Rhodovulum iodosum] diamond 948 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Rhodovulum Rhodovulum iodosum
30137832 30137832 PRJNA380660_P_NODE_832_length_957_cov_3.559267_g624_i0 PRJNA380660 832 957 3.559267 34.06218519 Salmonella enterica 28901 Bacteria Bacteria 82 9.39e-16   NR WP_348246255.1 28901 g624 i0 44.4 0.253918495297806 81 43 24.8 1 627 391 1 81 WP_348246255.1 hypothetical protein, partial [Salmonella enterica] diamond 243 82 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30454424 30454424 PRJNA380660_P_NODE_3593_length_434_cov_2.192593_g3206_i0 PRJNA380660 3593 434 2.192593 9.51585362 Oceanicoccus sp. KOV_DT_Chl 1904639 Bacteria Bacteria 42.7 0.0356   NR WP_101759026.1 1904639 g3206 i0 55.9 0.235023041474654 34 15 23.5 0 2 103 52 85 WP_101759026.1 hypothetical protein [Oceanicoccus sp. KOV_DT_Chl] diamond 102 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Spongiibacteraceae Oceanicoccus Oceanicoccus sp. KOV_DT_Chl
30485808 30485808 PRJNA380660_P_NODE_10013_length_207_cov_2.185393_g9613_i0 PRJNA380660 10013 207 2.185393 4.52376351 Salmonella enterica 28901 Bacteria Bacteria 80.5 5.48e-18   NR WP_348246255.1 28901 g9613 i0 51.5 0.985507246376812 68 31 95.7 1 198 1 10 77 WP_348246255.1 hypothetical protein, partial [Salmonella enterica] diamond 204 80.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
31482780 31482780 PRJNA380660_P_NODE_1676_length_653_cov_2.751603_g1357_i0 PRJNA380660 1676 653 2.751603 17.96796759 Bacteria 2 Bacteria Bacteria 124 1.71e-30   NR HAD24570.1 1913988 g1357 i0 60.2 3.40428790199081 108 38 49.6 1 328 651 5 107 HAD24570.1 4-hydroxy-tetrahydrodipicolinate synthase [Alphaproteobacteria bacterium] diamond 2223 124 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31703891 31703891 PRJNA380660_P_NODE_7857_length_252_cov_1.654709_g7457_i0 PRJNA380660 7857 252 1.654709 4.16986668 Pseudomonadati 3379134 Bacteria Bacteria 59.3 2.2e-8   NR KNC68917.1 43658 g7457 i0 37.7 2.54761904761905 77 48 91.7 0 4 234 72 148 KNC68917.1 hypothetical protein AC626_01985 [Pseudoalteromonas rubra] diamond 642 59.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas rubra
31971549 31971549 PRJNA380660_P_NODE_3918_length_412_cov_2.859008_g3526_i0 PRJNA380660 3918 412 2.859008 11.77911296 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 103 5.659999999999999e-24   NR MAL63273.1 1913988 g3526 i0 60.2 0.640776699029126 88 35 64.1 0 2 265 195 282 MAL63273.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 264 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32604254 32604254 PRJNA380660_P_NODE_2160_length_576_cov_2.486289_g1820_i0 PRJNA380660 2160 576 2.486289 14.32102464 Aestuariivirga sp. 2650926 Bacteria Bacteria 108 1.71e-24   NR WP_415005740.1 2650926 g1820 i0 37.4 0.973958333333333 187 112 95.3 3 28 576 158 343 WP_415005740.1 hypothetical protein [Aestuariivirga sp.] diamond 561 108 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga sp.
32652378 32652378 PRJNA380660_P_NODE_3100_length_471_cov_3.162896_g2726_i0 PRJNA380660 3100 471 3.162896 14.89724016 Pseudomonadati 3379134 Bacteria Bacteria 174 2.17e-49   NR MCB9675997.1 1913988 g2726 i0 60.3 10.9108280254777 156 56 99.4 2 470 3 13 162 MCB9675997.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 5139 175 0.994285714285714 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
32792918 32792918 PRJNA380660_P_NODE_9100_length_223_cov_2.237113_g8700_i0 PRJNA380660 9100 223 2.237113 4.98876199 Aestuariivirga sp. 2650926 Bacteria Bacteria 78.2 9.29e-15   NR WP_415005741.1 2650926 g8700 i0 52.1 0.982062780269058 73 28 98.2 2 4 222 321 386 WP_415005741.1 hypothetical protein [Aestuariivirga sp.] diamond 219 78.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga 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);;