RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA415856" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJNA415856 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
26758944 26758944 PRJNA415856_P_NODE_381_length_1411_cov_6.279001_g300_i0 PRJNA415856 381 1411 6.279001 88.59670411 Campylobacter jejuni 197 Bacteria Bacteria 143 2e-36   NR RTI48602.1 197 g300 i0 48.1 0.278525868178597 131 68 27.9 0 393 1 4 134 RTI48602.1 hypothetical protein C3I27_04060 [Campylobacter jejuni] diamond 393 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
26948916 26948916 PRJNA415856_P_NODE_322_length_1502_cov_5.249828_g250_i0 PRJNA415856 322 1502 5.249828 78.85241656 Helicobacter canis 29419 Bacteria Bacteria 237 5.09e-73   NR WP_115010603.1 29419 g250 i0 99.2 0.24167776298269 121 1 24.2 0 723 361 1 121 WP_115010603.1 phage holin family protein [Helicobacter canis] diamond 363 237 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canis
27012233 27012233 PRJNA415856_P_NODE_402_length_1389_cov_5.897761_g320_i0 PRJNA415856 402 1389 5.897761 81.91990029 Campylobacter lanienae 75658 Bacteria Bacteria 291 1.0299999999999999e-92   NR WP_321071193.1 75658 g320 i0 60.6 0.531317494600432 246 82 52.7 4 1118 387 18 250 WP_321071193.1 phage antirepressor KilAC domain-containing protein [Campylobacter lanienae] diamond 738 291 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lanienae
27075552 27075552 PRJNA415856_P_NODE_122_length_2006_cov_6.359223_g92_i0 PRJNA415856 122 2006 6.359223 127.56601338 Campylobacter helveticus 28898 Bacteria Bacteria 60.5 3.09e-7   NR WP_082199829.1 28898 g92 i0 33.7 0.469591226321037 101 60 14.8 3 1433 1137 4 99 WP_082199829.1 hypothetical protein [Campylobacter helveticus] diamond 942 60.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter helveticus
27138359 27138359 PRJNA415856_P_NODE_662_length_1144_cov_6.306849_g553_i0 PRJNA415856 662 1144 6.306849 72.15035256 uncultured Helicobacter sp. 175537 Bacteria Bacteria 189 4.33e-54   NR WP_299327203.1 175537 g553 i0 61.8 0.398601398601399 152 57 39.9 1 44 499 3 153 WP_299327203.1 phage antirepressor KilAC domain-containing protein, partial [uncultured Helicobacter sp.] diamond 456 189 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
27360184 27360184 PRJNA415856_P_NODE_1783_length_744_cov_6.943885_g1576_i0 PRJNA415856 1783 744 6.943885 51.6625044 unclassified Helicobacter 2593540 Bacteria Bacteria 286 4.369999999999999e-95   NR WP_285256502.1 2593540 g1576 i0 90.8 0.657258064516129 163 15 65.7 0 3 491 24 186 WP_285256502.1 MULTISPECIES: hypothetical protein [unclassified Helicobacter] diamond 489 286 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter  
27486383 27486383 PRJNA415856_P_NODE_23563_length_186_cov_1.489051_g23302_i0 PRJNA415856 23563 186 1.489051 2.76963486 Campylobacter sp. RM16187 1660063 Bacteria Bacteria 120 3.8499999999999996e-31   NR WP_260953213.1 1660063 g23302 i0 90.3 1 62 6 100 0 186 1 227 288 WP_260953213.1 adenine-specific methyltransferase EcoRI family protein [Campylobacter sp. RM16187] diamond 186 120 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. RM16187
27707854 27707854 PRJNA415856_P_NODE_364_length_1442_cov_6.678392_g285_i0 PRJNA415856 364 1442 6.678392 96.30241264 Campylobacter jejuni 197 Bacteria Bacteria 50.1 0.0151   NR WP_126232126.1 197 g285 i0 29.5 0.30998613037448 149 81 30.8 5 1018 575 207 332 WP_126232126.1 hypothetical protein [Campylobacter jejuni] diamond 447 50.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27896722 27896722 PRJNA415856_P_NODE_5_length_6435_cov_9.514563_g4_i0 PRJNA415856 5 6435 9.514563 612.26212905 Helicobacter sp. 218 Bacteria Bacteria 172 6.82e-44   NR HCD73290.1 218 g4 i0 41.4 0.113752913752914 244 138 11.3 3 2577 1852 1 241 HCD73290.1 hypothetical protein [Helicobacter sp.] diamond 732 172 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp.
27928424 27928424 PRJNA415856_P_NODE_25_length_3537_cov_8.647936_g19_i0 PRJNA415856 25 3537 8.647936 305.87749632 uncultured Helicobacter sp. 175537 Bacteria Bacteria 282 6.45e-84   NR WP_299327320.1 175537 g19 i0 90.9 0.139949109414758 165 15 14 0 496 2 1 165 WP_299327320.1 KilA-N domain-containing protein [uncultured Helicobacter sp.] diamond 495 282 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
27959934 27959934 PRJNA415856_P_NODE_7645_length_333_cov_4.507042_g7384_i0 PRJNA415856 7645 333 4.507042 15.00844986 Helicobacter valdiviensis 1458358 Bacteria Bacteria 72.4 1.59e-12   NR WP_111230195.1 1458358 g7384 i0 57.9 1.06306306306306 57 24 51.4 0 182 12 1 57 WP_111230195.1 DNA cytosine methyltransferase [Helicobacter valdiviensis] diamond 354 72.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter valdiviensis
28275611 28275611 PRJNA415856_P_NODE_54706_length_154_cov_4.285714_g54445_i0 PRJNA415856 54706 154 4.285714 6.59999956 Helicobacter pylori 210 Bacteria Bacteria 80.1 2.04e-18   NR GAA9125269.1 210 g54445 i0 100 0.681818181818182 35 0 68.2 0 3 107 4 38 GAA9125269.1 hypothetical protein Kyoto190A_0810 [Helicobacter pylori] diamond 105 80.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28923670 28923670 PRJNA415856_P_NODE_34828_length_167_cov_1.576271_g34567_i0 PRJNA415856 34828 167 1.576271 2.63237257 Pseudomonadati 3379134 Bacteria Bacteria 113 3.33e-30   NR WP_323470372.1 197 g34567 i0 98.2 1.97604790419162 55 1 98.8 0 166 2 96 150 WP_323470372.1 cell division protein FtsQ/DivIB, partial [Campylobacter jejuni] diamond 330 113 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
28970399 28970399 PRJNA415856_P_NODE_488_length_1289_cov_5.697581_g399_i0 PRJNA415856 488 1289 5.697581 73.44181909 uncultured Helicobacter sp. 175537 Bacteria Bacteria 67.4 1.32e-8   NR WP_299327207.1 175537 g399 i0 26.1 0.633048875096974 272 150 61.9 10 314 1111 25 251 WP_299327207.1 hypothetical protein [uncultured Helicobacter sp.] diamond 816 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
28987244 28987244 PRJNA415856_P_NODE_88_length_2267_cov_10.414337_g65_i0 PRJNA415856 88 2267 10.414337 236.09301979 root 1 Root_unresolved Root_unresolved 118 1.23e-27   NR WP_150337043.1 29419 g65 i0 76.1 0.742390824878694 71 17 9.4 0 2265 2053 26 96 WP_150337043.1 phage antirepressor KilAC domain-containing protein [Helicobacter canis] diamond 1683 118 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canis
29254281 29254281 PRJNA415856_P_NODE_10349_length_275_cov_6.398230_g10088_i0 PRJNA415856 10349 275 6.39823 17.5951325 Helicobacter canis 29419 Bacteria Bacteria 131 7.779999999999999e-38   NR WP_115010607.1 29419 g10088 i0 98.4 0.665454545454545 61 1 66.5 0 274 92 24 84 WP_115010607.1 hypothetical protein [Helicobacter canis] diamond 183 131 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canis
29507011 29507011 PRJNA415856_P_NODE_2750_length_603_cov_4.978339_g2511_i0 PRJNA415856 2750 603 4.978339 30.01938417 Helicobacter magdeburgensis 471858 Bacteria Bacteria 90.1 2.09e-18   NR WP_034588097.1 471858 g2511 i0 43.3 0.482587064676617 97 55 48.3 0 602 312 117 213 WP_034588097.1 hypothetical protein [Helicobacter magdeburgensis] diamond 291 90.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter magdeburgensis
29727843 29727843 PRJNA415856_P_NODE_28250_length_177_cov_1.593750_g27989_i0 PRJNA415856 28250 177 1.59375 2.8209375 Campylobacter sp. 2 205 Bacteria Bacteria 81.3 1.04e-17   NR WP_214120692.1 2836735 g27989 i0 81.6 1.59322033898305 49 9 83.1 0 149 3 59 107 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 282 81.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01
30360398 30360398 PRJNA415856_P_NODE_1712_length_759_cov_9.400000_g1513_i0 PRJNA415856 1712 759 9.4 71.346 uncultured Helicobacter sp. 175537 Bacteria Bacteria 346 1.77e-116   NR WP_299327288.1 175537 g1513 i0 90.8 0.731225296442688 185 17 73.1 0 205 759 1 185 WP_299327288.1 N-6 DNA methylase [uncultured Helicobacter sp.] diamond 555 346 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
30455079 30455079 PRJNA415856_P_NODE_3073_length_570_cov_6.992322_g2827_i0 PRJNA415856 3073 570 6.992322 39.8562354 uncultured Helicobacter sp. 175537 Bacteria Bacteria 211 1.72e-64   NR WP_299327288.1 175537 g2827 i0 77.6 0.752631578947368 143 27 73.2 2 1 417 177 318 WP_299327288.1 N-6 DNA methylase [uncultured Helicobacter sp.] diamond 429 211 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter uncultured Helicobacter sp.
30738995 30738995 PRJNA415856_P_NODE_1094_length_933_cov_6.876697_g938_i0 PRJNA415856 1094 933 6.876697 64.15958301 Helicobacter sp. 218 Bacteria Bacteria 82 1.43e-15   NR WP_290946306.1 218 g938 i0 38 0.321543408360129 100 62 32.2 0 820 521 1 100 WP_290946306.1 hypothetical protein [Helicobacter sp.] diamond 300 82 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp.
30913830 30913830 PRJNA415856_P_NODE_40694_length_165_cov_0.879310_g40433_i0 PRJNA415856 40694 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 45.8 4.7e-4   NR GAA9396157.1 210 g40433 i0 78.3 3.38181818181818 23 5 41.8 0 70 2 82 104 GAA9396157.1 hypothetical protein BTM418_15410 [Helicobacter pylori] diamond 558 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31307806 31307806 PRJNA415856_P_NODE_44175_length_164_cov_0.886957_g43914_i0 PRJNA415856 44175 164 0.886957 1.45460948 Campylobacter concisus 199 Bacteria Bacteria 104 3.74e-25   NR WP_148820009.1 199 g43914 i0 92.6 0.98780487804878 54 4 98.8 0 2 163 234 287 WP_148820009.1 ParA family protein [Campylobacter concisus] diamond 162 104 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
31908899 31908899 PRJNA415856_P_NODE_51177_length_161_cov_1.633929_g50916_i0 PRJNA415856 51177 161 1.633929 2.63062569 Helicobacter canis 29419 Bacteria Bacteria 106 1.47e-26   NR WP_115010637.1 29419 g50916 i0 100 0.987577639751553 53 0 98.8 0 161 3 163 215 WP_115010637.1 hypothetical protein [Helicobacter canis] diamond 159 106 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canis
31972111 31972111 PRJNA415856_P_NODE_42138_length_165_cov_0.879310_g41877_i0 PRJNA415856 42138 165 0.87931 1.4508615 Helicobacter canis 29419 Bacteria Bacteria 100 5.73e-23   NR WP_150337192.1 29419 g41877 i0 96.3 3.92727272727273 54 2 98.2 0 3 164 385 438 WP_150337192.1 methyl-accepting chemotaxis protein [Helicobacter canis] diamond 648 100 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter canis
32115495 32115495 PRJNA415856_P_NODE_23038_length_187_cov_1.398551_g22777_i0 PRJNA415856 23038 187 1.398551 2.61529037 root 1 Root_unresolved Root_unresolved 52 1.43e-6   NR MDU9757963.1 210 g22777 i0 50 19.7647058823529 44 18 70.6 1 28 159 57 96 MDU9757963.1 endonuclease [Helicobacter pylori] diamond 3696 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32368742 32368742 PRJNA415856_P_NODE_2659_length_613_cov_5.856383_g2421_i0 PRJNA415856 2659 613 5.856383 35.89962779 Campylobacter 194 Bacteria Bacteria 243 4.41e-78   NR EAJ6150330.1 201 g2421 i0 62.6 2.65742251223491 187 64 89.1 2 1 546 25 210 EAJ6150330.1 DNA (cytosine-5-)-methyltransferase [Campylobacter lari] diamond 1629 243 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
32621297 32621297 PRJNA415856_P_NODE_41660_length_165_cov_0.879310_g41399_i0 PRJNA415856 41660 165 0.87931 1.4508615 Pseudomonadati 3379134 Bacteria Bacteria 65.1 4.34e-12   NR MFC2588121.1 205 g41399 i0 100 3.38181818181818 31 0 56.4 0 3 95 58 88 MFC2588121.1 preprotein translocase subunit SecY [Campylobacter sp.] diamond 558 65.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.
32841686 32841686 PRJNA415856_P_NODE_240_length_1647_cov_9.135169_g186_i0 PRJNA415856 240 1647 9.135169 150.45623343 Helicobacter 209 Bacteria Bacteria 305 1.29e-96   NR WP_115026573.1 213 g186 i0 64.2 0.794171220400729 229 72 40.1 2 2 661 44 271 WP_115026573.1 phosphoadenosine phosphosulfate reductase family protein [Helicobacter cinaedi] diamond 1308 305 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi

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