RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA474426" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA474426 · 6 ✖

analysis 1

  • diamond · 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
24673655 24673655 PRJNA474426_P_NODE_35640_length_163_cov_0.912281_g35435_i0 PRJNA474426 35640 163 0.912281 1.48701803 Campylobacter jejuni 197 Bacteria Bacteria 89.7 3.5e-21   NR WP_257056761.1 197 g35435 i0 95.7 0.865030674846626 47 2 86.5 0 3 143 11 57 WP_257056761.1 PT domain-containing protein, partial [Campylobacter jejuni] diamond 141 89.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27139083 27139083 PRJNA474426_P_NODE_31622_length_169_cov_1.525000_g31417_i0 PRJNA474426 31622 169 1.525 2.57725 Halarcobacter sp. 2321133 Bacteria Bacteria 58.2 1.21e-8   NR WP_320035909.1 2321133 g31417 i0 50.9 2.02366863905325 57 26 97.6 1 1 165 11 67 WP_320035909.1 nucleoside 2-deoxyribosyltransferase [Halarcobacter sp.] diamond 342 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter sp.
27676752 27676752 PRJNA474426_P_NODE_9384_length_352_cov_1.491749_g9179_i0 PRJNA474426 9384 352 1.491749 5.25095648 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 143 1.11e-38   NR MCI4399423.1 2268179 g9179 i0 81.1 0.809659090909091 95 16 81 1 4 288 52 144 MCI4399423.1 glycosyltransferase [Campylobacteraceae bacterium] diamond 285 143 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
28781401 28781401 PRJNA474426_P_NODE_7007_length_408_cov_4.771588_g6803_i0 PRJNA474426 7007 408 4.771588 19.46807904 Desulfurellales bacterium 2482794 Bacteria Bacteria 53.9 7.88e-6   NR TXH59162.1 2482794 g6803 i0 48.8 0.588235294117647 80 38 56.6 2 2 232 86 165 TXH59162.1 MAG: hypothetical protein E6Q97_00430 [Desulfurellales bacterium] diamond 240 53.9 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
28812830 28812830 PRJNA474426_P_NODE_26248_length_190_cov_0.886525_g26043_i0 PRJNA474426 26248 190 0.886525 1.6843975 Campylobacterota bacterium 2026809 Bacteria Bacteria 85.5 1.61e-17   NR MDQ1245100.1 2026809 g26043 i0 91.3 0.726315789473684 46 4 72.6 0 175 38 315 360 MDQ1245100.1 hypothetical protein [Campylobacterota bacterium] diamond 138 85.5 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29254947 29254947 PRJNA474426_P_NODE_25489_length_193_cov_1.263889_g25284_i0 PRJNA474426 25489 193 1.263889 2.43930577 Arcobacter sp. 1872629 Bacteria Bacteria 48.9 9.4e-5   NR MCP4969030.1 1872629 g25284 i0 71 1.41450777202073 31 9 48.2 0 58 150 31 61 MCP4969030.1 hypothetical protein [Arcobacter sp.] diamond 273 48.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter 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);;