RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1093380" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093380 · 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
19324841 19324841 PRJNA1093380_P_NODE_1716_length_429_cov_1.283708_g1610_i0 PRJNA1093380 1716 429 1.283708 5.50710732 Pseudomonadati 3379134 Bacteria Bacteria 139 3.1999999999999995e-36   NR MBS0623645.1 2026799 g1610 i0 53.8 3 143 46 99.3 4 427 2 79 202 MBS0623645.1 tryptophan--tRNA ligase [Verrucomicrobiota bacterium] diamond 1287 140 0.992857142857143 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26624376 26624376 PRJNA1093380_P_NODE_14281_length_246_cov_2.242775_g14175_i0 PRJNA1093380 14281 246 2.242775 5.5172265 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.3 0.00913   NR TMP96329.1 2026799 g14175 i0 44.4 0.658536585365854 54 29 65.9 1 84 245 39 91 TMP96329.1 MAG: porin family protein, partial [Verrucomicrobiota bacterium] diamond 162 44.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26940934 26940934 PRJNA1093380_P_NODE_11002_length_256_cov_1.683060_g10896_i0 PRJNA1093380 11002 256 1.68306 4.3086336 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 159 1.26e-45   NR RYD65414.1 2026800 g10896 i0 81.2 0.99609375 85 16 99.6 0 1 255 245 329 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 255 159 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
27004212 27004212 PRJNA1093380_P_NODE_15242_length_245_cov_0.895349_g15136_i0 PRJNA1093380 15242 245 0.895349 2.19360505 Opitutaceae bacterium 2006848 Bacteria Bacteria 107 1.84e-26   NR MBC7368709.1 2006848 g15136 i0 69.1 0.991836734693878 81 25 99.2 0 244 2 165 245 MBC7368709.1 hypothetical protein [Opitutaceae bacterium] diamond 243 107 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
27352329 27352329 PRJNA1093380_P_NODE_8203_length_272_cov_1.547739_g8097_i0 PRJNA1093380 8203 272 1.547739 4.20985008 Opitutales bacterium 2026772 Bacteria Bacteria 45.4 0.00594   NR MCC5835478.1 2026772 g8097 i0 42.9 0.463235294117647 42 24 46.3 0 129 4 137 178 MCC5835478.1 DUF3488 domain-containing protein [Opitutales bacterium] diamond 126 45.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales     Opitutales bacterium
30352501 30352501 PRJNA1093380_P_NODE_3892_length_315_cov_1.582645_g3786_i0 PRJNA1093380 3892 315 1.582645 4.98533175 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 43.9 0.0221   NR MEI6341235.1 2026799 g3786 i0 41.4 0.552380952380952 58 32 53.3 1 109 276 109 166 MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium] diamond 174 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
31110060 31110060 PRJNA1093380_P_NODE_15895_length_243_cov_1.388235_g15789_i0 PRJNA1093380 15895 243 1.388235 3.37341105 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 45.4 0.00409   NR HCE04986.1 2026801 g15789 i0 50 0.54320987654321 44 22 54.3 0 104 235 152 195 HCE04986.1 hypothetical protein [Verrucomicrobiales bacterium] diamond 132 45.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales 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);;