contig_metadata
4 rows where bioproject = "PRJNA771359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8400297 | 8400297 | PRJNA771359_S_NODE_567_length_415_cov_4.349206_g484_i0 | PRJNA771359 | 567 | 415 | 4.349206 | 18.0492049 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 436 | 9.43e-118 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g484 | i0 | 86.486 | 119.833734939759 | 407 | 44 | 96 | 10 | 19 | 415 | 3681170 | 3681575 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 49731 | 436 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 19873791 | 19873791 | PRJNA771359_S_NODE_1736_length_254_cov_6.640553_g1653_i0 | PRJNA771359 | 1736 | 254 | 6.640553 | 16.86700462 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 268 | 2.0999999999999998e-67 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g1653 | i0 | 85.992 | 163.799212598425 | 257 | 28 | 100 | 8 | 1 | 254 | 1478341 | 1478090 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 41605 | 268 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 23700000 | 23700000 | PRJNA771359_S_NODE_2539_length_210_cov_2.317919_g2456_i0 | PRJNA771359 | 2539 | 210 | 2.317919 | 4.8676299 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 187 | 4.8399999999999984e-43 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g2456 | i0 | 83.178 | 673.861904761905 | 214 | 26 | 100 | 9 | 1 | 210 | 597459 | 597666 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 141511 | 187 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23700039 | 23700039 | PRJNA771359_S_NODE_959_length_332_cov_38.172881_g876_i0 | PRJNA771359 | 959 | 332 | 38.172881 | 126.73396492 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 497 | 3.34e-136 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g876 | i0 | 93.675 | 149.701807228916 | 332 | 21 | 100 | 0 | 1 | 332 | 3680372 | 3680703 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 49701 | 497 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria 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);;