RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA853194", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 6 ✖

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA853194 · 6 ✖

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
840991 840991 PRJNA853194_S_NODE_73201_length_256_cov_8.923497_g72110_i0 PRJNA853194 73201 256 8.923497 22.84415232 Malaciobacter marinus 505249 Bacteria Bacteria 52.8 0.023   NTclustered gi|1474785413|gb|CP032101.1| 505249 g72110 i0 100 0.109375 28 0 11 0 130 157 1771291 1771318 Malaciobacter marinus strain JCM 15502 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter marinus
10162960 10162960 PRJNA853194_S_NODE_15828_length_492_cov_2.749403_g14740_i0 PRJNA853194 15828 492 2.749403 13.52706276 Campylobacter 194 Bacteria Bacteria 54.7 0.013   NTclustered gi|1918098848|gb|CP027634.1| 195 g14740 i0 94.444 0.219512195121951 36 1 7 1 332 367 1428634 1428600 Campylobacter coli strain meC0281 chromosome, complete genome blastn 108 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
14867887 14867887 PRJNA853194_S_NODE_19192_length_455_cov_1.738220_g18102_i0 PRJNA853194 19192 455 1.73822 7.908901 Campylobacter concisus 199 Bacteria Bacteria 52.8 0.044   NTclustered gi|1938724023|gb|CP060707.1| 199 g18102 i0 100 0.145054945054945 28 0 6 0 198 225 1346830 1346857 Campylobacter concisus strain P1CDO2 chromosome, complete genome blastn 66 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
17418943 17418943 PRJNA853194_S_NODE_59074_length_285_cov_1.080189_g57983_i0 PRJNA853194 59074 285 1.080189 3.07853865 Malaciobacter mytili 603050 Bacteria Bacteria 54.7 0.007   NTclustered gi|1435908220|gb|CP031219.1| 1032238 g57983 i0 100 0.101754385964912 29 0 10 0 80 108 2394386 2394358 Malaciobacter mytili LMG 24559 chromosome, complete genome blastn 29 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter mytili
21242243 21242243 PRJNA853194_S_NODE_32497_length_369_cov_2.057432_g31406_i0 PRJNA853194 32497 369 2.057432 7.59192408 Campylobacter armoricus 2505970 Bacteria Bacteria 54.7 0.01   NTclustered gi|1861371805|gb|CP053825.1| 2505970 g31406 i0 90.476 0.227642276422764 42 2 11 1 34 73 1309547 1309588 Campylobacter armoricus strain CCUG 73571 chromosome, complete genome blastn 84 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter armoricus
27252787 27252787 PRJNA853194_S_NODE_63_length_2968_cov_22.254231_g39_i0 PRJNA853194 63 2968 22.254231 660.50557608 Pseudomonadati 3379134 Bacteria Bacteria 52.4 0.0137   NR WP_105915931.1 28198 g39 i0 22.9 0.67722371967655 402 269 38.7 13 453 1601 234 613 WP_105915931.1 hypothetical protein [Aliarcobacter cryaerophilus] diamond 2010 52.8 0.992424242424242 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus

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