contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA340009" and tax_phylum = "Candidatus Azamiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4219118 | 4219118 | PRJNA340009_P_NODE_13964_length_315_cov_4.022556_g13657_i0 | PRJNA340009 | 13964 | 315 | 4.022556 | 12.6710514 | Bacteria | 2 | Bacteria | Bacteria | 155 | 5.4799999999999996e-42 | NR | KKS43927.1 | 1618615 | g13657 | i0 | 81.3 | 6.26666666666667 | 91 | 17 | 86.7 | 0 | 275 | 3 | 208 | 298 | KKS43927.1 MAG: gyrase subunit B protein [Candidatus Azambacteria bacterium GW2011_GWB1_42_17] | diamond | 1974 | 156 | 0.993589743589744 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium GW2011_GWB1_42_17 | ||||||
| 27074651 | 27074651 | PRJNA340009_P_NODE_10542_length_354_cov_4.216393_g10235_i0 | PRJNA340009 | 10542 | 354 | 4.216393 | 14.92603122 | Candidatus Azambacteria bacterium | 2053511 | Bacteria | Bacteria | 137 | 5.96e-39 | NR | MCR4323007.1 | 2053511 | g10235 | i0 | 64.2 | 0.898305084745763 | 106 | 38 | 89.8 | 0 | 35 | 352 | 1 | 106 | MCR4323007.1 hypothetical protein [Candidatus Azambacteria bacterium] | diamond | 318 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium | ||||||
| 27895856 | 27895856 | PRJNA340009_P_NODE_47465_length_187_cov_3.224638_g47158_i0 | PRJNA340009 | 47465 | 187 | 3.224638 | 6.03007306 | Candidatus Azambacteria bacterium | 2053511 | Bacteria | Bacteria | 65.9 | 1.19e-10 | NR | MDO8443671.1 | 2053511 | g47158 | i0 | 53.6 | 0.898395721925134 | 56 | 26 | 89.8 | 0 | 185 | 18 | 477 | 532 | MDO8443671.1 hypothetical protein [Candidatus Azambacteria bacterium] | diamond | 168 | 65.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium | ||||||
| 28513065 | 28513065 | PRJNA340009_P_NODE_15727_length_299_cov_5.424000_g15420_i0 | PRJNA340009 | 15727 | 299 | 5.424 | 16.21776 | Bacteria | 2 | Bacteria | Bacteria | 43.1 | 0.0139 | NR | KKU23009.1 | 1618619 | g15420 | i0 | 67.9 | 0.842809364548495 | 28 | 9 | 28.1 | 0 | 299 | 216 | 82 | 109 | KKU23009.1 MAG: hypothetical protein UX33_C0001G0042 [Candidatus Azambacteria bacterium GW2011_GWC1_46_13] | diamond | 252 | 43.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium GW2011_GWC1_46_13 | ||||||
| 29316764 | 29316764 | PRJNA340009_P_NODE_12629_length_329_cov_1.092857_g12322_i0 | PRJNA340009 | 12629 | 329 | 1.092857 | 3.59549953 | Candidatus Azambacteria bacterium RIFCSPLOWO2_ | 2053511 | Bacteria | Bacteria | 127 | 3.68e-34 | NR | OGD29632.1 | 1797304 | g12322 | i0 | 59.6 | 1.87841945288754 | 104 | 42 | 94.8 | 0 | 312 | 1 | 7 | 110 | OGD29632.1 MAG: hypothetical protein A3A18_00085 [Candidatus Azambacteria bacterium RIFCSPLOWO2_01_FULL_44_84] | diamond | 618 | 127 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium RIFCSPLOWO2_01_FULL_44_84 | ||||||
| 29537719 | 29537719 | PRJNA340009_P_NODE_17850_length_283_cov_18.636752_g17543_i0 | PRJNA340009 | 17850 | 283 | 18.636752 | 52.74200816 | Candidatus Azambacteria bacterium GW2 | 2053511 | Bacteria | Bacteria | 52.4 | 1.66e-6 | NR | KKU40128.1 | 1618623 | g17543 | i0 | 92.3 | 0.275618374558304 | 26 | 2 | 27.6 | 0 | 22 | 99 | 16 | 41 | KKU40128.1 MAG: hypothetical protein UX56_C0041G0010, partial [Candidatus Azambacteria bacterium GW2011_GWD2_46_48] | diamond | 78 | 52.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium GW2011_GWD2_46_48 | ||||||
| 30169317 | 30169317 | PRJNA340009_P_NODE_19412_length_273_cov_4.339286_g19105_i0 | PRJNA340009 | 19412 | 273 | 4.339286 | 11.84625078 | Candidatus Azambacteria bacterium | 2053511 | Bacteria | Bacteria | 160 | 7.499999999999998e-44 | NR | MDO8743053.1 | 2053511 | g19105 | i0 | 92.2 | 0.989010989010989 | 90 | 7 | 98.9 | 0 | 271 | 2 | 449 | 538 | MDO8743053.1 ATP-dependent DNA helicase RecG [Candidatus Azambacteria bacterium] | diamond | 270 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium | ||||||
| 30628840 | 30628840 | PRJNA340009_P_NODE_34013_length_215_cov_4.373494_g33706_i0 | PRJNA340009 | 34013 | 215 | 4.373494 | 9.4030121 | Bacteria | 2 | Bacteria | Bacteria | 124 | 1.89e-32 | NR | KKQ92901.1 | 1618611 | g33706 | i0 | 81.7 | 4.95348837209302 | 71 | 13 | 99.1 | 0 | 1 | 213 | 96 | 166 | KKQ92901.1 MAG: tRNA dimethylallyltransferase [Candidatus Azambacteria bacterium GW2011_GWA2_39_10] | diamond | 1065 | 124 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium GW2011_GWA2_39_10 | ||||||
| 30976757 | 30976757 | PRJNA340009_P_NODE_64194_length_166_cov_0.871795_g63887_i0 | PRJNA340009 | 64194 | 166 | 0.871795 | 1.4471797 | Bacteria | 2 | Bacteria | Bacteria | 91.3 | 3.22e-20 | NR | KKT82154.1 | 1618610 | g63887 | i0 | 83 | 6.72289156626506 | 53 | 9 | 95.8 | 0 | 2 | 160 | 160 | 212 | KKT82154.1 MAG: Tryptophan-tRNA ligase [Candidatus Azambacteria bacterium GW2011_GWA1_44_9] | diamond | 1116 | 92 | 0.992391304347826 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria bacterium GW2011_GWA1_44_9 | ||||||
| 32824398 | 32824398 | PRJNA340009_P_NODE_81240_length_150_cov_13.079208_g80933_i0 | PRJNA340009 | 81240 | 150 | 13.079208 | 19.618812 | Candidatus Azambacteria bacterium | 2053511 | Bacteria | Bacteria | 48.9 | 2.47e-5 | NR | MDO8742988.1 | 2053511 | g80933 | i0 | 53.3 | 0.9 | 45 | 21 | 90 | 0 | 142 | 8 | 93 | 137 | MDO8742988.1 uL15 family ribosomal protein [Candidatus Azambacteria bacterium] | diamond | 135 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Azamiibacteriota | Candidatus Azambacteria 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);;