contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3298151 | 3298151 | PRJNA770826_P_NODE_4903_length_385_cov_2.741071_g4732_i0 | PRJNA770826 | 4903 | 385 | 2.741071 | 10.55312335 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 628 | 1.33e-175 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g4732 | i0 | 96.335 | 93.425974025974 | 382 | 14 | 99 | 0 | 4 | 385 | 4232657 | 4233038 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 35969 | 628 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 8400050 | 8400050 | PRJNA770826_P_NODE_14667_length_211_cov_0.962963_g14496_i0 | PRJNA770826 | 14667 | 211 | 0.962963 | 2.03185193 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 307 | 3.5800000000000004e-79 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g14496 | i0 | 92.925 | 141.132701421801 | 212 | 14 | 100 | 1 | 1 | 211 | 4233748 | 4233959 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 29779 | 307 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 12226586 | 12226586 | PRJNA770826_P_NODE_21770_length_173_cov_1.258065_g21599_i0 | PRJNA770826 | 21770 | 173 | 1.258065 | 2.17645245 | Edaphobacter sp. 4G125 | 2763071 | Bacteria | Bacteria | 71.3 | 4.01e-8 | NTclustered | gi|1895667655|gb|CP060393.1| | 2763071 | g21599 | i0 | 88.333 | 0.346820809248555 | 60 | 6 | 35 | 1 | 96 | 155 | 3147482 | 3147540 | Edaphobacter sp. 4G125 chromosome, complete genome | blastn | 60 | 71.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. 4G125 | ||
| 13500667 | 13500667 | PRJNA770826_P_NODE_3491_length_463_cov_1.188406_g3320_i0 | PRJNA770826 | 3491 | 463 | 1.188406 | 5.50231978 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 392 | 2.33e-104 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g3320 | i0 | 86.517 | 73.9330453563715 | 356 | 48 | 77 | 0 | 108 | 463 | 4648996 | 4648641 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 34231 | 392 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 18598735 | 18598735 | PRJNA770826_P_NODE_7735_length_294_cov_1.273469_g7564_i0 | PRJNA770826 | 7735 | 294 | 1.273469 | 3.74399886 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 344 | 4.02e-90 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g7564 | i0 | 87.879 | 974.268707482993 | 297 | 31 | 100 | 5 | 1 | 294 | 4233950 | 4233656 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 286435 | 344 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 21149513 | 21149513 | PRJNA770826_P_NODE_34177_length_165_cov_0.896552_g34006_i0 | PRJNA770826 | 34177 | 165 | 0.896552 | 1.4793108 | Paludibaculum fermentans | 1473598 | Bacteria | Bacteria | 126 | 8.02e-25 | NTclustered | gi|1929489624|gb|CP063849.1| | 1473598 | g34006 | i0 | 81.699 | 47.1030303030303 | 153 | 26 | 92 | 2 | 4 | 155 | 2258353 | 2258504 | Paludibaculum fermentans strain P105 chromosome, complete genome | blastn | 7772 | 126 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Paludibaculum | Paludibaculum fermentans | ||
| 24973465 | 24973465 | PRJNA770826_P_NODE_16200_length_201_cov_1.223684_g16029_i0 | PRJNA770826 | 16200 | 201 | 1.223684 | 2.45960484 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 174 | 3.58e-39 | NTclustered | gi|2893358450|emb|OZ220742.1| | 2651171 | g16029 | i0 | 83.784 | 10.8905472636816 | 185 | 28 | 92 | 2 | 10 | 193 | 3404922 | 3404739 | MAG: Thermoanaerobaculia bacterium isolate 0db66e92-d31a-4200-8262-fff8455c21c0 genome assembly, chromosome: 1 | blastn | 2189 | 174 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia 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);;