RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA674308" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA674308 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
8819699 8819699 PRJNA674308_P_NODE_36267_length_169_cov_0.866667_g36032_i0 PRJNA674308 36267 169 0.866667 1.46466723 PVC group 1783257 Bacteria Bacteria 116 2.89e-31   NR MFN9988271.1 117 g36032 i0 94.6 83.4852071005917 56 3 99.4 0 169 2 87 142 MFN9988271.1 dihydroxy-acid dehydratase [Pirellula sp.] diamond 14109 116 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
18497065 18497065 PRJNA674308_P_NODE_2775_length_585_cov_1.108209_g2548_i0 PRJNA674308 2775 585 1.108209 6.48302265 Pseudomonadati 3379134 Bacteria Bacteria 182 5.099999999999999e-53   NR GIW72247.1 2026780 g2548 i0 51.6 5.54871794871795 186 81 93.8 3 2 550 54 233 GIW72247.1 MAG: hypothetical protein KatS3mg102_1789 [Planctomycetota bacterium] diamond 3246 183 0.994535519125683 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
24118606 24118606 PRJNA674308_P_NODE_46319_length_165_cov_0.896552_g46084_i0 PRJNA674308 46319 165 0.896552 1.4793108 Planctomycetota bacterium 2026780 Bacteria Bacteria 89 6.42e-19   NR MCE9591807.1 2026780 g46084 i0 81.5 0.981818181818182 54 10 98.2 0 3 164 26 79 MCE9591807.1 phosphoglycerate dehydrogenase [Planctomycetota bacterium] diamond 162 89 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26923649 26923649 PRJNA674308_P_NODE_21842_length_212_cov_1.276074_g21607_i0 PRJNA674308 21842 212 1.276074 2.70527688 Phycisphaerales bacterium 2052180 Bacteria Bacteria 120 8.159999999999999e-32   NR MBY0308619.1 2052180 g21607 i0 82.9 0.990566037735849 70 12 99.1 0 1 210 73 142 MBY0308619.1 hypothetical protein [Phycisphaerales bacterium] diamond 210 120 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27144578 27144578 PRJNA674308_P_NODE_18042_length_230_cov_1.022099_g17807_i0 PRJNA674308 18042 230 1.022099 2.3508277 Gemmataceae bacterium 2052164 Bacteria Bacteria 70.5 1.92e-12   NR MDB5312661.1 2052164 g17807 i0 69.6 0.730434782608696 56 17 73 0 59 226 2 57 MDB5312661.1 short-chain dehydrogenase/reductase [Gemmataceae bacterium] diamond 168 70.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27599389 27599389 PRJNA674308_P_NODE_21744_length_212_cov_2.190184_g21509_i0 PRJNA674308 21744 212 2.190184 4.64319008 Gemmata 113 Bacteria Bacteria 99.4 3.99e-24   NR HEY1190802.1 1914242 g21509 i0 67.1 4.92452830188679 70 23 99.1 0 3 212 105 174 HEY1190802.1 SDR family NAD(P)-dependent oxidoreductase [Gemmata sp.] diamond 1044 99.8 0.995991983967936 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
27851645 27851645 PRJNA674308_P_NODE_17064_length_235_cov_1.946237_g16829_i0 PRJNA674308 17064 235 1.946237 4.57365695 Pseudomonadati 3379134 Bacteria Bacteria 130 4.45e-34   NR MFM7975758.1 117 g16829 i0 75.6 19.9148936170213 78 19 99.6 0 235 2 300 377 MFM7975758.1 adenosylhomocysteinase [Pirellula sp.] diamond 4680 131 0.99236641221374 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
28029459 28029459 PRJNA674308_P_NODE_35845_length_169_cov_1.291667_g35610_i0 PRJNA674308 35845 169 1.291667 2.18291723 Thermogemmata fonticola 2755323 Bacteria Bacteria 46.6 6.15e-4   NR WP_194539436.1 2755323 g35610 i0 52.2 0.816568047337278 46 22 81.7 0 10 147 1276 1321 WP_194539436.1 sialidase family protein, partial [Thermogemmata fonticola] diamond 138 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Thermogemmata Thermogemmata fonticola
28041330 28041330 PRJNA674308_P_NODE_4705_length_440_cov_1.508951_g4470_i0 PRJNA674308 4705 440 1.508951 6.6393844 Pseudomonadati 3379134 Bacteria Bacteria 109 8.42e-25   NR HUW34796.1 2026780 g4470 i0 47.1 5.66590909090909 138 71 94.1 2 2 415 60 195 HUW34796.1 VIT domain-containing protein [Planctomycetota bacterium] diamond 2493 109 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28187001 28187001 PRJNA674308_P_NODE_47866_length_164_cov_0.904348_g47631_i0 PRJNA674308 47866 164 0.904348 1.48313072 Blastopirellula sp. 2024826 Bacteria Bacteria 49.3 4.59e-5   NR MAR08434.1 2024826 g47631 i0 41.5 0.969512195121951 53 31 97 0 163 5 4 56 MAR08434.1 hypothetical protein [Blastopirellula sp.] diamond 159 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula sp.
28345045 28345045 PRJNA674308_P_NODE_35386_length_170_cov_1.347107_g35151_i0 PRJNA674308 35386 170 1.347107 2.2900819 Phycisphaerae bacterium 2026778 Bacteria Bacteria 91.3 1.1e-19   NR GMV98705.1 2026778 g35151 i0 69.6 1.97647058823529 56 17 98.8 0 170 3 58 113 GMV98705.1 MAG: phosphoenolpyruvate carboxykinase [GTP] [Phycisphaerae bacterium] diamond 336 91.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28439932 28439932 PRJNA674308_P_NODE_6586_length_370_cov_3.457944_g6351_i0 PRJNA674308 6586 370 3.457944 12.7943928 Pirellula sp. 117 Bacteria Bacteria 82.8 1.59e-15   NR MEQ1825283.1 117 g6351 i0 39.8 4.1027027027027 128 64 99.7 3 1 369 2243 2362 MEQ1825283.1 SdrD B-like domain-containing protein [Pirellula sp.] diamond 1518 82.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
28629442 28629442 PRJNA674308_P_NODE_29667_length_185_cov_1.529412_g29432_i0 PRJNA674308 29667 185 1.529412 2.8294122 Planctomycetaceae bacterium SCGC AG-212-F19 1799658 Bacteria Bacteria 67.4 3.05e-11   NR OAI48435.1 1799658 g29432 i0 50.9 1.81621621621622 57 28 92.4 0 171 1 152 208 OAI48435.1 hypothetical protein AYO44_06890 [Planctomycetaceae bacterium SCGC AG-212-F19] diamond 336 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium SCGC AG-212-F19
28913178 28913178 PRJNA674308_P_NODE_8308_length_330_cov_1.896797_g8073_i0 PRJNA674308 8308 330 1.896797 6.2594301 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.1 0.0149   NR TAH34958.1 2026780 g8073 i0 48.8 0.390909090909091 43 22 39.1 0 142 14 90 132 TAH34958.1 MAG: hypothetical protein EYC70_14270 [Planctomycetota bacterium] diamond 129 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29039944 29039944 PRJNA674308_P_NODE_5028_length_424_cov_2.642667_g4793_i0 PRJNA674308 5028 424 2.642667 11.20490808 Gemmataceae bacterium 2052164 Bacteria Bacteria 111 2.91e-25   NR MFO0965945.1 2052164 g4793 i0 43.9 4.08962264150943 148 75 99.1 3 2 421 109 256 MFO0965945.1 peroxidase family protein [Gemmataceae bacterium] diamond 1734 111 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29335805 29335805 PRJNA674308_P_NODE_37969_length_168_cov_1.294118_g37734_i0 PRJNA674308 37969 168 1.294118 2.17411824 Bacteria 2 Bacteria Bacteria 48.9 2.29e-5   NR MCA8910227.1 2026780 g37734 i0 54.1 4.71428571428571 37 17 66.1 0 168 58 83 119 MCA8910227.1 DUF1669 domain-containing protein [Planctomycetota bacterium] diamond 792 49.3 0.991886409736308 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29607642 29607642 PRJNA674308_P_NODE_27430_length_192_cov_1.090909_g27195_i0 PRJNA674308 27430 192 1.090909 2.09454528 Planctomycetota bacterium 2026780 Bacteria Bacteria 58.5 4.69e-8   NR MEC7233350.1 2026780 g27195 i0 42.1 0.890625 57 32 89.1 1 21 191 111 166 MEC7233350.1 hypothetical protein [Planctomycetota bacterium] diamond 171 58.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29607655 29607655 PRJNA674308_P_NODE_5750_length_396_cov_2.394813_g5515_i0 PRJNA674308 5750 396 2.394813 9.48345948 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 81.6 1.52e-17   NR HWB54745.1 2876886 g5515 i0 62.3 0.462121212121212 61 23 46.2 0 3 185 3 63 HWB54745.1 DUF2892 domain-containing protein [Tepidisphaeraceae bacterium] diamond 183 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
29892417 29892417 PRJNA674308_P_NODE_10411_length_296_cov_1.149798_g10176_i0 PRJNA674308 10411 296 1.149798 3.40340208 Gemmataceae bacterium 2052164 Bacteria Bacteria 115 3.32e-29   NR MDB5312661.1 2052164 g10176 i0 64.9 3.93243243243243 97 34 98.3 0 291 1 2 98 MDB5312661.1 short-chain dehydrogenase/reductase [Gemmataceae bacterium] diamond 1164 115 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29935875 29935875 PRJNA674308_P_NODE_17551_length_232_cov_2.000000_g17316_i0 PRJNA674308 17551 232 2 4.64 Bacteria 2 Bacteria Bacteria 50.1 8.21e-5   NR MFQ5592473.1 2026778 g17316 i0 39.3 5.22413793103448 84 40 95.7 5 9 230 340 422 MFQ5592473.1 hypothetical protein [Phycisphaerae bacterium] diamond 1212 50.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30018786 30018786 PRJNA674308_P_NODE_9951_length_302_cov_1.478261_g9716_i0 PRJNA674308 9951 302 1.478261 4.46434822 Gemmataceae bacterium 2052164 Bacteria Bacteria 77 1.61e-14   NR MDB5312661.1 2052164 g9716 i0 64.6 0.645695364238411 65 23 64.6 0 108 302 2 66 MDB5312661.1 short-chain dehydrogenase/reductase [Gemmataceae bacterium] diamond 195 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31029904 31029904 PRJNA674308_P_NODE_41575_length_167_cov_0.881356_g41340_i0 PRJNA674308 41575 167 0.881356 1.47186452 Planctomycetota bacterium 2026780 Bacteria Bacteria 68.9 5.27e-13   NR MBI3407090.1 2026780 g41340 i0 76.5 1.22155688622754 34 8 61.1 0 103 2 4 37 MBI3407090.1 hypothetical protein [Planctomycetota bacterium] diamond 204 68.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31061490 31061490 PRJNA674308_P_NODE_34535_length_172_cov_1.691057_g34300_i0 PRJNA674308 34535 172 1.691057 2.90861804 Planctomycetia bacterium 2052181 Bacteria Bacteria 80.9 1.22e-16   NR MBI1904488.1 2052181 g34300 i0 66 0.872093023255814 50 17 87.2 0 171 22 155 204 MBI1904488.1 queuosine precursor transporter [Planctomycetia bacterium] diamond 150 80.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31155681 31155681 PRJNA674308_P_NODE_27315_length_192_cov_1.454545_g27080_i0 PRJNA674308 27315 192 1.454545 2.7927264 Planctomycetota bacterium 2026780 Bacteria Bacteria 82.4 5.29e-18   NR MBM3968192.1 2026780 g27080 i0 64.9 0.890625 57 20 89.1 0 192 22 55 111 MBM3968192.1 hypothetical protein [Planctomycetota bacterium] diamond 171 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31440575 31440575 PRJNA674308_P_NODE_2876_length_573_cov_4.152672_g2647_i0 PRJNA674308 2876 573 4.152672 23.79481056 Planctomycetota bacterium 2026780 Bacteria Bacteria 107 4.549999999999999e-23   NR MBA3697823.1 2026780 g2647 i0 49 0.513089005235602 98 49 50.8 1 292 2 7 104 MBA3697823.1 acetate--CoA ligase [Planctomycetota bacterium] diamond 294 107 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31472456 31472456 PRJNA674308_P_NODE_6396_length_376_cov_1.577982_g6161_i0 PRJNA674308 6396 376 1.577982 5.93321232 Planctomycetota bacterium 2026780 Bacteria Bacteria 51.2 6.06e-5   NR MEY4394790.1 2026780 g6161 i0 45.8 0.470744680851064 59 32 47.1 0 192 368 43 101 MEY4394790.1 hypothetical protein [Planctomycetota bacterium] diamond 177 51.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31504087 31504087 PRJNA674308_P_NODE_48176_length_164_cov_0.904348_g47941_i0 PRJNA674308 48176 164 0.904348 1.48313072 Tautonia sociabilis 2080755 Bacteria Bacteria 60.1 8.27e-9   NR WP_126723413.1 2080755 g47941 i0 59.3 0.98780487804878 54 22 98.8 0 163 2 188 241 WP_126723413.1 sugar phosphate isomerase/epimerase family protein [Tautonia sociabilis] diamond 162 60.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Tautonia Tautonia sociabilis
31579192 31579192 PRJNA674308_P_NODE_53176_length_162_cov_0.920354_g52941_i0 PRJNA674308 53176 162 0.920354 1.49097348 PVC group 1783257 Bacteria Bacteria 50.1 3.2e-5   NR MCA9023658.1 2026779 g52941 i0 52.7 11.0555555555556 55 21 94.4 3 5 157 1796 1849 MCA9023658.1 FG-GAP repeat protein [Planctomycetaceae bacterium] diamond 1791 50.4 0.994047619047619 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31737051 31737051 PRJNA674308_P_NODE_10537_length_294_cov_1.297959_g10302_i0 PRJNA674308 10537 294 1.297959 3.81599946 Pseudomonadati 3379134 Bacteria Bacteria 60.5 4.05e-8   NR MDF1664958.1 2026780 g10302 i0 40.3 6.07142857142857 72 43 73.5 0 273 58 207 278 MDF1664958.1 AMP-dependent synthetase/ligase [Planctomycetota bacterium] diamond 1785 60.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32211888 32211888 PRJNA674308_P_NODE_10778_length_291_cov_1.504132_g10543_i0 PRJNA674308 10778 291 1.504132 4.37702412 Bacteria 2 Bacteria Bacteria 131 1.32e-33   NR MDB4338657.1 1973111 g10543 i0 64.9 9.8659793814433 97 33 99 1 3 290 276 372 MDB4338657.1 acyl-CoA synthetase [Rubripirellula sp.] diamond 2871 131 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula sp.
32263432 32263432 PRJNA674308_P_NODE_2358_length_640_cov_2.313029_g2136_i0 PRJNA674308 2358 640 2.313029 14.8033856 Planctomycetota bacterium 2026780 Bacteria Bacteria 121 1.24e-27   NR MEI8383067.1 2026780 g2136 i0 41.7 0.7875 168 82 71.3 4 154 609 681 848 MEI8383067.1 integrin alpha [Planctomycetota bacterium] diamond 504 121 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32484813 32484813 PRJNA674308_P_NODE_52379_length_162_cov_0.920354_g52144_i0 PRJNA674308 52379 162 0.920354 1.49097348 Planctomycetota bacterium 2026780 Bacteria Bacteria 64.3 2.95e-10   NR RME03460.1 2026780 g52144 i0 58.7 6.51851851851852 46 19 85.2 0 3 140 143 188 RME03460.1 MAG: PAS domain-containing sensor histidine kinase [Planctomycetota bacterium] diamond 1056 64.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);;