RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA851399 · 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
12713558 12713558 PRJNA851399_P_NODE_31970_length_164_cov_1.773913_g31517_i0 PRJNA851399 31970 164 1.773913 2.90921732 Phycisphaerae bacterium 2026778 Bacteria Bacteria 91.7 7.43e-20   NR HVP10452.1 2026778 g31517 i0 83.3 1.97560975609756 54 9 98.8 0 162 1 361 414 HVP10452.1 Hsp70 family protein [Phycisphaerae bacterium] diamond 324 91.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
28128977 28128977 PRJNA851399_P_NODE_35045_length_163_cov_0.894737_g34592_i0 PRJNA851399 35045 163 0.894737 1.45842131 Planctomycetia bacterium 2052181 Bacteria Bacteria 98.2 5.069999999999999e-23   NR MCI0700753.1 2052181 g34592 i0 82.7 2.88957055214724 52 9 95.7 0 162 7 25 76 MCI0700753.1 alpha/beta hydrolase [Planctomycetia bacterium] diamond 471 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia       Planctomycetia bacterium
29265315 29265315 PRJNA851399_P_NODE_30049_length_165_cov_0.879310_g29596_i0 PRJNA851399 30049 165 0.87931 1.4508615 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.9 0.00499   NR MEM6755981.1 2026780 g29596 i0 60 0.636363636363636 35 14 63.6 0 59 163 20 54 MEM6755981.1 site-specific integrase [Planctomycetota bacterium] diamond 105 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29580939 29580939 PRJNA851399_P_NODE_13890_length_202_cov_2.973856_g13437_i0 PRJNA851399 13890 202 2.973856 6.00718912 Singulisphaera sp. 1906241 Bacteria Bacteria 42.7 0.0213   NR MEJ7638550.1 1906241 g13437 i0 38.6 0.846534653465347 57 28 77.2 2 24 179 393 447 MEJ7638550.1 sodium:solute symporter family protein [Singulisphaera sp.] diamond 171 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp.
29842080 29842080 PRJNA851399_P_NODE_28111_length_166_cov_0.871795_g27658_i0 PRJNA851399 28111 166 0.871795 1.4471797 Bacteria 2 Bacteria Bacteria 70.1 1.38e-12   NR HPD28582.1 2026778 g27658 i0 70.5 5.6566265060241 44 13 79.5 0 164 33 227 270 HPD28582.1 hypothetical protein [Phycisphaerae bacterium] diamond 939 70.5 0.994326241134752 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
29842081 29842081 PRJNA851399_P_NODE_41811_length_159_cov_2.736364_g41358_i0 PRJNA851399 41811 159 2.736364 4.35081876 Lacipirellulaceae 2691359 Bacteria Bacteria 102 2.5299999999999998e-24   NR WP_145061785.1 1930276 g41358 i0 92.3 5.88679245283019 52 4 98.1 0 158 3 194 245 WP_145061785.1 cupin-like domain-containing protein [Adhaeretor mobilis] diamond 936 103 0.990291262135922 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae Adhaeretor Adhaeretor mobilis
30686770 30686770 PRJNA851399_P_NODE_37413_length_162_cov_0.902655_g36960_i0 PRJNA851399 37413 162 0.902655 1.4623011 Gemmataceae bacterium 2052164 Bacteria Bacteria 43.9 0.00479   NR MCX7699587.1 2052164 g36960 i0 39.2 0.944444444444444 51 31 94.4 0 154 2 363 413 MCX7699587.1 glycoside hydrolase family 5 protein [Gemmataceae bacterium] diamond 153 43.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae 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);;