RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA980585", 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

  • PRJNA980585 · 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
26804556 26804556 PRJNA980585_P_NODE_43441_length_250_cov_0.870056_g43187_i0 PRJNA980585 43441 250 0.870056 2.17514 Pontiellaceae bacterium 2813032 Bacteria Bacteria 83.6 1.77e-16   NR MCU0857130.1 2813032 g43187 i0 58.3 1.008 84 33 99.6 2 1 249 78 160 MCU0857130.1 type VI secretion system tip protein VgrG [Pontiellaceae bacterium] diamond 252 83.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae   Pontiellaceae bacterium
27380180 27380180 PRJNA980585_P_NODE_51663_length_246_cov_0.890173_g51409_i0 PRJNA980585 51663 246 0.890173 2.18982558 Pseudomonadati 3379134 Bacteria Bacteria 118 1.03e-28   NR MAW40554.1 2026752 g51409 i0 63.4 21 82 30 100 0 246 1 435 516 MAW40554.1 acetate--CoA ligase [Kiritimatiellaceae bacterium] diamond 5166 119 0.991596638655462 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Kiritimatiellaceae   Kiritimatiellaceae bacterium
28226101 28226101 PRJNA980585_P_NODE_56446_length_243_cov_0.905882_g56192_i0 PRJNA980585 56446 243 0.905882 2.20129326 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 73.2 5.95e-13   NR MBR4894321.1 2212473 g56192 i0 42.5 3.95061728395062 80 46 98.8 0 241 2 240 319 MBR4894321.1 GTPase ObgE [Kiritimatiellia bacterium] diamond 960 73.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29022193 29022193 PRJNA980585_P_NODE_26028_length_291_cov_1.059633_g25774_i0 PRJNA980585 26028 291 1.059633 3.08353203 Pseudomonadati 3379134 Bacteria Bacteria 62.4 2.75e-9   NR MBQ3746059.1 2212473 g25774 i0 38.9 4.84536082474227 95 50 97.9 2 3 287 55 141 MBQ3746059.1 hypothetical protein [Kiritimatiellia bacterium] diamond 1410 62.8 0.993630573248408 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31795937 31795937 PRJNA980585_P_NODE_20197_length_322_cov_1.449799_g19943_i0 PRJNA980585 20197 322 1.449799 4.66835278 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 124 7.039999999999999e-32   NR MEX2606178.1 2212473 g19943 i0 53.3 2.96273291925466 105 49 97.8 0 5 319 97 201 MEX2606178.1 hypothetical protein [Kiritimatiellia bacterium] diamond 954 124 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);;