RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA640350" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA640350 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
26713388 26713388 PRJNA640350_P_NODE_32761_length_165_cov_2.845588_g32600_i0 PRJNA640350 32761 165 2.845588 4.6952202 Pseudomonadati 3379134 Bacteria Bacteria 96.7 1.3e-21   NR HTG15699.1 2052146 g32600 i0 88.9 2.94545454545455 54 6 98.2 0 2 163 49 102 HTG15699.1 AAA family ATPase [Blastocatellia bacterium] diamond 486 96.7 1 Bacteria   Pseudomonadati Acidobacteriota Blastocatellia       Blastocatellia bacterium
28217770 28217770 PRJNA640350_P_NODE_40126_length_152_cov_0.918699_g39965_i0 PRJNA640350 40126 152 0.918699 1.39642248 Geothrix sp. 1962974 Bacteria Bacteria 41.6 0.0278   NR MCC6512416.1 1962974 g39965 i0 46.3 1.61842105263158 41 21 80.9 1 137 15 11 50 MCC6512416.1 hypothetical protein [Geothrix sp.] diamond 246 41.6 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp.
29323004 29323004 PRJNA640350_P_NODE_40109_length_152_cov_1.097561_g39948_i0 PRJNA640350 40109 152 1.097561 1.66829272 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 55.8 2.53e-7   NR HWO34008.1 3069120 g39948 i0 67.5 0.789473684210526 40 12 77 1 2 118 79 118 HWO34008.1 GumC family protein [Candidatus Acidiferrum sp.] diamond 120 55.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
30870891 30870891 PRJNA640350_P_NODE_38794_length_154_cov_1.448000_g38633_i0 PRJNA640350 38794 154 1.448 2.22992 Acidobacteriota bacterium 1978231 Bacteria Bacteria 59.7 1.05e-8   NR PYS45357.1 1978231 g38633 i0 56.8 1.73376623376623 44 19 85.7 0 152 21 225 268 PYS45357.1 MAG: hypothetical protein DMG13_32345, partial [Acidobacteriota bacterium] diamond 267 59.7 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31882594 31882594 PRJNA640350_P_NODE_39397_length_153_cov_1.443548_g39236_i0 PRJNA640350 39397 153 1.443548 2.20862844 Candidatus Acidiferrum sp. 3069120 Bacteria Bacteria 60.8 4.52e-9   NR HWO34008.1 3069120 g39236 i0 60 0.980392156862745 50 20 98 0 153 4 167 216 HWO34008.1 GumC family protein [Candidatus Acidiferrum sp.] diamond 150 60.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Candidatus Acidiferrales   Candidatus Acidiferrum Candidatus Acidiferrum sp.
32104164 32104164 PRJNA640350_P_NODE_41418_length_150_cov_1.140496_g41257_i0 PRJNA640350 41418 150 1.140496 1.710744 Bryobacteraceae bacterium 2212468 Bacteria Bacteria 54.7 6.07e-7   NR HEY3837980.1 2212468 g41257 i0 62.5 2.92 48 18 96 0 5 148 89 136 HEY3837980.1 acyltransferase [Bryobacteraceae bacterium] diamond 438 54.7 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);;