RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA520845", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 22 ✖

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA520845 · 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
3039284 3039284 PRJNA520845_P_NODE_141963_length_313_cov_2.637500_g140464_i0 PRJNA520845 141963 313 2.6375 8.255375 Hippea maritima 84405 Bacteria Bacteria 54.7 0.008   NTclustered gi|327180802|gb|CP002606.1| 760142 g140464 i0 96.875 0.10223642172524 32 1 10 0 159 190 522373 522342 Hippea maritima DSM 10411, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales Hippeaceae Hippea Hippea maritima
6214638 6214638 PRJNA520845_P_NODE_118405_length_343_cov_0.855556_g116906_i0 PRJNA520845 118405 343 0.855556 2.93455708 Campylobacter 194 Bacteria Bacteria 634 2.5299999999999996e-177   NTclustered gi|1829615825|gb|CP048760.1| 197 g116906 i0 100 100.020408163265 343 0 100 0 1 343 411779 412121 Campylobacter jejuni strain ZS005 chromosome, complete genome blastn 34307 634 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
6865559 6865559 PRJNA520845_P_NODE_125186_length_334_cov_0.885057_g123687_i0 PRJNA520845 125186 334 0.885057 2.95609038 Campylobacter jejuni 197 Bacteria Bacteria 617 2.48e-172   NTclustered gi|1626698542|gb|CP032522.1| 197 g123687 i0 100 100.359281437126 334 0 100 0 1 334 189629 189962 Campylobacter jejuni strain BC chromosome, complete genome blastn 33520 617 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
13244011 13244011 PRJNA520845_P_NODE_209231_length_254_cov_1.348066_g207732_i0 PRJNA520845 209231 254 1.348066 3.42408764 Aliarcobacter butzleri 28197 Bacteria Bacteria 470 5.37e-128   NTclustered gi|2305706618|gb|CP104378.1| 28197 g207732 i0 100 15.7716535433071 254 0 100 0 1 254 1229220 1229473 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 4006 470 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20237989 20237989 PRJNA520845_P_NODE_203496_length_259_cov_1.225806_g201997_i0 PRJNA520845 203496 259 1.225806 3.17483754 Aliarcobacter 2321111 Bacteria Bacteria 132 2.95e-26   NTclustered gi|2305706618|gb|CP104378.1| 28197 g201997 i0 80.114 21.8880308880309 176 35 68 0 3 178 395989 395814 Aliarcobacter butzleri strain P1100 chromosome, complete genome blastn 5669 132 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20890495 20890495 PRJNA520845_P_NODE_146397_length_309_cov_0.978814_g144898_i0 PRJNA520845 146397 309 0.978814 3.02453526 Campylobacter jejuni 197 Bacteria Bacteria 571 1.7899999999999995e-158   NTclustered gi|1444889023|gb|CP012220.1| 197 g144898 i0 100 98.7831715210356 309 0 100 0 1 309 1408470 1408162 Campylobacter jejuni strain CJ090CC1332, complete genome blastn 30524 571 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
20891880 20891880 PRJNA520845_P_NODE_198757_length_263_cov_1.115789_g197258_i0 PRJNA520845 198757 263 1.115789 2.93452507 Campylobacter jejuni 197 Bacteria Bacteria 486 5.5499999999999986e-133   NTclustered gi|1626698542|gb|CP032522.1| 197 g197258 i0 100 101 263 0 100 0 1 263 1492765 1492503 Campylobacter jejuni strain BC chromosome, complete genome blastn 26563 486 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
20893921 20893921 PRJNA520845_P_NODE_32517_length_667_cov_1.469697_g31069_i0 PRJNA520845 32517 667 1.469697 9.80287899 Arcobacter ellisii 913109 Bacteria Bacteria 56.5 0.005   NTclustered gi|1474793334|gb|CP032097.1| 913109 g31069 i0 100 0.0449775112443778 30 0 4 0 429 458 81988 81959 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
21513240 21513240 PRJNA520845_P_NODE_147257_length_308_cov_0.982979_g145758_i0 PRJNA520845 147257 308 0.982979 3.02757532 Campylobacter 194 Bacteria Bacteria 569 6.419999999999998e-158   NTclustered gi|1626698542|gb|CP032522.1| 197 g145758 i0 100 100 308 0 100 0 1 308 1401294 1400987 Campylobacter jejuni strain BC chromosome, complete genome blastn 30800 569 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
23443065 23443065 PRJNA520845_P_NODE_230139_length_248_cov_0.880000_g228640_i0 PRJNA520845 230139 248 0.88 2.1824 Campylobacter jejuni 197 Bacteria Bacteria 459 1.13e-124   NTclustered gi|1626698542|gb|CP032522.1| 197 g228640 i0 100 100 248 0 100 0 1 248 1164141 1163894 Campylobacter jejuni strain BC chromosome, complete genome blastn 24800 459 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
26855945 26855945 PRJNA520845_P_NODE_111301_length_353_cov_1.100000_g109802_i0 PRJNA520845 111301 353 1.1 3.883 Helicobacter pylori 210 Bacteria Bacteria 57.4 1.71e-8   NR GAA8766604.1 210 g109802 i0 65.9 0.348441926345609 41 14 34.8 0 1 123 7 47 GAA8766604.1 hypothetical protein Kyoto147A_4300 [Helicobacter pylori] diamond 123 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28245621 28245621 PRJNA520845_P_NODE_215026_length_251_cov_0.865169_g213527_i0 PRJNA520845 215026 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 41.2 0.019   NR GAA8856509.1 210 g213527 i0 47.2 0.430278884462151 36 18 41.8 1 186 82 22 57 GAA8856509.1 hypothetical protein Kyoto154A_2060 [Helicobacter pylori] diamond 108 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28624921 28624921 PRJNA520845_P_NODE_193087_length_267_cov_1.587629_g191588_i0 PRJNA520845 193087 267 1.587629 4.23896943 Arcobacter sp. 1872629 Bacteria Bacteria 58.2 1.83e-7   NR MCB9096052.1 1872629 g191588 i0 38 0.887640449438202 79 41 87.6 3 263 30 86 157 MCB9096052.1 hypothetical protein [Arcobacter sp.] diamond 237 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp.
29004034 29004034 PRJNA520845_P_NODE_132548_length_324_cov_2.039841_g131049_i0 PRJNA520845 132548 324 2.039841 6.60908484 Helicobacter pylori 210 Bacteria Bacteria 43.5 0.00344   NR GAA9125607.1 210 g131049 i0 60.6 0.305555555555556 33 13 30.6 0 103 5 16 48 GAA9125607.1 hypothetical protein Kyoto190A_0930 [Helicobacter pylori] diamond 99 43.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30092389 30092389 PRJNA520845_P_NODE_111652_length_352_cov_1.655914_g110153_i0 PRJNA520845 111652 352 1.655914 5.82881728 root 1 Root_unresolved Root_unresolved 45.8 0.0102   NR WP_129075794.1 708186 g110153 i0 30.7 4.55113636363636 101 68 85.2 2 21 320 84 183 WP_129075794.1 ankyrin repeat domain-containing protein [Aliarcobacter trophiarum] diamond 1602 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter trophiarum
30108873 30108873 PRJNA520845_P_NODE_86132_length_400_cov_1.412844_g84633_i0 PRJNA520845 86132 400 1.412844 5.651376 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0499   NR GAA8856509.1 210 g84633 i0 53.1 0.24 32 15 24 0 1 96 22 53 GAA8856509.1 hypothetical protein Kyoto154A_2060 [Helicobacter pylori] diamond 96 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31025182 31025182 PRJNA520845_P_NODE_124075_length_335_cov_1.221374_g122576_i0 PRJNA520845 124075 335 1.221374 4.0916029 Helicobacter pylori Hp A-5 992033 Bacteria Bacteria 46.6 0.00332   NR EJB41529.1 992033 g122576 i0 42.3 0.465671641791045 52 30 46.6 0 292 137 17 68 EJB41529.1 putative transposase [Helicobacter pylori Hp A-5] diamond 156 46.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31467892 31467892 PRJNA520845_P_NODE_124376_length_335_cov_0.881679_g122877_i0 PRJNA520845 124376 335 0.881679 2.95362465 Helicobacter pylori 210 Bacteria Bacteria 47 3.6e-4   NR GAA8909605.1 210 g122877 i0 42.4 0.591044776119403 66 23 48.4 2 93 254 3 65 GAA8909605.1 hypothetical protein Kyoto166A_1730 [Helicobacter pylori] diamond 198 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31562885 31562885 PRJNA520845_P_NODE_210196_length_253_cov_1.711111_g208697_i0 PRJNA520845 210196 253 1.711111 4.32911083 Helicobacter pylori 210 Bacteria Bacteria 47 7.6e-4   NR GAA9039287.1 210 g208697 i0 36.6 0.841897233201581 71 41 79.4 1 204 4 74 144 GAA9039287.1 hypothetical protein Kyoto184A_01650 [Helicobacter pylori] diamond 213 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31910658 31910658 PRJNA520845_P_NODE_62897_length_469_cov_3.626263_g61398_i0 PRJNA520845 62897 469 3.626263 17.00717347 Sulfurimonas sp. 2022749 Bacteria Bacteria 87.4 5.72e-19   NR WP_321778635.1 2022749 g61398 i0 43.9 2.49466950959488 107 55 65.2 1 3 308 10 116 WP_321778635.1 YegP family protein [Sulfurimonas sp.] diamond 1170 87.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas sp.
32005584 32005584 PRJNA520845_P_NODE_246598_length_245_cov_0.895349_g245099_i0 PRJNA520845 246598 245 0.895349 2.19360505 Hippea sp. KM1 944481 Bacteria Bacteria 64.7 4.43e-10   NR WP_025270374.1 944481 g245099 i0 45.5 4.50612244897959 77 40 91.8 1 245 21 11 87 WP_025270374.1 DnaJ C-terminal domain-containing protein [Hippea sp. KM1] diamond 1104 64.7 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales Hippeaceae Hippea Hippea sp. KM1
32763857 32763857 PRJNA520845_P_NODE_181680_length_276_cov_1.694581_g180181_i0 PRJNA520845 181680 276 1.694581 4.67704356 Arcobacter sp. CECT 8985 1935424 Bacteria Bacteria 56.6 6.7e-7   NR WP_129104433.1 1935424 g180181 i0 46.7 0.652173913043478 60 32 65.2 0 273 94 87 146 WP_129104433.1 hypothetical protein [Arcobacter sp. CECT 8985] diamond 180 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp. CECT 8985

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