contig_metadata
4 rows where bioproject = "PRJNA1164198", tax_clade = "Cyanobacteriota/Melainabacteria group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7965192 | 7965192 | PRJNA1164198_P_NODE_18847_length_285_cov_2.547170_g18578_i0 | PRJNA1164198 | 18847 | 285 | 2.54717 | 7.2594345 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 433 | 8.05e-117 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g18578 | i0 | 94.035 | 229.961403508772 | 285 | 17 | 100 | 0 | 1 | 285 | 1477630 | 1477914 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 65539 | 433 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 13065515 | 13065515 | PRJNA1164198_P_NODE_11031_length_374_cov_2.199336_g10763_i0 | PRJNA1164198 | 11031 | 374 | 2.199336 | 8.22551664 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 652 | 0 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g10763 | i0 | 98.128 | 101.393048128342 | 374 | 7 | 100 | 0 | 1 | 374 | 514205 | 513832 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 37921 | 652 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 13792809 | 13792809 | PRJNA1164198_P_NODE_20811_length_272_cov_1.482412_g20542_i0 | PRJNA1164198 | 20811 | 272 | 1.482412 | 4.03216064 | Bacteria | 2 | Bacteria | Bacteria | 470 | 5.81e-128 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g20542 | i0 | 98.141 | 574.643382352941 | 269 | 5 | 99 | 0 | 1 | 269 | 1479307 | 1479575 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 156303 | 470 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 23264195 | 23264195 | PRJNA1164198_P_NODE_21539_length_268_cov_1.200000_g21270_i0 | PRJNA1164198 | 21539 | 268 | 1.2 | 3.216 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 254 | 6.27e-63 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g21270 | i0 | 84.211 | 327.328358208955 | 266 | 36 | 98 | 5 | 1 | 263 | 1477003 | 1477265 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 87724 | 254 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 |
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);;