RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1103784" 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

  • PRJNA1103784 · 3 ✖

analysis 1

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
2295614 2295614 PRJNA1103784_P_NODE_2782_length_325_cov_1.027778_g2727_i0 PRJNA1103784 2782 325 1.027778 3.3402785 Bacteriovorax 146784 Bacteria Bacteria 296 1.28e-75   NTclustered gi|1700689994|gb|CP030035.1| 960 g2727 i0 83.75 230.249230769231 320 45 97 7 10 325 1660680 1660364 Bacteriovorax stolpii strain AC01 chromosome, complete genome blastn 74831 296 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
12965945 12965945 PRJNA1103784_P_NODE_1371_length_433_cov_1.772222_g1316_i0 PRJNA1103784 1371 433 1.772222 7.67372126 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 717 0   NTclustered gi|2800948966|gb|CP168973.1| 959 g1316 i0 96.536 207.831408775982 433 15 100 0 1 433 1677153 1677585 Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome blastn 89991 717 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
19337949 19337949 PRJNA1103784_P_NODE_5096_length_261_cov_1.452128_g5041_i0 PRJNA1103784 5096 261 1.452128 3.79005408 Peredibacter starrii 28202 Bacteria Bacteria 436 5.619999999999999e-118   NTclustered gi|2631252187|gb|CP139487.1| 28202 g5041 i0 97.276 170.662835249042 257 7 98 0 1 257 512148 511892 Peredibacter starrii strain A3.12 chromosome, complete genome blastn 44543 436 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Peredibacter Peredibacter starrii

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