contig_metadata
6 rows where analysis = "diamond", bioproject = "PRJNA951810" and tax_phylum = "Candidatus Poribacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 937145 | 937145 | PRJNA951810_P_NODE_30901_length_360_cov_2.080139_g30559_i0 | PRJNA951810 | 30901 | 360 | 2.080139 | 7.4885004 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 177 | 6.950000000000001e-50 | NR | MCZ6678743.1 | 2026781 | g30559 | i0 | 67.2 | 3.96666666666667 | 119 | 39 | 99.2 | 0 | 2 | 358 | 428 | 546 | MCZ6678743.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Poribacteria bacterium] | diamond | 1428 | 177 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 27468190 | 27468190 | PRJNA951810_P_NODE_141383_length_264_cov_8.596859_g141038_i0 | PRJNA951810 | 141383 | 264 | 8.596859 | 22.69570776 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 103 | 3.36e-24 | NR | MBI1923897.1 | 2026781 | g141038 | i0 | 47.7 | 1.96590909090909 | 88 | 46 | 100 | 0 | 264 | 1 | 173 | 260 | MBI1923897.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 519 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29173195 | 29173195 | PRJNA951810_P_NODE_106489_length_289_cov_2.870370_g106145_i0 | PRJNA951810 | 106489 | 289 | 2.87037 | 8.2953693 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 122 | 6.48e-30 | NR | MEK7396107.1 | 2026781 | g106145 | i0 | 58.9 | 2.95847750865052 | 95 | 39 | 98.6 | 0 | 287 | 3 | 475 | 569 | MEK7396107.1 tetratricopeptide repeat protein [Candidatus Poribacteria bacterium] | diamond | 855 | 122 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30474622 | 30474622 | PRJNA951810_P_NODE_147813_length_259_cov_9.338710_g147468_i0 | PRJNA951810 | 147813 | 259 | 9.33871 | 24.1872589 | Bacillati | 1783272 | Bacteria | Bacteria | 99.8 | 4.03e-22 | NR | RKU28297.1 | 2026781 | g147468 | i0 | 59.7 | 4.66795366795367 | 77 | 31 | 89.2 | 0 | 233 | 3 | 194 | 270 | RKU28297.1 MAG: hypothetical protein C6495_15215 [Candidatus Poribacteria bacterium] | diamond | 1209 | 100 | 0.998 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30506179 | 30506179 | PRJNA951810_P_NODE_18173_length_463_cov_3.915385_g17838_i0 | PRJNA951810 | 18173 | 463 | 3.915385 | 18.12823255 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 130 | 6.249999999999998e-32 | NR | MFC1713498.1 | 2026781 | g17838 | i0 | 64.8 | 3.47300215982721 | 88 | 31 | 57 | 0 | 264 | 1 | 301 | 388 | MFC1713498.1 amidohydrolase [Candidatus Poribacteria bacterium] | diamond | 1608 | 130 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32680731 | 32680731 | PRJNA951810_P_NODE_128560_length_274_cov_2.820896_g128215_i0 | PRJNA951810 | 128560 | 274 | 2.820896 | 7.72925504 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 99 | 8.73e-22 | NR | MBM3215670.1 | 2026781 | g128215 | i0 | 57.3 | 2.14598540145985 | 96 | 35 | 98.5 | 2 | 270 | 1 | 290 | 385 | MBM3215670.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 588 | 99 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria 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);;