RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA380129" 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 · 5 ✖

bioproject 1

  • PRJNA380129 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27296276 27296276 PRJNA380129_P_NODE_3223_length_273_cov_3.004098_g2899_i0 PRJNA380129 3223 273 3.004098 8.20118754 Candidatus Levyibacteriota bacterium 2052151 Bacteria Bacteria 74.7 2.86e-13   NR MBI2430860.1 2052151 g2899 i0 73.2 1.08791208791209 41 11 45.1 0 130 8 242 282 MBI2430860.1 hypothetical protein [Candidatus Levyibacteriota bacterium] diamond 297 74.7 1 Bacteria Bacteria candidate phyla   Candidatus Levyibacteriota         Candidatus Levyibacteriota bacterium
28906440 28906440 PRJNA380129_P_NODE_3308_length_242_cov_2.539906_g2984_i0 PRJNA380129 3308 242 2.539906 6.14657252 Parcubacteria group bacterium GW2 2026774 Bacteria Bacteria 110 2.39e-28   NR KKQ77766.1 1618783 g2984 i0 72.7 2.47933884297521 66 18 81.8 0 1 198 109 174 KKQ77766.1 MAG: polymerase III epsilon subunit protein [Parcubacteria group bacterium GW2011_GWA1_38_7] diamond 600 110 1 Bacteria Bacteria candidate phyla             Parcubacteria group bacterium GW2011_GWA1_38_7
29033151 29033151 PRJNA380129_P_NODE_3588_length_171_cov_2.014085_g3264_i0 PRJNA380129 3588 171 2.014085 3.44408535 Candidatus Parcubacteria bacterium 2762014 Bacteria Bacteria 68.6 1.14e-11   NR MEN9405062.1 2762014 g3264 i0 70.6 0.894736842105263 51 15 89.5 0 156 4 46 96 MEN9405062.1 Synechococcus virus Syn5 [Candidatus Parcubacteria bacterium] diamond 153 68.6 1 Bacteria Bacteria candidate phyla   Candidatus Parcubacteria         Candidatus Parcubacteria bacterium
32051900 32051900 PRJNA380129_P_NODE_3458_length_197_cov_3.107143_g3134_i0 PRJNA380129 3458 197 3.107143 6.12107171 Bacteria 2 Bacteria Bacteria 49.7 7.3e-5   NR MBI2021079.1 2053557 g3134 i0 85.7 0.852791878172589 28 4 42.6 0 86 3 1 28 MBI2021079.1 DNA polymerase III subunit alpha [Candidatus Giovannonibacteria bacterium] diamond 168 50.1 0.992015968063872 Bacteria Bacteria candidate phyla   Candidatus Giovannoniibacteriota         Candidatus Giovannonibacteria bacterium
32066441 32066441 PRJNA380129_P_NODE_3478_length_192_cov_5.288344_g3154_i0 PRJNA380129 3478 192 5.288344 10.15362048 Candidatus Vogelbacteria bacterium 2053638 Bacteria Bacteria 73.2 2.67e-13   NR MCE9628997.1 2053638 g3154 i0 58.9 0.875 56 23 87.5 0 170 3 222 277 MCE9628997.1 phosphoglycerate kinase [Candidatus Vogelbacteria bacterium] diamond 168 73.2 1 Bacteria Bacteria candidate phyla   Candidatus Vogeliibacteriota         Candidatus Vogelbacteria 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);;