RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA474911" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA474911 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
2372569 2372569 PRJNA474911_P_NODE_6282_length_223_cov_1.469136_g6155_i0 PRJNA474911 6282 223 1.469136 3.27617328 Sphingomonas sp. 28214 Bacteria Bacteria 72.4 6.98e-15   NR WP_300493146.1 28214 g6155 i0 88.1 1.13004484304933 42 5 56.5 0 126 1 1 42 WP_300493146.1 hypothetical protein [Sphingomonas sp.] diamond 252 72.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
9375443 9375443 PRJNA474911_P_NODE_5808_length_234_cov_1.109827_g5681_i0 PRJNA474911 5808 234 1.109827 2.59699518 Rheinheimera sp. 1869214 Bacteria Bacteria 145 2.12e-41   NR HAT43178.1 1869214 g5681 i0 98.7 1 78 1 100 0 1 234 102 179 HAT43178.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Rheinheimera sp.] diamond 234 145 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
18299197 18299197 PRJNA474911_P_NODE_7495_length_206_cov_0.882759_g7368_i0 PRJNA474911 7495 206 0.882759 1.81848354 Sphingomonas sp. 28214 Bacteria Bacteria 132 4.849999999999998e-35   NR WP_300494976.1 28214 g7368 i0 100 0.975728155339806 67 0 97.6 0 2 202 198 264 WP_300494976.1 serine hydrolase [Sphingomonas sp.] diamond 201 132 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
26601141 26601141 PRJNA474911_P_NODE_7061_length_209_cov_0.864865_g6934_i0 PRJNA474911 7061 209 0.864865 1.80756785 Microvirga arabica 1128671 Bacteria Bacteria 129 1.12e-33   NR WP_377030868.1 1128671 g6934 i0 91.3 0.990430622009569 69 6 99 0 2 208 340 408 WP_377030868.1 CmpA/NrtA family ABC transporter substrate-binding protein [Microvirga arabica] diamond 207 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga arabica
26696316 26696316 PRJNA474911_P_NODE_5281_length_247_cov_2.919355_g5154_i0 PRJNA474911 5281 247 2.919355 7.21080685 Phycisphaerales bacterium 2052180 Bacteria Bacteria 42.7 0.0242   NR MCC6427943.1 2052180 g5154 i0 47.5 0.48582995951417 40 20 48.6 1 81 200 125 163 MCC6427943.1 PepSY domain-containing protein [Phycisphaerales bacterium] diamond 120 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26791525 26791525 PRJNA474911_P_NODE_7481_length_206_cov_0.882759_g7354_i0 PRJNA474911 7481 206 0.882759 1.81848354 Cupriavidus sp. UGS-1 2899826 Bacteria Bacteria 139 3.32e-36   NR WP_232205132.1 2899826 g7354 i0 100 0.990291262135922 68 0 99 0 206 3 2488 2555 WP_232205132.1 filamentous hemagglutinin N-terminal domain-containing protein [Cupriavidus sp. UGS-1] diamond 204 139 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Cupriavidus Cupriavidus sp. UGS-1
27250381 27250381 PRJNA474911_P_NODE_2863_length_361_cov_1.440000_g2737_i0 PRJNA474911 2863 361 1.44 5.1984 PVC group 1783257 Bacteria Bacteria 63.2 3.17e-9   NR MCK4859712.1 2035772 g2737 i0 62.5 1.66204986149584 40 15 33.2 0 325 206 2 41 MCK4859712.1 adenylate kinase [Candidatus Omnitrophota bacterium] diamond 600 63.2 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
27676758 27676758 PRJNA474911_P_NODE_8304_length_201_cov_0.914286_g8177_i0 PRJNA474911 8304 201 0.914286 1.83771486 Klebsiella pneumoniae 573 Bacteria Bacteria 47 7.16e-5   NR WP_416493070.1 573 g8177 i0 65.1 0.641791044776119 43 15 64.2 0 46 174 26 68 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 129 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27865802 27865802 PRJNA474911_P_NODE_7125_length_208_cov_1.312925_g6998_i0 PRJNA474911 7125 208 1.312925 2.730884 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 42.7 0.0244   NR MBQ6248075.1 2212473 g6998 i0 51.2 0.591346153846154 41 16 59.1 1 2 124 20 56 MBQ6248075.1 DEAD/DEAH box helicase family protein [Kiritimatiellia bacterium] diamond 123 42.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28023921 28023921 PRJNA474911_P_NODE_7845_length_204_cov_0.895105_g7718_i0 PRJNA474911 7845 204 0.895105 1.8260142 Phenylobacterium sp. 1871053 Bacteria Bacteria 132 6.32e-35   NR WP_333586332.1 1871053 g7718 i0 100 1.97058823529412 67 0 98.5 0 3 203 41 107 WP_333586332.1 mechanosensitive ion channel [Phenylobacterium sp.] diamond 402 132 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Phenylobacterium Phenylobacterium sp.
28213007 28213007 PRJNA474911_P_NODE_6146_length_226_cov_1.236364_g6019_i0 PRJNA474911 6146 226 1.236364 2.79418264 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42 0.0448   NR MEN1727192.1 1977087 g6019 i0 38 0.663716814159292 50 29 63.7 1 32 175 113 162 MEN1727192.1 hypothetical protein [Pseudomonadota bacterium] diamond 150 42 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28671532 28671532 PRJNA474911_P_NODE_7927_length_203_cov_0.901408_g7800_i0 PRJNA474911 7927 203 0.901408 1.82985824 Sphingomonas 13687 Bacteria Bacteria 53.1 9.69e-7   NR WP_138995789.1 1112213 g7800 i0 47.5 2.61576354679803 61 32 90.1 0 203 21 17 77 WP_138995789.1 hypothetical protein [Sphingomonas sp. PAMC 26621] diamond 531 53.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. PAMC 26621
28750047 28750047 PRJNA474911_P_NODE_6987_length_209_cov_0.864865_g6860_i0 PRJNA474911 6987 209 0.864865 1.80756785 Bradyrhizobium lablabi 722472 Bacteria Bacteria 120 2.24e-31   NR WP_212217550.1 722472 g6860 i0 81.2 0.990430622009569 69 13 99 0 209 3 32 100 WP_212217550.1 amidohydrolase family protein [Bradyrhizobium lablabi] diamond 207 120 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium lablabi
29760244 29760244 PRJNA474911_P_NODE_8471_length_193_cov_2.287879_g8344_i0 PRJNA474911 8471 193 2.287879 4.41560647 Acinetobacter baumannii 470 Bacteria Bacteria 76.6 1.82e-16   NR WP_306225785.1 470 g8344 i0 92.7 0.854922279792746 55 4 85.5 0 3 167 5 59 WP_306225785.1 hypothetical protein [Acinetobacter baumannii] diamond 165 76.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
30297911 30297911 PRJNA474911_P_NODE_4712_length_265_cov_1.509804_g4585_i0 PRJNA474911 4712 265 1.509804 4.0009806 Sulfuricella sp. T 2099377 Bacteria Bacteria 50.8 5.74e-5   NR WP_144408221.1 1632857 g4585 i0 40.8 0.80377358490566 71 41 80.4 1 50 262 150 219 WP_144408221.1 phosphatase PAP2 family protein [Sulfuricella sp. T08] diamond 213 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sulfuricellaceae Sulfuricella Sulfuricella sp. T08
30676432 30676432 PRJNA474911_P_NODE_7913_length_203_cov_1.218310_g7786_i0 PRJNA474911 7913 203 1.21831 2.4731693 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42.7 0.0219   NR MES2919868.1 1977087 g7786 i0 46.4 0.827586206896552 56 26 79.8 2 187 26 396 449 MES2919868.1 DUF3999 domain-containing protein [Pseudomonadota bacterium] diamond 168 42.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30739735 30739735 PRJNA474911_P_NODE_7054_length_209_cov_0.864865_g6927_i0 PRJNA474911 7054 209 0.864865 1.80756785 Acinetobacter lwoffii 28090 Bacteria Bacteria 135 5.77e-36   NR WP_253114842.1 28090 g6927 i0 100 0.990430622009569 69 0 99 0 2 208 314 382 WP_253114842.1 hypothetical protein [Acinetobacter lwoffii] diamond 207 135 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter lwoffii
30914021 30914021 PRJNA474911_P_NODE_8554_length_188_cov_2.007874_g8427_i0 PRJNA474911 8554 188 2.007874 3.77480312 Yoonia 2211641 Bacteria Bacteria 43.1 0.0131   NR WP_409696605.1 2212373 g8427 i0 42.6 1.9468085106383 61 32 97.3 1 187 5 25 82 WP_409696605.1 hypothetical protein [Yoonia sp.] diamond 366 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Yoonia Yoonia sp.
31056042 31056042 PRJNA474911_P_NODE_3575_length_315_cov_1.480315_g3449_i0 PRJNA474911 3575 315 1.480315 4.66299225 Rhizobacter sp. 1909292 Bacteria Bacteria 116 3.38e-30   NR MET0334258.1 1909292 g3449 i0 52.8 1.00952380952381 106 49 100 1 315 1 75 180 MET0334258.1 glutathione transferase GstA [Rhizobacter sp.] diamond 318 116 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Rhizobacter Rhizobacter sp.
31150061 31150061 PRJNA474911_P_NODE_7215_length_208_cov_0.870748_g7088_i0 PRJNA474911 7215 208 0.870748 1.81115584 Rickettsia endosymbiont of Ixodes persulcatus 2005673 Bacteria Bacteria 147 1.71e-42   NR MCZ6914134.1 2005673 g7088 i0 95.7 0.995192307692308 69 3 99.5 0 208 2 131 199 MCZ6914134.1 endonuclease/exonuclease/phosphatase family protein [Rickettsia endosymbiont of Ixodes persulcatus] diamond 207 147 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Rickettsia Rickettsia endosymbiont of Ixodes persulcatus
31308518 31308518 PRJNA474911_P_NODE_7015_length_209_cov_0.864865_g6888_i0 PRJNA474911 7015 209 0.864865 1.80756785 Sphingomonas liriopis 2949094 Bacteria Bacteria 112 5.880000000000001e-27   NR WP_254289494.1 2949094 g6888 i0 79.7 4.95215311004785 69 14 99 0 3 209 123 191 WP_254289494.1 amino acid permease [Sphingomonas liriopis] diamond 1035 112 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas liriopis
31340218 31340218 PRJNA474911_P_NODE_6976_length_209_cov_1.182432_g6849_i0 PRJNA474911 6976 209 1.182432 2.47128288 Bdellovibrio sp. qaytius 1916293 Bacteria Bacteria 42 0.0453   NR AZZ35451.1 1916293 g6849 i0 45 0.574162679425837 40 22 57.4 0 130 11 314 353 AZZ35451.1 catalase/peroxidase HPI [Bdellovibrio sp. qaytius] diamond 120 42 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. qaytius
32099377 32099377 PRJNA474911_P_NODE_4398_length_277_cov_1.393519_g4271_i0 PRJNA474911 4398 277 1.393519 3.86004763 Paracoccus spongiarum 3064387 Bacteria Bacteria 42.4 0.0303   NR WP_305962362.1 3064387 g4271 i0 45.7 0.498194945848375 46 25 49.8 0 71 208 53 98 WP_305962362.1 YraN family protein [Paracoccus spongiarum] diamond 138 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus spongiarum

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