RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA488043 · 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
26886692 26886692 PRJNA488043_P_NODE_14861_length_230_cov_1.522388_g12619_i0 PRJNA488043 14861 230 1.522388 3.5014924 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 92 8.15e-20   NR MDQ5979581.1 2026799 g12619 i0 65.7 0.873913043478261 67 23 87.4 0 4 204 339 405 MDQ5979581.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 201 92 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
26949668 26949668 PRJNA488043_P_NODE_16682_length_206_cov_2.186441_g14440_i0 PRJNA488043 16682 206 2.186441 4.50406846 Chthoniobacter sp. 2510640 Bacteria Bacteria 60.1 1.75e-8   NR MDB6151469.1 2510640 g14440 i0 37.3 0.975728155339806 67 42 97.6 0 5 205 564 630 MDB6151469.1 hypothetical protein [Chthoniobacter sp.] diamond 201 60.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Chthoniobacter Chthoniobacter sp.
28766052 28766052 PRJNA488043_P_NODE_20687_length_165_cov_2.014706_g18445_i0 PRJNA488043 20687 165 2.014706 3.3242649 Pseudomonadati 3379134 Bacteria Bacteria 53.5 1.76e-6   NR PWU04916.1 2026799 g18445 i0 56.1 2.96363636363636 41 18 74.5 0 125 3 184 224 PWU04916.1 MAG: terminase, partial [Verrucomicrobiota bacterium] diamond 489 53.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29823387 29823387 PRJNA488043_P_NODE_7811_length_424_cov_2.845570_g5632_i0 PRJNA488043 7811 424 2.84557 12.0652168 Chthoniobacter sp. 2510640 Bacteria Bacteria 79 2.52e-15   NR MDB6151505.1 2510640 g5632 i0 39.8 0.658018867924528 93 56 65.8 0 280 2 1 93 MDB6151505.1 helix-turn-helix protein [Chthoniobacter sp.] diamond 279 79 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae Chthoniobacter Chthoniobacter sp.
30329617 30329617 PRJNA488043_P_NODE_19172_length_180_cov_1.761589_g16930_i0 PRJNA488043 19172 180 1.761589 3.1708602 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 53.9 1.7e-6   NR MCS7008470.1 2201154 g16930 i0 66.7 0.75 45 13 71.7 1 180 52 250 294 MCS7008470.1 pentapeptide repeat-containing protein [Chthoniobacterales bacterium] diamond 135 53.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
31656406 31656406 PRJNA488043_P_NODE_4377_length_658_cov_2.265501_g2584_i0 PRJNA488043 4377 658 2.265501 14.90699658 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 60.5 3.87e-8   NR MDQ5978039.1 2026799 g2584 i0 48.4 0.282674772036474 62 32 28.3 0 599 414 1 62 MDQ5978039.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 186 60.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
32699896 32699896 PRJNA488043_P_NODE_20720_length_165_cov_1.330882_g18478_i0 PRJNA488043 20720 165 1.330882 2.1959553 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 109 1.15e-29   NR MDQ5978784.1 2026799 g18478 i0 94.4 0.981818181818182 54 3 98.2 0 165 4 27 80 MDQ5978784.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 162 109 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;