RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1262902 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
9291711 9291711 PRJNA1262902_P_NODE_8128_length_250_cov_0.870056_g8086_i0 PRJNA1262902 8128 250 0.870056 2.17514 Gemmataceae bacterium 2052164 Bacteria Bacteria 132 1.89e-36   NR HEY1379059.1 2052164 g8086 i0 76.8 0.984 82 19 98.4 0 3 248 132 213 HEY1379059.1 class I SAM-dependent methyltransferase [Gemmataceae bacterium] diamond 246 132 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27105316 27105316 PRJNA1262902_P_NODE_7642_length_251_cov_0.865169_g7600_i0 PRJNA1262902 7642 251 0.865169 2.17157419 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 115 2.78e-29   NR HUB93397.1 2499141 g7600 i0 66.3 2.97609561752988 83 28 99.2 0 1 249 185 267 HUB93397.1 ABC transporter permease [Verrucomicrobiia bacterium] diamond 747 115 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
27390150 27390150 PRJNA1262902_P_NODE_7403_length_251_cov_0.865169_g7361_i0 PRJNA1262902 7403 251 0.865169 2.17157419 Gemmataceae bacterium 2052164 Bacteria Bacteria 89.4 9.57e-19   NR HMC89491.1 2052164 g7361 i0 64.9 3.83665338645418 77 26 90.8 1 235 8 46 122 HMC89491.1 hypothetical protein [Gemmataceae bacterium] diamond 963 89.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27976055 27976055 PRJNA1262902_P_NODE_8065_length_250_cov_0.870056_g8023_i0 PRJNA1262902 8065 250 0.870056 2.17514 Gimesia 1649453 Bacteria Bacteria 103 1.5e-23   NR WP_299467522.1 1678688 g8023 i0 61.4 12.768 83 32 99.6 0 1 249 449 531 WP_299467522.1 adenylate/guanylate cyclase domain-containing protein [uncultured Gimesia sp.] diamond 3192 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Gimesia uncultured Gimesia sp.
28747640 28747640 PRJNA1262902_P_NODE_10187_length_245_cov_0.895349_g10145_i0 PRJNA1262902 10187 245 0.895349 2.19360505 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 69.7 1.23e-11   NR HWE02348.1 2876886 g10145 i0 46.9 0.991836734693878 81 43 99.2 0 243 1 614 694 HWE02348.1 sugar-binding protein [Tepidisphaeraceae bacterium] diamond 243 69.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
28905246 28905246 PRJNA1262902_P_NODE_10328_length_245_cov_0.895349_g10286_i0 PRJNA1262902 10328 245 0.895349 2.19360505 Gemmataceae bacterium 2052164 Bacteria Bacteria 40.8 0.0195   NR HKB34894.1 2052164 g10286 i0 66.7 0.330612244897959 27 9 33.1 0 75 155 21 47 HKB34894.1 hypothetical protein [Gemmataceae bacterium] diamond 81 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29126794 29126794 PRJNA1262902_P_NODE_9189_length_247_cov_0.885057_g9147_i0 PRJNA1262902 9189 247 0.885057 2.18609079 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 6.55e-4   NR MCX6902751.1 2026799 g9147 i0 35.1 0.692307692307692 57 30 69.2 1 47 217 240 289 MCX6902751.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 171 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29333823 29333823 PRJNA1262902_P_NODE_9549_length_246_cov_1.774566_g9507_i0 PRJNA1262902 9549 246 1.774566 4.36543236 PVC group 1783257 Bacteria Bacteria 116 2.0099999999999999e-28   NR HXI82039.1 2499141 g9507 i0 62.9 2.10975609756098 89 26 100 2 1 246 283 371 HXI82039.1 pilus assembly protein TadG-related protein [Verrucomicrobiia bacterium] diamond 519 117 0.991452991452991 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29379165 29379165 PRJNA1262902_P_NODE_2649_length_328_cov_1.172549_g2607_i0 PRJNA1262902 2649 328 1.172549 3.84596072 Zavarzinella sp. 1914240 Bacteria Bacteria 81.6 1.82e-15   NR MEZ6142557.1 1914240 g2607 i0 63.8 0.530487804878049 58 21 53 0 154 327 31 88 MEZ6142557.1 restriction endonuclease subunit S [Zavarzinella sp.] diamond 174 81.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Zavarzinella Zavarzinella sp.
30136705 30136705 PRJNA1262902_P_NODE_5352_length_274_cov_1.149254_g5310_i0 PRJNA1262902 5352 274 1.149254 3.14895596 Planctomycetota bacterium 2026780 Bacteria Bacteria 133 2.8e-37   NR MEX1024664.1 2026780 g5310 i0 64.8 3.98540145985401 91 32 99.6 0 1 273 22 112 MEX1024664.1 cytochrome c [Planctomycetota bacterium] diamond 1092 133 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30610893 30610893 PRJNA1262902_P_NODE_10653_length_244_cov_0.900585_g10611_i0 PRJNA1262902 10653 244 0.900585 2.1974274 Planctomycetota bacterium 2026780 Bacteria Bacteria 145 5.93e-39   NR TXT34838.1 2026780 g10611 i0 94.7 0.934426229508197 76 4 93.4 0 243 16 481 556 TXT34838.1 MAG: ATP-dependent RNA helicase DeaD [Planctomycetota bacterium] diamond 228 145 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30737266 30737266 PRJNA1262902_P_NODE_8234_length_249_cov_1.312500_g8192_i0 PRJNA1262902 8234 249 1.3125 3.268125 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0281   NR MBN8525566.1 2026780 g8192 i0 42.2 0.771084337349398 64 34 75.9 2 214 26 120 181 MBN8525566.1 glutamyl-tRNA reductase [Planctomycetota bacterium] diamond 192 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30863705 30863705 PRJNA1262902_P_NODE_11714_length_242_cov_0.911243_g11672_i0 PRJNA1262902 11714 242 0.911243 2.20520806 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 125 7.01e-33   NR MDP9292101.1 2026799 g11672 i0 74.7 1.97107438016529 79 20 97.9 0 4 240 77 155 MDP9292101.1 glycosyltransferase family 2 protein [Verrucomicrobiota bacterium] diamond 477 125 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31021795 31021795 PRJNA1262902_P_NODE_9415_length_247_cov_0.885057_g9373_i0 PRJNA1262902 9415 247 0.885057 2.18609079 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 67.4 7.56e-11   NR HEV7301962.1 2876886 g9373 i0 86.1 0.437246963562753 36 5 43.7 0 247 140 366 401 HEV7301962.1 sugar transferase [Tepidisphaeraceae bacterium] diamond 108 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31622440 31622440 PRJNA1262902_P_NODE_9816_length_246_cov_0.890173_g9774_i0 PRJNA1262902 9816 246 0.890173 2.18982558 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 100 1.01e-22   NR MBV9126863.1 2026799 g9774 i0 67.1 1 82 27 100 0 246 1 361 442 MBV9126863.1 TolC family protein [Verrucomicrobiota bacterium] diamond 246 100 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32051601 32051601 PRJNA1262902_P_NODE_6298_length_262_cov_1.391534_g6256_i0 PRJNA1262902 6298 262 1.391534 3.64581908 PVC group 1783257 Bacteria Bacteria 86.3 1.44e-17   NR HPM80193.1 2699742 g6256 i0 50 1.87786259541985 82 41 93.9 0 15 260 202 283 HPM80193.1 tetratricopeptide repeat protein [Candidatus Anammoximicrobium sp.] diamond 492 86.7 0.995386389850058 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Candidatus Anammoximicrobium Candidatus Anammoximicrobium sp.
32160487 32160487 PRJNA1262902_P_NODE_10258_length_245_cov_0.895349_g10216_i0 PRJNA1262902 10258 245 0.895349 2.19360505 Gemmataceae bacterium 2052164 Bacteria Bacteria 139 2.62e-40   NR HEY1378861.1 2052164 g10216 i0 89 1.00408163265306 82 8 99.2 1 1 243 33 114 HEY1378861.1 BlaI/MecI/CopY family transcriptional regulator [Gemmataceae bacterium] diamond 246 139 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32445304 32445304 PRJNA1262902_P_NODE_5659_length_270_cov_1.208122_g5617_i0 PRJNA1262902 5659 270 1.208122 3.2619294 Phycisphaerales bacterium 2052180 Bacteria Bacteria 72.8 1.33e-12   NR TVQ60604.1 2052180 g5617 i0 47.7 1.67777777777778 88 46 97.8 0 265 2 164 251 TVQ60604.1 MAG: hypothetical protein EA378_10980 [Phycisphaerales bacterium] diamond 453 72.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;