RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA453111" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA453111 · 23 ✖

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
441418 441418 PRJNA453111_P_NODE_12801_length_242_cov_0.911243_g12709_i0 PRJNA453111 12801 242 0.911243 2.20520806 Pseudomonadati 3379134 Bacteria Bacteria 137 2.03e-36   NR WP_407176481.1 578924 g12709 i0 75 32.7272727272727 80 20 99.2 0 242 3 276 355 WP_407176481.1 isocitrate lyase [Bradyrhizobium sp. STM 3562] diamond 7920 137 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. STM 3562
2992025 2992025 PRJNA453111_P_NODE_10683_length_249_cov_0.875000_g10591_i0 PRJNA453111 10683 249 0.875 2.17875 Terribium terrae 2725666 Bacteria Bacteria 460 3.16e-125   NTclustered gi|1752754875|gb|CP044218.1| 2725666 g10591 i0 100 64.6706827309237 249 0 100 0 1 249 3572184 3571936 Mesorhizobium terrae strain NIBRBAC000500504 chromosome, complete genome blastn 16103 460 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Terribium Terribium terrae
4268436 4268436 PRJNA453111_P_NODE_13024_length_241_cov_0.916667_g12932_i0 PRJNA453111 13024 241 0.916667 2.20916747 Bradyrhizobium sp. PSBB068 2715960 Bacteria Bacteria 446 8.519999999999999e-121   NTclustered gi|1979381481|gb|CP069300.1| 2715960 g12932 i0 100 42.7966804979253 241 0 100 0 1 241 4027655 4027415 Bradyrhizobium sp. PSBB068 chromosome, complete genome blastn 10314 446 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. PSBB068
5545095 5545095 PRJNA453111_P_NODE_10285_length_250_cov_0.870056_g10193_i0 PRJNA453111 10285 250 0.870056 2.17514 Bradyrhizobium sp. PSBB068 2715960 Bacteria Bacteria 462 8.83e-126   NTclustered gi|1979381481|gb|CP069300.1| 2715960 g10193 i0 100 97.756 250 0 100 0 1 250 5136916 5136667 Bradyrhizobium sp. PSBB068 chromosome, complete genome blastn 24439 462 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. PSBB068
9369277 9369277 PRJNA453111_P_NODE_12448_length_243_cov_0.905882_g12356_i0 PRJNA453111 12448 243 0.905882 2.20129326 Ralstonia insidiosa 190721 Bacteria Bacteria 449 6.65e-122   NTclustered gi|1036241154|gb|CP016023.1| 190721 g12356 i0 100 83.8600823045268 243 0 100 0 1 243 339164 338922 Ralstonia insidiosa strain ATCC 49129 chromosome 2, complete sequence blastn 20378 449 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia insidiosa
11920257 11920257 PRJNA453111_P_NODE_9050_length_267_cov_1.190722_g8958_i0 PRJNA453111 9050 267 1.190722 3.17922774 Kosakonia arachidis 551989 Bacteria Bacteria 56.5 0.002   NTclustered gi|1769903668|gb|CP045299.1| 551989 g8958 i0 96.97 0.123595505617978 33 1 12 0 203 235 25488 25456 Kosakonia arachidis strain KACC 18508 plasmid unnamed1, complete sequence blastn 33 56.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Kosakonia Kosakonia arachidis
13194969 13194969 PRJNA453111_P_NODE_10151_length_251_cov_0.865169_g10059_i0 PRJNA453111 10151 251 0.865169 2.17157419 Methyloversatilis sp. RAC08 1842540 Bacteria Bacteria 414 2.52e-111   NTclustered gi|1059487190|gb|CP016448.1| 1842540 g10059 i0 96.414 224.486055776892 251 9 100 0 1 251 844965 844715 Methyloversatilis sp. RAC08 chromosome, complete genome blastn 56346 414 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp. RAC08
15120687 15120687 PRJNA453111_P_NODE_7952_length_287_cov_1.065421_g7860_i0 PRJNA453111 7952 287 1.065421 3.05775827 Comamonas 283 Bacteria Bacteria 486 6.139999999999999e-133   NTclustered gi|507148303|ref|NR_103106.1| 285 g7860 i0 97.213 420.620209059233 287 8 100 0 1 287 1145 1431 Comamonas testosteroni strain CNB-1 23S ribosomal RNA gene, complete sequence blastn 120718 486 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas testosteroni
18293023 18293023 PRJNA453111_P_NODE_11675_length_246_cov_0.890173_g11583_i0 PRJNA453111 11675 246 0.890173 2.18982558 Mixta calida 665913 Bacteria Bacteria 52.8 0.022   NTclustered gi|1907656030|gb|CP061511.1| 665913 g11583 i0 100 0.227642276422764 28 0 11 0 14 41 3529897 3529870 Mixta calida strain 5098PV chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Mixta Mixta calida
23393647 23393647 PRJNA453111_P_NODE_4719_length_372_cov_1.190635_g4627_i0 PRJNA453111 4719 372 1.190635 4.4291622 Mesorhizobium loti 381 Bacteria Bacteria 54.7 0.01   NTclustered gi|1050758791|dbj|AP017605.1| 381 g4627 i0 96.875 0.161290322580645 32 1 9 0 154 185 2839721 2839752 Mesorhizobium loti DNA, nearly complete genome, strain: TONO blastn 60 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium loti
24044772 24044772 PRJNA453111_P_NODE_9199_length_264_cov_1.905759_g9107_i0 PRJNA453111 9199 264 1.905759 5.03120376 Burkholderia 32008 Bacteria Bacteria 82.4 3.08e-11   NTclustered gi|2304481520|gb|CP104215.1| 28095 g9107 i0 94.34 35.9090909090909 53 3 20 0 17 69 1071718 1071666 Burkholderia gladioli strain ZN-S4 chromosome 2, complete sequence blastn 9480 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia gladioli
24667579 24667579 PRJNA453111_P_NODE_12500_length_243_cov_0.905882_g12408_i0 PRJNA453111 12500 243 0.905882 2.20129326 Aquipseudomonas campi 2731681 Bacteria Bacteria 54.7 0.006   NTclustered gi|1876483579|gb|CP053697.2| 2731681 g12408 i0 96.875 0.131687242798354 32 1 13 0 38 69 2709033 2709002 Aquipseudomonas campi strain S1-A32-2 chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Aquipseudomonas Aquipseudomonas campi
27138914 27138914 PRJNA453111_P_NODE_7942_length_287_cov_1.084112_g7850_i0 PRJNA453111 7942 287 1.084112 3.11140144 Variovorax sp. J22R133 3053503 Bacteria Bacteria 43.5 0.0328   NR WP_286562580.1 3053503 g7850 i0 42.9 0.585365853658537 56 30 57.5 2 265 101 277 331 WP_286562580.1 PglL family O-oligosaccharyltransferase [Variovorax sp. J22R133] diamond 168 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax brevis
27834113 27834113 PRJNA453111_P_NODE_12464_length_243_cov_0.905882_g12372_i0 PRJNA453111 12464 243 0.905882 2.20129326 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 44.7 0.00771   NR MSQ54280.1 1891241 g12372 i0 38.7 0.925925925925926 75 43 90.1 2 19 237 294 367 MSQ54280.1 MFS transporter [Betaproteobacteria bacterium] diamond 225 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
28055094 28055094 PRJNA453111_P_NODE_5745_length_337_cov_1.659091_g5653_i0 PRJNA453111 5745 337 1.659091 5.59113667 Spiribacter pallidus 1987936 Bacteria Bacteria 44.7 0.0213   NR WP_367985223.1 1987936 g5653 i0 28.4 0.72106824925816 81 48 63.2 2 49 261 119 199 WP_367985223.1 CynX/NimT family MFS transporter [Spiribacter pallidus] diamond 243 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae Spiribacter Spiribacter pallidus
28086687 28086687 PRJNA453111_P_NODE_5285_length_351_cov_1.586331_g5193_i0 PRJNA453111 5285 351 1.586331 5.56802181 Chitinimonas sp. 1934313 Bacteria Bacteria 78.6 2.42e-14   NR WP_374349013.1 1934313 g5193 i0 35.1 0.974358974358974 114 74 97.4 0 1 342 65 178 WP_374349013.1 M35 family metallo-endopeptidase [Chitinimonas sp.] diamond 342 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinimonas Chitinimonas sp.
28212843 28212843 PRJNA453111_P_NODE_9366_length_261_cov_1.303191_g9274_i0 PRJNA453111 9366 261 1.303191 3.40132851 Klebsiella pneumoniae 573 Bacteria Bacteria 42.4 0.00926   NR WP_416493070.1 573 g9274 i0 53.1 0.735632183908046 64 29 73.6 1 55 246 9 71 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 192 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28812660 28812660 PRJNA453111_P_NODE_12328_length_244_cov_0.888889_g12236_i0 PRJNA453111 12328 244 0.888889 2.16888916 Nitrosomonas 914 Bacteria Bacteria 43.9 0.015   NR WP_011111877.1 914 g12236 i0 35 0.737704918032787 60 38 73.8 1 13 192 421 479 WP_011111877.1 MULTISPECIES: CHASE2 domain-containing protein [Nitrosomonas] diamond 180 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas  
31451296 31451296 PRJNA453111_P_NODE_12116_length_244_cov_0.900585_g12024_i0 PRJNA453111 12116 244 0.900585 2.1974274 Comamonadaceae 80864 Bacteria Bacteria 41.6 0.0289   NR WP_006298065.1 80880 g12024 i0 37.7 1.63524590163934 61 35 73.8 2 51 230 8 66 WP_006298065.1 hypothetical protein [Hylemonella gracilis] diamond 399 42 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hylemonella Hylemonella gracilis
31483054 31483054 PRJNA453111_P_NODE_12396_length_243_cov_1.100000_g12304_i0 PRJNA453111 12396 243 1.1 2.673 root 1 Root_unresolved Root_unresolved 82.8 1.71e-18   NR WP_264767160.1 573 g12304 i0 87.5 1.97530864197531 40 5 49.4 0 120 1 41 80 WP_264767160.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 480 83.2 0.995192307692308 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32131075 32131075 PRJNA453111_P_NODE_13318_length_222_cov_6.724832_g13226_i0 PRJNA453111 13318 222 6.724832 14.92912704 Klebsiella pneumoniae 573 Bacteria Bacteria 114 1.19e-30   NR WP_416532323.1 573 g13226 i0 91.5 0.797297297297297 59 5 79.7 0 45 221 86 144 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 177 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32510914 32510914 PRJNA453111_P_NODE_9719_length_254_cov_2.552486_g9627_i0 PRJNA453111 9719 254 2.552486 6.48331444 Methylocella sp. 1978226 Bacteria Bacteria 42 0.0203   NR HEY4846789.1 1978226 g9627 i0 32.4 0.803149606299213 68 45 80.3 1 1 204 4 70 HEY4846789.1 helix-turn-helix domain-containing protein [Methylocella sp.] diamond 204 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Beijerinckiaceae Methylocella Methylocella sp.
32699658 32699658 PRJNA453111_P_NODE_4880_length_366_cov_0.839590_g4788_i0 PRJNA453111 4880 366 0.83959 3.0728994 Comamonas sp. 34028 Bacteria Bacteria 42.7 0.0464   NR MBN9331280.1 34028 g4788 i0 38.2 0.450819672131148 55 32 43.4 2 205 363 32 86 MBN9331280.1 hypothetical protein [Comamonas sp.] diamond 165 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas 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);;