RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1111146 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
216350 216350 PRJNA1111146_P_NODE_323821_length_184_cov_0.870229_g322683_i0 PRJNA1111146 323821 184 0.870229 1.60122136 Peredibacter starrii 28202 Bacteria Bacteria 152 1.4999999999999995e-32   NTclustered gi|2631252187|gb|CP139487.1| 28202 g322683 i0 85.915 1.54347826086957 142 20 77 0 1 142 3444556 3444697 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 284 152 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
1021465 1021465 PRJNA1111146_P_NODE_187081_length_209_cov_1.243590_g185943_i0 PRJNA1111146 187081 209 1.24359 2.5991031000000002 Peredibacter 263370 Bacteria Bacteria 333 5.839999999999999e-87   NTclustered gi|2631252187|gb|CP139487.1| 28202 g185943 i0 95.694 126.875598086124 209 6 100 3 1 209 511828 512033 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 26517 333 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
11695838 11695838 PRJNA1111146_P_NODE_7530_length_574_cov_1.489443_g6423_i0 PRJNA1111146 7530 574 1.489443 8.54940282 Peredibacter starrii 28202 Bacteria Bacteria 922 0   NTclustered gi|2631252187|gb|CP139487.1| 28202 g6423 i0 95.66 312.771777003484 576 22 100 2 1 574 512621 512047 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 179531 922 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
15518817 15518817 PRJNA1111146_P_NODE_274953_length_191_cov_2.079710_g273815_i0 PRJNA1111146 274953 191 2.07971 3.9722461 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 97.1 7.48e-16   NTclustered gi|2893356071|emb|OZ220494.1| 2053517 g273815 i0 98.182 39.5968586387435 55 1 29 0 1 55 967600 967546 MAG: Bdellovibrionales bacterium isolate 95f108ca-4012-4f55-a596-77f5f94b2342 genome assembly, chromosome: 1 blastn 7563 97.1 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
16792803 16792803 PRJNA1111146_P_NODE_14334_length_419_cov_1.581967_g13200_i0 PRJNA1111146 14334 419 1.581967 6.62844173 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 547 4.219999999999998e-151   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g13200 i0 90.215 142.477326968974 419 41 100 0 1 419 1292768 1292350 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 59698 547 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198
21423597 21423597 PRJNA1111146_P_NODE_195337_length_207_cov_1.474026_g194199_i0 PRJNA1111146 195337 207 1.474026 3.05123382 Bacteriovorax 146784 Bacteria Bacteria 322 1.25e-83   NTclustered gi|1700689994|gb|CP030035.1| 960 g194199 i0 94.686 262.434782608696 207 11 100 0 1 207 1660889 1661095 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 54324 322 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii

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