RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1200128" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1200128 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
27388830 27388830 PRJNA1200128_S_NODE_33103_length_173_cov_1.084615_g32994_i0 PRJNA1200128 33103 173 1.084615 1.87638395 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 40.8 0.0432   NR PYL54605.1 2026799 g32994 i0 44.4 0.780346820809249 45 24 76.3 1 1 132 26 70 PYL54605.1 MAG: hypothetical protein DMF29_06015 [Verrucomicrobiota bacterium] diamond 135 40.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27514948 27514948 PRJNA1200128_S_NODE_28963_length_181_cov_1.021739_g28854_i0 PRJNA1200128 28963 181 1.021739 1.84934759 Pelagicoccus sp. SDUM812 2921790 Bacteria Bacteria 42.7 0.0161   NR WP_309019849.1 3041267 g28854 i0 39.2 0.845303867403315 51 31 84.5 0 6 158 34 84 WP_309019849.1 CehA/McbA family metallohydrolase [Pelagicoccus sp. SDUM812003] diamond 153 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales Pelagicoccaceae Pelagicoccus Pelagicoccus sp. SDUM812003
29914802 29914802 PRJNA1200128_S_NODE_8671_length_264_cov_7.723982_g8562_i0 PRJNA1200128 8671 264 7.723982 20.39131248 Opitutia bacterium 2026771 Bacteria Bacteria 43.9 0.0189   NR MBI5425267.1 2026771 g8562 i0 39.7 1.97727272727273 58 29 62.5 2 203 39 299 353 MBI5425267.1 glycoside hydrolase family 2 [Opitutia bacterium] diamond 522 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia       Opitutia bacterium
31558159 31558159 PRJNA1200128_S_NODE_14656_length_224_cov_1.165746_g14547_i0 PRJNA1200128 14656 224 1.165746 2.61127104 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42.4 0.0394   NR MDX1951866.1 2026799 g14547 i0 34.8 0.616071428571429 46 30 61.6 0 148 11 226 271 MDX1951866.1 POTRA domain-containing protein [Verrucomicrobiota bacterium] diamond 138 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32570609 32570609 PRJNA1200128_S_NODE_8079_length_270_cov_3.070485_g7970_i0 PRJNA1200128 8079 270 3.070485 8.2903095 Prosthecobacter sp. 1965333 Bacteria Bacteria 46.2 0.0031   NR WP_395745445.1 1965333 g7970 i0 39.7 0.7 63 30 61.1 2 3 167 163 225 WP_395745445.1 O-antigen ligase family protein [Prosthecobacter sp.] diamond 189 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.

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);;