RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA675042", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 16 ✖

tax_phylum 1

  • Campylobacterota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675042 · 16 ✖

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
646582 646582 PRJNA675042_P_NODE_19361_length_416_cov_1.122449_g18911_i0 PRJNA675042 19361 416 1.122449 4.66938784 Aliarcobacter cibarius 255507 Bacteria Bacteria 65.8 5.14e-6   NTclustered gi|1755823616|gb|CP043857.1| 255507 g18911 i0 100 0.235576923076923 35 0 8 0 367 401 756992 757026 Aliarcobacter cibarius strain H743 chromosome, complete genome blastn 98 65.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cibarius
646649 646649 PRJNA675042_P_NODE_2361_length_869_cov_5.459799_g1996_i0 PRJNA675042 2361 869 5.459799 47.44565331 Campylobacter jejuni 197 Bacteria Bacteria 132 1.48e-35   NR MBP0443134.1 197 g1996 i0 100 0.238204833141542 69 0 23.8 0 614 408 1 69 MBP0443134.1 hypothetical protein [Campylobacter jejuni] diamond 207 132 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
5749635 5749635 PRJNA675042_P_NODE_133025_length_247_cov_1.327586_g132575_i0 PRJNA675042 133025 247 1.327586 3.27913742 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 52.8 0.022   NTclustered gi|2581873871|gb|CP134842.1| 2933791 g132575 i0 100 0.340080971659919 28 0 11 0 122 149 1321056 1321029 Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 65 chromosome, complete genome blastn 84 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
7025799 7025799 PRJNA675042_P_NODE_55486_length_315_cov_1.057851_g55036_i0 PRJNA675042 55486 315 1.057851 3.33223065 Helicobacter winghamensis 157268 Bacteria Bacteria 52.8 0.029   NTclustered gi|2446993225|gb|CP063531.1| 157268 g55036 i0 100 0.266666666666667 28 0 9 0 115 142 1010341 1010368 Helicobacter winghamensis strain ATCC BAA-435 chromosome, complete genome blastn 84 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter winghamensis
10850549 10850549 PRJNA675042_P_NODE_173849_length_242_cov_0.911243_g173399_i0 PRJNA675042 173849 242 0.911243 2.20520806 Helicobacter pylori 210 Bacteria Bacteria 56.5 0.002   NTclustered gi|2641914139|gb|CP078365.1| 210 g173399 i0 100 0.12396694214876 30 0 12 0 207 236 762064 762035 Helicobacter pylori strain HpGP-SGP-024 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
13401035 13401035 PRJNA675042_P_NODE_42711_length_338_cov_1.116981_g42261_i0 PRJNA675042 42711 338 1.116981 3.77539578 Campylobacter concisus 199 Bacteria Bacteria 52.8 0.032   NTclustered gi|1938715890|gb|CP049263.1| 199 g42261 i0 100 0.165680473372781 28 0 8 0 51 78 407441 407468 Campylobacter concisus strain H16O-S1 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
14675332 14675332 PRJNA675042_P_NODE_14732_length_447_cov_0.938503_g14282_i0 PRJNA675042 14732 447 0.938503 4.19510841 Helicobacter typhlonius 76936 Bacteria Bacteria 54.7 0.012   NTclustered gi|953940668|emb|LN907858.1| 76936 g14282 i0 100 0.0648769574944072 29 0 6 0 191 219 1539632 1539604 Helicobacter typhlonius genome assembly htyphlonius_mit97-6810, chromosome : I blastn 29 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter typhlonius
16471089 16471089 PRJNA675042_P_NODE_60873_length_306_cov_1.682403_g60423_i0 PRJNA675042 60873 306 1.682403 5.14815318 Campylobacter 194 Bacteria Bacteria 54.7 0.008   NTclustered gi|744815412|gb|CP007774.1| 580033 g60423 i0 100 0.284313725490196 29 0 9 0 223 251 1226183 1226155 Campylobacter volucris LMG 24379 chromosome, complete genome blastn 87 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter volucris
18499272 18499272 PRJNA675042_P_NODE_41455_length_341_cov_0.858209_g41005_i0 PRJNA675042 41455 341 0.858209 2.92649269 Campylobacter jejuni 197 Bacteria Bacteria 54.7 0.009   NTclustered gi|1752751014|gb|CP044167.1| 197 g41005 i0 96.875 0.093841642228739 32 1 9 0 54 85 879080 879111 Campylobacter jejuni strain AR-0415 chromosome, complete genome blastn 32 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
21048735 21048735 PRJNA675042_P_NODE_142477_length_246_cov_0.890173_g142027_i0 PRJNA675042 142477 246 0.890173 2.18982558 uncultured Aliarcobacter sp. 2321118 Bacteria Bacteria 52.8 0.022   NTclustered gi|2621785459|emb|OY781917.1| 2321118 g142027 i0 84.906 0.329268292682927 53 6 21 2 188 239 925010 924959 MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2 blastn 81 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter uncultured Aliarcobacter sp.
22323223 22323223 PRJNA675042_P_NODE_114178_length_250_cov_0.870056_g113728_i0 PRJNA675042 114178 250 0.870056 2.17514 Campylobacter subantarcticus 497724 Bacteria Bacteria 54.7 0.006   NTclustered gi|744813640|gb|CP007773.1| 1388752 g113728 i0 100 0.116 29 0 12 0 67 95 1807487 1807515 Campylobacter subantarcticus LMG 24377 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter subantarcticus
23599929 23599929 PRJNA675042_P_NODE_52979_length_319_cov_1.105691_g52529_i0 PRJNA675042 52979 319 1.105691 3.52715429 Nitrosophilus kaiyonis 2930200 Bacteria Bacteria 52.8 0.03   NTclustered gi|2329051130|dbj|AP025696.1| 2930200 g52529 i0 94.286 0.109717868338558 35 1 11 1 259 293 408450 408483 Nitrosophilus sp. MOT50 DNA, complete genome blastn 35 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Nautiliales Nitratiruptoraceae Nitrosophilus Nitrosophilus kaiyonis
24873056 24873056 PRJNA675042_P_NODE_35660_length_355_cov_1.035461_g35210_i0 PRJNA675042 35660 355 1.035461 3.67588655 Campylobacter jejuni 197 Bacteria Bacteria 56.5 0.003   NTclustered gi|1540282258|emb|LR134530.1| 32021 g35210 i0 94.595 0.104225352112676 37 1 10 1 142 177 159889 159925 Campylobacter jejuni subsp. doylei strain NCTC11924 genome assembly, chromosome: 1 blastn 37 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
24873681 24873681 PRJNA675042_P_NODE_86420_length_273_cov_1.270000_g85970_i0 PRJNA675042 86420 273 1.27 3.4671 Halarcobacter sp. 2321133 Bacteria Bacteria 52.8 0.025   NTclustered gi|2621784481|emb|OY780939.1| 2321133 g85970 i0 100 0.102564102564103 28 0 10 0 223 250 2592612 2592639 MAG: Halarcobacter sp. isolate c23ce619-377f-483f-a597-00588adfbfa9 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter sp.
29797425 29797425 PRJNA675042_P_NODE_172011_length_242_cov_0.911243_g171561_i0 PRJNA675042 172011 242 0.911243 2.20520806 Campylobacterota bacterium 2026809 Bacteria Bacteria 44.3 0.0105   NR MEA1918603.1 2026809 g171561 i0 54.8 0.520661157024793 42 16 50.8 2 25 147 210 249 MEA1918603.1 sensor histidine kinase [Campylobacterota bacterium] diamond 126 44.3 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
32116992 32116992 PRJNA675042_P_NODE_161378_length_243_cov_0.905882_g160928_i0 PRJNA675042 161378 243 0.905882 2.20129326 Pseudomonadati 3379134 Bacteria Bacteria 164 6.56e-51   NR WP_209379118.1 197 g160928 i0 100 2.96296296296296 80 0 98.8 0 241 2 10 89 WP_209379118.1 hypothetical protein, partial [Campylobacter jejuni] diamond 720 164 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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