RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA473641 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
10023771 10023771 PRJNA473641_P_NODE_7428_length_351_cov_0.920863_g7345_i0 PRJNA473641 7428 351 0.920863 3.23222913 Burkholderiales 80840 Bacteria Bacteria 195 4.3499999999999995e-57   NR WP_114468125.1 545864 g7345 i0 80.2 47.3846153846154 116 22 99.1 1 3 350 421 535 WP_114468125.1 3-(methylthio)propionyl-CoA ligase [Pseudorhodoferax soli] diamond 16632 196 0.994897959183674 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Pseudorhodoferax Pseudorhodoferax soli
26601049 26601049 PRJNA473641_P_NODE_21441_length_246_cov_0.890173_g21358_i0 PRJNA473641 21441 246 0.890173 2.18982558 Allosphingosinicella sp. 2823234 Bacteria Bacteria 103 1.88e-23   NR WP_331039338.1 2823234 g21358 i0 72.5 0.841463414634146 69 18 82.9 1 246 43 489 557 WP_331039338.1 class I adenylate-forming enzyme family protein [Allosphingosinicella sp.] diamond 207 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Allosphingosinicella Allosphingosinicella sp.
26664374 26664374 PRJNA473641_P_NODE_1661_length_635_cov_1.583630_g1579_i0 PRJNA473641 1661 635 1.58363 10.0560505 Neptuniibacter sp. QD34_54 3398208 Bacteria Bacteria 191 8.089999999999999e-57   NR WP_415882484.1 3398208 g1579 i0 48.8 4.01102362204724 211 102 99.7 4 634 2 40 244 WP_415882484.1 group I truncated hemoglobin [Neptuniibacter sp. QD34_54] diamond 2547 191 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Oceanospirillaceae Neptuniibacter Neptuniibacter sp. QD34_54
26918001 26918001 PRJNA473641_P_NODE_10082_length_315_cov_0.954545_g9999_i0 PRJNA473641 10082 315 0.954545 3.00681675 Chitinibacter fontanus 1737446 Bacteria Bacteria 107 2.33e-24   NR WP_180306650.1 1737446 g9999 i0 64.9 2.12380952380952 74 26 70.5 0 1 222 601 674 WP_180306650.1 glycosyl hydrolase family 18 protein [Chitinibacter fontanus] diamond 669 107 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Chitinibacter Chitinibacter fontanus
26918002 26918002 PRJNA473641_P_NODE_11822_length_297_cov_1.375000_g11739_i0 PRJNA473641 11822 297 1.375 4.08375 Cellvibrionales bacterium 2026722 Bacteria Bacteria 48.9 3.6e-4   NR MCY4045457.1 2026722 g11739 i0 33 0.888888888888889 88 52 88.9 3 10 273 143 223 MCY4045457.1 glutathione S-transferase family protein [Cellvibrionales bacterium] diamond 264 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales     Cellvibrionales bacterium
27408677 27408677 PRJNA473641_P_NODE_3423_length_472_cov_1.538847_g3340_i0 PRJNA473641 3423 472 1.538847 7.26335784 root 1 Root_unresolved Root_unresolved 134 3.1899999999999997e-37   NR WP_404852727.1 562 g3340 i0 61.3 1.51271186440678 119 44 75.6 2 442 86 1 117 WP_404852727.1 non-specific lipid-transfer protein [Escherichia coli] diamond 714 134 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27739910 27739910 PRJNA473641_P_NODE_18084_length_250_cov_0.870056_g18001_i0 PRJNA473641 18084 250 0.870056 2.17514 Acetobacteraceae bacterium 1909293 Bacteria Bacteria 42.4 0.0288   NR MCC7280952.1 1909293 g18001 i0 48 0.6 50 18 60 2 99 248 20 61 MCC7280952.1 GNAT family N-acetyltransferase [Acetobacteraceae bacterium] diamond 150 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae   Acetobacteraceae bacterium
27865726 27865726 PRJNA473641_P_NODE_17565_length_251_cov_0.865169_g17482_i0 PRJNA473641 17565 251 0.865169 2.17157419 Pseudomonadota bacterium 1977087 Bacteria Bacteria 78.6 9.92e-15   NR MEO0343026.1 1977087 g17482 i0 84.6 0.920318725099602 39 6 46.6 0 118 2 296 334 MEO0343026.1 terminase TerL endonuclease subunit [Pseudomonadota bacterium] diamond 231 78.6 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27929076 27929076 PRJNA473641_P_NODE_4745_length_415_cov_0.900585_g4662_i0 PRJNA473641 4745 415 0.900585 3.73742775 Aestuariivirga sp. 2650926 Bacteria Bacteria 100 9.31e-22   NR WP_415005741.1 2650926 g4662 i0 40.3 0.896385542168675 124 62 89.6 2 11 382 241 352 WP_415005741.1 hypothetical protein [Aestuariivirga sp.] diamond 372 100 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga sp.
28071389 28071389 PRJNA473641_P_NODE_12485_length_290_cov_1.419355_g12402_i0 PRJNA473641 12485 290 1.419355 4.1161295 Bacteria 2 Bacteria Bacteria 96.7 5e-24   NR WP_289465466.1 573 g12402 i0 68.6 1.96551724137931 70 22 72.4 0 290 81 3 72 WP_289465466.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 570 96.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28307986 28307986 PRJNA473641_P_NODE_3506_length_468_cov_1.726582_g3423_i0 PRJNA473641 3506 468 1.726582 8.08040376 Salmonella enterica 28901 Bacteria Bacteria 221 6.329999999999999e-72   NR MDR5387564.1 90371 g3423 i0 97.1 0.673076923076923 105 3 67.3 0 3 317 4 108 MDR5387564.1 DUF3421 domain-containing protein [Salmonella enterica subsp. enterica serovar Typhimurium] diamond 315 221 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
28718462 28718462 PRJNA473641_P_NODE_21707_length_246_cov_0.890173_g21624_i0 PRJNA473641 21707 246 0.890173 2.18982558 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 42.4 0.0435   NR HZA96636.1 2030806 g21624 i0 44.1 0.719512195121951 59 32 72 1 19 195 48 105 HZA96636.1 glycerol-3-phosphate 1-O-acyltransferase PlsY [Burkholderiaceae bacterium] diamond 177 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
28829138 28829138 PRJNA473641_P_NODE_16748_length_253_cov_1.283333_g16665_i0 PRJNA473641 16748 253 1.283333 3.24683249 Pseudomonadati 3379134 Bacteria Bacteria 47.8 5.91e-4   NR RZA07720.1 1889775 g16665 i0 40.7 2.71541501976285 54 26 56.9 1 253 110 11 64 RZA07720.1 MAG: hypothetical protein EOO68_03010 [Moraxellaceae bacterium] diamond 687 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae   Moraxellaceae bacterium
29649741 29649741 PRJNA473641_P_NODE_14050_length_276_cov_1.517241_g13967_i0 PRJNA473641 14050 276 1.517241 4.18758516 Pseudomonadota 1224 Bacteria Bacteria 48.5 5.35e-4   NR MBX3717763.1 1891238 g13967 i0 48.5 1.39130434782609 66 34 71.7 0 261 64 121 186 MBX3717763.1 Ig-like domain repeat protein [Burkholderiales bacterium] diamond 384 48.9 0.991820040899796 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
30487023 30487023 PRJNA473641_P_NODE_19913_length_248_cov_0.880000_g19830_i0 PRJNA473641 19913 248 0.88 2.1824 Klebsiella pneumoniae 573 Bacteria Bacteria 159 4.4e-49   NR WP_289465622.1 573 g19830 i0 100 1.76612903225806 75 0 90.7 0 23 247 1 75 WP_289465622.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 438 159 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30581496 30581496 PRJNA473641_P_NODE_13993_length_277_cov_1.132353_g13910_i0 PRJNA473641 13993 277 1.132353 3.13661781 Gammaproteobacteria bacterium CG12_big_fil_rev_8_21_14_ 1913989 Bacteria Bacteria 44.3 0.0163   NR PIQ42931.1 1974024 g13910 i0 44.2 0.465703971119134 43 18 46.6 1 189 61 425 461 PIQ42931.1 MAG: primosomal protein N' [Gammaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_46_12] diamond 129 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium CG12_big_fil_rev_8_21_14_0_65_46_12
31782791 31782791 PRJNA473641_P_NODE_19137_length_249_cov_0.875000_g19054_i0 PRJNA473641 19137 249 0.875 2.17875 Aestuariivirga sp. 2650926 Bacteria Bacteria 71.6 2.69e-12   NR WP_415005741.1 2650926 g19054 i0 35.8 0.975903614457831 81 52 97.6 0 243 1 85 165 WP_415005741.1 hypothetical protein [Aestuariivirga sp.] diamond 243 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aestuariivirgaceae Aestuariivirga Aestuariivirga sp.
32352740 32352740 PRJNA473641_P_NODE_19419_length_248_cov_2.708571_g19336_i0 PRJNA473641 19419 248 2.708571 6.71725608 Salmonella enterica 28901 Bacteria Bacteria 129 8.33e-37   NR MDR5387555.1 90371 g19336 i0 90.5 0.762096774193548 63 6 76.2 0 247 59 55 117 MDR5387555.1 DUF3421 domain-containing protein [Salmonella enterica subsp. enterica serovar Typhimurium] diamond 189 129 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
32652692 32652692 PRJNA473641_P_NODE_20980_length_247_cov_0.885057_g20897_i0 PRJNA473641 20980 247 0.885057 2.18609079 root 1 Root_unresolved Root_unresolved 47.4 9.57e-4   NR APV50551.1 1904640 g20897 i0 45.3 2.68421052631579 86 40 97.2 4 247 8 493 577 APV50551.1 hypothetical protein BWI17_13150 [Betaproteobacteria bacterium GR16-43] diamond 663 47.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium GR16-43
32731435 32731435 PRJNA473641_P_NODE_1020_length_780_cov_1.973126_g950_i0 PRJNA473641 1020 780 1.973126 15.3903828 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 144 1.13e-38   NR NCY05671.1 1891241 g950 i0 53.8 0.75 195 90 75 0 46 630 4 198 NCY05671.1 hypothetical protein [Betaproteobacteria bacterium] diamond 585 144 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
32825850 32825850 PRJNA473641_P_NODE_8380_length_336_cov_1.144487_g8297_i0 PRJNA473641 8380 336 1.144487 3.84547632 Pseudomonadota bacterium 1977087 Bacteria Bacteria 72.8 2.84e-12   NR MCH8335333.1 1977087 g8297 i0 37.8 0.875 98 45 74.1 2 80 328 101 197 MCH8335333.1 MBL fold metallo-hydrolase [Pseudomonadota bacterium] diamond 294 72.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium

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