RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB48872 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
26716573 26716573 PRJEB48872_P_NODE_659501_length_157_cov_0.949153_g643689_i0 PRJEB48872 659501 157 0.949153 1.49017021 Phycisphaerales bacterium 2052180 Bacteria Bacteria 70.9 1.12e-12   NR NUQ67316.1 2052180 g643689 i0 65.3 1.91082802547771 49 17 93.6 0 3 149 281 329 NUQ67316.1 aldo/keto reductase [Phycisphaerales bacterium] diamond 300 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27222961 27222961 PRJEB48872_P_NODE_266883_length_314_cov_1.461818_g251071_i0 PRJEB48872 266883 314 1.461818 4.59010852 Candidatus Brocadiales bacterium 2760054 Bacteria Bacteria 42.7 0.0398   NR MEE9200699.1 2760054 g251071 i0 63.6 0.210191082802548 22 8 21 0 156 91 28 49 MEE9200699.1 cytochrome C [Candidatus Brocadiales bacterium] diamond 66 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales     Candidatus Brocadiales bacterium
27753590 27753590 PRJEB48872_P_NODE_695044_length_150_cov_2.018018_g679232_i0 PRJEB48872 695044 150 2.018018 3.027027 PVC group 1783257 Bacteria Bacteria 73.2 1.89e-13   NR MDG6026916.1 2172549 g679232 i0 65.3 7.8 49 17 98 0 148 2 1204 1252 MDG6026916.1 hypothetical protein [Candidatus Brocadia sp.] diamond 1170 73.6 0.994565217391304 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae Candidatus Brocadia Candidatus Brocadia sp.
28675849 28675849 PRJEB48872_P_NODE_380987_length_239_cov_2.090000_g365175_i0 PRJEB48872 380987 239 2.09 4.9951 Planctomycetota bacterium 2026780 Bacteria Bacteria 110 1.14e-28   NR MBU0718477.1 2026780 g365175 i0 61.5 0.97907949790795 78 30 97.9 0 3 236 5 82 MBU0718477.1 toll/interleukin-1 receptor domain-containing protein [Planctomycetota bacterium] diamond 234 110 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28738907 28738907 PRJEB48872_P_NODE_443827_length_212_cov_2.300578_g428015_i0 PRJEB48872 443827 212 2.300578 4.87722536 Pirellulales bacterium 2715253 Bacteria Bacteria 53.9 2.9e-6   NR MDB4475171.1 2715253 g428015 i0 41.4 1.74056603773585 58 29 82.1 1 194 21 2518 2570 MDB4475171.1 Ig-like domain-containing protein [Pirellulales bacterium] diamond 369 53.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
30350030 30350030 PRJEB48872_P_NODE_692192_length_151_cov_1.250000_g676380_i0 PRJEB48872 692192 151 1.25 1.8875 Planctomycetota bacterium 2026780 Bacteria Bacteria 107 8.39e-26   NR MBM3971287.1 2026780 g676380 i0 100 2.98013245033113 50 0 99.3 0 2 151 168 217 MBM3971287.1 hypothetical protein [Planctomycetota bacterium] diamond 450 107 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32088235 32088235 PRJEB48872_P_NODE_508698_length_191_cov_1.703947_g492886_i0 PRJEB48872 508698 191 1.703947 3.25453877 Phycisphaerae bacterium 2026778 Bacteria Bacteria 42 0.0357   NR MDP6637106.1 2026778 g492886 i0 38.8 0.769633507853403 49 30 77 0 154 8 447 495 MDP6637106.1 DUF3604 domain-containing protein [Phycisphaerae bacterium] diamond 147 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
32404753 32404753 PRJEB48872_P_NODE_668839_length_155_cov_1.413793_g653027_i0 PRJEB48872 668839 155 1.413793 2.19137915 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 84.7 6.34e-18   NR MBV8312565.1 2026779 g653027 i0 78.4 0.987096774193548 51 11 98.7 0 153 1 139 189 MBV8312565.1 TolC family protein [Planctomycetaceae bacterium] diamond 153 84.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;