RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA407886", 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 · 11 ✖

tax_kingdom 1

tax_clade 1

  • PVC group · 11 ✖

bioproject 1

  • PRJNA407886 · 11 ✖

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
27170096 27170096 PRJNA407886_P_NODE_61302_length_271_cov_1.207071_g59608_i0 PRJNA407886 61302 271 1.207071 3.27116241 Opitutaceae bacterium 2006848 Bacteria Bacteria 117 4.13e-28   NR MBE2216508.1 2006848 g59608 i0 65.6 0.996309963099631 90 31 99.6 0 270 1 57 146 MBE2216508.1 PAS domain S-box protein [Opitutaceae bacterium] diamond 270 117 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
28355374 28355374 PRJNA407886_P_NODE_76726_length_245_cov_0.895349_g75032_i0 PRJNA407886 76726 245 0.895349 2.19360505 PVC group 1783257 Bacteria Bacteria 44.7 0.00803   NR GDX10959.1 2026799 g75032 i0 39.7 3.97959183673469 73 37 85.7 2 5 214 651 719 GDX10959.1 RNA-binding transcriptional accessory protein [Verrucomicrobiota bacterium] diamond 975 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29223041 29223041 PRJNA407886_P_NODE_32629_length_395_cov_1.400621_g30935_i0 PRJNA407886 32629 395 1.400621 5.53245295 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 128 7.399999999999999e-33   NR RYD71398.1 2026800 g30935 i0 49.2 1.00253164556962 132 65 98.7 2 1 390 62 193 RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] diamond 396 128 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
29492090 29492090 PRJNA407886_P_NODE_74950_length_247_cov_0.885057_g73256_i0 PRJNA407886 74950 247 0.885057 2.18609079 Candidatus Udaeobacter 1921511 Bacteria Bacteria 43.1 0.0272   NR PYK49983.1 2026799 g73256 i0 52.4 1.02024291497976 42 19 51 1 197 72 108 148 PYK49983.1 MAG: hypothetical protein DME51_07085, partial [Verrucomicrobiota bacterium] diamond 252 43.5 0.990804597701149 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
29980772 29980772 PRJNA407886_P_NODE_77051_length_245_cov_0.895349_g75357_i0 PRJNA407886 77051 245 0.895349 2.19360505 Chthoniobacterales bacterium 2201154 Bacteria Bacteria 42.4 0.0294   NR HEX8899378.1 2201154 g75357 i0 48.9 0.551020408163265 45 23 55.1 0 165 31 106 150 HEX8899378.1 hypothetical protein [Chthoniobacterales bacterium] diamond 135 42.4 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales     Chthoniobacterales bacterium
30107020 30107020 PRJNA407886_P_NODE_81652_length_241_cov_0.916667_g79958_i0 PRJNA407886 81652 241 0.916667 2.20916747 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 42 0.0324   NR MEN8255875.1 2026799 g79958 i0 44.4 0.560165975103734 45 25 56 0 22 156 53 97 MEN8255875.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 135 42 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30738917 30738917 PRJNA407886_P_NODE_27594_length_443_cov_2.081081_g25901_i0 PRJNA407886 27594 443 2.081081 9.21918883 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 202 1.13e-61   NR RYD65414.1 2026800 g25901 i0 81.7 0.778781038374718 115 21 77.9 0 435 91 222 336 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 345 202 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31276123 31276123 PRJNA407886_P_NODE_41215_length_340_cov_1.726592_g39521_i0 PRJNA407886 41215 340 1.726592 5.8704128 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 100 1.18e-22   NR RYD71398.1 2026800 g39521 i0 50 1.02352941176471 116 47 97.9 4 5 337 149 258 RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium] diamond 348 100 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31497760 31497760 PRJNA407886_P_NODE_36916_length_364_cov_1.955326_g35222_i0 PRJNA407886 36916 364 1.955326 7.11738664 Verrucomicrobiaceae bacterium 2026800 Bacteria Bacteria 167 2.6599999999999997e-48   NR RYD65414.1 2026800 g35222 i0 74.6 0.972527472527473 118 28 97.3 1 9 362 73 188 RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium] diamond 354 167 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae   Verrucomicrobiaceae bacterium
31497791 31497791 PRJNA407886_P_NODE_78656_length_243_cov_1.782353_g76962_i0 PRJNA407886 78656 243 1.782353 4.33111779 Opitutaceae bacterium 2006848 Bacteria Bacteria 50.8 4.59e-5   NR HEY9155313.1 2006848 g76962 i0 59.5 1.62962962962963 37 15 45.7 0 93 203 82 118 HEY9155313.1 MBL fold metallo-hydrolase [Opitutaceae bacterium] diamond 396 50.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae   Opitutaceae bacterium
32604723 32604723 PRJNA407886_P_NODE_61260_length_271_cov_1.363636_g59566_i0 PRJNA407886 61260 271 1.363636 3.69545356 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 113 6.5e-27   NR MEI7958366.1 2026799 g59566 i0 66.7 5.6789667896679 84 27 93 1 271 20 454 536 MEI7958366.1 hydroxylamine reductase [Verrucomicrobiota bacterium] diamond 1539 113 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);;