RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1105232" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1105232 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
15515178 15515178 PRJNA1105232_S_NODE_11533_length_190_cov_1.475177_g11317_i0 PRJNA1105232 11533 190 1.475177 2.8028363 Pseudomonadati 3379134 Bacteria Bacteria 107 2.08e-25   NR HWU43318.1 28201 g11317 i0 87.1 10.7368421052632 62 8 97.9 0 3 188 347 408 HWU43318.1 polyribonucleotide nucleotidyltransferase [Bdellovibrio sp.] diamond 2040 108 0.990740740740741 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
18064286 18064286 PRJNA1105232_S_NODE_9795_length_204_cov_1.206452_g9579_i0 PRJNA1105232 9795 204 1.206452 2.46116208 Bdellovibrio sp. 28201 Bacteria Bacteria 141 3.84e-41   NR HWU43228.1 28201 g9579 i0 100 1 68 0 100 0 204 1 46 113 HWU43228.1 ATP-dependent Clp protease proteolytic subunit [Bdellovibrio sp.] diamond 204 141 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
20146787 20146787 PRJNA1105232_S_NODE_4916_length_267_cov_3.100917_g4700_i0 PRJNA1105232 4916 267 3.100917 8.27944839 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 109 1.67e-25   NR MCB0385061.1 2053517 g4700 i0 73.3 5.25842696629214 75 20 84.3 0 14 238 285 359 MCB0385061.1 S8 family peptidase [Bdellovibrionales bacterium] diamond 1404 109 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
26719140 26719140 PRJNA1105232_S_NODE_8521_length_215_cov_1.006024_g8305_i0 PRJNA1105232 8521 215 1.006024 2.1629516 Halobacteriovorax sp. 2020862 Bacteria Bacteria 111 2.53e-28   NR MAE58778.1 2020862 g8305 i0 70.4 0.990697674418605 71 21 99.1 0 213 1 146 216 MAE58778.1 type 1 glutamine amidotransferase domain-containing protein [Halobacteriovorax sp.] diamond 213 111 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae Halobacteriovorax Halobacteriovorax sp.
27036075 27036075 PRJNA1105232_S_NODE_15562_length_168_cov_0.873950_g15346_i0 PRJNA1105232 15562 168 0.87395 1.468236 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 98.2 3.4e-24   NR HND85665.1 2026715 g15346 i0 80 0.982142857142857 55 11 98.2 0 167 3 12 66 HND85665.1 translation initiation factor IF-2 [Pseudobdellovibrionaceae bacterium] diamond 165 98.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
27099251 27099251 PRJNA1105232_S_NODE_4142_length_285_cov_4.686441_g3926_i0 PRJNA1105232 4142 285 4.686441 13.35635685 Pseudobdellovibrionaceae bacterium 2026715 Bacteria Bacteria 85.5 5.21e-17   NR MAE74034.1 2026715 g3926 i0 52.7 0.978947368421053 93 43 96.8 1 5 280 359 451 MAE74034.1 hypothetical protein [Pseudobdellovibrionaceae bacterium] diamond 279 85.5 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
28457433 28457433 PRJNA1105232_S_NODE_12226_length_185_cov_3.058824_g12010_i0 PRJNA1105232 12226 185 3.058824 5.6588244 Bdellovibrionia bacterium 3034169 Bacteria Bacteria 116 1.99e-29   NR MFP5520261.1 3034169 g12010 i0 91.8 2.95135135135135 61 5 98.9 0 3 185 267 327 MFP5520261.1 recombinase RecA [Bdellovibrionia bacterium] diamond 546 116 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia       Bdellovibrionia bacterium
29562260 29562260 PRJNA1105232_S_NODE_7490_length_226_cov_1.762712_g7274_i0 PRJNA1105232 7490 226 1.762712 3.98372912 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 68.6 7.54e-12   NR MCB0416831.1 2053517 g7274 i0 50 0.902654867256637 68 34 90.3 0 221 18 138 205 MCB0416831.1 DUF1028 domain-containing protein [Bdellovibrionales bacterium] diamond 204 68.6 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
29656708 29656708 PRJNA1105232_S_NODE_6090_length_245_cov_2.561224_g5874_i0 PRJNA1105232 6090 245 2.561224 6.2749988 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 58.5 7.82e-8   NR MBS1971504.1 2053517 g5874 i0 72.4 3.66122448979592 76 21 93.1 0 18 245 150 225 MBS1971504.1 hypothetical protein [Bdellovibrionales bacterium] diamond 897 58.5 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
29869471 29869471 PRJNA1105232_S_NODE_18771_length_152_cov_2.252427_g18555_i0 PRJNA1105232 18771 152 2.252427 3.42368904 Bacteria 2 Bacteria Bacteria 64.7 1.18e-11   NR MEZ0393028.1 2026715 g18555 i0 76 2.96052631578947 50 12 98.7 0 3 152 46 95 MEZ0393028.1 50S ribosomal protein L18 [Pseudobdellovibrionaceae bacterium] diamond 450 64.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae   Pseudobdellovibrionaceae bacterium
30920974 30920974 PRJNA1105232_S_NODE_11834_length_188_cov_1.496403_g11618_i0 PRJNA1105232 11834 188 1.496403 2.81323764 uncultured Bdellovibrio sp. 239744 Bacteria Bacteria 46.2 0.00105   NR WP_295900119.1 239744 g11618 i0 46.9 0.781914893617021 49 25 78.2 1 2 148 199 246 WP_295900119.1 porin [uncultured Bdellovibrio sp.] diamond 147 46.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio uncultured Bdellovibrio sp.
31101522 31101522 PRJNA1105232_S_NODE_6235_length_243_cov_2.139175_g6019_i0 PRJNA1105232 6235 243 2.139175 5.19819525 Pseudomonadati 3379134 Bacteria Bacteria 82.8 2.87e-16   NR WP_290732337.1 2014617 g6019 i0 55.8 3.88888888888889 77 30 95.1 1 3 233 559 631 WP_290732337.1 prolyl oligopeptidase family serine peptidase [Halobacteriovorax sp. JY17] diamond 945 82.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Halobacteriovoraceae Halobacteriovorax Halobacteriovorax sp. JY17
31173221 31173221 PRJNA1105232_S_NODE_13635_length_177_cov_1.218750_g13419_i0 PRJNA1105232 13635 177 1.21875 2.1571875 Bdellovibrio sp. 28201 Bacteria Bacteria 63.9 2.75e-11   NR MBO9668465.1 28201 g13419 i0 60.4 0.898305084745763 53 21 89.8 0 164 6 1 53 MBO9668465.1 hypothetical protein [Bdellovibrio sp.] diamond 159 63.9 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
31417813 31417813 PRJNA1105232_S_NODE_9596_length_205_cov_3.000000_g9380_i0 PRJNA1105232 9596 205 3 6.15 Bdellovibrio 958 Bacteria Bacteria 119 6.1099999999999994e-30   NR HEY1079752.1 28201 g9380 i0 92.5 12.7463414634146 67 5 98 0 3 203 366 432 HEY1079752.1 ATP-dependent zinc metalloprotease FtsH [Bdellovibrio sp.] diamond 2613 119 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
32344226 32344226 PRJNA1105232_S_NODE_14579_length_172_cov_1.268293_g14363_i0 PRJNA1105232 14579 172 1.268293 2.18146396 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 110 1.89e-26   NR WP_015089232.1 959 g14363 i0 94.7 1.98837209302326 57 3 99.4 0 1 171 12 68 WP_015089232.1 fumarate reductase/succinate dehydrogenase flavoprotein subunit [Bdellovibrio bacteriovorus] diamond 342 110 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
32597073 32597073 PRJNA1105232_S_NODE_10980_length_194_cov_1.434483_g10764_i0 PRJNA1105232 10980 194 1.434483 2.78289702 Bdellovibrio sp. 28201 Bacteria Bacteria 87.8 2.59e-18   NR HWU41837.1 28201 g10764 i0 76.6 1.97938144329897 64 15 99 0 193 2 845 908 HWU41837.1 chromosome segregation protein SMC [Bdellovibrio sp.] diamond 384 87.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.
32785732 32785732 PRJNA1105232_S_NODE_17100_length_163_cov_0.859649_g16884_i0 PRJNA1105232 17100 163 0.859649 1.40122787 Bdellovibrio sp. GT3 3136282 Bacteria Bacteria 74.7 5.53e-14   NR WP_340598136.1 3136282 g16884 i0 69.8 1.95092024539877 53 15 95.7 1 7 162 112 164 WP_340598136.1 S8 family peptidase [Bdellovibrio sp. GT3] diamond 318 74.7 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. GT3

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