RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1101048" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1101048 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
26940972 26940972 PRJNA1101048_P_NODE_7282_length_252_cov_0.865922_g7226_i0 PRJNA1101048 7282 252 0.865922 2.18212344 Klebsiella pneumoniae 573 Bacteria Bacteria 40.8 0.0383   NR MEI4920301.1 573 g7226 i0 51.3 0.464285714285714 39 6 46.4 1 199 83 3 28 MEI4920301.1 hypothetical protein [Klebsiella pneumoniae] diamond 117 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27004265 27004265 PRJNA1101048_P_NODE_9162_length_243_cov_0.911765_g9106_i0 PRJNA1101048 9162 243 0.911765 2.21558895 Hyphomicrobiaceae bacterium 2015799 Bacteria Bacteria 43.1 0.026   NR MCB1522331.1 2015799 g9106 i0 38.1 0.518518518518518 42 26 51.9 0 199 74 172 213 MCB1522331.1 YbfB/YjiJ family MFS transporter [Hyphomicrobiaceae bacterium] diamond 126 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae   Hyphomicrobiaceae bacterium
27288886 27288886 PRJNA1101048_P_NODE_9323_length_242_cov_0.923077_g9267_i0 PRJNA1101048 9323 242 0.923077 2.23384634 Klebsiella pneumoniae 573 Bacteria Bacteria 50.8 3.44e-6   NR WP_336509094.1 573 g9267 i0 91.7 0.297520661157025 24 2 29.8 0 242 171 7 30 WP_336509094.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 72 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27983586 27983586 PRJNA1101048_P_NODE_8805_length_244_cov_1.818713_g8749_i0 PRJNA1101048 8805 244 1.818713 4.43765972 Pseudomonas helleri 1608996 Bacteria Bacteria 76.6 1.77e-16   NR WP_228393237.1 1608996 g8749 i0 84.6 0.479508196721311 39 6 48 0 54 170 25 63 WP_228393237.1 hypothetical protein, partial [Pseudomonas helleri] diamond 117 76.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas helleri
28141730 28141730 PRJNA1101048_P_NODE_1625_length_440_cov_1.997275_g1569_i0 PRJNA1101048 1625 440 1.997275 8.78801 Klebsiella pneumoniae 573 Bacteria Bacteria 81.3 2.49e-17   NR MEI4896662.1 573 g1569 i0 86.4 0.3 44 5 29.3 1 253 381 1 44 MEI4896662.1 hypothetical protein [Klebsiella pneumoniae] diamond 132 81.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28425795 28425795 PRJNA1101048_P_NODE_9506_length_238_cov_2.024242_g9450_i0 PRJNA1101048 9506 238 2.024242 4.81769596 Klebsiella pneumoniae 573 Bacteria Bacteria 122 6.89e-34   NR MEI4920163.1 573 g9450 i0 88.7 0.781512605042017 62 7 78.2 0 187 2 1 62 MEI4920163.1 hypothetical protein [Klebsiella pneumoniae] diamond 186 122 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29120534 29120534 PRJNA1101048_P_NODE_2169_length_392_cov_0.974922_g2113_i0 PRJNA1101048 2169 392 0.974922 3.82169424 Shigella sonnei 624 Bacteria Bacteria 42 0.0342   NR ARR40544.1 624 g2113 i0 34.8 0.528061224489796 69 35 48.2 2 125 313 1 65 ARR40544.1 hypothetical protein B9127_13380 [Shigella sonnei] diamond 207 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
30280570 30280570 PRJNA1101048_P_NODE_7852_length_249_cov_0.886364_g7796_i0 PRJNA1101048 7852 249 0.886364 2.20704636 Pseudomonadota 1224 Bacteria Bacteria 99.4 1.44e-22   NR MDA8381779.1 1891241 g7796 i0 68.7 4 67 21 80.7 0 3 203 286 352 MDA8381779.1 tRNA guanosine(34) transglycosylase Tgt [Betaproteobacteria bacterium] diamond 996 100 0.994 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
30889175 30889175 PRJNA1101048_P_NODE_7154_length_252_cov_1.212291_g7098_i0 PRJNA1101048 7154 252 1.212291 3.05497332 Bradyrhizobium sp. BRP19 2793823 Bacteria Bacteria 42.4 0.0323   NR WP_225173172.1 2793823 g7098 i0 46.3 0.488095238095238 41 22 48.8 0 32 154 34 74 WP_225173172.1 acyltransferase family protein [Bradyrhizobium sp. BRP19] diamond 123 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. BRP19
31395003 31395003 PRJNA1101048_P_NODE_8496_length_246_cov_0.901734_g8440_i0 PRJNA1101048 8496 246 0.901734 2.21826564 Proteus penneri 102862 Bacteria Bacteria 42.7 0.0274   NR CRL60822.1 102862 g8440 i0 34.9 0.524390243902439 43 28 52.4 0 79 207 121 163 CRL60822.1 NADPH-dependent curcumin reductase [Proteus penneri] diamond 129 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Morganellaceae Proteus Proteus penneri
31647710 31647710 PRJNA1101048_P_NODE_4797_length_292_cov_1.397260_g4741_i0 PRJNA1101048 4797 292 1.39726 4.0799992 Klebsiella pneumoniae 573 Bacteria Bacteria 46.2 3.11e-4   NR MEI4927462.1 573 g4741 i0 55.3 0.39041095890411 38 17 39 0 118 5 7 44 MEI4927462.1 hypothetical protein [Klebsiella pneumoniae] diamond 114 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31670785 31670785 PRJNA1101048_P_NODE_7777_length_249_cov_1.153409_g7721_i0 PRJNA1101048 7777 249 1.153409 2.87198841 Pseudomonadota 1224 Bacteria Bacteria 42.7 0.0394   NR WP_293143781.1 78556 g7721 i0 55.2 0.698795180722892 29 13 34.9 0 141 227 401 429 WP_293143781.1 glyoxylate carboligase [Moritella sp.] diamond 174 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Moritellaceae Moritella Moritella sp.
31742667 31742667 PRJNA1101048_P_NODE_5217_length_283_cov_1.628571_g5161_i0 PRJNA1101048 5217 283 1.628571 4.60885593 Klebsiella pneumoniae 573 Bacteria Bacteria 66.6 3.51e-12   NR MEI4926877.1 573 g5161 i0 83.8 0.392226148409894 37 6 39.2 0 102 212 1 37 MEI4926877.1 hypothetical protein [Klebsiella pneumoniae] diamond 111 66.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32027566 32027566 PRJNA1101048_P_NODE_7018_length_253_cov_0.866667_g6962_i0 PRJNA1101048 7018 253 0.866667 2.19266751 Aestuariivirga sp. 2650926 Bacteria Bacteria 81.6 7.35e-18   NR WP_408915963.1 2650926 g6962 i0 78.7 1.11462450592885 47 10 55.7 0 246 106 7 53 WP_408915963.1 L-rhamnose mutarotase [Aestuariivirga sp.] diamond 282 81.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga sp.
32154123 32154123 PRJNA1101048_P_NODE_9118_length_243_cov_0.917647_g9062_i0 PRJNA1101048 9118 243 0.917647 2.22988221 Skermanella cutis 2775420 Bacteria Bacteria 45.4 0.00419   NR WP_201079445.1 2775420 g9062 i0 34.7 0.888888888888889 72 42 88.9 1 2 217 208 274 WP_201079445.1 ATP-binding protein [Skermanella cutis] diamond 216 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Azospirillaceae Skermanella Skermanella cutis
32185812 32185812 PRJNA1101048_P_NODE_9138_length_243_cov_0.917647_g9082_i0 PRJNA1101048 9138 243 0.917647 2.22988221 Pantoea sp. GM 69393 Bacteria Bacteria 42.4 0.0487   NR WP_036621002.1 1144320 g9082 i0 39.7 0.716049382716049 58 28 63 2 21 173 338 395 WP_036621002.1 MFS transporter [Pantoea sp. GM01] diamond 174 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Pantoea Pantoea sp. GM01
32754345 32754345 PRJNA1101048_P_NODE_6020_length_268_cov_1.174359_g5964_i0 PRJNA1101048 6020 268 1.174359 3.14728212 Zoogloea oleivorans 1552750 Bacteria Bacteria 45.4 0.00532   NR WP_148578587.1 1552750 g5964 i0 34.4 1.00746268656716 90 52 94 3 9 260 325 413 WP_148578587.1 MFS transporter [Zoogloea oleivorans] diamond 270 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Zoogloeaceae Zoogloea Zoogloea oleivorans

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