RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB64798" and tax_phylum = "Candidatus Poribacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Poribacteria · 4 ✖

tax_clade 1

bioproject 1

  • PRJEB64798 · 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
26994936 26994936 PRJEB64798_P_NODE_196922_length_168_cov_3.226891_g195156_i0 PRJEB64798 196922 168 3.226891 5.42117688 Bacteria 2 Bacteria Bacteria 79 2.28e-15   NR MCE2401405.1 2026781 g195156 i0 69.1 4.91071428571429 55 17 98.2 0 2 166 519 573 MCE2401405.1 AAA family ATPase [Candidatus Poribacteria bacterium] diamond 825 79.7 0.991217063989962 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria bacterium
28202120 28202120 PRJEB64798_P_NODE_149726_length_188_cov_10.726619_g147960_i0 PRJEB64798 149726 188 10.726619 20.16604372 Candidatus Poribacteria bacterium 2026781 Bacteria Bacteria 74.7 5.96e-15   NR HIB86909.1 2026781 g147960 i0 55.9 0.941489361702128 59 26 94.1 0 6 182 25 83 HIB86909.1 hypothetical protein [Candidatus Poribacteria bacterium] diamond 177 74.7 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria bacterium
30469456 30469456 PRJEB64798_P_NODE_138073_length_194_cov_6.455172_g136307_i0 PRJEB64798 138073 194 6.455172 12.52303368 Bacillati 1783272 Bacteria Bacteria 50.1 3.91e-5   NR MYC77520.1 2026781 g136307 i0 41.8 3.57216494845361 55 32 85.1 0 7 171 17 71 MYC77520.1 16S rRNA (guanine(527)-N(7))-methyltransferase RsmG [Candidatus Poribacteria bacterium] diamond 693 50.1 1 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria bacterium
32366567 32366567 PRJEB64798_P_NODE_211039_length_164_cov_6.382609_g209273_i0 PRJEB64798 211039 164 6.382609 10.46747876 Bacillati 1783272 Bacteria Bacteria 44.3 0.00329   NR MFC1712038.1 2026781 g209273 i0 45.2 2.6890243902439 42 23 76.8 0 39 164 1 42 MFC1712038.1 adenylate kinase [Candidatus Poribacteria bacterium] diamond 441 44.7 0.991051454138702 Bacteria Bacteria candidate phyla   Candidatus Poribacteria         Candidatus Poribacteria 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);;