RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA615351 · 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
13349693 13349693 PRJNA615351_P_NODE_125571_length_236_cov_1.616915_g111471_i0 PRJNA615351 125571 236 1.616915 3.8159194 Peredibacter starrii 28202 Bacteria Bacteria 396 8.489999999999996e-106   NTclustered gi|2631252187|gb|CP139487.1| 28202 g111471 i0 97.414 155.194915254237 232 6 98 0 1 232 512686 512917 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 36626 396 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
20276375 20276375 PRJNA615351_P_NODE_141576_length_203_cov_2.767857_g127476_i0 PRJNA615351 141576 203 2.767857 5.61874971 Peredibacter 263370 Bacteria Bacteria 375 9.24e-100   NTclustered gi|2631252187|gb|CP139487.1| 28202 g127476 i0 100 223.068965517241 203 0 100 0 1 203 511429 511227 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 45283 375 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii
20997776 20997776 PRJNA615351_P_NODE_130697_length_224_cov_3.126984_g116597_i0 PRJNA615351 130697 224 3.126984 7.00444416 Bdellovibrio reynosensis 2835041 Bacteria Bacteria 392 1.0299999999999999e-104   NTclustered gi|2216477995|gb|CP093442.1| 2835041 g116597 i0 98.214 257.433035714286 224 4 100 0 1 224 950259 950482 Bdellovibrio reynosensis strain LBG001 chromosome, complete genome blastn 57665 392 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio reynosensis
24821873 24821873 PRJNA615351_P_NODE_184600_length_152_cov_1.478632_g170500_i0 PRJNA615351 184600 152 1.478632 2.24752064 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 231 1.49e-56   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g170500 i0 94.079 4.57894736842105 152 9 100 0 1 152 1292297 1292448 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 696 231 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198

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