RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where bioproject = "PRJNA414225", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 9 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 9 ✖

bioproject 1

  • PRJNA414225 · 9 ✖

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
1693795 1693795 PRJNA414225_P_NODE_65082_length_165_cov_0.879310_g64995_i0 PRJNA414225 65082 165 0.87931 1.4508615 Prosthecobacter 48463 Bacteria Bacteria 100 2.85e-24   NR WP_395751687.1 1965333 g64995 i0 85.2 1.96363636363636 54 8 98.2 0 165 4 174 227 WP_395751687.1 phytanoyl-CoA dioxygenase family protein [Prosthecobacter sp.] diamond 324 101 0.99009900990099 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Prosthecobacter Prosthecobacter sp.
20820680 20820680 PRJNA414225_P_NODE_63537_length_165_cov_0.879310_g63450_i0 PRJNA414225 63537 165 0.87931 1.4508615 Pseudomonadati 3379134 Bacteria Bacteria 105 4.02e-25   NR MBS0604634.1 2026799 g63450 i0 92.7 2 55 4 100 0 165 1 246 300 MBS0604634.1 acetyl-CoA carboxylase biotin carboxylase subunit [Verrucomicrobiota bacterium] diamond 330 106 0.990566037735849 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27802240 27802240 PRJNA414225_P_NODE_42564_length_170_cov_1.603306_g42477_i0 PRJNA414225 42564 170 1.603306 2.7256202 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 95.5 3e-21   NR MCI0538197.1 2026801 g42477 i0 91.1 0.794117647058823 45 4 79.4 0 2 136 450 494 MCI0538197.1 type IV secretion system DNA-binding domain-containing protein [Verrucomicrobiales bacterium] diamond 135 95.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
27896706 27896706 PRJNA414225_P_NODE_52225_length_167_cov_0.864407_g52138_i0 PRJNA414225 52225 167 0.864407 1.44355969 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 98.6 2.1e-23   NR PYI45510.1 2026799 g52138 i0 85.2 5.82035928143713 54 8 97 0 6 167 150 203 PYI45510.1 MAG: hypothetical protein DMF10_11180 [Verrucomicrobiota bacterium] diamond 972 98.6 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
27976558 27976558 PRJNA414225_P_NODE_29425_length_179_cov_1.569231_g29338_i0 PRJNA414225 29425 179 1.569231 2.80892349 Bacteria 2 Bacteria Bacteria 70.5 2.18e-12   NR MFM1746879.1 2026799 g29338 i0 67.3 5.73184357541899 55 16 92.2 1 179 15 251 303 MFM1746879.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 1026 71.2 0.990168539325843 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28086147 28086147 PRJNA414225_P_NODE_17645_length_189_cov_1.457143_g17558_i0 PRJNA414225 17645 189 1.457143 2.75400027 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 113 7.71e-29   NR MBI3850644.1 2026799 g17558 i0 85.5 2.95238095238095 62 9 98.4 0 1 186 99 160 MBI3850644.1 esterase family protein [Verrucomicrobiota bacterium] diamond 558 113 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30186872 30186872 PRJNA414225_P_NODE_64472_length_165_cov_0.879310_g64385_i0 PRJNA414225 64472 165 0.87931 1.4508615 PVC group 1783257 Bacteria Bacteria 48.1 1.57e-4   NR MBI2924480.1 2026799 g64385 i0 54.5 1.6 44 20 80 0 30 161 59 102 MBI2924480.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 264 48.5 0.991752577319588 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30675720 30675720 PRJNA414225_P_NODE_22673_length_185_cov_1.500000_g22586_i0 PRJNA414225 22673 185 1.5 2.775 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 113 2.4199999999999998e-27   NR HEV8543922.1 2499141 g22586 i0 91.8 1.97837837837838 61 5 98.9 0 184 2 20 80 HEV8543922.1 biosynthetic-type acetolactate synthase large subunit [Verrucomicrobiia bacterium] diamond 366 113 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
31687383 31687383 PRJNA414225_P_NODE_79337_length_163_cov_0.894737_g79250_i0 PRJNA414225 79337 163 0.894737 1.45842131 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 91.3 9.73e-20   NR HEX5221043.1 2499141 g79250 i0 78.8 3.82822085889571 52 11 95.7 0 6 161 499 550 HEX5221043.1 HAD-IIB family hydrolase [Verrucomicrobiia bacterium] diamond 624 91.3 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia 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);;