RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1188114" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 24 ✖

bioproject 1

  • PRJNA1188114 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
9247964 9247964 PRJNA1188114_P_NODE_8988_length_179_cov_1.853846_g8936_i0 PRJNA1188114 8988 179 1.853846 3.31838434 Phycisphaerales bacterium 2052180 Bacteria Bacteria 100 5.079999999999999e-23   NR MDB5327853.1 2052180 g8936 i0 74.6 0.988826815642458 59 15 98.9 0 179 3 306 364 MDB5327853.1 Beta,4-xylanase [Phycisphaerales bacterium] diamond 177 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
13073589 13073589 PRJNA1188114_P_NODE_19571_length_161_cov_0.910714_g19519_i0 PRJNA1188114 19571 161 0.910714 1.46624954 Luteolibacter 518753 Bacteria Bacteria 103 1.39e-25   NR MEO7099747.1 1962973 g19519 i0 88.7 5.92546583850932 53 6 98.8 0 1 159 84 136 MEO7099747.1 response regulator transcription factor [Luteolibacter sp.] diamond 954 104 0.990384615384615 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
26660542 26660542 PRJNA1188114_P_NODE_10721_length_172_cov_1.658537_g10669_i0 PRJNA1188114 10721 172 1.658537 2.85268364 Phycisphaerales bacterium 2052180 Bacteria Bacteria 114 6.47e-31   NR MDB5326561.1 2052180 g10669 i0 92.9 0.976744186046512 56 4 97.7 0 168 1 70 125 MDB5326561.1 hydrolase [Phycisphaerales bacterium] diamond 168 114 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
26711244 26711244 PRJNA1188114_P_NODE_19581_length_161_cov_0.910714_g19529_i0 PRJNA1188114 19581 161 0.910714 1.46624954 Bacteria 2 Bacteria Bacteria 67.4 1.84e-11   NR MCH8006341.1 2026780 g19529 i0 58 1.86335403726708 50 21 93.2 0 159 10 234 283 MCH8006341.1 endonuclease/exonuclease/phosphatase family protein [Planctomycetota bacterium] diamond 300 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26787658 26787658 PRJNA1188114_P_NODE_14261_length_165_cov_1.465517_g14209_i0 PRJNA1188114 14261 165 1.465517 2.41810305 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 113 2e-27   NR MDQ6632165.1 2026799 g14209 i0 94.4 4.90909090909091 54 3 98.2 0 163 2 304 357 MDQ6632165.1 DUF1553 domain-containing protein [Verrucomicrobiota bacterium] diamond 810 113 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26787660 26787660 PRJNA1188114_P_NODE_19281_length_161_cov_0.910714_g19229_i0 PRJNA1188114 19281 161 0.910714 1.46624954 Pirellulaceae bacterium 2699754 Bacteria Bacteria 42.4 0.0168   NR MCS5630876.1 2699754 g19229 i0 47.8 2.53416149068323 46 24 85.7 0 155 18 341 386 MCS5630876.1 DUF1549 and DUF1553 domain-containing protein [Pirellulaceae bacterium] diamond 408 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
26914079 26914079 PRJNA1188114_P_NODE_4502_length_212_cov_1.251534_g4450_i0 PRJNA1188114 4502 212 1.251534 2.65325208 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 120 3.689999999999999e-31   NR RYD65414.1 2026800 g4450 i0 77.1 0.990566037735849 70 16 99.1 0 3 212 232 301 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 210 120 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27451811 27451811 PRJNA1188114_P_NODE_16783_length_163_cov_0.894737_g16731_i0 PRJNA1188114 16783 163 0.894737 1.45842131 Planctomycetota bacterium 2026780 Bacteria Bacteria 89.7 1.63e-19   NR MBN9120584.1 2026780 g16731 i0 84.9 0.975460122699387 53 8 97.5 0 159 1 84 136 MBN9120584.1 HD domain-containing protein [Planctomycetota bacterium] diamond 159 89.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27956820 27956820 PRJNA1188114_P_NODE_7545_length_185_cov_1.500000_g7493_i0 PRJNA1188114 7545 185 1.5 2.775 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 60.5 9.46e-9   NR HEY2156819.1 2691532 g7493 i0 93.1 4.24864864864865 29 2 47 0 3 89 466 494 HEY2156819.1 aconitate hydratase AcnA [Isosphaeraceae bacterium] diamond 786 60.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
27988377 27988377 PRJNA1188114_P_NODE_16125_length_164_cov_0.886957_g16073_i0 PRJNA1188114 16125 164 0.886957 1.45460948 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 41.6 0.0333   NR MFH1499603.1 2026799 g16073 i0 81 0.384146341463415 21 4 38.4 0 58 120 1 21 MFH1499603.1 O-antigen ligase family protein [Verrucomicrobiota bacterium] diamond 63 41.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28051448 28051448 PRJNA1188114_P_NODE_10345_length_174_cov_1.112000_g10293_i0 PRJNA1188114 10345 174 1.112 1.93488 Luteolibacter sp. LG18 2819286 Bacteria Bacteria 82.4 7.15e-17   NR WP_338288046.1 2819286 g10293 i0 67.9 1.93103448275862 56 18 96.6 0 5 172 152 207 WP_338288046.1 type II secretion system F family protein [Luteolibacter sp. LG18] diamond 336 82.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp. LG18
28101929 28101929 PRJNA1188114_P_NODE_15065_length_165_cov_0.879310_g15013_i0 PRJNA1188114 15065 165 0.87931 1.4508615 PVC group 1783257 Bacteria Bacteria 55.8 6.06e-8   NR HIB69429.1 2052180 g15013 i0 65.2 1.8 46 16 83.6 0 1 138 9 54 HIB69429.1 hypothetical protein [Phycisphaerales bacterium] diamond 297 55.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28272314 28272314 PRJNA1188114_P_NODE_14546_length_165_cov_0.879310_g14494_i0 PRJNA1188114 14546 165 0.87931 1.4508615 Frigoriglobus tundricola 2774151 Bacteria Bacteria 100 1.22e-24   NR WP_171473219.1 2774151 g14494 i0 88.2 0.927272727272727 51 6 92.7 0 11 163 1 51 WP_171473219.1 metallophosphoesterase family protein [Frigoriglobus tundricola] diamond 153 100 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
28367095 28367095 PRJNA1188114_P_NODE_6446_length_189_cov_3.100000_g6394_i0 PRJNA1188114 6446 189 3.1 5.859 Synoicihabitans lomoniglobus 2909285 Bacteria Bacteria 89.4 6.84e-19   NR WP_330929723.1 2909285 g6394 i0 59.7 0.984126984126984 62 25 98.4 0 2 187 518 579 WP_330929723.1 endo-1,4-beta-xylanase [Synoicihabitans lomoniglobus] diamond 186 89.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Synoicihabitans Synoicihabitans lomoniglobus
28493621 28493621 PRJNA1188114_P_NODE_14027_length_166_cov_0.871795_g13975_i0 PRJNA1188114 14027 166 0.871795 1.4471797 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 82.8 9.56e-17   NR MFM7102256.1 2026799 g13975 i0 83.6 2.98192771084337 55 9 99.4 0 2 166 406 460 MFM7102256.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium] diamond 495 82.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29440445 29440445 PRJNA1188114_P_NODE_6610_length_189_cov_1.342857_g6558_i0 PRJNA1188114 6610 189 1.342857 2.53799973 Opitutaceae bacterium 2006848 Bacteria Bacteria 112 7.65e-28   NR HEU5078630.1 2006848 g6558 i0 85.7 1 63 9 100 0 189 1 173 235 HEU5078630.1 Ldh family oxidoreductase [Opitutaceae bacterium] diamond 189 112 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
30451735 30451735 PRJNA1188114_P_NODE_1713_length_325_cov_1.213768_g1661_i0 PRJNA1188114 1713 325 1.213768 3.944746 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 60.5 5.72e-8   NR MFM8580792.1 2026779 g1661 i0 49.3 1.91076923076923 69 35 63.7 0 302 96 424 492 MFM8580792.1 collagen binding domain-containing protein [Planctomycetaceae bacterium] diamond 621 60.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30767478 30767478 PRJNA1188114_P_NODE_9654_length_176_cov_2.173228_g9602_i0 PRJNA1188114 9654 176 2.173228 3.82488128 Opitutus sp. 1913982 Bacteria Bacteria 93.2 1.99e-20   NR HWL15758.1 1913982 g9602 i0 72.4 1.97727272727273 58 16 98.9 0 175 2 236 293 HWL15758.1 MFS transporter [Opitutus sp.] diamond 348 93.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus sp.
31052082 31052082 PRJNA1188114_P_NODE_16815_length_163_cov_0.894737_g16763_i0 PRJNA1188114 16815 163 0.894737 1.45842131 Lacipirellula sp. 2691419 Bacteria Bacteria 85.9 1.54e-19   NR HEX6961070.1 2691419 g16763 i0 75 2.9079754601227 52 13 95.7 0 158 3 57 108 HEX6961070.1 hypothetical protein [Lacipirellula sp.] diamond 474 85.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Lacipirellula Lacipirellula sp.
31399755 31399755 PRJNA1188114_P_NODE_17976_length_162_cov_0.902655_g17924_i0 PRJNA1188114 17976 162 0.902655 1.4623011 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 98.2 7.139999999999999e-23   NR MDB6078283.1 2562705 g17924 i0 81.1 0.981481481481482 53 10 98.1 0 3 161 212 264 MDB6078283.1 LysR family transcriptional regulator [Akkermansiaceae bacterium] diamond 159 98.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
31494598 31494598 PRJNA1188114_P_NODE_9096_length_179_cov_1.269231_g9044_i0 PRJNA1188114 9096 179 1.269231 2.27192349 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 68.9 5.01e-12   NR HEV8293106.1 2876886 g9044 i0 69.5 0.988826815642458 59 18 98.9 0 178 2 113 171 HEV8293106.1 ABC transporter permease [Tepidisphaeraceae bacterium] diamond 177 68.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32348874 32348874 PRJNA1188114_P_NODE_18059_length_162_cov_0.902655_g18007_i0 PRJNA1188114 18059 162 0.902655 1.4623011 Gemmata sp. 1914242 Bacteria Bacteria 67.4 2.43e-11   NR HEY1186586.1 1914242 g18007 i0 67.9 1.96296296296296 53 17 98.1 0 3 161 638 690 HEY1186586.1 hypothetical protein [Gemmata sp.] diamond 318 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
32412025 32412025 PRJNA1188114_P_NODE_13499_length_166_cov_0.871795_g13447_i0 PRJNA1188114 13499 166 0.871795 1.4471797 Gemmataceae bacterium 2052164 Bacteria Bacteria 92 2.5300000000000003e-21   NR HEX4590977.1 2052164 g13447 i0 86.5 4.75301204819277 52 7 94 0 7 162 42 93 HEX4590977.1 adenosine kinase [Gemmataceae bacterium] diamond 789 92 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32884848 32884848 PRJNA1188114_P_NODE_8700_length_181_cov_1.219697_g8648_i0 PRJNA1188114 8700 181 1.219697 2.20765157 Pirellulales bacterium 2715253 Bacteria Bacteria 102 1.58e-24   NR MCC7476623.1 2715253 g8648 i0 74.6 1.95580110497238 59 15 97.8 0 1 177 87 145 MCC7476623.1 hypothetical protein [Pirellulales bacterium] diamond 354 102 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales 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);;