RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA633835" 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

  • PRJNA633835 · 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
6255926 6255926 PRJNA633835_S_NODE_4265_length_325_cov_1.833333_g4197_i0 PRJNA633835 4265 325 1.833333 5.95833225 Duganella fentianensis 2692177 Bacteria Bacteria 145 3.829999999999999e-41   NR WP_161033893.1 2692177 g4197 i0 93.9 0.756923076923077 82 5 75.7 0 248 3 1 82 WP_161033893.1 nitroreductase [Duganella fentianensis] diamond 246 145 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Duganella Duganella fentianensis
27049387 27049387 PRJNA633835_S_NODE_1402_length_467_cov_1.360406_g1334_i0 PRJNA633835 1402 467 1.360406 6.35309602 Escherichia coli 562 Bacteria Bacteria 107 3.28e-27   NR WP_213080762.1 562 g1334 i0 65.1 0.533190578158458 83 18 46.3 1 264 49 2 84 WP_213080762.1 hypothetical protein, partial [Escherichia coli] diamond 249 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27049389 27049389 PRJNA633835_S_NODE_722_length_582_cov_18.774067_g655_i0 PRJNA633835 722 582 18.774067 109.26506994 Acinetobacter baumannii 470 Bacteria Bacteria 102 1.8899999999999998e-24   NR OIC67842.1 470 g655 i0 79.7 0.355670103092784 69 14 35.6 0 223 17 3 71 OIC67842.1 hypothetical protein A7L55_18305 [Acinetobacter baumannii] diamond 207 102 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
27302282 27302282 PRJNA633835_S_NODE_1243_length_485_cov_18.434466_g1175_i0 PRJNA633835 1243 485 18.434466 89.4071601 Acinetobacter baumannii 470 Bacteria Bacteria 107 5.3200000000000006e-27   NR OIC67842.1 470 g1175 i0 81.2 0.841237113402062 69 13 42.7 0 263 469 3 71 OIC67842.1 hypothetical protein A7L55_18305 [Acinetobacter baumannii] diamond 408 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
28280866 28280866 PRJNA633835_S_NODE_546_length_639_cov_26.273852_g481_i0 PRJNA633835 546 639 26.273852 167.88991428 Escherichia coli 562 Bacteria Bacteria 124 1.72e-33   NR PMD93738.1 562 g481 i0 95.1 0.286384976525822 61 3 28.6 0 180 362 1 61 PMD93738.1 hypothetical protein A8A04_13700 [Escherichia coli] diamond 183 124 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28312742 28312742 PRJNA633835_S_NODE_5106_length_308_cov_0.931915_g5038_i0 PRJNA633835 5106 308 0.931915 2.8702982 Escherichia coli 562 Bacteria Bacteria 41.2 0.045   NR WP_213080760.1 562 g5038 i0 82.6 0.224025974025974 23 4 22.4 0 213 281 13 35 WP_213080760.1 hypothetical protein, partial [Escherichia coli] diamond 69 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28407404 28407404 PRJNA633835_S_NODE_11686_length_243_cov_0.888235_g11618_i0 PRJNA633835 11686 243 0.888235 2.15841105 Klebsiella pneumoniae 573 Bacteria Bacteria 43.5 0.0117   NR WP_228264608.1 573 g11618 i0 95.5 1.62962962962963 22 1 27.2 0 241 176 89 110 WP_228264608.1 transposase, partial [Klebsiella pneumoniae] diamond 396 43.9 0.990888382687927 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28470628 28470628 PRJNA633835_S_NODE_7166_length_277_cov_1.122549_g7098_i0 PRJNA633835 7166 277 1.122549 3.10946073 Duganella qianjiadongensis 2692176 Bacteria Bacteria 155 1.94e-41   NR WP_161037351.1 2692176 g7098 i0 83.1 0.963898916967509 89 15 96.4 0 267 1 415 503 WP_161037351.1 TonB-dependent receptor domain-containing protein [Duganella qianjiadongensis] diamond 267 155 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Duganella Duganella qianjiadongensis
28596920 28596920 PRJNA633835_S_NODE_867_length_547_cov_34.740506_g800_i0 PRJNA633835 867 547 34.740506 190.03056782 Acinetobacter baumannii 470 Bacteria Bacteria 104 2.39e-25   NR OIC67842.1 470 g800 i0 79.7 0.745886654478976 69 14 37.8 0 325 531 3 71 OIC67842.1 hypothetical protein A7L55_18305 [Acinetobacter baumannii] diamond 408 104 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
28660075 28660075 PRJNA633835_S_NODE_11827_length_242_cov_0.952663_g11759_i0 PRJNA633835 11827 242 0.952663 2.30544446 Neoroseomonas marina 1232220 Bacteria Bacteria 40.4 0.0472   NR WP_211187730.1 1232220 g11759 i0 66.7 0.297520661157025 24 8 29.8 0 55 126 57 80 WP_211187730.1 hypothetical protein, partial [Neoroseomonas marina] diamond 72 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas marina
28660076 28660076 PRJNA633835_S_NODE_407_length_702_cov_53.774245_g342_i0 PRJNA633835 407 702 53.774245 377.4951999 Escherichia coli 562 Bacteria Bacteria 126 8.100000000000001e-34   NR PMD93738.1 562 g342 i0 96.7 0.260683760683761 61 2 26.1 0 180 362 1 61 PMD93738.1 hypothetical protein A8A04_13700 [Escherichia coli] diamond 183 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28786072 28786072 PRJNA633835_S_NODE_10267_length_249_cov_0.875000_g10199_i0 PRJNA633835 10267 249 0.875 2.17875 Acinetobacter towneri 202956 Bacteria Bacteria 44.7 0.00116   NR WP_286430494.1 202956 g10199 i0 69 0.349397590361446 29 9 34.9 0 37 123 52 80 WP_286430494.1 hypothetical protein, partial [Acinetobacter towneri] diamond 87 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter towneri
29196832 29196832 PRJNA633835_S_NODE_1849_length_425_cov_3.167614_g1781_i0 PRJNA633835 1849 425 3.167614 13.4623595 Acinetobacter baumannii 470 Bacteria Bacteria 96.3 9.34e-23   NR OIC67842.1 470 g1781 i0 78.3 0.487058823529412 69 15 48.7 0 223 17 3 71 OIC67842.1 hypothetical protein A7L55_18305 [Acinetobacter baumannii] diamond 207 96.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
29386278 29386278 PRJNA633835_S_NODE_5769_length_297_cov_0.785714_g5701_i0 PRJNA633835 5769 297 0.785714 2.33357058 Neoroseomonas marina 1232220 Bacteria Bacteria 41.2 0.0411   NR WP_211187730.1 1232220 g5701 i0 70.8 0.242424242424242 24 7 24.2 0 230 159 57 80 WP_211187730.1 hypothetical protein, partial [Neoroseomonas marina] diamond 72 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas marina
30238891 30238891 PRJNA633835_S_NODE_3972_length_332_cov_31.969112_g3904_i0 PRJNA633835 3972 332 31.969112 106.13745184 Acinetobacter baumannii 470 Bacteria Bacteria 99 2.6899999999999994e-24   NR OIC67842.1 470 g3904 i0 78.3 1.79819277108434 69 15 62.3 0 223 17 3 71 OIC67842.1 hypothetical protein A7L55_18305 [Acinetobacter baumannii] diamond 597 99 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
30902446 30902446 PRJNA633835_S_NODE_2214_length_401_cov_2.207317_g2146_i0 PRJNA633835 2214 401 2.207317 8.85134117 Duganella fentianensis 2692177 Bacteria Bacteria 222 7.14e-66   NR WP_348695142.1 2692177 g2146 i0 96.2 0.987531172069825 132 5 98.8 0 3 398 210 341 WP_348695142.1 Ig-like domain-containing protein [Duganella fentianensis] diamond 396 222 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Duganella Duganella fentianensis
31028983 31028983 PRJNA633835_S_NODE_315_length_780_cov_46.900990_g253_i0 PRJNA633835 315 780 46.90099 365.827722 Escherichia coli 562 Bacteria Bacteria 126 1.71e-33   NR PMD93738.1 562 g253 i0 96.7 0.234615384615385 61 2 23.5 0 180 362 1 61 PMD93738.1 hypothetical protein A8A04_13700 [Escherichia coli] diamond 183 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31154824 31154824 PRJNA633835_S_NODE_75_length_1491_cov_28.289140_g1_i31 PRJNA633835 75 1491 28.28914 421.7910774 Escherichia coli 562 Bacteria Bacteria 126 1.7699999999999996e-31   NR PMD93738.1 562 g1 i31 96.7 0.122736418511066 61 2 12.3 0 180 362 1 61 PMD93738.1 hypothetical protein A8A04_13700 [Escherichia coli] diamond 183 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
31629586 31629586 PRJNA633835_S_NODE_7616_length_272_cov_0.768844_g7548_i0 PRJNA633835 7616 272 0.768844 2.09125568 Escherichia coli 562 Bacteria Bacteria 59.7 1.86e-9   NR WP_213080760.1 562 g7548 i0 83.9 0.341911764705882 31 5 34.2 0 181 89 13 43 WP_213080760.1 hypothetical protein, partial [Escherichia coli] diamond 93 59.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32672947 32672947 PRJNA633835_S_NODE_320_length_774_cov_48.751783_g258_i0 PRJNA633835 320 774 48.751783 377.33880042 Escherichia coli 562 Bacteria Bacteria 126 1.6200000000000002e-33   NR PMD93738.1 562 g258 i0 96.7 0.236434108527132 61 2 23.6 0 595 413 1 61 PMD93738.1 hypothetical protein A8A04_13700 [Escherichia coli] diamond 183 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32704442 32704442 PRJNA633835_S_NODE_6340_length_288_cov_1.502326_g6272_i0 PRJNA633835 6340 288 1.502326 4.32669888 Neoroseomonas marina 1232220 Bacteria Bacteria 47 2.14e-4   NR WP_211187730.1 1232220 g6272 i0 54.1 0.385416666666667 37 17 38.5 0 27 137 44 80 WP_211187730.1 hypothetical protein, partial [Neoroseomonas marina] diamond 111 47 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas marina

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