RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA1031674" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1031674 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
3993231 3993231 PRJNA1031674_P_NODE_21544_length_252_cov_2.944134_g21333_i0 PRJNA1031674 21544 252 2.944134 7.41921768 Gemmataceae bacterium 2052164 Bacteria Bacteria 157 1.39e-44   NR HZZ77069.1 2052164 g21333 i0 92.8 0.988095238095238 83 6 98.8 0 3 251 70 152 HZZ77069.1 GTP-binding protein [Gemmataceae bacterium] diamond 249 157 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
7819465 7819465 PRJNA1031674_P_NODE_28207_length_239_cov_2.343373_g27996_i0 PRJNA1031674 28207 239 2.343373 5.60066147 Phycisphaerales bacterium 2052180 Bacteria Bacteria 100 1.17e-22   NR MBL0920883.1 2052180 g27996 i0 63.3 1.92050209205021 79 18 99.2 2 238 2 441 508 MBL0920883.1 DUF885 domain-containing protein [Phycisphaerales bacterium] diamond 459 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
12920296 12920296 PRJNA1031674_P_NODE_12191_length_286_cov_1.446009_g11980_i0 PRJNA1031674 12191 286 1.446009 4.13558574 Planctomycetota bacterium 2026780 Bacteria Bacteria 118 1.56e-29   NR MBS0192102.1 2026780 g11980 i0 66.3 1.97202797202797 95 32 99.7 0 1 285 279 373 MBS0192102.1 protein arginine kinase [Planctomycetota bacterium] diamond 564 118 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
23118929 23118929 PRJNA1031674_P_NODE_19999_length_259_cov_1.365591_g19788_i0 PRJNA1031674 19999 259 1.365591 3.53688069 Phycisphaerales bacterium 2052180 Bacteria Bacteria 132 2.5099999999999996e-37   NR TVQ64210.1 2052180 g19788 i0 80 0.984555984555985 85 17 98.5 0 257 3 49 133 TVQ64210.1 MAG: 50S ribosomal protein L11 [Phycisphaerales bacterium] diamond 255 132 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26686801 26686801 PRJNA1031674_P_NODE_20821_length_255_cov_2.478022_g20610_i0 PRJNA1031674 20821 255 2.478022 6.3189561 Candidatus Brocadiia bacterium 2517210 Bacteria Bacteria 77.4 5.53e-15   NR MFO8007798.1 2517210 g20610 i0 56.2 6.38823529411765 73 28 85.9 2 221 3 7 75 MFO8007798.1 IMP cyclohydrolase [Candidatus Brocadiia bacterium] diamond 1629 77.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia       Candidatus Brocadiia bacterium
27287958 27287958 PRJNA1031674_P_NODE_13443_length_282_cov_1.473684_g13232_i0 PRJNA1031674 13443 282 1.473684 4.15578888 Phycisphaerales bacterium 2052180 Bacteria Bacteria 124 9.58e-31   NR MCC6676468.1 2052180 g13232 i0 85.9 0.75531914893617 71 10 75.5 0 213 1 1 71 MCC6676468.1 hypothetical protein [Phycisphaerales bacterium] diamond 213 124 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27785542 27785542 PRJNA1031674_P_NODE_5924_length_353_cov_3.739286_g5713_i0 PRJNA1031674 5924 353 3.739286 13.19967958 Pseudomonadati 3379134 Bacteria Bacteria 132 6.55e-33   NR NUP95924.1 2026779 g5713 i0 59.6 3.6628895184136 109 42 91.8 2 325 2 509 616 NUP95924.1 hypothetical protein [Planctomycetaceae bacterium] diamond 1293 132 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28077338 28077338 PRJNA1031674_P_NODE_22345_length_250_cov_3.632768_g22134_i0 PRJNA1031674 22345 250 3.632768 9.08192 Phycisphaerales bacterium 2052180 Bacteria Bacteria 121 1e-29   NR MCC6676056.1 2052180 g22134 i0 70.2 1.008 84 20 99.6 2 249 1 617 696 MCC6676056.1 glycosyltransferase [Phycisphaerales bacterium] diamond 252 121 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28235054 28235054 PRJNA1031674_P_NODE_20226_length_258_cov_1.432432_g20015_i0 PRJNA1031674 20226 258 1.432432 3.69567456 Phycisphaerales bacterium 2052180 Bacteria Bacteria 180 1.29e-52   NR MCC6678867.1 2052180 g20015 i0 90.6 0.988372093023256 85 8 98.8 0 256 2 224 308 MCC6678867.1 beta-glucosidase [Phycisphaerales bacterium] diamond 255 180 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28322029 28322029 PRJNA1031674_P_NODE_26046_length_244_cov_1.461988_g25835_i0 PRJNA1031674 26046 244 1.461988 3.56725072 Bacteria 2 Bacteria Bacteria 85.1 4.6e-17   NR MBM3979560.1 2026780 g25835 i0 76.5 1.53688524590164 51 12 62.7 0 8 160 319 369 MBM3979560.1 DNA strand exchange inhibitor protein [Planctomycetota bacterium] diamond 375 85.9 0.990686845168801 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28393157 28393157 PRJNA1031674_P_NODE_27366_length_242_cov_0.911243_g27155_i0 PRJNA1031674 27366 242 0.911243 2.20520806 Phycisphaerales bacterium 2052180 Bacteria Bacteria 87.8 5.01e-18   NR TVQ62293.1 2052180 g27155 i0 55 0.991735537190083 80 34 99.2 1 242 3 320 397 TVQ62293.1 MAG: phenylalanine--tRNA ligase subunit beta [Phycisphaerales bacterium] diamond 240 87.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28424884 28424884 PRJNA1031674_P_NODE_23926_length_248_cov_0.880000_g23715_i0 PRJNA1031674 23926 248 0.88 2.1824 Aquisphaera giovannonii 406548 Bacteria Bacteria 91.7 7.29e-20   NR WP_148598209.1 406548 g23715 i0 62.5 0.870967741935484 72 27 87.1 0 2 217 82 153 WP_148598209.1 SRPBCC family protein [Aquisphaera giovannonii] diamond 216 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera giovannonii
28677465 28677465 PRJNA1031674_P_NODE_14007_length_280_cov_1.917874_g13796_i0 PRJNA1031674 14007 280 1.917874 5.3700472 Phycisphaerales bacterium 2052180 Bacteria Bacteria 179 4.54e-50   NR MBL0870451.1 2052180 g13796 i0 82.6 0.985714285714286 92 16 98.6 0 278 3 404 495 MBL0870451.1 hypothetical protein [Phycisphaerales bacterium] diamond 276 179 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29308718 29308718 PRJNA1031674_P_NODE_13989_length_280_cov_2.014493_g13778_i0 PRJNA1031674 13989 280 2.014493 5.6405804 Phycisphaerales bacterium 2052180 Bacteria Bacteria 65.5 1.17e-10   NR HLP83798.1 2052180 g13778 i0 44.7 1.58571428571429 76 40 79.3 2 224 3 67 142 HLP83798.1 hypothetical protein [Phycisphaerales bacterium] diamond 444 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29710961 29710961 PRJNA1031674_P_NODE_22630_length_250_cov_0.870056_g22419_i0 PRJNA1031674 22630 250 0.870056 2.17514 Planctomycetia 203683 Bacteria Bacteria 112 3.99e-29   NR MEZ5944617.1 2026779 g22419 i0 64.9 7.548 74 26 88.8 0 223 2 104 177 MEZ5944617.1 transposase [Planctomycetaceae bacterium] diamond 1887 113 0.991150442477876 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29750609 29750609 PRJNA1031674_P_NODE_24931_length_246_cov_0.890173_g24720_i0 PRJNA1031674 24931 246 0.890173 2.18982558 Planctomycetia bacterium 2052181 Bacteria Bacteria 65.5 1.67e-10   NR MCI0701762.1 2052181 g24720 i0 70 2.21951219512195 40 12 48.8 0 4 123 203 242 MCI0701762.1 hypothetical protein [Planctomycetia bacterium] diamond 546 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
30161267 30161267 PRJNA1031674_P_NODE_19252_length_262_cov_1.227513_g19041_i0 PRJNA1031674 19252 262 1.227513 3.21608406 Phycisphaerales bacterium 2052180 Bacteria Bacteria 92 2.22e-19   NR TVQ59976.1 2052180 g19041 i0 56.6 1.94656488549618 83 36 95 0 14 262 336 418 TVQ59976.1 MAG: hypothetical protein EA379_09280 [Phycisphaerales bacterium] diamond 510 92 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30603740 30603740 PRJNA1031674_P_NODE_21653_length_252_cov_1.720670_g21442_i0 PRJNA1031674 21653 252 1.72067 4.3360884 Planctomycetales bacterium 2053591 Bacteria Bacteria 148 5.68e-43   NR MCE9527997.1 2053591 g21442 i0 92.5 0.952380952380952 80 6 95.2 0 3 242 124 203 MCE9527997.1 FHA domain-containing protein [Planctomycetales bacterium] diamond 240 148 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30817049 30817049 PRJNA1031674_P_NODE_11694_length_288_cov_0.958140_g11483_i0 PRJNA1031674 11694 288 0.95814 2.7594432 Bacteria 2 Bacteria Bacteria 129 5.6199999999999996e-34   NR MBX3351562.1 2026777 g11483 i0 73.7 2.96875 95 25 99 0 287 3 138 232 MBX3351562.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 855 129 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31077939 31077939 PRJNA1031674_P_NODE_8475_length_310_cov_2.953586_g8264_i0 PRJNA1031674 8475 310 2.953586 9.1561166 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 92.4 2.88e-19   NR MBX3353931.1 2026777 g8264 i0 81.6 0.474193548387097 49 9 47.4 0 309 163 454 502 MBX3353931.1 Flp pilus assembly complex ATPase component TadA [Phycisphaeraceae bacterium] diamond 147 92.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31235640 31235640 PRJNA1031674_P_NODE_11695_length_288_cov_0.883721_g11484_i0 PRJNA1031674 11695 288 0.883721 2.54511648 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 43.1 0.0462   NR MCP4463036.1 2026779 g11484 i0 46.9 0.510416666666667 49 23 49 2 41 181 504 551 MCP4463036.1 sulfatase-like hydrolase/transferase [Planctomycetaceae bacterium] diamond 147 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31646793 31646793 PRJNA1031674_P_NODE_13317_length_282_cov_2.698565_g13106_i0 PRJNA1031674 13317 282 2.698565 7.6099533 Phycisphaerales bacterium 2052180 Bacteria Bacteria 171 9.11e-52   NR MCC6677033.1 2052180 g13106 i0 88.3 1 94 11 100 0 282 1 73 166 MCC6677033.1 hypothetical protein [Phycisphaerales bacterium] diamond 282 171 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32658623 32658623 PRJNA1031674_P_NODE_28780_length_231_cov_2.455696_g28569_i0 PRJNA1031674 28780 231 2.455696 5.67265776 Phycisphaerae bacterium 2026778 Bacteria Bacteria 50.1 8.21e-5   NR MBM4108586.1 2026778 g28569 i0 41.3 1.03896103896104 80 34 87 2 6 206 209 288 MBM4108586.1 apolipoprotein N-acyltransferase [Phycisphaerae bacterium] diamond 240 50.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);;