contig_metadata
14 rows where 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 | |||||
| 15612216 | 15612216 | PRJNA1160211_S_NODE_165813_length_353_cov_2.053571_g164580_i0 | PRJNA1160211 | 165813 | 353 | 2.053571 | 7.24910563 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 198 | 1.44e-62 | NR | MBX9724270.1 | 2364082 | g164580 | i0 | 94 | 0.84985835694051 | 100 | 6 | 85 | 0 | 352 | 53 | 71 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 300 | 198 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 16887686 | 16887686 | PRJNA1160211_S_NODE_5414_length_931_cov_12.980186_g4826_i0 | PRJNA1160211 | 5414 | 931 | 12.980186 | 120.84553166 | Bacillati | 1783272 | Bacteria | Bacteria | 131 | 2.1399999999999997e-31 | NR | MFA6212919.1 | 2364082 | g4826 | i0 | 75.9 | 0.763694951664876 | 79 | 19 | 25.5 | 0 | 931 | 695 | 290 | 368 | MFA6212919.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 711 | 131 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales 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 | |||||
| 28114166 | 28114166 | PRJNA1160211_S_NODE_66285_length_531_cov_2.820961_g65086_i0 | PRJNA1160211 | 66285 | 531 | 2.820961 | 14.97930291 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 206 | 3.34e-65 | NR | MBX9722668.1 | 2364082 | g65086 | i0 | 71.5 | 1.5819209039548 | 137 | 39 | 77.4 | 0 | 97 | 507 | 1 | 137 | MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 840 | 206 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30482822 | 30482822 | PRJNA1160211_S_NODE_60033_length_547_cov_10.267932_g58849_i0 | PRJNA1160211 | 60033 | 547 | 10.267932 | 56.16558804 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 358 | 3.66e-117 | NR | MBX3152849.1 | 2364082 | g58849 | i0 | 100 | 0.992687385740402 | 181 | 0 | 99.3 | 0 | 3 | 545 | 74 | 254 | MBX3152849.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 543 | 358 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30628214 | 30628214 | PRJNA1160211_S_NODE_198793_length_312_cov_2.577406_g197560_i0 | PRJNA1160211 | 198793 | 312 | 2.577406 | 8.04150672 | Bacillati | 1783272 | Bacteria | Bacteria | 143 | 4.939999999999999e-37 | NR | MBX9671475.1 | 2364082 | g197560 | i0 | 64.1 | 1.98076923076923 | 103 | 36 | 98.1 | 1 | 306 | 1 | 195 | 297 | MBX9671475.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 618 | 144 | 0.993055555555556 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31208988 | 31208988 | PRJNA1160211_S_NODE_105995_length_446_cov_2.538874_g104767_i0 | PRJNA1160211 | 105995 | 446 | 2.538874 | 11.32337804 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 255 | 8.069999999999998e-82 | NR | MBX3134648.1 | 2364082 | g104767 | i0 | 100 | 0.881165919282511 | 131 | 0 | 88.1 | 0 | 394 | 2 | 1 | 131 | MBX3134648.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 393 | 255 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31683731 | 31683731 | PRJNA1160211_S_NODE_80657_length_497_cov_3.320755_g79440_i0 | PRJNA1160211 | 80657 | 497 | 3.320755 | 16.50415235 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 49.7 | 5.61e-5 | NR | MDZ4832597.1 | 2052166 | g79440 | i0 | 57.1 | 0.253521126760563 | 42 | 18 | 25.4 | 0 | 372 | 497 | 1 | 42 | MDZ4832597.1 hypothetical protein [Candidatus Melainabacteria bacterium] | diamond | 126 | 49.7 | 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);;