RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA900028 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
23827037 23827037 PRJNA900028_P_NODE_15819_length_294_cov_1.355102_g15070_i0 PRJNA900028 15819 294 1.355102 3.98399988 Bacteria 2 Bacteria Bacteria 134 8.819999999999999e-37   NR WP_285658688.1 56877 g15070 i0 80.9 5.44897959183673 89 17 90.8 0 269 3 47 135 WP_285658688.1 sensor histidine kinase, partial [Helicobacter bizzozeronii] diamond 1602 134 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter bizzozeronii
26683480 26683480 PRJNA900028_P_NODE_6481_length_423_cov_1.620321_g5736_i0 PRJNA900028 6481 423 1.620321 6.85395783 Bacteria 2 Bacteria Bacteria 229 1.88e-74   NR PUB99708.1 210 g5736 i0 100 2.31914893617021 109 0 77.3 0 329 3 7 115 PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori] diamond 981 229 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26960691 26960691 PRJNA900028_P_NODE_171562_length_163_cov_0.894737_g170813_i0 PRJNA900028 171562 163 0.894737 1.45842131 Helicobacter pylori 210 Bacteria Bacteria 68.2 1.91e-13   NR GAA9184244.1 210 g170813 i0 96.6 0.533742331288344 29 1 53.4 0 42 128 4 32 GAA9184244.1 hypothetical protein Kyoto193A_2890 [Helicobacter pylori] diamond 87 68.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27087476 27087476 PRJNA900028_P_NODE_184882_length_162_cov_0.902655_g184133_i0 PRJNA900028 184882 162 0.902655 1.4623011 Helicobacter pylori 210 Bacteria Bacteria 47.8 1.11e-5   NR GAA8933524.1 210 g184133 i0 64.7 0.62962962962963 34 12 63 0 5 106 13 46 GAA8933524.1 hypothetical protein Kyoto166A_4440 [Helicobacter pylori] diamond 102 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27095015 27095015 PRJNA900028_P_NODE_166142_length_163_cov_0.894737_g165393_i0 PRJNA900028 166142 163 0.894737 1.45842131 Pseudomonadati 3379134 Bacteria Bacteria 99 9.27e-23   NR WP_298957208.1 218934 g165393 i0 90.7 1.98773006134969 54 5 99.4 0 163 2 151 204 WP_298957208.1 ABC transporter permease [uncultured Campylobacter sp.] diamond 324 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
27182030 27182030 PRJNA900028_P_NODE_186522_length_161_cov_2.723214_g185773_i0 PRJNA900028 186522 161 2.723214 4.38437454 Helicobacter pylori 210 Bacteria Bacteria 39.7 0.018   NR GAA9176525.1 210 g185773 i0 73.9 0.428571428571429 23 6 42.9 0 110 42 1 23 GAA9176525.1 hypothetical protein Kyoto193A_0810 [Helicobacter pylori] diamond 69 39.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27372184 27372184 PRJNA900028_P_NODE_177043_length_162_cov_1.150442_g176294_i0 PRJNA900028 177043 162 1.150442 1.86371604 Helicobacter pylori 210 Bacteria Bacteria 59.7 2.11e-10   NR GAA8950290.1 210 g176294 i0 92.6 0.5 27 2 50 0 142 62 1 27 GAA8950290.1 hypothetical protein Kyoto181A_1480 [Helicobacter pylori] diamond 81 59.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28635084 28635084 PRJNA900028_P_NODE_163607_length_164_cov_0.878261_g162858_i0 PRJNA900028 163607 164 0.878261 1.44034804 Campylobacter sp. 2 205 Bacteria Bacteria 67.4 2.29e-12   NR WP_214120692.1 2836735 g162858 i0 84.6 0.713414634146341 39 6 71.3 0 48 164 59 97 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 117 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01
28729617 28729617 PRJNA900028_P_NODE_61507_length_195_cov_2.767123_g60758_i0 PRJNA900028 61507 195 2.7671230000000002 5.39588985 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0224   NR GAA6912157.1 210 g60758 i0 98.2 0.876923076923077 57 1 87.7 0 193 23 3 59 GAA6912157.1 hypothetical protein Kyoto207A_2960 [Helicobacter pylori] diamond 171 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29266146 29266146 PRJNA900028_P_NODE_90689_length_180_cov_1.511450_g89940_i0 PRJNA900028 90689 180 1.51145 2.72061 Campylobacter concisus 199 Bacteria Bacteria 110 1.7600000000000003e-27   NR WP_103617747.1 199 g89940 i0 89.5 2.85 57 6 95 0 3 173 240 296 WP_103617747.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Campylobacter concisus] diamond 513 110 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
29652484 29652484 PRJNA900028_P_NODE_180090_length_162_cov_0.902655_g179341_i0 PRJNA900028 180090 162 0.902655 1.4623011 root 1 Root_unresolved Root_unresolved 53.9 2.26e-7   NR WP_240382657.1 197 g179341 i0 56.5 1.7037037037037 46 20 85.2 0 22 159 29 74 WP_240382657.1 hypothetical protein, partial [Campylobacter jejuni] diamond 276 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
29897920 29897920 PRJNA900028_P_NODE_144991_length_165_cov_0.879310_g144242_i0 PRJNA900028 144991 165 0.87931 1.4508615 uncultured Campylobacter sp. 218934 Bacteria Bacteria 90.5 9.57e-20   NR WP_299190647.1 218934 g144242 i0 94 0.909090909090909 50 3 90.9 0 152 3 1 50 WP_299190647.1 hypothetical protein [uncultured Campylobacter sp.] diamond 150 90.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
30474307 30474307 PRJNA900028_P_NODE_109453_length_171_cov_1.672131_g108704_i0 PRJNA900028 109453 171 1.672131 2.85934401 Campylobacter 194 Bacteria Bacteria 112 4.1800000000000005e-27   NR WP_306528832.1 205 g108704 i0 92.9 1.96491228070175 56 4 98.2 0 3 170 368 423 WP_306528832.1 lytic transglycosylase domain-containing protein [Campylobacter sp.] diamond 336 112 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.
30498145 30498145 PRJNA900028_P_NODE_147593_length_165_cov_0.879310_g146844_i0 PRJNA900028 147593 165 0.87931 1.4508615 Campylobacter jejuni 197 Bacteria Bacteria 61.2 1.47e-10   NR WP_332068430.1 197 g146844 i0 57.4 1.96363636363636 54 23 98.2 0 3 164 19 72 WP_332068430.1 retropepsin-like aspartic protease, partial [Campylobacter jejuni] diamond 324 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30758565 30758565 PRJNA900028_P_NODE_149334_length_165_cov_0.879310_g148585_i0 PRJNA900028 149334 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 82 8.97e-19   NR WP_332068430.1 197 g148585 i0 64.8 3.87272727272727 54 19 98.2 0 2 163 5 58 WP_332068430.1 retropepsin-like aspartic protease, partial [Campylobacter jejuni] diamond 639 82.4 0.995145631067961 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30940637 30940637 PRJNA900028_P_NODE_192494_length_161_cov_0.910714_g191745_i0 PRJNA900028 192494 161 0.910714 1.46624954 uncultured Campylobacter sp. 218934 Bacteria Bacteria 102 3.58e-26   NR WP_297996631.1 218934 g191745 i0 94.3 1.97515527950311 53 3 98.8 0 160 2 80 132 WP_297996631.1 macro domain-containing protein, partial [uncultured Campylobacter sp.] diamond 318 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
31035515 31035515 PRJNA900028_P_NODE_103315_length_174_cov_1.624000_g102566_i0 PRJNA900028 103315 174 1.624 2.82576 uncultured Campylobacter sp. 218934 Bacteria Bacteria 113 4.54e-30   NR WP_297880367.1 218934 g102566 i0 94.7 1.96551724137931 57 3 98.3 0 172 2 55 111 WP_297880367.1 type II secretion system protein, partial [uncultured Campylobacter sp.] diamond 342 113 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
31043240 31043240 PRJNA900028_P_NODE_26595_length_248_cov_1.547739_g25846_i0 PRJNA900028 26595 248 1.547739 3.83839272 Epsilonproteobacteria 3031852 Bacteria Bacteria 94.4 2.04e-20   NR MDO9305623.1 2025608 g25846 i0 64.1 10.3911290322581 64 23 77.4 0 204 13 133 196 MDO9305623.1 response regulator [Sulfuricurvum sp.] diamond 2577 94.7 0.996832101372756 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfuricurvum Sulfuricurvum sp.
31200435 31200435 PRJNA900028_P_NODE_93755_length_179_cov_0.984615_g93006_i0 PRJNA900028 93755 179 0.984615 1.76246085 root 1 Root_unresolved Root_unresolved 54.3 2.97e-7   NR GAA8684133.1 210 g93006 i0 86.2 4.29050279329609 29 4 48.6 0 102 16 8 36 GAA8684133.1 hypothetical protein Kyoto145A_0980 [Helicobacter pylori] diamond 768 54.7 0.992687385740402 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31699331 31699331 PRJNA900028_P_NODE_199497_length_151_cov_2.980392_g198748_i0 PRJNA900028 199497 151 2.980392 4.50039192 Helicobacter pylori 210 Bacteria Bacteria 42.7 0.00276   NR GAA9129177.1 210 g198748 i0 77.3 1.74834437086093 22 5 43.7 0 3 68 41 62 GAA9129177.1 hypothetical protein Kyoto190A_1890 [Helicobacter pylori] diamond 264 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31825635 31825635 PRJNA900028_P_NODE_166277_length_163_cov_0.894737_g165528_i0 PRJNA900028 166277 163 0.894737 1.45842131 Campylobacter rectus 203 Bacteria Bacteria 107 4.47e-26   NR WP_314701695.1 203 g165528 i0 100 0.975460122699387 53 0 97.5 0 3 161 131 183 WP_314701695.1 RAMP superfamily CRISPR-associated protein [Campylobacter rectus] diamond 159 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
32742655 32742655 PRJNA900028_P_NODE_23340_length_259_cov_0.838095_g22591_i0 PRJNA900028 23340 259 0.838095 2.17066605 Helicobacter pylori 210 Bacteria Bacteria 70.1 1.11e-13   NR GAA9176533.1 210 g22591 i0 66.7 1.06563706563707 48 16 55.6 0 1 144 8 55 GAA9176533.1 hypothetical protein Kyoto193A_0850 [Helicobacter pylori] diamond 276 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32773920 32773920 PRJNA900028_P_NODE_61620_length_195_cov_1.746575_g60871_i0 PRJNA900028 61620 195 1.746575 3.40582125 Campylobacter ureolyticus 827 Bacteria Bacteria 77.8 1.48e-15   NR WP_016646089.1 827 g60871 i0 100 0.569230769230769 37 0 56.9 0 1 111 191 227 WP_016646089.1 molecular chaperone TorD family protein [Campylobacter ureolyticus] diamond 111 77.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus

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