RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 10 ✖

bioproject 1

  • PRJNA474426 · 10 ✖

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
1096952 1096952 PRJNA474426_P_NODE_32661_length_167_cov_1.186441_g32456_i0 PRJNA474426 32661 167 1.186441 1.98135647 Aliarcobacter 2321111 Bacteria Bacteria 283 4.56e-72   NTclustered gi|1817415496|gb|CP026656.1| 28198 g32456 i0 100 355.646706586826 153 0 92 0 2 154 56985 56833 Aliarcobacter cryaerophilus strain M830MA chromosome, complete genome blastn 59393 283 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
13201163 13201163 PRJNA474426_P_NODE_32711_length_167_cov_0.881356_g32506_i0 PRJNA474426 32711 167 0.881356 1.47186452 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 167 4.79e-37   NTclustered gi|2317587505|gb|CP099556.1| 28198 g32506 i0 97.917 32.6167664670659 96 2 92 0 59 154 163445 163350 Aliarcobacter cryaerophilus strain ICDCAC48 chromosome, complete genome blastn 5447 167 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
13850585 13850585 PRJNA474426_P_NODE_33251_length_166_cov_1.487179_g33046_i0 PRJNA474426 33251 166 1.487179 2.46871714 Aliarcobacter 2321111 Bacteria Bacteria 246 5.94e-61   NTclustered gi|1896712910|gb|CP060264.1| 28198 g33046 i0 99.265 60.8614457831325 136 1 82 0 29 164 507587 507452 Aliarcobacter cryaerophilus strain 16CS0369-1-AR-4 chromosome, complete genome blastn 10103 246 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
17674607 17674607 PRJNA474426_P_NODE_37054_length_159_cov_3.481818_g36849_i0 PRJNA474426 37054 159 3.481818 5.53609062 Arcobacteraceae 2808963 Bacteria Bacteria 272 9.28e-69   NTclustered gi|1474790806|gb|CP032100.1| 663365 g36849 i0 99.333 357.440251572327 150 1 94 0 10 159 1733885 1733736 Arcobacter suis CECT 7833 chromosome, complete genome blastn 56833 272 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis
24673655 24673655 PRJNA474426_P_NODE_35640_length_163_cov_0.912281_g35435_i0 PRJNA474426 35640 163 0.912281 1.48701803 Campylobacter jejuni 197 Bacteria Bacteria 89.7 3.5e-21   NR WP_257056761.1 197 g35435 i0 95.7 0.865030674846626 47 2 86.5 0 3 143 11 57 WP_257056761.1 PT domain-containing protein, partial [Campylobacter jejuni] diamond 141 89.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27139083 27139083 PRJNA474426_P_NODE_31622_length_169_cov_1.525000_g31417_i0 PRJNA474426 31622 169 1.525 2.57725 Halarcobacter sp. 2321133 Bacteria Bacteria 58.2 1.21e-8   NR WP_320035909.1 2321133 g31417 i0 50.9 2.02366863905325 57 26 97.6 1 1 165 11 67 WP_320035909.1 nucleoside 2-deoxyribosyltransferase [Halarcobacter sp.] diamond 342 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter sp.
27676752 27676752 PRJNA474426_P_NODE_9384_length_352_cov_1.491749_g9179_i0 PRJNA474426 9384 352 1.491749 5.25095648 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 143 1.11e-38   NR MCI4399423.1 2268179 g9179 i0 81.1 0.809659090909091 95 16 81 1 4 288 52 144 MCI4399423.1 glycosyltransferase [Campylobacteraceae bacterium] diamond 285 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
28781401 28781401 PRJNA474426_P_NODE_7007_length_408_cov_4.771588_g6803_i0 PRJNA474426 7007 408 4.771588 19.46807904 Desulfurellales bacterium 2482794 Bacteria Bacteria 53.9 7.88e-6   NR TXH59162.1 2482794 g6803 i0 48.8 0.588235294117647 80 38 56.6 2 2 232 86 165 TXH59162.1 MAG: hypothetical protein E6Q97_00430 [Desulfurellales bacterium] diamond 240 53.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28812830 28812830 PRJNA474426_P_NODE_26248_length_190_cov_0.886525_g26043_i0 PRJNA474426 26248 190 0.886525 1.6843975 Campylobacterota bacterium 2026809 Bacteria Bacteria 85.5 1.61e-17   NR MDQ1245100.1 2026809 g26043 i0 91.3 0.726315789473684 46 4 72.6 0 175 38 315 360 MDQ1245100.1 hypothetical protein [Campylobacterota bacterium] diamond 138 85.5 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29254947 29254947 PRJNA474426_P_NODE_25489_length_193_cov_1.263889_g25284_i0 PRJNA474426 25489 193 1.263889 2.43930577 Arcobacter sp. 1872629 Bacteria Bacteria 48.9 9.4e-5   NR MCP4969030.1 1872629 g25284 i0 71 1.41450777202073 31 9 48.2 0 58 150 31 61 MCP4969030.1 hypothetical protein [Arcobacter sp.] diamond 273 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp.

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