RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA407886 · 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
2968427 2968427 PRJNA407886_P_NODE_56223_length_285_cov_1.103774_g54529_i0 PRJNA407886 56223 285 1.103774 3.1457559 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 449 7.99e-122   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g54529 i0 95.088 218.484210526316 285 14 100 0 1 285 1292996 1293280 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 62268 449 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198
12561015 12561015 PRJNA407886_P_NODE_52330_length_296_cov_2.071749_g50636_i0 PRJNA407886 52330 296 2.071749 6.13237704 Bacteriovorax 146784 Bacteria Bacteria 523 4.849999999999998e-144   NTclustered gi|1700689994|gb|CP030035.1| 960 g50636 i0 98.644 178.266891891892 295 4 99 0 2 296 1662373 1662667 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 52767 523 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
18933406 18933406 PRJNA407886_P_NODE_23815_length_498_cov_1.336471_g22124_i0 PRJNA407886 23815 498 1.336471 6.65562558 Bacteriovorax 146784 Bacteria Bacteria 544 6.579999999999998e-150   NTclustered gi|1700689994|gb|CP030035.1| 960 g22124 i0 86.454 163.142570281125 502 60 100 8 1 498 1660860 1660363 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 81245 544 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);;