RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA656952" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA656952 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
622398 622398 PRJNA656952_P_NODE_35221_length_248_cov_0.880000_g35034_i0 PRJNA656952 35221 248 0.88 2.1824 Phycisphaerales bacterium 2052180 Bacteria Bacteria 167 8.47e-46   NR HLO41002.1 2052180 g35034 i0 92.7 0.991935483870968 82 6 99.2 0 248 3 290 371 HLO41002.1 PSD1 and planctomycete cytochrome C domain-containing protein [Phycisphaerales bacterium] diamond 246 167 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
1160010 1160010 PRJNA656952_P_NODE_24761_length_279_cov_1.495146_g24574_i0 PRJNA656952 24761 279 1.495146 4.17145734 Gemmataceae bacterium 2052164 Bacteria Bacteria 121 9.829999999999999e-30   NR HTK74860.1 2052164 g24574 i0 64.4 0.967741935483871 90 32 96.8 0 277 8 336 425 HTK74860.1 hypothetical protein [Gemmataceae bacterium] diamond 270 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
3711876 3711876 PRJNA656952_P_NODE_31683_length_251_cov_0.865169_g31496_i0 PRJNA656952 31683 251 0.865169 2.17157419 Phycisphaerales bacterium 2052180 Bacteria Bacteria 167 2.39e-50   NR HLO40943.1 2052180 g31496 i0 95.2 0.99203187250996006 83 4 99.2 0 250 2 41 123 HLO40943.1 carboxyl transferase domain-containing protein [Phycisphaerales bacterium] diamond 249 167 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
18474702 18474702 PRJNA656952_P_NODE_35115_length_248_cov_0.880000_g34928_i0 PRJNA656952 35115 248 0.88 2.1824 Gemmata massiliana 1210884 Bacteria Bacteria 132 1.6e-37   NR WP_162667600.1 1210884 g34928 i0 75.6 0.991935483870968 82 20 99.2 0 3 248 28 109 WP_162667600.1 response regulator [Gemmata massiliana] diamond 246 132 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
26732774 26732774 PRJNA656952_P_NODE_36301_length_247_cov_0.885057_g36114_i0 PRJNA656952 36301 247 0.885057 2.18609079 Humisphaera sp. 2807514 Bacteria Bacteria 78.2 3.09e-15   NR MEA2734762.1 2807514 g36114 i0 45.9 0.898785425101215 74 33 89.9 1 3 224 189 255 MEA2734762.1 hypothetical protein [Humisphaera sp.] diamond 222 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae Humisphaera Humisphaera sp.
26796550 26796550 PRJNA656952_P_NODE_31881_length_251_cov_0.865169_g31694_i0 PRJNA656952 31881 251 0.865169 2.17157419 Phycisphaerae bacterium 2026778 Bacteria Bacteria 122 2.73e-32   NR GDX99692.1 2026778 g31694 i0 72.3 0.99203187250996006 83 23 99.2 0 250 2 35 117 GDX99692.1 hypothetical protein LBMAG48_20960 [Phycisphaerae bacterium] diamond 249 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27144118 27144118 PRJNA656952_P_NODE_42642_length_242_cov_0.911243_g42455_i0 PRJNA656952 42642 242 0.911243 2.20520806 Phycisphaerales bacterium 2052180 Bacteria Bacteria 103 9.53e-27   NR MDB5333575.1 2052180 g42455 i0 69.4 0.892561983471074 72 19 89.3 1 217 2 1 69 MDB5333575.1 hypothetical protein [Phycisphaerales bacterium] diamond 216 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27744985 27744985 PRJNA656952_P_NODE_32644_length_250_cov_0.870056_g32457_i0 PRJNA656952 32644 250 0.870056 2.17514 Pirellula sp. 117 Bacteria Bacteria 142 4.92e-37   NR MBA4106471.1 117 g32457 i0 96.3 0.984 82 3 98.4 0 248 3 460 541 MBA4106471.1 hybrid sensor histidine kinase/response regulator [Pirellula sp.] diamond 246 142 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
30649818 30649818 PRJNA656952_P_NODE_26913_length_270_cov_0.903553_g26726_i0 PRJNA656952 26913 270 0.903553 2.4395931 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0378   NR MBJ76935.1 2026780 g26726 i0 41.5 0.588888888888889 53 31 58.9 0 111 269 659 711 MBJ76935.1 hypothetical protein [Planctomycetota bacterium] diamond 159 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30681423 30681423 PRJNA656952_P_NODE_39253_length_245_cov_0.895349_g39066_i0 PRJNA656952 39253 245 0.895349 2.19360505 Phycisphaerales bacterium 2052180 Bacteria Bacteria 164 1.8999999999999998e-47   NR HLP85146.1 2052180 g39066 i0 95.1 0.991836734693878 81 4 99.2 0 3 245 103 183 HLP85146.1 hypothetical protein [Phycisphaerales bacterium] diamond 243 164 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30744867 30744867 PRJNA656952_P_NODE_37634_length_246_cov_0.890173_g37447_i0 PRJNA656952 37634 246 0.890173 2.18982558 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 124 1.08e-31   NR MDX1967521.1 2026779 g37447 i0 98.5 2.48780487804878 68 1 82.9 0 245 42 330 397 MDX1967521.1 phosphoglycerate kinase [Planctomycetaceae bacterium] diamond 612 124 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32136245 32136245 PRJNA656952_P_NODE_33998_length_249_cov_0.875000_g33811_i0 PRJNA656952 33998 249 0.875 2.17875 Phycisphaerales bacterium 2052180 Bacteria Bacteria 85.1 3.36e-17   NR HLP84061.1 2052180 g33811 i0 51.4 0.843373493975904 70 34 84.3 0 37 246 173 242 HLP84061.1 hypothetical protein [Phycisphaerales bacterium] diamond 210 85.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32560023 32560023 PRJNA656952_P_NODE_42979_length_242_cov_0.911243_g42792_i0 PRJNA656952 42979 242 0.911243 2.20520806 Gemmata 113 Bacteria Bacteria 87.4 4.64e-19   NR MBM3982944.1 2026780 g42792 i0 58.3 6.47107438016529 84 31 99.2 1 241 2 134 217 MBM3982944.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium] diamond 1566 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;