RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA217180" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA217180 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
5470433 5470433 PRJNA217180_P_NODE_11145_length_177_cov_1.593750_g11045_i0 PRJNA217180 11145 177 1.59375 2.8209375 Paludisphaera 1763521 Bacteria Bacteria 116 1.51e-28   NR WP_083713118.1 1387353 g11045 i0 88.1 9 59 7 100 0 1 177 90 148 WP_083713118.1 arylsulfatase [Paludisphaera borealis] diamond 1593 117 0.991452991452991 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Paludisphaera Paludisphaera borealis
19493054 19493054 PRJNA217180_P_NODE_14576_length_163_cov_0.894737_g14476_i0 PRJNA217180 14576 163 0.894737 1.45842131 Phycisphaera sp. 2030824 Bacteria Bacteria 59.7 1.32e-8   NR UYV11941.1 2030824 g14476 i0 55.8 0.957055214723926 52 22 93.9 1 5 157 98 149 UYV11941.1 MAG: DEAD/DEAH box helicase [Phycisphaera sp.] diamond 156 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
24593349 24593349 PRJNA217180_P_NODE_5680_length_245_cov_1.025510_g5580_i0 PRJNA217180 5680 245 1.02551 2.5124995 Gemmataceae bacterium 2052164 Bacteria Bacteria 81.6 3.32e-16   NR MFO0826365.1 2052164 g5580 i0 49.4 0.942857142857143 77 38 94.3 1 2 232 228 303 MFO0826365.1 C45 family peptidase [Gemmataceae bacterium] diamond 231 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26598827 26598827 PRJNA217180_P_NODE_13941_length_164_cov_0.886957_g13841_i0 PRJNA217180 13941 164 0.886957 1.45460948 Planctomycetota bacterium 2026780 Bacteria Bacteria 67.8 7.88e-13   NR RLS76569.1 2026780 g13841 i0 91.2 0.621951219512195 34 3 62.2 0 5 106 1 34 RLS76569.1 MAG: diacylglycerol kinase family protein [Planctomycetota bacterium] diamond 102 67.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27073941 27073941 PRJNA217180_P_NODE_12822_length_166_cov_1.299145_g12722_i0 PRJNA217180 12822 166 1.299145 2.1565807 Phycisphaerae bacterium 2026778 Bacteria Bacteria 47 2.15e-4   NR HUX15701.1 2026778 g12722 i0 58.8 0.614457831325301 34 14 61.4 0 14 115 44 77 HUX15701.1 hypothetical protein [Phycisphaerae bacterium] diamond 102 47 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27926809 27926809 PRJNA217180_P_NODE_15045_length_162_cov_0.902655_g14945_i0 PRJNA217180 15045 162 0.902655 1.4623011 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 55.8 1.88e-8   NR MEN6407890.1 2691551 g14945 i0 80 0.648148148148148 35 7 64.8 0 58 162 1 35 MEN6407890.1 hypothetical protein [Thermoguttaceae bacterium] diamond 105 55.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
28179144 28179144 PRJNA217180_P_NODE_13466_length_165_cov_0.879310_g13366_i0 PRJNA217180 13466 165 0.87931 1.4508615 Phycisphaerae bacterium 2026778 Bacteria Bacteria 46.6 5.27e-4   NR MFO0971831.1 2026778 g13366 i0 39.2 0.927272727272727 51 31 92.7 0 2 154 197 247 MFO0971831.1 hypothetical protein [Phycisphaerae bacterium] diamond 153 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28273991 28273991 PRJNA217180_P_NODE_12906_length_166_cov_0.871795_g12806_i0 PRJNA217180 12906 166 0.871795 1.4471797 Planctomycetota bacterium 2026780 Bacteria Bacteria 76.6 8.62e-15   NR MEO8494394.1 2026780 g12806 i0 56.4 0.993975903614458 55 22 95.8 1 166 8 118 172 MEO8494394.1 HTTM domain-containing protein [Planctomycetota bacterium] diamond 165 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28432052 28432052 PRJNA217180_P_NODE_15006_length_162_cov_0.902655_g14906_i0 PRJNA217180 15006 162 0.902655 1.4623011 Gemmata palustris 2822762 Bacteria Bacteria 49.3 2.88e-5   NR WP_210653483.1 2822762 g14906 i0 64.9 0.685185185185185 37 13 68.5 0 13 123 124 160 WP_210653483.1 hypothetical protein [Gemmata palustris] diamond 111 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata palustris
28558438 28558438 PRJNA217180_P_NODE_10847_length_180_cov_1.267176_g10747_i0 PRJNA217180 10847 180 1.267176 2.2809168 Planctomycetota bacterium 2026780 Bacteria Bacteria 108 1.81e-27   NR MBL8801160.1 2026780 g10747 i0 94.9 2.95 59 3 98.3 0 179 3 172 230 MBL8801160.1 MotA/TolQ/ExbB proton channel family protein [Planctomycetota bacterium] diamond 531 108 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29126883 29126883 PRJNA217180_P_NODE_15309_length_161_cov_0.910714_g15209_i0 PRJNA217180 15309 161 0.910714 1.46624954 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 40.8 0.0297   NR MDX1969404.1 2026779 g15209 i0 52.4 0.782608695652174 42 20 78.3 0 5 130 86 127 MDX1969404.1 hypothetical protein [Planctomycetaceae bacterium] diamond 126 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29221535 29221535 PRJNA217180_P_NODE_12909_length_166_cov_0.871795_g12809_i0 PRJNA217180 12909 166 0.871795 1.4471797 Pirellulaceae bacterium 2699754 Bacteria Bacteria 60.8 3.21e-10   NR MFN9917050.1 2699754 g12809 i0 56.5 0.831325301204819 46 20 83.1 0 9 146 60 105 MFN9917050.1 hypothetical protein [Pirellulaceae bacterium] diamond 138 60.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
29884596 29884596 PRJNA217180_P_NODE_15511_length_161_cov_0.910714_g15411_i0 PRJNA217180 15511 161 0.910714 1.46624954 Urbifossiella sp. 2807431 Bacteria Bacteria 48.5 1.1e-4   NR HEX4613170.1 2807431 g15411 i0 56.8 0.819875776397516 44 18 82 1 2 133 43 85 HEX4613170.1 DNA methyltransferase [Urbifossiella sp.] diamond 132 48.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Urbifossiella Urbifossiella sp.
30231945 30231945 PRJNA217180_P_NODE_9952_length_187_cov_1.260870_g9852_i0 PRJNA217180 9952 187 1.26087 2.3578269 Planctomycetales bacterium 2053591 Bacteria Bacteria 105 1.97e-25   NR MCX7411237.1 2053591 g9852 i0 86 0.914438502673797 57 8 91.4 0 172 2 1 57 MCX7411237.1 FHA domain-containing protein [Planctomycetales bacterium] diamond 171 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
30327256 30327256 PRJNA217180_P_NODE_15312_length_161_cov_0.910714_g15212_i0 PRJNA217180 15312 161 0.910714 1.46624954 Planctomycetota bacterium 2026780 Bacteria Bacteria 75.5 3.46e-14   NR MDZ4772332.1 2026780 g15212 i0 79.2 0.894409937888199 48 10 89.4 0 18 161 459 506 MDZ4772332.1 aldehyde dehydrogenase family protein [Planctomycetota bacterium] diamond 144 75.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30358823 30358823 PRJNA217180_P_NODE_10852_length_180_cov_1.221374_g10752_i0 PRJNA217180 10852 180 1.221374 2.1984732 Planctomycetota bacterium 2026780 Bacteria Bacteria 113 6.900000000000001e-28   NR MCY2982628.1 2026780 g10752 i0 91.5 0.983333333333333 59 5 98.3 0 178 2 230 288 MCY2982628.1 hypothetical protein [Planctomycetota bacterium] diamond 177 113 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30769161 30769161 PRJNA217180_P_NODE_12934_length_166_cov_0.871795_g12834_i0 PRJNA217180 12934 166 0.871795 1.4471797 Phycisphaerales bacterium 2052180 Bacteria Bacteria 52.4 5.03e-6   NR MFA6043399.1 2052180 g12834 i0 51.9 0.975903614457831 54 26 97.6 0 164 3 108 161 MFA6043399.1 SNF2-related protein [Phycisphaerales bacterium] diamond 162 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30832221 30832221 PRJNA217180_P_NODE_13634_length_165_cov_0.879310_g13534_i0 PRJNA217180 13634 165 0.87931 1.4508615 Planctomycetes bacterium RIFCSPHIGHO2_12_39_6 1801977 Bacteria Bacteria 83.6 1.78e-17   NR OHB99883.1 1801977 g13534 i0 72.7 1 55 15 100 0 1 165 89 143 OHB99883.1 MAG: hypothetical protein A2Z57_11205 [Planctomycetes bacterium RIFCSPHIGHO2_12_39_6] diamond 165 83.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium RIFCSPHIGHO2_12_39_6
30990390 30990390 PRJNA217180_P_NODE_12434_length_167_cov_0.864407_g12334_i0 PRJNA217180 12434 167 0.864407 1.44355969 Planctomycetota bacterium 2026780 Bacteria Bacteria 96.7 3.35e-22   NR MCC7063247.1 2026780 g12334 i0 77.8 9.70059880239521 54 12 97 0 162 1 50 103 MCC7063247.1 hypothetical protein [Planctomycetota bacterium] diamond 1620 96.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31021876 31021876 PRJNA217180_P_NODE_10335_length_184_cov_1.274074_g10235_i0 PRJNA217180 10335 184 1.274074 2.34429616 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 79 2.83e-15   NR MBT3354815.1 2268189 g10235 i0 68.8 0.782608695652174 48 15 78.3 0 182 39 403 450 MBT3354815.1 glycosyltransferase [Candidatus Scalindua sp.] diamond 144 79 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
31210929 31210929 PRJNA217180_P_NODE_14035_length_164_cov_0.886957_g13935_i0 PRJNA217180 14035 164 0.886957 1.45460948 Planctomycetota bacterium 2026780 Bacteria Bacteria 49.3 3.93e-6   NR MCP5006680.1 2026780 g13935 i0 69 0.530487804878049 29 9 53 0 134 48 12 40 MCP5006680.1 hypothetical protein [Planctomycetota bacterium] diamond 87 49.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31387529 31387529 PRJNA217180_P_NODE_12956_length_166_cov_0.871795_g12856_i0 PRJNA217180 12956 166 0.871795 1.4471797 Planctomycetia 203683 Bacteria Bacteria 86.3 1.81e-19   NR MBS0203150.1 2026780 g12856 i0 80 2.98192771084337 55 11 99.4 0 2 166 79 133 MBS0203150.1 N-acetyltransferase [Planctomycetota bacterium] diamond 495 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31843878 31843878 PRJNA217180_P_NODE_12477_length_167_cov_0.864407_g12377_i0 PRJNA217180 12477 167 0.864407 1.44355969 Planctomycetota bacterium 2026780 Bacteria Bacteria 61.2 4.31e-10   NR MFN6401147.1 2026780 g12377 i0 50 0.862275449101796 48 24 86.2 0 167 24 69 116 MFN6401147.1 hypothetical protein [Planctomycetota bacterium] diamond 144 61.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32381957 32381957 PRJNA217180_P_NODE_11279_length_176_cov_1.283465_g11179_i0 PRJNA217180 11279 176 1.283465 2.2588984 Planctomycetota bacterium 2026780 Bacteria Bacteria 110 1.95e-27   NR MCK6445985.1 2026780 g11179 i0 91.4 0.988636363636364 58 5 98.9 0 1 174 179 236 MCK6445985.1 restriction endonuclease, SacI family [Planctomycetota bacterium] diamond 174 110 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32571935 32571935 PRJNA217180_P_NODE_12599_length_167_cov_0.864407_g12499_i0 PRJNA217180 12599 167 0.864407 1.44355969 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 67 2.29e-11   NR WZO97302.1 3139350 g12499 i0 66.7 0.862275449101796 48 13 80.8 1 166 32 219 266 WZO97302.1 hypothetical protein EP7_004327 [Isosphaeraceae bacterium EP7] diamond 144 67 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
32634405 32634405 PRJNA217180_P_NODE_14120_length_164_cov_0.886957_g14020_i0 PRJNA217180 14120 164 0.886957 1.45460948 Pirellulaceae bacterium 2699754 Bacteria Bacteria 45.4 5.58e-4   NR MFN9915684.1 2699754 g14020 i0 41.7 0.878048780487805 48 28 87.8 0 18 161 38 85 MFN9915684.1 hypothetical protein [Pirellulaceae bacterium] diamond 144 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
32854998 32854998 PRJNA217180_P_NODE_13640_length_165_cov_0.879310_g13540_i0 PRJNA217180 13640 165 0.87931 1.4508615 Planctomycetota bacterium 2026780 Bacteria Bacteria 86.7 1.66e-20   NR MBP8302044.1 2026780 g13540 i0 95.6 0.818181818181818 45 2 81.8 0 3 137 53 97 MBP8302044.1 hypothetical protein [Planctomycetota bacterium] diamond 135 86.7 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);;