RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

34 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 34 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1001940 · 34 ✖

analysis 1

  • diamond · 34 ✖

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
1422782 1422782 PRJNA1001940_S_NODE_77222_length_247_cov_3.784314_g76168_i0 PRJNA1001940 77222 247 3.784314 9.34725558 Aquamicrobium sp. NLF2-7 2918753 Bacteria Bacteria 162 5.21e-48   NR WP_239799125.1 2918753 g76168 i0 100 0.995951417004049 82 0 99.6 0 2 247 126 207 WP_239799125.1 AzlC family ABC transporter permease [Aquamicrobium sp. NLF2-7] diamond 246 162 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aquamicrobium Aquamicrobium sp. NLF2-7
11625728 11625728 PRJNA1001940_S_NODE_21070_length_429_cov_4.329016_g20031_i0 PRJNA1001940 21070 429 4.329016 18.57147864 Aquamicrobium sp. NLF2-7 2918753 Bacteria Bacteria 129 3.35e-32   NR WP_239799358.1 2918753 g20031 i0 100 0.433566433566434 62 0 43.4 0 3 188 420 481 WP_239799358.1 aldehyde dehydrogenase family protein [Aquamicrobium sp. NLF2-7] diamond 186 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aquamicrobium Aquamicrobium sp. NLF2-7
12478533 12478533 PRJNA1001940_S_NODE_94290_length_223_cov_2.933333_g93236_i0 PRJNA1001940 94290 223 2.933333 6.54133259 Phyllobacterium sp. 1871046 Bacteria Bacteria 142 2.54e-40   NR WP_346308336.1 1871046 g93236 i0 100 0.982062780269058 73 0 98.2 0 3 221 16 88 WP_346308336.1 4-(cytidine 5'-diphospho)-2-C-methyl-D-erythritol kinase, partial [Phyllobacterium sp.] diamond 219 142 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Phyllobacterium Phyllobacterium sp.
23100179 23100179 PRJNA1001940_S_NODE_73219_length_254_cov_2.009479_g72165_i0 PRJNA1001940 73219 254 2.009479 5.10407666 Aquamicrobium lusatiense 89772 Bacteria Bacteria 176 5.57e-52   NR WP_183829905.1 89772 g72165 i0 98.8 0.992125984251969 84 1 99.2 0 2 253 271 354 WP_183829905.1 cystathionine beta-lyase [Aquamicrobium lusatiense] diamond 252 176 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aquamicrobium Aquamicrobium lusatiense
23952060 23952060 PRJNA1001940_S_NODE_75339_length_250_cov_5.178744_g74285_i0 PRJNA1001940 75339 250 5.178744 12.94686 Sphingomonas dokdonensis 344880 Bacteria Bacteria 136 8.79e-38   NR WP_088366491.1 344880 g74285 i0 90.2 0.984 82 8 98.4 0 5 250 81 162 WP_088366491.1 CPBP family intramembrane glutamic endopeptidase [Sphingomonas dokdonensis] diamond 246 136 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas dokdonensis
26781321 26781321 PRJNA1001940_S_NODE_96121_length_221_cov_2.078652_g95067_i0 PRJNA1001940 96121 221 2.078652 4.59382092 Escherichia coli 562 Bacteria Bacteria 46.6 9.45e-5   NR WP_235635482.1 562 g95067 i0 71.4 0.380090497737557 28 8 38 0 94 11 32 59 WP_235635482.1 hypothetical protein, partial [Escherichia coli] diamond 84 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27184868 27184868 PRJNA1001940_S_NODE_128222_length_192_cov_0.966443_g127168_i0 PRJNA1001940 128222 192 0.966443 1.85557056 Aquamicrobium 69278 Bacteria Bacteria 82.4 1.92e-16   NR WP_287943754.1 1872579 g127168 i0 97.7 1.34375 43 1 67.2 0 63 191 1 43 WP_287943754.1 DNA translocase FtsK 4TM domain-containing protein, partial [Aquamicrobium sp.] diamond 258 82.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aquamicrobium Aquamicrobium sp.
27223832 27223832 PRJNA1001940_S_NODE_167943_length_168_cov_0.984000_g166889_i0 PRJNA1001940 167943 168 0.984 1.65312 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 40 0.0231   NR WP_395583954.1 251699 g166889 i0 64.9 0.660714285714286 37 11 66.1 2 131 21 2 36 WP_395583954.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 111 40 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27223838 27223838 PRJNA1001940_S_NODE_81423_length_241_cov_1.454545_g80369_i0 PRJNA1001940 81423 241 1.454545 3.50545345 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 42.4 0.0298   NR MET0311348.1 2030806 g80369 i0 41.9 0.535269709543568 43 16 53.5 1 98 226 123 156 MET0311348.1 MFS transporter [Burkholderiaceae bacterium] diamond 129 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
27445511 27445511 PRJNA1001940_S_NODE_19643_length_440_cov_2.272040_g18606_i0 PRJNA1001940 19643 440 2.27204 9.996976 Shigella sonnei 624 Bacteria Bacteria 84.7 1.94e-18   NR WP_353763804.1 624 g18606 i0 95.6 0.306818181818182 45 2 30.7 0 305 439 38 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 135 84.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
27824258 27824258 PRJNA1001940_S_NODE_100744_length_216_cov_1.664740_g99690_i0 PRJNA1001940 100744 216 1.66474 3.5958384 Enterobacter hormaechei 158836 Bacteria Bacteria 65.5 3.97e-12   NR WP_276192208.1 158836 g99690 i0 77.8 0.5 36 8 50 0 115 8 1 36 WP_276192208.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 108 65.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
28297630 28297630 PRJNA1001940_S_NODE_73726_length_253_cov_2.285714_g72672_i0 PRJNA1001940 73726 253 2.285714 5.78285642 Kordiimonadaceae bacterium 2664180 Bacteria Bacteria 43.1 0.0301   NR MBT5074352.1 2664180 g72672 i0 53.1 0.379446640316206 32 13 37.9 1 178 83 213 242 MBT5074352.1 MFS transporter [Kordiimonadaceae bacterium] diamond 96 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Kordiimonadales Kordiimonadaceae   Kordiimonadaceae bacterium
29308009 29308009 PRJNA1001940_S_NODE_68789_length_262_cov_1.753425_g67735_i0 PRJNA1001940 68789 262 1.753425 4.5939735 Sphingomonas sp. 28214 Bacteria Bacteria 59.7 7.25e-10   NR WP_375270587.1 28214 g67735 i0 75.6 0.515267175572519 45 11 51.5 0 126 260 1 45 WP_375270587.1 hypothetical protein [Sphingomonas sp.] diamond 135 59.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
29465563 29465563 PRJNA1001940_S_NODE_197010_length_154_cov_1.729730_g195956_i0 PRJNA1001940 197010 154 1.72973 2.6637842 Kosakonia 1330547 Bacteria Bacteria 84.3 2.89e-20   NR WP_165501869.1 1330547 g195956 i0 91.9 0.720779220779221 37 3 72.1 0 113 3 1 37 WP_165501869.1 MULTISPECIES: hydrogenase maturation nickel metallochaperone HypA [Kosakonia] diamond 111 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Kosakonia  
29686672 29686672 PRJNA1001940_S_NODE_177750_length_163_cov_1.200000_g176696_i0 PRJNA1001940 177750 163 1.2 1.956 Enterobacter hormaechei 158836 Bacteria Bacteria 84.3 2.32e-19   NR WP_276171474.1 158836 g176696 i0 72.2 0.993865030674847 54 14 99.4 1 2 163 11 63 WP_276171474.1 hypothetical protein [Enterobacter hormaechei] diamond 162 84.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
29939779 29939779 PRJNA1001940_S_NODE_183071_length_160_cov_1.641026_g182017_i0 PRJNA1001940 183071 160 1.641026 2.6256416 Pseudomonas lurida 244566 Bacteria Bacteria 51.6 7.02e-7   NR WP_369006328.1 244566 g182017 i0 75.8 17.53125 33 8 61.9 0 158 60 46 78 WP_369006328.1 reverse transcriptase domain-containing protein, partial [Pseudomonas lurida] diamond 2805 51.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas lurida
30248391 30248391 PRJNA1001940_S_NODE_82992_length_238_cov_4.205128_g81938_i0 PRJNA1001940 82992 238 4.205128 10.00820464 Gammaproteobacteria 1236 Bacteria Bacteria 106 8.24e-28   NR WP_337144352.1 287 g81938 i0 78.5 18.9075630252101 79 17 99.6 0 1 237 2 80 WP_337144352.1 hypothetical protein, partial [Pseudomonas aeruginosa] diamond 4500 106 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
30287539 30287539 PRJNA1001940_S_NODE_92052_length_226_cov_2.098361_g90998_i0 PRJNA1001940 92052 226 2.098361 4.74229586 Nitrosomonas sp. 42353 Bacteria Bacteria 47.8 5.05e-4   NR MCC6161685.1 42353 g90998 i0 41.9 0.823008849557522 62 35 81 1 225 43 125 186 MCC6161685.1 O-antigen ligase family protein [Nitrosomonas sp.] diamond 186 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
30563805 30563805 PRJNA1001940_S_NODE_81133_length_241_cov_2.424242_g80079_i0 PRJNA1001940 81133 241 2.424242 5.84242322 root 1 Root_unresolved Root_unresolved 53.9 4.34e-7   NR WP_329792810.1 562 g80079 i0 59.4 5.09128630705394 32 13 39.8 0 146 51 53 84 WP_329792810.1 hypothetical protein, partial [Escherichia coli] diamond 1227 54.3 0.992633517495396 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30571267 30571267 PRJNA1001940_S_NODE_83453_length_238_cov_1.420513_g82399_i0 PRJNA1001940 83453 238 1.420513 3.38082094 Aquamicrobium sp. 1872579 Bacteria Bacteria 139 3.28e-36   NR WP_287942269.1 1872579 g82399 i0 92.3 0.983193277310924 78 6 98.3 0 235 2 51 128 WP_287942269.1 polysaccharide biosynthesis protein [Aquamicrobium sp.] diamond 234 139 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Aquamicrobium Aquamicrobium sp.
30666229 30666229 PRJNA1001940_S_NODE_114953_length_202_cov_1.792453_g113899_i0 PRJNA1001940 114953 202 1.792453 3.62075506 Sphingomonas dokdonensis 344880 Bacteria Bacteria 134 3.11e-36   NR WP_088366971.1 344880 g113899 i0 100 0.995049504950495 67 0 99.5 0 1 201 147 213 WP_088366971.1 FemAB family XrtA/PEP-CTERM system-associated protein [Sphingomonas dokdonensis] diamond 201 134 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas dokdonensis
30666233 30666233 PRJNA1001940_S_NODE_33813_length_361_cov_3.820755_g32759_i0 PRJNA1001940 33813 361 3.820755 13.79292555 Alcaligenes faecalis 511 Bacteria Bacteria 106 1.73e-26   NR WP_368934440.1 511 g32759 i0 100 0.43213296398892 52 0 43.2 0 157 2 1 52 WP_368934440.1 hypothetical protein [Alcaligenes faecalis] diamond 156 106 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Alcaligenes Alcaligenes faecalis
30848509 30848509 PRJNA1001940_S_NODE_187154_length_158_cov_2.504348_g186100_i0 PRJNA1001940 187154 158 2.504348 3.95686984 Bacteria 2 Bacteria Bacteria 80.5 3.33e-17   NR WP_371913113.1 573 g186100 i0 76.1 1.74683544303797 46 11 87.3 0 140 3 93 138 WP_371913113.1 reverse transcriptase domain-containing protein, partial [Klebsiella pneumoniae] diamond 276 80.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30950845 30950845 PRJNA1001940_S_NODE_187354_length_158_cov_2.086957_g186300_i0 PRJNA1001940 187354 158 2.086957 3.29739206 Sphingomonas dokdonensis 344880 Bacteria Bacteria 58.2 6.4e-9   NR WP_088366116.1 344880 g186300 i0 93.9 0.626582278481013 33 2 62.7 0 1 99 59 91 WP_088366116.1 hypothetical protein [Sphingomonas dokdonensis] diamond 99 58.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas dokdonensis
31393350 31393350 PRJNA1001940_S_NODE_166836_length_168_cov_1.536000_g165782_i0 PRJNA1001940 166836 168 1.536 2.58048 Klebsiella pneumoniae 573 Bacteria Bacteria 39.7 0.0369   NR WP_305199557.1 573 g165782 i0 70.4 0.482142857142857 27 8 48.2 0 86 166 49 75 WP_305199557.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 81 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31417435 31417435 PRJNA1001940_S_NODE_210856_length_151_cov_0.898148_g209802_i0 PRJNA1001940 210856 151 0.898148 1.35620348 root 1 Root_unresolved Root_unresolved 90.5 3.11e-20   NR WP_270022569.1 287 g209802 i0 82 536.423841059603 50 9 99.3 0 2 151 67 116 WP_270022569.1 hypothetical protein [Pseudomonas aeruginosa] diamond 81000 90.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
31614580 31614580 PRJNA1001940_S_NODE_98796_length_218_cov_1.920000_g97742_i0 PRJNA1001940 98796 218 1.92 4.1856 Hyphomicrobiales bacterium 1909294 Bacteria Bacteria 43.1 0.0184   NR MDG2187425.1 1909294 g97742 i0 37 0.63302752293578 46 28 63.3 1 183 46 60 104 MDG2187425.1 prolipoprotein diacylglyceryl transferase [Hyphomicrobiales bacterium] diamond 138 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales bacterium
31930811 31930811 PRJNA1001940_S_NODE_146577_length_179_cov_3.867647_g145523_i0 PRJNA1001940 146577 179 3.867647 6.92308813 Escherichia marmotae 1499973 Bacteria Bacteria 49.3 5.03e-6   NR MCR6678950.1 1499973 g145523 i0 53.8 0.871508379888268 52 24 87.2 0 16 171 7 58 MCR6678950.1 hypothetical protein [Escherichia marmotae] diamond 156 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia marmotae
31994213 31994213 PRJNA1001940_S_NODE_120998_length_197_cov_1.870130_g119944_i0 PRJNA1001940 120998 197 1.87013 3.6841561 Pararhizobium sp. BT-229 2986923 Bacteria Bacteria 70.9 2.55e-13   NR WP_264263804.1 2986923 g119944 i0 50.8 0.898477157360406 59 29 89.8 0 194 18 48 106 WP_264263804.1 hypothetical protein [Pararhizobium sp. BT-229] diamond 177 70.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Pararhizobium Pararhizobium sp. BT-229
32279172 32279172 PRJNA1001940_S_NODE_105119_length_211_cov_2.571429_g104065_i0 PRJNA1001940 105119 211 2.571429 5.42571519 Escherichia coli 562 Bacteria Bacteria 54.3 1.05e-7   NR WP_235634646.1 562 g104065 i0 54.7 0.753554502369668 53 23 73.9 1 5 160 22 74 WP_235634646.1 hypothetical protein, partial [Escherichia coli] diamond 159 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32310924 32310924 PRJNA1001940_S_NODE_41919_length_330_cov_2.393728_g40865_i0 PRJNA1001940 41919 330 2.393728 7.8993024 Edwardsiella tarda 636 Bacteria Bacteria 51.2 1.37e-5   NR WP_217700664.1 636 g40865 i0 70.6 0.309090909090909 34 10 30.9 0 176 75 64 97 WP_217700664.1 hypothetical protein, partial [Edwardsiella tarda] diamond 102 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Hafniaceae Edwardsiella Edwardsiella tarda
32405634 32405634 PRJNA1001940_S_NODE_187379_length_158_cov_2.086957_g186325_i0 PRJNA1001940 187379 158 2.086957 3.29739206 Salinicola aestuarinus 1949082 Bacteria Bacteria 53.9 1.23e-6   NR WP_245391835.1 1949082 g186325 i0 53.8 3.93037974683544 52 24 98.7 0 158 3 128 179 WP_245391835.1 CheR family methyltransferase [Salinicola aestuarinus] diamond 621 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Salinicola Salinicola aestuarinus
32752692 32752692 PRJNA1001940_S_NODE_87820_length_232_cov_1.269841_g86766_i0 PRJNA1001940 87820 232 1.269841 2.94603112 Shigella sonnei 624 Bacteria Bacteria 78.6 4.02e-17   NR CSS20281.1 624 g86766 i0 85.7 0.633620689655172 49 7 63.4 0 231 85 30 78 CSS20281.1 Uncharacterised protein [Shigella sonnei] diamond 147 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
32878573 32878573 PRJNA1001940_S_NODE_113560_length_203_cov_2.700000_g112506_i0 PRJNA1001940 113560 203 2.7 5.481 Klebsiella pneumoniae 573 Bacteria Bacteria 64.3 1.28e-11   NR WP_408357587.1 573 g112506 i0 68.2 0.650246305418719 44 14 65 0 3 134 6 49 WP_408357587.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 132 64.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae

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