contig_metadata
11 rows where bioproject = "PRJNA1112809", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9149091 | 9149091 | PRJNA1112809_P_NODE_75088_length_400_cov_1.648318_g71813_i0 | PRJNA1112809 | 75088 | 400 | 1.648318 | 6.593272 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 641 | 1.7899999999999994e-179 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g71813 | i0 | 96.632 | 377.785 | 386 | 13 | 97 | 0 | 1 | 386 | 429697 | 430082 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 151114 | 641 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 12972866 | 12972866 | PRJNA1112809_P_NODE_124631_length_291_cov_0.853211_g121356_i0 | PRJNA1112809 | 124631 | 291 | 0.853211 | 2.48284401 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 195 | 4.23e-45 | NTclustered | gi|2621786307|emb|OY782765.1| | 2614255 | g121356 | i0 | 79.538 | 109.113402061856 | 303 | 38 | 100 | 17 | 1 | 291 | 2844064 | 2844354 | MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1 | blastn | 31752 | 195 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 18071493 | 18071493 | PRJNA1112809_P_NODE_171295_length_248_cov_3.165714_g168020_i0 | PRJNA1112809 | 171295 | 248 | 3.165714 | 7.85097072 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 398 | 2.5e-106 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g168020 | i0 | 95.565 | 2.01612903225806 | 248 | 11 | 100 | 0 | 1 | 248 | 430530 | 430283 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 500 | 398 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 21425341 | 21425341 | PRJNA1112809_P_NODE_166897_length_250_cov_0.870056_g163622_i0 | PRJNA1112809 | 166897 | 250 | 0.870056 | 2.17514 | Melioribacter | 1134403 | Bacteria | Bacteria | 331 | 2.6e-86 | NTclustered | gi|470490269|ref|NR_076978.1| | 1134405 | g163622 | i0 | 91.701 | 170.884 | 241 | 16 | 96 | 4 | 8 | 246 | 1301 | 1539 | Melioribacter roseus strain P3M-2 23S ribosomal RNA gene, complete sequence | blastn | 42721 | 331 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacter | Melioribacter roseus | |
| 26900969 | 26900969 | PRJNA1112809_P_NODE_127661_length_287_cov_1.546729_g124386_i0 | PRJNA1112809 | 127661 | 287 | 1.546729 | 4.43911223 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 100 | 5.57e-24 | NR | MBI5471696.1 | 2026749 | g124386 | i0 | 49.5 | 4.93379790940767 | 95 | 48 | 99.3 | 0 | 2 | 286 | 89 | 183 | MBI5471696.1 YfiR family protein [Ignavibacteriota bacterium] | diamond | 1416 | 100 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27194247 | 27194247 | PRJNA1112809_P_NODE_64742_length_445_cov_1.755376_g61468_i0 | PRJNA1112809 | 64742 | 445 | 1.755376 | 7.8114232 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 72.8 | 4.33e-12 | NR | MEI9976353.1 | 2026749 | g61468 | i0 | 53.1 | 0.431460674157303 | 64 | 30 | 43.1 | 0 | 252 | 443 | 3 | 66 | MEI9976353.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 192 | 72.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28078530 | 28078530 | PRJNA1112809_P_NODE_185805_length_243_cov_2.029412_g182530_i0 | PRJNA1112809 | 185805 | 243 | 2.029412 | 4.93147116 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 43.1 | 0.0207 | NR | MBI5326219.1 | 2026749 | g182530 | i0 | 36.5 | 0.641975308641975 | 52 | 33 | 64.2 | 0 | 1 | 156 | 83 | 134 | MBI5326219.1 RNA polymerase sigma factor [Ignavibacteriota bacterium] | diamond | 156 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28954064 | 28954064 | PRJNA1112809_P_NODE_150528_length_263_cov_1.400000_g147253_i0 | PRJNA1112809 | 150528 | 263 | 1.4 | 3.682 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 169 | 1.19e-46 | NR | OGU65756.1 | 1798428 | g147253 | i0 | 96.6 | 4.96197718631179 | 87 | 3 | 99.2 | 0 | 263 | 3 | 35 | 121 | OGU65756.1 MAG: cation transporter [Stygiobacter sp. GWC2_38_9] | diamond | 1305 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Stygiobacter | Stygiobacter sp. GWC2_38_9 | |
| 28994535 | 28994535 | PRJNA1112809_P_NODE_178908_length_246_cov_0.890173_g175633_i0 | PRJNA1112809 | 178908 | 246 | 0.890173 | 2.18982558 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 124 | 6.07e-32 | NR | MBK7500059.1 | 2049428 | g175633 | i0 | 78.1 | 2.67073170731707 | 73 | 16 | 89 | 0 | 4 | 222 | 175 | 247 | MBK7500059.1 hypothetical protein [Ignavibacteriales bacterium] | diamond | 657 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 31141725 | 31141725 | PRJNA1112809_P_NODE_129415_length_285_cov_1.452830_g126140_i0 | PRJNA1112809 | 129415 | 285 | 1.45283 | 4.1405655 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 149 | 1.64e-39 | NR | MEI9973508.1 | 2026749 | g126140 | i0 | 86.2 | 0.989473684210526 | 94 | 13 | 98.9 | 0 | 284 | 3 | 336 | 429 | MEI9973508.1 CusA/CzcA family heavy metal efflux RND transporter [Ignavibacteriota bacterium] | diamond | 282 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 31639181 | 31639181 | PRJNA1112809_P_NODE_156216_length_258_cov_1.054054_g152941_i0 | PRJNA1112809 | 156216 | 258 | 1.054054 | 2.71945932 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 46.6 | 6.65e-4 | NR | MEI9974407.1 | 2026749 | g152941 | i0 | 66.7 | 1.98837209302326 | 42 | 11 | 45.3 | 2 | 163 | 47 | 69 | 110 | MEI9974407.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 513 | 46.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota 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);;