RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA849646" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849646 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27276252 27276252 PRJNA849646_P_NODE_23143_length_262_cov_2.354497_g23025_i0 PRJNA849646 23143 262 2.354497 6.16878214 Campylobacter concisus 199 Bacteria Bacteria 169 5.12e-49   NR WP_107970286.1 199 g23025 i0 98.9 0.99618320610687 87 1 99.6 0 2 262 58 144 WP_107970286.1 PD-(D/E)XK nuclease family protein [Campylobacter concisus] diamond 261 169 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
27789873 27789873 PRJNA849646_P_NODE_1084_length_477_cov_3.571782_g967_i0 PRJNA849646 1084 477 3.571782 17.03740014 root 1 Root_unresolved Root_unresolved 128 3.63e-31   NR TXH41244.1 2482794 g967 i0 44.9 1.89308176100629 147 81 92.5 0 3 443 268 414 TXH41244.1 MAG: hypothetical protein E6Q97_38065 [Desulfurellales bacterium] diamond 903 128 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30054717 30054717 PRJNA849646_P_NODE_24751_length_259_cov_2.446237_g24633_i0 PRJNA849646 24751 259 2.446237 6.33575383 Campylobacterota bacterium 2026809 Bacteria Bacteria 97.1 2.7500000000000003e-21   NR MEA2017174.1 2026809 g24633 i0 51.8 0.984555984555985 85 41 98.5 0 255 1 353 437 MEA2017174.1 Fic family protein [Campylobacterota bacterium] diamond 255 97.1 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30086408 30086408 PRJNA849646_P_NODE_832_length_540_cov_2.115632_g716_i0 PRJNA849646 832 540 2.115632 11.4244128 Desulfurellales bacterium 2482794 Bacteria Bacteria 155 8.37e-44   NR TXH41228.1 2482794 g716 i0 84.1 0.488888888888889 88 14 48.9 0 264 1 10 97 TXH41228.1 MAG: FAD-dependent thymidylate synthase [Desulfurellales bacterium] diamond 264 155 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium

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