RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1087264", tax_clade = "PVC group" 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

  • PVC group · 7 ✖

bioproject 1

  • PRJNA1087264 · 7 ✖

analysis 1

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
27193826 27193826 PRJNA1087264_P_NODE_13962_length_168_cov_1.285714_g13880_i0 PRJNA1087264 13962 168 1.285714 2.15999952 Phycisphaerae bacterium 2026778 Bacteria Bacteria 68.9 5.99e-12   NR MDX2199290.1 2026778 g13880 i0 54.5 1.96428571428571 55 23 98.2 1 3 167 83 135 MDX2199290.1 NAD(P)-dependent alcohol dehydrogenase [Phycisphaerae bacterium] diamond 330 68.9 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27320468 27320468 PRJNA1087264_P_NODE_17603_length_165_cov_0.879310_g17521_i0 PRJNA1087264 17603 165 0.87931 1.4508615 Fuerstiella sp. 1936112 Bacteria Bacteria 55.8 2.2e-7   NR MCP4511687.1 1936112 g17521 i0 36.4 1.83636363636364 55 35 100 0 1 165 119 173 MCP4511687.1 hypothetical protein [Fuerstiella sp.] diamond 303 55.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae Fuerstiella Fuerstiella sp.
27699673 27699673 PRJNA1087264_P_NODE_20684_length_162_cov_0.902655_g20602_i0 PRJNA1087264 20684 162 0.902655 1.4623011 Gemmataceae bacterium 2052164 Bacteria Bacteria 45.1 8.53e-4   NR MFO0849856.1 2052164 g20602 i0 45.3 0.981481481481482 53 27 96.3 2 157 2 36 87 MFO0849856.1 BPSL0067 family protein [Gemmataceae bacterium] diamond 159 45.1 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
29656515 29656515 PRJNA1087264_P_NODE_2530_length_419_cov_1.851351_g2449_i0 PRJNA1087264 2530 419 1.851351 7.75716069 Pirellula sp. 117 Bacteria Bacteria 50.4 4.76e-4   NR MFM7931657.1 117 g2449 i0 34.8 1.91169451073986 89 57 63 1 6 269 48 136 MFM7931657.1 SdrD B-like domain-containing protein [Pirellula sp.] diamond 801 50.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae Pirellula Pirellula sp.
31363253 31363253 PRJNA1087264_P_NODE_12076_length_182_cov_0.842105_g11994_i0 PRJNA1087264 12076 182 0.842105 1.5326311 Planctomycetes bacterium DG_23 1703414 Bacteria Bacteria 55.1 4.95e-7   NR KPJ58283.1 1703414 g11994 i0 46 1.81318681318681 50 27 82.4 0 178 29 62 111 KPJ58283.1 MAG: hypothetical protein AMS15_08795 [Planctomycetes bacterium DG_23] diamond 330 55.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetes bacterium DG_23
32122477 32122477 PRJNA1087264_P_NODE_16898_length_165_cov_0.879310_g16816_i0 PRJNA1087264 16898 165 0.87931 1.4508615 Pirellulales bacterium 2715253 Bacteria Bacteria 60.8 5.37e-9   NR MBN1912441.1 2715253 g16816 i0 50.9 3.89090909090909 55 27 100 0 165 1 213 267 MBN1912441.1 sulfatase [Pirellulales bacterium] diamond 642 60.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales     Pirellulales bacterium
32817147 32817147 PRJNA1087264_P_NODE_1620_length_529_cov_1.900000_g1541_i0 PRJNA1087264 1620 529 1.9 10.051 Planctomycetota bacterium 2026780 Bacteria Bacteria 58.5 1.76e-6   NR MCP3904936.1 2026780 g1541 i0 37 0.56710775047259 100 55 53.3 3 443 162 324 421 MCP3904936.1 protein kinase [Planctomycetota bacterium] diamond 300 58.5 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);;