RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1093380 · 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
11222647 11222647 PRJNA1093380_P_NODE_16329_length_242_cov_1.615385_g16223_i0 PRJNA1093380 16329 242 1.615385 3.9092317 Chlamydiales bacterium 2047757 Bacteria Bacteria 149 1.9199999999999998e-42   NR MFI5334950.1 2047757 g16223 i0 92.5 3.96694214876033 80 6 99.2 0 2 241 178 257 MFI5334950.1 succinate--CoA ligase subunit alpha [Chlamydiales bacterium] diamond 960 149 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
19324841 19324841 PRJNA1093380_P_NODE_1716_length_429_cov_1.283708_g1610_i0 PRJNA1093380 1716 429 1.283708 5.50710732 Pseudomonadati 3379134 Bacteria Bacteria 139 3.1999999999999995e-36   NR MBS0623645.1 2026799 g1610 i0 53.8 3 143 46 99.3 4 427 2 79 202 MBS0623645.1 tryptophan--tRNA ligase [Verrucomicrobiota bacterium] diamond 1287 140 0.992857142857143 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26624376 26624376 PRJNA1093380_P_NODE_14281_length_246_cov_2.242775_g14175_i0 PRJNA1093380 14281 246 2.242775 5.5172265 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.3 0.00913   NR TMP96329.1 2026799 g14175 i0 44.4 0.658536585365854 54 29 65.9 1 84 245 39 91 TMP96329.1 MAG: porin family protein, partial [Verrucomicrobiota bacterium] diamond 162 44.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26940934 26940934 PRJNA1093380_P_NODE_11002_length_256_cov_1.683060_g10896_i0 PRJNA1093380 11002 256 1.68306 4.3086336 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 159 1.26e-45   NR RYD65414.1 2026800 g10896 i0 81.2 0.99609375 85 16 99.6 0 1 255 245 329 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 255 159 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27004212 27004212 PRJNA1093380_P_NODE_15242_length_245_cov_0.895349_g15136_i0 PRJNA1093380 15242 245 0.895349 2.19360505 Opitutaceae bacterium 2006848 Bacteria Bacteria 107 1.84e-26   NR MBC7368709.1 2006848 g15136 i0 69.1 0.991836734693878 81 25 99.2 0 244 2 165 245 MBC7368709.1 hypothetical protein [Opitutaceae bacterium] diamond 243 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
27352329 27352329 PRJNA1093380_P_NODE_8203_length_272_cov_1.547739_g8097_i0 PRJNA1093380 8203 272 1.547739 4.20985008 Opitutales bacterium 2026772 Bacteria Bacteria 45.4 0.00594   NR MCC5835478.1 2026772 g8097 i0 42.9 0.463235294117647 42 24 46.3 0 129 4 137 178 MCC5835478.1 DUF3488 domain-containing protein [Opitutales bacterium] diamond 126 45.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
27573137 27573137 PRJNA1093380_P_NODE_17004_length_241_cov_0.916667_g16898_i0 PRJNA1093380 17004 241 0.916667 2.20916747 Chlamydiales bacterium 2047757 Bacteria Bacteria 127 3.48e-33   NR MFI5335116.1 2047757 g16898 i0 78.5 0.983402489626556 79 17 98.3 0 3 239 12 90 MFI5335116.1 helix-hairpin-helix domain-containing protein [Chlamydiales bacterium] diamond 237 127 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
28299265 28299265 PRJNA1093380_P_NODE_8286_length_272_cov_0.909548_g8180_i0 PRJNA1093380 8286 272 0.909548 2.47397056 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.9 0.0187   NR MBN1809450.1 2026780 g8180 i0 42.6 0.672794117647059 61 28 61.8 3 36 203 52 110 MBN1809450.1 helix-turn-helix transcriptional regulator [Planctomycetota bacterium] diamond 183 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28899058 28899058 PRJNA1093380_P_NODE_8388_length_271_cov_1.494949_g8282_i0 PRJNA1093380 8388 271 1.494949 4.05131179 Chlamydiales bacterium 2047757 Bacteria Bacteria 153 6.6e-45   NR MFI5333839.1 2047757 g8282 i0 80 0.996309963099631 90 18 99.6 0 2 271 85 174 MFI5333839.1 hypothetical protein [Chlamydiales bacterium] diamond 270 153 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
29206553 29206553 PRJNA1093380_P_NODE_17329_length_237_cov_3.475610_g17223_i0 PRJNA1093380 17329 237 3.47561 8.2371957 Singulisphaera 466152 Bacteria Bacteria 80.9 1.03e-15   NR WP_074317405.1 1882752 g17223 i0 56.4 4.93670886075949 78 34 98.7 0 236 3 40 117 WP_074317405.1 3-dehydroquinate synthase [Singulisphaera sp. GP187] diamond 1170 81.3 0.995079950799508 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. GP187
29246481 29246481 PRJNA1093380_P_NODE_12389_length_250_cov_0.870056_g12283_i0 PRJNA1093380 12389 250 0.870056 2.17514 Gemmataceae bacterium 2052164 Bacteria Bacteria 112 3.78e-27   NR HEX5272822.1 2052164 g12283 i0 69.5 0.984 82 24 98.4 1 3 248 176 256 HEX5272822.1 DUF1501 domain-containing protein [Gemmataceae bacterium] diamond 246 112 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29972803 29972803 PRJNA1093380_P_NODE_16731_length_241_cov_2.333333_g16625_i0 PRJNA1093380 16731 241 2.333333 5.62333253 Gemmataceae bacterium 2052164 Bacteria Bacteria 80.9 9.87e-16   NR HZU34943.1 2052164 g16625 i0 51.3 0.995850622406639 80 39 99.6 0 1 240 218 297 HZU34943.1 ATP-binding protein [Gemmataceae bacterium] diamond 240 80.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
30352501 30352501 PRJNA1093380_P_NODE_3892_length_315_cov_1.582645_g3786_i0 PRJNA1093380 3892 315 1.582645 4.98533175 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0221   NR MEI6341235.1 2026799 g3786 i0 41.4 0.552380952380952 58 32 53.3 1 109 276 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30532845 30532845 PRJNA1093380_P_NODE_5093_length_291_cov_1.068807_g4987_i0 PRJNA1093380 5093 291 1.068807 3.11022837 Bacteria 2 Bacteria Bacteria 43.5 0.0362   NR PHX78409.1 2026779 g4987 i0 64 1.03092783505155 25 9 25.8 0 88 162 547 571 PHX78409.1 MAG: hypothetical protein CK544_02960 [Planctomycetaceae bacterium] diamond 300 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31110060 31110060 PRJNA1093380_P_NODE_15895_length_243_cov_1.388235_g15789_i0 PRJNA1093380 15895 243 1.388235 3.37341105 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 45.4 0.00409   NR HCE04986.1 2026801 g15789 i0 50 0.54320987654321 44 22 54.3 0 104 235 152 195 HCE04986.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 132 45.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
31141470 31141470 PRJNA1093380_P_NODE_11115_length_255_cov_2.285714_g11009_i0 PRJNA1093380 11115 255 2.285714 5.8285707 Gemmataceae bacterium 2052164 Bacteria Bacteria 60.5 2.57e-8   NR HVK07542.1 2052164 g11009 i0 68.8 1.88235294117647 48 14 55.3 1 141 1 2 49 HVK07542.1 PVC-type heme-binding CxxCH protein [Gemmataceae bacterium] diamond 480 60.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
31458218 31458218 PRJNA1093380_P_NODE_16856_length_241_cov_0.916667_g16750_i0 PRJNA1093380 16856 241 0.916667 2.20916747 Chlamydiales bacterium 2047757 Bacteria Bacteria 137 1.89e-38   NR MFI5333591.1 2047757 g16750 i0 87.3 1.96680497925311 79 10 98.3 0 4 240 142 220 MFI5333591.1 UMP kinase [Chlamydiales bacterium] diamond 474 137 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Chlamydiales     Chlamydiales bacterium
32785634 32785634 PRJNA1093380_P_NODE_15340_length_244_cov_1.801170_g15234_i0 PRJNA1093380 15340 244 1.80117 4.3948548 Gemmataceae bacterium 2052164 Bacteria Bacteria 116 2.33e-28   NR MFL5327527.1 2052164 g15234 i0 68.8 1.95491803278689 80 25 98.4 0 242 3 383 462 MFL5327527.1 aldehyde dehydrogenase family protein [Gemmataceae bacterium] diamond 477 116 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;