contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax_phylum = "Candidatus Rokuibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7270792 | 7270792 | PRJNA911178_P_NODE_260966_length_247_cov_0.885057_g258492_i0 | PRJNA911178 | 260966 | 247 | 0.885057 | 2.18609079 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 153 | 3.1099999999999993e-43 | NR | RPH84604.1 | 2053607 | g258492 | i0 | 97.6 | 0.995951417004049 | 82 | 2 | 99.6 | 0 | 2 | 247 | 214 | 295 | RPH84604.1 MAG: acyl-CoA dehydrogenase [Candidatus Rokuibacteriota bacterium] | diamond | 246 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 21652388 | 21652388 | PRJNA911178_P_NODE_255957_length_248_cov_0.880000_g253483_i0 | PRJNA911178 | 255957 | 248 | 0.88 | 2.1824 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 147 | 1.92e-41 | NR | PYN82044.1 | 2053607 | g253483 | i0 | 85.4 | 2.93951612903226 | 82 | 12 | 99.2 | 0 | 1 | 246 | 27 | 108 | PYN82044.1 MAG: peptide ABC transporter permease [Candidatus Rokuibacteriota bacterium] | diamond | 729 | 147 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 25476715 | 25476715 | PRJNA911178_P_NODE_241040_length_251_cov_0.865169_g238566_i0 | PRJNA911178 | 241040 | 251 | 0.865169 | 2.17157419 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 160 | 1.62e-45 | NR | RPH82858.1 | 2053607 | g238566 | i0 | 100 | 0.9800796812749 | 82 | 0 | 98 | 0 | 251 | 6 | 100 | 181 | RPH82858.1 MAG: MFS transporter [Candidatus Rokuibacteriota bacterium] | diamond | 246 | 160 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 26929598 | 26929598 | PRJNA911178_P_NODE_261282_length_247_cov_0.885057_g258808_i0 | PRJNA911178 | 261282 | 247 | 0.885057 | 2.18609079 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 153 | 1.0899999999999997e-42 | NR | MET0484219.1 | 2053607 | g258808 | i0 | 96.2 | 0.959514170040486 | 79 | 3 | 96 | 0 | 245 | 9 | 286 | 364 | MET0484219.1 phospholipase D-like domain-containing protein [Candidatus Rokuibacteriota bacterium] | diamond | 237 | 153 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28192865 | 28192865 | PRJNA911178_P_NODE_199606_length_272_cov_1.371859_g197133_i0 | PRJNA911178 | 199606 | 272 | 1.371859 | 3.73145648 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 96.7 | 1.46e-22 | NR | PYN44503.1 | 2053607 | g197133 | i0 | 73.5 | 3.02205882352941 | 68 | 18 | 75 | 0 | 67 | 270 | 5 | 72 | PYN44503.1 MAG: hypothetical protein DMD95_10570 [Candidatus Rokuibacteriota bacterium] | diamond | 822 | 96.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28666834 | 28666834 | PRJNA911178_P_NODE_263227_length_247_cov_0.862069_g260753_i0 | PRJNA911178 | 263227 | 247 | 0.862069 | 2.12931043 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 163 | 7.919999999999999e-48 | NR | PYO07977.1 | 2053607 | g260753 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 247 | 5 | 85 | 165 | PYO07977.1 MAG: catechol 2,3-dioxygenase [Candidatus Rokuibacteriota bacterium] | diamond | 243 | 163 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 28863468 | 28863468 | PRJNA911178_P_NODE_277448_length_244_cov_0.900585_g274974_i0 | PRJNA911178 | 277448 | 244 | 0.900585 | 2.1974274 | Bacteria | 2 | Bacteria | Bacteria | 109 | 7.61e-28 | NR | PYN58582.1 | 2053607 | g274974 | i0 | 70.4 | 8.96311475409836 | 81 | 24 | 99.6 | 0 | 243 | 1 | 78 | 158 | PYN58582.1 MAG: thiamine phosphate synthase [Candidatus Rokuibacteriota bacterium] | diamond | 2187 | 110 | 0.990909090909091 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 29393030 | 29393030 | PRJNA911178_P_NODE_199569_length_272_cov_1.391960_g197096_i0 | PRJNA911178 | 199569 | 272 | 1.39196 | 3.7861312 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 104 | 3.42e-24 | NR | PYM68630.1 | 2053607 | g197096 | i0 | 92.2 | 0.5625 | 51 | 4 | 56.3 | 0 | 154 | 2 | 185 | 235 | PYM68630.1 MAG: hypothetical protein DME10_26750 [Candidatus Rokuibacteriota bacterium] | diamond | 153 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 31098588 | 31098588 | PRJNA911178_P_NODE_258115_length_248_cov_0.880000_g255641_i0 | PRJNA911178 | 258115 | 248 | 0.88 | 2.1824 | Candidatus Rokuibacteriota bacterium | 2053607 | Bacteria | Bacteria | 159 | 4.0199999999999994e-46 | NR | MBI2207809.1 | 2053607 | g255641 | i0 | 90.2 | 3.96774193548387 | 82 | 8 | 99.2 | 0 | 1 | 246 | 172 | 253 | MBI2207809.1 4-hydroxy-tetrahydrodipicolinate synthase [Candidatus Rokuibacteriota bacterium] | diamond | 984 | 159 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokuibacteriota bacterium | ||||||
| 32459047 | 32459047 | PRJNA911178_P_NODE_276119_length_244_cov_0.900585_g273645_i0 | PRJNA911178 | 276119 | 244 | 0.900585 | 2.1974274 | Candidatus Rokubacteria bacterium 13_2_2 | 1805374 | Bacteria | Bacteria | 103 | 2.0499999999999999e-23 | NR | OLB00775.1 | 1805374 | g273645 | i0 | 77.6 | 2.40983606557377 | 58 | 13 | 71.3 | 0 | 178 | 5 | 4 | 61 | OLB00775.1 MAG: hypothetical protein AUH09_02970 [Candidatus Rokubacteria bacterium 13_2_20CM_70_12] | diamond | 588 | 103 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Rokuibacteriota | Candidatus Rokubacteria bacterium 13_2_20CM_70_12 |
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);;