RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA930380" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA930380 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
26803293 26803293 PRJNA930380_P_NODE_8961_length_277_cov_2.264706_g8908_i0 PRJNA930380 8961 277 2.264706 6.27323562 Thiolapillus sp. 2017437 Bacteria Bacteria 61.2 1.56e-8   NR WP_368857476.1 2017437 g8908 i0 42 4.76534296028881 88 51 95.3 0 276 13 201 288 WP_368857476.1 reverse transcriptase domain-containing protein, partial [Thiolapillus sp.] diamond 1320 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Thiolapillus Thiolapillus sp.
27182768 27182768 PRJNA930380_P_NODE_5182_length_296_cov_2.062780_g5129_i0 PRJNA930380 5182 296 2.06278 6.1058288 Steroidobacteraceae bacterium 2689616 Bacteria Bacteria 45.4 0.0066   NR HEY8509077.1 2689616 g5129 i0 32.9 0.861486486486487 85 47 76 2 10 234 144 228 HEY8509077.1 SDR family NAD(P)-dependent oxidoreductase [Steroidobacteraceae bacterium] diamond 255 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Steroidobacterales Steroidobacteraceae   Steroidobacteraceae bacterium
27182771 27182771 PRJNA930380_P_NODE_7882_length_283_cov_1.457143_g7829_i0 PRJNA930380 7882 283 1.457143 4.12371469 unclassified Glaciimonas 2644401 Bacteria Bacteria 43.9 0.0169   NR WP_323506359.1 2644401 g7829 i0 39.7 0.614840989399293 58 34 60.4 1 81 251 139 196 WP_323506359.1 MULTISPECIES: phosphatase PAP2 family protein [unclassified Glaciimonas] diamond 174 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Glaciimonas  
27688785 27688785 PRJNA930380_P_NODE_13144_length_245_cov_0.895349_g13091_i0 PRJNA930380 13144 245 0.895349 2.19360505 Mitsuaria sp. WAJ17 2761452 Bacteria Bacteria 144 2.5499999999999994e-42   NR WP_183102716.1 2761452 g13091 i0 92.6 0.991836734693878 81 6 99.2 0 1 243 37 117 WP_183102716.1 RNA-binding S4 domain-containing protein [Mitsuaria sp. WAJ17] diamond 243 144 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Mitsuaria sp. WAJ17
27720431 27720431 PRJNA930380_P_NODE_7684_length_284_cov_1.289100_g7631_i0 PRJNA930380 7684 284 1.2891 3.661044 Sneathiella sp. 1964365 Bacteria Bacteria 45.8 0.00346   NR WP_293950268.1 1964365 g7631 i0 40.6 0.72887323943662 69 36 72.9 2 70 276 129 192 WP_293950268.1 DUF2062 domain-containing protein [Sneathiella sp.] diamond 207 45.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sneathiellales Sneathiellaceae Sneathiella Sneathiella sp.
27972540 27972540 PRJNA930380_P_NODE_6265_length_290_cov_1.419355_g6212_i0 PRJNA930380 6265 290 1.419355 4.1161295 Cellvibrionaceae bacterium 2026723 Bacteria Bacteria 43.1 0.0449   NR MAZ86849.1 2026723 g6212 i0 55.3 0.393103448275862 38 16 39.3 1 5 118 221 257 MAZ86849.1 hypothetical protein [Cellvibrionaceae bacterium] diamond 114 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Cellvibrionaceae   Cellvibrionaceae bacterium
28035778 28035778 PRJNA930380_P_NODE_11825_length_250_cov_0.870056_g11772_i0 PRJNA930380 11825 250 0.870056 2.17514 unclassified Sphingomonas 196159 Bacteria Bacteria 158 9.54e-44   NR WP_137864156.1 196159 g11772 i0 100 0.996 83 0 99.6 0 1 249 137 219 WP_137864156.1 MULTISPECIES: SulP family inorganic anion transporter [unclassified Sphingomonas] diamond 249 158 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
28667324 28667324 PRJNA930380_P_NODE_7927_length_283_cov_1.109524_g7874_i0 PRJNA930380 7927 283 1.109524 3.13995292 Vibrio parahaemolyticus 670 Bacteria Bacteria 73.6 6.52e-14   NR MDF4259844.1 670 g7874 i0 50 0.80565371024735 76 36 78.4 2 36 257 16 91 MDF4259844.1 reverse transcriptase domain-containing protein [Vibrio parahaemolyticus] diamond 228 73.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
28730345 28730345 PRJNA930380_P_NODE_12807_length_246_cov_1.734104_g12754_i0 PRJNA930380 12807 246 1.734104 4.26589584 Candidatus Jidaibacter acanthamoeba 1891672 Bacteria Bacteria 73.9 3.88e-13   NR WP_039455795.1 86105 g12754 i0 71.7 0.560975609756098 46 13 56.1 0 71 208 542 587 WP_039455795.1 NAD(P)-dependent oxidoreductase [Candidatus Jidaibacter acanthamoeba] diamond 138 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Candidatus Midichloriaceae Candidatus Jidaibacter Candidatus Jidaibacter acanthamoebae
28761779 28761779 PRJNA930380_P_NODE_9047_length_277_cov_1.303922_g8994_i0 PRJNA930380 9047 277 1.303922 3.61186394 Sphingomonadales bacterium 1978525 Bacteria Bacteria 42.4 0.0385   NR MDE2405464.1 1978525 g8994 i0 36.1 0.660649819494585 61 37 66.1 2 262 80 65 123 MDE2405464.1 hypothetical protein [Sphingomonadales bacterium] diamond 183 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales     Sphingomonadales bacterium
28856442 28856442 PRJNA930380_P_NODE_7708_length_284_cov_1.137441_g7655_i0 PRJNA930380 7708 284 1.137441 3.23033244 Vibrio parahaemolyticus 670 Bacteria Bacteria 91.3 8.6e-21   NR MDF4259844.1 670 g7655 i0 48.9 1.90140845070423 90 44 93 1 267 4 10 99 MDF4259844.1 reverse transcriptase domain-containing protein [Vibrio parahaemolyticus] diamond 540 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
28888100 28888100 PRJNA930380_P_NODE_11708_length_250_cov_0.870056_g11655_i0 PRJNA930380 11708 250 0.870056 2.17514 Nevskiaceae bacterium 1969813 Bacteria Bacteria 48.9 2.81e-4   NR MBV8854719.1 1969813 g11655 i0 53.7 0.984 41 19 49.2 0 154 32 677 717 MBV8854719.1 DDE-type integrase/transposase/recombinase [Nevskiaceae bacterium] diamond 246 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae   Nevskiaceae bacterium
28888101 28888101 PRJNA930380_P_NODE_12368_length_248_cov_0.880000_g12315_i0 PRJNA930380 12368 248 0.88 2.1824 Ralstonia 48736 Bacteria Bacteria 90.1 1.84e-19   NR WP_024973549.1 48736 g12315 i0 100 0.556451612903226 46 0 55.6 0 248 111 255 300 WP_024973549.1 MULTISPECIES: S-methyl-5'-thioadenosine phosphorylase [Ralstonia] diamond 138 90.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia  
29046154 29046154 PRJNA930380_P_NODE_6188_length_290_cov_2.129032_g6135_i0 PRJNA930380 6188 290 2.129032 6.1741928 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 43.5 0.0323   NR MCK6424170.1 2030806 g6135 i0 40.4 0.486206896551724 47 28 48.6 0 224 84 52 98 MCK6424170.1 HupU protein [Burkholderiaceae bacterium] diamond 141 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
29337327 29337327 PRJNA930380_P_NODE_6929_length_287_cov_1.453271_g6876_i0 PRJNA930380 6929 287 1.453271 4.17088777 root 1 Root_unresolved Root_unresolved 76.6 7.77e-14   NR MEE4247466.1 2026751 g6876 i0 40.7 10.9756097560976 91 54 95.1 0 274 2 906 996 MEE4247466.1 reverse transcriptase domain-containing protein [Kangiellaceae bacterium] diamond 3150 76.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae   Kangiellaceae bacterium
29463180 29463180 PRJNA930380_P_NODE_7490_length_285_cov_1.103774_g7437_i0 PRJNA930380 7490 285 1.103774 3.1457559 root 1 Root_unresolved Root_unresolved 80.5 1.43e-16   NR MDF4259844.1 670 g7437 i0 45.3 4.81052631578947 95 50 97.9 1 282 4 5 99 MDF4259844.1 reverse transcriptase domain-containing protein [Vibrio parahaemolyticus] diamond 1371 80.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
29487915 29487915 PRJNA930380_P_NODE_9010_length_277_cov_1.509804_g8957_i0 PRJNA930380 9010 277 1.509804 4.18215708 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 47.8 9.53e-4   NR MCP3852634.1 1913989 g8957 i0 32.8 0.725631768953069 67 45 72.6 0 257 57 770 836 MCP3852634.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 201 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29684274 29684274 PRJNA930380_P_NODE_13250_length_245_cov_0.895349_g13197_i0 PRJNA930380 13250 245 0.895349 2.19360505 Roseomonadaceae 3385906 Bacteria Bacteria 107 2.04e-26   NR WP_241667242.1 1854500 g13197 i0 68.8 2.93877551020408 80 25 98 0 2 241 84 163 WP_241667242.1 IS5 family transposase [Roseomonas nepalensis] diamond 720 107 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Muricoccus Muricoccus nepalensis
29740428 29740428 PRJNA930380_P_NODE_2330_length_411_cov_2.307692_g2277_i0 PRJNA930380 2330 411 2.307692 9.48461412 Acinetobacter baumannii 470 Bacteria Bacteria 54.7 5.57e-7   NR WP_205731319.1 470 g2277 i0 58.7 0.45985401459854 63 26 46 0 169 357 1 63 WP_205731319.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 189 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
30025133 30025133 PRJNA930380_P_NODE_6871_length_287_cov_2.158879_g6818_i0 PRJNA930380 6871 287 2.158879 6.19598273 uncultured Gammaproteobacteria bacterium 86473 Bacteria Bacteria 57.4 4.46e-7   NR CAC9588992.1 86473 g6818 i0 40.5 1.91289198606272 84 49 87.8 1 284 33 352 434 CAC9588992.1 hypothetical protein, partial [uncultured Gammaproteobacteria bacterium] diamond 549 57.8 0.993079584775087 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
30063476 30063476 PRJNA930380_P_NODE_6271_length_290_cov_1.419355_g6218_i0 PRJNA930380 6271 290 1.419355 4.1161295 Pseudomonadati 3379134 Bacteria Bacteria 48.9 4.52e-4   NR WP_374210521.1 2017437 g6218 i0 36.6 5.13103448275862 82 51 83.8 1 269 27 695 776 WP_374210521.1 reverse transcriptase family protein [Thiolapillus sp.] diamond 1488 49.3 0.991886409736308 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Thiolapillus Thiolapillus sp.
30182908 30182908 PRJNA930380_P_NODE_8572_length_279_cov_2.985437_g8519_i0 PRJNA930380 8572 279 2.985437 8.32936923 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 63.5 2.71e-9   NR MDA8001621.1 1913988 g8519 i0 61.7 0.505376344086022 47 18 50.5 0 142 2 110 156 MDA8001621.1 reverse transcriptase domain-containing protein [Alphaproteobacteria bacterium] diamond 141 63.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30214379 30214379 PRJNA930380_P_NODE_6272_length_290_cov_1.419355_g6219_i0 PRJNA930380 6272 290 1.419355 4.1161295 uncultured Gammaproteobacteria bacterium 86473 Bacteria Bacteria 43.5 0.0325   NR CAC9599287.1 86473 g6219 i0 35.8 0.693103448275862 67 39 68.3 2 261 64 213 276 CAC9599287.1 hypothetical protein [uncultured Gammaproteobacteria bacterium] diamond 201 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
30719958 30719958 PRJNA930380_P_NODE_8174_length_281_cov_2.783654_g8121_i0 PRJNA930380 8174 281 2.783654 7.82206774 Thiolapillus sp. 2017437 Bacteria Bacteria 56.2 9.53e-7   NR WP_295437843.1 2017437 g8121 i0 68.4 6.86476868327402 38 12 40.6 0 9 122 271 308 WP_295437843.1 reverse transcriptase domain-containing protein, partial [Thiolapillus sp.] diamond 1929 56.6 0.992932862190813 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Thiolapillus Thiolapillus sp.
30758749 30758749 PRJNA930380_P_NODE_10994_length_257_cov_1.673913_g10941_i0 PRJNA930380 10994 257 1.673913 4.30195641 root 1 Root_unresolved Root_unresolved 162 1.02e-49   NR WP_353839214.1 470 g10941 i0 97.6 28.4941634241245 85 2 99.2 0 257 3 1 85 WP_353839214.1 50S ribosomal protein L19e, partial [Acinetobacter baumannii] diamond 7323 163 0.993865030674847 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
31359328 31359328 PRJNA930380_P_NODE_10736_length_262_cov_1.444444_g10683_i0 PRJNA930380 10736 262 1.444444 3.78444328 Pseudomonadota 1224 Bacteria Bacteria 180 6.11e-56   NR WP_202619792.1 562 g10683 i0 97.7 1.96946564885496 86 2 98.5 0 260 3 1 86 WP_202619792.1 alkaline phosphatase family protein, partial [Escherichia coli] diamond 516 181 0.994475138121547 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31517462 31517462 PRJNA930380_P_NODE_9476_length_274_cov_1.532338_g9423_i0 PRJNA930380 9476 274 1.532338 4.19860612 root 1 Root_unresolved Root_unresolved 66.6 9.16e-12   NR WP_367087474.1 28450 g9423 i0 51.8 2.05839416058394 56 27 61.3 0 15 182 2 57 WP_367087474.1 reverse transcriptase domain-containing protein, partial [Burkholderia pseudomallei] diamond 564 67 0.994029850746269 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia pseudomallei
31636718 31636718 PRJNA930380_P_NODE_7196_length_286_cov_1.446009_g7143_i0 PRJNA930380 7196 286 1.446009 4.13558574 Escherichia coli 562 Bacteria Bacteria 100 8.37e-23   NR WP_152854700.1 562 g7143 i0 47.3 10.6153846153846 93 49 97.6 0 281 3 172 264 WP_152854700.1 reverse transcriptase domain-containing protein, partial [Escherichia coli] diamond 3036 101 0.99009900990099 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31675362 31675362 PRJNA930380_P_NODE_7117_length_286_cov_2.051643_g7064_i0 PRJNA930380 7117 286 2.051643 5.86769898 root 1 Root_unresolved Root_unresolved 51.6 1.81e-5   NR MDF4259844.1 670 g7064 i0 36.8 7.48951048951049 76 45 76.6 1 2 220 4 79 MDF4259844.1 reverse transcriptase domain-containing protein [Vibrio parahaemolyticus] diamond 2142 51.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
31889778 31889778 PRJNA930380_P_NODE_9197_length_276_cov_1.517241_g9144_i0 PRJNA930380 9197 276 1.517241 4.18758516 Lautropia sp. SCN 69-89 1660104 Bacteria Bacteria 43.5 0.0305   NR ODS98130.1 1660104 g9144 i0 40 0.543478260869565 50 30 54.3 0 257 108 373 422 ODS98130.1 MAG: hypothetical protein ABS56_05840 [Lautropia sp. SCN 69-89] diamond 150 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Lautropia Lautropia sp. SCN 69-89
32680039 32680039 PRJNA930380_P_NODE_9920_length_271_cov_1.797980_g9867_i0 PRJNA930380 9920 271 1.79798 4.8725258 Burkholderia pseudomallei 28450 Bacteria Bacteria 47 3.95e-4   NR WP_367087474.1 28450 g9867 i0 58.1 0.697416974169742 31 13 34.3 0 4 96 11 41 WP_367087474.1 reverse transcriptase domain-containing protein, partial [Burkholderia pseudomallei] diamond 189 47 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia pseudomallei

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