RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA315314" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 21 ✖

bioproject 1

  • PRJNA315314 · 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
15683673 15683673 PRJNA315314_S_NODE_6113_length_327_cov_2.268456_g5792_i0 PRJNA315314 6113 327 2.268456 7.41785112 Phycisphaerae bacterium 2026778 Bacteria Bacteria 185 5.21e-54   NR MCG3126236.1 2026778 g5792 i0 82.4 18.8256880733945 108 19 99.1 0 325 2 188 295 MCG3126236.1 Phenylacetaldehyde dehydrogenase [Phycisphaerae bacterium] diamond 6156 185 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27042734 27042734 PRJNA315314_S_NODE_28542_length_158_cov_2.271318_g28221_i0 PRJNA315314 28542 158 2.271318 3.58868244 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 45.1 0.00148   NR MEY3851192.1 2026799 g28221 i0 73.1 0.493670886075949 26 7 49.4 0 9 86 187 212 MEY3851192.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 78 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27042746 27042746 PRJNA315314_S_NODE_9322_length_265_cov_4.644068_g9001_i0 PRJNA315314 9322 265 4.644068 12.3067802 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.1 0.0368   NR HZT83001.1 2052164 g9001 i0 40 0.679245283018868 60 29 60 1 23 181 703 762 HZT83001.1 hypothetical protein [Gemmataceae bacterium] diamond 180 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27074305 27074305 PRJNA315314_S_NODE_10102_length_255_cov_2.022124_g9781_i0 PRJNA315314 10102 255 2.022124 5.1564162 Planctomycetota bacterium 2026780 Bacteria Bacteria 91.7 2.75e-19   NR MEY4566438.1 2026780 g9781 i0 55.6 0.952941176470588 81 36 95.3 0 13 255 224 304 MEY4566438.1 hypothetical protein [Planctomycetota bacterium] diamond 243 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27281619 27281619 PRJNA315314_S_NODE_10403_length_251_cov_4.333333_g10082_i0 PRJNA315314 10403 251 4.333333 10.87666583 Opitutia 414999 Bacteria Bacteria 69.3 5.11e-13   NR MBE6411830.1 2026772 g10082 i0 55.9 3.44223107569721 59 25 69.3 1 176 3 1 59 MBE6411830.1 ribosome-associated translation inhibitor RaiA [Opitutales bacterium] diamond 864 69.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
27611558 27611558 PRJNA315314_S_NODE_31404_length_152_cov_2.243902_g31083_i0 PRJNA315314 31404 152 2.243902 3.41073104 Phycisphaerales bacterium 2052180 Bacteria Bacteria 86.7 2.71e-18   NR MEN6384997.1 2052180 g31083 i0 76 0.986842105263158 50 12 98.7 0 1 150 206 255 MEN6384997.1 DUF2828 family protein [Phycisphaerales bacterium] diamond 150 86.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28102406 28102406 PRJNA315314_S_NODE_14405_length_215_cov_6.946237_g14084_i0 PRJNA315314 14405 215 6.946237 14.93440955 Pseudomonadati 3379134 Bacteria Bacteria 75.1 7.83e-16   NR MBV9999945.1 2026799 g14084 i0 60 1.75813953488372 60 23 83.7 1 36 215 14 72 MBV9999945.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 378 75.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28748095 28748095 PRJNA315314_S_NODE_3107_length_451_cov_3.407583_g2789_i0 PRJNA315314 3107 451 3.407583 15.36819933 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 194 8.69e-58   NR MFH1459883.1 2035772 g2789 i0 64.7 5.96674057649667 150 53 99.8 0 451 2 86 235 MFH1459883.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Omnitrophota bacterium] diamond 2691 194 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
29127242 29127242 PRJNA315314_S_NODE_20089_length_184_cov_5.883871_g19768_i0 PRJNA315314 20089 184 5.883871 10.82632264 Opitutaceae bacterium 2006848 Bacteria Bacteria 66.2 5.47e-12   NR MEO6245957.1 2006848 g19768 i0 62.2 2.23369565217391 45 17 73.4 0 180 46 84 128 MEO6245957.1 ribosome-associated translation inhibitor RaiA [Opitutaceae bacterium] diamond 411 66.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
29442484 29442484 PRJNA315314_S_NODE_20470_length_183_cov_1.792208_g20149_i0 PRJNA315314 20470 183 1.792208 3.27974064 Waddliaceae bacterium 2026802 Bacteria Bacteria 94 5.07e-21   NR HEY4831209.1 2026802 g20149 i0 81.4 0.967213114754098 59 11 96.7 0 3 179 215 273 HEY4831209.1 F0F1 ATP synthase subunit alpha [Waddliaceae bacterium] diamond 177 94 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Waddliaceae   Waddliaceae bacterium
29979522 29979522 PRJNA315314_S_NODE_11511_length_239_cov_3.771429_g11190_i0 PRJNA315314 11511 239 3.771429 9.01371531 Opitutales bacterium ASA1 3081749 Bacteria Bacteria 55.8 1.32e-7   NR BET69689.1 3081749 g11190 i0 49.3 0.841004184100418 67 33 82.8 1 237 40 28 94 BET69689.1 hypothetical protein ASA1KI_46070 [Opitutales bacterium ASA1] diamond 201 55.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Alterococcaceae Congregicoccus Congregicoccus parvus
30232287 30232287 PRJNA315314_S_NODE_10172_length_254_cov_1.986667_g9851_i0 PRJNA315314 10172 254 1.986667 5.04613418 Aquisphaera insulae 2712864 Bacteria Bacteria 53.5 6.47e-6   NR WP_165229365.1 2712864 g9851 i0 40.2 1.7244094488189 87 39 89.8 3 22 249 224 308 WP_165229365.1 DUF3466 family protein [Aquisphaera insulae] diamond 438 53.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Aquisphaera Aquisphaera insulae
30422277 30422277 PRJNA315314_S_NODE_14193_length_217_cov_1.765957_g13872_i0 PRJNA315314 14193 217 1.765957 3.83212669 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 70.5 4.47e-12   NR MBL8872133.1 2026779 g13872 i0 41.7 3.96774193548387 72 42 99.5 0 2 217 258 329 MBL8872133.1 carboxypeptidase regulatory-like domain-containing protein [Planctomycetaceae bacterium] diamond 861 70.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31054082 31054082 PRJNA315314_S_NODE_18355_length_192_cov_8.742331_g18034_i0 PRJNA315314 18355 192 8.742331 16.78527552 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.037   NR MBM4008176.1 2026780 g18034 i0 63 0.421875 27 10 42.2 0 7 87 436 462 MBM4008176.1 glycosyl transferase family 39 [Planctomycetota bacterium] diamond 81 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31085425 31085425 PRJNA315314_S_NODE_20375_length_183_cov_3.279221_g20054_i0 PRJNA315314 20375 183 3.279221 6.00097443 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0312   NR RMG34231.1 2026780 g20054 i0 43.6 0.901639344262295 55 31 90.2 0 169 5 22 76 RMG34231.1 MAG: hypothetical protein D6725_14655 [Planctomycetota bacterium] diamond 165 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31116740 31116740 PRJNA315314_S_NODE_29015_length_157_cov_2.281250_g28694_i0 PRJNA315314 29015 157 2.28125 3.5815625 Phycisphaera mikurensis 547188 Bacteria Bacteria 59.3 1.57e-8   NR WP_014436784.1 547188 g28694 i0 67.5 0.764331210191083 40 13 76.4 0 122 3 7 46 WP_014436784.1 tyrosine--tRNA ligase [Phycisphaera mikurensis] diamond 120 59.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera mikurensis
31211305 31211305 PRJNA315314_S_NODE_17635_length_196_cov_2.712575_g17314_i0 PRJNA315314 17635 196 2.712575 5.316647 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 102 1.2699999999999999e-23   NR MED5453097.1 2026799 g17314 i0 73.8 1.98979591836735 65 15 99.5 1 1 195 166 228 MED5453097.1 tyrosine--tRNA ligase [Verrucomicrobiota bacterium] diamond 390 102 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31355941 31355941 PRJNA315314_S_NODE_17896_length_195_cov_1.228916_g17575_i0 PRJNA315314 17896 195 1.228916 2.3963862 Pseudomonadati 3379134 Bacteria Bacteria 63.5 8.88e-10   NR MBF0244012.1 2026780 g17575 i0 56.6 1.63076923076923 53 23 81.5 0 194 36 670 722 MBF0244012.1 arginine--tRNA ligase [Planctomycetota bacterium] diamond 318 63.9 0.993740219092332 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31450816 31450816 PRJNA315314_S_NODE_17256_length_198_cov_2.378698_g16935_i0 PRJNA315314 17256 198 2.378698 4.70982204 Pseudomonadati 3379134 Bacteria Bacteria 65.1 2.3e-10   NR WP_148074969.1 1400387 g16935 i0 47.8 2 67 34 100 1 1 198 127 193 WP_148074969.1 glycosyltransferase [Bythopirellula goksoeyrii] diamond 396 65.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Bythopirellula Bythopirellula goksoeyrii
32287680 32287680 PRJNA315314_S_NODE_27699_length_160_cov_2.557252_g27378_i0 PRJNA315314 27699 160 2.557252 4.0916032 Chlamydia suis 83559 Bacteria Bacteria 39.3 0.0327   NR WP_219663935.1 83559 g27378 i0 43.9 0.76875 41 23 76.9 0 31 153 2 42 WP_219663935.1 hypothetical protein, partial [Chlamydia suis] diamond 123 39.3 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales Chlamydiaceae Chlamydia Chlamydia suis
32620945 32620945 PRJNA315314_S_NODE_6620_length_314_cov_2.185965_g6299_i0 PRJNA315314 6620 314 2.185965 6.8639301 Pseudomonadati 3379134 Bacteria Bacteria 52.8 2.62e-5   NR HBO46329.1 2026779 g6299 i0 40 3.53503184713376 100 57 95.5 1 303 4 437 533 HBO46329.1 hypothetical protein [Planctomycetaceae bacterium] diamond 1110 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;