RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1248424", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 13 ✖

tax_phylum 1

  • Campylobacterota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1248424 · 13 ✖

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
352900 352900 PRJNA1248424_P_NODE_63381_length_266_cov_1.720207_g57312_i0 PRJNA1248424 63381 266 1.720207 4.57575062 Campylobacter jejuni 197 Bacteria Bacteria 54.7 0.007   NTclustered gi|1403731835|emb|LS483295.1| 32021 g57312 i0 100 0.109022556390977 29 0 11 0 101 129 545909 545937 Campylobacter jejuni subsp. doylei strain NCTC11925 genome assembly, chromosome: 1 blastn 29 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
2327299 2327299 PRJNA1248424_P_NODE_67922_length_254_cov_1.016575_g61853_i0 PRJNA1248424 67922 254 1.016575 2.5821005 Campylobacter 194 Bacteria Bacteria 52.8 0.023   NTclustered gi|1540291694|emb|LR134534.1| 260714 g61853 i0 100 0.330708661417323 28 0 11 0 185 212 176626 176653 Campylobacter insulaenigrae strain NCTC12928 genome assembly, chromosome: 1 blastn 84 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter insulaenigrae
4179484 4179484 PRJNA1248424_P_NODE_24364_length_673_cov_2.026667_g18467_i0 PRJNA1248424 24364 673 2.026667 13.63946891 Arcobacter ellisii 913109 Bacteria Bacteria 1238 0   NTclustered gi|1474793334|gb|CP032097.1| 913109 g18467 i0 99.851 396.848439821694 673 1 100 0 1 673 955391 954719 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 267079 1238 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
12530501 12530501 PRJNA1248424_P_NODE_54130_length_290_cov_1.585253_g48062_i0 PRJNA1248424 54130 290 1.585253 4.5972337 Campylobacter 194 Bacteria Bacteria 52.8 0.027   NTclustered gi|1153133932|gb|CP012548.1| 1660067 g48062 i0 100 0.482758620689655 28 0 10 0 179 206 1122993 1122966 Campylobacter pinnipediorum subsp. pinnipediorum strain RM17262 chromosome, complete genome blastn 140 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter pinnipediorum
12530522 12530522 PRJNA1248424_P_NODE_62670_length_268_cov_1.579487_g56601_i0 PRJNA1248424 62670 268 1.579487 4.23302516 Aliarcobacter 2321111 Bacteria Bacteria 54.7 0.007   NTclustered gi|2304736180|gb|CP104332.1| 28197 g56601 i0 100 0.742537313432836 29 0 11 0 240 268 1159980 1160008 Aliarcobacter butzleri strain P1200 chromosome, complete genome blastn 199 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
15079552 15079552 PRJNA1248424_P_NODE_76332_length_244_cov_1.736842_g70263_i0 PRJNA1248424 76332 244 1.736842 4.23789448 root 1 Root_unresolved Root_unresolved 451 1.86e-122   NTclustered gi|2423708788|gb|CP115181.1| 195 g70263 i0 100 125.315573770492 244 0 100 0 1 244 595138 594895 Campylobacter coli strain 18JS15S chromosome, complete genome blastn 30577 451 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
18204707 18204707 PRJNA1248424_P_NODE_59855_length_276_cov_1.320197_g53787_i0 PRJNA1248424 59855 276 1.320197 3.64374372 Campylobacter armoricus 2505970 Bacteria Bacteria 52.8 0.025   NTclustered gi|1861371805|gb|CP053825.1| 2505970 g53787 i0 96.774 0.22463768115942 31 1 11 0 61 91 788983 788953 Campylobacter armoricus strain CCUG 73571 chromosome, complete genome blastn 62 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter armoricus
24003927 24003927 PRJNA1248424_P_NODE_63039_length_267_cov_1.577320_g56970_i0 PRJNA1248424 63039 267 1.57732 4.2114444 Campylobacter 194 Bacteria Bacteria 56.5 0.002   NTclustered gi|1540241471|emb|LR134508.1| 201 g56970 i0 100 0.337078651685393 30 0 11 0 163 192 1003531 1003560 Campylobacter lari strain NCTC11937 genome assembly, chromosome: 1 blastn 90 56.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter lari
26661813 26661813 PRJNA1248424_P_NODE_82101_length_199_cov_6.015873_g76031_i0 PRJNA1248424 82101 199 6.015873 11.97158727 Helicobacter pylori 210 Bacteria Bacteria 77 4.31e-17   NR GAA8838853.1 210 g76031 i0 94.6 0.557788944723618 37 2 55.8 0 194 84 7 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 111 77 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27768825 27768825 PRJNA1248424_P_NODE_67624_length_255_cov_0.813187_g61555_i0 PRJNA1248424 67624 255 0.813187 2.07362685 Campylobacterales bacterium 2268180 Bacteria Bacteria 53.5 6.67e-6   NR MBY0539905.1 2268180 g61555 i0 59.6 1.09411764705882 47 17 55.3 1 255 115 334 378 MBY0539905.1 DDE-type integrase/transposase/recombinase [Campylobacterales bacterium] diamond 279 53.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
28968474 28968474 PRJNA1248424_P_NODE_57548_length_282_cov_1.167464_g51480_i0 PRJNA1248424 57548 282 1.167464 3.29224848 Sulfurovum sp. 1969726 Bacteria Bacteria 74.7 3.35e-14   NR MCB4763109.1 1969726 g51480 i0 50.7 8.29787234042553 71 35 75.5 0 65 277 3 73 MCB4763109.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 2340 74.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
31369429 31369429 PRJNA1248424_P_NODE_66336_length_258_cov_1.567568_g60267_i0 PRJNA1248424 66336 258 1.567568 4.04432544 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 42.7 0.0426   NR MCK5293339.1 2808971 g60267 i0 40.7 0.686046511627907 59 33 68.6 1 78 254 47 103 MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium] diamond 177 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
32886054 32886054 PRJNA1248424_P_NODE_76400_length_244_cov_1.497076_g70331_i0 PRJNA1248424 76400 244 1.497076 3.65286544 Sulfurovum sp. 1969726 Bacteria Bacteria 62 6.22e-9   NR MCB4775620.1 1969726 g70331 i0 64.1 1.91803278688525 39 14 48 0 118 2 336 374 MCB4775620.1 hypothetical protein [Sulfurovum sp.] diamond 468 62 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum 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);;