RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1160211" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1160211 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
28417962 28417962 PRJNA1160211_S_NODE_288926_length_233_cov_3.368750_g287693_i0 PRJNA1160211 288926 233 3.36875 7.8491875 root 1 Root_unresolved Root_unresolved 44.7 0.00611   NR GAA6795622.1 210 g287693 i0 47.2 6.6824034334764 36 19 46.4 0 65 172 122 157 GAA6795622.1 hypothetical protein Kyoto200A_0460 [Helicobacter pylori] diamond 1557 44.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28512439 28512439 PRJNA1160211_S_NODE_229347_length_280_cov_3.202899_g228114_i0 PRJNA1160211 229347 280 3.202899 8.9681172 Campylobacter 194 Bacteria Bacteria 98.2 1.73e-22   NR WP_314991748.1 218934 g228114 i0 51.6 1.99285714285714 93 45 99.6 0 2 280 187 279 WP_314991748.1 type I restriction-modification enzyme R subunit C-terminal domain-containing protein, partial [uncultured Campylobacter sp.] diamond 558 98.6 0.995943204868154 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
29314116 29314116 PRJNA1160211_S_NODE_214729_length_295_cov_0.986486_g213496_i0 PRJNA1160211 214729 295 0.986486 2.9101337 Helicobacter pylori 210 Bacteria Bacteria 82.4 2.31e-18   NR GAA9209002.1 210 g213496 i0 94.6 0.376271186440678 37 2 37.6 0 133 243 1 37 GAA9209002.1 hypothetical protein Kyoto198A_1420 [Helicobacter pylori] diamond 111 82.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29692631 29692631 PRJNA1160211_S_NODE_137370_length_393_cov_6.550000_g136138_i0 PRJNA1160211 137370 393 6.55 25.7415 Campylobacter ureolyticus 827 Bacteria Bacteria 252 3.48e-81   NR WP_016646459.1 827 g136138 i0 98.5 1 131 2 100 0 393 1 179 309 WP_016646459.1 type II asparaginase [Campylobacter ureolyticus] diamond 393 252 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
31051736 31051736 PRJNA1160211_S_NODE_133455_length_399_cov_12.395706_g132223_i0 PRJNA1160211 133455 399 12.395706 49.45886694 Campylobacterota bacterium 2026809 Bacteria Bacteria 75.1 4.73e-13   NR MCL4431196.1 2026809 g132223 i0 50 0.661654135338346 88 32 65.4 2 77 337 159 235 MCL4431196.1 hypothetical protein [Campylobacterota bacterium] diamond 264 75.1 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
32632490 32632490 PRJNA1160211_S_NODE_257180_length_256_cov_1.683060_g255947_i0 PRJNA1160211 257180 256 1.68306 4.3086336 Helicobacter pylori 210 Bacteria Bacteria 63.9 1.62e-11   NR WP_316480680.1 210 g255947 i0 92.6 0.31640625 27 2 31.6 0 134 214 1 27 WP_316480680.1 hypothetical protein [Helicobacter pylori] diamond 81 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32664044 32664044 PRJNA1160211_S_NODE_254520_length_258_cov_1.994595_g253287_i0 PRJNA1160211 254520 258 1.994595 5.1460551 Helicobacter sp. 12S 218 Bacteria Bacteria 73.6 6.2e-13   NR WP_257875431.1 1476197 g253287 i0 57.9 1.32558139534884 57 24 66.3 0 173 3 1 57 WP_257875431.1 acetate--CoA ligase family protein [Helicobacter sp. 12S02232-10] diamond 342 73.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp. 12S02232-10

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