contig_metadata
7 rows where bioproject = "PRJNA1237347" and tax_phylum = "Candidatus Roizmaniibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22725243 | 22725243 | PRJNA1237347_P_NODE_319298_length_321_cov_1.725806_g312725_i0 | PRJNA1237347 | 319298 | 321 | 1.725806 | 5.53983726 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 99.8 | 2.5499999999999998e-24 | NR | MFS8159965.1 | 2282149 | g312725 | i0 | 60.5 | 0.803738317757009 | 86 | 26 | 72.9 | 2 | 321 | 88 | 25 | 110 | MFS8159965.1 DnaJ domain-containing protein [Candidatus Roizmanbacteria bacterium] | diamond | 258 | 99.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 26661279 | 26661279 | PRJNA1237347_P_NODE_344201_length_306_cov_2.266094_g337628_i0 | PRJNA1237347 | 344201 | 306 | 2.266094 | 6.93424764 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 44.3 | 0.0205 | NR | MFS8160610.1 | 2282149 | g337628 | i0 | 34.3 | 1 | 102 | 64 | 99 | 2 | 304 | 2 | 151 | 250 | MFS8160610.1 hypothetical protein [Candidatus Roizmanbacteria bacterium] | diamond | 306 | 44.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 28620535 | 28620535 | PRJNA1237347_P_NODE_200807_length_432_cov_2.348189_g194235_i0 | PRJNA1237347 | 200807 | 432 | 2.348189 | 10.14417648 | Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_ | 2282149 | Bacteria | Bacteria | 105 | 8.04e-24 | NR | OGK26231.1 | 1802040 | g194235 | i0 | 47.4 | 2.60416666666667 | 97 | 50 | 67.4 | 1 | 85 | 375 | 71 | 166 | OGK26231.1 MAG: 3-dehydroquinate synthase [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_39_9] | diamond | 1125 | 105 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_02_FULL_39_9 | ||||||
| 29472609 | 29472609 | PRJNA1237347_P_NODE_224310_length_402_cov_1.389058_g217738_i0 | PRJNA1237347 | 224310 | 402 | 1.389058 | 5.58401316 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 63.2 | 1.01e-8 | NR | NCO88365.1 | 2282149 | g217738 | i0 | 35.7 | 0.940298507462687 | 126 | 71 | 94 | 5 | 378 | 1 | 151 | 266 | NCO88365.1 pyrroline-5-carboxylate reductase [Candidatus Roizmanbacteria bacterium] | diamond | 378 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 29630315 | 29630315 | PRJNA1237347_P_NODE_166110_length_490_cov_1.985612_g159545_i0 | PRJNA1237347 | 166110 | 490 | 1.985612 | 9.7294988 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 45.4 | 0.0481 | NR | MBI4008973.1 | 2282149 | g159545 | i0 | 28.6 | 0.471428571428571 | 77 | 49 | 47.1 | 1 | 307 | 77 | 10 | 80 | MBI4008973.1 cation-translocating P-type ATPase [Candidatus Roizmanbacteria bacterium] | diamond | 231 | 45.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 30041768 | 30041768 | PRJNA1237347_P_NODE_74711_length_821_cov_4.537433_g68764_i0 | PRJNA1237347 | 74711 | 821 | 4.537433 | 37.25232493 | Candidatus Roizmanbacteria bacterium | 2282149 | Bacteria | Bacteria | 97.1 | 3.26e-19 | NR | MFS8160610.1 | 2282149 | g68764 | i0 | 29.9 | 1.86358099878197 | 251 | 169 | 90.3 | 3 | 743 | 3 | 64 | 311 | MFS8160610.1 hypothetical protein [Candidatus Roizmanbacteria bacterium] | diamond | 1530 | 97.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium | ||||||
| 30610410 | 30610410 | PRJNA1237347_P_NODE_99193_length_685_cov_1.986928_g92814_i0 | PRJNA1237347 | 99193 | 685 | 1.986928 | 13.6104568 | Candidatus Roizmanbacteria bacterium GW2 | 2282149 | Bacteria | Bacteria | 46.2 | 0.0172 | NR | KKQ23605.1 | 1618483 | g92814 | i0 | 42.1 | 0.332846715328467 | 38 | 22 | 16.6 | 0 | 680 | 567 | 100 | 137 | KKQ23605.1 MAG: Ribosomal protein L13 [Candidatus Roizmanbacteria bacterium GW2011_GWC1_37_12] | diamond | 228 | 46.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Roizmaniibacteriota | Candidatus Roizmanbacteria bacterium GW2011_GWC1_37_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);;