contig_metadata
3 rows where bioproject = "PRJNA1020854" and tax_phylum = "Candidatus Melainabacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3987930 | 3987930 | PRJNA1020854_S_NODE_7344_length_562_cov_1058.953096_g4734_i0 | PRJNA1020854 | 7344 | 562 | 1058.953096 | 5951.31639952 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 255 | 3.75e-83 | NR | MDR3612433.1 | 2364082 | g4734 | i0 | 76.5 | 1.72419928825623 | 162 | 37 | 85.9 | 1 | 489 | 7 | 18 | 179 | MDR3612433.1 response regulator transcription factor [Candidatus Obscuribacterales bacterium] | diamond | 969 | 255 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30382865 | 30382865 | PRJNA1020854_S_NODE_42593_length_152_cov_2.008130_g39829_i0 | PRJNA1020854 | 42593 | 152 | 2.00813 | 3.0523576 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 48.1 | 1.15e-4 | NR | MFN8659968.1 | 2364082 | g39829 | i0 | 59 | 0.769736842105263 | 39 | 16 | 77 | 0 | 146 | 30 | 202 | 240 | MFN8659968.1 class I SAM-dependent methyltransferase [Candidatus Obscuribacterales bacterium] | diamond | 117 | 48.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31646563 | 31646563 | PRJNA1020854_S_NODE_39457_length_159_cov_2.153846_g36693_i0 | PRJNA1020854 | 39457 | 159 | 2.153846 | 3.42461514 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 74.7 | 4.1e-14 | NR | OGI18471.1 | 1801607 | g36693 | i0 | 78.3 | 0.867924528301887 | 46 | 10 | 86.8 | 0 | 1 | 138 | 241 | 286 | OGI18471.1 MAG: hypothetical protein A3B68_06925 [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 138 | 74.7 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_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);;