RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA382357", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 5 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 5 ✖

bioproject 1

  • PRJNA382357 · 5 ✖

analysis 1

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
28338388 28338388 PRJNA382357_P_NODE_138266_length_209_cov_2.641892_g137527_i0 PRJNA382357 138266 209 2.641892 5.52155428 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 76.6 1.75e-14   NR MFA7054871.1 2212473 g137527 i0 100 0.502392344497608 35 0 50.2 0 104 208 36 70 MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium] diamond 105 76.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28685947 28685947 PRJNA382357_P_NODE_65267_length_292_cov_1.393939_g64528_i0 PRJNA382357 65267 292 1.393939 4.07030188 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 51.6 4.94e-5   NR MBR4651764.1 2212473 g64528 i0 43.8 0.657534246575342 64 36 65.8 0 5 196 308 371 MBR4651764.1 hypothetical protein [Kiritimatiellia bacterium] diamond 192 51.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29538080 29538080 PRJNA382357_P_NODE_147370_length_205_cov_2.993056_g146631_i0 PRJNA382357 147370 205 2.993056 6.1357648 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.1 0.00355   NR MBQ6008779.1 2212473 g146631 i0 48.8 0.629268292682927 43 16 62.9 2 17 145 571 607 MBQ6008779.1 hypothetical protein [Kiritimatiellia bacterium] diamond 129 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29790550 29790550 PRJNA382357_P_NODE_155731_length_202_cov_0.921986_g154992_i0 PRJNA382357 155731 202 0.921986 1.86241172 Pontiellaceae bacterium 2813032 Bacteria Bacteria 58.9 4.34e-8   NR MBN2164190.1 2813032 g154992 i0 69.4 0.534653465346535 36 11 53.5 0 181 74 294 329 MBN2164190.1 S8 family serine peptidase [Pontiellaceae bacterium] diamond 108 58.9 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae   Pontiellaceae bacterium
32667222 32667222 PRJNA382357_P_NODE_93320_length_249_cov_41.537234_g92581_i0 PRJNA382357 93320 249 41.537234 103.42771266 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 99 1.56e-22   NR MFA7054871.1 2212473 g92581 i0 100 0.590361445783133 49 0 59 0 76 222 4 52 MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium] diamond 147 99 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia 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);;