contig_metadata
7 rows where bioproject = "PRJNA1120060" and tax_phylum = "Candidatus Uhriibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27195086 | 27195086 | PRJNA1120060_P_NODE_2070762_length_270_cov_1.380711_g2052725_i0 | PRJNA1120060 | 2070762 | 270 | 1.380711 | 3.7279197 | Candidatus Uhrbacteria bacterium CG_4_1 | 2053634 | Bacteria | Bacteria | 60.1 | 5.16e-9 | NR | PIX62545.1 | 1975030 | g2052725 | i0 | 38.6 | 1.84444444444444 | 83 | 51 | 92.2 | 0 | 22 | 270 | 45 | 127 | PIX62545.1 MAG: ribonuclease H [Candidatus Uhrbacteria bacterium CG_4_10_14_3_um_filter_41_21] | diamond | 498 | 60.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium CG_4_10_14_3_um_filter_41_21 | ||||||
| 27889713 | 27889713 | PRJNA1120060_P_NODE_1768805_length_282_cov_1.913876_g1750794_i0 | PRJNA1120060 | 1768805 | 282 | 1.913876 | 5.39713032 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 43.9 | 0.00898 | NR | MBI2483672.1 | 2053634 | g1750794 | i0 | 45.5 | 0.468085106382979 | 44 | 24 | 46.8 | 0 | 142 | 11 | 9 | 52 | MBI2483672.1 ribonuclease HI family protein [Candidatus Uhrbacteria bacterium] | diamond | 132 | 43.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 29374289 | 29374289 | PRJNA1120060_P_NODE_248449_length_441_cov_4.059783_g231631_i0 | PRJNA1120060 | 248449 | 441 | 4.059783 | 17.90364303 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 52.8 | 1.7e-5 | NR | MBI2483672.1 | 2053634 | g231631 | i0 | 33.9 | 0.802721088435374 | 118 | 65 | 71.4 | 2 | 125 | 439 | 4 | 121 | MBI2483672.1 ribonuclease HI family protein [Candidatus Uhrbacteria bacterium] | diamond | 354 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 30731893 | 30731893 | PRJNA1120060_P_NODE_1544114_length_291_cov_2.977064_g1526123_i0 | PRJNA1120060 | 1544114 | 291 | 2.977064 | 8.66325624 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 41.2 | 0.035 | NR | HBU27800.1 | 2053634 | g1526123 | i0 | 36.1 | 0.371134020618557 | 36 | 23 | 37.1 | 0 | 57 | 164 | 15 | 50 | HBU27800.1 hypothetical protein [Candidatus Uhrbacteria bacterium] | diamond | 108 | 41.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 31808021 | 31808021 | PRJNA1120060_P_NODE_3309777_length_226_cov_4.666667_g3291667_i0 | PRJNA1120060 | 3309777 | 226 | 4.666667 | 10.54666742 | Candidatus Uhrbacteria bacterium GW2 | 2053634 | Bacteria | Bacteria | 45.8 | 0.00226 | NR | KKW32249.1 | 1618980 | g3291667 | i0 | 38.6 | 0.756637168141593 | 57 | 32 | 75.7 | 1 | 53 | 223 | 140 | 193 | KKW32249.1 MAG: hypothetical protein UY77_C0030G0004 [Candidatus Uhrbacteria bacterium GW2011_GWA2_53_10] | diamond | 171 | 45.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium GW2011_GWA2_53_10 | ||||||
| 32661498 | 32661498 | PRJNA1120060_P_NODE_3130560_length_234_cov_5.161491_g3112456_i0 | PRJNA1120060 | 3130560 | 234 | 5.161491 | 12.07788894 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 41.6 | 0.0439 | NR | MBI4592390.1 | 2053634 | g3112456 | i0 | 43.1 | 0.653846153846154 | 51 | 29 | 65.4 | 0 | 233 | 81 | 86 | 136 | MBI4592390.1 ribonuclease HI family protein [Candidatus Uhrbacteria bacterium] | diamond | 153 | 41.6 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria bacterium | ||||||
| 32756210 | 32756210 | PRJNA1120060_P_NODE_3162340_length_233_cov_2.868750_g3144236_i0 | PRJNA1120060 | 3162340 | 233 | 2.86875 | 6.6841875 | Candidatus Uhrbacteria bacterium | 2053634 | Bacteria | Bacteria | 42.4 | 0.0427 | NR | MBI4276371.1 | 2053634 | g3144236 | i0 | 32.1 | 0.721030042918455 | 56 | 35 | 68.2 | 1 | 173 | 15 | 82 | 137 | MBI4276371.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Uhrbacteria bacterium] | diamond | 168 | 42.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Uhriibacteriota | Candidatus Uhrbacteria 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);;