RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1047321" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA1047321 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
10377715 10377715 PRJNA1047321_P_NODE_7649_length_246_cov_0.890173_g7478_i0 PRJNA1047321 7649 246 0.890173 2.18982558 Planctomycetota bacterium 2026780 Bacteria Bacteria 145 3.77e-38   NR MCI0335396.1 2026780 g7478 i0 92.6 1.97560975609756 81 6 98.8 0 245 3 512 592 MCI0335396.1 sodium-translocating pyrophosphatase [Planctomycetota bacterium] diamond 486 145 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
18026230 18026230 PRJNA1047321_P_NODE_5635_length_268_cov_1.579487_g5464_i0 PRJNA1047321 5635 268 1.579487 4.23302516 Singulisphaera 466152 Bacteria Bacteria 60.5 2.71e-8   NR WP_074308398.1 1882752 g5464 i0 82.9 1.56716417910448 35 6 39.2 0 163 267 1 35 WP_074308398.1 AAA family ATPase [Singulisphaera sp. GP187] diamond 420 60.8 0.995065789473684 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae Singulisphaera Singulisphaera sp. GP187
32185046 32185046 PRJNA1047321_P_NODE_8318_length_243_cov_0.905882_g8147_i0 PRJNA1047321 8318 243 0.905882 2.20129326 Limnoglobus roseus 2598579 Bacteria Bacteria 62.8 5.56e-10   NR WP_149110227.1 2598579 g8147 i0 44.9 0.851851851851852 69 38 85.2 0 5 211 97 165 WP_149110227.1 hypothetical protein [Limnoglobus roseus] diamond 207 62.8 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales Gemmataceae Limnoglobus Limnoglobus roseus
32722110 32722110 PRJNA1047321_P_NODE_7200_length_248_cov_0.880000_g7029_i0 PRJNA1047321 7200 248 0.88 2.1824 Waddliaceae bacterium 2026802 Bacteria Bacteria 75.9 7.13e-14   NR MBB64038.1 2026802 g7029 i0 40.2 2.9758064516129 82 49 99.2 0 2 247 170 251 MBB64038.1 peptidase [Waddliaceae bacterium] diamond 738 75.9 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Waddliaceae   Waddliaceae 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);;