contig_metadata
9 rows where bioproject = "PRJNA940501", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14949216 | 14949216 | PRJNA940501_S_NODE_395952_length_150_cov_1.757009_g395134_i0 | PRJNA940501 | 395952 | 150 | 1.757009 | 2.6355135 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 52.8 | 0.012 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g395134 | i0 | 100 | 0.186666666666667 | 28 | 0 | 19 | 0 | 41 | 68 | 354451 | 354478 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 15286350 | 15286350 | PRJNA940501_S_NODE_6172_length_599_cov_76.462230_g5498_i0 | PRJNA940501 | 6172 | 599 | 76.46223 | 458.0087577 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 317 | 4.66e-108 | NR | MBX9724270.1 | 2364082 | g5498 | i0 | 91.6 | 0.836393989983305 | 167 | 14 | 83.6 | 0 | 1 | 501 | 4 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 501 | 317 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 20048496 | 20048496 | PRJNA940501_S_NODE_68636_length_263_cov_1.495455_g67818_i0 | PRJNA940501 | 68636 | 263 | 1.495455 | 3.93304665 | Bacillati | 1783272 | Bacteria | Bacteria | 134 | 6.04e-38 | NR | MBX2861300.1 | 2717857 | g67818 | i0 | 70.9 | 8.85171102661597 | 86 | 25 | 98.1 | 0 | 260 | 3 | 26 | 111 | MBX2861300.1 nucleoside-diphosphate kinase [Vampirovibrio sp.] | diamond | 2328 | 134 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrio | Vampirovibrio sp. | ||
| 27373160 | 27373160 | PRJNA940501_S_NODE_116123_length_228_cov_1.664865_g115305_i0 | PRJNA940501 | 116123 | 228 | 1.664865 | 3.7958922 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 40.4 | 0.0346 | NR | MBR5305092.1 | 2137880 | g115305 | i0 | 42.9 | 0.552631578947368 | 42 | 18 | 47.4 | 2 | 17 | 124 | 26 | 67 | MBR5305092.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] | diamond | 126 | 40.4 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 28541310 | 28541310 | PRJNA940501_S_NODE_14307_length_406_cov_2.801653_g13494_i0 | PRJNA940501 | 14307 | 406 | 2.801653 | 11.37471118 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 49.3 | 9.93e-4 | NR | MBI2810854.1 | 2052166 | g13494 | i0 | 65.7 | 0.258620689655172 | 35 | 12 | 25.9 | 0 | 398 | 294 | 319 | 353 | MBI2810854.1 molecular chaperone DnaJ [Candidatus Melainabacteria bacterium] | diamond | 105 | 49.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30562041 | 30562041 | PRJNA940501_S_NODE_230733_length_184_cov_1.000000_g229915_i0 | PRJNA940501 | 230733 | 184 | 1 | 1.84 | Candidatus Gastranaerophilaceae bacterium | 3022870 | Bacteria | Bacteria | 54.3 | 1.27e-6 | NR | MEE3348692.1 | 3022870 | g229915 | i0 | 38.3 | 0.978260869565217 | 60 | 37 | 97.8 | 0 | 182 | 3 | 137 | 196 | MEE3348692.1 hypothetical protein [Candidatus Gastranaerophilaceae bacterium] | diamond | 180 | 54.3 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilaceae | Candidatus Gastranaerophilaceae bacterium | |||
| 31573983 | 31573983 | PRJNA940501_S_NODE_397516_length_150_cov_1.317757_g396698_i0 | PRJNA940501 | 397516 | 150 | 1.317757 | 1.9766355 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 67.8 | 2.2e-12 | NR | MBP7579192.1 | 2711154 | g396698 | i0 | 61.2 | 2.94 | 49 | 19 | 98 | 0 | 149 | 3 | 65 | 113 | MBP7579192.1 hypothetical protein [Candidatus Obscuribacter sp.] | diamond | 441 | 67.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 31700329 | 31700329 | PRJNA940501_S_NODE_247537_length_179_cov_2.036765_g246719_i0 | PRJNA940501 | 247537 | 179 | 2.036765 | 3.64580935 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 95.5 | 4.1200000000000005e-21 | NR | MBQ8887389.1 | 2137880 | g246719 | i0 | 79.7 | 0.988826815642458 | 59 | 12 | 98.9 | 0 | 2 | 178 | 339 | 397 | MBQ8887389.1 hypothetical protein [Candidatus Gastranaerophilales bacterium] | diamond | 177 | 95.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 32586321 | 32586321 | PRJNA940501_S_NODE_6879_length_564_cov_6.593090_g6169_i0 | PRJNA940501 | 6879 | 564 | 6.59309 | 37.1850276 | Vampirovibrionales bacterium | 2692181 | Bacteria | Bacteria | 83.2 | 2.8e-15 | NR | MFM7389114.1 | 2692181 | g6169 | i0 | 71.9 | 0.303191489361702 | 57 | 16 | 30.3 | 0 | 530 | 360 | 254 | 310 | MFM7389114.1 ATP synthase F1 subunit gamma [Vampirovibrionales bacterium] | diamond | 171 | 83.2 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrionales 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);;