RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB81327", 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 · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJEB81327 · 18 ✖

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
140018 140018 PRJEB81327_P_NODE_5101_length_644_cov_7.607706_g4525_i0 PRJEB81327 5101 644 7.607706 48.99362664 Campylobacter gracilis 824 Bacteria Bacteria 1147 0   NTclustered gi|909717139|gb|CP012196.1| 824 g4525 i0 99.369 262.83850931677 634 3 98 1 12 644 500438 501071 Campylobacter gracilis strain ATCC 33236, complete genome blastn 169268 1147 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis
5242588 5242588 PRJEB81327_P_NODE_49925_length_249_cov_0.875000_g49317_i0 PRJEB81327 49925 249 0.875 2.17875 uncultured Arcobacter sp. 165434 Bacteria Bacteria 237 5.8e-58   NTclustered gi|682122801|gb|KJ739652.1| 165434 g49317 i0 87.745 286.710843373494 204 23 82 2 47 249 3 205 Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence blastn 71391 237 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
6100391 6100391 PRJEB81327_P_NODE_67805_length_230_cov_2.624204_g67197_i0 PRJEB81327 67805 230 2.624204 6.0356692 Bacteria 2 Bacteria Bacteria 425 1.05e-114   NTclustered gi|2323232558|gb|CP109813.1| 195 g67197 i0 100 101 230 0 100 0 1 230 552714 552485 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 23230 425 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
9924829 9924829 PRJEB81327_P_NODE_17528_length_323_cov_0.924000_g16920_i0 PRJEB81327 17528 323 0.924 2.98452 root 1 Root_unresolved Root_unresolved 597 3.11e-166   NTclustered gi|1226876681|gb|CP022559.1| 197 g16920 i0 100 100 323 0 100 0 1 323 698630 698952 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 32300 597 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
11200178 11200178 PRJEB81327_P_NODE_27829_length_282_cov_1.669856_g27221_i0 PRJEB81327 27829 282 1.669856 4.70899392 Bacteria 2 Bacteria Bacteria 521 1.6499999999999996e-143   NTclustered gi|2323232558|gb|CP109813.1| 195 g27221 i0 100 100 282 0 100 0 1 282 557055 557336 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 28200 521 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
11618525 11618525 PRJEB81327_P_NODE_48730_length_250_cov_0.870056_g48122_i0 PRJEB81327 48730 250 0.870056 2.17514 Campylobacter rectus 203 Bacteria Bacteria 335 2.0099999999999996e-87   NTclustered gi|1622745323|gb|CP012543.1| 203 g48122 i0 90.8 2 250 23 100 0 1 250 2284586 2284835 Campylobacter rectus strain ATCC 33238, complete genome blastn 500 335 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
12893292 12893292 PRJEB81327_P_NODE_33571_length_272_cov_1.386935_g32963_i0 PRJEB81327 33571 272 1.386935 3.7724632 Campylobacter concisus 199 Bacteria Bacteria 420 5.94e-113   NTclustered gi|1938721720|gb|CP049266.1| 199 g32963 i0 94.485 13.5661764705882 272 15 100 0 1 272 490482 490211 Campylobacter concisus strain P1CDO3 chromosome, complete genome blastn 3690 420 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
13750399 13750399 PRJEB81327_P_NODE_34371_length_270_cov_3.121827_g33763_i0 PRJEB81327 34371 270 3.121827 8.4289329 Bacteria 2 Bacteria Bacteria 86.1 2.44e-12   NTclustered gi|2922103276|gb|CP182878.1| 1355374 g33763 i0 96.154 4.26666666666667 52 2 19 0 8 59 591556 591505 Aliarcobacter lanthieri strain BNI-3132 chromosome, complete genome blastn 1152 86.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter lanthieri
16716542 16716542 PRJEB81327_P_NODE_36054_length_268_cov_1.358974_g35446_i0 PRJEB81327 36054 268 1.358974 3.64205032 Campylobacter showae 204 Bacteria Bacteria 383 7.66e-102   NTclustered gi|1622747600|gb|CP012544.1| 204 g35446 i0 95.062 3.72014925373134 243 12 91 0 1 243 270368 270126 Campylobacter showae strain ATCC 51146 chromosome, complete genome blastn 997 383 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
17991436 17991436 PRJEB81327_P_NODE_39875_length_261_cov_2.234043_g39267_i0 PRJEB81327 39875 261 2.234043 5.83085223 Campylobacter rectus 203 Bacteria Bacteria 477 3.3099999999999986e-130   NTclustered gi|1622745323|gb|CP012543.1| 203 g39267 i0 99.617 236.061302681992 261 1 100 0 1 261 159629 159889 Campylobacter rectus strain ATCC 33238, complete genome blastn 61612 477 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
20540716 20540716 PRJEB81327_P_NODE_30857_length_277_cov_1.093137_g30249_i0 PRJEB81327 30857 277 1.093137 3.02798949 Nitratiruptor sp. YY09-18 2724901 Bacteria Bacteria 169 2.4299999999999997e-37   NTclustered gi|1941658040|dbj|AP023065.1| 2724901 g30249 i0 82.028 136.259927797834 217 22 79 13 62 274 384308 384105 Nitratiruptor sp. YY09-18 DNA, complete genome blastn 37744 169 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Nautiliales Nitratiruptoraceae Nitratiruptor Nitratiruptor sp. YY09-18
25223324 25223324 PRJEB81327_P_NODE_62220_length_242_cov_2.118343_g61612_i0 PRJEB81327 62220 242 2.118343 5.12639006 Campylobacter 194 Bacteria Bacteria 442 1.1099999999999995e-119   NTclustered gi|1622745323|gb|CP012543.1| 203 g61612 i0 99.587 233.136363636364 242 1 100 0 1 242 160087 159846 Campylobacter rectus strain ATCC 33238, complete genome blastn 56419 442 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
27634693 27634693 PRJEB81327_P_NODE_9124_length_457_cov_1.854167_g8516_i0 PRJEB81327 9124 457 1.854167 8.47354319 Desulfurellales bacterium 2482794 Bacteria Bacteria 76.3 7.32e-13   NR TXH41244.1 2482794 g8516 i0 44.8 0.571115973741794 87 48 57.1 0 1 261 328 414 TXH41244.1 MAG: hypothetical protein E6Q97_38065 [Desulfurellales bacterium] diamond 261 76.3 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28108006 28108006 PRJEB81327_P_NODE_35565_length_268_cov_4.302564_g34957_i0 PRJEB81327 35565 268 4.302564 11.53087152 Helicobacter pylori 210 Bacteria Bacteria 48.9 2.67e-5   NR GAA9038100.1 210 g34957 i0 74.1 0.582089552238806 27 7 30.2 0 88 168 1 27 GAA9038100.1 hypothetical protein Kyoto184A_01000 [Helicobacter pylori] diamond 156 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28108010 28108010 PRJEB81327_P_NODE_44165_length_254_cov_1.696133_g43557_i0 PRJEB81327 44165 254 1.696133 4.30817782 Campylobacterota bacterium 2026809 Bacteria Bacteria 91.7 2.41e-19   NR NPA10987.1 2026809 g43557 i0 64.2 3.30708661417323 67 24 79.1 0 2 202 442 508 NPA10987.1 phosphoenolpyruvate carboxykinase (ATP) [Campylobacterota bacterium] diamond 840 91.7 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28479816 28479816 PRJEB81327_P_NODE_22626_length_293_cov_2.586364_g22018_i0 PRJEB81327 22626 293 2.586364 7.57804652 Pseudomonadati 3379134 Bacteria Bacteria 112 3.9699999999999995e-30   NR WP_306199871.1 197 g22018 i0 100 1.02389078498294 50 0 51.2 0 1 150 5 54 WP_306199871.1 hypothetical protein, partial [Campylobacter jejuni] diamond 300 112 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
30413704 30413704 PRJEB81327_P_NODE_58653_length_244_cov_1.789474_g58045_i0 PRJEB81327 58653 244 1.789474 4.36631656 Helicobacter pylori 210 Bacteria Bacteria 57 7.53e-9   NR GAA9176259.1 210 g58045 i0 44 1.74590163934426 75 16 92.2 2 6 230 1 49 GAA9176259.1 hypothetical protein Kyoto193A_0410 [Helicobacter pylori] diamond 426 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31607198 31607198 PRJEB81327_P_NODE_16956_length_328_cov_1.207843_g16348_i0 PRJEB81327 16956 328 1.207843 3.96172504 root 1 Root_unresolved Root_unresolved 109 7.37e-26   NR WP_034556802.1 216 g16348 i0 55.7 5.85365853658537 106 47 97 0 8 325 234 339 WP_034556802.1 trans-sulfuration enzyme family protein [Helicobacter muridarum] diamond 1920 110 0.990909090909091 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter muridarum

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