RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 4 ✖

bioproject 1

  • PRJNA846086 · 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
27244356 27244356 PRJNA846086_P_NODE_5103_length_243_cov_0.905882_g5037_i0 PRJNA846086 5103 243 0.905882 2.20129326 Akkermansiaceae bacterium 2562705 Bacteria Bacteria 43.1 0.0154   NR MEO1834869.1 2562705 g5037 i0 48.5 0.407407407407407 33 17 40.7 0 239 141 19 51 MEO1834869.1 hypothetical protein [Akkermansiaceae bacterium] diamond 99 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Akkermansiaceae   Akkermansiaceae bacterium
29296858 29296858 PRJNA846086_P_NODE_4529_length_245_cov_0.895349_g4463_i0 PRJNA846086 4529 245 0.895349 2.19360505 Phycisphaerae bacterium 2026778 Bacteria Bacteria 153 4.14e-46   NR MDZ4755881.1 2026778 g4463 i0 95.1 4.95918367346939 81 4 99.2 0 243 1 33 113 MDZ4755881.1 heme-binding protein [Phycisphaerae bacterium] diamond 1215 153 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae       Phycisphaerae bacterium
30465783 30465783 PRJNA846086_P_NODE_3973_length_247_cov_0.885057_g3907_i0 PRJNA846086 3973 247 0.885057 2.18609079 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 90.5 3.39e-21   NR MCG3177591.1 2035772 g3907 i0 54.9 1.9919028340081 82 31 99.6 1 247 2 8 83 MCG3177591.1 hypothetical protein [Candidatus Omnitrophota bacterium] diamond 492 90.5 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
31769868 31769868 PRJNA846086_P_NODE_2017_length_281_cov_1.264423_g1951_i0 PRJNA846086 2017 281 1.264423 3.55302863 Bacteria 2 Bacteria Bacteria 102 9.12e-25   NR MBX3404621.1 2026777 g1951 i0 69.4 2.56227758007117 72 22 76.9 0 279 64 121 192 MBX3404621.1 GNAT family N-acetyltransferase [Phycisphaeraceae bacterium] diamond 720 103 0.990291262135922 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales Phycisphaeraceae   Phycisphaeraceae 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);;