RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA520845 · 12 ✖

analysis 1

  • diamond · 12 ✖

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