contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA946307" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2202203 | 2202203 | PRJNA946307_P_NODE_23742_length_263_cov_4.649533_g22868_i0 | PRJNA946307 | 23742 | 263 | 4.649533 | 12.22827179 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 339 | 1.65e-88 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g22868 | i0 | 91.968 | 2.50190114068441 | 249 | 7 | 95 | 4 | 1 | 249 | 3682367 | 3682602 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 658 | 339 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 6029179 | 6029179 | PRJNA946307_P_NODE_128165_length_171_cov_3.319672_g127291_i0 | PRJNA946307 | 128165 | 171 | 3.319672 | 5.67663912 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 135 | 1.3800000000000002e-27 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g127291 | i0 | 89.623 | 96.2397660818714 | 106 | 11 | 62 | 0 | 52 | 157 | 509914 | 510019 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 16457 | 135 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 7305200 | 7305200 | PRJNA946307_P_NODE_3406_length_794_cov_11.401342_g2852_i0 | PRJNA946307 | 3406 | 794 | 11.401342 | 90.52665548 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 889 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g2852 | i0 | 87.342 | 297.613350125945 | 790 | 83 | 98 | 16 | 14 | 794 | 3682595 | 3681814 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 236305 | 889 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 8578415 | 8578415 | PRJNA946307_P_NODE_10207_length_420_cov_128.854447_g9356_i0 | PRJNA946307 | 10207 | 420 | 128.854447 | 541.1886774 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 532 | 1.1799999999999996e-146 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g9356 | i0 | 90.394 | 143.471428571429 | 406 | 37 | 96 | 2 | 15 | 419 | 3680698 | 3680294 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 60258 | 532 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 9854903 | 9854903 | PRJNA946307_P_NODE_23508_length_265_cov_1.254630_g22634_i0 | PRJNA946307 | 23508 | 265 | 1.25463 | 3.3247695 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 207 | 4.88e-49 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g22634 | i0 | 82.258 | 946.052830188679 | 248 | 36 | 92 | 7 | 7 | 251 | 1477736 | 1477494 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 250704 | 207 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 9855677 | 9855677 | PRJNA946307_P_NODE_66248_length_199_cov_5.433333_g65374_i0 | PRJNA946307 | 66248 | 199 | 5.433333 | 10.81233267 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 158 | 3.56e-34 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g65374 | i0 | 97.826 | 61.1105527638191 | 92 | 1 | 46 | 1 | 11 | 102 | 511466 | 511376 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 12161 | 158 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 13681267 | 13681267 | PRJNA946307_P_NODE_60071_length_207_cov_1.797468_g59197_i0 | PRJNA946307 | 60071 | 207 | 1.797468 | 3.72075876 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 348 | 2.06e-91 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g59197 | i0 | 99.476 | 0.922705314009662 | 191 | 1 | 92 | 0 | 6 | 196 | 3681008 | 3681198 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 191 | 348 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 16230923 | 16230923 | PRJNA946307_P_NODE_85653_length_190_cov_3.907801_g84779_i0 | PRJNA946307 | 85653 | 190 | 3.907801 | 7.4248219 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 318 | 1.46e-82 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g84779 | i0 | 99.429 | 138.763157894737 | 175 | 1 | 92 | 0 | 1 | 175 | 1477685 | 1477511 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 26365 | 318 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 20054345 | 20054345 | PRJNA946307_P_NODE_6636_length_551_cov_20.392430_g5857_i0 | PRJNA946307 | 6636 | 551 | 20.39243 | 112.3622893 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 542 | 2.64e-149 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g5857 | i0 | 84.532 | 120.357531760436 | 556 | 77 | 100 | 6 | 1 | 551 | 3681049 | 3681600 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 66317 | 542 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 22604306 | 22604306 | PRJNA946307_P_NODE_4018_length_729_cov_53.227941_g3396_i0 | PRJNA946307 | 4018 | 729 | 53.227941 | 388.03168989 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 664 | 0 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g3396 | i0 | 84.046 | 292.912208504801 | 702 | 98 | 95 | 12 | 38 | 729 | 3680903 | 3681600 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 213533 | 664 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 22604695 | 22604695 | PRJNA946307_P_NODE_63098_length_201_cov_6.414474_g62224_i0 | PRJNA946307 | 63098 | 201 | 6.414474 | 12.89309274 | Candidatus Melainabacteria bacterium MEL.A1 | 1899017 | Bacteria | Bacteria | 335 | 1.5499999999999995e-87 | NTclustered | gi|1079475020|gb|CP017245.1| | 1899017 | g62224 | i0 | 98.93 | 119.388059701493 | 187 | 2 | 93 | 0 | 1 | 187 | 1479879 | 1479693 | Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome | blastn | 23997 | 335 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium MEL.A1 | |||||
| 23879954 | 23879954 | PRJNA946307_P_NODE_4819_length_661_cov_25.433007_g4143_i0 | PRJNA946307 | 4819 | 661 | 25.433007 | 168.11217627 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 604 | 4.0299999999999988e-168 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g4143 | i0 | 83.333 | 312.402420574887 | 672 | 94 | 100 | 14 | 1 | 661 | 3681600 | 3680936 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 206498 | 604 | 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);;