RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJEB48872 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
26716566 26716566 PRJEB48872_P_NODE_573281_length_174_cov_2.000000_g557469_i0 PRJEB48872 573281 174 2 3.48 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 58.2 5.51e-8   NR RJQ27558.1 2762014 g557469 i0 49.1 0.948275862068966 55 28 94.8 0 171 7 6 60 RJQ27558.1 MAG: DEAD/DEAH box helicase [Candidatus Parcubacteria bacterium] diamond 165 58.2 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
28644312 28644312 PRJEB48872_P_NODE_648127_length_159_cov_1.025000_g632315_i0 PRJEB48872 648127 159 1.025 1.62975 Minisyncoccota bacterium 2053589 Bacteria Bacteria 52.4 4.61e-6   NR HOL54201.1 2053589 g632315 i0 49 0.962264150943396 51 26 96.2 0 155 3 118 168 HOL54201.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 153 52.4 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
31202078 31202078 PRJEB48872_P_NODE_546615_length_181_cov_1.154930_g530803_i0 PRJEB48872 546615 181 1.15493 2.0904233 Minisyncoccota bacterium 2053589 Bacteria Bacteria 107 5.38e-26   NR HVX91236.1 2053589 g530803 i0 86.4 0.977900552486188 59 8 97.8 0 179 3 105 163 HVX91236.1 IS3 family transposase [Candidatus Paceibacterota bacterium] diamond 177 107 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
32563119 32563119 PRJEB48872_P_NODE_578339_length_173_cov_1.641791_g562527_i0 PRJEB48872 578339 173 1.641791 2.84029843 Candidatus Binataceae bacterium 2785449 Bacteria Bacteria 78.2 4.65e-15   NR HZO80131.1 2785449 g562527 i0 75 2.93063583815029 56 14 97.1 0 6 173 786 841 HZO80131.1 cation-transporting P-type ATPase [Candidatus Binataceae bacterium] diamond 507 78.2 1 Bacteria Bacteria candidate phyla   Candidatus Binatota Candidatus Binatia Candidatus Binatales Candidatus Binataceae   Candidatus Binataceae 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);;