contig_metadata
9 rows where bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3455530 | 3455530 | PRJNA928559_P_NODE_93463_length_368_cov_4.040678_g91894_i0 | PRJNA928559 | 93463 | 368 | 4.040678 | 14.86969504 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 300 | 1.13e-76 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g91894 | i0 | 82.789 | 28.1358695652174 | 337 | 56 | 91 | 2 | 10 | 345 | 442662 | 442997 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 10354 | 300 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 21304071 | 21304071 | PRJNA928559_P_NODE_111257_length_338_cov_2.083019_g109688_i0 | PRJNA928559 | 111257 | 338 | 2.083019 | 7.04060422 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 121 | 8.619999999999999e-23 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g109688 | i0 | 73.476 | 0.970414201183432 | 328 | 83 | 96 | 4 | 2 | 327 | 605205 | 605530 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 328 | 121 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 23856128 | 23856128 | PRJNA928559_P_NODE_29519_length_600_cov_223.703985_g27994_i0 | PRJNA928559 | 29519 | 600 | 223.703985 | 1342.22391 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 721 | 0 | NTclustered | gi|2258833497|gb|CP060226.1| | 2053688 | g27994 | i0 | 88.927 | 378.478333333333 | 587 | 61 | 98 | 4 | 6 | 590 | 814634 | 814050 | MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome | blastn | 227087 | 721 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27024822 | 27024822 | PRJNA928559_P_NODE_38222_length_539_cov_3.349785_g36668_i0 | PRJNA928559 | 38222 | 539 | 3.349785 | 18.05534115 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 176 | 3.17e-53 | NR | MDR0772399.1 | 2053688 | g36668 | i0 | 71.5 | 4.3469387755102 | 130 | 37 | 72.4 | 0 | 475 | 86 | 3 | 132 | MDR0772399.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 2343 | 176 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27024848 | 27024848 | PRJNA928559_P_NODE_96062_length_363_cov_6.489655_g94493_i0 | PRJNA928559 | 96062 | 363 | 6.489655 | 23.55744765 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 124 | 3.16e-33 | NR | USN57799.1 | 2053688 | g94493 | i0 | 64.6 | 0.933884297520661 | 113 | 40 | 93.4 | 0 | 363 | 25 | 79 | 191 | USN57799.1 MAG: ribosome recycling factor [Candidatus Peribacteria bacterium] | diamond | 339 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27277744 | 27277744 | PRJNA928559_P_NODE_101283_length_354_cov_2.932384_g99714_i0 | PRJNA928559 | 101283 | 354 | 2.932384 | 10.38063936 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 68.6 | 7.16e-11 | NR | USN58643.1 | 2053688 | g99714 | i0 | 77.6 | 1.24576271186441 | 49 | 11 | 41.5 | 0 | 311 | 165 | 124 | 172 | USN58643.1 MAG: efflux RND transporter permease subunit [Candidatus Peribacteria bacterium] | diamond | 441 | 68.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 28856300 | 28856300 | PRJNA928559_P_NODE_166168_length_271_cov_3.454545_g164599_i0 | PRJNA928559 | 166168 | 271 | 3.454545 | 9.36181695 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 45.1 | 5.1e-4 | NR | MDR1988402.1 | 2053688 | g164599 | i0 | 40.4 | 0.575645756457565 | 52 | 26 | 57.6 | 1 | 253 | 98 | 1 | 47 | MDR1988402.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 156 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 29677098 | 29677098 | PRJNA928559_P_NODE_91590_length_372_cov_2.066890_g90021_i0 | PRJNA928559 | 91590 | 372 | 2.06689 | 7.6888308 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 94 | 3.78e-21 | NR | USN58482.1 | 2053688 | g90021 | i0 | 62.2 | 0.596774193548387 | 74 | 27 | 58.9 | 1 | 346 | 128 | 77 | 150 | USN58482.1 MAG: trypsin-like peptidase domain-containing protein [Candidatus Peribacteria bacterium] | diamond | 222 | 94 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 31794589 | 31794589 | PRJNA928559_P_NODE_180757_length_258_cov_2.513514_g179188_i0 | PRJNA928559 | 180757 | 258 | 2.513514 | 6.48486612 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 66.6 | 1.99e-12 | NR | MDR2189825.1 | 2053688 | g179188 | i0 | 60.7 | 0.651162790697674 | 56 | 21 | 64 | 1 | 209 | 45 | 8 | 63 | MDR2189825.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 168 | 66.6 | 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);;