RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA399133" 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

  • PRJNA399133 · 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
27123408 27123408 PRJNA399133_P_NODE_6142_length_212_cov_2.254237_g6054_i0 PRJNA399133 6142 212 2.254237 4.77898244 Bacteria 2 Bacteria Bacteria 105 9.13e-25   NR MAO21141.1 2026778 g6054 i0 68.6 4.95283018867925 70 22 99.1 0 212 3 164 233 MAO21141.1 PBSX family phage terminase large subunit [Phycisphaerae bacterium] diamond 1050 105 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27391638 27391638 PRJNA399133_P_NODE_11303_length_157_cov_1.967213_g11215_i0 PRJNA399133 11303 157 1.967213 3.08852441 Planctomycetota bacterium 2026780 Bacteria Bacteria 48.9 7.76e-5   NR MBX3461222.1 2026780 g11215 i0 52.2 0.878980891719745 46 22 87.9 0 1 138 462 507 MBX3461222.1 YifB family Mg chelatase-like AAA ATPase [Planctomycetota bacterium] diamond 138 48.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29128278 29128278 PRJNA399133_P_NODE_4929_length_229_cov_2.340206_g4841_i0 PRJNA399133 4929 229 2.340206 5.35907174 Planctomycetota bacterium 2026780 Bacteria Bacteria 75.9 6.76e-14   NR MFN3241241.1 2026780 g4841 i0 52.6 0.995633187772926 76 25 99.6 1 1 228 939 1003 MFN3241241.1 Ig-like domain-containing protein [Planctomycetota bacterium] diamond 228 75.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29128280 29128280 PRJNA399133_P_NODE_5549_length_225_cov_1.473684_g5461_i0 PRJNA399133 5549 225 1.473684 3.315789 Planctomycetota bacterium 2026780 Bacteria Bacteria 84.3 6.83e-18   NR NDG63678.1 2026780 g5461 i0 54.7 1 75 34 100 0 225 1 148 222 NDG63678.1 polynucleotide kinase [Planctomycetota bacterium] diamond 225 84.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32130377 32130377 PRJNA399133_P_NODE_12158_length_152_cov_1.358974_g12070_i0 PRJNA399133 12158 152 1.358974 2.06564048 Planctomycetota bacterium 2026780 Bacteria Bacteria 82.4 8.96e-18   NR MFN5329251.1 2026780 g12070 i0 80.9 0.927631578947368 47 9 92.8 0 152 12 148 194 MFN5329251.1 lambda exonuclease family protein [Planctomycetota bacterium] diamond 141 82.4 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32383323 32383323 PRJNA399133_P_NODE_10979_length_159_cov_2.169355_g10891_i0 PRJNA399133 10979 159 2.169355 3.44927445 Planctomycetota bacterium 2026780 Bacteria Bacteria 62 1.54e-9   NR MFT6108405.1 2026780 g10891 i0 48.1 1.9622641509434 52 27 98.1 0 3 158 130 181 MFT6108405.1 UDP-3-O-[3-hydroxymyristoyl] glucosamine N-acyltransferase [Planctomycetota bacterium] diamond 312 62 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32478470 32478470 PRJNA399133_P_NODE_919_length_532_cov_2.917505_g841_i0 PRJNA399133 919 532 2.917505 15.5211266 Planctomycetota bacterium 2026780 Bacteria Bacteria 105 5.85e-23   NR MCH2572347.1 2026780 g841 i0 62.1 0.490601503759398 87 31 48.5 2 2 259 342 427 MCH2572347.1 hypothetical protein [Planctomycetota bacterium] diamond 261 105 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);;