RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093380 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
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
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
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
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
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);;