RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB6584 · 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
26340717 26340717 PRJEB6584o_S_NODE_13439_length_240_cov_4.829268_g13331_i0 PRJEB6584 13439 240 4.829268 11.5902432 Pseudomonadati 3379134 Bacteria Bacteria 120 4.1699999999999995e-30   NR MCE9619661.1 2026780 g13331 i0 65.8 2.9875 79 27 98.8 0 238 2 24 102 MCE9619661.1 amidohydrolase family protein [Planctomycetota bacterium] diamond 717 121 0.991735537190083 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32928966 32928966 PRJEB6584a_S_NODE_3097_length_214_cov_4.039106_g3077_i0 PRJEB6584 3097 214 4.039106 8.64368684 Gemmataceae bacterium 2052164 Bacteria Bacteria 67.4 5.31e-11   NR MFO0877588.1 2052164 g3077 i0 49.2 4.55607476635514 65 33 91.1 0 2 196 1164 1228 MFO0877588.1 ATP-binding protein [Gemmataceae bacterium] diamond 975 67.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
33049006 33049006 PRJEB6584o_S_NODE_46549_length_168_cov_2.067669_g46441_i0 PRJEB6584 46549 168 2.067669 3.47368392 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.2 0.0472   NR MCE9636583.1 2026780 g46441 i0 39.5 0.767857142857143 43 21 69.6 2 3 119 164 205 MCE9636583.1 glycosyltransferase family 39 protein [Planctomycetota bacterium] diamond 129 41.2 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33110883 33110883 PRJEB6584o_S_NODE_62478_length_161_cov_2.484127_g62370_i0 PRJEB6584 62478 161 2.484127 3.99944447 Pseudomonadati 3379134 Bacteria Bacteria 76.6 1.24e-14   NR MCE9619661.1 2026780 g62370 i0 87.8 4.58385093167702 41 5 76.4 0 159 37 227 267 MCE9619661.1 amidohydrolase family protein [Planctomycetota bacterium] diamond 738 76.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33128026 33128026 PRJEB6584o_S_NODE_8711_length_292_cov_4.914397_g8603_i0 PRJEB6584 8711 292 4.914397 14.35003924 Bacteria 2 Bacteria Bacteria 122 1.28e-30   NR MAC19092.1 2026778 g8603 i0 72.3 3.36986301369863 83 23 85.3 0 270 22 325 407 MAC19092.1 cystathionine beta-lyase [Phycisphaerae bacterium] diamond 984 122 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
33168260 33168260 PRJEB6584o_S_NODE_19840_length_203_cov_2.309524_g19732_i0 PRJEB6584 19840 203 2.309524 4.68833372 Planctomycetota bacterium 2026780 Bacteria Bacteria 63.5 8.96e-10   NR MBI1369225.1 2026780 g19732 i0 42.4 0.975369458128079 66 38 97.5 0 6 203 43 108 MBI1369225.1 IS630 family transposase [Planctomycetota bacterium] diamond 198 63.5 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
33179298 33179298 PRJEB6584o_S_NODE_20280_length_201_cov_4803.108434_g20172_i0 PRJEB6584 20280 201 4803.108434 9654.24795234 Pseudomonadati 3379134 Bacteria Bacteria 44.7 0.00426   NR MBI5779285.1 2026780 g20172 i0 54.8 1.26865671641791 42 18 62.7 1 29 154 192 232 MBI5779285.1 FkbM family methyltransferase [Planctomycetota bacterium] diamond 255 44.7 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);;