RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA688931", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 15 ✖

tax_kingdom 1

  • Pseudomonadati · 15 ✖

bioproject 1

  • PRJNA688931 · 15 ✖

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
6282051 6282051 PRJNA688931_P_NODE_25445_length_202_cov_2.934641_g25232_i0 PRJNA688931 25445 202 2.934641 5.92797482 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 119 7.999999999999998e-30   NR MCB0371130.1 2053517 g25232 i0 82.1 1.99009900990099 67 12 99.5 0 202 2 186 252 MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium] diamond 402 119 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
10872589 10872589 PRJNA688931_P_NODE_32209_length_178_cov_1.193798_g31996_i0 PRJNA688931 32209 178 1.193798 2.12496044 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 217 5.0499999999999996e-52   NTclustered gi|2800920897|gb|CP168968.1| 959 g31996 i0 88.764 194.421348314607 178 19 99 1 2 178 1609020 1609197 Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome blastn 34607 217 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
27082333 27082333 PRJNA688931_P_NODE_3942_length_565_cov_1.782946_g3740_i0 PRJNA688931 3942 565 1.782946 10.0736449 Bdellovibrionota bacterium 3034175 Bacteria Bacteria 55.1 1.14e-5   NR MES2525764.1 3034175 g3740 i0 33 0.515044247787611 97 58 47.8 2 474 205 1 97 MES2525764.1 FHA domain-containing protein [Bdellovibrionota bacterium] diamond 291 55.1 1 Bacteria   Pseudomonadati Bdellovibrionota         Bdellovibrionota bacterium
28672928 28672928 PRJNA688931_P_NODE_10207_length_331_cov_1.099291_g9994_i0 PRJNA688931 10207 331 1.099291 3.63865321 Pseudomonadati 3379134 Bacteria Bacteria 85.1 3.86e-18   NR MBC7419956.1 28201 g9994 i0 45.8 6.32628398791541 96 50 85.2 2 47 328 30 125 MBC7419956.1 lipocalin family protein [Bdellovibrio sp.] diamond 2094 85.1 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
29071990 29071990 PRJNA688931_P_NODE_5748_length_459_cov_2.136585_g5536_i0 PRJNA688931 5748 459 2.136585 9.80692515 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 63.9 1.3e-8   NR MCB9093312.1 2026745 g5536 i0 36.4 0.699346405228758 107 65 68 2 74 385 170 276 MCB9093312.1 hypothetical protein [Halobacteriovoraceae bacterium] diamond 321 63.9 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae bacterium
29166706 29166706 PRJNA688931_P_NODE_18089_length_241_cov_1.666667_g17876_i0 PRJNA688931 18089 241 1.666667 4.01666747 Halobacteriovoraceae bacterium 2026745 Bacteria Bacteria 58.2 1.29e-7   NR MCB9093311.1 2026745 g17876 i0 52.9 0.634854771784232 51 23 63.5 1 2 154 194 243 MCB9093311.1 hypothetical protein [Halobacteriovoraceae bacterium] diamond 153 58.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae   Halobacteriovoraceae bacterium
29702884 29702884 PRJNA688931_P_NODE_39050_length_165_cov_2.224138_g38837_i0 PRJNA688931 39050 165 2.224138 3.6698277 Oligoflexus tunisiensis 708132 Bacteria Bacteria 75.5 3.78e-14   NR WP_141730899.1 708132 g38837 i0 59.3 3.70909090909091 54 22 98.2 0 1 162 701 754 WP_141730899.1 DNA mismatch repair protein MutS [Oligoflexus tunisiensis] diamond 612 75.5 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Oligoflexales Oligoflexaceae Oligoflexus Oligoflexus tunisiensis
29746102 29746102 PRJNA688931_P_NODE_24470_length_207_cov_0.968354_g24257_i0 PRJNA688931 24470 207 0.968354 2.00449278 Pseudomonadati 3379134 Bacteria Bacteria 50.8 3.19e-5   NR MBC7464911.1 28201 g24257 i0 38.2 13.7971014492754 68 40 98.6 2 3 206 542 607 MBC7464911.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis enzyme MnmG [Bdellovibrio sp.] diamond 2856 50.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
31124545 31124545 PRJNA688931_P_NODE_13695_length_280_cov_2.030303_g13482_i0 PRJNA688931 13695 280 2.030303 5.6848484 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 84.7 8.32e-17   NR MCB0371130.1 2053517 g13482 i0 48.4 0.996428571428571 93 47 99.6 1 2 280 324 415 MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium] diamond 279 84.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
31167765 31167765 PRJNA688931_P_NODE_7055_length_409_cov_4.216667_g6842_i0 PRJNA688931 7055 409 4.216667 17.24616803 Pseudomonadati 3379134 Bacteria Bacteria 131 1.47e-33   NR MFA5591951.1 2024841 g6842 i0 56 1.73105134474328 116 51 85.1 0 50 397 2 117 MFA5591951.1 acyl-CoA dehydrogenase [Micavibrio sp.] diamond 708 131 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Micavibrio Micavibrio sp.
31326118 31326118 PRJNA688931_P_NODE_24715_length_206_cov_0.847134_g24502_i0 PRJNA688931 24715 206 0.847134 1.74509604 Bacteriovorax 146784 Bacteria Bacteria 46.2 0.00121   NR WP_021274850.1 1201288 g24502 i0 44.1 2.97087378640777 68 38 99 0 2 205 145 212 WP_021274850.1 slipin family protein [Bacteriovorax sp. Seq25_V] diamond 612 46.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax sp. Seq25_V
31452826 31452826 PRJNA688931_P_NODE_13876_length_278_cov_2.165939_g13663_i0 PRJNA688931 13876 278 2.165939 6.02131042 Pseudomonadati 3379134 Bacteria Bacteria 90.5 2.2e-19   NR MAI61608.1 2024841 g13663 i0 54.5 4.89928057553957 77 35 83.1 0 278 48 82 158 MAI61608.1 electron transfer flavoprotein subunit alpha [Micavibrio sp.] diamond 1362 90.9 0.995599559955996 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Micavibrio Micavibrio sp.
31610926 31610926 PRJNA688931_P_NODE_26196_length_199_cov_1.973333_g25983_i0 PRJNA688931 26196 199 1.973333 3.92693267 root 1 Root_unresolved Root_unresolved 51.6 1.59e-5   NR MEN0059417.1 28201 g25983 i0 37.9 5.321608040201 66 29 99.5 2 198 1 965 1018 MEN0059417.1 ABC transporter transmembrane domain-containing protein [Bdellovibrio sp.] diamond 1059 51.6 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
31883869 31883869 PRJNA688931_P_NODE_15877_length_258_cov_2.220096_g15664_i0 PRJNA688931 15877 258 2.220096 5.72784768 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 136 3.66e-36   NR MCB0371130.1 2053517 g15664 i0 72.9 0.988372093023256 85 23 98.8 0 256 2 4 88 MCB0371130.1 ATP-grasp domain-containing protein [Bdellovibrionales bacterium] diamond 255 136 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
32073842 32073842 PRJNA688931_P_NODE_28758_length_190_cov_0.829787_g28545_i0 PRJNA688931 28758 190 0.829787 1.5765953 Pseudobdellovibrio sp. HCB154 3386277 Bacteria Bacteria 78.2 4.78e-15   NR WP_409478539.1 3386277 g28545 i0 88.6 8.36842105263158 44 5 69.5 0 55 186 330 373 WP_409478539.1 cystathionine gamma-synthase [Pseudobdellovibrio sp. HCB154] diamond 1590 78.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Pseudobdellovibrio Pseudobdellovibrio sp. HCB154

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