RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA1137393", 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

  • PRJNA1137393 · 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
1032102 1032102 PRJNA1137393_P_NODE_55601_length_166_cov_0.888889_g55085_i0 PRJNA1137393 55601 166 0.888889 1.47555574 root 1 Root_unresolved Root_unresolved 307 2.69e-79   NTclustered gi|1145145120|gb|KX686749.1| 195 g55085 i0 100 101 166 0 100 0 1 166 46619 46454 Campylobacter coli strain Tx40 plasmid unnamed, complete sequence blastn 16766 307 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
7937672 7937672 PRJNA1137393_P_NODE_11247_length_248_cov_1.432161_g10731_i0 PRJNA1137393 11247 248 1.432161 3.55175928 Arcobacter acticola 1849015 Bacteria Bacteria 374 4.2099999999999995e-99   NTclustered gi|1845963640|gb|CP042652.1| 1849015 g10731 i0 94.979 322.116935483871 239 10 96 1 12 248 1064019 1063781 Arcobacter acticola strain KCTC 52212 chromosome, complete genome blastn 79885 374 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter acticola
8685154 8685154 PRJNA1137393_P_NODE_4147_length_449_cov_3.827500_g3634_i0 PRJNA1137393 4147 449 3.8275 17.185475 Arcobacteraceae 2808963 Bacteria Bacteria 824 0   NTclustered gi|1847339566|gb|CP053833.1| 1054034 g3634 i0 99.777 390.425389755011 449 1 100 0 1 449 919187 919635 Arcobacter cloacae strain LMG 26153 chromosome, complete genome blastn 175301 830 0.992771084337349 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter cloacae
11763314 11763314 PRJNA1137393_P_NODE_20250_length_201_cov_1.730263_g19734_i0 PRJNA1137393 20250 201 1.730263 3.47782863 uncultured Arcobacter sp. 165434 Bacteria Bacteria 261 2.67e-65   NTclustered gi|682122801|gb|KJ739652.1| 165434 g19734 i0 90.816 254.562189054726 196 17 98 1 6 201 39 233 Uncultured Arcobacter sp. clone ONWR3-May-27-2012 23S ribosomal RNA gene, partial sequence blastn 51167 261 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter uncultured Arcobacter sp.
13785457 13785457 PRJNA1137393_P_NODE_48451_length_167_cov_0.881356_g47935_i0 PRJNA1137393 48451 167 0.881356 1.47186452 Campylobacter 194 Bacteria Bacteria 259 7.69e-65   NTclustered gi|2700477995|gb|CP147775.1| 199 g47935 i0 94.611 13.0059880239521 167 9 100 0 1 167 488411 488245 Campylobacter concisus strain RMIT-O23 chromosome blastn 2172 259 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
19410575 19410575 PRJNA1137393_P_NODE_10736_length_253_cov_3.671569_g10220_i0 PRJNA1137393 10736 253 3.671569 9.28906957 uncultured Aliarcobacter sp. 2321118 Bacteria Bacteria 462 8.95e-126   NTclustered gi|2621785459|emb|OY781917.1| 2321118 g10220 i0 99.605 384.411067193676 253 1 100 0 1 253 1466110 1466362 MAG: uncultured Aliarcobacter sp. isolate 35e71162-57ce-4606-8f28-3f72018c63bd genome assembly, chromosome: 2 blastn 97256 462 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter uncultured Aliarcobacter sp.
27038737 27038737 PRJNA1137393_P_NODE_69302_length_162_cov_1.840708_g68786_i0 PRJNA1137393 69302 162 1.840708 2.98194696 Helicobacter pylori 210 Bacteria Bacteria 60.8 4.62e-10   NR GAA8950930.1 210 g68786 i0 65.9 0.814814814814815 44 15 81.5 0 31 162 48 91 GAA8950930.1 hypothetical protein Kyoto181A_1790 [Helicobacter pylori] diamond 132 60.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28681171 28681171 PRJNA1137393_P_NODE_22407_length_195_cov_1.383562_g21891_i0 PRJNA1137393 22407 195 1.383562 2.6979459 Helicobacter pylori 210 Bacteria Bacteria 51.6 5.58e-7   NR GAA6795254.1 210 g21891 i0 62.9 1.6 35 13 53.8 0 181 77 4 38 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 312 51.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30070287 30070287 PRJNA1137393_P_NODE_13752_length_229_cov_1.155556_g13236_i0 PRJNA1137393 13752 229 1.155556 2.64622324 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0121   NR GAA8989908.1 210 g13236 i0 92.3 0.510917030567686 39 3 51.1 0 111 227 1 39 GAA8989908.1 hypothetical protein Kyoto181A_5900 [Helicobacter pylori] diamond 117 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31260171 31260171 PRJNA1137393_P_NODE_15135_length_221_cov_2.034884_g14619_i0 PRJNA1137393 15135 221 2.034884 4.49709364 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.25e-5   NR GAA9176272.1 210 g14619 i0 79.2 1.30316742081448 24 5 32.6 0 27 98 1 24 GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori] diamond 288 50.1 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);;