RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA737474" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA737474 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
25567809 25567809 PRJNA737474b_S_NODE_15385_length_408_cov_72706.588060_g14346_i0 PRJNA737474 15385 408 72706.58806 296642.8792848 Desulfurellales bacterium 2482794 Bacteria Bacteria 139 1.99e-39   NR TXH58056.1 2482794 g14346 i0 89.3 0.551470588235294 75 8 55.1 0 297 73 38 112 TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium] diamond 225 139 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
26540184 26540184 PRJNA737474g_S_NODE_41520_length_445_cov_1.704301_g40230_i0 PRJNA737474 41520 445 1.704301 7.58413945 Pseudomonadati 3379134 Bacteria Bacteria 119 5.1e-32   NR WP_306199892.1 197 g40230 i0 87.7 0.876404494382023 65 8 43.8 0 3 197 9 73 WP_306199892.1 DUF3467 domain-containing protein, partial [Campylobacter jejuni] diamond 390 120 0.991666666666667 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32919418 32919418 PRJNA737474f_S_NODE_138673_length_271_cov_391.782828_g137995_i0 PRJNA737474 138673 271 391.782828 1061.73146388 Helicobacter pylori 210 Bacteria Bacteria 80.1 6.68e-18   NR GAA8838853.1 210 g137995 i0 92.5 0.44280442804428 40 3 44.3 0 3 122 4 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 120 80.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32936505 32936505 PRJNA737474f_S_NODE_122641_length_279_cov_1.087379_g121963_i0 PRJNA737474 122641 279 1.087379 3.03378741 Helicobacter pylori 210 Bacteria Bacteria 58.9 1.63e-9   NR GAA6916578.1 210 g121963 i0 70 0.43010752688172 40 12 43 0 220 101 1 40 GAA6916578.1 hypothetical protein Kyoto207A_3550 [Helicobacter pylori] diamond 120 58.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32953576 32953576 PRJNA737474e_S_NODE_11866_length_345_cov_2.444853_g10984_i0 PRJNA737474 11866 345 2.444853 8.43474285 Desulfurellales bacterium 2482794 Bacteria Bacteria 202 1.32e-64   NR TXH58056.1 2482794 g10984 i0 86 1.98260869565217 114 16 99.1 0 343 2 30 143 TXH58056.1 MAG: hypothetical protein E6Q97_03180 [Desulfurellales bacterium] diamond 684 202 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
32970516 32970516 PRJNA737474d_S_NODE_33066_length_265_cov_2.609375_g32472_i0 PRJNA737474 33066 265 2.609375 6.91484375 Helicobacter pylori 210 Bacteria Bacteria 63.9 1.85e-11   NR GAA6858901.1 210 g32472 i0 93.3 0.509433962264151 45 3 50.9 0 262 128 4 48 GAA6858901.1 hypothetical protein Kyoto206A_0570 [Helicobacter pylori] diamond 135 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32987670 32987670 PRJNA737474e_S_NODE_13651_length_329_cov_2.289062_g12769_i0 PRJNA737474 13651 329 2.289062 7.53101398 Sulfuricurvum sp. 2025608 Bacteria Bacteria 130 5.099999999999999e-33   NR MDD5212245.1 2025608 g12769 i0 57.5 0.966565349544073 106 45 96.7 0 5 322 300 405 MDD5212245.1 phage portal protein [Sulfuricurvum sp.] diamond 318 130 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfuricurvum Sulfuricurvum sp.
32989006 32989006 PRJNA737474g_S_NODE_263779_length_261_cov_0.808511_g262485_i0 PRJNA737474 263779 261 0.808511 2.11021371 Helicobacter pylori 210 Bacteria Bacteria 53.1 5.3e-7   NR GAA6953496.1 210 g262485 i0 64.7 0.942528735632184 51 18 58.6 0 1 153 3 53 GAA6953496.1 hypothetical protein Kyoto211A_0670 [Helicobacter pylori] diamond 246 53.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33004690 33004690 PRJNA737474e_S_NODE_35243_length_227_cov_3.896104_g34361_i0 PRJNA737474 35243 227 3.896104 8.84415608 Helicobacter pylori 210 Bacteria Bacteria 66.2 1.19e-12   NR GAA8838853.1 210 g34361 i0 90.9 0.436123348017621 33 3 43.6 0 212 114 11 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 99 66.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33005107 33005107 PRJNA737474f_S_NODE_273067_length_242_cov_1.195266_g272389_i0 PRJNA737474 273067 242 1.195266 2.89254372 Campylobacter jejuni 197 Bacteria Bacteria 156 3.74e-47   NR WP_187984201.1 197 g272389 i0 96.3 0.991735537190083 80 3 99.2 0 1 240 34 113 WP_187984201.1 PAS domain S-box protein, partial [Campylobacter jejuni] diamond 240 156 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
33005588 33005588 PRJNA737474g_S_NODE_149091_length_297_cov_0.991071_g147797_i0 PRJNA737474 149091 297 0.991071 2.94348087 Helicobacter pylori 210 Bacteria Bacteria 47.4 7.97e-5   NR GAA6953491.1 210 g147797 i0 80.8 0.717171717171717 26 5 26.3 0 17 94 4 29 GAA6953491.1 hypothetical protein Kyoto211A_0650 [Helicobacter pylori] diamond 213 47.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33005650 33005650 PRJNA737474g_S_NODE_167699_length_289_cov_2.000000_g166405_i0 PRJNA737474 167699 289 2 5.78 Helicobacter saguini 1548018 Bacteria Bacteria 58.2 1.75e-7   NR WP_118949335.1 1548018 g166405 i0 39 2.719723183391 77 43 75.8 1 69 287 85 161 WP_118949335.1 sugar phosphate nucleotidyltransferase [Helicobacter saguini] diamond 786 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter saguini
33005968 33005968 PRJNA737474g_S_NODE_279995_length_257_cov_1.429348_g278701_i0 PRJNA737474 279995 257 1.429348 3.67342436 Helicobacter pylori 210 Bacteria Bacteria 64.3 3.61e-11   NR GAA9038095.1 210 g278701 i0 87.5 0.75875486381323 32 4 37.4 0 2 97 7 38 GAA9038095.1 hypothetical protein Kyoto184A_00980 [Helicobacter pylori] diamond 195 64.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33021065 33021065 PRJNA737474b_S_NODE_44436_length_246_cov_1.421965_g43397_i0 PRJNA737474 44436 246 1.421965 3.4980339 Campylobacter jejuni 197 Bacteria Bacteria 115 1.5199999999999998e-31   NR WP_332061212.1 197 g43397 i0 95.1 0.98780487804878 81 4 98.8 0 3 245 5 85 WP_332061212.1 AI-2E family transporter, partial [Campylobacter jejuni] diamond 243 115 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
33022314 33022314 PRJNA737474f_S_NODE_281892_length_241_cov_1.285714_g281214_i0 PRJNA737474 281892 241 1.285714 3.09857074 Helicobacter pylori 210 Bacteria Bacteria 52.8 3.18e-7   NR GAA8948601.1 210 g281214 i0 71.9 0.398340248962656 32 9 39.8 0 241 146 14 45 GAA8948601.1 hypothetical protein Kyoto181A_0400 [Helicobacter pylori] diamond 96 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33027331 33027331 PRJNA737474g_S_NODE_325148_length_250_cov_1.124294_g323854_i0 PRJNA737474 325148 250 1.124294 2.810735 Bacteria 2 Bacteria Bacteria 53.9 6.73e-7   NR GAA6955717.1 210 g323854 i0 69.4 0.804 36 10 43.2 1 235 128 6 40 GAA6955717.1 hypothetical protein Kyoto211A_1670 [Helicobacter pylori] diamond 201 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33044247 33044247 PRJNA737474g_S_NODE_165116_length_290_cov_3.552995_g163822_i0 PRJNA737474 165116 290 3.552995 10.3036855 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.028   NR WP_299942789.1 2022749 g163822 i0 61.3 0.682758620689655 31 12 32.1 0 10 102 109 139 WP_299942789.1 Hsp20/alpha crystallin family protein [Sulfurimonas sp.] diamond 198 43.1 0.990719257540603 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
33055536 33055536 PRJNA737474d_S_NODE_22413_length_322_cov_2.244980_g21819_i0 PRJNA737474 22413 322 2.24498 7.2288356 Helicobacteraceae bacterium 2212472 Bacteria Bacteria 49.3 4.16e-5   NR NOQ29922.1 2212472 g21819 i0 37.5 0.596273291925466 64 37 59.6 1 2 193 21 81 NOQ29922.1 hypothetical protein [Helicobacteraceae bacterium] diamond 192 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae   Helicobacteraceae bacterium
33061039 33061039 PRJNA737474f_S_NODE_15717_length_509_cov_6.401376_g15046_i0 PRJNA737474 15717 509 6.401376 32.58300384 Pseudomonadati 3379134 Bacteria Bacteria 114 5.910000000000001e-29   NR MBR6612018.1 205 g15046 i0 54.7 2.84086444007859 95 43 56 0 69 353 60 154 MBR6612018.1 NADAR family protein [Campylobacter sp.] diamond 1446 114 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.
33072803 33072803 PRJNA737474e_S_NODE_18189_length_297_cov_6.433036_g17307_i0 PRJNA737474 18189 297 6.433036 19.10611692 Helicobacter pylori 210 Bacteria Bacteria 70.1 1.1e-13   NR GAA9180191.1 210 g17307 i0 89.1 0.555555555555556 55 6 55.6 0 44 208 1 55 GAA9180191.1 hypothetical protein Kyoto193A_2320 [Helicobacter pylori] diamond 165 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33073725 33073725 PRJNA737474g_S_NODE_121157_length_312_cov_1.071130_g119863_i0 PRJNA737474 121157 312 1.07113 3.3419256 Helicobacter pylori 210 Bacteria Bacteria 54.7 2.24e-7   NR GAA6953502.1 210 g119863 i0 74.1 0.778846153846154 27 7 26 0 223 143 12 38 GAA6953502.1 hypothetical protein Kyoto211A_0700 [Helicobacter pylori] diamond 243 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33074093 33074093 PRJNA737474g_S_NODE_247709_length_264_cov_2.172775_g246415_i0 PRJNA737474 247709 264 2.172775 5.736126 Helicobacter sp. MIT 11-5569 1548151 Bacteria Bacteria 122 2.55e-32   NR WP_034291347.1 1548151 g246415 i0 63.2 1.97727272727273 87 32 98.9 0 3 263 122 208 WP_034291347.1 sugar phosphate nucleotidyltransferase [Helicobacter sp. MIT 11-5569] diamond 522 122 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. MIT 11-5569
33078192 33078192 PRJNA737474f_S_NODE_151637_length_266_cov_1.300518_g150959_i0 PRJNA737474 151637 266 1.300518 3.45937788 Pseudomonadati 3379134 Bacteria Bacteria 168 2.5e-47   NR MDD3500783.1 1969726 g150959 i0 91.4 3.65413533834586 81 7 91.4 0 264 22 492 572 MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.] diamond 972 168 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
33107136 33107136 PRJNA737474f_S_NODE_100022_length_291_cov_1.366972_g99344_i0 PRJNA737474 100022 291 1.366972 3.97788852 Thiovulum sp. ES 1177931 Bacteria Bacteria 103 1.41e-24   NR EJF07249.1 1177931 g99344 i0 58.3 0.865979381443299 84 35 86.6 0 8 259 78 161 EJF07249.1 capsule polysaccharide export protein [Thiovulum sp. ES] diamond 252 103 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Thiovulum Thiovulum sp. ES
33125194 33125194 PRJNA737474g_S_NODE_185351_length_283_cov_0.876190_g184057_i0 PRJNA737474 185351 283 0.87619 2.4796177 Helicobacter pylori 210 Bacteria Bacteria 48.9 1.75e-5   NR GAA8766134.1 210 g184057 i0 95.2 0.222614840989399 21 1 22.3 0 208 270 1 21 GAA8766134.1 hypothetical protein Kyoto147A_4290 [Helicobacter pylori] diamond 63 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33125215 33125215 PRJNA737474g_S_NODE_195983_length_279_cov_1.121359_g194689_i0 PRJNA737474 195983 279 1.121359 3.12859161 Helicobacter pylori 210 Bacteria Bacteria 60.8 8.22e-10   NR GAA8733134.1 210 g194689 i0 69.2 0.78494623655914 39 12 41.9 0 4 120 4 42 GAA8733134.1 hypothetical protein Kyoto147A_1050 [Helicobacter pylori] diamond 219 60.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33129419 33129419 PRJNA737474f_S_NODE_154615_length_265_cov_1.197917_g153937_i0 PRJNA737474 154615 265 1.197917 3.17448005 Campylobacter 194 Bacteria Bacteria 45.4 0.00533   NR WP_070274184.1 194 g153937 i0 48.6 0.837735849056604 37 19 41.9 0 3 113 135 171 WP_070274184.1 MULTISPECIES: hypothetical protein [Campylobacter] diamond 222 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter  
33129561 33129561 PRJNA737474f_S_NODE_9103_length_678_cov_1.383471_g8488_i0 PRJNA737474 9103 678 1.383471 9.37993338 Pseudomonadati 3379134 Bacteria Bacteria 107 2.8899999999999995e-23   NR WP_095224823.1 1476199 g8488 i0 33.7 4.93362831858407 193 112 81.9 5 606 52 19 203 WP_095224823.1 glycosyltransferase family 87 protein [Helicobacter sp. 12S02634-8] diamond 3345 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. 12S02634-8
33129687 33129687 PRJNA737474g_S_NODE_313975_length_251_cov_1.241573_g312681_i0 PRJNA737474 313975 251 1.241573 3.11634823 Pseudomonadati 3379134 Bacteria Bacteria 53.1 2.84e-7   NR GAA8724913.1 210 g312681 i0 84 0.920318725099602 25 4 29.9 0 13 87 1 25 GAA8724913.1 hypothetical protein Kyoto145A_4940 [Helicobacter pylori] diamond 231 53.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33142164 33142164 PRJNA737474g_S_NODE_171007_length_288_cov_1.134884_g169713_i0 PRJNA737474 171007 288 1.134884 3.26846592 Sulfurovum sp. 1969726 Bacteria Bacteria 152 2.72e-41   NR MDD3500783.1 1969726 g169713 i0 91.6 1.72916666666667 83 7 86.5 0 39 287 244 326 MDD3500783.1 group II intron reverse transcriptase/maturase [Sulfurovum sp.] diamond 498 152 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
33157617 33157617 PRJNA737474c_S_NODE_28120_length_243_cov_2.805882_g27289_i0 PRJNA737474 28120 243 2.805882 6.81829326 Campylobacter jejuni 197 Bacteria Bacteria 54.3 1.22e-7   NR MCH3846953.1 197 g27289 i0 83.3 0.740740740740741 30 5 37 0 93 4 1 30 MCH3846953.1 leucine dehydrogenase [Campylobacter jejuni] diamond 180 54.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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