RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA667863" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA667863 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
26701571 26701571 PRJNA667863_P_NODE_12561_length_249_cov_0.875000_g12527_i0 PRJNA667863 12561 249 0.875 2.17875 Phycisphaerales bacterium 2052180 Bacteria Bacteria 150 1.12e-42   NR MBY0313100.1 2052180 g12527 i0 93.9 0.987951807228916 82 5 98.8 0 247 2 87 168 MBY0313100.1 ParA family protein [Phycisphaerales bacterium] diamond 246 150 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27460968 27460968 PRJNA667863_P_NODE_5563_length_293_cov_1.372727_g5529_i0 PRJNA667863 5563 293 1.372727 4.02209011 Planctomycetota bacterium 2026780 Bacteria Bacteria 67.8 7.72e-11   NR MEM7754480.1 2026780 g5529 i0 45 7.59726962457338 80 39 76.8 1 6 230 213 292 MEM7754480.1 fasciclin domain-containing protein [Planctomycetota bacterium] diamond 2226 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27965944 27965944 PRJNA667863_P_NODE_7925_length_271_cov_1.464646_g7891_i0 PRJNA667863 7925 271 1.464646 3.96919066 Planctomycetota bacterium 2026780 Bacteria Bacteria 108 6.08e-26   NR MDE0905108.1 2026780 g7891 i0 59.3 2.01476014760148 91 34 98.5 2 3 269 84 173 MDE0905108.1 bifunctional diaminohydroxyphosphoribosylaminopyrimidine deaminase/5-amino-6-(5-phosphoribosylamino)uracil reductase RibD [Planctomycetota bacterium] diamond 546 108 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28344869 28344869 PRJNA667863_P_NODE_6326_length_285_cov_1.273585_g6292_i0 PRJNA667863 6326 285 1.273585 3.62971725 Gemmata massiliana 1210884 Bacteria Bacteria 113 6.89e-27   NR WP_162666449.1 1210884 g6292 i0 61.8 2.93684210526316 89 33 93.7 1 3 269 278 365 WP_162666449.1 OB-fold protein [Gemmata massiliana] diamond 837 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata massiliana
28451801 28451801 PRJNA667863_P_NODE_8166_length_269_cov_2.107143_g8132_i0 PRJNA667863 8166 269 2.107143 5.66821467 root 1 Root_unresolved Root_unresolved 44.7 0.0108   NR MFO0981485.1 2026780 g8132 i0 46.2 2.2639405204461 52 22 51.3 1 268 131 524 575 MFO0981485.1 hypothetical protein [Planctomycetota bacterium] diamond 609 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29229185 29229185 PRJNA667863_P_NODE_789_length_553_cov_4.056250_g757_i0 PRJNA667863 789 553 4.05625 22.4310625 Phycisphaerales bacterium 2052180 Bacteria Bacteria 70.9 1.45e-10   NR MSR40902.1 2052180 g757 i0 38.8 0.726943942133816 134 60 62.9 7 549 202 590 719 MSR40902.1 hypothetical protein [Phycisphaerales bacterium] diamond 402 70.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29449747 29449747 PRJNA667863_P_NODE_9230_length_262_cov_1.941799_g9196_i0 PRJNA667863 9230 262 1.941799 5.08751338 Gemmata obscuriglobus 114 Bacteria Bacteria 151 3.4199999999999993e-40   NR WP_010038014.1 114 g9196 i0 84.9 0.984732824427481 86 13 98.5 0 3 260 968 1053 WP_010038014.1 serine/threonine-protein kinase [Gemmata obscuriglobus] diamond 258 151 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata obscuriglobus
30081424 30081424 PRJNA667863_P_NODE_15212_length_244_cov_0.900585_g15178_i0 PRJNA667863 15212 244 0.900585 2.1974274 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 42.7 0.0358   NR HRK32644.1 2876886 g15178 i0 50 0.442622950819672 36 18 44.3 0 132 239 63 98 HRK32644.1 serine/threonine-protein kinase [Tepidisphaeraceae bacterium] diamond 108 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
30523911 30523911 PRJNA667863_P_NODE_413_length_723_cov_2.950769_g384_i0 PRJNA667863 413 723 2.950769 21.33405987 Planctomycetota bacterium 2026780 Bacteria Bacteria 97.1 6.76e-19   NR MBM4052851.1 2026780 g384 i0 36.8 0.767634854771784 185 81 76.3 10 126 677 783 932 MBM4052851.1 hypothetical protein [Planctomycetota bacterium] diamond 555 97.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30650097 30650097 PRJNA667863_P_NODE_16033_length_242_cov_3.668639_g15999_i0 PRJNA667863 16033 242 3.668639 8.87810638 Gemmata sp. 1914242 Bacteria Bacteria 56.2 1.67e-7   NR HEY1191034.1 1914242 g15999 i0 60.4 0.65702479338843 53 20 65.7 1 19 177 108 159 HEY1191034.1 hypothetical protein [Gemmata sp.] diamond 159 56.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
30757152 30757152 PRJNA667863_P_NODE_14414_length_245_cov_1.686047_g14380_i0 PRJNA667863 14414 245 1.686047 4.13081515 Planctomycetia 203683 Bacteria Bacteria 67.4 8.05e-11   NR MDF1841105.1 1973111 g14380 i0 42.1 4.29795918367347 76 44 93.1 0 231 4 1184 1259 MDF1841105.1 hypothetical protein [Rubripirellula sp.] diamond 1053 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula sp.
31408889 31408889 PRJNA667863_P_NODE_15736_length_243_cov_0.905882_g15702_i0 PRJNA667863 15736 243 0.905882 2.20129326 Neorhodopirellula lusitana 445327 Bacteria Bacteria 78.2 7.12e-16   NR WP_283433369.1 445327 g15702 i0 89.7 0.962962962962963 39 4 48.1 0 2 118 137 175 WP_283433369.1 hypothetical protein [Neorhodopirellula lusitana] diamond 234 78.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Neorhodopirellula Neorhodopirellula lusitana
31440352 31440352 PRJNA667863_P_NODE_4716_length_308_cov_1.391489_g4682_i0 PRJNA667863 4716 308 1.391489 4.28578612 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0428   NR MFM1805237.1 2026780 g4682 i0 37.2 0.75974025974026 78 40 72.1 3 60 281 251 323 MFM1805237.1 hypothetical protein [Planctomycetota bacterium] diamond 234 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31693456 31693456 PRJNA667863_P_NODE_4217_length_318_cov_0.971429_g4183_i0 PRJNA667863 4217 318 0.971429 3.08914422 Gemmataceae bacterium 2052164 Bacteria Bacteria 72 3.26e-12   NR VIP09135.1 2052164 g4183 i0 42.4 1.82075471698113 99 55 93.4 2 6 302 7 103 VIP09135.1 acetylserotonin o-methyltransferase : Acetylserotonin O-methyltransferase OS=Rhodopirellula baltica SH28 GN=RBSH_02618 PE=4 SV=1: Methyltransf_2 [Gemmataceae bacterium] diamond 579 72 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32243733 32243733 PRJNA667863_P_NODE_8978_length_264_cov_1.240838_g8944_i0 PRJNA667863 8978 264 1.240838 3.27581232 Planctomycetota 203682 Bacteria Bacteria 42.7 0.0489   NR WP_229759373.1 2596890 g8944 i0 38.7 1.35227272727273 62 34 70.5 1 203 18 768 825 WP_229759373.1 DUF4062 domain-containing protein [Candidatus Uabimicrobium amorphum] diamond 357 43.1 0.990719257540603 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Uabimicrobiia Candidatus Uabimicrobiales Candidatus Uabimicrobiaceae Candidatus Uabimicrobium Candidatus Uabimicrobium amorphum
32862672 32862672 PRJNA667863_P_NODE_720_length_573_cov_1.600000_g688_i0 PRJNA667863 720 573 1.6 9.168 Planctomycetota bacterium 2026780 Bacteria Bacteria 59.3 1.43e-6   NR MEI6637303.1 2026780 g688 i0 30.8 0.696335078534031 133 78 67 4 149 532 200 323 MEI6637303.1 discoidin domain-containing protein [Planctomycetota bacterium] diamond 399 59.3 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);;