contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26725307 | 26725307 | PRJNA168635_P_NODE_11381_length_243_cov_1.257732_g10965_i0 | PRJNA168635 | 11381 | 243 | 1.257732 | 3.05628876 | Candidatus Peregrinibacteria bacterium GW2 | 2030811 | Bacteria | Bacteria | 47 | 5.26e-4 | NR | KKW40451.1 | 1619059 | g10965 | i0 | 55.8 | 0.530864197530864 | 43 | 19 | 53.1 | 0 | 224 | 96 | 6 | 48 | KKW40451.1 MAG: hypothetical protein UY90_C0081G0010 [Candidatus Peregrinibacteria bacterium GW2011_GWA2_54_9] | diamond | 129 | 47 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium GW2011_GWA2_54_9 | ||||||
| 26775408 | 26775408 | PRJNA168635_P_NODE_28221_length_166_cov_0.888889_g27805_i0 | PRJNA168635 | 28221 | 166 | 0.888889 | 1.47555574 | Bacteria | 2 | Bacteria | Bacteria | 84.3 | 2.89e-17 | NR | MFH0769777.1 | 2030811 | g27805 | i0 | 75.5 | 2.87349397590361 | 53 | 13 | 95.8 | 0 | 166 | 8 | 374 | 426 | MFH0769777.1 aspartate--tRNA ligase [Candidatus Peregrinibacteria bacterium] | diamond | 477 | 84.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 26852657 | 26852657 | PRJNA168635_P_NODE_19461_length_184_cov_1.533333_g19045_i0 | PRJNA168635 | 19461 | 184 | 1.533333 | 2.82133272 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 63.9 | 3.55e-10 | NR | NOS67372.1 | 2735830 | g19045 | i0 | 54.2 | 0.782608695652174 | 48 | 22 | 78.3 | 0 | 146 | 3 | 134 | 181 | NOS67372.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 144 | 63.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 29158322 | 29158322 | PRJNA168635_P_NODE_27649_length_166_cov_2.760684_g27233_i0 | PRJNA168635 | 27649 | 166 | 2.760684 | 4.58273544 | Candidatus Peregrinibacteria bacterium | 2030811 | Bacteria | Bacteria | 59.7 | 5.75e-9 | NR | MBI5156003.1 | 2030811 | g27233 | i0 | 67.3 | 0.885542168674699 | 49 | 16 | 88.6 | 0 | 2 | 148 | 131 | 179 | MBI5156003.1 30S ribosomal protein S5 [Candidatus Peregrinibacteria bacterium] | diamond | 147 | 59.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peregrinibacteria bacterium | ||||||
| 29442030 | 29442030 | PRJNA168635_P_NODE_27670_length_166_cov_2.478632_g27254_i0 | PRJNA168635 | 27670 | 166 | 2.478632 | 4.11452912 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 51.2 | 1.17e-5 | NR | MCK5019173.1 | 2735830 | g27254 | i0 | 47.3 | 0.993975903614458 | 55 | 28 | 99.4 | 1 | 166 | 2 | 51 | 104 | MCK5019173.1 ATP-grasp domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 165 | 51.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 30358756 | 30358756 | PRJNA168635_P_NODE_30172_length_164_cov_0.904348_g29756_i0 | PRJNA168635 | 30172 | 164 | 0.904348 | 1.48313072 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 72 | 6e-13 | NR | MCK5017875.1 | 2735830 | g29756 | i0 | 59.3 | 0.98780487804878 | 54 | 22 | 98.8 | 0 | 1 | 162 | 441 | 494 | MCK5017875.1 hypothetical protein [Candidatus Peribacteraceae bacterium] | diamond | 162 | 72 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 30674114 | 30674114 | PRJNA168635_P_NODE_24813_length_169_cov_4.166667_g24397_i0 | PRJNA168635 | 24813 | 169 | 4.166667 | 7.04166723 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 85.5 | 3.29e-20 | NR | MCB9807114.1 | 2053688 | g24397 | i0 | 80 | 1.97041420118343 | 55 | 10 | 95.9 | 1 | 164 | 3 | 1 | 55 | MCB9807114.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 333 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacteria bacterium | |||||
| 32160524 | 32160524 | PRJNA168635_P_NODE_32878_length_160_cov_2.423423_g32462_i0 | PRJNA168635 | 32878 | 160 | 2.423423 | 3.8774768 | Candidatus Peribacteraceae bacterium | 2735830 | Bacteria | Bacteria | 61.6 | 2.65e-9 | NR | MEQ1848962.1 | 2735830 | g32462 | i0 | 49.1 | 0.99375 | 53 | 27 | 99.4 | 0 | 1 | 159 | 47 | 99 | MEQ1848962.1 DUF4215 domain-containing protein [Candidatus Peribacteraceae bacterium] | diamond | 159 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Peregrinibacteriota | Candidatus Peribacteria | Candidatus Peribacterales | Candidatus Peribacteraceae bacterium | ||||
| 32540265 | 32540265 | PRJNA168635_P_NODE_24919_length_169_cov_2.533333_g24503_i0 | PRJNA168635 | 24919 | 169 | 2.533333 | 4.28133277 | Candidatus Peribacteria bacterium | 2053688 | Bacteria | Bacteria | 60.1 | 6.44e-9 | NR | MSR67662.1 | 2053688 | g24503 | i0 | 55.1 | 0.869822485207101 | 49 | 22 | 87 | 0 | 150 | 4 | 195 | 243 | MSR67662.1 hypothetical protein [Candidatus Peribacteria bacterium] | diamond | 147 | 60.1 | 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);;