RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1089179 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
10398102 10398102 PRJNA1089179_P_NODE_14949_length_249_cov_0.875000_g14931_i0 PRJNA1089179 14949 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 142 2.97e-39   NR RLT10217.1 2026780 g14931 i0 84 0.975903614457831 81 13 97.6 0 248 6 256 336 RLT10217.1 MAG: GDP-mannose 4,6-dehydratase [Planctomycetota bacterium] diamond 243 142 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
16771797 16771797 PRJNA1089179_P_NODE_15534_length_247_cov_0.885057_g15516_i0 PRJNA1089179 15534 247 0.885057 2.18609079 Bacteria 2 Bacteria Bacteria 152 3.8700000000000003e-44   NR MEO0530835.1 2026780 g15516 i0 88.9 11.8056680161943 81 9 98.4 0 3 245 74 154 MEO0530835.1 peptide chain release factor-like protein [Planctomycetota bacterium] diamond 2916 153 0.993464052287582 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26592474 26592474 PRJNA1089179_P_NODE_15701_length_246_cov_1.231214_g15683_i0 PRJNA1089179 15701 246 1.231214 3.02878644 Pirellulaceae bacterium 2699754 Bacteria Bacteria 48.1 4.69e-4   NR MBX3421965.1 2699754 g15683 i0 34.2 0.963414634146341 79 49 95.1 2 5 238 38 114 MBX3421965.1 hypothetical protein [Pirellulaceae bacterium] diamond 237 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
26710444 26710444 PRJNA1089179_P_NODE_15521_length_247_cov_0.885057_g15503_i0 PRJNA1089179 15521 247 0.885057 2.18609079 PVC group 1783257 Bacteria Bacteria 55.8 9.85e-7   NR TVP96468.1 2026779 g15503 i0 35.4 5.96356275303644 82 53 99.6 0 1 246 2195 2276 TVP96468.1 MAG: amino acid adenylation domain-containing protein [Planctomycetaceae bacterium] diamond 1473 55.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27225381 27225381 PRJNA1089179_P_NODE_17363_length_241_cov_0.916667_g17345_i0 PRJNA1089179 17363 241 0.916667 2.20916747 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 70.1 8.55e-12   NR MBX3439950.1 2026779 g17345 i0 45.9 1.81742738589212 74 40 92.1 0 1 222 636 709 MBX3439950.1 pre-peptidase C-terminal domain-containing protein [Planctomycetaceae bacterium] diamond 438 70.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28235829 28235829 PRJNA1089179_P_NODE_14646_length_250_cov_0.870056_g14628_i0 PRJNA1089179 14646 250 0.870056 2.17514 Planctomycetales bacterium 2053591 Bacteria Bacteria 97.4 4.52e-22   NR MCA9131604.1 2053591 g14628 i0 64.6 0.948 79 28 94.8 0 13 249 140 218 MCA9131604.1 CPBP family intramembrane metalloprotease [Planctomycetales bacterium] diamond 237 97.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales     Planctomycetales bacterium
28552013 28552013 PRJNA1089179_P_NODE_16687_length_243_cov_0.905882_g16669_i0 PRJNA1089179 16687 243 0.905882 2.20129326 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 154 1.62e-41   NR MBL8812310.1 2026779 g16669 i0 98.8 0.987654320987654 80 1 98.8 0 3 242 829 908 MBL8812310.1 efflux RND transporter permease subunit [Planctomycetaceae bacterium] diamond 240 154 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
28898992 28898992 PRJNA1089179_P_NODE_16968_length_242_cov_0.911243_g16950_i0 PRJNA1089179 16968 242 0.911243 2.20520806 Pirellula sp. 117 Bacteria Bacteria 104 3e-24   NR MEQ1827485.1 117 g16950 i0 59.8 2.00826446280992 82 31 99.2 1 1 240 238 319 MEQ1827485.1 PDZ domain-containing protein [Pirellula sp.] diamond 486 104 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
29372806 29372806 PRJNA1089179_P_NODE_15569_length_247_cov_0.885057_g15551_i0 PRJNA1089179 15569 247 0.885057 2.18609079 Planctomyces sp. 37635 Bacteria Bacteria 46.6 0.00173   NR MFN6330462.1 37635 g15551 i0 38.1 0.765182186234818 63 39 76.5 0 59 247 315 377 MFN6330462.1 LPD1 domain-containing protein [Planctomyces sp.] diamond 189 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
29530705 29530705 PRJNA1089179_P_NODE_15550_length_247_cov_0.885057_g15532_i0 PRJNA1089179 15550 247 0.885057 2.18609079 Planctomycetota bacterium 2026780 Bacteria Bacteria 141 5.02e-41   NR MBM3963784.1 2026780 g15532 i0 86.6 8.91497975708502 82 11 99.6 0 2 247 45 126 MBM3963784.1 flagellar motor switch protein FliN [Planctomycetota bacterium] diamond 2202 141 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30383906 30383906 PRJNA1089179_P_NODE_15033_length_249_cov_0.875000_g15015_i0 PRJNA1089179 15033 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 166 1.75e-48   NR MFN9720045.1 2026780 g15015 i0 91.5 0.987951807228916 82 7 98.8 0 247 2 72 153 MFN9720045.1 hypothetical protein [Planctomycetota bacterium] diamond 246 166 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30478384 30478384 PRJNA1089179_P_NODE_15193_length_248_cov_0.880000_g15175_i0 PRJNA1089179 15193 248 0.88 2.1824 Planctomycetota bacterium 2026780 Bacteria Bacteria 136 2.4499999999999997e-37   NR MCY2982318.1 2026780 g15175 i0 78 0.991935483870968 82 18 99.2 0 1 246 38 119 MCY2982318.1 hypothetical protein [Planctomycetota bacterium] diamond 246 136 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30564166 30564166 PRJNA1089179_P_NODE_14933_length_249_cov_0.875000_g14915_i0 PRJNA1089179 14933 249 0.875 2.17875 Pirellula 123 Bacteria Bacteria 97.1 1.33e-21   NR MFN7734236.1 117 g14915 i0 59.5 2.69879518072289 74 30 89.2 0 248 27 246 319 MFN7734236.1 HlyD family secretion protein [Pirellula sp.] diamond 672 97.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
30636050 30636050 PRJNA1089179_P_NODE_16973_length_242_cov_0.911243_g16955_i0 PRJNA1089179 16973 242 0.911243 2.20520806 Planctomycetota bacterium 2026780 Bacteria Bacteria 120 1.3399999999999998e-32   NR MFN9720278.1 2026780 g16955 i0 72.2 0.979338842975207 79 22 97.9 0 1 237 25 103 MFN9720278.1 hypothetical protein [Planctomycetota bacterium] diamond 237 120 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30983986 30983986 PRJNA1089179_P_NODE_17214_length_241_cov_0.916667_g17196_i0 PRJNA1089179 17214 241 0.916667 2.20916747 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 48.1 4.46e-4   NR HQX50129.1 2026779 g17196 i0 37 0.908713692946058 73 45 89.6 1 217 2 60 132 HQX50129.1 hypothetical protein [Planctomycetaceae bacterium] diamond 219 48.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
31015392 31015392 PRJNA1089179_P_NODE_14375_length_251_cov_0.865169_g14357_i0 PRJNA1089179 14375 251 0.865169 2.17157419 Pirellulales bacterium 2715253 Bacteria Bacteria 73.6 8.56e-15   NR MFO0923454.1 2715253 g14357 i0 75.6 0.49003984063745 41 10 49 0 249 127 60 100 MFO0923454.1 hypothetical protein [Pirellulales bacterium] diamond 123 73.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32407162 32407162 PRJNA1089179_P_NODE_16659_length_243_cov_0.905882_g16641_i0 PRJNA1089179 16659 243 0.905882 2.20129326 Stieleria varia 2528005 Bacteria Bacteria 129 1.68e-35   NR WP_146520151.1 2528005 g16641 i0 80 2.96296296296296 80 16 98.8 0 2 241 56 135 WP_146520151.1 RNA polymerase sigma factor [Stieleria varia] diamond 720 129 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Stieleria Stieleria varia
32628118 32628118 PRJNA1089179_P_NODE_17220_length_241_cov_0.916667_g17202_i0 PRJNA1089179 17220 241 0.916667 2.20916747 Pirellulales bacterium 2715253 Bacteria Bacteria 90.9 1.7e-19   NR MFO0921921.1 2715253 g17202 i0 60 1.99170124481328 80 31 98.3 1 239 3 51 130 MFO0921921.1 Mrp/NBP35 family ATP-binding protein [Pirellulales bacterium] diamond 480 90.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32659498 32659498 PRJNA1089179_P_NODE_14760_length_250_cov_0.870056_g14742_i0 PRJNA1089179 14760 250 0.870056 2.17514 Pirellulales bacterium 2715253 Bacteria Bacteria 95.1 1.52e-20   NR MFO0924060.1 2715253 g14742 i0 53.7 0.984 82 37 98.4 1 248 3 342 422 MFO0924060.1 matrixin family metalloprotease [Pirellulales bacterium] diamond 246 95.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32880126 32880126 PRJNA1089179_P_NODE_14660_length_250_cov_0.870056_g14642_i0 PRJNA1089179 14660 250 0.870056 2.17514 Planctomycetota bacterium 2026780 Bacteria Bacteria 126 1.19e-31   NR MFN9719641.1 2026780 g14642 i0 75.9 0.996 83 20 99.6 0 2 250 473 555 MFN9719641.1 Gldg family protein [Planctomycetota bacterium] diamond 249 126 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;