RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA833575 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
25050715 25050715 PRJNA833575_P_NODE_38960_length_234_cov_1.696970_g38823_i0 PRJNA833575 38960 234 1.69697 3.9709098 root 1 Root_unresolved Root_unresolved 128 7.269999999999999e-37   NR WP_395241880.1 2614656 g38823 i0 80.5 10.8076923076923 77 15 98.7 0 2 232 1 77 WP_395241880.1 MULTISPECIES: 40S ribosomal protein S27 [unclassified Salmonella] diamond 2529 128 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella  
27054709 27054709 PRJNA833575_P_NODE_20962_length_323_cov_1.133858_g20825_i0 PRJNA833575 20962 323 1.133858 3.66236134 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 45.4 0.0107   NR MCW8851037.1 1913989 g20825 i0 36.9 1.24458204334365 84 39 72.4 4 270 37 78 153 MCW8851037.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 402 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27875823 27875823 PRJNA833575_P_NODE_30225_length_270_cov_1.845771_g30088_i0 PRJNA833575 30225 270 1.845771 4.9835817 Pseudomonadota bacterium 1977087 Bacteria Bacteria 69.3 2.23e-11   NR RZO47190.1 1977087 g30088 i0 57.1 2.22222222222222 63 26 70 1 15 203 294 355 RZO47190.1 MAG: hypothetical protein EVA81_02115, partial [Pseudomonadota bacterium] diamond 600 69.3 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28452898 28452898 PRJNA833575_P_NODE_27326_length_285_cov_1.000000_g27189_i0 PRJNA833575 27326 285 1 2.85 Pseudomonadota 1224 Bacteria Bacteria 136 1.2799999999999998e-35   NR WP_070177377.1 1856405 g27189 i0 62.4 5.92631578947368 93 35 97.9 0 282 4 341 433 WP_070177377.1 aldehyde dehydrogenase family protein [Alteromonas lipolytica] diamond 1689 136 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Alteromonadaceae Alteromonas Alteromonas lipolytica
28981188 28981188 PRJNA833575_P_NODE_29868_length_272_cov_1.246305_g29731_i0 PRJNA833575 29868 272 1.246305 3.3899496 Rubellimicrobium rubrum 2585369 Bacteria Bacteria 169 7.53e-50   NR WP_139074938.1 2585369 g29731 i0 90 0.992647058823529 90 9 99.3 0 270 1 38 127 WP_139074938.1 carbohydrate ABC transporter permease [Rubellimicrobium rubrum] diamond 270 169 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Rubellimicrobium Rubellimicrobium rubrum
29589060 29589060 PRJNA833575_P_NODE_11190_length_431_cov_1.591160_g11053_i0 PRJNA833575 11190 431 1.59116 6.8578996 Pseudomonadati 3379134 Bacteria Bacteria 119 8.909999999999998e-32   NR WP_009851746.1 314344 g11053 i0 52.1 4.96983758700696 119 54 80.7 1 350 3 2 120 WP_009851746.1 group I truncated hemoglobin [Mariprofundus ferrooxydans] diamond 2142 120 0.991666666666667 Bacteria   Pseudomonadati Pseudomonadota Candidatius Mariprofundia Mariprofundales Mariprofundaceae Mariprofundus Mariprofundus ferrooxydans
29810308 29810308 PRJNA833575_P_NODE_46411_length_226_cov_0.917197_g46274_i0 PRJNA833575 46411 226 0.917197 2.07286522 Pseudomonadati 3379134 Bacteria Bacteria 83.2 8.29e-17   NR MEH6588640.1 2024834 g46274 i0 70.3 7.23451327433628 64 18 83.6 1 35 223 120 183 MEH6588640.1 NADP-dependent oxidoreductase [Halioglobus sp.] diamond 1635 84 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Halieaceae Halioglobus Halioglobus sp.
30749729 30749729 PRJNA833575_P_NODE_16714_length_359_cov_1.686207_g16577_i0 PRJNA833575 16714 359 1.686207 6.05348313 Salmonella sp. S146_54837 2665635 Bacteria Bacteria 134 1.4699999999999998e-37   NR WP_187788045.1 2665635 g16577 i0 60.2 2.13927576601671 128 42 99.4 2 1 357 10 137 WP_187788045.1 60S ribosomal protein L13, partial [Salmonella sp. S146_54837] diamond 768 134 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. S146_54837
30749731 30749731 PRJNA833575_P_NODE_43154_length_230_cov_0.894410_g43017_i0 PRJNA833575 43154 230 0.89441 2.057143 Methylococcales bacterium 2304002 Bacteria Bacteria 50.1 7.51e-5   NR MBT4836068.1 2304002 g43017 i0 57.6 0.430434782608696 33 14 43 0 228 130 176 208 MBT4836068.1 hypothetical protein [Methylococcales bacterium] diamond 99 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales     Methylococcales bacterium
31002559 31002559 PRJNA833575_P_NODE_38454_length_235_cov_0.867470_g38317_i0 PRJNA833575 38454 235 0.86747 2.0385545 Amphritea sp. 1872502 Bacteria Bacteria 65.9 2.38e-10   NR MCV6613292.1 1872502 g38317 i0 46.8 3.98297872340426 79 35 99.6 2 2 235 255 327 MCV6613292.1 sodium/proton antiporter NhaB [Amphritea sp.] diamond 936 65.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Oceanospirillaceae Amphritea Amphritea sp.
31223473 31223473 PRJNA833575_P_NODE_22755_length_311_cov_1.479339_g22618_i0 PRJNA833575 22755 311 1.479339 4.60074429 Pseudomonadota bacterium 1977087 Bacteria Bacteria 135 2.37e-34   NR MEN9580828.1 1977087 g22618 i0 60.9 2.08360128617363 110 36 99.4 3 311 3 162 271 MEN9580828.1 hypothetical protein [Pseudomonadota bacterium] diamond 648 135 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31540113 31540113 PRJNA833575_P_NODE_37636_length_237_cov_1.684524_g37499_i0 PRJNA833575 37636 237 1.684524 3.99232188 Bradyrhizobium sp. 376 Bacteria Bacteria 74.7 1.08e-13   NR HZR89668.1 376 g37499 i0 53.3 0.949367088607595 75 34 93.7 1 224 3 125 199 HZR89668.1 MBL fold metallo-hydrolase [Bradyrhizobium sp.] diamond 225 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp.
31698106 31698106 PRJNA833575_P_NODE_39237_length_234_cov_0.872727_g39100_i0 PRJNA833575 39237 234 0.872727 2.04218118 Rhodospirillales bacterium 2026786 Bacteria Bacteria 81.6 1.92e-17   NR MBN8900684.1 2026786 g39100 i0 72.5 0.653846153846154 51 14 65.4 0 2 154 90 140 MBN8900684.1 fibronectin type III domain-containing protein [Rhodospirillales bacterium] diamond 153 81.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales     Rhodospirillales bacterium
32204324 32204324 PRJNA833575_P_NODE_39198_length_234_cov_0.872727_g39061_i0 PRJNA833575 39198 234 0.872727 2.04218118 Comamonas sp. 34028 Bacteria Bacteria 42.4 0.0425   NR WP_287916688.1 34028 g39061 i0 33.9 0.756410256410256 59 39 75.6 0 50 226 240 298 WP_287916688.1 DMT family transporter [Comamonas sp.] diamond 177 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas sp.
32331245 32331245 PRJNA833575_P_NODE_46839_length_226_cov_0.917197_g46702_i0 PRJNA833575 46839 226 0.917197 2.07286522 Roseateles sp. 1971397 Bacteria Bacteria 149 3.4599999999999995e-42   NR WP_373715138.1 1971397 g46702 i0 97.3 0.995575221238938 75 2 99.6 0 226 2 36 110 WP_373715138.1 porin [Roseateles sp.] diamond 225 149 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
32425857 32425857 PRJNA833575_P_NODE_37159_length_239_cov_1.717647_g37022_i0 PRJNA833575 37159 239 1.717647 4.10517633 Escherichia coli 562 Bacteria Bacteria 89 2.33e-20   NR WP_140424324.1 562 g37022 i0 61.1 0.903765690376569 72 28 90.4 0 238 23 79 150 WP_140424324.1 actin-binding ADF family protein, partial [Escherichia coli] diamond 216 89 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32425858 32425858 PRJNA833575_P_NODE_42819_length_230_cov_0.894410_g42682_i0 PRJNA833575 42819 230 0.89441 2.057143 Comamonas sp. 34028 Bacteria Bacteria 41.6 0.0193   NR WP_309279921.1 34028 g42682 i0 51.1 1.3695652173913 47 21 61.3 2 181 41 13 57 WP_309279921.1 hypothetical protein [Comamonas sp.] diamond 315 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Comamonas Comamonas sp.
32812728 32812728 PRJNA833575_P_NODE_36400_length_243_cov_1.212644_g36263_i0 PRJNA833575 36400 243 1.212644 2.94672492 Tardiphaga 1395974 Bacteria Bacteria 93.2 4.31e-21   NR MET0905828.1 1926292 g36263 i0 72.1 2.23456790123457 61 17 75.3 0 240 58 179 239 MET0905828.1 class I fructose-bisphosphate aldolase [Tardiphaga sp.] diamond 543 93.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Tardiphaga Tardiphaga 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);;