RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA849822", tax_phylum = "Minisyncoccota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 5 ✖

tax_phylum 1

  • Minisyncoccota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA849822 · 5 ✖

analysis 1

tax_kingdom 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
27055011 27055011 PRJNA849822_P_NODE_20942_length_316_cov_2.374486_g20768_i0 PRJNA849822 20942 316 2.374486 7.50337576 Minisyncoccota bacterium 2053589 Bacteria Bacteria 45.4 0.00971   NR HPP64811.1 2053589 g20768 i0 51.5 0.996835443037975 33 16 31.3 0 41 139 423 455 HPP64811.1 PKD domain-containing protein [Candidatus Paceibacterota bacterium] diamond 315 45.4 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29991801 29991801 PRJNA849822_P_NODE_24571_length_292_cov_1.570776_g24397_i0 PRJNA849822 24571 292 1.570776 4.58666592 Minisyncoccota bacterium 2053589 Bacteria Bacteria 92.8 1.47e-19   NR MDR3558125.1 2053589 g24397 i0 47.9 0.986301369863014 96 50 98.6 0 3 290 182 277 MDR3558125.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 288 92.8 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
30718358 30718358 PRJNA849822_P_NODE_33194_length_253_cov_1.733333_g33020_i0 PRJNA849822 33194 253 1.733333 4.38533249 Minisyncoccota bacterium 2053589 Bacteria Bacteria 73.9 4.59e-15   NR MDR3572201.1 2053589 g33020 i0 88.1 0.49802371541502 42 5 49.8 0 2 127 47 88 MDR3572201.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 126 73.9 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31856510 31856510 PRJNA849822_P_NODE_28237_length_275_cov_1.113861_g28063_i0 PRJNA849822 28237 275 1.113861 3.06311775 Minisyncoccota bacterium 2053589 Bacteria Bacteria 75.5 8.54e-15   NR MBP6858028.1 2053589 g28063 i0 93.6 0.512727272727273 47 3 51.3 0 135 275 1 47 MBP6858028.1 type II secretion system protein [Candidatus Paceibacterota bacterium] diamond 141 75.5 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32204682 32204682 PRJNA849822_P_NODE_31438_length_261_cov_1.085106_g31264_i0 PRJNA849822 31438 261 1.085106 2.83212666 Minisyncoccota bacterium 2053589 Bacteria Bacteria 72 2.28e-12   NR MFO0743522.1 2053589 g31264 i0 58.8 3.62068965517241 80 31 92 1 9 248 433 510 MFO0743522.1 fibronectin type III domain-containing protein [Candidatus Paceibacterota bacterium] diamond 945 72 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota 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);;