RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA554794" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA554794 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
8173722 8173722 PRJNA554794_P_NODE_9627_length_424_cov_0.744000_g5784_i0 PRJNA554794 9627 424 0.744 3.15456 Pseudomonadati 3379134 Bacteria Bacteria 186 6.45e-54   NR NUQ33528.1 2026779 g5784 i0 73.6 23.6603773584906 121 32 85.6 0 1 363 346 466 NUQ33528.1 F0F1 ATP synthase subunit beta [Planctomycetaceae bacterium] diamond 10032 186 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
26951523 26951523 PRJNA554794_P_NODE_12662_length_268_cov_1.351598_g8733_i0 PRJNA554794 12662 268 1.351598 3.62228264 Phycisphaeraceae bacterium JB051 3342864 Bacteria Bacteria 54.3 3.48e-6   NR MFG0249595.1 3342864 g8733 i0 36.4 1.97014925373134 88 56 98.5 0 5 268 106 193 MFG0249595.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium JB051] diamond 528 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium JB051
27836224 27836224 PRJNA554794_P_NODE_22204_length_171_cov_1.459016_g18275_i0 PRJNA554794 22204 171 1.459016 2.49491736 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0145   NR MBN8643811.1 2026780 g18275 i0 38.2 4.75438596491228 55 32 96.5 1 4 168 289 341 MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium] diamond 813 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28404685 28404685 PRJNA554794_P_NODE_21306_length_182_cov_1.127820_g17377_i0 PRJNA554794 21306 182 1.12782 2.0526324 Phycisphaeraceae bacterium 2026777 Bacteria Bacteria 43.1 0.0119   NR MBX3315538.1 2026777 g17377 i0 45.6 2.43956043956044 57 25 89 2 182 21 270 323 MBX3315538.1 choice-of-anchor A family protein [Phycisphaeraceae bacterium] diamond 444 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae bacterium
32196394 32196394 PRJNA554794_P_NODE_23418_length_164_cov_1.321739_g19489_i0 PRJNA554794 23418 164 1.321739 2.16765196 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 108 5.71e-28   NR MCP4190648.1 2026779 g19489 i0 92.6 1.97560975609756 54 4 98.8 0 162 1 140 193 MCP4190648.1 hypothetical protein [Planctomycetaceae bacterium] diamond 324 108 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
32590660 32590660 PRJNA554794_P_NODE_6219_length_796_cov_1.160643_g3043_i0 PRJNA554794 6219 796 1.160643 9.23871828 PVC group 1783257 Bacteria Bacteria 54.7 1.79e-4   NR MBN8603554.1 2026780 g3043 i0 33.1 1.43969849246231 121 76 44.5 4 734 381 212 330 MBN8603554.1 hypothetical protein [Planctomycetota bacterium] diamond 1146 55.1 0.992740471869329 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);;