contig_metadata
6 rows where bioproject = "PRJNA1118794", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4057427 | 4057427 | PRJNA1118794_P_NODE_31764_length_287_cov_2.775701_g31014_i0 | PRJNA1118794 | 31764 | 287 | 2.775701 | 7.96626187 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 237 | 6.83e-58 | NTclustered | gi|2621703088|emb|OY760517.1| | 2614255 | g31014 | i0 | 83.658 | 647.519163763066 | 257 | 36 | 89 | 6 | 2 | 255 | 3133500 | 3133247 | MAG: Melioribacteraceae bacterium isolate c8b6aad9-4aa7-488e-baf1-dd4234e1cecc genome assembly, chromosome: 1 | blastn | 185838 | 237 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 27352785 | 27352785 | PRJNA1118794_P_NODE_52843_length_249_cov_1.625000_g52093_i0 | PRJNA1118794 | 52843 | 249 | 1.625 | 4.04625 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 77 | 3.4e-14 | NR | MEI9971262.1 | 2026749 | g52093 | i0 | 61.5 | 1.80722891566265 | 78 | 28 | 94 | 1 | 245 | 12 | 121 | 196 | MEI9971262.1 putative Ig domain-containing protein [Ignavibacteriota bacterium] | diamond | 450 | 77 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28710415 | 28710415 | PRJNA1118794_P_NODE_50387_length_250_cov_2.389831_g49637_i0 | PRJNA1118794 | 50387 | 250 | 2.389831 | 5.9745775 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 149 | 2.929999999999999e-41 | NR | NLT51695.1 | 2053306 | g49637 | i0 | 86.7 | 0.996 | 83 | 11 | 99.6 | 0 | 1 | 249 | 29 | 111 | NLT51695.1 rod shape-determining protein RodA [Ignavibacteria bacterium] | diamond | 249 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30415976 | 30415976 | PRJNA1118794_P_NODE_69353_length_243_cov_0.905882_g68603_i0 | PRJNA1118794 | 69353 | 243 | 0.905882 | 2.20129326 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 68.2 | 1.21e-11 | NR | MCB0743308.1 | 2026749 | g68603 | i0 | 55.9 | 3.74074074074074 | 68 | 21 | 84 | 2 | 1 | 204 | 160 | 218 | MCB0743308.1 bifunctional 5,10-methylenetetrahydrofolate dehydrogenase/5,10-methenyltetrahydrofolate cyclohydrolase [Ignavibacteriota bacterium] | diamond | 909 | 68.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31639217 | 31639217 | PRJNA1118794_P_NODE_31896_length_287_cov_1.439252_g31146_i0 | PRJNA1118794 | 31896 | 287 | 1.439252 | 4.13065324 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 60.8 | 6.52e-9 | NR | MCI0706888.1 | 2026749 | g31146 | i0 | 37.2 | 3.31358885017422 | 94 | 49 | 98.3 | 4 | 4 | 285 | 33 | 116 | MCI0706888.1 superoxide dismutase family protein [Ignavibacteriota bacterium] | diamond | 951 | 61.2 | 0.993464052287582 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31996347 | 31996347 | PRJNA1118794_P_NODE_54418_length_249_cov_0.875000_g53668_i0 | PRJNA1118794 | 54418 | 249 | 0.875 | 2.17875 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 63.2 | 2.68e-9 | NR | MCJ7554389.1 | 2651163 | g53668 | i0 | 39 | 2.80722891566265 | 77 | 45 | 92.8 | 1 | 249 | 19 | 958 | 1032 | MCJ7554389.1 NPCBM/NEW2 domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 699 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;