RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1002816 · 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
28613521 28613521 PRJNA1002816_P_NODE_15427_length_276_cov_1.064039_g15267_i0 PRJNA1002816 15427 276 1.064039 2.93674764 Planctomycetota bacterium 2026780 Bacteria Bacteria 43.1 0.0401   NR MEN9557233.1 2026780 g15267 i0 36 0.543478260869565 50 32 54.3 0 81 230 453 502 MEN9557233.1 NADH-quinone oxidoreductase subunit [Planctomycetota bacterium] diamond 150 43.1 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30192357 30192357 PRJNA1002816_P_NODE_9472_length_364_cov_1.003436_g9312_i0 PRJNA1002816 9472 364 1.003436 3.65250704 Simkania sp. 34094 Bacteria Bacteria 99 1.2800000000000001e-22   NR MCB1084310.1 34094 g9312 i0 70.8 0.535714285714286 65 19 53.6 0 6 200 108 172 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 195 99 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
30287612 30287612 PRJNA1002816_P_NODE_9232_length_369_cov_1.027027_g9072_i0 PRJNA1002816 9232 369 1.027027 3.78972963 Planctomycetaceae bacterium 2026779 Bacteria Bacteria 44.3 0.0401   NR RPJ36674.1 2026779 g9072 i0 43.3 0.48780487804878 60 33 48 1 323 147 144 203 RPJ36674.1 MAG: hypothetical protein EHM35_07725, partial [Planctomycetaceae bacterium] diamond 180 44.3 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Planctomycetales Planctomycetaceae   Planctomycetaceae bacterium
30634593 30634593 PRJNA1002816_P_NODE_14633_length_285_cov_1.150943_g14473_i0 PRJNA1002816 14633 285 1.150943 3.28018755 Phycisphaerales bacterium 2052180 Bacteria Bacteria 171 1.29e-47   NR MBY0309260.1 2052180 g14473 i0 85.3 1 95 14 100 0 285 1 353 447 MBY0309260.1 FYVE zinc finger domain-containing protein [Phycisphaerales bacterium] diamond 285 171 1 Bacteria PVC group Pseudomonadati Planctomycetota Phycisphaerae Phycisphaerales     Phycisphaerales bacterium
32120982 32120982 PRJNA1002816_P_NODE_14898_length_282_cov_1.105263_g14738_i0 PRJNA1002816 14898 282 1.105263 3.11684166 Haloferula rosea 490093 Bacteria Bacteria 43.9 0.0205   NR WP_200283419.1 490093 g14738 i0 39.6 2.04255319148936 48 29 51.1 0 280 137 125 172 WP_200283419.1 3-deoxy-8-phosphooctulonate synthase [Haloferula rosea] diamond 576 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Haloferula Haloferula rosea
32342566 32342566 PRJNA1002816_P_NODE_11079_length_334_cov_1.440613_g10919_i0 PRJNA1002816 11079 334 1.440613 4.81164742 Simkania sp. 34094 Bacteria Bacteria 115 3.5600000000000003e-29   NR MCB1084310.1 34094 g10919 i0 69.1 0.727544910179641 81 25 72.8 0 5 247 92 172 MCB1084310.1 hypothetical protein [Simkania sp.] diamond 243 115 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Simkaniaceae Simkania Simkania sp.
32374105 32374105 PRJNA1002816_P_NODE_14399_length_288_cov_1.065116_g14239_i0 PRJNA1002816 14399 288 1.065116 3.06753408 Pirellulaceae bacterium 2699754 Bacteria Bacteria 43.5 0.0313   NR MFM8175203.1 2699754 g14239 i0 37.5 0.5 48 30 50 0 107 250 222 269 MFM8175203.1 hypothetical protein [Pirellulaceae bacterium] diamond 144 43.5 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Pirellulaceae   Pirellulaceae 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);;