contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA1160211" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10514058 | 10514058 | PRJNA1160211_S_NODE_299489_length_205_cov_4.083333_g298256_i0 | PRJNA1160211 | 299489 | 205 | 4.083333 | 8.37083265 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 187 | 4.6999999999999985e-43 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g298256 | i0 | 87.273 | 440.234146341463 | 165 | 19 | 80 | 2 | 19 | 182 | 510580 | 510743 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 90248 | 187 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 12517133 | 12517133 | PRJNA1160211_S_NODE_191770_length_320_cov_4.056680_g190537_i0 | PRJNA1160211 | 191770 | 320 | 4.05668 | 12.981376 | Bacillati | 1783272 | Bacteria | Bacteria | 254 | 7.67e-63 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g190537 | i0 | 84.27 | 370.003125 | 267 | 35 | 82 | 6 | 22 | 283 | 511564 | 511828 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 118401 | 254 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 14338215 | 14338215 | PRJNA1160211_S_NODE_143872_length_383_cov_10.825806_g142639_i0 | PRJNA1160211 | 143872 | 383 | 10.825806 | 41.46283698 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 65.8 | 4.69e-6 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g142639 | i0 | 100 | 0.357702349869452 | 35 | 0 | 9 | 0 | 326 | 360 | 1908112 | 1908146 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 137 | 65.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 19436105 | 19436105 | PRJNA1160211_S_NODE_258976_length_254_cov_11.149171_g257743_i0 | PRJNA1160211 | 258976 | 254 | 11.149171 | 28.31889434 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 183 | 7.84e-42 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g257743 | i0 | 82.273 | 72.7125984251968 | 220 | 31 | 85 | 8 | 25 | 240 | 3682424 | 3682209 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 18469 | 183 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 20711828 | 20711828 | PRJNA1160211_S_NODE_37417_length_619_cov_58.100733_g36287_i0 | PRJNA1160211 | 37417 | 619 | 58.100733 | 359.64353727 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 560 | 8.25e-155 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g36287 | i0 | 83.175 | 145.292407108239 | 630 | 88 | 100 | 14 | 1 | 619 | 3680997 | 3681619 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 89936 | 560 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23261758 | 23261758 | PRJNA1160211_S_NODE_18359_length_721_cov_170.674383_g17391_i0 | PRJNA1160211 | 18359 | 721 | 170.674383 | 1230.56230143 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 776 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g17391 | i0 | 87.555 | 132.031900138696 | 683 | 70 | 94 | 14 | 27 | 701 | 3682681 | 3682006 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 95195 | 776 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 23262450 | 23262450 | PRJNA1160211_S_NODE_28059_length_661_cov_36.336735_g26975_i0 | PRJNA1160211 | 28059 | 661 | 36.336735 | 240.18581835 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 640 | 1.1e-178 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g26975 | i0 | 84.203 | 209.062027231467 | 671 | 92 | 100 | 12 | 1 | 661 | 3680953 | 3681619 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 138190 | 640 | 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);;