RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA600413 · 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
3124330 3124330 PRJNA600413_P_NODE_141303_length_162_cov_0.902655_g140602_i0 PRJNA600413 141303 162 0.902655 1.4623011 Pseudobdellovibrio exovorus 453816 Bacteria Bacteria 300 4.36e-77   NTclustered gi|469929247|gb|CP003537.1| 1184267 g140602 i0 100 1 162 0 100 0 1 162 1782356 1782517 Bdellovibrio exovorus JSS, complete genome blastn 162 300 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Pseudobdellovibrio Pseudobdellovibrio exovorus
8226545 8226545 PRJNA600413_P_NODE_143007_length_162_cov_0.902655_g142306_i0 PRJNA600413 143007 162 0.902655 1.4623011 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 294 2.03e-75   NTclustered gi|2800924434|gb|CP168967.1| 959 g142306 i0 99.383 6.01851851851852 162 1 100 0 1 162 1050144 1049983 Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome blastn 975 294 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
9501805 9501805 PRJNA600413_P_NODE_144388_length_161_cov_1.821429_g143687_i0 PRJNA600413 144388 161 1.821429 2.93250069 Bdellovibrio bacteriovorus 959 Bacteria Bacteria 193 7.55e-45   NTclustered gi|425858678|gb|CP002930.1| 1069642 g143687 i0 88.199 1 161 19 100 0 1 161 2836544 2836704 Bdellovibrio bacteriovorus str. Tiberius, complete genome blastn 161 193 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio bacteriovorus
20977189 20977189 PRJNA600413_P_NODE_69137_length_187_cov_1.304348_g68436_i0 PRJNA600413 69137 187 1.304348 2.43913076 Bacteriovorax stolpii 960 Bacteria Bacteria 158 3.3000000000000003e-34   NTclustered gi|1326041851|gb|CP025704.1| 960 g68436 i0 85.621 2.20855614973262 153 18 81 4 37 187 1290786 1290936 Bacteriovorax stolpii strain DSM 12778 chromosome, complete genome blastn 413 158 1 Bacteria   Pseudomonadati Bdellovibrionota Bacteriovoracia Bacteriovoracales Bacteriovoracaceae Bacteriovorax Bacteriovorax stolpii
24093671 24093671 PRJNA600413_P_NODE_115299_length_165_cov_1.758621_g114598_i0 PRJNA600413 115299 165 1.758621 2.90172465 Pseudomonadati 3379134 Bacteria Bacteria 305 9.59e-79   NTclustered gi|1352809571|gb|MH013351.1| 28201 g114598 i0 100 99.6181818181818 165 0 100 0 1 165 463 299 Bdellovibrio sp. strain MPR08 16S ribosomal RNA gene, partial sequence blastn 16437 305 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales Pseudobdellovibrionaceae Bdellovibrio Bdellovibrio sp.

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