RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA557895" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 32 ✖

tax_kingdom 1

bioproject 1

  • PRJNA557895 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
5640065 5640065 PRJNA557895_P_NODE_33085_length_165_cov_0.879310_g32730_i0 PRJNA557895 33085 165 0.87931 1.4508615 Sphingomonas sp. 28214 Bacteria Bacteria 103 1.3e-26   NR WP_294062310.1 28214 g32730 i0 90.7 0.981818181818182 54 5 98.2 0 2 163 68 121 WP_294062310.1 hypothetical protein [Sphingomonas sp.] diamond 162 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp.
22213238 22213238 PRJNA557895_P_NODE_30638_length_167_cov_0.864407_g30283_i0 PRJNA557895 30638 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 94.7 1.91e-22   NR MEG0342263.1 472 g30283 i0 78.2 45.4491017964072 55 12 98.8 0 165 1 65 119 MEG0342263.1 CoA transferase subunit A [Acinetobacter sp.] diamond 7590 95.1 0.995793901156677 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter sp.
22213315 22213315 PRJNA557895_P_NODE_34358_length_164_cov_0.886957_g34003_i0 PRJNA557895 34358 164 0.886957 1.45460948 Ectothiorhodospiraceae bacterium AqS1 1725326 Bacteria Bacteria 83.2 7.08e-17   NR MBF2760171.1 1725326 g34003 i0 88.9 0.98780487804878 54 6 98.8 0 164 3 413 466 MBF2760171.1 hypothetical protein [Ectothiorhodospiraceae bacterium AqS1] diamond 162 83.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae   Ectothiorhodospiraceae bacterium AqS1
23488916 23488916 PRJNA557895_P_NODE_79_length_3718_cov_23.210957_g55_i0 PRJNA557895 79 3718 23.210957 862.98338126 Klebsiella pneumoniae 573 Bacteria Bacteria 103 1.66e-22   NR WP_217903975.1 573 g55 i0 80 0.064550833781603 80 15 6.4 1 3139 2903 1 80 WP_217903975.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 240 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
24762716 24762716 PRJNA557895_P_NODE_80_length_3718_cov_21.117198_g55_i1 PRJNA557895 80 3718 21.117198 785.13742164 Klebsiella pneumoniae 573 Bacteria Bacteria 103 1.66e-22   NR WP_217903975.1 573 g55 i1 80 0.064550833781603 80 15 6.4 1 3139 2903 1 80 WP_217903975.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 240 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26681326 26681326 PRJNA557895_P_NODE_34381_length_164_cov_0.886957_g34026_i0 PRJNA557895 34381 164 0.886957 1.45460948 Candidatus Thiodiazotropha 1913444 Bacteria Bacteria 108 1.13e-25   NR MCG8078249.1 2792791 g34026 i0 88.7 4.84756097560976 53 6 97 0 3 161 529 581 MCG8078249.1 reverse transcriptase family protein [Candidatus Thiodiazotropha taylori] diamond 795 109 0.990825688073395 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Candidatus Thiodiazotropha Candidatus Thiodiazotropha taylori
26857707 26857707 PRJNA557895_P_NODE_6341_length_356_cov_1.918567_g5986_i0 PRJNA557895 6341 356 1.918567 6.83009852 Bathymodiolus azoricus thioautotrophic gill symbiont 235205 Bacteria Bacteria 45.4 0.0152   NR WP_202775563.1 235205 g5986 i0 56.1 0.345505617977528 41 18 34.6 0 24 146 215 255 WP_202775563.1 reverse transcriptase domain-containing protein, partial [Bathymodiolus azoricus thioautotrophic gill symbiont] diamond 123 45.4 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus azoricus thioautotrophic gill symbiont
26920697 26920697 PRJNA557895_P_NODE_30942_length_166_cov_1.367521_g30587_i0 PRJNA557895 30942 166 1.367521 2.27008486 Candidatus Thiodiazotropha sp. 2847306 Bacteria Bacteria 95.9 2.5300000000000003e-21   NR MES9976195.1 2847306 g30587 i0 80 15.3253012048193 50 10 90.4 0 17 166 499 548 MES9976195.1 reverse transcriptase domain-containing protein [Candidatus Thiodiazotropha sp.] diamond 2544 95.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Candidatus Thiodiazotropha Candidatus Thiodiazotropha sp.
27047279 27047279 PRJNA557895_P_NODE_34122_length_164_cov_0.886957_g33767_i0 PRJNA557895 34122 164 0.886957 1.45460948 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 63.2 4.04e-10   NR MDX1580319.1 1913988 g33767 i0 50 1.79268292682927 56 26 98.8 1 3 164 6 61 MDX1580319.1 succinate dehydrogenase iron-sulfur subunit [Alphaproteobacteria bacterium] diamond 294 63.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
27047282 27047282 PRJNA557895_P_NODE_3622_length_504_cov_2.701099_g3277_i0 PRJNA557895 3622 504 2.701099 13.61353896 Nitrosospira sp. Nsp18 1855334 Bacteria Bacteria 135 4.32e-35   NR WP_090960727.1 1855334 g3277 i0 46.6 12.6071428571429 163 82 97 2 502 14 165 322 WP_090960727.1 malate dehydrogenase [Nitrosospira sp. Nsp18] diamond 6354 135 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosospira Nitrosospira sp. Nsp18
27187572 27187572 PRJNA557895_P_NODE_34602_length_164_cov_0.886957_g34247_i0 PRJNA557895 34602 164 0.886957 1.45460948 Pseudomonadota 1224 Bacteria Bacteria 72.4 4.39e-13   NR MAQ06249.1 2024888 g34247 i0 53.7 4.92073170731707 54 25 98.8 0 1 162 651 704 MAQ06249.1 methylmalonyl-CoA mutase [SAR116 cluster bacterium] diamond 807 72.8 0.994505494505495 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Puniceispirillales     SAR116 cluster bacterium
27268460 27268460 PRJNA557895_P_NODE_22443_length_196_cov_1.040816_g22088_i0 PRJNA557895 22443 196 1.040816 2.03999936 Solemya velum gill symbiont 2340 Bacteria Bacteria 42.7 0.0084   NR WP_143556208.1 2340 g22088 i0 38.1 1.25510204081633 42 26 64.3 0 12 137 45 86 WP_143556208.1 RNA-directed DNA polymerase, partial [Solemya velum gill symbiont] diamond 246 42.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Solemya velum gill symbiont
27331893 27331893 PRJNA557895_P_NODE_23763_length_190_cov_1.085106_g23408_i0 PRJNA557895 23763 190 1.085106 2.0617014 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 89.4 6.81e-19   NR MDA8002120.1 1913988 g23408 i0 72.6 0.978947368421053 62 17 97.9 0 188 3 300 361 MDA8002120.1 reverse transcriptase domain-containing protein [Alphaproteobacteria bacterium] diamond 186 89.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
27395115 27395115 PRJNA557895_P_NODE_25983_length_181_cov_1.159091_g25628_i0 PRJNA557895 25983 181 1.159091 2.09795471 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 84 4.93e-17   NR MCH9717643.1 1913989 g25628 i0 61.7 0.994475138121547 60 23 99.4 0 181 2 363 422 MCH9717643.1 DDE-type integrase/transposase/recombinase [Gammaproteobacteria bacterium] diamond 180 84 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
27472262 27472262 PRJNA557895_P_NODE_11623_length_270_cov_1.266968_g11268_i0 PRJNA557895 11623 270 1.266968 3.4208136 Pseudomonadota 1224 Bacteria Bacteria 137 2.84e-35   NR MDA8001621.1 1913988 g11268 i0 66.3 1.97777777777778 89 30 98.9 0 268 2 271 359 MDA8001621.1 reverse transcriptase domain-containing protein [Alphaproteobacteria bacterium] diamond 534 137 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
27489724 27489724 PRJNA557895_P_NODE_223_length_2324_cov_4.315604_g150_i0 PRJNA557895 223 2324 4.315604 100.29463696 Escherichia coli 562 Bacteria Bacteria 596 1.3e-203   NR WP_021557595.1 562 g150 i0 59 1.28313253012048 497 204 64.2 0 2265 775 29 525 WP_021557595.1 AAA family ATPase [Escherichia coli] diamond 2982 596 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28437005 28437005 PRJNA557895_P_NODE_3186_length_550_cov_1.860279_g2844_i0 PRJNA557895 3186 550 1.860279 10.2315345 Candidatus Thiodiazotropha sp. (ex. Lucinisca nassula) 2865854 Bacteria Bacteria 87 3.77e-16   NR MBW9275219.1 2865854 g2844 i0 44.6 0.550909090909091 101 56 55.1 0 431 129 1042 1142 MBW9275219.1 DDE-type integrase/transposase/recombinase [Candidatus Thiodiazotropha sp. (ex. Lucinisca nassula)] diamond 303 87 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Candidatus Thiodiazotropha Candidatus Thiodiazotropha sp. (ex. Lucinisca nassula)
28735139 28735139 PRJNA557895_P_NODE_27_length_6477_cov_8.696484_g18_i0 PRJNA557895 27 6477 8.696484 563.27126868 root 1 Root_unresolved Root_unresolved 151 7.31e-38   NR WP_317986776.1 562 g18 i0 52.9 0.380268642890227 138 65 6.4 0 5658 6071 4 141 WP_317986776.1 ead/Ea22-like family protein, partial [Escherichia coli] diamond 2463 152 0.993421052631579 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28735140 28735140 PRJNA557895_P_NODE_34107_length_164_cov_0.886957_g33752_i0 PRJNA557895 34107 164 0.886957 1.45460948 Pseudomonadota 1224 Bacteria Bacteria 115 2.18e-32   NR WP_214278800.1 562 g33752 i0 100 3.95121951219512 54 0 98.8 0 3 164 20 73 WP_214278800.1 hypothetical protein, partial [Escherichia coli] diamond 648 115 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29163330 29163330 PRJNA557895_P_NODE_3329_length_534_cov_2.367010_g2985_i0 PRJNA557895 3329 534 2.36701 12.6398334 Salmonella sp. s51228 3159652 Bacteria Bacteria 254 9.99e-79   NR WP_411022855.1 3159652 g2985 i0 64.6 1 178 62 99.4 1 531 1 84 261 WP_411022855.1 hypothetical protein [Salmonella sp. s51228] diamond 534 254 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella sp. s51228
29257551 29257551 PRJNA557895_P_NODE_14789_length_240_cov_0.905759_g14434_i0 PRJNA557895 14789 240 0.905759 2.1738216 Taylorella asinigenitalis 84590 Bacteria Bacteria 43.9 0.0129   NR WP_015551060.1 84590 g14434 i0 35.7 0.7 56 36 70 0 174 7 3 58 WP_015551060.1 exodeoxyribonuclease III [Taylorella asinigenitalis] diamond 168 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Taylorella Taylorella asinigenitalis
29415537 29415537 PRJNA557895_P_NODE_15309_length_235_cov_1.059140_g14954_i0 PRJNA557895 15309 235 1.05914 2.488979 Pseudomonadota bacterium 1977087 Bacteria Bacteria 44.7 0.00682   NR MEM9969045.1 1977087 g14954 i0 40.3 0.791489361702128 62 31 75.3 2 177 1 224 282 MEM9969045.1 NADP-dependent oxidoreductase [Pseudomonadota bacterium] diamond 186 44.7 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29415548 29415548 PRJNA557895_P_NODE_30789_length_167_cov_0.864407_g30434_i0 PRJNA557895 30789 167 0.864407 1.44355969 Erwinia sp. 198 2022746 Bacteria Bacteria 42.7 0.00512   NR WP_233598464.1 2022746 g30434 i0 43.8 0.862275449101796 48 25 82.6 1 144 7 57 104 WP_233598464.1 inner membrane protein YbjM [Erwinia sp. 198] diamond 144 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Erwinia Erwinia sp. 198
30015788 30015788 PRJNA557895_P_NODE_36291_length_163_cov_0.894737_g35936_i0 PRJNA557895 36291 163 0.894737 1.45842131 Ectothiorhodospiraceae bacterium AqS1 1725326 Bacteria Bacteria 112 4.87e-27   NR MBF2760515.1 1725326 g35936 i0 100 0.975460122699387 53 0 97.5 0 161 3 1578 1630 MBF2760515.1 hypothetical protein [Ectothiorhodospiraceae bacterium AqS1] diamond 159 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae   Ectothiorhodospiraceae bacterium AqS1
30268759 30268759 PRJNA557895_P_NODE_6472_length_352_cov_1.049505_g6117_i0 PRJNA557895 6472 352 1.049505 3.6942576 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 149 7.7e-39   NR MCP4272276.1 1913989 g6117 i0 60.5 0.971590909090909 114 45 97.2 0 346 5 343 456 MCP4272276.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 342 149 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30693214 30693214 PRJNA557895_P_NODE_7933_length_318_cov_0.940520_g7578_i0 PRJNA557895 7933 318 0.94052 2.9908536 root 1 Root_unresolved Root_unresolved 91.7 1.68e-21   NR WP_139160629.1 470 g7578 i0 67.2 131.877358490566 58 19 54.7 0 1 174 16 73 WP_139160629.1 chlorophyll a/b-binding protein, partial [Acinetobacter baumannii] diamond 41937 92.4 0.992424242424242 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
30805588 30805588 PRJNA557895_P_NODE_3034_length_567_cov_2.117761_g2692_i0 PRJNA557895 3034 567 2.117761 12.00770487 Kangiellaceae bacterium 2026751 Bacteria Bacteria 48.1 0.00915   NR MEE4247207.1 2026751 g2692 i0 29.5 0.555555555555556 105 73 55.6 1 544 230 445 548 MEE4247207.1 reverse transcriptase family protein [Kangiellaceae bacterium] diamond 315 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae   Kangiellaceae bacterium
31058675 31058675 PRJNA557895_P_NODE_33335_length_165_cov_0.879310_g32980_i0 PRJNA557895 33335 165 0.87931 1.4508615 Gluconobacter cerinus 38307 Bacteria Bacteria 103 2.18e-24   NR WP_415553315.1 38307 g32980 i0 100 0.981818181818182 54 0 98.2 0 2 163 249 302 WP_415553315.1 TolC family outer membrane protein, partial [Gluconobacter cerinus] diamond 162 103 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Gluconobacter Gluconobacter cerinus
31596093 31596093 PRJNA557895_P_NODE_1456_length_925_cov_18.430365_g1184_i0 PRJNA557895 1456 925 18.430365 170.48087625 Klebsiella pneumoniae 573 Bacteria Bacteria 95.1 9.32e-21   NR WP_217903975.1 573 g1184 i0 70 0.259459459459459 80 23 25.6 1 346 110 1 80 WP_217903975.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 240 95.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31880334 31880334 PRJNA557895_P_NODE_15037_length_237_cov_1.617021_g14682_i0 PRJNA557895 15037 237 1.617021 3.83233977 Woeseia sp. 1980636 Bacteria Bacteria 57 3.18e-7   NR MEX2495611.1 1980636 g14682 i0 47.5 0.772151898734177 61 29 73.4 2 196 23 285 345 MEX2495611.1 M12 family metallo-peptidase [Woeseia sp.] diamond 183 57 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Woeseiales Woeseiaceae Woeseia Woeseia sp.
32734162 32734162 PRJNA557895_P_NODE_30880_length_166_cov_1.897436_g30525_i0 PRJNA557895 30880 166 1.897436 3.14974376 Psittacicella gerlachiana 2028574 Bacteria Bacteria 43.9 0.00129   NR WP_119535301.1 2028574 g30525 i0 46.2 0.704819277108434 39 21 70.5 0 6 122 53 91 WP_119535301.1 BolA family protein [Psittacicella gerlachiana] diamond 117 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Psittacicellaceae Psittacicella Psittacicella gerlachiana
32828562 32828562 PRJNA557895_P_NODE_38060_length_161_cov_1.330357_g37705_i0 PRJNA557895 38060 161 1.330357 2.14187477 Sphingomonas sp. Root71 28214 Bacteria Bacteria 49.7 3.73e-5   NR WP_056376800.1 1736594 g37705 i0 40 0.93167701863354 50 30 93.2 0 153 4 56 105 WP_056376800.1 enoyl-CoA hydratase/isomerase family protein [Sphingomonas sp. Root710] diamond 150 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. Root710

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