RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA613025" 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 · 19 ✖

bioproject 1

  • PRJNA613025 · 19 ✖

analysis 1

  • diamond · 19 ✖
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
2424103 2424103 PRJNA613025_S_NODE_29822_length_168_cov_1.067227_g29668_i0 PRJNA613025 29822 168 1.067227 1.79294136 Simkania sp. 34094 Bacteria Bacteria 105 2.01e-26   NR MCB1084310.1 34094 g29668 i0 90.9 0.982142857142857 55 5 98.2 0 3 167 33 87 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 165 105 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
26763750 26763750 PRJNA613025_S_NODE_30701_length_166_cov_0.871795_g30547_i0 PRJNA613025 30701 166 0.871795 1.4471797 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 48.9 6.37e-6   NR PYJ85085.1 2026799 g30547 i0 63.2 0.686746987951807 38 14 68.7 0 153 40 28 65 PYJ85085.1 MAG: hypothetical protein DME22_10395 [Verrucomicrobiota bacterium] diamond 114 48.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27238257 27238257 PRJNA613025_S_NODE_14423_length_288_cov_10.133891_g14269_i0 PRJNA613025 14423 288 10.133891 29.18560608 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0164   NR MEI6341235.1 2026799 g14269 i0 46 0.520833333333333 50 25 50 1 110 253 109 158 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 150 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28280209 28280209 PRJNA613025_S_NODE_12346_length_330_cov_26.078292_g12192_i0 PRJNA613025 12346 330 26.078292 86.0583636 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0255   NR MEI6341235.1 2026799 g12192 i0 41.4 0.527272727272727 58 32 50.9 1 91 258 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28722549 28722549 PRJNA613025_S_NODE_11567_length_349_cov_29.053333_g11413_i0 PRJNA613025 11567 349 29.053333 101.39613217 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.7 0.0157   NR MEI6341235.1 2026799 g11413 i0 39.7 0.498567335243553 58 33 48.1 1 110 277 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28911588 28911588 PRJNA613025_S_NODE_11568_length_349_cov_25.446667_g11414_i0 PRJNA613025 11568 349 25.446667 88.80886783 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00432   NR MEI6341235.1 2026799 g11414 i0 33.7 0.713467048710602 83 46 63.6 2 56 277 84 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 249 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29196205 29196205 PRJNA613025_S_NODE_11569_length_349_cov_24.186667_g11415_i0 PRJNA613025 11569 349 24.186667 84.41146783 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00432   NR MEI6341235.1 2026799 g11415 i0 34.9 0.713467048710602 83 45 63.6 2 56 277 84 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 249 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29272018 29272018 PRJNA613025_S_NODE_15189_length_276_cov_1.678414_g15035_i0 PRJNA613025 15189 276 1.678414 4.63242264 Bacteria 2 Bacteria Bacteria 44.3 0.0158   NR PHX78409.1 2026779 g15035 i0 64 1.08695652173913 25 9 27.2 0 92 18 547 571 PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium] diamond 300 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29953927 29953927 PRJNA613025_S_NODE_17811_length_241_cov_1.328125_g17657_i0 PRJNA613025 17811 241 1.328125 3.20078125 Rhodopirellula sp. TMED11 1986614 Bacteria Bacteria 122 5.399999999999999e-31   NR OUT58717.1 1986614 g17657 i0 74.7 0.983402489626556 79 20 98.3 0 3 239 366 444 OUT58717.1 MAG: adenosylhomocysteinase [Rhodopirellula sp. TMED11] diamond 237 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rhodopirellula Rhodopirellula sp. TMED11
30491065 30491065 PRJNA613025_S_NODE_29513_length_169_cov_1.133333_g29359_i0 PRJNA613025 29513 169 1.133333 1.91533277 Phycisphaerales bacterium 2052180 Bacteria Bacteria 72 6.58e-13   NR HMN42288.1 2052180 g29359 i0 60.7 0.994082840236686 56 21 99.4 1 169 2 1362 1416 HMN42288.1 GC-type dockerin domain-anchored protein [Phycisphaerales bacterium] diamond 168 72 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30522555 30522555 PRJNA613025_S_NODE_20053_length_219_cov_2.147059_g19899_i0 PRJNA613025 20053 219 2.147059 4.70205921 Limnoglobus roseus 2598579 Bacteria Bacteria 63.5 1.3e-9   NR WP_149113609.1 2598579 g19899 i0 49.2 0.89041095890411 65 27 89 3 195 1 799 857 WP_149113609.1 FAD-binding protein [Limnoglobus roseus] diamond 195 63.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus
30996591 30996591 PRJNA613025_S_NODE_11474_length_351_cov_25.784768_g11320_i0 PRJNA613025 11474 351 25.784768 90.50453568 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0308   NR MEI6341235.1 2026799 g11320 i0 41.4 0.495726495726496 58 32 47.9 1 112 279 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30996606 30996606 PRJNA613025_S_NODE_26294_length_182_cov_1.360902_g26140_i0 PRJNA613025 26294 182 1.360902 2.47684164 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 63.2 1.02e-9   NR NUQ35036.1 2026779 g26140 i0 63 1.63186813186813 46 17 75.8 0 180 43 118 163 NUQ35036.1 adenosylhomocysteinase [Planctomycetaceae bacterium] diamond 297 63.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31375979 31375979 PRJNA613025_S_NODE_16356_length_258_cov_2.234450_g16202_i0 PRJNA613025 16356 258 2.23445 5.764881 Planctomycetia bacterium 2052181 Bacteria Bacteria 161 2.3099999999999994e-48   NR NCX99838.1 2052181 g16202 i0 98.8 0.988372093023256 85 1 98.8 0 257 3 92 176 NCX99838.1 TetR family transcriptional regulator [Planctomycetia bacterium] diamond 255 161 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
31534213 31534213 PRJNA613025_S_NODE_33776_length_161_cov_0.910714_g33622_i0 PRJNA613025 33776 161 0.910714 1.46624954 Phycisphaerae bacterium 2026778 Bacteria Bacteria 55.5 3.94e-7   NR MFQ5463581.1 2026778 g33622 i0 71.9 0.596273291925466 32 9 59.6 0 14 109 325 356 MFQ5463581.1 hypothetical protein [Phycisphaerae bacterium] diamond 96 55.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
31831515 31831515 PRJNA613025_S_NODE_25217_length_187_cov_1.775362_g25063_i0 PRJNA613025 25217 187 1.775362 3.31992694 root 1 Root_unresolved Root_unresolved 103 1.97e-26   NR MCB1084350.1 34094 g25063 i0 75.4 3.88235294117647 61 15 97.9 0 185 3 18 78 MCB1084350.1 MC/SLC25 family protein [Simkania sp.] diamond 726 103 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
31945061 31945061 PRJNA613025_S_NODE_23817_length_195_cov_0.972603_g23663_i0 PRJNA613025 23817 195 0.972603 1.89657585 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.2 0.0438   NR NBU73603.1 2026780 g23663 i0 46.5 0.661538461538462 43 23 66.2 0 44 172 49 91 NBU73603.1 DUF1080 domain-containing protein [Planctomycetota bacterium] diamond 129 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31945066 31945066 PRJNA613025_S_NODE_27077_length_178_cov_9.372093_g26923_i0 PRJNA613025 27077 178 9.372093 16.68232554 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0159   NR MCZ7647757.1 2026780 g26923 i0 56.3 0.539325842696629 32 14 53.9 0 52 147 70 101 MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium] diamond 96 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32356832 32356832 PRJNA613025_S_NODE_17979_length_239_cov_1.505263_g17825_i0 PRJNA613025 17979 239 1.505263 3.59757857 Rubripirellula tenax 2528015 Bacteria Bacteria 81.3 9.7e-16   NR WP_146456240.1 2528015 g17825 i0 55.6 0.903765690376569 72 32 90.4 0 218 3 415 486 WP_146456240.1 FAD-binding protein [Rubripirellula tenax] diamond 216 81.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Rubripirellula Rubripirellula tenax

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);;