RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA1200128", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 9 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 9 ✖

bioproject 1

  • PRJNA1200128 · 9 ✖
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
327024 327024 PRJNA1200128_S_NODE_26881_length_185_cov_2.295775_g26772_i0 PRJNA1200128 26881 185 2.295775 4.24718375 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 259 8.67e-65   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g26772 i0 91.892 28.2 185 15 100 0 1 185 1600681 1600497 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 5217 259 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
1601862 1601862 PRJNA1200128_S_NODE_5742_length_301_cov_2.775194_g5633_i0 PRJNA1200128 5742 301 2.775194 8.35333394 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 490 5.01e-134   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g5633 i0 96.013 160.568106312292 301 12 100 0 1 301 1600052 1599752 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 48331 490 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
7980466 7980466 PRJNA1200128_S_NODE_14747_length_223_cov_2.788889_g14638_i0 PRJNA1200128 14747 223 2.788889 6.21922247 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 375 1.03e-99   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g14638 i0 97.285 45.6816143497758 221 6 99 0 1 221 1599677 1599457 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 10187 375 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
10530817 10530817 PRJNA1200128_S_NODE_10969_length_245_cov_2.559406_g10860_i0 PRJNA1200128 10969 245 2.559406 6.2705447 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 420 5.26e-113   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g10860 i0 97.551 160.914285714286 245 6 100 0 1 245 1601084 1601328 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 39424 420 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
10530837 10530837 PRJNA1200128_S_NODE_15229_length_221_cov_1.848315_g15120_i0 PRJNA1200128 15229 221 1.848315 4.08477615 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 381 2.2e-101   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g15120 i0 99.061 298.380090497738 213 1 96 1 10 221 1600081 1600293 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 65942 381 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
28177749 28177749 PRJNA1200128_S_NODE_23546_length_194_cov_0.933775_g23437_i0 PRJNA1200128 23546 194 0.933775 1.8115235 Sedimentisphaerales bacterium 2813034 Bacteria Bacteria 44.7 0.00399   NR MBN1796766.1 2813034 g23437 i0 38.2 0.850515463917526 55 25 71.1 1 161 24 31 85 MBN1796766.1 AmmeMemoRadiSam system radical SAM enzyme [Sedimentisphaerales bacterium] diamond 165 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
28746331 28746331 PRJNA1200128_S_NODE_39887_length_162_cov_1.184874_g39778_i0 PRJNA1200128 39887 162 1.184874 1.91949588 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0311   NR MFC1737531.1 2026780 g39778 i0 40.9 0.814814814814815 44 26 81.5 0 140 9 5 48 MFC1737531.1 PAC2 family protein [Planctomycetota bacterium] diamond 132 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29504013 29504013 PRJNA1200128_S_NODE_48910_length_151_cov_0.944444_g48801_i0 PRJNA1200128 48910 151 0.944444 1.42611044 Candidatus Brocadiia bacterium 2517210 Bacteria Bacteria 43.1 0.00786   NR MFO7956648.1 2517210 g48801 i0 40.4 0.933774834437086 47 28 93.4 0 4 144 85 131 MFO7956648.1 divalent metal cation transporter [Candidatus Brocadiia bacterium] diamond 141 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia       Candidatus Brocadiia bacterium
32759242 32759242 PRJNA1200128_S_NODE_24140_length_192_cov_1.496644_g24031_i0 PRJNA1200128 24140 192 1.496644 2.87355648 Pirellula sp. 117 Bacteria Bacteria 42.4 0.0256   NR MCE2753667.1 117 g24031 i0 45.2 0.65625 42 23 65.6 0 32 157 356 397 MCE2753667.1 ammonium transporter [Pirellula sp.] diamond 126 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula 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);;