contig_metadata
6 rows where bioproject = "PRJEB11748" and tax_phylum = "Candidatus Magasanikiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26875008 | 26875008 | PRJEB11748_P_NODE_293661_length_222_cov_11.788820_g291478_i0 | PRJEB11748 | 293661 | 222 | 11.78882 | 26.1711804 | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_ | 2026717 | Bacteria | Bacteria | 94.7 | 1.87e-22 | NR | OGH58722.1 | 1798671 | g291478 | i0 | 65.2 | 0.932432432432432 | 69 | 24 | 93.2 | 0 | 208 | 2 | 1 | 69 | OGH58722.1 MAG: hypothetical protein A2725_03430 [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_33_34] | diamond | 207 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_33_34 | ||||||
| 26969570 | 26969570 | PRJEB11748_P_NODE_40302_length_686_cov_15.428800_g38273_i0 | PRJEB11748 | 40302 | 686 | 15.4288 | 105.841568 | Candidatus Magasanikbacteria bacterium GW2 | 2026717 | Bacteria | Bacteria | 261 | 4.93e-84 | NR | KKW42223.1 | 1619044 | g38273 | i0 | 69.8 | 1.55685131195335 | 179 | 54 | 78.3 | 0 | 664 | 128 | 18 | 196 | KKW42223.1 MAG: 50S ribosomal protein L2 [Candidatus Magasanikbacteria bacterium GW2011_GWA2_56_11] | diamond | 1068 | 261 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWA2_56_11 | ||||||
| 27696598 | 27696598 | PRJEB11748_P_NODE_222524_length_265_cov_17.318627_g220341_i0 | PRJEB11748 | 222524 | 265 | 17.318627 | 45.89436155 | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_ | 2026717 | Bacteria | Bacteria | 110 | 8.07e-29 | NR | OGH64316.1 | 1798672 | g220341 | i0 | 85.7 | 0.713207547169811 | 63 | 9 | 71.3 | 0 | 265 | 77 | 87 | 149 | OGH64316.1 MAG: hypothetical protein A2821_04100 [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23] | diamond | 189 | 110 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23 | ||||||
| 27753402 | 27753402 | PRJEB11748_P_NODE_105204_length_406_cov_66.220290_g103032_i0 | PRJEB11748 | 105204 | 406 | 66.22029 | 268.8543774 | Bacteria | 2 | Bacteria | Bacteria | 73.2 | 3.24e-12 | NR | OGH64045.1 | 1798672 | g103032 | i0 | 45.1 | 1.3448275862069 | 91 | 45 | 63.5 | 2 | 395 | 138 | 185 | 275 | OGH64045.1 MAG: hypothetical protein A2821_03505 [Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23] | diamond | 546 | 73.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium RIFCSPHIGHO2_01_FULL_41_23 | ||||||
| 29148995 | 29148995 | PRJEB11748_P_NODE_122649_length_374_cov_9.456869_g120473_i0 | PRJEB11748 | 122649 | 374 | 9.456869 | 35.36869006 | Candidatus Magasanikbacteria bacterium CG1_ | 2026717 | Bacteria | Bacteria | 66.2 | 1.41e-10 | NR | OIO20310.1 | 1805238 | g120473 | i0 | 66.7 | 1.22727272727273 | 51 | 17 | 40.9 | 0 | 199 | 351 | 1 | 51 | OIO20310.1 MAG: hypothetical protein AUJ23_00585 [Candidatus Magasanikbacteria bacterium CG1_02_32_51] | diamond | 459 | 66.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium CG1_02_32_51 | ||||||
| 31828111 | 31828111 | PRJEB11748_P_NODE_326317_length_208_cov_1.122449_g324134_i0 | PRJEB11748 | 326317 | 208 | 1.122449 | 2.33469392 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 95.5 | 6.290000000000001e-21 | NR | KKU12746.1 | 1619050 | g324134 | i0 | 83.3 | 2.625 | 60 | 10 | 86.5 | 0 | 22 | 201 | 547 | 606 | KKU12746.1 MAG: RstB [Candidatus Magasanikbacteria bacterium GW2011_GWC2_45_8] | diamond | 546 | 95.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Magasanikiibacteriota | Candidatus Magasanikbacteria bacterium GW2011_GWC2_45_8 |
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);;