RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA681861" and tax_phylum = "Armatimonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Armatimonadota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA681861 · 5 ✖

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
3723155 3723155 PRJNA681861_P_NODE_4023_length_1207_cov_100.737691_g2990_i1 PRJNA681861 4023 1207 100.737691 1215.90393037 Fimbriimonas 1005038 Bacteria Bacteria 1118 0   NTclustered gi|663071213|gb|CP007139.1| 661478 g2990 i1 83.593 182.803645401823 1219 172 100 19 1 1207 29098 27896 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 220644 1118 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
11374987 11374987 PRJNA681861_P_NODE_16629_length_377_cov_38.554598_g14534_i0 PRJNA681861 16629 377 38.554598 145.35083446 Fimbriimonas 1005038 Bacteria Bacteria 507 6.38e-139   NTclustered gi|663071213|gb|CP007139.1| 661478 g14534 i0 91.398 219.649867374005 372 28 98 4 7 376 28811 29180 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 82808 512 0.990234375 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
14686626 14686626 PRJNA681861_P_NODE_47152_length_150_cov_2.735537_g45052_i0 PRJNA681861 47152 150 2.735537 4.1033055 Fimbriimonas sp. 1936159 Bacteria Bacteria 158 2.5199999999999998e-34   NTclustered gi|2778022393|emb|OZ123194.1| 1936159 g45052 i0 86.207 80.4266666666667 145 20 97 0 6 150 1687578 1687722 MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 blastn 12064 158 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas sp.
19023146 19023146 PRJNA681861_P_NODE_36135_length_187_cov_10.436709_g34035_i0 PRJNA681861 36135 187 10.436709 19.51664583 Fimbriimonas 1005038 Bacteria Bacteria 268 1.46e-67   NTclustered gi|663071213|gb|CP007139.1| 661478 g34035 i0 92.553 157.171122994652 188 12 99 2 1 186 27938 27751 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 29391 268 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
24123335 24123335 PRJNA681861_P_NODE_4019_length_1208_cov_107.579304_g2990_i0 PRJNA681861 4019 1208 107.579304 1299.55799232 Fimbriimonas 1005038 Bacteria Bacteria 1101 0   NTclustered gi|663071213|gb|CP007139.1| 661478 g2990 i0 83.388 255.823675496689 1222 170 100 21 1 1208 29098 27896 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 309035 1101 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);;