RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA896973 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
22550324 22550324 PRJNA896973_S_NODE_38_length_1693_cov_5.185185_g36_i0 PRJNA896973 38 1693 5.185185 87.78518205 Gemmataceae bacterium 2052164 Bacteria Bacteria 342 1.46e-111   NR HEY7331155.1 2052164 g36 i0 74 1.97578263437685 223 58 39.5 0 576 1244 1 223 HEY7331155.1 heavy metal response regulator transcription factor [Gemmataceae bacterium] diamond 3345 342 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
26960626 26960626 PRJNA896973_P_NODE_24542_length_246_cov_1.780347_g24448_i0 PRJNA896973 24542 246 1.780347 4.37965362 Planctomycetota bacterium 2026780 Bacteria Bacteria 160 9.83e-45   NR MBS0264672.1 2026780 g24448 i0 95.1 2.96341463414634 81 4 98.8 0 2 244 165 245 MBS0264672.1 DUF1501 domain-containing protein [Planctomycetota bacterium] diamond 729 160 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29297861 29297861 PRJNA896973_P_NODE_28209_length_241_cov_0.916667_g28115_i0 PRJNA896973 28209 241 0.916667 2.20916747 Candidatus Brocadiaceae bacterium 2094028 Bacteria Bacteria 42.4 0.0456   NR NLW51132.1 2094028 g28115 i0 33.3 0.746887966804979 60 36 74.7 2 4 183 187 242 NLW51132.1 cytochrome c biogenesis protein CcsA [Candidatus Brocadiaceae bacterium] diamond 180 42.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Candidatus Brocadiia Candidatus Brocadiales Candidatus Brocadiaceae   Candidatus Brocadiaceae bacterium
29739581 29739581 PRJNA896973_P_NODE_24930_length_246_cov_0.890173_g24836_i0 PRJNA896973 24930 246 0.890173 2.18982558 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 135 1.15e-35   NR MDB5334976.1 2026779 g24836 i0 84.1 1 82 13 100 0 1 246 35 116 MDB5334976.1 transposase family protein [Planctomycetaceae bacterium] diamond 246 135 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30972113 30972113 PRJNA896973_P_NODE_25594_length_245_cov_0.895349_g25500_i0 PRJNA896973 25594 245 0.895349 2.19360505 Frigoriglobus tundricola 2774151 Bacteria Bacteria 117 6.27e-30   NR WP_171475323.1 2774151 g25500 i0 84.7 0.881632653061225 72 11 88.2 0 2 217 192 263 WP_171475323.1 FG-GAP repeat domain-containing protein [Frigoriglobus tundricola] diamond 216 117 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola
31793879 31793879 PRJNA896973_P_NODE_22877_length_249_cov_0.875000_g22783_i0 PRJNA896973 22877 249 0.875 2.17875 Planctomycetota bacterium 2026780 Bacteria Bacteria 164 2e-45   NR MBN9121418.1 2026780 g22783 i0 93.9 3.95180722891566 82 5 98.8 0 2 247 529 610 MBN9121418.1 DUF1549 domain-containing protein [Planctomycetota bacterium] diamond 984 164 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31825568 31825568 PRJNA896973_P_NODE_27717_length_241_cov_1.821429_g27623_i0 PRJNA896973 27717 241 1.821429 4.38964389 Gemmataceae bacterium 2052164 Bacteria Bacteria 94.4 1.84e-20   NR MCC6417287.1 2052164 g27623 i0 70 0.995850622406639 80 24 99.6 0 1 240 120 199 MCC6417287.1 efflux RND transporter periplasmic adaptor subunit [Gemmataceae bacterium] diamond 240 94.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32047258 32047258 PRJNA896973_P_NODE_24178_length_247_cov_0.885057_g24084_i0 PRJNA896973 24178 247 0.885057 2.18609079 Frigoriglobus tundricola 2774151 Bacteria Bacteria 103 2.13e-23   NR WP_171469499.1 2774151 g24084 i0 63.4 0.995951417004049 82 29 99.6 1 246 1 328 408 WP_171469499.1 tetratricopeptide repeat protein [Frigoriglobus tundricola] diamond 246 103 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Frigoriglobus Frigoriglobus tundricola

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);;