RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA681822" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA681822 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
27271670 27271670 PRJNA681822_P_NODE_47643_length_540_cov_1.781585_g46187_i0 PRJNA681822 47643 540 1.781585 9.620559 Helicobacter pylori 210 Bacteria Bacteria 216 9.87e-70   NR GAA7771988.1 210 g46187 i0 100 0.572222222222222 103 0 57.2 0 538 230 3 105 GAA7771988.1 hypothetical protein HpMS107_60470 [Helicobacter pylori] diamond 309 216 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28408507 28408507 PRJNA681822_P_NODE_459086_length_243_cov_1.382353_g457596_i0 PRJNA681822 459086 243 1.382353 3.35911779 Campylobacter concisus 199 Bacteria Bacteria 147 3.52e-39   NR WP_103569199.1 199 g457596 i0 92.3 0.962962962962963 78 6 96.3 0 8 241 402 479 WP_103569199.1 asparagine synthase (glutamine-hydrolyzing) [Campylobacter concisus] diamond 234 147 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
28503167 28503167 PRJNA681822_P_NODE_246427_length_287_cov_1.626168_g244938_i0 PRJNA681822 246427 287 1.626168 4.66710216 Helicobacter pylori 210 Bacteria Bacteria 52.4 8.77e-7   NR GAA9130373.1 210 g244938 i0 50 0.815331010452962 52 9 54.4 1 170 15 4 38 GAA9130373.1 hypothetical protein Kyoto190A_1990 [Helicobacter pylori] diamond 234 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28661112 28661112 PRJNA681822_P_NODE_283227_length_278_cov_1.853659_g281738_i0 PRJNA681822 283227 278 1.853659 5.15317202 Helicobacter pylori 210 Bacteria Bacteria 52 1.78e-6   NR GAA6953496.1 210 g281738 i0 67.7 1.76978417266187 62 20 66.9 0 219 34 11 72 GAA6953496.1 hypothetical protein Kyoto211A_0670 [Helicobacter pylori] diamond 492 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28850266 28850266 PRJNA681822_P_NODE_209088_length_303_cov_1.252174_g207600_i0 PRJNA681822 209088 303 1.252174 3.79408722 Helicobacter pylori 210 Bacteria Bacteria 54.7 2.1e-7   NR GAA9209002.1 210 g207600 i0 68.8 0.316831683168317 32 10 31.7 0 213 118 6 37 GAA9209002.1 hypothetical protein Kyoto198A_1420 [Helicobacter pylori] diamond 96 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29987253 29987253 PRJNA681822_P_NODE_328331_length_266_cov_2.347150_g326842_i0 PRJNA681822 328331 266 2.34715 6.243419 Helicobacter pylori 210 Bacteria Bacteria 61.6 1.51e-10   NR GAA9176259.1 210 g326842 i0 57.4 1.06015037593985 47 20 53 0 165 25 4 50 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 282 61.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30019013 30019013 PRJNA681822_P_NODE_480971_length_241_cov_0.916667_g479481_i0 PRJNA681822 480971 241 0.916667 2.20916747 Helicobacter pylori 210 Bacteria Bacteria 40 0.0478   NR GAA8957928.1 210 g479481 i0 59.3 0.336099585062241 27 11 33.6 0 81 1 20 46 GAA8957928.1 hypothetical protein Kyoto181A_3320 [Helicobacter pylori] diamond 81 40 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30398419 30398419 PRJNA681822_P_NODE_111113_length_378_cov_1.009836_g109627_i0 PRJNA681822 111113 378 1.009836 3.81718008 Campylobacter coli 195 Bacteria Bacteria 45.8 0.0125   NR WP_342248546.1 195 g109627 i0 27.9 0.53968253968254 68 47 52.4 1 275 78 257 324 WP_342248546.1 hypothetical protein, partial [Campylobacter coli] diamond 204 45.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
30492804 30492804 PRJNA681822_P_NODE_328633_length_266_cov_2.041451_g327144_i0 PRJNA681822 328633 266 2.041451 5.43025966 Helicobacter pylori 210 Bacteria Bacteria 63.2 1.26e-10   NR GAA8799372.1 210 g327144 i0 60.9 0.981203007518797 87 31 94.7 3 253 2 6 92 GAA8799372.1 hypothetical protein Kyoto149A_1730 [Helicobacter pylori] diamond 261 63.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31167674 31167674 PRJNA681822_P_NODE_334335_length_265_cov_1.276042_g332846_i0 PRJNA681822 334335 265 1.276042 3.3815113 Pseudomonadati 3379134 Bacteria Bacteria 64.3 1.04e-11   NR GAA8757316.1 210 g332846 i0 86.7 1.69811320754717 30 4 34 0 259 170 1 30 GAA8757316.1 hypothetical protein Kyoto147A_3750 [Helicobacter pylori] diamond 450 64.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31516148 31516148 PRJNA681822_P_NODE_412756_length_248_cov_0.880000_g411267_i0 PRJNA681822 412756 248 0.88 2.1824 Pseudomonadati 3379134 Bacteria Bacteria 52.8 8.16e-7   NR WP_390595206.1 210 g411267 i0 45.3 1.46370967741935 53 29 64.1 0 245 87 25 77 WP_390595206.1 tetratricopeptide repeat protein [Helicobacter pylori] diamond 363 53.1 0.994350282485876 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31567641 31567641 PRJNA681822_P_NODE_426296_length_247_cov_0.885057_g424807_i0 PRJNA681822 426296 247 0.885057 2.18609079 Helicobacter pylori 210 Bacteria Bacteria 59.7 1.5e-9   NR GAA8948737.1 210 g424807 i0 42.1 4.66396761133603 76 18 91.1 2 234 10 6 56 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 1152 59.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32358581 32358581 PRJNA681822_P_NODE_365939_length_256_cov_1.262295_g364450_i0 PRJNA681822 365939 256 1.262295 3.2314752 Helicobacter pylori 210 Bacteria Bacteria 98.6 8.059999999999999e-23   NR GAA7771998.1 210 g364450 i0 81.5 0.76171875 65 10 73.8 1 191 3 1 65 GAA7771998.1 hypothetical protein HpMS107_60550 [Helicobacter pylori] diamond 195 98.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32863053 32863053 PRJNA681822_P_NODE_162580_length_332_cov_1.745174_g161092_i0 PRJNA681822 162580 332 1.745174 5.79397768 Helicobacter pylori 210 Bacteria Bacteria 228 8.93e-75   NR GAA7771007.1 210 g161092 i0 100 0.993975903614458 110 0 99.4 0 2 331 10 119 GAA7771007.1 hypothetical protein HpMS107_56900 [Helicobacter pylori] diamond 330 228 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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