contig_metadata
7 rows where bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2122684 | 2122684 | PRJNA864829_S_NODE_9622_length_202_cov_3.267974_g9536_i0 | PRJNA864829 | 9622 | 202 | 3.267974 | 6.60130748 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 254 | 4.4900000000000003e-63 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g9536 | i0 | 95.031 | 168.242574257426 | 161 | 8 | 80 | 0 | 24 | 184 | 3679884 | 3680044 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 33985 | 254 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 13600964 | 13600964 | PRJNA864829_S_NODE_3011_length_316_cov_5.898876_g2925_i0 | PRJNA864829 | 3011 | 316 | 5.898876 | 18.64044816 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 518 | 2.4299999999999998e-142 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g2925 | i0 | 96.203 | 285.623417721519 | 316 | 12 | 100 | 0 | 1 | 316 | 3682184 | 3682499 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 90257 | 518 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23799547 | 23799547 | PRJNA864829_S_NODE_5559_length_253_cov_3.078431_g5473_i0 | PRJNA864829 | 5559 | 253 | 3.078431 | 7.78843043 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 353 | 5.62e-93 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g5473 | i0 | 94.348 | 105.256916996047 | 230 | 13 | 91 | 0 | 1 | 230 | 3682456 | 3682685 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 26630 | 353 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 27781792 | 27781792 | PRJNA864829_S_NODE_2704_length_328_cov_2.225806_g2618_i0 | PRJNA864829 | 2704 | 328 | 2.225806 | 7.30064368 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 233 | 6.130000000000001e-73 | NR | MFN8658798.1 | 2364082 | g2618 | i0 | 99.1 | 0.996951219512195 | 109 | 1 | 99.7 | 0 | 327 | 1 | 331 | 439 | MFN8658798.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 327 | 233 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29423291 | 29423291 | PRJNA864829_S_NODE_12109_length_184_cov_1.185185_g12023_i0 | PRJNA864829 | 12109 | 184 | 1.185185 | 2.1807404 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 120 | 4.43e-30 | NR | MBX9666291.1 | 2364082 | g12023 | i0 | 91.7 | 0.978260869565217 | 60 | 5 | 97.8 | 0 | 183 | 4 | 30 | 89 | MBX9666291.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 180 | 120 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30655336 | 30655336 | PRJNA864829_S_NODE_14693_length_169_cov_1.341667_g14607_i0 | PRJNA864829 | 14693 | 169 | 1.341667 | 2.26741723 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 105 | 3.79e-25 | NR | MBX9671452.1 | 2364082 | g14607 | i0 | 89.1 | 0.976331360946746 | 55 | 6 | 97.6 | 0 | 3 | 167 | 31 | 85 | MBX9671452.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 165 | 105 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32742020 | 32742020 | PRJNA864829_S_NODE_4820_length_268_cov_2.091324_g4734_i0 | PRJNA864829 | 4820 | 268 | 2.091324 | 5.60474832 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 100 | 7.44e-23 | NR | MBX9667389.1 | 2364082 | g4734 | i0 | 100 | 0.548507462686567 | 49 | 0 | 54.9 | 0 | 267 | 121 | 356 | 404 | MBX9667389.1 ATP-grasp domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 147 | 100 | 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);;