RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA206070 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
5469406 5469406 PRJNA206070_S_NODE_10265_length_373_cov_30.869048_g8390_i0 PRJNA206070 10265 373 30.869048 115.14154904 Fimbriimonas ginsengisoli 1005039 Bacteria Bacteria 425 1.81e-114   NTclustered gi|663071213|gb|CP007139.1| 661478 g8390 i0 90.244 64.4504021447721 328 28 87 4 41 366 29469 29794 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 24040 425 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas ginsengisoli
5470071 5470071 PRJNA206070_S_NODE_9325_length_406_cov_33.292683_g7452_i0 PRJNA206070 9325 406 33.292683 135.16829298 Fimbriimonas sp. 1936159 Bacteria Bacteria 640 6.54e-179   NTclustered gi|2778022393|emb|OZ123194.1| 1936159 g7452 i0 95.074 905.536945812808 406 20 100 0 1 406 1687578 1687983 MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1 blastn 367648 640 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas Fimbriimonas sp.
8019478 8019478 PRJNA206070_S_NODE_12047_length_322_cov_120.140351_g10171_i0 PRJNA206070 12047 322 120.140351 386.85193022 uncultured Fimbriimonas sp. 1936177 Bacteria Bacteria 512 1.1499999999999998e-140   NTclustered gi|1154724300|gb|KX379253.1| 1936177 g10171 i0 95.342 98.9409937888199 322 15 100 0 1 322 15 336 Uncultured Fimbriimonas sp. clone OD-9 16S ribosomal RNA gene, partial sequence blastn 31859 512 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae Fimbriimonas uncultured Fimbriimonas sp.
10570438 10570438 PRJNA206070_S_NODE_22989_length_184_cov_3.319728_g21113_i0 PRJNA206070 22989 184 3.319728 6.10829952 Fimbriimonadaceae bacterium 2682144 Bacteria Bacteria 228 2.4299999999999996e-55   NTclustered gi|2076449834|gb|CP075365.1| 2682144 g21113 i0 90.643 41.5597826086956 171 16 93 0 1 171 1878813 1878983 MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome blastn 7647 228 1 Bacteria   Bacillati Armatimonadota Fimbriimonadia Fimbriimonadales Fimbriimonadaceae   Fimbriimonadaceae bacterium
14395214 14395214 PRJNA206070_S_NODE_13272_length_296_cov_4.096525_g11396_i0 PRJNA206070 13272 296 4.096525 12.125714 Fimbriimonas ginsengisoli 1005039 Bacteria Bacteria 309 1.48e-79   NTclustered gi|663071213|gb|CP007139.1| 661478 g11396 i0 85.619 1.01013513513514 299 38 100 5 1 296 1625531 1625827 Fimbriimonas ginsengisoli Gsoil 348, complete genome blastn 299 309 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);;