RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA680334", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

  • Bacillati · 4 ✖

bioproject 1

  • PRJNA680334 · 4 ✖

analysis 1

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
8302915 8302915 PRJNA680334_S_NODE_33827_length_216_cov_12.360656_g33341_i0 PRJNA680334 33827 216 12.360656 26.69901696 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 189 1.3899999999999996e-43   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g33341 i0 84.946 77.4398148148148 186 28 86 0 22 207 667598 667413 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 16727 189 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
10097928 10097928 PRJNA680334_S_NODE_35008_length_214_cov_3.718232_g34522_i0 PRJNA680334 35008 214 3.718232 7.95701648 Bacteria 2 Bacteria Bacteria 102 1.85e-17   NTclustered gi|2874253971|emb|OY970296.1| 157466 g34522 i0 82.5 15.6355140186916 120 17 55 4 80 196 4214085 4214203 MAG: uncultured Armatimonadetes bacterium isolate MFD04408.bin.1.1 genome assembly, chromosome: 1 blastn 3346 102 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
19021020 19021020 PRJNA680334_S_NODE_32655_length_219_cov_2.612903_g32169_i0 PRJNA680334 32655 219 2.612903 5.72225757 Fimbriimonas 1005038 Bacteria Bacteria 239 1.39e-58   NTclustered gi|2778022393|emb|OZ123194.1| 1936159 g32169 i0 86.486 6.78082191780822 222 25 100 4 1 219 1690467 1690248 MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 blastn 1485 239 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas sp.
19777063 19777063 PRJNA680334_S_NODE_68396_length_173_cov_13.107143_g67910_i0 PRJNA680334 68396 173 13.107143 22.67535739 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 134 5.050000000000001e-27   NTclustered gi|2874254000|emb|OY970325.1| 157466 g67910 i0 88.889 31.1734104046243 108 12 62 0 7 114 1307022 1306915 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 5393 134 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes 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);;