contig_metadata
3 rows where bioproject = "PRJNA605033" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3133821 | 3133821 | PRJNA605033_P_NODE_58803_length_228_cov_2.000000_g57235_i0 | PRJNA605033 | 58803 | 228 | 2 | 4.56 | uncultured delta proteobacterium | 34034 | Bacteria | Bacteria | 63.9 | 9.39e-6 | NTclustered | gi|2874253999|emb|OY970324.1| | 34034 | g57235 | i0 | 97.297 | 0.640350877192982 | 37 | 1 | 16 | 0 | 14 | 50 | 245139 | 245175 | MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1 | blastn | 146 | 63.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | uncultured delta proteobacterium | ||||||
| 29038221 | 29038221 | PRJNA605033_P_NODE_188308_length_171_cov_1.397059_g186739_i0 | PRJNA605033 | 188308 | 171 | 1.397059 | 2.38897089 | Candidatus Zymogenaceae bacterium | 2844909 | Bacteria | Bacteria | 55.8 | 3.27e-7 | NR | MBN1880703.1 | 2844909 | g186739 | i0 | 45.3 | 3.64912280701754 | 53 | 29 | 93 | 0 | 12 | 170 | 33 | 85 | MBN1880703.1 PAS domain S-box protein [Candidatus Zymogenaceae bacterium] | diamond | 624 | 55.8 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Candidatus Zymogeniales | Candidatus Zymogenaceae | Candidatus Zymogenaceae bacterium | ||||
| 32861107 | 32861107 | PRJNA605033_P_NODE_11980_length_403_cov_1.975543_g10448_i0 | PRJNA605033 | 11980 | 403 | 1.975543 | 7.96143829 | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ | 2026735 | Bacteria | Bacteria | 79.7 | 2.55e-14 | NR | PIR20469.1 | 1973975 | g10448 | i0 | 51.9 | 0.602977667493797 | 81 | 36 | 60.3 | 2 | 150 | 392 | 69 | 146 | PIR20469.1 MAG: hypothetical protein COV45_06045 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16] | diamond | 243 | 79.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_47_16 |
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);;