RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA255848" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA255848 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27832078 27832078 PRJNA255848_P_NODE_47504_length_161_cov_0.910714_g47186_i0 PRJNA255848 47504 161 0.910714 1.46624954 Gemmataceae bacterium 2052164 Bacteria Bacteria 61.6 1.31e-9   NR MFO0878164.1 2052164 g47186 i0 52.8 0.987577639751553 53 25 98.8 0 160 2 163 215 MFO0878164.1 GntR family transcriptional regulator [Gemmataceae bacterium] diamond 159 61.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
28590066 28590066 PRJNA255848_P_NODE_38867_length_165_cov_1.318966_g38549_i0 PRJNA255848 38867 165 1.318966 2.1762939 Planctomycetota bacterium 2026780 Bacteria Bacteria 40.8 0.0387   NR MCG3134052.1 2026780 g38549 i0 54.8 0.563636363636364 31 14 56.4 0 165 73 104 134 MCG3134052.1 hypothetical protein [Planctomycetota bacterium] diamond 93 40.8 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28590070 28590070 PRJNA255848_P_NODE_46147_length_162_cov_0.902655_g45829_i0 PRJNA255848 46147 162 0.902655 1.4623011 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 60.1 1.59e-9   NR HMO25009.1 2876886 g45829 i0 65.2 2.7962962962963 46 16 85.2 0 160 23 91 136 HMO25009.1 glycosyltransferase [Tepidisphaeraceae bacterium] diamond 453 60.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
31938823 31938823 PRJNA255848_P_NODE_35577_length_167_cov_0.864407_g35259_i0 PRJNA255848 35577 167 0.864407 1.44355969 Tepidisphaeraceae bacterium 2876886 Bacteria Bacteria 64.3 3.17e-10   NR HMO24746.1 2876886 g35259 i0 56.4 0.988023952095808 55 24 98.8 0 165 1 49 103 HMO24746.1 hypothetical protein [Tepidisphaeraceae bacterium] diamond 165 64.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Tepidisphaerales Tepidisphaeraceae   Tepidisphaeraceae bacterium
32540372 32540372 PRJNA255848_P_NODE_27879_length_188_cov_2.201439_g27561_i0 PRJNA255848 27879 188 2.201439 4.13870532 Isosphaera sp. 41672 Bacteria Bacteria 42 0.006   NR MBA4062752.1 41672 g27561 i0 44.4 0.574468085106383 36 20 57.4 0 10 117 36 71 MBA4062752.1 hypothetical protein [Isosphaera sp.] diamond 108 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Isosphaera Isosphaera sp.

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