RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA728642", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 11 ✖

tax_phylum 1

  • Campylobacterota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA728642 · 11 ✖

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
3746668 3746668 PRJNA728642_P_NODE_14763_length_261_cov_1.228723_g14492_i0 PRJNA728642 14763 261 1.228723 3.20696703 Pseudomonadati 3379134 Bacteria Bacteria 477 3.3099999999999986e-130   NTclustered gi|1226876681|gb|CP022559.1| 197 g14492 i0 99.617 100 261 1 100 0 1 261 701279 701019 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 26100 477 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
6298876 6298876 PRJNA728642_P_NODE_11425_length_299_cov_2.265487_g11154_i0 PRJNA728642 11425 299 2.265487 6.77380613 Aliarcobacter 2321111 Bacteria Bacteria 553 6.25e-153   NTclustered gi|564273087|gb|KF690259.1| 28197 g11154 i0 100 148.214046822742 299 0 100 0 1 299 307 9 Arcobacter butzleri strain ANDL04 16S ribosomal RNA gene, partial sequence blastn 44316 553 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
7572734 7572734 PRJNA728642_P_NODE_13546_length_273_cov_1.900000_g13275_i0 PRJNA728642 13546 273 1.9 5.187 Aliarcobacter 2321111 Bacteria Bacteria 501 2.07e-137   NTclustered gi|1231709647|emb|LT906455.1| 28197 g13275 i0 100 396.175824175824 271 0 99 0 3 273 849963 849693 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 108156 501 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
9641447 9641447 PRJNA728642_P_NODE_3368_length_569_cov_1.758065_g3099_i0 PRJNA728642 3368 569 1.758065 10.00338985 uncultured Arcobacter sp. 165434 Bacteria Bacteria 340 1.07e-88   NTclustered gi|682122801|gb|KJ739652.1| 165434 g3099 i0 90.909 65.451669595782107 253 23 44 0 317 569 6 258 Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence blastn 37242 340 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
16498137 16498137 PRJNA728642_P_NODE_8873_length_342_cov_1.026022_g8602_i0 PRJNA728642 8873 342 1.026022 3.50899524 Campylobacter 194 Bacteria Bacteria 560 4.34e-155   NTclustered gi|1935888393|gb|CP049239.1| 199 g8602 i0 96.199 249.383040935673 342 13 100 0 1 342 1034010 1034351 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 85289 560 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
17772691 17772691 PRJNA728642_P_NODE_14474_length_264_cov_1.471204_g14203_i0 PRJNA728642 14474 264 1.471204 3.88397856 root 1 Root_unresolved Root_unresolved 488 1.5499999999999999e-133   NTclustered gi|1226876681|gb|CP022559.1| 197 g14203 i0 100 101 264 0 100 0 1 264 698755 699018 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 26664 488 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
17772723 17772723 PRJNA728642_P_NODE_16454_length_249_cov_1.329545_g16183_i0 PRJNA728642 16454 249 1.329545 3.31056705 Arcobacteraceae 2808963 Bacteria Bacteria 449 6.840000000000001e-122   NTclustered gi|1231709647|emb|LT906455.1| 28197 g16183 i0 99.2 369.369477911647 250 1 100 1 1 249 850883 851132 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 91973 449 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
20321593 20321593 PRJNA728642_P_NODE_6256_length_410_cov_2.255193_g5985_i0 PRJNA728642 6256 410 2.255193 9.2462913 root 1 Root_unresolved Root_unresolved 752 0   NTclustered gi|1226876681|gb|CP022559.1| 197 g5985 i0 99.756 100 410 1 100 0 1 410 698010 698419 Campylobacter jejuni strain 11168H/araE chromosome, complete genome blastn 41000 752 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
24146504 24146504 PRJNA728642_P_NODE_18199_length_244_cov_2.520468_g17928_i0 PRJNA728642 18199 244 2.520468 6.14994192 Aliarcobacter 2321111 Bacteria Bacteria 451 1.86e-122   NTclustered gi|1231709647|emb|LT906455.1| 28197 g17928 i0 100 373.118852459016 244 0 100 0 1 244 851873 851630 Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1 blastn 91041 451 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
25421491 25421491 PRJNA728642_P_NODE_14720_length_261_cov_1.936170_g14449_i0 PRJNA728642 14720 261 1.93617 5.0534037 Campylobacter 194 Bacteria Bacteria 483 7.12e-132   NTclustered gi|1207769201|gb|MF351714.1| 199 g14449 i0 100 241.298850574713 261 0 100 0 1 261 1271 1011 Campylobacter concisus strain H3O1 23S ribosomal RNA gene, partial sequence blastn 62979 483 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
32012166 32012166 PRJNA728642_P_NODE_19178_length_242_cov_0.911243_g18907_i0 PRJNA728642 19178 242 0.911243 2.20520806 Aliarcobacter butzleri 28197 Bacteria Bacteria 40.8 0.0407   NR WP_152057716.1 28197 g18907 i0 35 0.743801652892562 60 36 74.4 1 12 191 11 67 WP_152057716.1 50S ribosomal protein L5, partial [Aliarcobacter butzleri] diamond 180 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri

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