RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJEB7799" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJEB7799 · 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
25799293 25799293 PRJEB7799g_S_NODE_17035_length_155_cov_1.150000_g16819_i0 PRJEB7799 17035 155 1.15 1.7825 Peredibacter sp. HCB2-198 3383025 Bacteria Bacteria 250 4.21e-62   NTclustered gi|2867657404|gb|CP174607.1| 3383025 g16819 i0 100 82.6129032258064 135 0 87 0 1 135 1293188 1293322 Peredibacter sp. HCB2-198 chromosome, complete genome blastn 12805 250 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter sp. HCB2-198
26071783 26071783 PRJEB7799i_S_NODE_8085_length_173_cov_2.376812_g8055_i0 PRJEB7799 8085 173 2.376812 4.11188476 Micavibrio aeruginosavorus ARL-13 856793 Bacteria Bacteria 148 1.7999999999999998e-31   NTclustered gi|347589306|gb|CP002382.1| 856793 g8055 i0 82.081 4.32947976878613 173 31 100 0 1 173 878515 878687 Micavibrio aeruginosavorus ARL-13, complete genome blastn 749 148 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Micavibrio Micavibrio aeruginosavorus
26297366 26297366 PRJEB7799m_S_NODE_318_length_285_cov_2.948000_g313_i0 PRJEB7799 318 285 2.948 8.4018 Bacteriovorax 146784 Bacteria Bacteria 252 2.42e-62   NTclustered gi|1700689994|gb|CP030035.1| 960 g313 i0 82.927 242.168421052632 287 42 99 7 2 285 1660692 1660410 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 69018 252 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
26297420 26297420 PRJEB7799n_S_NODE_3430_length_243_cov_4.750000_g3393_i0 PRJEB7799 3430 243 4.75 11.5425 Bacteriovorax 146784 Bacteria Bacteria 211 3.41e-50   NTclustered gi|1700689994|gb|CP030035.1| 960 g3393 i0 82.787 281.522633744856 244 35 100 7 1 240 1660427 1660667 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 68410 211 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
26480222 26480222 PRJEB7799i_S_NODE_9784_length_160_cov_3.720000_g9754_i0 PRJEB7799 9784 160 3.72 5.952 Bdellovibrio sp. HCB117 3394359 Bacteria Bacteria 54.7 0.004   NTclustered gi|2895987660|gb|CP178622.1| 3394359 g9754 i0 100 0.18125 29 0 18 0 99 127 2938422 2938450 Bdellovibrio sp. HCB117 chromosome, complete genome blastn 29 54.7 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);;