contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Candidatus Peregrinibacteriota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12004401 | 12004401 | PRJNA556992_P_NODE_209950_length_322_cov_1.236948_g207762_i0 | PRJNA556992 | 209950 | 322 | 1.236948 | 3.98297256 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 305 | 2.1e-78 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g207762 | i0 | 91.781 | 83.0683229813665 | 219 | 18 | 68 | 0 | 60 | 278 | 1195650 | 1195432 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 26748 | 305 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 13287892 | 13287892 | PRJNA556992_P_NODE_849351_length_243_cov_2.711765_g847161_i0 | PRJNA556992 | 849351 | 243 | 2.711765 | 6.5895889499999996 | Candidatus Peribacter riflensis | 1735162 | Bacteria | Bacteria | 248 | 2.6e-61 | NTclustered | gi|946529367|gb|CP013062.1| | 1735162 | g847161 | i0 | 85.656 | 165.925925925926 | 244 | 25 | 99 | 8 | 3 | 243 | 1195099 | 1194863 | MAG: Candidatus Peribacter riflensis, complete genome | blastn | 40320 | 248 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacter | Candidatus Peribacter riflensis | |||
| 13288127 | 13288127 | PRJNA556992_P_NODE_868371_length_242_cov_2.757396_g866181_i0 | PRJNA556992 | 868371 | 242 | 2.757396 | 6.67289832 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 217 | 7.3e-52 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g866181 | i0 | 88.701 | 4.64876033057851 | 177 | 20 | 73 | 0 | 40 | 216 | 813837 | 813661 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 1125 | 217 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 18380873 | 18380873 | PRJNA556992_P_NODE_465215_length_270_cov_2.502538_g463026_i0 | PRJNA556992 | 465215 | 270 | 2.502538 | 6.7568526 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 113 | 1.12e-20 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g463026 | i0 | 81.295 | 0.514814814814815 | 139 | 26 | 51 | 0 | 15 | 153 | 928971 | 929109 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 139 | 113 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 22205262 | 22205262 | PRJNA556992_P_NODE_393738_length_277_cov_2.098039_g391549_i0 | PRJNA556992 | 393738 | 277 | 2.098039 | 5.81156803 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 226 | 1.42e-54 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g391549 | i0 | 82.49 | 1.78339350180505 | 257 | 45 | 93 | 0 | 21 | 277 | 1016056 | 1016312 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 494 | 226 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;