RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA939369" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA939369 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
26835258 26835258 PRJNA939369_S_NODE_44641_length_267_cov_1.582474_g44224_i0 PRJNA939369 44641 267 1.582474 4.22520558 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 94.4 7.4e-22   NR MBO5437458.1 2691551 g44224 i0 81.5 0.606741573033708 54 10 60.7 0 2 163 140 193 MBO5437458.1 HK97 family phage prohead protease [Thermoguttaceae bacterium] diamond 162 94.4 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
27095191 27095191 PRJNA939369_S_NODE_67602_length_245_cov_0.895349_g67185_i0 PRJNA939369 67602 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 70.1 5.84e-12   NR MBI68501.1 2026778 g67185 i0 66 1.1265306122449 47 16 57.6 0 1 141 260 306 MBI68501.1 hypothetical protein [Phycisphaerae bacterium] diamond 276 70.5 0.994326241134752 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
27530536 27530536 PRJNA939369_S_NODE_24963_length_317_cov_0.946721_g24546_i0 PRJNA939369 24963 317 0.946721 3.00110557 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 98.2 4.0799999999999996e-23   NR MBQ2850058.1 2691551 g24546 i0 58.7 2.12933753943218 75 31 71 0 309 85 115 189 MBQ2850058.1 hypothetical protein [Thermoguttaceae bacterium] diamond 675 98.2 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
28667367 28667367 PRJNA939369_S_NODE_32827_length_293_cov_1.222727_g32410_i0 PRJNA939369 32827 293 1.222727 3.58259011 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 44.3 0.0133   NR MBR0225112.1 2691551 g32410 i0 48.6 0.747440273037543 37 19 37.9 0 178 288 6 42 MBR0225112.1 hypothetical protein [Thermoguttaceae bacterium] diamond 219 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
29014857 29014857 PRJNA939369_S_NODE_72588_length_243_cov_0.888235_g72171_i0 PRJNA939369 72588 243 0.888235 2.15841105 Phycisphaerales bacterium 2052180 Bacteria Bacteria 43.5 0.0197   NR MCC6321303.1 2052180 g72171 i0 38.2 0.839506172839506 68 41 82.7 1 220 20 96 163 MCC6321303.1 S8 family serine peptidase [Phycisphaerales bacterium] diamond 204 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
29898761 29898761 PRJNA939369_S_NODE_68831_length_244_cov_1.350877_g68414_i0 PRJNA939369 68831 244 1.350877 3.29613988 Thermoguttaceae bacterium 2691551 Bacteria Bacteria 65.5 3.8e-10   NR MBQ9372152.1 2691551 g68414 i0 45.8 1.02049180327869 83 41 99.6 3 243 1 481 561 MBQ9372152.1 fibronectin type III domain-containing protein [Thermoguttaceae bacterium] diamond 249 65.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Thermoguttaceae   Thermoguttaceae bacterium
30885089 30885089 PRJNA939369_S_NODE_73714_length_242_cov_0.911243_g73297_i0 PRJNA939369 73714 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 80.1 2.55e-15   NR MDP7254702.1 2026780 g73297 i0 50.6 7.5495867768595 87 35 97.9 2 237 1 559 645 MDP7254702.1 Mu-like prophage major head subunit gpT family protein [Planctomycetota bacterium] diamond 1827 80.9 0.990111248454882 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31036347 31036347 PRJNA939369_S_NODE_27055_length_310_cov_0.869198_g26638_i0 PRJNA939369 27055 310 0.869198 2.6945138 Phycisphaerae bacterium 2026778 Bacteria Bacteria 43.5 0.0103   NR MAO23689.1 2026778 g26638 i0 38.7 0.725806451612903 75 35 64.8 3 208 8 1 72 MAO23689.1 hypothetical protein [Phycisphaerae bacterium] diamond 225 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae 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);;