RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB12982 · 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
27665092 27665092 PRJEB12982_P_NODE_20284_length_162_cov_0.902655_g20121_i0 PRJEB12982 20284 162 0.902655 1.4623011 Pirellulales bacterium 2715253 Bacteria Bacteria 72.4 4.24e-14   NR HVA49718.1 2715253 g20121 i0 64.2 0.981481481481482 53 19 98.1 0 2 160 102 154 HVA49718.1 hypothetical protein [Pirellulales bacterium] diamond 159 72.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
27696816 27696816 PRJEB12982_P_NODE_17144_length_167_cov_0.864407_g16981_i0 PRJEB12982 17144 167 0.864407 1.44355969 Phycisphaerales bacterium 2052180 Bacteria Bacteria 39.7 0.0255   NR HRJ50108.1 2052180 g16981 i0 36.5 0.934131736526946 52 23 93.4 1 158 3 17 58 HRJ50108.1 hypothetical protein [Phycisphaerales bacterium] diamond 156 39.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
27910908 27910908 PRJEB12982_P_NODE_15265_length_177_cov_1.195312_g15102_i0 PRJEB12982 15265 177 1.195312 2.11570224 Planctomyces 118 Bacteria Bacteria 74.7 3.13e-14   NR MFO0536479.1 37635 g15102 i0 66 5.40677966101695 53 18 89.8 0 1 159 57 109 MFO0536479.1 aldehyde dehydrogenase family protein [Planctomyces sp.] diamond 957 74.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Planctomyces Planctomyces sp.
29780335 29780335 PRJEB12982_P_NODE_17011_length_167_cov_0.864407_g16848_i0 PRJEB12982 17011 167 0.864407 1.44355969 Planctomycetota bacterium 2026780 Bacteria Bacteria 42 0.0252   NR MEQ1634930.1 2026780 g16848 i0 53.1 0.880239520958084 49 18 88 2 148 2 5 48 MEQ1634930.1 phosphoenolpyruvate carboxykinase (ATP) [Planctomycetota bacterium] diamond 147 42 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31606925 31606925 PRJEB12982_P_NODE_20256_length_162_cov_0.902655_g20093_i0 PRJEB12982 20256 162 0.902655 1.4623011 Planctomycetia 203683 Bacteria Bacteria 86.3 2.14e-18   NR HKB03998.1 2052164 g20093 i0 80 2.77777777777778 50 10 92.6 0 2 151 34 83 HKB03998.1 hypothetical protein [Gemmataceae bacterium] diamond 450 86.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
32467728 32467728 PRJEB12982_P_NODE_10599_length_217_cov_0.970238_g10436_i0 PRJEB12982 10599 217 0.970238 2.10541646 Planctomycetota bacterium 2026780 Bacteria Bacteria 44.3 0.00767   NR MCZ7647757.1 2026780 g10436 i0 40.3 0.857142857142857 62 35 85.7 2 8 193 42 101 MCZ7647757.1 ThuA domain-containing protein [Planctomycetota bacterium] diamond 186 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32556369 32556369 PRJEB12982_P_NODE_3059_length_440_cov_1.723785_g2898_i0 PRJEB12982 3059 440 1.723785 7.584654 Pseudomonadati 3379134 Bacteria Bacteria 181 4.13e-53   NR MFB3430228.1 2052180 g2898 i0 55.1 10.0159090909091 147 64 99.5 2 438 1 48 193 MFB3430228.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerales bacterium] diamond 4407 181 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);;