RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA983848 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
12449170 12449170 PRJNA983848_P_NODE_58510_length_430_cov_3.243697_g52629_i0 PRJNA983848 58510 430 3.243697 13.9478971 Planctomycetia 203683 Bacteria Bacteria 118 2.91e-30   NR MDR0521560.1 2026779 g52629 i0 67.1 3.38372093023256 79 26 55.1 0 237 1 6 84 MDR0521560.1 peroxiredoxin [Planctomycetaceae bacterium] diamond 1455 119 0.991596638655462 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
22645917 22645917 PRJNA983848_P_NODE_28078_length_867_cov_3.537783_g22648_i0 PRJNA983848 28078 867 3.537783 30.67257861 Bacteria 2 Bacteria Bacteria 106 1.5e-21   NR MCG8429548.1 2035772 g22648 i0 28.9 2.75086505190311 266 174 88.6 3 3 770 348 608 MCG8429548.1 endonuclease/exonuclease/phosphatase family protein [Candidatus Omnitrophota bacterium] diamond 2385 106 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
25193795 25193795 PRJNA983848_P_NODE_141860_length_251_cov_0.876404_g135977_i0 PRJNA983848 141860 251 0.876404 2.19977404 Pirellulales bacterium 2715253 Bacteria Bacteria 140 6.239999999999999e-38   NR MBX7168867.1 2715253 g135977 i0 79.5 4.9601593625498 83 17 99.2 0 249 1 7 89 MBX7168867.1 tryptophan synthase subunit beta [Pirellulales bacterium] diamond 1245 140 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
27158444 27158444 PRJNA983848_P_NODE_144142_length_250_cov_0.881356_g138259_i0 PRJNA983848 144142 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 138 1.27e-40   NR MBX3379435.1 2026777 g138259 i0 87.8 2.664 74 9 88.8 0 222 1 1 74 MBX3379435.1 hypothetical protein [Phycisphaeraceae bacterium] diamond 666 138 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
27531923 27531923 PRJNA983848_P_NODE_96923_length_308_cov_2.119149_g91040_i0 PRJNA983848 96923 308 2.119149 6.52697892 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 42.7 0.0212   NR HXT83479.1 2499141 g91040 i0 47.5 0.38961038961039 40 21 39 0 150 31 55 94 HXT83479.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 120 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
28011701 28011701 PRJNA983848_P_NODE_67245_length_388_cov_3.888889_g61362_i0 PRJNA983848 67245 388 3.888889 15.08888932 Candidatus Scalindua 236756 Bacteria Bacteria 83.2 1.44e-16   NR MCP5002365.1 2026780 g61362 i0 56.3 2.47422680412371 64 28 49.5 0 193 2 84 147 MCP5002365.1 hypothetical protein [Planctomycetota bacterium] diamond 960 83.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28194778 28194778 PRJNA983848_P_NODE_155366_length_244_cov_1.309942_g149483_i0 PRJNA983848 155366 244 1.309942 3.19625848 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 6.2e-4   NR MEO0454925.1 2026799 g149483 i0 47.8 0.565573770491803 46 23 56.6 1 173 36 175 219 MEO0454925.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 138 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28289525 28289525 PRJNA983848_P_NODE_160106_length_242_cov_0.923077_g154223_i0 PRJNA983848 160106 242 0.923077 2.23384634 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 123 6.2e-33   NR NDF17446.1 2026799 g154223 i0 69.1 1.00413223140496 81 24 99.2 1 3 242 91 171 NDF17446.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 243 123 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28605430 28605430 PRJNA983848_P_NODE_60167_length_421_cov_1.979885_g54285_i0 PRJNA983848 60167 421 1.979885 8.33531585 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 45.1 0.0284   NR TMP98142.1 2026799 g54285 i0 51.3 0.27790973871734 39 18 27.8 1 114 230 183 220 TMP98142.1 MAG: prepilin-type N-terminal cleavage/methylation domain-containing protein [Verrucomicrobiota bacterium] diamond 117 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28763175 28763175 PRJNA983848_P_NODE_145067_length_249_cov_1.534091_g139184_i0 PRJNA983848 145067 249 1.534091 3.81988659 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 43.9 0.015   NR HTX58466.1 2499141 g139184 i0 54.1 0.44578313253012 37 14 41 1 63 164 311 347 HTX58466.1 DUF1565 domain-containing protein [Verrucomicrobiia bacterium] diamond 111 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29300053 29300053 PRJNA983848_P_NODE_150529_length_246_cov_2.369942_g144646_i0 PRJNA983848 150529 246 2.369942 5.83005732 Candidatus Scalindua sp. 2268189 Bacteria Bacteria 54.3 8.3e-7   NR MCP4252926.1 2268189 g144646 i0 38.6 0.853658536585366 70 38 79.3 1 18 212 54 123 MCP4252926.1 hypothetical protein [Candidatus Scalindua sp.] diamond 210 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Scalinduaceae Candidatus Scalindua Candidatus Scalindua sp.
29710156 29710156 PRJNA983848_P_NODE_142390_length_251_cov_0.876404_g136507_i0 PRJNA983848 142390 251 0.876404 2.19977404 Planctomycetota bacterium 2026780 Bacteria Bacteria 52.4 1.51e-5   NR MCL5278727.1 2026780 g136507 i0 60 1.01593625498008 35 14 41.8 0 251 147 74 108 MCL5278727.1 NHL repeat-containing protein [Planctomycetota bacterium] diamond 255 52.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29710168 29710168 PRJNA983848_P_NODE_86890_length_329_cov_1.863281_g81007_i0 PRJNA983848 86890 329 1.863281 6.13019449 Planctomycetota bacterium 2026780 Bacteria Bacteria 76.3 3.17e-14   NR MCP5002365.1 2026780 g81007 i0 65.3 0.446808510638298 49 17 44.7 0 149 3 130 178 MCP5002365.1 hypothetical protein [Planctomycetota bacterium] diamond 147 76.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29836750 29836750 PRJNA983848_P_NODE_72831_length_368_cov_1.694915_g66948_i0 PRJNA983848 72831 368 1.694915 6.2372872 Planctomycetota bacterium 2026780 Bacteria Bacteria 115 5.09e-29   NR MCP5002365.1 2026780 g66948 i0 71.6 0.603260869565217 74 21 60.3 0 145 366 113 186 MCP5002365.1 hypothetical protein [Planctomycetota bacterium] diamond 222 115 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29931764 29931764 PRJNA983848_P_NODE_159711_length_242_cov_0.923077_g153828_i0 PRJNA983848 159711 242 0.923077 2.23384634 Candidatus Didemnitutus sp. 2814259 Bacteria Bacteria 130 3.18e-33   NR HET7535355.1 2814259 g153828 i0 76.3 0.991735537190083 80 19 99.2 0 2 241 126 205 HET7535355.1 SulP family inorganic anion transporter [Candidatus Didemnitutus sp.] diamond 240 130 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Candidatus Didemnitutus Candidatus Didemnitutus sp.
30089455 30089455 PRJNA983848_P_NODE_140612_length_251_cov_2.651685_g134729_i0 PRJNA983848 140612 251 2.651685 6.65572935 Phycisphaerae bacterium 2026778 Bacteria Bacteria 44.7 0.00862   NR HUU82256.1 2026778 g134729 i0 41.2 1.73306772908367 51 30 61 0 49 201 87 137 HUU82256.1 hydantoinase/oxoprolinase family protein [Phycisphaerae bacterium] diamond 435 44.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30342830 30342830 PRJNA983848_P_NODE_143632_length_250_cov_0.881356_g137749_i0 PRJNA983848 143632 250 0.881356 2.20339 Opitutus terrae 107709 Bacteria Bacteria 58.2 1.53e-7   NR WP_012374816.1 107709 g137749 i0 49.3 0.804 67 34 80.4 0 222 22 718 784 WP_012374816.1 hypothetical protein [Opitutus terrae] diamond 201 58.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
30689751 30689751 PRJNA983848_P_NODE_109493_length_287_cov_3.757009_g103610_i0 PRJNA983848 109493 287 3.757009 10.78261583 Planctomycetota bacterium 2026780 Bacteria Bacteria 62 1.06e-8   NR MCP5007393.1 2026780 g103610 i0 56.1 0.689895470383275 66 27 66.9 2 93 284 43 108 MCP5007393.1 hypothetical protein [Planctomycetota bacterium] diamond 198 62 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31005808 31005808 PRJNA983848_P_NODE_72854_length_368_cov_1.583051_g66971_i0 PRJNA983848 72854 368 1.583051 5.82562768 Planctomycetota bacterium 2026780 Bacteria Bacteria 45.4 0.00815   NR MEL6899292.1 2026780 g66971 i0 60.5 0.309782608695652 38 15 31 0 215 102 75 112 MEL6899292.1 reverse transcriptase family protein [Planctomycetota bacterium] diamond 114 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31037735 31037735 PRJNA983848_P_NODE_158315_length_243_cov_0.917647_g152432_i0 PRJNA983848 158315 243 0.917647 2.22988221 Planctomycetota bacterium 2026780 Bacteria Bacteria 135 1.62e-38   NR MBN8596286.1 2026780 g152432 i0 100 0.91358024691358 74 0 91.4 0 2 223 79 152 MBN8596286.1 Hsp20/alpha crystallin family protein [Planctomycetota bacterium] diamond 222 135 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31353558 31353558 PRJNA983848_P_NODE_114356_length_281_cov_1.307692_g108473_i0 PRJNA983848 114356 281 1.307692 3.67461452 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00362   NR MBI4661175.1 2026799 g108473 i0 36.2 0.736654804270463 69 39 68.3 2 202 11 704 772 MBI4661175.1 TonB-dependent receptor [Verrucomicrobiota bacterium] diamond 207 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31511867 31511867 PRJNA983848_P_NODE_166136_length_227_cov_2.194805_g160253_i0 PRJNA983848 166136 227 2.194805 4.98220735 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 45.4 0.00345   NR MBV8233323.1 2026779 g160253 i0 65.5 0.383259911894273 29 10 38.3 0 134 220 911 939 MBV8233323.1 hypothetical protein [Planctomycetaceae bacterium] diamond 87 45.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32807575 32807575 PRJNA983848_P_NODE_122600_length_270_cov_1.583756_g116717_i0 PRJNA983848 122600 270 1.583756 4.2761412 Candidatus Brocadiaceae bacterium 2094028 Bacteria Bacteria 52.8 1.49e-5   NR MCP4267925.1 2094028 g116717 i0 39.7 0.7 63 38 70 0 193 5 425 487 MCP4267925.1 hypothetical protein [Candidatus Brocadiaceae bacterium] diamond 189 52.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae   Candidatus Brocadiaceae 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);;