RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA745553" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA745553 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27178975 27178975 PRJNA745553_S_NODE_24802_length_249_cov_1.312500_g24607_i0 PRJNA745553 24802 249 1.3125 3.268125 Gemmataceae bacterium 2052164 Bacteria Bacteria 46.6 7.59e-4   NR MFL5341867.1 2052164 g24607 i0 56 3.39759036144578 50 17 57.8 2 148 5 33 79 MFL5341867.1 hypothetical protein [Gemmataceae bacterium] diamond 846 46.6 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae   Gemmataceae bacterium
27779434 27779434 PRJNA745553_S_NODE_15184_length_316_cov_2.851852_g14989_i0 PRJNA745553 15184 316 2.851852 9.01185232 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0417   NR MFT5086819.1 2026780 g14989 i0 47.9 0.455696202531646 48 24 44.6 1 20 160 41 88 MFT5086819.1 hypothetical protein [Planctomycetota bacterium] diamond 144 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
28041940 28041940 PRJNA745553_S_NODE_20765_length_271_cov_5.424242_g20570_i0 PRJNA745553 20765 271 5.424242 14.69969582 Planctomycetia 203683 Bacteria Bacteria 59.3 7.5e-8   NR HVL12751.1 1914242 g20570 i0 59.2 1.5830258302583 49 20 54.2 0 103 249 2 50 HVL12751.1 PQQ-binding-like beta-propeller repeat protein [Gemmata sp.] diamond 429 59.7 0.993299832495812 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Gemmata Gemmata sp.
29294824 29294824 PRJNA745553_S_NODE_19309_length_281_cov_4.966346_g19114_i0 PRJNA745553 19309 281 4.966346 13.95543226 Planctomycetota bacterium 2026780 Bacteria Bacteria 41.6 0.0213   NR HYE06036.1 2026780 g19114 i0 54.8 0.330960854092527 31 14 33.1 0 145 237 1 31 HYE06036.1 hypothetical protein [Planctomycetota bacterium] diamond 93 41.6 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29999694 29999694 PRJNA745553_S_NODE_4851_length_509_cov_2.855505_g4659_i0 PRJNA745553 4851 509 2.855505 14.53452045 Pseudomonadati 3379134 Bacteria Bacteria 82 3.97e-15   NR NQW47738.1 2026780 g4659 i0 42.6 1.33202357563851 115 55 64.2 3 330 4 50 159 NQW47738.1 hypothetical protein [Planctomycetota bacterium] diamond 678 82 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
32044258 32044258 PRJNA745553_S_NODE_5158_length_499_cov_3.523474_g4964_i0 PRJNA745553 5158 499 3.523474 17.58213526 Planctomycetota bacterium 2026780 Bacteria Bacteria 125 2.58e-30   NR MCK6474102.1 2026780 g4964 i0 45.5 0.925851703406814 154 80 90.8 3 24 476 186 338 MCK6474102.1 ATP-binding protein [Planctomycetota bacterium] diamond 462 125 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);;