RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA438687", 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

  • PRJNA438687 · 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
8088591 8088591 PRJNA438687_S_NODE_7927_length_153_cov_3.152542_g7837_i0 PRJNA438687 7927 153 3.152542 4.82338926 uncultured Armatimonadetes bacterium 157466 Bacteria Bacteria 189 9.16e-44   NTclustered gi|2874254000|emb|OY970325.1| 157466 g7837 i0 92.424 314.281045751634 132 10 86 0 1 132 1304292 1304161 MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1 blastn 48085 189 1 Bacteria   Bacillati Armatimonadota         uncultured Armatimonadetes bacterium
24043110 24043110 PRJNA438687_S_NODE_7419_length_159_cov_2.088710_g7329_i0 PRJNA438687 7419 159 2.08871 3.3210489 Fimbriimonas 1005038 Bacteria Bacteria 255 9.35e-64   NTclustered gi|663071213|gb|CP007139.1| 661478 g7329 i0 96.154 32.3899371069182 156 6 98 0 3 158 28619 28774 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 5150 255 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
24661564 24661564 PRJNA438687_S_NODE_3980_length_223_cov_2.664894_g3890_i0 PRJNA438687 3980 223 2.664894 5.94271362 Armatimonadota bacterium 2033014 Bacteria Bacteria 95.3 3.24e-15   NTclustered gi|2108374973|gb|CP070648.1| 2033014 g3890 i0 85.263 0.426008968609865 95 11 42 3 6 98 208261 208168 MAG: Armatimonadetes bacterium isolate bin88 chromosome blastn 95 95.3 1 Bacteria   Bacillati Armatimonadota         Armatimonadota bacterium
25317411 25317411 PRJNA438687_S_NODE_5960_length_180_cov_2.468966_g5870_i0 PRJNA438687 5960 180 2.468966 4.4441388 Fimbriimonas 1005038 Bacteria Bacteria 219 1.4199999999999999e-52   NTclustered gi|663071213|gb|CP007139.1| 661478 g5870 i0 89.655 6.73888888888889 174 14 96 4 8 179 28376 28205 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 1213 219 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli

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);;