RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA724039" 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

bioproject 1

  • PRJNA724039 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3745894 3745894 PRJNA724039_S_NODE_1403_length_682_cov_12.465116_g1235_i0 PRJNA724039 1403 682 12.465116 85.01209112 Chthonomonas 1077265 Bacteria Bacteria 630 6.869999999999997e-176   NTclustered gi|526641997|ref|NR_103994.1| 454171 g1235 i0 83.55 41.7243401759531 693 95 100 17 1 682 1144 1828 Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence blastn 28456 630 1 Bacteria   Bacillati Armatimonadota Chthonomonadia Chthonomonadales Chthonomonadaceae Chthonomonas Chthonomonas calidirosea
3745906 3745906 PRJNA724039_S_NODE_15863_length_160_cov_1.975610_g15656_i0 PRJNA724039 15863 160 1.97561 3.160976 Fimbriimonas 1005038 Bacteria Bacteria 196 5.79e-46   NTclustered gi|663071213|gb|CP007139.1| 661478 g15656 i0 88.957 151.4875 163 13 100 5 1 160 27966 28126 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 24238 196 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
20320591 20320591 PRJNA724039_S_NODE_17556_length_152_cov_2.843478_g17349_i0 PRJNA724039 17556 152 2.843478 4.32208656 Fimbriimonas 1005038 Bacteria Bacteria 219 1.16e-52   NTclustered gi|663071213|gb|CP007139.1| 661478 g17349 i0 95.588 8.43421052631579 136 6 89 0 1 136 28893 29028 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 1282 219 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
25420747 25420747 PRJNA724039_S_NODE_5660_length_291_cov_2.129921_g5453_i0 PRJNA724039 5660 291 2.129921 6.19807011 Fimbriimonas 1005038 Bacteria Bacteria 322 1.86e-83   NTclustered gi|663071213|gb|CP007139.1| 661478 g5453 i0 87.589 207.893470790378 282 29 96 6 1 279 28463 28185 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 60497 322 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);;