RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1145574 · 8 ✖

analysis 1

  • diamond · 8 ✖

tax_clade 0

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
13042340 13042340 PRJNA1145574_P_NODE_14091_length_244_cov_0.912281_g13907_i0 PRJNA1145574 14091 244 0.912281 2.22596564 Bacteria 2 Bacteria Bacteria 152 1.4799999999999999e-40   NR HEV7676215.1 2976921 g13907 i0 93.8 8.96311475409836 81 5 99.6 0 244 2 413 493 HEV7676215.1 transcription-repair coupling factor [Candidatus Angelobacter sp.] diamond 2187 153 0.993464052287582 Bacteria   Pseudomonadati Acidobacteriota Terriglobia     Candidatus Angelobacter Candidatus Angelobacter sp.
27027803 27027803 PRJNA1145574_P_NODE_12442_length_249_cov_0.886364_g12258_i0 PRJNA1145574 12442 249 0.886364 2.20704636 Candidatus Angelobacter 2976915 Bacteria Bacteria 154 9.18e-45   NR MBZ5508830.1 2081523 g12258 i0 91.5 1.97590361445783 82 7 98.8 0 248 3 5 86 MBZ5508830.1 LytTR family DNA-binding domain-containing protein [Terriglobia bacterium] diamond 492 154 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
27418455 27418455 PRJNA1145574_P_NODE_14623_length_243_cov_0.917647_g14439_i0 PRJNA1145574 14623 243 0.917647 2.22988221 Acidobacteriota bacterium 1978231 Bacteria Bacteria 156 1.17e-43   NR MBU6216758.1 1978231 g14439 i0 92.6 1 81 6 100 0 243 1 131 211 MBU6216758.1 competence/damage-inducible protein A [Acidobacteriota bacterium] diamond 243 156 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
27986558 27986558 PRJNA1145574_P_NODE_11285_length_252_cov_0.871508_g11101_i0 PRJNA1145574 11285 252 0.871508 2.19620016 Terriglobia bacterium 2081523 Bacteria Bacteria 146 2.51e-39   NR MBZ5669062.1 2081523 g11101 i0 89.2 1.97619047619048 83 9 98.8 0 250 2 397 479 MBZ5669062.1 citramalate synthase [Terriglobia bacterium] diamond 498 146 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia       Terriglobia bacterium
28238925 28238925 PRJNA1145574_P_NODE_11826_length_251_cov_0.876404_g11642_i0 PRJNA1145574 11826 251 0.876404 2.19977404 Terriglobales bacterium 2282142 Bacteria Bacteria 129 4.35e-34   NR HKR82665.1 2282142 g11642 i0 87.5 0.860557768924303 72 9 86.1 0 1 216 209 280 HKR82665.1 IS110 family transposase [Terriglobales bacterium] diamond 216 129 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales     Terriglobales bacterium
28586605 28586605 PRJNA1145574_P_NODE_13107_length_247_cov_0.896552_g12923_i0 PRJNA1145574 13107 247 0.896552 2.21448344 Acidobacteriota bacterium 1978231 Bacteria Bacteria 93.6 3.57e-21   NR MBU6202563.1 1978231 g12923 i0 100 0.65587044534413 54 0 65.6 0 164 3 1 54 MBU6202563.1 hypothetical protein [Acidobacteriota bacterium] diamond 162 93.6 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
28618171 28618171 PRJNA1145574_P_NODE_12167_length_250_cov_0.881356_g11983_i0 PRJNA1145574 12167 250 0.881356 2.20339 Terracidiphilus sp. 1964191 Bacteria Bacteria 155 2.5299999999999992e-43   NR HMG84427.1 1964191 g11983 i0 88 1.992 83 10 99.6 0 2 250 166 248 HMG84427.1 DUF4382 domain-containing protein [Terracidiphilus sp.] diamond 498 155 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Terracidiphilus Terracidiphilus sp.
30639129 30639129 PRJNA1145574_P_NODE_12473_length_249_cov_0.886364_g12289_i0 PRJNA1145574 12473 249 0.886364 2.20704636 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 71.2 6.58e-13   NR MEN6603814.1 2212468 g12289 i0 87.1 0.373493975903614 31 4 37.3 0 248 156 176 206 MEN6603814.1 hypothetical protein [Bryobacteraceae bacterium] diamond 93 71.2 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales Bryobacteraceae   Bryobacteraceae 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);;