RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA1156092" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 27 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1156092 · 27 ✖

analysis 1

  • diamond · 27 ✖
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
6140083 6140083 PRJNA1156092_P_NODE_28145_length_245_cov_0.895349_g28015_i0 PRJNA1156092 28145 245 0.895349 2.19360505 Planctomycetota bacterium 2026780 Bacteria Bacteria 100 1.23e-22   NR MED5330494.1 2026780 g28015 i0 65.4 0.991836734693878 81 25 99.2 2 2 244 392 469 MED5330494.1 VCBS repeat-containing protein [Planctomycetota bacterium] diamond 243 100 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
23989443 23989443 PRJNA1156092_P_NODE_22099_length_251_cov_0.865169_g21969_i0 PRJNA1156092 22099 251 0.865169 2.17157419 Planctomycetota bacterium 2026780 Bacteria Bacteria 134 1.78e-35   NR MEO0478996.1 2026780 g21969 i0 69.9 1.9840637450199201 83 25 99.2 0 249 1 223 305 MEO0478996.1 threonine synthase [Planctomycetota bacterium] diamond 498 134 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27166565 27166565 PRJNA1156092_P_NODE_30042_length_243_cov_0.905882_g29912_i0 PRJNA1156092 30042 243 0.905882 2.20129326 Planctomycetota bacterium 2026780 Bacteria Bacteria 47.4 8.69e-4   NR MBI4880967.1 2026780 g29912 i0 35.4 0.802469135802469 65 41 80.2 1 202 8 596 659 MBI4880967.1 sigma-70 family RNA polymerase sigma factor [Planctomycetota bacterium] diamond 195 47.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27451381 27451381 PRJNA1156092_P_NODE_32403_length_241_cov_0.916667_g32273_i0 PRJNA1156092 32403 241 0.916667 2.20916747 Planctomycetota bacterium 2026780 Bacteria Bacteria 87.4 1.59e-19   NR MCH7726647.1 2026780 g32273 i0 78.8 0.647302904564315 52 11 64.7 0 86 241 1 52 MCH7726647.1 hypothetical protein [Planctomycetota bacterium] diamond 156 87.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27723495 27723495 PRJNA1156092_P_NODE_26084_length_247_cov_0.885057_g25954_i0 PRJNA1156092 26084 247 0.885057 2.18609079 Pseudomonadati 3379134 Bacteria Bacteria 139 1.22e-36   NR MEZ6125807.1 2026779 g25954 i0 76.5 8.82995951417004 81 19 98.4 0 246 4 155 235 MEZ6125807.1 FAD-dependent oxidoreductase [Planctomycetaceae bacterium] diamond 2181 139 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
27924763 27924763 PRJNA1156092_P_NODE_25205_length_248_cov_0.880000_g25075_i0 PRJNA1156092 25205 248 0.88 2.1824 Phycisphaerae bacterium 2026778 Bacteria Bacteria 123 6.389999999999998e-32   NR MDP6044673.1 2026778 g25075 i0 73.7 1.83870967741935 76 20 91.9 0 1 228 250 325 MDP6044673.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Phycisphaerae bacterium] diamond 456 123 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28007450 28007450 PRJNA1156092_P_NODE_30785_length_243_cov_0.905882_g30655_i0 PRJNA1156092 30785 243 0.905882 2.20129326 Pseudomonadati 3379134 Bacteria Bacteria 85.1 4.12e-17   NR NLE56912.1 2026780 g30655 i0 63.1 1.7037037037037 65 22 80.2 1 199 5 192 254 NLE56912.1 hypothetical protein [Planctomycetota bacterium] diamond 414 85.9 0.990686845168801 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28145954 28145954 PRJNA1156092_P_NODE_22445_length_251_cov_0.865169_g22315_i0 PRJNA1156092 22445 251 0.865169 2.17157419 Phycisphaerae bacterium 2026778 Bacteria Bacteria 83.2 2.38e-16   NR MEE8170355.1 2026778 g22315 i0 48.1 2.8804780876494 81 36 96.8 1 246 4 82 156 MEE8170355.1 thrombospondin type 3 repeat-containing protein [Phycisphaerae bacterium] diamond 723 83.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28354533 28354533 PRJNA1156092_P_NODE_22066_length_251_cov_0.865169_g21936_i0 PRJNA1156092 22066 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 134 2.56e-34   NR MBL7185247.1 2026778 g21936 i0 72 3.9203187250996 82 23 98 0 246 1 443 524 MBL7185247.1 DUF5060 domain-containing protein [Phycisphaerae bacterium] diamond 984 134 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28891157 28891157 PRJNA1156092_P_NODE_28708_length_245_cov_0.895349_g28578_i0 PRJNA1156092 28708 245 0.895349 2.19360505 Pseudomonadati 3379134 Bacteria Bacteria 62.4 4.5e-9   NR MFC1636791.1 2026780 g28578 i0 82.4 1.24897959183673 34 6 41.6 0 244 143 588 621 MFC1636791.1 asparagine synthase (glutamine-hydrolyzing) [Planctomycetota bacterium] diamond 306 62.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29219431 29219431 PRJNA1156092_P_NODE_31749_length_242_cov_0.911243_g31619_i0 PRJNA1156092 31749 242 0.911243 2.20520806 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 46.6 0.00154   NR MBQ9372758.1 2691551 g31619 i0 49 0.632231404958678 51 25 63.2 1 179 27 128 177 MBQ9372758.1 pentapeptide repeat-containing protein [Thermoguttaceae bacterium] diamond 153 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
29408663 29408663 PRJNA1156092_P_NODE_30609_length_243_cov_0.905882_g30479_i0 PRJNA1156092 30609 243 0.905882 2.20129326 Gemmataceae bacterium 2052164 Bacteria Bacteria 41.6 0.0409   NR MFO0964598.1 2052164 g30479 i0 38 0.617283950617284 50 31 61.7 0 200 51 30 79 MFO0964598.1 hypothetical protein [Gemmataceae bacterium] diamond 150 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29459373 29459373 PRJNA1156092_P_NODE_27330_length_246_cov_0.890173_g27200_i0 PRJNA1156092 27330 246 0.890173 2.18982558 Planctomycetia 203683 Bacteria Bacteria 142 5e-37   NR MAR12834.1 2024826 g27200 i0 79 4.86585365853659 81 17 98.8 0 243 1 726 806 MAR12834.1 cell division protein FtsK [Blastopirellula sp.] diamond 1197 142 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Blastopirellula Blastopirellula sp.
29692559 29692559 PRJNA1156092_P_NODE_27050_length_246_cov_0.890173_g26920_i0 PRJNA1156092 27050 246 0.890173 2.18982558 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 94.4 4.06e-21   NR MCA9061634.1 2026779 g26920 i0 55.6 1.97560975609756 81 36 98.8 0 2 244 132 212 MCA9061634.1 methyltransferase domain-containing protein [Planctomycetaceae bacterium] diamond 486 94.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
29882579 29882579 PRJNA1156092_P_NODE_24691_length_249_cov_0.875000_g24561_i0 PRJNA1156092 24691 249 0.875 2.17875 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 42.4 0.00732   NR HEY2250590.1 2026779 g24561 i0 40 0.481927710843373 40 24 48.2 0 153 34 17 56 HEY2250590.1 hypothetical protein [Planctomycetaceae bacterium] diamond 120 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30166535 30166535 PRJNA1156092_P_NODE_22632_length_251_cov_0.865169_g22502_i0 PRJNA1156092 22632 251 0.865169 2.17157419 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 82.4 4.57e-16   NR MBT6484839.1 2026779 g22502 i0 49.4 1.9840637450199201 83 42 99.2 0 3 251 356 438 MBT6484839.1 hypothetical protein [Planctomycetaceae bacterium] diamond 498 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30229885 30229885 PRJNA1156092_P_NODE_25072_length_248_cov_0.880000_g24942_i0 PRJNA1156092 25072 248 0.88 2.1824 Phycisphaera sp. 2030824 Bacteria Bacteria 70.1 9.51e-12   NR MBI1371809.1 2030824 g24942 i0 54.4 1.79032258064516 68 29 82.3 1 45 248 1129 1194 MBI1371809.1 tandem-95 repeat protein [Phycisphaera sp.] diamond 444 70.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae Phycisphaera Phycisphaera sp.
30545832 30545832 PRJNA1156092_P_NODE_30193_length_243_cov_0.905882_g30063_i0 PRJNA1156092 30193 243 0.905882 2.20129326 Planctomycetota bacterium 2026780 Bacteria Bacteria 100 7.78e-23   NR MCH7799362.1 2026780 g30063 i0 70.6 0.839506172839506 68 20 84 0 26 229 157 224 MCH7799362.1 hypothetical protein [Planctomycetota bacterium] diamond 204 100 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31007586 31007586 PRJNA1156092_P_NODE_29454_length_244_cov_0.900585_g29324_i0 PRJNA1156092 29454 244 0.900585 2.1974274 Roseimaritima 1579506 Bacteria Bacteria 72 1.76e-12   NR WP_238388710.1 980254 g29324 i0 66 3.49180327868852 47 16 57.8 0 242 102 510 556 WP_238388710.1 ATP-binding cassette domain-containing protein [Roseimaritima ulvae] diamond 852 72.4 0.994475138121547 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Roseimaritima Roseimaritima ulvae
31620504 31620504 PRJNA1156092_P_NODE_30436_length_243_cov_0.905882_g30306_i0 PRJNA1156092 30436 243 0.905882 2.20129326 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.9 1.23e-9   NR REJ91543.1 2026780 g30306 i0 45.7 0.864197530864197 70 38 86.4 0 30 239 7 76 REJ91543.1 MAG: hypothetical protein DWQ34_14780 [Planctomycetota bacterium] diamond 210 63.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31715419 31715419 PRJNA1156092_P_NODE_25597_length_248_cov_0.880000_g25467_i0 PRJNA1156092 25597 248 0.88 2.1824 Pirellulaceae bacterium 2699754 Bacteria Bacteria 147 2.6e-41   NR MDP6719945.1 2699754 g25467 i0 86.6 0.991935483870968 82 11 99.2 0 3 248 36 117 MDP6719945.1 DPP IV N-terminal domain-containing protein [Pirellulaceae bacterium] diamond 246 147 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae bacterium
31968407 31968407 PRJNA1156092_P_NODE_25918_length_247_cov_0.885057_g25788_i0 PRJNA1156092 25918 247 0.885057 2.18609079 Planctomycetota bacterium 2026780 Bacteria Bacteria 54.3 3.27e-6   NR MCH8164644.1 2026780 g25788 i0 44.4 1.96761133603239 81 36 98.4 2 2 244 178 249 MCH8164644.1 hypothetical protein [Planctomycetota bacterium] diamond 486 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32000156 32000156 PRJNA1156092_P_NODE_32458_length_241_cov_0.916667_g32328_i0 PRJNA1156092 32458 241 0.916667 2.20916747 Planctomycetota bacterium 2026780 Bacteria Bacteria 124 4.339999999999999e-31   NR MEO0482361.1 2026780 g32328 i0 71.8 7.7551867219917 78 22 97.1 0 6 239 411 488 MEO0482361.1 MmgE/PrpD family protein [Planctomycetota bacterium] diamond 1869 124 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32095032 32095032 PRJNA1156092_P_NODE_28478_length_245_cov_0.895349_g28348_i0 PRJNA1156092 28478 245 0.895349 2.19360505 Planctomycetota bacterium 2026780 Bacteria Bacteria 150 3.13e-40   NR MBA3697823.1 2026780 g28348 i0 82.7 12.330612244898 75 13 91.8 0 21 245 250 324 MBA3697823.1 acetate--CoA ligase [Planctomycetota bacterium] diamond 3021 150 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32241325 32241325 PRJNA1156092_P_NODE_27558_length_246_cov_0.890173_g27428_i0 PRJNA1156092 27558 246 0.890173 2.18982558 Bacteria 2 Bacteria Bacteria 119 1.38e-29   NR MFB0525775.1 2026778 g27428 i0 67.5 4.84146341463415 80 26 97.6 0 245 6 48 127 MFB0525775.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Phycisphaerae bacterium] diamond 1191 119 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
32506586 32506586 PRJNA1156092_P_NODE_27999_length_245_cov_0.895349_g27869_i0 PRJNA1156092 27999 245 0.895349 2.19360505 Phycisphaerae bacterium 2026778 Bacteria Bacteria 80.5 1.91e-15   NR MFA5783334.1 2026778 g27869 i0 52 1.83673469387755 75 36 91.8 0 1 225 324 398 MFA5783334.1 PAS domain S-box protein [Phycisphaerae bacterium] diamond 450 80.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
32526136 32526136 PRJNA1156092_P_NODE_29539_length_244_cov_0.900585_g29409_i0 PRJNA1156092 29539 244 0.900585 2.1974274 Bacteria 2 Bacteria Bacteria 125 3.95e-31   NR MCP4891992.1 2026779 g29409 i0 80.8 1.84426229508197 73 14 89.8 0 221 3 550 622 MCP4891992.1 DUF1592 domain-containing protein [Planctomycetaceae bacterium] diamond 450 125 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae 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);;