RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA715462 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
5809292 5809292 PRJNA715462_P_NODE_26185_length_352_cov_0.824373_g25389_i0 PRJNA715462 26185 352 0.824373 2.90179296 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 52.8 0.033   NTclustered gi|2626289182|emb|OY843585.1| 2053517 g25389 i0 100 0.0795454545454545 28 0 8 0 40 67 298368 298341 MAG: Bdellovibrionales bacterium isolate 022bb5af-5c53-4953-82b0-2ef8059d9f16 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
19044006 19044006 PRJNA715462_P_NODE_29715_length_327_cov_2.421260_g28919_i0 PRJNA715462 29715 327 2.42126 7.9175202 Peredibacter 263370 Bacteria Bacteria 544 4.16e-150   NTclustered gi|2631252187|gb|CP139487.1| 28202 g28919 i0 96.646 211.079510703364 328 10 100 1 1 327 511251 511578 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 69023 549 0.990892531876138 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
19833198 19833198 PRJNA715462_P_NODE_57296_length_247_cov_1.770115_g56500_i0 PRJNA715462 57296 247 1.770115 4.37218405 Bdellovibrio sp. HCB117 3394359 Bacteria Bacteria 198 2.71e-46   NTclustered gi|2895987660|gb|CP178622.1| 3394359 g56500 i0 81.481 1.73279352226721 243 43 98 2 6 247 2734488 2734729 Bdellovibrio sp. HCB117 chromosome, complete genome blastn 428 198 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp. HCB117

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