RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA421571" 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

  • PRJNA421571 · 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
423318 423318 PRJNA421571_P_NODE_51941_length_378_cov_2.019672_g49392_i0 PRJNA421571 51941 378 2.019672 7.63436016 Planctomycetota bacterium 2026780 Bacteria Bacteria 111 3.98e-26   NR MEO0631472.1 2026780 g49392 i0 52.8 1.79365079365079 106 44 79.4 2 364 65 296 401 MEO0631472.1 hypothetical protein [Planctomycetota bacterium] diamond 678 111 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
2972650 2972650 PRJNA421571_P_NODE_11103_length_1138_cov_1.540845_g9557_i0 PRJNA421571 11103 1138 1.540845 17.5348161 Pseudomonadati 3379134 Bacteria Bacteria 546 5.95e-188   NR WP_146586571.1 2528002 g9557 i0 69.7 60.8409490333919 373 109 98.1 2 22 1137 10 379 WP_146586571.1 catalase [Posidoniimonas polymericola] diamond 69237 550 0.992727272727273 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Posidoniimonas Posidoniimonas polymericola
2973628 2973628 PRJNA421571_P_NODE_3_length_7201_cov_7.290825_g2_i0 PRJNA421571 3 7201 7.290825 525.01230825 Phycisphaerales bacterium 2052180 Bacteria Bacteria 92.4 2.52e-14   NR MCC6971826.1 2052180 g2 i0 27.7 0.189557005971393 455 284 18.3 12 3484 4803 107 531 MCC6971826.1 hypothetical protein [Phycisphaerales bacterium] diamond 1365 92.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
11903322 11903322 PRJNA421571_P_NODE_99950_length_245_cov_2.674419_g97401_i0 PRJNA421571 99950 245 2.674419 6.55232655 Planctomycetota bacterium 2026780 Bacteria Bacteria 96.3 5.59e-21   NR MEM0982985.1 2026780 g97401 i0 63.2 2.75510204081633 76 25 93.1 1 229 2 8 80 MEM0982985.1 alanine--tRNA ligase [Planctomycetota bacterium] diamond 675 96.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
14452891 14452891 PRJNA421571_P_NODE_77052_length_284_cov_1.459716_g74503_i0 PRJNA421571 77052 284 1.459716 4.14559344 Bacteria 2 Bacteria Bacteria 82.8 4.73e-16   NR MFN5944013.1 2026778 g74503 i0 43.5 1.94366197183099 92 52 97.2 0 5 280 308 399 MFN5944013.1 aldehyde dehydrogenase [Phycisphaerae bacterium] diamond 552 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
26712131 26712131 PRJNA421571_P_NODE_95601_length_249_cov_0.869318_g93052_i0 PRJNA421571 95601 249 0.869318 2.16460182 root 1 Root_unresolved Root_unresolved 70.5 2.34e-12   NR MBI1825087.1 2026780 g93052 i0 45.9 3.24096385542169 74 39 89.2 1 246 25 20 92 MBI1825087.1 FkbM family methyltransferase [Planctomycetota bacterium] diamond 807 70.9 0.994358251057828 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27138465 27138465 PRJNA421571_P_NODE_84862_length_266_cov_0.968912_g82313_i0 PRJNA421571 84862 266 0.968912 2.57730592 Planctomycetota bacterium 2026780 Bacteria Bacteria 105 2.12e-24   NR MDP6963322.1 2026780 g82313 i0 58.1 4.84962406015038 86 33 95.9 2 10 264 230 313 MDP6963322.1 M60 family metallopeptidase [Planctomycetota bacterium] diamond 1290 105 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27296901 27296901 PRJNA421571_P_NODE_27683_length_629_cov_1.194245_g25179_i0 PRJNA421571 27683 629 1.194245 7.51180105 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.8 3.42e-4   NR MDH3592285.1 2026780 g25179 i0 29.4 0.777424483306836 163 91 70.6 3 3 446 71 224 MDH3592285.1 M60 family metallopeptidase [Planctomycetota bacterium] diamond 489 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27707909 27707909 PRJNA421571_P_NODE_107484_length_236_cov_2.631902_g104935_i0 PRJNA421571 107484 236 2.631902 6.21128872 Planctomyces sp. SH-PL14 1632864 Bacteria Bacteria 108 1.71e-25   NR WP_075096580.1 1632864 g104935 i0 62.8 0.991525423728814 78 29 99.2 0 2 235 270 347 WP_075096580.1 M66 family metalloprotease [Planctomyces sp. SH-PL14] diamond 234 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp. SH-PL14
28686530 28686530 PRJNA421571_P_NODE_89247_length_256_cov_1.262295_g86698_i0 PRJNA421571 89247 256 1.262295 3.2314752 Aquisphaera insulae 2712864 Bacteria Bacteria 62.8 2.92e-9   NR WP_165220558.1 2712864 g86698 i0 62 1.171875 50 19 58.6 0 252 103 115 164 WP_165220558.1 lipase family protein [Aquisphaera insulae] diamond 300 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera insulae
28875662 28875662 PRJNA421571_P_NODE_38528_length_481_cov_1.575980_g35981_i0 PRJNA421571 38528 481 1.57598 7.5804638 Planctomycetota bacterium 2026780 Bacteria Bacteria 121 4.55e-29   NR MBL7007865.1 2026780 g35981 i0 39 2.97505197505198 159 93 96.7 3 1 465 111 269 MBL7007865.1 hypothetical protein [Planctomycetota bacterium] diamond 1431 121 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29286055 29286055 PRJNA421571_P_NODE_82989_length_270_cov_1.177665_g80440_i0 PRJNA421571 82989 270 1.177665 3.1796955 Gemmataceae bacterium 2052164 Bacteria Bacteria 104 6.62e-24   NR MCI0460161.1 2052164 g80440 i0 53.6 1.86666666666667 84 39 93.3 0 16 267 1 84 MCI0460161.1 VWA-like domain-containing protein [Gemmataceae bacterium] diamond 504 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29428786 29428786 PRJNA421571_P_NODE_106649_length_241_cov_0.916667_g104100_i0 PRJNA421571 106649 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 64.3 9.13e-10   NR MFN0057506.1 2026780 g104100 i0 52.9 4.0954356846473 51 24 63.5 0 235 83 555 605 MFN0057506.1 M3 family metallopeptidase [Planctomycetota bacterium] diamond 987 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29460288 29460288 PRJNA421571_P_NODE_103390_length_243_cov_0.905882_g100841_i0 PRJNA421571 103390 243 0.905882 2.20129326 Bacteria 2 Bacteria Bacteria 87.4 7.01e-18   NR HMN42288.1 2052180 g100841 i0 57.1 1.61728395061728 63 27 77.8 0 51 239 1346 1408 HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium] diamond 393 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30107136 30107136 PRJNA421571_P_NODE_77132_length_284_cov_1.180095_g74583_i0 PRJNA421571 77132 284 1.180095 3.3514698 Planctomycetota bacterium 2026780 Bacteria Bacteria 61.2 1.69e-8   NR MEC7233350.1 2026780 g74583 i0 44.3 0.73943661971831 70 39 73.9 0 226 17 195 264 MEC7233350.1 hypothetical protein [Planctomycetota bacterium] diamond 210 61.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30376986 30376986 PRJNA421571_P_NODE_42812_length_441_cov_1.782609_g40264_i0 PRJNA421571 42812 441 1.782609 7.86130569 Bacteria 2 Bacteria Bacteria 113 7.93e-26   NR MCC6682421.1 2026777 g40264 i0 47.8 4.87755102040816 115 60 78.2 0 437 93 653 767 MCC6682421.1 alanine--tRNA ligase [Phycisphaeraceae bacterium] diamond 2151 113 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31149440 31149440 PRJNA421571_P_NODE_103955_length_243_cov_0.905882_g101406_i0 PRJNA421571 103955 243 0.905882 2.20129326 Planctomycetota bacterium 2026780 Bacteria Bacteria 99.4 3.6000000000000003e-22   NR MBL8722991.1 2026780 g101406 i0 52.6 1.91358024691358 78 37 96.3 0 239 6 225 302 MBL8722991.1 hypothetical protein [Planctomycetota bacterium] diamond 465 99.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31434418 31434418 PRJNA421571_P_NODE_44816_length_425_cov_2.312500_g42268_i0 PRJNA421571 44816 425 2.3125 9.828125 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 44.7 0.0313   NR HWE37279.1 2691532 g42268 i0 42.4 0.416470588235294 59 23 36.7 3 189 34 139 193 HWE37279.1 hypothetical protein [Isosphaeraceae bacterium] diamond 177 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
31592815 31592815 PRJNA421571_P_NODE_101916_length_244_cov_0.900585_g99367_i0 PRJNA421571 101916 244 0.900585 2.1974274 Planctomycetota bacterium 2026780 Bacteria Bacteria 97.8 4.5e-24   NR MEO0480714.1 2026780 g99367 i0 61.3 3.4672131147541 75 29 92.2 0 2 226 53 127 MEO0480714.1 Rid family detoxifying hydrolase [Planctomycetota bacterium] diamond 846 97.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31972217 31972217 PRJNA421571_P_NODE_88178_length_258_cov_1.664865_g85629_i0 PRJNA421571 88178 258 1.664865 4.2953517 Phycisphaerales bacterium 2052180 Bacteria Bacteria 172 2.2799999999999998e-48   NR MBY0309260.1 2052180 g85629 i0 96.5 0.988372093023256 85 3 98.8 0 3 257 81 165 MBY0309260.1 FYVE zinc finger domain-containing protein [Phycisphaerales bacterium] diamond 255 172 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32590078 32590078 PRJNA421571_P_NODE_97019_length_248_cov_0.880000_g94470_i0 PRJNA421571 97019 248 0.88 2.1824 PVC group 1783257 Bacteria Bacteria 95.9 7.88e-21   NR MCC6785004.1 2026780 g94470 i0 60.3 4.68145161290323 78 29 91.9 1 232 5 406 483 MCC6785004.1 glutamine synthetase III [Planctomycetota bacterium] diamond 1161 96.7 0.991726990692865 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);;