RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA861969 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
22523109 22523109 PRJNA861969_P_NODE_28678_length_259_cov_1.290323_g28447_i0 PRJNA861969 28678 259 1.290323 3.34193657 Planococcus dechangensis 1176255 Bacteria Bacteria 171 6.309999999999999e-52   NR WP_377280155.1 1176255 g28447 i0 91.9 0.996138996138996 86 7 99.6 0 259 2 5 90 WP_377280155.1 GNAT family N-acetyltransferase [Planococcus dechangensis] diamond 258 171 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus dechangensis
25072678 25072678 PRJNA861969_P_NODE_39220_length_243_cov_0.905882_g38989_i0 PRJNA861969 39220 243 0.905882 2.20129326 Planococcus dechangensis 1176255 Bacteria Bacteria 122 4.459999999999999e-34   NR WP_377277072.1 1176255 g38989 i0 98.4 0.777777777777778 63 1 77.8 0 2 190 45 107 WP_377277072.1 thioredoxin family protein [Planococcus dechangensis] diamond 189 122 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus dechangensis
26928569 26928569 PRJNA861969_P_NODE_27722_length_263_cov_1.621053_g27491_i0 PRJNA861969 27722 263 1.621053 4.26336939 Desulfitobacterium sp. 49981 Bacteria Bacteria 105 1.5999999999999999e-24   NR WP_325394154.1 49981 g27491 i0 60.5 0.980988593155893 86 31 98.1 1 4 261 32 114 WP_325394154.1 zinc ribbon domain-containing protein [Desulfitobacterium sp.] diamond 258 105 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
27402866 27402866 PRJNA861969_P_NODE_38463_length_244_cov_0.900585_g38232_i0 PRJNA861969 38463 244 0.900585 2.1974274 Desulfosporosinus sp. PR 3401928 Bacteria Bacteria 140 1.51e-40   NR WP_308894782.1 3059172 g38232 i0 84 0.995901639344262 81 13 99.6 0 243 1 75 155 WP_308894782.1 pyruvoyl-dependent arginine decarboxylase [Desulfosporosinus sp. PR] diamond 243 140 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus sp. PR
27781775 27781775 PRJNA861969_P_NODE_25704_length_272_cov_1.547739_g25473_i0 PRJNA861969 25704 272 1.547739 4.20985008 Metabacillus dongyingensis 2874282 Bacteria Bacteria 137 4.59e-38   NR WP_223439037.1 2874282 g25473 i0 85.6 0.992647058823529 90 13 99.3 0 2 271 3 92 WP_223439037.1 twin-arginine translocase subunit TatC [Metabacillus dongyingensis] diamond 270 137 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Metabacillus Metabacillus dongyingensis
27876318 27876318 PRJNA861969_P_NODE_36065_length_246_cov_0.890173_g35834_i0 PRJNA861969 36065 246 0.890173 2.18982558 Planococcus dechangensis 1176255 Bacteria Bacteria 141 4.37e-38   NR WP_377279251.1 1176255 g35834 i0 88.9 0.98780487804878 81 9 98.8 0 244 2 72 152 WP_377279251.1 hypothetical protein [Planococcus dechangensis] diamond 243 141 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus dechangensis
28002888 28002888 PRJNA861969_P_NODE_35265_length_247_cov_0.885057_g35034_i0 PRJNA861969 35265 247 0.885057 2.18609079 Peptoniphilus rachelemmaiella 2811779 Bacteria Bacteria 166 1.13e-45   NR WP_215506625.1 2811779 g35034 i0 100 0.983805668016194 81 0 98.4 0 3 245 356 436 WP_215506625.1 InlB B-repeat-containing protein [Peptoniphilus rachelemmaiella] diamond 243 166 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Peptoniphilus Peptoniphilus rachelemmaiella
28255156 28255156 PRJNA861969_P_NODE_42506_length_226_cov_2.013072_g42275_i0 PRJNA861969 42506 226 2.013072 4.54954272 Parageobacillus thermoglucosidasius 1426 Bacteria Bacteria 51.6 6.03e-6   NR RDE20760.1 1426 g42275 i0 42.9 0.836283185840708 63 36 83.6 0 219 31 10 72 RDE20760.1 hypothetical protein DV712_11155 [Parageobacillus thermoglucosidasius] diamond 189 51.6 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Anoxybacillaceae Parageobacillus Parageobacillus thermoglucosidasius
29013340 29013340 PRJNA861969_P_NODE_35408_length_247_cov_0.885057_g35177_i0 PRJNA861969 35408 247 0.885057 2.18609079 Marinococcus halotolerans 301092 Bacteria Bacteria 156 5.32e-44   NR WP_022792912.1 301092 g35177 i0 95.1 0.995951417004049 82 4 99.6 0 2 247 42 123 WP_022792912.1 iron-containing alcohol dehydrogenase [Marinococcus halotolerans] diamond 246 156 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Marinococcus Marinococcus halotolerans
29210805 29210805 PRJNA861969_P_NODE_24849_length_276_cov_1.517241_g24618_i0 PRJNA861969 24849 276 1.517241 4.18758516 Bacillus 1386 Bacteria Bacteria 123 1.78e-30   NR WP_256499189.1 1408 g24618 i0 88.4 2.25 69 8 75 0 276 70 493 561 WP_256499189.1 hypothetical protein [Bacillus pumilus] diamond 621 123 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus pumilus
29518139 29518139 PRJNA861969_P_NODE_36550_length_246_cov_0.890173_g36319_i0 PRJNA861969 36550 246 0.890173 2.18982558 Veillonella sp. DNF 1926307 Bacteria Bacteria 176 3.23e-49   NR WP_062400908.1 1384081 g36319 i0 98.8 1 82 1 100 0 1 246 351 432 WP_062400908.1 DUF3427 domain-containing protein [Veillonella sp. DNF00869] diamond 246 176 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella sp. DNF00869
29707222 29707222 PRJNA861969_P_NODE_41670_length_241_cov_0.916667_g41439_i0 PRJNA861969 41670 241 0.916667 2.20916747 Planococcus dechangensis 1176255 Bacteria Bacteria 79 4.5e-17   NR WP_377277195.1 1176255 g41439 i0 91.3 0.572614107883817 46 4 57.3 0 104 241 1 46 WP_377277195.1 hypothetical protein [Planococcus dechangensis] diamond 138 79 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Caryophanaceae Planococcus Planococcus dechangensis
30340007 30340007 PRJNA861969_P_NODE_42392_length_229_cov_2.461538_g42161_i0 PRJNA861969 42392 229 2.461538 5.63692202 Marinococcus halophilus 1371 Bacteria Bacteria 149 8.68e-41   NR WP_094908925.1 1371 g42161 i0 94.7 1.99126637554585 76 4 99.6 0 1 228 272 347 WP_094908925.1 MBL fold metallo-hydrolase [Marinococcus halophilus] diamond 456 149 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Marinococcus Marinococcus halophilus
30686896 30686896 PRJNA861969_P_NODE_24493_length_278_cov_1.141463_g24262_i0 PRJNA861969 24493 278 1.141463 3.17326714 Bacillus sp. UMB 2066053 Bacteria Bacteria 146 2.8999999999999993e-43   NR WP_180849991.1 2066053 g24262 i0 83.5 1.96402877697842 91 15 98.2 0 3 275 5 95 WP_180849991.1 Ger(x)C family spore germination C-terminal domain-containing protein [Bacillus sp. UMB0893] diamond 546 146 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. UMB0893
31034885 31034885 PRJNA861969_P_NODE_40035_length_242_cov_1.792899_g39804_i0 PRJNA861969 40035 242 1.792899 4.33881558 Streptococcus sp. HMSC 1306 Bacteria Bacteria 112 2.86e-29   NR WP_075228855.1 1739491 g39804 i0 74 0.954545454545455 77 20 95.5 0 12 242 6 82 WP_075228855.1 hypothetical protein [Streptococcus sp. HMSC067H01] diamond 231 112 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus sp. HMSC067H01
31485566 31485566 PRJNA861969_P_NODE_23716_length_281_cov_1.480769_g23485_i0 PRJNA861969 23716 281 1.480769 4.16096089 Eubacteriales 186802 Bacteria Bacteria 85.5 1.46e-17   NR WP_148265259.1 1563 g23485 i0 48.3 3.80071174377224 87 45 92.9 0 15 275 91 177 WP_148265259.1 hypothetical protein [Desulfosporosinus orientis] diamond 1068 85.9 0.9953434225844 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfosporosinus Desulfosporosinus orientis
31730137 31730137 PRJNA861969_P_NODE_28837_length_258_cov_1.664865_g28606_i0 PRJNA861969 28837 258 1.664865 4.2953517 Pelorhabdus rhamnosifermentans 2772457 Bacteria Bacteria 157 5.19e-44   NR WP_215830330.1 2772457 g28606 i0 92.9 0.988372093023256 85 6 98.8 0 1 255 119 203 WP_215830330.1 ATP-dependent protease ATPase subunit HslU [Pelorhabdus rhamnosifermentans] diamond 255 157 1 Bacteria   Bacillati Bacillota Negativicutes Selenomonadales Sporomusaceae Pelorhabdus Pelorhabdus rhamnosifermentans
31991372 31991372 PRJNA861969_P_NODE_34078_length_248_cov_0.880000_g33847_i0 PRJNA861969 34078 248 0.88 2.1824 Desulfitobacterium 36853 Bacteria Bacteria 112 1.14e-29   NR WP_323415339.1 49981 g33847 i0 68.3 1.98387096774194 82 26 99.2 0 2 247 5 86 WP_323415339.1 MarR family winged helix-turn-helix transcriptional regulator [Desulfitobacterium sp.] diamond 492 112 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium sp.
32276449 32276449 PRJNA861969_P_NODE_30978_length_251_cov_0.865169_g30747_i0 PRJNA861969 30978 251 0.865169 2.17157419 Bacilli 91061 Bacteria Bacteria 116 4.77e-30   NR CJH68509.1 1313 g30747 i0 66.3 5.91633466135458 83 28 99.2 0 1 249 6 88 CJH68509.1 methylenetetrahydrofolate dehydrogenase [Streptococcus pneumoniae] diamond 1485 116 1 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus pneumoniae
32363231 32363231 PRJNA861969_P_NODE_32219_length_250_cov_0.870056_g31988_i0 PRJNA861969 32219 250 0.870056 2.17514 Desulfitobacterium metallireducens 142877 Bacteria Bacteria 146 3.22e-40   NR WP_006715480.1 142877 g31988 i0 90.2 1.968 82 8 98.4 0 5 250 34 115 WP_006715480.1 acetyl-CoA C-acetyltransferase [Desulfitobacterium metallireducens] diamond 492 146 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Desulfitobacteriaceae Desulfitobacterium Desulfitobacterium metallireducens
32402863 32402863 PRJNA861969_P_NODE_15619_length_336_cov_1.216730_g15388_i0 PRJNA861969 15619 336 1.21673 4.0882128 Bacteria 2 Bacteria Bacteria 66.2 3.27e-10   NR MCI9507724.1 2485925 g15388 i0 31.6 1.92857142857143 114 70 99.1 3 335 3 62 170 MCI9507724.1 hypothetical protein [Oscillospiraceae bacterium] diamond 648 66.2 1 Bacteria   Bacillati Bacillota Clostridia Eubacteriales Oscillospiraceae   Oscillospiraceae bacterium
32553148 32553148 PRJNA861969_P_NODE_29519_length_255_cov_1.692308_g29288_i0 PRJNA861969 29519 255 1.692308 4.3153854 Peptacetobacter hominis 2743610 Bacteria Bacteria 78.6 5.47e-15   NR WP_142536582.1 2743610 g29288 i0 47.7 7.12941176470588 88 37 95.3 2 1 243 174 259 WP_142536582.1 type I phosphomannose isomerase catalytic subunit [Peptacetobacter hominis] diamond 1818 78.6 1 Bacteria   Bacillati Bacillota Clostridia Peptostreptococcales Peptostreptococcaceae Peptacetobacter Peptacetobacter hominis

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