RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJEB81171 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
139411 139411 PRJEB81171_P_NODE_6061_length_278_cov_1.258537_g5934_i0 PRJEB81171 6061 278 1.258537 3.49873286 Opitutaceae bacterium 2006848 Bacteria Bacteria 158 7.36e-46   NR MDD2765758.1 2006848 g5934 i0 83.5 0.982014388489209 91 15 98.2 0 274 2 127 217 MDD2765758.1 MaoC/PaaZ C-terminal domain-containing protein [Opitutaceae bacterium] diamond 273 158 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
6099801 6099801 PRJEB81171_P_NODE_6805_length_266_cov_1.404145_g6678_i0 PRJEB81171 6805 266 1.404145 3.7350257 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 77 4.38e-14   NR MBM3861047.1 2026799 g6678 i0 50 0.992481203007519 88 42 97 1 260 3 835 922 MBM3861047.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 264 77 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
21816106 21816106 PRJEB81171_P_NODE_378_length_1033_cov_1.288542_g295_i0 PRJEB81171 378 1033 1.288542 13.31063886 Candidatus Protochlamydia naegleriophila 389348 Bacteria Bacteria 431 1.46e-144   NR WP_059059927.1 389348 g295 i0 62.5 9.38625363020329 323 114 93.8 3 1031 63 275 590 WP_059059927.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Protochlamydia naegleriophila] diamond 9696 431 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia naegleriophila
26717274 26717274 PRJEB81171_P_NODE_6021_length_278_cov_2.282927_g5894_i0 PRJEB81171 6021 278 2.282927 6.34653706 Planctomycetota bacterium 2026780 Bacteria Bacteria 82 4.27e-16   NR MCP4609751.1 2026780 g5894 i0 50 1.78057553956835 84 41 89.6 1 253 5 234 317 MCP4609751.1 sulfotransferase [Planctomycetota bacterium] diamond 495 82 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27097411 27097411 PRJEB81171_P_NODE_5622_length_285_cov_0.985849_g5495_i0 PRJEB81171 5622 285 0.985849 2.80966965 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 58.5 1.56e-7   NR MFN0198965.1 2026779 g5495 i0 33.3 0.947368421052632 90 59 94.7 1 14 283 23 111 MFN0198965.1 hypothetical protein [Planctomycetaceae bacterium] diamond 270 58.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27539909 27539909 PRJEB81171_P_NODE_7404_length_256_cov_1.699454_g7277_i0 PRJEB81171 7404 256 1.699454 4.35060224 Pirellulaceae bacterium 2699754 Bacteria Bacteria 58.9 1.21e-8   NR HEY6564530.1 2699754 g7277 i0 68.4 1.32421875 38 12 44.5 0 130 243 3 40 HEY6564530.1 6-carboxytetrahydropterin synthase [Pirellulaceae bacterium] diamond 339 58.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27855498 27855498 PRJEB81171_P_NODE_665_length_797_cov_2.678177_g555_i0 PRJEB81171 665 797 2.678177 21.34507069 Pirellulaceae bacterium 2699754 Bacteria Bacteria 77 7.02e-12   NR MFM8407616.1 2699754 g555 i0 32.3 1.88958594730238 251 140 84.7 11 724 50 141 387 MFM8407616.1 SdrD B-like domain-containing protein [Pirellulaceae bacterium] diamond 1506 77 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
27981910 27981910 PRJEB81171_P_NODE_7725_length_253_cov_0.866667_g7598_i0 PRJEB81171 7725 253 0.866667 2.19266751 Gemmataceae bacterium 2052164 Bacteria Bacteria 101 8.13e-23   NR HMC65002.1 2052164 g7598 i0 58.8 0.948616600790514 80 33 94.9 0 10 249 214 293 HMC65002.1 vWA domain-containing protein [Gemmataceae bacterium] diamond 240 101 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28732393 28732393 PRJEB81171_P_NODE_427_length_977_cov_2.418142_g340_i0 PRJEB81171 427 977 2.418142 23.62524734 Planctomycetia 203683 Bacteria Bacteria 55.5 2.25e-4   NR MFM8580792.1 2026779 g340 i0 48.6 1.41555783009212 70 35 21.5 1 308 99 424 492 MFM8580792.1 collagen binding domain-containing protein [Planctomycetaceae bacterium] diamond 1383 55.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28921639 28921639 PRJEB81171_P_NODE_1248_length_589_cov_1.982558_g1126_i0 PRJEB81171 1248 589 1.982558 11.67726662 Bacteria 2 Bacteria Bacteria 101 5.71e-21   NR QOJ04281.1 2052181 g1126 i0 41.7 2.80135823429542 151 76 75.9 4 581 135 334 474 QOJ04281.1 MAG: hypothetical protein HRU71_12640 [Planctomycetia bacterium] diamond 1650 102 0.990196078431373 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
30571148 30571148 PRJEB81171_P_NODE_6293_length_274_cov_1.532338_g6166_i0 PRJEB81171 6293 274 1.532338 4.19860612 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 47 0.00163   NR QYK46985.1 2026777 g6166 i0 32.9 0.897810218978102 82 36 84.3 2 41 271 135 202 QYK46985.1 MAG: isoprenylcysteine carboxylmethyltransferase family protein [Phycisphaeraceae bacterium] diamond 246 47 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
31171438 31171438 PRJEB81171_P_NODE_8015_length_251_cov_1.353933_g7888_i0 PRJEB81171 8015 251 1.353933 3.39837183 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.5 0.0213   NR MBN8643811.1 2026780 g7888 i0 41.5 0.633466135458167 53 26 59.8 2 74 223 284 334 MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 159 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31298125 31298125 PRJEB81171_P_NODE_7875_length_252_cov_0.871508_g7748_i0 PRJEB81171 7875 252 0.871508 2.19620016 Planctomycetota bacterium 2026780 Bacteria Bacteria 75.1 1.58e-13   NR MBI5765270.1 2026780 g7748 i0 100 0.404761904761905 34 0 40.5 0 1 102 397 430 MBI5765270.1 beta-ketoacyl-[acyl-carrier-protein] synthase family protein [Planctomycetota bacterium] diamond 102 75.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31519748 31519748 PRJEB81171_P_NODE_6716_length_267_cov_3.860825_g6589_i0 PRJEB81171 6716 267 3.860825 10.30840275 Phycisphaerales bacterium 2052180 Bacteria Bacteria 118 3.21e-32   NR MBE2293297.1 2052180 g6589 i0 70.2 5.68539325842697 84 25 94.4 0 15 266 3 86 MBE2293297.1 group 1 truncated hemoglobin [Phycisphaerales bacterium] diamond 1518 118 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
31899185 31899185 PRJEB81171_P_NODE_7897_length_252_cov_0.871508_g7770_i0 PRJEB81171 7897 252 0.871508 2.19620016 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 48.9 2.41e-4   NR MDF1813063.1 2026801 g7770 i0 36.3 2.08333333333333 91 40 100 3 252 1 65 144 MDF1813063.1 carbonic anhydrase family protein [Verrucomicrobiales bacterium] diamond 525 48.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32088977 32088977 PRJEB81171_P_NODE_8958_length_247_cov_0.896552_g8831_i0 PRJEB81171 8958 247 0.896552 2.21448344 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 44.7 0.00839   NR MBX3390531.1 2026777 g8831 i0 38.1 1.02024291497976 84 47 97.2 3 244 5 298 380 MBX3390531.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 252 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
32721086 32721086 PRJEB81171_P_NODE_7200_length_260_cov_1.117647_g7073_i0 PRJEB81171 7200 260 1.117647 2.9058822 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.7 0.0325   NR MEI6341235.1 2026799 g7073 i0 39.7 0.669230769230769 58 33 64.6 1 208 41 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;