RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where analysis = "diamond", bioproject = "PRJNA685060" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 33 ✖

tax_kingdom 1

bioproject 1

  • PRJNA685060 · 33 ✖

analysis 1

  • diamond · 33 ✖

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
3217028 3217028 PRJNA685060_P_NODE_15723_length_245_cov_0.895349_g15633_i0 PRJNA685060 15723 245 0.895349 2.19360505 Cellvibrio 10 Bacteria Bacteria 151 4.92e-42   NR WP_310067776.1 126350 g15633 i0 87.7 1.98367346938776 81 10 99.2 0 3 245 225 305 WP_310067776.1 amino acid deaminase [Cellvibrio fibrivorans] diamond 486 151 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Cellvibrionaceae Cellvibrio Cellvibrio fibrivorans
10104664 10104664 PRJNA685060_P_NODE_11228_length_280_cov_1.425121_g11138_i0 PRJNA685060 11228 280 1.425121 3.9903388 uncultured Sphingomonas sp. 158754 Bacteria Bacteria 135 3.22e-39   NR WP_288937652.1 158754 g11138 i0 95.8 0.771428571428571 72 3 77.1 0 280 65 33 104 WP_288937652.1 ArsR/SmtB family transcription factor [uncultured Sphingomonas sp.] diamond 216 135 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas uncultured Sphingomonas sp.
15968849 15968849 PRJNA685060_P_NODE_16813_length_243_cov_0.905882_g16723_i0 PRJNA685060 16813 243 0.905882 2.20129326 unclassified Sphingomonas 196159 Bacteria Bacteria 144 2.12e-39   NR WP_115379161.1 196159 g16723 i0 88.9 1 81 9 100 0 1 243 209 289 WP_115379161.1 MULTISPECIES: deoxyguanosinetriphosphate triphosphohydrolase [unclassified Sphingomonas] diamond 243 144 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
18518206 18518206 PRJNA685060_P_NODE_11435_length_277_cov_0.970588_g11345_i0 PRJNA685060 11435 277 0.970588 2.68852876 Bosea vaviloviae 1526658 Bacteria Bacteria 172 1.17e-49   NR WP_054209838.1 1526658 g11345 i0 98.9 0.985559566787004 91 1 98.6 0 3 275 327 417 WP_054209838.1 sensor histidine kinase [Bosea vaviloviae] diamond 273 172 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea vaviloviae
23619001 23619001 PRJNA685060_P_NODE_14339_length_249_cov_0.875000_g14249_i0 PRJNA685060 14339 249 0.875 2.17875 Sphingomonas beigongshangi 2782540 Bacteria Bacteria 170 3.269999999999999e-47   NR WP_246848265.1 2782540 g14249 i0 100 0.987951807228916 82 0 98.8 0 248 3 507 588 WP_246848265.1 UDP-galactopyranose mutase [Sphingomonas beigongshangi] diamond 246 170 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas beigongshangi
26872642 26872642 PRJNA685060_P_NODE_6321_length_380_cov_1.000000_g6231_i0 PRJNA685060 6321 380 1 3.8 Methylophaga 40222 Bacteria Bacteria 151 1.75e-39   NR MBE0438484.1 1913989 g6231 i0 68.7 3.10263157894737 99 31 78.2 0 82 378 5 103 MBE0438484.1 methionine synthase [Gammaproteobacteria bacterium] diamond 1179 152 0.993421052631579 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27366948 27366948 PRJNA685060_P_NODE_13983_length_250_cov_0.870056_g13893_i0 PRJNA685060 13983 250 0.870056 2.17514 Sandaracinobacteroides hominis 2780086 Bacteria Bacteria 63.2 7.63e-11   NR WP_199556199.1 2780086 g13893 i0 100 0.372 31 0 37.2 0 249 157 57 87 WP_199556199.1 XrtV sorting system accessory protein [Sandaracinobacteroides hominis] diamond 93 63.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingosinicellaceae Sandaracinobacteroides Sandaracinobacteroides hominis
27682783 27682783 PRJNA685060_P_NODE_11764_length_272_cov_1.507538_g11674_i0 PRJNA685060 11764 272 1.507538 4.10050336 Sphingomonas sp. S-NIH.Pt15_ 28214 Bacteria Bacteria 89 3.2e-19   NR WP_125996107.1 1920129 g11674 i0 51.1 0.992647058823529 90 43 98.2 1 268 2 6 95 WP_125996107.1 YmfQ family protein [Sphingomonas sp. S-NIH.Pt15_0812] diamond 270 89 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. S-NIH.Pt15_0812
27808966 27808966 PRJNA685060_P_NODE_13284_length_251_cov_1.365169_g13194_i0 PRJNA685060 13284 251 1.365169 3.42657419 Nevskia ramosa 64002 Bacteria Bacteria 40.4 0.0357   NR WP_022976971.1 64002 g13194 i0 84 0.298804780876494 25 4 29.9 0 130 204 10 34 WP_022976971.1 hypothetical protein [Nevskia ramosa] diamond 75 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Nevskia Nevskia ramosa
28029850 28029850 PRJNA685060_P_NODE_16645_length_243_cov_0.905882_g16555_i0 PRJNA685060 16645 243 0.905882 2.20129326 Bosea sp. (in: a-proteobacteria) 1871050 Bacteria Bacteria 166 7.85e-51   NR WP_372690462.1 1871050 g16555 i0 98.8 0.987654320987654 80 1 98.8 0 242 3 81 160 WP_372690462.1 peptidoglycan-binding domain-containing protein [Bosea sp. (in: a-proteobacteria)] diamond 240 166 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea sp. (in: a-proteobacteria)
28282117 28282117 PRJNA685060_P_NODE_16046_length_245_cov_0.895349_g15956_i0 PRJNA685060 16046 245 0.895349 2.19360505 Lysobacteraceae bacterium 1926873 Bacteria Bacteria 151 2.13e-40   NR MBA4285940.1 1926873 g15956 i0 87.7 0.991836734693878 81 10 99.2 0 2 244 430 510 MBA4285940.1 hypothetical protein [Lysobacteraceae bacterium] diamond 243 151 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae   Lysobacteraceae bacterium
28629866 28629866 PRJNA685060_P_NODE_16627_length_243_cov_0.905882_g16537_i0 PRJNA685060 16627 243 0.905882 2.20129326 Sphingomonas melonis 152682 Bacteria Bacteria 169 1.1999999999999998e-48   NR MFE8106712.1 152682 g16537 i0 100 0.987654320987654 80 0 98.8 0 242 3 66 145 MFE8106712.1 glycosyltransferase [Sphingomonas melonis] diamond 240 169 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas melonis
28724421 28724421 PRJNA685060_P_NODE_12867_length_257_cov_1.217391_g12777_i0 PRJNA685060 12867 257 1.217391 3.12869487 Pseudomonas sp. 2822-15 1712677 Bacteria Bacteria 43.9 0.00232   NR WP_256593155.1 1712677 g12777 i0 100 0.280155642023346 24 0 28 0 255 184 1 24 WP_256593155.1 hypothetical protein, partial [Pseudomonas sp. 2822-15] diamond 72 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. 2822-15
28755932 28755932 PRJNA685060_P_NODE_13647_length_251_cov_0.865169_g13557_i0 PRJNA685060 13647 251 0.865169 2.17157419 Roseomonas mucosa 207340 Bacteria Bacteria 138 1.91e-39   NR UZO95001.1 207340 g13557 i0 79.5 0.99203187250996006 83 17 99.2 0 2 250 79 161 UZO95001.1 Hypothetical protein RMHFA_05591 [Roseomonas mucosa] diamond 249 138 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Roseomonas Roseomonas mucosa
28945644 28945644 PRJNA685060_P_NODE_16528_length_243_cov_1.635294_g16438_i0 PRJNA685060 16528 243 1.635294 3.97376442 Sphingomonas beigongshangi 2782540 Bacteria Bacteria 68.9 2.24e-11   NR WP_246848190.1 2782540 g16438 i0 100 0.469135802469136 38 0 46.9 0 130 243 1 38 WP_246848190.1 M13 family metallopeptidase [Sphingomonas beigongshangi] diamond 114 68.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas beigongshangi
29040359 29040359 PRJNA685060_P_NODE_7308_length_352_cov_1.376344_g7218_i0 PRJNA685060 7308 352 1.376344 4.84473088 Nitrosomonas sp. 42353 Bacteria Bacteria 93.2 2.71e-19   NR HNJ38565.1 42353 g7218 i0 45 2.8125 109 59 92 1 27 350 999 1107 HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.] diamond 990 93.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
29260949 29260949 PRJNA685060_P_NODE_4269_length_469_cov_4.593434_g4179_i0 PRJNA685060 4269 469 4.593434 21.54320546 Chitinimonas koreensis 356302 Bacteria Bacteria 45.4 0.0315   NR WP_187523596.1 356302 g4179 i0 32.4 0.473347547974414 74 45 47.3 1 183 404 221 289 WP_187523596.1 DUF4166 domain-containing protein [Chitinimonas koreensis] diamond 222 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinimonas Chitinimonas koreensis
29292666 29292666 PRJNA685060_P_NODE_12129_length_267_cov_1.417526_g12039_i0 PRJNA685060 12129 267 1.417526 3.78479442 Sphingomonas aquatilis 93063 Bacteria Bacteria 92.4 4.670000000000001e-21   NR WP_331360828.1 93063 g12039 i0 93.6 0.528089887640449 47 3 52.8 0 142 2 1 47 WP_331360828.1 hypothetical protein [Sphingomonas aquatilis] diamond 141 92.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas aquatilis
29418874 29418874 PRJNA685060_P_NODE_15009_length_247_cov_0.885057_g14919_i0 PRJNA685060 15009 247 0.885057 2.18609079 Nevskia sp. 1929292 Bacteria Bacteria 174 1.61e-49   NR WP_292997880.1 1929292 g14919 i0 100 0.983805668016194 81 0 98.4 0 3 245 384 464 WP_292997880.1 asparagine synthase-related protein [Nevskia sp.] diamond 243 174 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae Nevskia Nevskia sp.
30082044 30082044 PRJNA685060_P_NODE_12612_length_260_cov_1.647059_g12522_i0 PRJNA685060 12612 260 1.647059 4.2823534 Bosea vaviloviae 1526658 Bacteria Bacteria 82.8 3.58e-16   NR WP_082364991.1 1526658 g12522 i0 97.5 0.461538461538462 40 1 46.2 0 260 141 513 552 WP_082364991.1 NAD(P)H-hydrate dehydratase [Bosea vaviloviae] diamond 120 82.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea vaviloviae
30176883 30176883 PRJNA685060_P_NODE_13512_length_251_cov_0.865169_g13422_i0 PRJNA685060 13512 251 0.865169 2.17157419 Sandaracinobacteroides hominis 2780086 Bacteria Bacteria 132 1.0999999999999999e-33   NR WP_199556107.1 2780086 g13422 i0 100 0.872509960159363 73 0 87.3 0 33 251 1 73 WP_199556107.1 TonB-dependent receptor [Sandaracinobacteroides hominis] diamond 219 132 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingosinicellaceae Sandaracinobacteroides Sandaracinobacteroides hominis
30208294 30208294 PRJNA685060_P_NODE_14692_length_248_cov_0.880000_g14602_i0 PRJNA685060 14692 248 0.88 2.1824 Xanthobacteraceae bacterium 2021379 Bacteria Bacteria 53.5 6.07e-6   NR MBX9844567.1 2021379 g14602 i0 47.1 0.616935483870968 51 27 61.7 0 246 94 196 246 MBX9844567.1 pyocin knob domain-containing protein [Xanthobacteraceae bacterium] diamond 153 53.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae   Xanthobacteraceae bacterium
30240220 30240220 PRJNA685060_P_NODE_13652_length_250_cov_3.372881_g13562_i0 PRJNA685060 13652 250 3.372881 8.4322025 Denitromonas iodatirespirans 2795389 Bacteria Bacteria 119 2.89e-30   NR WP_214361122.1 2795389 g13562 i0 68.3 5.868 82 26 98.4 0 250 5 101 182 WP_214361122.1 GTP 3',8-cyclase MoaA [Denitromonas iodatirespirans] diamond 1467 119 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Zoogloeaceae Denitromonas Denitromonas iodatirespirans
30555943 30555943 PRJNA685060_P_NODE_14153_length_249_cov_0.875000_g14063_i0 PRJNA685060 14153 249 0.875 2.17875 Sandaracinobacteroides hominis 2780086 Bacteria Bacteria 64.7 3.96e-10   NR WP_199556240.1 2780086 g14063 i0 100 0.987951807228916 82 0 98.8 0 248 3 95 176 WP_199556240.1 helix-turn-helix domain-containing protein [Sandaracinobacteroides hominis] diamond 246 64.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingosinicellaceae Sandaracinobacteroides Sandaracinobacteroides hominis
30555944 30555944 PRJNA685060_P_NODE_14393_length_249_cov_0.875000_g14303_i0 PRJNA685060 14393 249 0.875 2.17875 Ahrensia kielensis 76980 Bacteria Bacteria 42.7 0.0264   NR WP_041951536.1 76980 g14303 i0 31.7 0.72289156626506 60 39 71.1 2 66 242 35 93 WP_041951536.1 transglutaminase-like cysteine peptidase [Ahrensia kielensis] diamond 180 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Ahrensiaceae Ahrensia Ahrensia kielensis
30630760 30630760 PRJNA685060_P_NODE_14833_length_248_cov_0.880000_g14743_i0 PRJNA685060 14833 248 0.88 2.1824 Sphingosinicellaceae 2820280 Bacteria Bacteria 149 1.1199999999999999e-40   NR WP_140927447.1 1715348 g14743 i0 90.1 1.93548387096774 81 6 95.6 1 3 239 389 469 WP_140927447.1 helix-turn-helix domain-containing protein [Sandaracinobacter neustonicus] diamond 480 149 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingosinicellaceae Sandaracinobacter Sandaracinobacter neustonicus
30694101 30694101 PRJNA685060_P_NODE_17713_length_241_cov_0.916667_g17623_i0 PRJNA685060 17713 241 0.916667 2.20916747 Sphingomonadaceae 41297 Bacteria Bacteria 128 4.54e-34   NR WP_183982371.1 535907 g17623 i0 86.3 9.92116182572614 80 11 99.6 0 241 2 163 242 WP_183982371.1 MlaD family protein [Sphingomonas jinjuensis] diamond 2391 129 0.992248062015504 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas jinjuensis
30777393 30777393 PRJNA685060_P_NODE_9494_length_308_cov_0.982979_g9404_i0 PRJNA685060 9494 308 0.982979 3.02757532 uncultured Sphingomonas sp. 158754 Bacteria Bacteria 157 1.43e-42   NR WP_298091922.1 158754 g9404 i0 85.7 0.818181818181818 84 12 81.8 0 253 2 2 85 WP_298091922.1 terminase gpA endonuclease subunit, partial [uncultured Sphingomonas sp.] diamond 252 157 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas uncultured Sphingomonas sp.
31472846 31472846 PRJNA685060_P_NODE_16036_length_245_cov_0.895349_g15946_i0 PRJNA685060 16036 245 0.895349 2.19360505 Sandaracinobacteroides hominis 2780086 Bacteria Bacteria 159 1.02e-45   NR WP_199553661.1 2780086 g15946 i0 100 0.991836734693878 81 0 99.2 0 245 3 210 290 WP_199553661.1 P-loop NTPase [Sandaracinobacteroides hominis] diamond 243 159 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingosinicellaceae Sandaracinobacteroides Sandaracinobacteroides hominis
31610898 31610898 PRJNA685060_P_NODE_17116_length_242_cov_0.911243_g17026_i0 PRJNA685060 17116 242 0.911243 2.20520806 Alphaproteobacteria 28211 Bacteria Bacteria 84.3 7.82e-17   NR WP_055458341.1 363953 g17026 i0 57.3 21.2727272727273 75 32 93 0 228 4 323 397 WP_055458341.1 NADH-quinone oxidoreductase subunit M [Chelatococcus sambhunathii] diamond 5148 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Chelatococcaceae Chelatococcus Chelatococcus sambhunathii
31662298 31662298 PRJNA685060_P_NODE_16997_length_242_cov_0.911243_g16907_i0 PRJNA685060 16997 242 0.911243 2.20520806 Bosea vaviloviae 1526658 Bacteria Bacteria 143 2.86e-41   NR WP_248310709.1 1526658 g16907 i0 100 0.991735537190083 80 0 99.2 0 2 241 68 147 WP_248310709.1 HupE/UreJ family protein [Bosea vaviloviae] diamond 240 143 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Boseaceae Bosea Bosea vaviloviae
31946974 31946974 PRJNA685060_P_NODE_16597_length_243_cov_0.905882_g16507_i0 PRJNA685060 16597 243 0.905882 2.20129326 Candidatus Raskinella chloraquaticus 1951219 Bacteria Bacteria 155 1.15e-45   NR WP_376801014.1 1951219 g16507 i0 100 1 81 0 100 0 243 1 3 83 WP_376801014.1 50S ribosomal protein L1 [Candidatus Raskinella chloraquaticus] diamond 243 155 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phreatobacteraceae Candidatus Raskinella Candidatus Raskinella chloraquaticus
32263857 32263857 PRJNA685060_P_NODE_15058_length_247_cov_0.885057_g14968_i0 PRJNA685060 15058 247 0.885057 2.18609079 unclassified Devosia 196773 Bacteria Bacteria 44.7 0.00798   NR WP_291308987.1 196773 g14968 i0 36 0.607287449392713 50 32 60.7 0 176 27 565 614 WP_291308987.1 MULTISPECIES: alpha-amylase family protein [unclassified Devosia] diamond 150 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae Devosia  

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