RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1011833 · 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
6533478 6533478 PRJNA1011833_S_NODE_17766_length_287_cov_3.147541_g17346_i0 PRJNA1011833 17766 287 3.147541 9.03344267 Rheinheimera 67575 Bacteria Bacteria 119 9.81e-30   NR WP_051686046.1 306205 g17346 i0 64.8 6.36585365853659 88 29 89.9 1 286 29 265 352 WP_051686046.1 UDP-glucose--hexose-1-phosphate uridylyltransferase [Rheinheimera texasensis] diamond 1827 120 0.991666666666667 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera texasensis
26932175 26932175 PRJNA1011833_S_NODE_53702_length_157_cov_2.096491_g53282_i0 PRJNA1011833 53702 157 2.096491 3.29149087 Bacteria 2 Bacteria Bacteria 54.3 9.64e-7   NR MDO5759342.1 1948890 g53282 i0 59.5 7.22292993630573 37 15 70.7 0 118 8 17 53 MDO5759342.1 alpha-amylase family glycosyl hydrolase [Rhodobacterales bacterium] diamond 1134 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales     Rhodobacterales bacterium
27066187 27066187 PRJNA1011833_S_NODE_8162_length_398_cov_5.740845_g7745_i0 PRJNA1011833 8162 398 5.740845 22.8485631 Buchnera aphidicola 9 Bacteria Bacteria 54.3 1.75e-5   NR WP_367671453.1 9 g7745 i0 31 0.949748743718593 126 69 92 4 16 381 275 386 WP_367671453.1 trypsin-like peptidase domain-containing protein [Buchnera aphidicola] diamond 378 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Buchnera Buchnera aphidicola
27160847 27160847 PRJNA1011833_S_NODE_8822_length_387_cov_5.799419_g8404_i0 PRJNA1011833 8822 387 5.799419 22.44375153 Limnobacter sp. 13 2003368 Bacteria Bacteria 77.4 1.17e-13   NR WP_159568531.1 2653147 g8404 i0 40 2.93023255813953 125 69 96.1 3 386 15 307 426 WP_159568531.1 thiolase family protein [Limnobacter sp. 130] diamond 1134 77.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Limnobacter Limnobacter sp. 130
27319304 27319304 PRJNA1011833_S_NODE_50283_length_163_cov_1.508333_g49863_i0 PRJNA1011833 50283 163 1.508333 2.45858279 Sphingomonadaceae 41297 Bacteria Bacteria 91.3 1.04e-20   NR WP_066667190.1 41297 g49863 i0 100 0.809815950920245 44 0 81 0 3 134 215 258 WP_066667190.1 MULTISPECIES: 3-oxoadipate enol-lactonase [Sphingomonadaceae] diamond 132 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae    
27501232 27501232 PRJNA1011833_S_NODE_48563_length_166_cov_1.560976_g48143_i0 PRJNA1011833 48563 166 1.560976 2.59122016 Bacteria 2 Bacteria Bacteria 45.1 0.00204   NR WP_197341592.1 305 g48143 i0 52.6 1.87951807228916 38 17 66.9 1 2 112 522 559 WP_197341592.1 DNA-directed RNA polymerase [Ralstonia solanacearum] diamond 312 45.4 0.993392070484582 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia solanacearum
28014055 28014055 PRJNA1011833_S_NODE_51085_length_162_cov_1.201681_g50665_i0 PRJNA1011833 51085 162 1.201681 1.94672322 Klebsiella pneumoniae 573 Bacteria Bacteria 48.5 1.12e-5   NR WP_251884210.1 573 g50665 i0 50 0.740740740740741 40 17 68.5 1 51 161 18 57 WP_251884210.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 120 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28645449 28645449 PRJNA1011833_S_NODE_4867_length_471_cov_4.831776_g4460_i0 PRJNA1011833 4867 471 4.831776 22.75766496 Shigella sonnei 624 Bacteria Bacteria 109 3.95e-28   NR WP_353763804.1 624 g4460 i0 95.1 0.388535031847134 61 2 38.9 1 269 451 23 82 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 183 109 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei
28771590 28771590 PRJNA1011833_S_NODE_47567_length_168_cov_1.152000_g47147_i0 PRJNA1011833 47567 168 1.152 1.93536 Salmonella enterica 28901 Bacteria Bacteria 51.2 8.94e-7   NR MEQ1463787.1 28901 g47147 i0 61.5 2.125 39 15 69.6 0 118 2 15 53 MEQ1463787.1 hypothetical protein [Salmonella enterica] diamond 357 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
29182276 29182276 PRJNA1011833_S_NODE_34909_length_198_cov_1.238710_g34489_i0 PRJNA1011833 34909 198 1.23871 2.4526458 Pseudomonadota bacterium 1977087 Bacteria Bacteria 75.1 7.81e-14   NR MCF6319631.1 1977087 g34489 i0 64.3 3.42424242424242 56 20 84.8 0 191 24 93 148 MCF6319631.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Pseudomonadota bacterium] diamond 678 75.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29426851 29426851 PRJNA1011833_S_NODE_12809_length_335_cov_2.434932_g12389_i0 PRJNA1011833 12809 335 2.434932 8.1570222 Bacteria candidate phyla 1783234 Bacteria Bacteria 110 1.84e-25   NR WP_081326530.1 955 g12389 i0 51.5 16.9791044776119 101 49 90.4 0 326 24 677 777 WP_081326530.1 endopeptidase La [Wolbachia pipientis] diamond 5688 111 0.990990990990991 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Anaplasmataceae Wolbachia Wolbachia pipientis
29465876 29465876 PRJNA1011833_S_NODE_60090_length_151_cov_0.870370_g59670_i0 PRJNA1011833 60090 151 0.87037 1.3142587 Escherichia coli 562 Bacteria Bacteria 62 3.11e-11   NR WP_309049012.1 562 g59670 i0 73.8 0.834437086092715 42 11 83.4 0 126 1 18 59 WP_309049012.1 hypothetical protein, partial [Escherichia coli] diamond 126 62 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29655306 29655306 PRJNA1011833_S_NODE_45970_length_171_cov_1.460938_g45550_i0 PRJNA1011833 45970 171 1.460938 2.49820398 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 71.6 8.92e-13   NR MCC6172850.1 1913989 g45550 i0 60.7 1.89473684210526 56 22 98.2 0 3 170 119 174 MCC6172850.1 acyl-CoA dehydrogenase family protein [Gammaproteobacteria bacterium] diamond 324 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30445608 30445608 PRJNA1011833_S_NODE_32813_length_205_cov_0.888889_g32393_i0 PRJNA1011833 32813 205 0.888889 1.82222245 Kangiellaceae bacterium 2026751 Bacteria Bacteria 75.5 6.15e-14   NR MCW9017799.1 2026751 g32393 i0 58.5 3.80487804878049 65 27 95.1 0 10 204 372 436 MCW9017799.1 acetyl-CoA carboxylase biotin carboxylase subunit [Kangiellaceae bacterium] diamond 780 75.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae   Kangiellaceae bacterium
30729764 30729764 PRJNA1011833_S_NODE_8094_length_400_cov_1.464986_g7677_i0 PRJNA1011833 8094 400 1.464986 5.859944 Rhizobiaceae bacterium 1913961 Bacteria Bacteria 96.7 3.15e-21   NR MBO6813400.1 1913961 g7677 i0 39.5 0.93 124 75 93 0 2 373 139 262 MBO6813400.1 SAM-dependent methyltransferase [Rhizobiaceae bacterium] diamond 372 96.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae   Rhizobiaceae bacterium
30951165 30951165 PRJNA1011833_S_NODE_11314_length_352_cov_7.300971_g10894_i0 PRJNA1011833 11314 352 7.300971 25.69941792 Pseudomonadota bacterium 1977087 Bacteria Bacteria 52.8 3.59e-5   NR KAA3628728.1 1977087 g10894 i0 42.2 5.72727272727273 90 48 75.9 3 5 271 261 347 KAA3628728.1 MAG: heme A synthase [Pseudomonadota bacterium] diamond 2016 52.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31290853 31290853 PRJNA1011833_S_NODE_11635_length_348_cov_5.498361_g11215_i0 PRJNA1011833 11635 348 5.498361 19.13429628 Alphaproteobacteria 28211 Bacteria Bacteria 126 3.0899999999999993e-31   NR MEJ2457329.1 1874826 g11215 i0 62.9 3.93965517241379 97 36 83.6 0 1 291 435 531 MEJ2457329.1 choline dehydrogenase [Novosphingobium sp.] diamond 1371 127 0.992125984251969 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium sp.
31362046 31362046 PRJNA1011833_S_NODE_22376_length_253_cov_2.438095_g21956_i0 PRJNA1011833 22376 253 2.438095 6.16838035 Nitrobacter winogradskyi 913 Bacteria Bacteria 43.9 0.00934   NR WP_011315495.1 913 g21956 i0 32.5 0.91304347826087 77 49 91.3 1 8 238 59 132 WP_011315495.1 hypothetical protein [Nitrobacter winogradskyi] diamond 231 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Nitrobacter Nitrobacter winogradskyi
31425084 31425084 PRJNA1011833_S_NODE_14796_length_314_cov_1.594096_g14376_i0 PRJNA1011833 14796 314 1.594096 5.00546144 Marinobacter sp. es. 50741 Bacteria Bacteria 75.1 3.67e-13   NR WP_088827542.1 1761795 g14376 i0 36.1 3.09554140127389 108 64 98.4 2 309 1 495 602 WP_088827542.1 long-chain-acyl-CoA synthetase [Marinobacter sp. es.048] diamond 972 75.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Marinobacteraceae Marinobacter Marinobacter sp. es.048
31456878 31456878 PRJNA1011833_S_NODE_29756_length_216_cov_1.942197_g29336_i0 PRJNA1011833 29756 216 1.942197 4.19514552 Burkholderiaceae bacterium PBA 3058603 Bacteria Bacteria 42.7 0.0256   NR TMS58172.1 795666 g29336 i0 40.7 0.819444444444444 59 33 81.9 1 14 190 56 112 TMS58172.1 guanine deaminase [Burkholderiaceae bacterium PBA] diamond 177 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium PBA
32437739 32437739 PRJNA1011833_S_NODE_11899_length_345_cov_3.092715_g11479_i0 PRJNA1011833 11899 345 3.092715 10.66986675 Flavimaribacter sediminis 2865987 Bacteria Bacteria 67.8 7.78e-11   NR WP_220230909.1 2865987 g11479 i0 41.3 0.695652173913043 80 47 69.6 0 344 105 44 123 WP_220230909.1 ankyrin repeat domain-containing protein [Flavimaribacter sediminis] diamond 240 67.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Flavimaribacter Flavimaribacter sediminis

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