RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1004255" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 24 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1004255 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
6104143 6104143 PRJNA1004255_S_NODE_3505_length_297_cov_2.212598_g3297_i0 PRJNA1004255 3505 297 2.212598 6.57141606 Pseudomonadota bacterium 1977087 Bacteria Bacteria 196 3.29e-57   NR MBS0417227.1 1977087 g3297 i0 99 1 99 1 100 0 1 297 72 170 MBS0417227.1 phosphogluconate dehydratase [Pseudomonadota bacterium] diamond 297 196 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
11204268 11204268 PRJNA1004255_S_NODE_17649_length_155_cov_2.098214_g17441_i0 PRJNA1004255 17649 155 2.098214 3.2522317 Bradyrhizobium sp. RD5-C2 244562 Bacteria Bacteria 64.7 2.98e-11   NR WP_223977496.1 244562 g17441 i0 78.9 0.735483870967742 38 8 73.5 0 116 3 7 44 WP_223977496.1 flavin reductase family protein [Bradyrhizobium sp. RD5-C2] diamond 114 64.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. RD5-C2
14181947 14181947 PRJNA1004255_S_NODE_2932_length_314_cov_4.892989_g2724_i0 PRJNA1004255 2932 314 4.892989 15.36398546 Microvirga 186650 Bacteria Bacteria 170 1.15e-49   NR HEV2558174.1 1873136 g2724 i0 74 7.9203821656051 104 27 99.4 0 3 314 44 147 HEV2558174.1 NADPH:quinone oxidoreductase family protein [Microvirga sp.] diamond 2487 171 0.994152046783626 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga sp.
15455905 15455905 PRJNA1004255_S_NODE_3853_length_287_cov_4.454918_g3645_i0 PRJNA1004255 3853 287 4.454918 12.78561466 Massilia sp. YIM B 1882437 Bacteria Bacteria 178 1.6299999999999999e-52   NR WP_290421552.1 3050129 g3645 i0 100 0.857142857142857 82 0 85.7 0 286 41 222 303 WP_290421552.1 FAD-dependent oxidoreductase [Massilia sp. YIM B02769] diamond 246 178 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia sp. YIM B02769
17578818 17578818 PRJNA1004255_S_NODE_3494_length_297_cov_4.948819_g3286_i0 PRJNA1004255 3494 297 4.948819 14.69799243 Rubrivivax 28067 Bacteria Bacteria 166 2.989999999999999e-47   NR MDE2145978.1 1891238 g3286 i0 80.6 1.97979797979798 98 19 99 0 3 296 316 413 MDE2145978.1 glucose-1-phosphate adenylyltransferase [Burkholderiales bacterium] diamond 588 167 0.994011976047904 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
18004988 18004988 PRJNA1004255_S_NODE_2495_length_332_cov_3.415225_g2287_i0 PRJNA1004255 2495 332 3.415225 11.338547 Pseudomonadota bacterium 1977087 Bacteria Bacteria 206 9.76e-64   NR MBS0422205.1 1977087 g2287 i0 96.3 0.975903614457831 108 4 97.6 0 330 7 212 319 MBS0422205.1 ketoacyl-ACP synthase III [Pseudomonadota bacterium] diamond 324 206 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
20127391 20127391 PRJNA1004255_S_NODE_10136_length_200_cov_2.095541_g9928_i0 PRJNA1004255 10136 200 2.095541 4.191082 Bradyrhizobium sp. 376 Bacteria Bacteria 107 1.7000000000000002e-27   NR WP_324406718.1 376 g9928 i0 77.3 1.98 66 15 99 0 2 199 87 152 WP_324406718.1 hypothetical protein [Bradyrhizobium sp.] diamond 396 107 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp.
20554465 20554465 PRJNA1004255_S_NODE_9037_length_210_cov_1.407186_g8829_i0 PRJNA1004255 9037 210 1.407186 2.9550906 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 86.7 7.72e-18   NR MEJ0036570.1 1913989 g8829 i0 75 0.857142857142857 60 15 85.7 0 3 182 24 83 MEJ0036570.1 OmpW family outer membrane protein [Gammaproteobacteria bacterium] diamond 180 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
26971031 26971031 PRJNA1004255_S_NODE_8402_length_216_cov_5.161850_g8194_i0 PRJNA1004255 8402 216 5.16185 11.149596 Mameliella alba 561184 Bacteria Bacteria 44.3 0.00737   NR WP_074622400.1 561184 g8194 i0 44.2 0.722222222222222 52 29 72.2 0 58 213 72 123 WP_074622400.1 xanthine dehydrogenase accessory protein XdhC [Mameliella alba] diamond 156 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Mameliella Mameliella alba
28360805 28360805 PRJNA1004255_S_NODE_13386_length_176_cov_12.586466_g13178_i0 PRJNA1004255 13386 176 12.586466 22.15218016 Klebsiella pneumoniae 573 Bacteria Bacteria 68.2 1.27e-12   NR WP_416532323.1 573 g13178 i0 96.9 0.545454545454545 32 1 54.5 0 98 3 112 143 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 96 68.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28487334 28487334 PRJNA1004255_S_NODE_11127_length_192_cov_1.261745_g10919_i0 PRJNA1004255 11127 192 1.261745 2.4225504 Paracoccus marinus 288426 Bacteria Bacteria 108 3.3800000000000003e-29   NR WP_131672971.1 288426 g10919 i0 100 0.8125 52 0 81.3 0 192 37 43 94 WP_131672971.1 DUF2171 domain-containing protein [Paracoccus marinus] diamond 156 108 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus marinus
28669378 28669378 PRJNA1004255_S_NODE_7247_length_229_cov_4.650538_g7039_i0 PRJNA1004255 7247 229 4.650538 10.64973202 Pseudomonadota 1224 Bacteria Bacteria 135 5.6e-35   NR WP_050325840.1 225324 g7039 i0 92.1 1.99126637554585 76 6 99.6 0 228 1 1224 1299 WP_050325840.1 pilus assembly protein PilY [Enhydrobacter aerosaccus] diamond 456 135 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales   Enhydrobacter Enhydrobacter aerosaccus
28866088 28866088 PRJNA1004255_S_NODE_11248_length_191_cov_1.905405_g11040_i0 PRJNA1004255 11248 191 1.905405 3.63932355 Pseudomonas sp. 74_A 2813565 Bacteria Bacteria 111 1.28e-29   NR WP_243433116.1 2813565 g11040 i0 78.3 0.942408376963351 60 13 94.2 0 180 1 2 61 WP_243433116.1 AP2 domain-containing protein, partial [Pseudomonas sp. 74_A] diamond 180 111 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. 74_A
30097546 30097546 PRJNA1004255_S_NODE_17252_length_157_cov_1.008772_g17044_i0 PRJNA1004255 17252 157 1.008772 1.58377204 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42.7 0.00797   NR WP_395515016.1 251699 g17044 i0 56.5 0.878980891719745 46 15 84.1 2 5 136 60 102 WP_395515016.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 138 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
30382433 30382433 PRJNA1004255_S_NODE_13133_length_178_cov_4.318519_g12925_i0 PRJNA1004255 13133 178 4.318519 7.68696382 Shigella sonnei 624 Bacteria Bacteria 40.8 0.0165   NR WP_353763804.1 624 g12925 i0 56.8 0.741573033707865 44 16 69.1 2 124 2 24 67 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 132 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
30445364 30445364 PRJNA1004255_S_NODE_16433_length_160_cov_4.418803_g16225_i0 PRJNA1004255 16433 160 4.418803 7.0700848 Moraxella osloensis 34062 Bacteria Bacteria 105 4.92e-27   NR WP_065263609.1 34062 g16225 i0 96.2 0.99375 53 2 99.4 0 160 2 52 104 WP_065263609.1 hypothetical protein [Moraxella osloensis] diamond 159 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Faucicola Faucicola osloensis
30508421 30508421 PRJNA1004255_S_NODE_7513_length_226_cov_3.437158_g7305_i0 PRJNA1004255 7513 226 3.437158 7.76797708 Shigella sonnei 624 Bacteria Bacteria 131 7.89e-38   NR WP_353763784.1 624 g7305 i0 88.6 1.85840707964602 70 8 92.9 0 221 12 10 79 WP_353763784.1 hypothetical protein, partial [Shigella sonnei] diamond 420 132 0.992424242424242 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
30950925 30950925 PRJNA1004255_S_NODE_10734_length_195_cov_3.184211_g10526_i0 PRJNA1004255 10734 195 3.184211 6.20921145 Enterobacter hormaechei 158836 Bacteria Bacteria 67.4 8.65e-13   NR WP_276192107.1 158836 g10526 i0 89.5 0.584615384615385 38 3 56.9 1 3 113 54 91 WP_276192107.1 hypothetical protein [Enterobacter hormaechei] diamond 114 67.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
31234973 31234973 PRJNA1004255_S_NODE_13195_length_178_cov_1.740741_g12987_i0 PRJNA1004255 13195 178 1.740741 3.09851898 Xanthobacteraceae bacterium 2021379 Bacteria Bacteria 111 1e-29   NR MDR3469815.1 2021379 g12987 i0 78 0.99438202247191 59 13 99.4 0 178 2 41 99 MDR3469815.1 hypothetical protein [Xanthobacteraceae bacterium] diamond 177 111 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Xanthobacteraceae   Xanthobacteraceae bacterium
31266802 31266802 PRJNA1004255_S_NODE_515_length_578_cov_5.998131_g315_i0 PRJNA1004255 515 578 5.998131 34.66919718 Shigella sonnei 624 Bacteria Bacteria 80.9 2.32e-16   NR WP_353763804.1 624 g315 i0 89.6 0.249134948096886 48 4 24.9 1 63 206 36 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 144 80.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
31488396 31488396 PRJNA1004255_S_NODE_13956_length_173_cov_7.600000_g13748_i0 PRJNA1004255 13956 173 7.6 13.148 Escherichia coli 562 Bacteria Bacteria 44.3 4.04e-4   NR WP_235634694.1 562 g13748 i0 95 0.346820809248555 20 1 34.7 0 3 62 40 59 WP_235634694.1 hypothetical protein, partial [Escherichia coli] diamond 60 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32247757 32247757 PRJNA1004255_S_NODE_7738_length_224_cov_1.099448_g7530_i0 PRJNA1004255 7738 224 1.099448 2.46276352 Escherichia coli 562 Bacteria Bacteria 101 3.01e-26   NR WP_369072787.1 562 g7530 i0 90.2 0.683035714285714 51 5 68.3 0 70 222 1 51 WP_369072787.1 hypothetical protein, partial [Escherichia coli] diamond 153 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32469123 32469123 PRJNA1004255_S_NODE_3339_length_301_cov_5.100775_g3131_i0 PRJNA1004255 3339 301 5.100775 15.35333275 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 60.5 4.5e-8   NR MDB6156549.1 1913989 g3131 i0 49.1 0.548172757475083 55 26 52.8 1 297 139 930 984 MDB6156549.1 TonB-dependent receptor [Gammaproteobacteria bacterium] diamond 165 60.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
32682135 32682135 PRJNA1004255_S_NODE_17640_length_155_cov_2.232143_g17432_i0 PRJNA1004255 17640 155 2.232143 3.45982165 Bradyrhizobium 374 Bacteria Bacteria 48.5 1.02e-4   NR WP_211985963.1 312253 g17432 i0 56.1 1.66451612903226 41 18 79.4 0 16 138 606 646 WP_211985963.1 beta strand repeat-containing protein [Bradyrhizobium tropiciagri] diamond 258 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium tropiciagri

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