RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB3181", tax_phylum = "Armatimonadota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_phylum 1

  • Armatimonadota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 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
2606027 2606027 PRJEB3181_S_NODE_18783_length_150_cov_3.217391_g18490_i0 PRJEB3181 18783 150 3.217391 4.8260865 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 176 6.95e-40   NTclustered gi|2076449834|gb|CP075365.1| 2682144 g18490 i0 88.889 107.18 144 15 96 1 1 144 1879398 1879540 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome blastn 16077 176 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
12809445 12809445 PRJEB3181_P_NODE_13651_length_228_cov_13.883249_g13387_i0 PRJEB3181 13651 228 13.883249 31.65380772 Armatimonadetes bacterium Uphvl-Ar2 2004468 Bacteria Bacteria 113 9.19e-21   NTclustered gi|1199101103|gb|CP021424.1| 2004468 g13387 i0 94.521 52.8377192982456 73 4 32 0 122 194 2200864 2200792 Armatimonadetes bacterium Uphvl-Ar2 genome blastn 12047 113 1 Bacteria   Bacillati Armatimonadota         Armatimonadetes bacterium Uphvl-Ar2
17907738 17907738 PRJEB3181_S_NODE_4215_length_288_cov_8.316206_g3922_i0 PRJEB3181 4215 288 8.316206 23.95067328 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 283 8.679999999999999e-72   NTclustered gi|2076452338|gb|CP075364.1| 2682144 g3922 i0 85.556 271.190972222222 270 39 94 0 1 270 667393 667662 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome blastn 78103 283 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
20115378 20115378 PRJEB3181_S_NODE_5376_length_261_cov_7.814159_g5083_i0 PRJEB3181 5376 261 7.814159 20.39495499 Fimbriimonas 1005038 Bacteria Bacteria 263 1.01e-65   NTclustered gi|663071213|gb|CP007139.1| 661478 g5083 i0 88.182 76.6858237547893 220 26 84 0 42 261 29788 29569 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 20015 263 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);;