contig_metadata
6 rows where bioproject = "PRJNA694770", tax_clade = "Bacteria candidate phyla" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8329006 | 8329006 | PRJNA694770_P_NODE_93607_length_244_cov_0.900585_g93313_i0 | PRJNA694770 | 93607 | 244 | 0.900585 | 2.1974274 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 135 | 7.99e-36 | NR | MBI2453223.1 | 2030811 | g93313 | i0 | 77.8 | 4.97950819672131 | 81 | 18 | 99.6 | 0 | 244 | 2 | 276 | 356 | MBI2453223.1 adenylosuccinate lyase [Candidatus Peregrinibacteria bacterium] | diamond | 1215 | 135 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 23628500 | 23628500 | PRJNA694770_P_NODE_90999_length_245_cov_0.895349_g90705_i0 | PRJNA694770 | 90999 | 245 | 0.895349 | 2.19360505 | Bacteria | 2 | Bacteria | Bacteria | 139 | 3.14e-37 | NR | MFH0820624.1 | 2030811 | g90705 | i0 | 76.5 | 8.9265306122449 | 81 | 19 | 99.2 | 0 | 2 | 244 | 260 | 340 | MFH0820624.1 serine--tRNA ligase [Candidatus Peregrinibacteria bacterium] | diamond | 2187 | 139 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 27114049 | 27114049 | PRJNA694770_P_NODE_95722_length_243_cov_0.905882_g95428_i0 | PRJNA694770 | 95722 | 243 | 0.905882 | 2.20129326 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 92 | 1.69e-19 | NR | HVW66767.1 | 2735830 | g95428 | i0 | 53.2 | 2.90123456790123 | 79 | 37 | 97.5 | 0 | 237 | 1 | 89 | 167 | HVW66767.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 705 | 92 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 28041528 | 28041528 | PRJNA694770_P_NODE_50585_length_295_cov_1.734234_g50291_i0 | PRJNA694770 | 50585 | 295 | 1.734234 | 5.1159903 | Bacteria | 2 | Bacteria | Bacteria | 104 | 1.56e-25 | NR | MBN2087122.1 | 2030811 | g50291 | i0 | 51 | 2.94915254237288 | 96 | 47 | 97.6 | 0 | 5 | 292 | 114 | 209 | MBN2087122.1 ribulose-phosphate 3-epimerase [Candidatus Peregrinibacteria bacterium] | diamond | 870 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 28598621 | 28598621 | PRJNA694770_P_NODE_31587_length_357_cov_0.750000_g31293_i0 | PRJNA694770 | 31587 | 357 | 0.75 | 2.6775 | Candidatus Peregrinibacteria bacterium RIFCSPLOWO2_ | 2030811 | Bacteria | Bacteria | 178 | 4.75e-54 | NR | OGJ45670.1 | 1801900 | g31293 | i0 | 75.6 | 1 | 119 | 29 | 100 | 0 | 1 | 357 | 5 | 123 | OGJ45670.1 MAG: hypothetical protein A3J23_01810 [Candidatus Peregrinibacteria bacterium RIFCSPLOWO2_02_FULL_48_14] | diamond | 357 | 178 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium RIFCSPLOWO2_02_FULL_48_14 | ||||||
| 29893267 | 29893267 | PRJNA694770_P_NODE_86891_length_247_cov_0.885057_g86597_i0 | PRJNA694770 | 86891 | 247 | 0.885057 | 2.18609079 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 132 | 1.57e-33 | NR | MBD3360537.1 | 2030811 | g86597 | i0 | 75.6 | 35.8178137651822 | 82 | 20 | 99.6 | 0 | 2 | 247 | 577 | 658 | MBD3360537.1 type IV secretion system DNA-binding domain-containing protein [Candidatus Peregrinibacteria bacterium] | diamond | 8847 | 132 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria 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);;