contig_metadata
6 rows where bioproject = "PRJNA724039", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1194196 | 1194196 | PRJNA724039_S_NODE_881_length_964_cov_6.482201_g754_i0 | PRJNA724039 | 881 | 964 | 6.482201 | 62.48841764 | Bacteria | 2 | Bacteria | Bacteria | 549 | 2.8399999999999987e-151 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g754 | i0 | 78.363 | 114.653526970954 | 892 | 161 | 91 | 30 | 1 | 875 | 1478010 | 1477134 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 110526 | 549 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 4539621 | 4539621 | PRJNA724039_S_NODE_6344_length_270_cov_4.982833_g6137_i0 | PRJNA724039 | 6344 | 270 | 4.982833 | 13.4536491 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 259 | 1.36e-64 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g6137 | i0 | 84.387 | 165.518518518519 | 269 | 36 | 99 | 5 | 2 | 268 | 511544 | 511280 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 44690 | 259 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 14740355 | 14740355 | PRJNA724039_S_NODE_872_length_969_cov_19.296137_g746_i0 | PRJNA724039 | 872 | 969 | 19.296137 | 186.97956753 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 1016 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g746 | i0 | 85.744 | 283.33746130031 | 968 | 130 | 99 | 6 | 4 | 969 | 3680783 | 3681744 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 274554 | 1016 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 17289205 | 17289205 | PRJNA724039_S_NODE_3414_length_393_cov_5.665730_g3207_i0 | PRJNA724039 | 3414 | 393 | 5.66573 | 22.2663189 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 289 | 2.63e-73 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g3207 | i0 | 80.8 | 43.8676844783715 | 375 | 67 | 94 | 5 | 4 | 374 | 3680783 | 3681156 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 17240 | 289 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 21113597 | 21113597 | PRJNA724039_S_NODE_10017_length_205_cov_6.375000_g9810_i0 | PRJNA724039 | 10017 | 205 | 6.375 | 13.06875 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 62.1 | 2.97e-5 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g9810 | i0 | 100 | 0.160975609756098 | 33 | 0 | 16 | 0 | 1 | 33 | 1887804 | 1887772 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 33 | 62.1 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 28347094 | 28347094 | PRJNA724039_S_NODE_7046_length_254_cov_2.096774_g6839_i0 | PRJNA724039 | 7046 | 254 | 2.096774 | 5.32580596 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 129 | 3.61e-37 | NR | MFA6208533.1 | 2364082 | g6839 | i0 | 95.7 | 0.826771653543307 | 70 | 3 | 82.7 | 0 | 43 | 252 | 1 | 70 | MFA6208533.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 210 | 129 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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);;