RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJEB10320" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB10320 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
2563405 2563405 PRJEB10320_P_NODE_18963_length_200_cov_1.193939_g18705_i0 PRJEB10320 18963 200 1.193939 2.387878 Bacteria 2 Bacteria Bacteria 115 9.28e-31   NR MBL9080275.1 2053591 g18705 i0 80.3 8.91 66 13 99 0 199 2 48 113 MBL9080275.1 3-isopropylmalate dehydratase large subunit [Planctomycetales bacterium] diamond 1782 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
26773491 26773491 PRJEB10320_P_NODE_5981_length_428_cov_2.249364_g5730_i0 PRJEB10320 5981 428 2.249364 9.62727792 Phycisphaerae 666505 Bacteria Bacteria 85.1 5.25e-18   NR HPS56096.1 2813034 g5730 i0 44 1.46495327102804 109 52 74.3 3 65 382 5 107 HPS56096.1 arsenate reductase ArsC [Sedimentisphaerales bacterium] diamond 627 85.5 0.9953216374269 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Sedimentisphaerales     Sedimentisphaerales bacterium
26836909 26836909 PRJEB10320_P_NODE_23381_length_172_cov_1.291971_g23123_i0 PRJEB10320 23381 172 1.291971 2.22219012 Pseudomonadati 3379134 Bacteria Bacteria 54.7 8.79e-7   NR HKB35699.1 2052164 g23123 i0 51.8 1.88372093023256 56 21 87.2 1 172 23 188 243 HKB35699.1 peroxidase family protein [Gemmataceae bacterium] diamond 324 55.1 0.992740471869329 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26906187 26906187 PRJEB10320_P_NODE_27162_length_155_cov_1.333333_g26904_i0 PRJEB10320 27162 155 1.333333 2.06666615 Gemmataceae bacterium 2052164 Bacteria Bacteria 41.6 0.0291   NR HEY1378729.1 2052164 g26904 i0 49.2 1.14193548387097 59 16 98.7 3 154 2 207 259 HEY1378729.1 peroxidase family protein [Gemmataceae bacterium] diamond 177 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27728121 27728121 PRJEB10320_P_NODE_24644_length_166_cov_0.893130_g24386_i0 PRJEB10320 24644 166 0.89313 1.4825958 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 85.5 9.96e-18   NR MAT70443.1 2026779 g24386 i0 75.9 1.86144578313253 54 13 97.6 0 164 3 274 327 MAT70443.1 long-chain fatty acid--CoA ligase [Planctomycetaceae bacterium] diamond 309 85.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27759638 27759638 PRJEB10320_P_NODE_15984_length_225_cov_1.778947_g15726_i0 PRJEB10320 15984 225 1.778947 4.00263075 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 78.6 3.26e-17   NR HWB54745.1 2876886 g15726 i0 61.7 0.8 60 23 80 0 1 180 4 63 HWB54745.1 DUF2892 domain-containing protein [Tepidisphaeraceae bacterium] diamond 180 78.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
27790998 27790998 PRJEB10320_P_NODE_16944_length_216_cov_2.696133_g16686_i0 PRJEB10320 16944 216 2.696133 5.82364728 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.004   NR RME73613.1 2026780 g16686 i0 44.2 0.722222222222222 52 27 72.2 2 190 35 36 85 RME73613.1 MAG: hypothetical protein D6776_06780 [Planctomycetota bacterium] diamond 156 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28012116 28012116 PRJEB10320_P_NODE_3945_length_539_cov_2.166667_g3714_i0 PRJEB10320 3945 539 2.166667 11.67833513 Planctomycetia bacterium 2052181 Bacteria Bacteria 131 1.42e-32   NR NDC54979.1 2052181 g3714 i0 48.9 1.50278293135436 135 67 75.1 1 13 417 165 297 NDC54979.1 hypothetical protein [Planctomycetia bacterium] diamond 810 131 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
28012122 28012122 PRJEB10320_P_NODE_7865_length_362_cov_1.483180_g7608_i0 PRJEB10320 7865 362 1.48318 5.3691116 Zavarzinella formosa 360055 Bacteria Bacteria 62.4 1.99e-8   NR WP_020468205.1 360055 g7608 i0 43.8 0.870165745856354 105 48 84.5 4 25 330 1733 1829 WP_020468205.1 beta strand repeat-containing protein [Zavarzinella formosa] diamond 315 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Zavarzinella Zavarzinella formosa
28226542 28226542 PRJEB10320_P_NODE_23666_length_170_cov_2.074074_g23408_i0 PRJEB10320 23666 170 2.074074 3.5259258 Pseudomonadati 3379134 Bacteria Bacteria 43.9 0.00411   NR MFL5240637.1 2052164 g23408 i0 42.9 4.34117647058823 49 27 84.7 1 3 146 143 191 MFL5240637.1 NADPH-dependent FMN reductase [Gemmataceae bacterium] diamond 738 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28454103 28454103 PRJEB10320_P_NODE_26986_length_156_cov_0.917355_g26728_i0 PRJEB10320 26986 156 0.917355 1.4310738 Algisphaera agarilytica 1385975 Bacteria Bacteria 45.4 0.00131   NR WP_184678501.1 1385975 g26728 i0 48.9 3.76923076923077 47 22 86.5 1 135 1 390 436 WP_184678501.1 sulfatase [Algisphaera agarilytica] diamond 588 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Algisphaera Algisphaera agarilytica
28548869 28548869 PRJEB10320_P_NODE_21787_length_181_cov_1.643836_g21529_i0 PRJEB10320 21787 181 1.643836 2.97534316 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 82 6.49e-18   NR MCA9117194.1 2026779 g21529 i0 73.5 4.77348066298343 49 13 81.2 0 2 148 99 147 MCA9117194.1 M3 family peptidase [Planctomycetaceae bacterium] diamond 864 82 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29180322 29180322 PRJEB10320_P_NODE_12089_length_273_cov_3.575630_g11831_i0 PRJEB10320 12089 273 3.57563 9.7614699 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 54.3 6.97e-7   NR MBV8879729.1 2026779 g11831 i0 35.4 2.10989010989011 65 40 71.4 1 198 4 6 68 MBV8879729.1 hypothetical protein [Planctomycetaceae bacterium] diamond 576 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29401128 29401128 PRJEB10320_P_NODE_15249_length_233_cov_1.479798_g14991_i0 PRJEB10320 15249 233 1.479798 3.44792934 Phycisphaerae bacterium 2026778 Bacteria Bacteria 56.6 3.81e-7   NR HEY3244876.1 2026778 g14991 i0 42.1 0.733905579399142 57 32 73.4 1 202 32 249 304 HEY3244876.1 ankyrin repeat domain-containing protein [Phycisphaerae bacterium] diamond 171 56.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29558925 29558925 PRJEB10320_P_NODE_26150_length_159_cov_1.258065_g25892_i0 PRJEB10320 26150 159 1.258065 2.00032335 Phycisphaerales bacterium 2052180 Bacteria Bacteria 101 8.48e-25   NR MBY0308619.1 2052180 g25892 i0 88.5 0.981132075471698 52 6 98.1 0 158 3 27 78 MBY0308619.1 hypothetical protein [Phycisphaerales bacterium] diamond 156 101 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29558934 29558934 PRJEB10320_P_NODE_8130_length_354_cov_2.006270_g7872_i0 PRJEB10320 8130 354 2.00627 7.1021958 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.4 5.66e-5   NR MBL9076139.1 2026780 g7872 i0 41.3 2.50847457627119 75 38 62.7 2 1 222 412 481 MBL9076139.1 hypothetical protein [Planctomycetota bacterium] diamond 888 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31201363 31201363 PRJEB10320_P_NODE_23095_length_173_cov_2.775362_g22837_i0 PRJEB10320 23095 173 2.775362 4.80137626 Planctomycetia bacterium 2052181 Bacteria Bacteria 82 4.45e-17   NR MBI1904488.1 2052181 g22837 i0 75.5 1.69942196531792 49 12 85 0 171 25 150 198 MBI1904488.1 queuosine precursor transporter [Planctomycetia bacterium] diamond 294 82 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31676084 31676084 PRJEB10320_P_NODE_22877_length_175_cov_1.035714_g22619_i0 PRJEB10320 22877 175 1.035714 1.8124995 Botrimarina sp. 2795802 Bacteria Bacteria 55.5 1.21e-7   NR WP_350214269.1 2795802 g22619 i0 52.9 1.74857142857143 51 24 87.4 0 174 22 70 120 WP_350214269.1 Hsp20/alpha crystallin family protein [Botrimarina sp.] diamond 306 55.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Botrimarina Botrimarina sp.
31771061 31771061 PRJEB10320_P_NODE_28397_length_151_cov_1.034483_g28139_i0 PRJEB10320 28397 151 1.034483 1.56206933 Planctomycetota bacterium 2026780 Bacteria Bacteria 60.1 8.09e-9   NR TAJ23449.1 2026780 g28139 i0 56.3 2.74172185430464 48 21 95.4 0 145 2 148 195 TAJ23449.1 MAG: S9 family peptidase [Planctomycetota bacterium] diamond 414 60.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31802545 31802545 PRJEB10320_P_NODE_17557_length_211_cov_2.011364_g17299_i0 PRJEB10320 17557 211 2.011364 4.24397804 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.4 0.0355   NR MCP4707532.1 2026780 g17299 i0 45 0.568720379146919 40 22 56.9 0 74 193 4319 4358 MCP4707532.1 hypothetical protein [Planctomycetota bacterium] diamond 120 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32467436 32467436 PRJEB10320_P_NODE_16719_length_218_cov_2.754098_g16461_i0 PRJEB10320 16719 218 2.754098 6.00393364 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.1 0.0186   NR MFN0137316.1 2026778 g16461 i0 42.9 0.577981651376147 42 23 56.4 1 199 77 38 79 MFN0137316.1 hypothetical protein [Phycisphaerae bacterium] diamond 126 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae 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);;