RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA436017 · 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
5534515 5534515 PRJNA436017_P_NODE_2185_length_641_cov_1.514901_g1942_i0 PRJNA436017 2185 641 1.514901 9.71051541 Planctomycetota bacterium 2026780 Bacteria Bacteria 171 4.269999999999999e-48   NR HLX60647.1 2026780 g1942 i0 54.1 1.84399375975039 183 77 83.8 4 3 539 5 184 HLX60647.1 non-ribosomal peptide synthetase [Planctomycetota bacterium] diamond 1182 171 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
27644743 27644743 PRJNA436017_P_NODE_26344_length_159_cov_1.237705_g26046_i0 PRJNA436017 26344 159 1.237705 1.96795095 Phycisphaerales bacterium 2052180 Bacteria Bacteria 76.6 7.35e-15   NR HLP84092.1 2052180 g26046 i0 100 0.641509433962264 34 0 64.2 0 57 158 72 105 HLP84092.1 PA2169 family four-helix-bundle protein [Phycisphaerales bacterium] diamond 102 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
28244237 28244237 PRJNA436017_P_NODE_20726_length_180_cov_1.062937_g20428_i0 PRJNA436017 20726 180 1.062937 1.9132866 Isosphaeraceae bacterium 2691532 Bacteria Bacteria 86.7 1.44e-20   NR HKM53099.1 2691532 g20428 i0 74 0.833333333333333 50 13 83.3 0 5 154 35 84 HKM53099.1 hypothetical protein [Isosphaeraceae bacterium] diamond 150 86.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium
29160303 29160303 PRJNA436017_P_NODE_19309_length_186_cov_1.570470_g19011_i0 PRJNA436017 19309 186 1.57047 2.9210742 Planctomycetia bacterium 2052181 Bacteria Bacteria 59.7 1.8e-8   NR MCX7411934.1 2052181 g19011 i0 60.4 0.854838709677419 53 19 82.3 1 155 3 224 276 MCX7411934.1 autotransporter-associated beta strand repeat-containing protein [Planctomycetia bacterium] diamond 159 59.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
29822872 29822872 PRJNA436017_P_NODE_15791_length_208_cov_1.333333_g15493_i0 PRJNA436017 15791 208 1.333333 2.77333264 Phycisphaerales bacterium 2052180 Bacteria Bacteria 43.9 0.00248   NR HLP83835.1 2052180 g15493 i0 96.1 0.735576923076923 51 2 73.6 0 46 198 1 51 HLP83835.1 hypothetical protein [Phycisphaerales bacterium] diamond 153 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
30075718 30075718 PRJNA436017_P_NODE_28032_length_154_cov_1.333333_g27734_i0 PRJNA436017 28032 154 1.333333 2.05333282 Planctomycetota bacterium 2026780 Bacteria Bacteria 68.2 1.18e-11   NR MBI1918664.1 2026780 g27734 i0 64.7 3.97402597402597 51 18 99.4 0 2 154 55 105 MBI1918664.1 putative DNA binding domain-containing protein [Planctomycetota bacterium] diamond 612 68.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31687676 31687676 PRJNA436017_P_NODE_28317_length_153_cov_1.844828_g28019_i0 PRJNA436017 28317 153 1.844828 2.82258684 Phycisphaerales bacterium 2052180 Bacteria Bacteria 55.1 2.45e-8   NR HLP84091.1 2052180 g28019 i0 90 0.588235294117647 30 3 58.8 0 1 90 14 43 HLP84091.1 hypothetical protein [Phycisphaerales bacterium] diamond 90 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales 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);;