contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB11748" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11492187 | 11492187 | PRJEB11748_P_NODE_118550_length_381_cov_6.640625_g116375_i0 | PRJEB11748 | 118550 | 381 | 6.640625 | 25.30078125 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 52.8 | 1.97e-6 | NR | MDR0772487.1 | 2053688 | g116375 | i0 | 61.7 | 0.37007874015748 | 47 | 18 | 37 | 0 | 165 | 25 | 3 | 49 | MDR0772487.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 141 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 27349208 | 27349208 | PRJEB11748_P_NODE_290223_length_224_cov_4.214724_g288040_i0 | PRJEB11748 | 290223 | 224 | 4.214724 | 9.44098176 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 97.1 | 1.6000000000000002e-22 | NR | MDD5056178.1 | 2735830 | g288040 | i0 | 64.2 | 0.897321428571429 | 67 | 24 | 89.7 | 0 | 202 | 2 | 116 | 182 | MDD5056178.1 LlaMI family restriction endonuclease [Candidatus Peribacteraceae bacterium] | diamond | 201 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27538588 | 27538588 | PRJEB11748_P_NODE_360564_length_192_cov_5.778626_g358381_i0 | PRJEB11748 | 360564 | 192 | 5.778626 | 11.09496192 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 71.2 | 1.4e-12 | NR | MBP9850826.1 | 2735830 | g358381 | i0 | 63.3 | 0.9375 | 60 | 21 | 92.2 | 1 | 178 | 2 | 61 | 120 | MBP9850826.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 180 | 71.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 27910886 | 27910886 | PRJEB11748_P_NODE_362345_length_191_cov_7.161538_g360162_i0 | PRJEB11748 | 362345 | 191 | 7.161538 | 13.67853758 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 82.8 | 1.41e-16 | NR | OGJ62493.1 | 1801919 | g360162 | i0 | 65.6 | 1.91623036649215 | 61 | 21 | 95.8 | 0 | 9 | 191 | 172 | 232 | OGJ62493.1 MAG: DNA methyltransferase [Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15] | diamond | 366 | 82.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15 | |||||
| 29401329 | 29401329 | PRJEB11748_P_NODE_329789_length_206_cov_5.662069_g327606_i0 | PRJEB11748 | 329789 | 206 | 5.662069 | 11.66386214 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 44.3 | 0.00643 | NR | MCC6643316.1 | 2030811 | g327606 | i0 | 69 | 0.422330097087379 | 29 | 9 | 42.2 | 0 | 116 | 30 | 335 | 363 | MCC6643316.1 hypothetical protein [Candidatus Peregrinibacteria bacterium] | diamond | 87 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 31771209 | 31771209 | PRJEB11748_P_NODE_287937_length_225_cov_6.932927_g285754_i0 | PRJEB11748 | 287937 | 225 | 6.932927 | 15.59908575 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 72 | 9.43e-15 | NR | MCB9807183.1 | 2053688 | g285754 | i0 | 81 | 0.56 | 42 | 8 | 56 | 0 | 214 | 89 | 22 | 63 | MCB9807183.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 126 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 31986338 | 31986338 | PRJEB11748_P_NODE_303458_length_218_cov_1.490446_g301275_i0 | PRJEB11748 | 303458 | 218 | 1.490446 | 3.24917228 | Bacteria | 2 | Bacteria | Bacteria | 70.1 | 6.15e-12 | NR | OGJ63223.1 | 1801919 | g301275 | i0 | 79.5 | 3.22018348623853 | 39 | 8 | 53.7 | 0 | 3 | 119 | 549 | 587 | OGJ63223.1 MAG: DNA gyrase subunit A [Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15] | diamond | 702 | 70.5 | 0.994326241134752 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15 |
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);;