RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA641991 · 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
26828233 26828233 PRJNA641991_P_NODE_3941_length_163_cov_0.894737_g3900_i0 PRJNA641991 3941 163 0.894737 1.45842131 Vibrio vulnificus 672 Bacteria Bacteria 41.2 0.0145   NR WP_263574758.1 672 g3900 i0 63.9 8.5398773006135 36 13 66.3 0 162 55 5 40 WP_263574758.1 hypothetical protein, partial [Vibrio vulnificus] diamond 1392 41.6 0.990384615384615 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
27870834 27870834 PRJNA641991_S_NODE_925_length_547_cov_1.648594_g809_i0 PRJNA641991 925 547 1.648594 9.01780918 Hyphomicrobiales bacterium 1909294 Bacteria Bacteria 46.6 0.0238   NR MBV9051098.1 1909294 g809 i0 29.7 1.39853747714808 138 87 74 3 520 116 193 323 MBV9051098.1 FAD-binding oxidoreductase [Hyphomicrobiales bacterium] diamond 765 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales bacterium
28470973 28470973 PRJNA641991_S_NODE_7846_length_198_cov_226.919463_g7727_i0 PRJNA641991 7846 198 226.919463 449.30053674 Klebsiella pneumoniae 573 Bacteria Bacteria 114 1.78e-30   NR WP_416532323.1 573 g7727 i0 96.3 0.818181818181818 54 2 81.8 0 198 37 91 144 WP_416532323.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 162 114 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28514755 28514755 PRJNA641991_S_NODE_8307_length_194_cov_1.462069_g8188_i0 PRJNA641991 8307 194 1.462069 2.83641386 Bacteria 2 Bacteria Bacteria 41.6 0.0478   NR MBN8520949.1 1913988 g8188 i0 39.5 1.32989690721649 43 26 66.5 0 34 162 165 207 MBN8520949.1 succinate dehydrogenase iron-sulfur subunit [Alphaproteobacteria bacterium] diamond 258 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
28786381 28786381 PRJNA641991_S_NODE_4567_length_250_cov_1.592040_g4448_i0 PRJNA641991 4567 250 1.59204 3.9801 Candidatus Thiodiazotropha taylori 2792791 Bacteria Bacteria 63.5 1.95e-9   NR MCG8077976.1 2792791 g4448 i0 42.2 3.936 83 48 99.6 0 2 250 844 926 MCG8077976.1 DDE-type integrase/transposase/recombinase [Candidatus Thiodiazotropha taylori] diamond 984 63.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Candidatus Thiodiazotropha Candidatus Thiodiazotropha taylori
29102450 29102450 PRJNA641991_S_NODE_4448_length_253_cov_2.215686_g4329_i0 PRJNA641991 4448 253 2.215686 5.60568558 Endozoicomonas elysicola 305900 Bacteria Bacteria 42.7 0.0408   NR WP_020582764.1 305900 g4329 i0 39.1 0.818181818181818 69 36 74.7 1 237 49 222 290 WP_020582764.1 hypothetical protein [Endozoicomonas elysicola] diamond 207 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Endozoicomonadaceae Endozoicomonas Endozoicomonas elysicola
29240956 29240956 PRJNA641991_S_NODE_14249_length_162_cov_0.902655_g14130_i0 PRJNA641991 14249 162 0.902655 1.4623011 Acinetobacter 469 Bacteria Bacteria 107 4.39e-26   NR MEG2273630.1 472 g14130 i0 100 3.92592592592593 53 0 98.1 0 160 2 169 221 MEG2273630.1 hypothetical protein [Acinetobacter sp.] diamond 636 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp.
30334430 30334430 PRJNA641991_S_NODE_14892_length_161_cov_0.910714_g14773_i0 PRJNA641991 14892 161 0.910714 1.46624954 Shewanella septentrionalis 2952223 Bacteria Bacteria 109 2.54e-28   NR WP_261271577.1 2952223 g14773 i0 94.3 0.987577639751553 53 3 98.8 0 161 3 118 170 WP_261271577.1 hypothetical protein [Shewanella septentrionalis] diamond 159 109 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Shewanellaceae Shewanella Shewanella septentrionalis
30820298 30820298 PRJNA641991_S_NODE_3374_length_287_cov_1.500000_g3255_i0 PRJNA641991 3374 287 1.5 4.305 Kiloniella 454159 Bacteria Bacteria 87.4 1.15e-17   NR MBS0558773.1 1977087 g3255 i0 53.8 3.53310104529617 93 43 97.2 0 285 7 329 421 MBS0558773.1 NADH-quinone oxidoreductase subunit M [Pseudomonadota bacterium] diamond 1014 88.2 0.99092970521542 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30902788 30902788 PRJNA641991_S_NODE_5754_length_227_cov_0.955056_g5635_i0 PRJNA641991 5754 227 0.955056 2.16797712 Methylovirgula sp. 1978224 Bacteria Bacteria 41.6 0.0451   NR HEY1736391.1 1978224 g5635 i0 28.4 0.977973568281938 74 53 97.8 0 2 223 20 93 HEY1736391.1 SRPBCC family protein [Methylovirgula sp.] diamond 222 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Beijerinckiaceae Methylovirgula Methylovirgula sp.
31135857 31135857 PRJNA641991_S_NODE_10415_length_177_cov_1.062500_g10296_i0 PRJNA641991 10415 177 1.0625 1.880625 Alphaproteobacteria 28211 Bacteria Bacteria 63.9 3.62e-10   NR MBO6491012.1 2026775 g10296 i0 55.9 12.7627118644068 59 22 100 2 1 177 214 268 MBO6491012.1 glycine cleavage system aminomethyltransferase GcvT [Pelagibacteraceae bacterium] diamond 2259 64.3 0.993779160186625 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales Candidatus Pelagibacteraceae   Pelagibacteraceae bacterium
31218314 31218314 PRJNA641991_S_NODE_5795_length_226_cov_1.333333_g5676_i0 PRJNA641991 5795 226 1.333333 3.01333258 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42 0.0366   NR MEO0390848.1 1977087 g5676 i0 33.9 0.743362831858407 56 33 69 1 66 221 43 98 MEO0390848.1 GNAT family N-acetyltransferase [Pseudomonadota bacterium] diamond 168 42 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31768647 31768647 PRJNA641991_S_NODE_13717_length_163_cov_0.894737_g13598_i0 PRJNA641991 13717 163 0.894737 1.45842131 Mariluticola 3064792 Bacteria Bacteria 82.4 9.05e-18   NR HEY8594805.1 2845825 g13598 i0 77.1 3.53374233128834 48 10 88.3 1 145 2 43 89 HEY8594805.1 nucleoside deaminase [Devosiaceae bacterium] diamond 576 83.2 0.990384615384615 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Devosiaceae   Devosiaceae bacterium
31831747 31831747 PRJNA641991_S_NODE_12037_length_167_cov_0.864407_g11918_i0 PRJNA641991 12037 167 0.864407 1.44355969 Pseudomonadati 3379134 Bacteria Bacteria 42.4 0.00764   NR HSS14100.1 1978228 g11918 i0 47.7 8.04790419161677 44 21 75.4 1 32 157 14 57 HSS14100.1 class I SAM-dependent methyltransferase [Rhizomicrobium sp.] diamond 1344 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Micropepsales Micropepsaceae Rhizomicrobium Rhizomicrobium sp.
32041193 32041193 PRJNA641991_S_NODE_14378_length_162_cov_0.902655_g14259_i0 PRJNA641991 14378 162 0.902655 1.4623011 Vogesella urethralis 2592656 Bacteria Bacteria 98.6 1.17e-22   NR WP_144373153.1 2592656 g14259 i0 100 0.851851851851852 46 0 85.2 0 161 24 137 182 WP_144373153.1 multidrug efflux MFS transporter MdtH [Vogesella urethralis] diamond 138 98.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chromobacteriaceae Vogesella Vogesella urethralis
32294608 32294608 PRJNA641991_P_NODE_1859_length_226_cov_0.830508_g1818_i0 PRJNA641991 1859 226 0.830508 1.87694808 Rickettsiales bacterium Ac37b 1528098 Bacteria Bacteria 63.2 1.26e-9   NR AIL65752.1 1528098 g1818 i0 75.8 0.79646017699115 33 8 43.8 0 226 128 221 253 AIL65752.1 Cytochrome c oxidase subunit 2 precursor [Rickettsiales bacterium Ac37b] diamond 180 63.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales     Rickettsiales bacterium Ac37b
32420890 32420890 PRJNA641991_S_NODE_13319_length_164_cov_0.886957_g13200_i0 PRJNA641991 13319 164 0.886957 1.45460948 Aureimonas populi 1701758 Bacteria Bacteria 66.6 3.94e-11   NR WP_209735593.1 1701758 g13200 i0 68.2 0.804878048780488 44 13 80.5 1 135 4 66 108 WP_209735593.1 L,D-transpeptidase family protein [Aureimonas populi] diamond 132 66.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aurantimonadaceae Aureimonas Aureimonas populi
32452725 32452725 PRJNA641991_P_NODE_3999_length_162_cov_0.902655_g3958_i0 PRJNA641991 3999 162 0.902655 1.4623011 Pseudomonas citronellolis 53408 Bacteria Bacteria 66.2 6.11e-11   NR KAF1066225.1 53408 g3958 i0 63 1.7962962962963 46 17 85.2 0 162 25 82 127 KAF1066225.1 MAG: hypothetical protein GAK45_01990 [Pseudomonas citronellolis] diamond 291 66.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas citronellolis

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