RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1095825" and tax_phylum = "Candidatus Deferrimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Deferrimicrobiota · 5 ✖

bioproject 1

  • PRJNA1095825 · 5 ✖

analysis 1

  • diamond · 5 ✖

tax_kingdom 0

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
22696466 22696466 PRJNA1095825_P_NODE_259418_length_247_cov_0.885057_g256355_i0 PRJNA1095825 259418 247 0.885057 2.18609079 Candidatus Deferrimicrobiaceae bacterium 3069220 Bacteria Bacteria 170 1.91e-51   NR HEX9204748.1 3069220 g256355 i0 97.6 1.9919028340081 82 2 99.6 0 2 247 85 166 HEX9204748.1 phosphoribosylglycinamide formyltransferase [Candidatus Deferrimicrobiaceae bacterium] diamond 492 170 1 Bacteria     Candidatus Deferrimicrobiota Candidatus Deferrimicrobia Candidatus Deferrimicrobiales Candidatus Deferrimicrobiaceae   Candidatus Deferrimicrobiaceae bacterium
29372900 29372900 PRJNA1095825_P_NODE_229489_length_255_cov_1.708791_g226426_i0 PRJNA1095825 229489 255 1.708791 4.35741705 Candidatus Deferrimicrobium borealis 2974938 Bacteria Bacteria 102 1.66e-23   NR MCP2501266.1 2974938 g226426 i0 93 0.670588235294118 57 4 67.1 0 173 3 1 57 MCP2501266.1 anaerobic C4-dicarboxylate transporter [Candidatus Deferrimicrobium borealis] diamond 171 102 1 Bacteria     Candidatus Deferrimicrobiota Candidatus Deferrimicrobia Candidatus Deferrimicrobiales Candidatus Deferrimicrobiaceae Candidatus Deferrimicrobium Candidatus Deferrimicrobium borealis
29814806 29814806 PRJNA1095825_P_NODE_200731_length_276_cov_1.349754_g197668_i0 PRJNA1095825 200731 276 1.349754 3.72532104 Candidatus Deferrimicrobiaceae bacterium 3069220 Bacteria Bacteria 99.4 7.13e-22   NR HSQ48097.1 3069220 g197668 i0 95.8 1.04347826086957 48 2 52.2 0 133 276 1 48 HSQ48097.1 SMC family ATPase [Candidatus Deferrimicrobiaceae bacterium] diamond 288 99.4 1 Bacteria     Candidatus Deferrimicrobiota Candidatus Deferrimicrobia Candidatus Deferrimicrobiales Candidatus Deferrimicrobiaceae   Candidatus Deferrimicrobiaceae bacterium
30952475 30952475 PRJNA1095825_P_NODE_198734_length_277_cov_1.882353_g195671_i0 PRJNA1095825 198734 277 1.882353 5.21411781 Candidatus Deferrimicrobiaceae bacterium 3069220 Bacteria Bacteria 149 4.0699999999999996e-42   NR HSL97342.1 3069220 g195671 i0 80 0.974729241877256 90 18 97.5 0 272 3 180 269 HSL97342.1 alpha/beta hydrolase [Candidatus Deferrimicrobiaceae bacterium] diamond 270 149 1 Bacteria     Candidatus Deferrimicrobiota Candidatus Deferrimicrobia Candidatus Deferrimicrobiales Candidatus Deferrimicrobiaceae   Candidatus Deferrimicrobiaceae bacterium
31236578 31236578 PRJNA1095825_P_NODE_246715_length_249_cov_1.517045_g243652_i0 PRJNA1095825 246715 249 1.517045 3.77744205 Candidatus Deferrimicrobium sp. 3060586 Bacteria Bacteria 137 1.28e-38   NR HZW01122.1 3060586 g243652 i0 80.5 0.987951807228916 82 16 98.8 0 2 247 67 148 HZW01122.1 hypothetical protein [Candidatus Deferrimicrobium sp.] diamond 246 137 1 Bacteria     Candidatus Deferrimicrobiota Candidatus Deferrimicrobia Candidatus Deferrimicrobiales Candidatus Deferrimicrobiaceae Candidatus Deferrimicrobium Candidatus Deferrimicrobium 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);;