contig_metadata
9 rows where bioproject = "PRJNA437204", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1706662 | 1706662 | PRJNA437204_P_NODE_115402_length_243_cov_1.811765_g115103_i0 | PRJNA437204 | 115402 | 243 | 1.811765 | 4.40258895 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 278 | 3.3200000000000004e-70 | NTclustered | gi|1958007833|gb|CP064963.1| | 2052166 | g115103 | i0 | 87.552 | 51.3991769547325 | 241 | 29 | 99 | 1 | 3 | 243 | 3679728 | 3679967 | MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome | blastn | 12490 | 278 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 2983934 | 2983934 | PRJNA437204_P_NODE_75163_length_257_cov_1.625000_g74864_i0 | PRJNA437204 | 75163 | 257 | 1.625 | 4.17625 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 270 | 5.93e-68 | NTclustered | gi|2189472572|gb|CP091731.1| | 2052166 | g74864 | i0 | 85.769 | 349.859922178988 | 260 | 32 | 100 | 5 | 1 | 257 | 598546 | 598803 | MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome | blastn | 89914 | 270 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 5535801 | 5535801 | PRJNA437204_P_NODE_14745_length_462_cov_2.195373_g14446_i0 | PRJNA437204 | 14745 | 462 | 2.195373 | 10.14262326 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 286 | 5.660000000000001e-97 | NR | MBX9724270.1 | 2364082 | g14446 | i0 | 90.8 | 0.993506493506494 | 153 | 14 | 99.4 | 0 | 3 | 461 | 8 | 160 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 459 | 286 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 12568113 | 12568113 | PRJNA437204_P_NODE_10250_length_532_cov_1.803922_g9952_i0 | PRJNA437204 | 10250 | 532 | 1.803922 | 9.59686504 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 226 | 8.54e-73 | NR | MBX9724270.1 | 2364082 | g9952 | i0 | 87.3 | 0.710526315789474 | 126 | 16 | 71.1 | 0 | 1 | 378 | 45 | 170 | MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] | diamond | 378 | 226 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 20834232 | 20834232 | PRJNA437204_P_NODE_39977_length_324_cov_1.840637_g39678_i0 | PRJNA437204 | 39977 | 324 | 1.840637 | 5.96366388 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 433 | 9.299999999999999e-117 | NTclustered | gi|2729058672|emb|OZ006972.1| | 2137880 | g39678 | i0 | 92.182 | 27.4351851851852 | 307 | 22 | 94 | 2 | 12 | 317 | 511295 | 510990 | MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1 | blastn | 8889 | 433 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 22108999 | 22108999 | PRJNA437204_P_NODE_3138_length_844_cov_1.906615_g2886_i0 | PRJNA437204 | 3138 | 844 | 1.906615 | 16.0918306 | Candidatus Gastranaerophilales bacterium | 2137880 | Bacteria | Bacteria | 1009 | 0 | NTclustered | gi|2729058729|emb|OZ007029.1| | 2137880 | g2886 | i0 | 88.457 | 198.537914691943 | 849 | 80 | 99 | 17 | 1 | 841 | 1222677 | 1223515 | MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1 | blastn | 167566 | 1009 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 28749671 | 28749671 | PRJNA437204_P_NODE_79867_length_251_cov_0.865169_g79568_i0 | PRJNA437204 | 79867 | 251 | 0.865169 | 2.17157419 | Candidatus Obscuribacter sp. | 2711154 | Bacteria | Bacteria | 176 | 1.48e-50 | NR | HNH76025.1 | 2711154 | g79568 | i0 | 94 | 6.94422310756972 | 83 | 5 | 99.2 | 0 | 251 | 3 | 322 | 404 | HNH76025.1 phosphoenolpyruvate carboxykinase (GTP) [Candidatus Obscuribacter sp.] | diamond | 1743 | 176 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacteraceae | Candidatus Obscuribacter | Candidatus Obscuribacter sp. | ||
| 30612876 | 30612876 | PRJNA437204_P_NODE_69973_length_265_cov_1.343750_g69674_i0 | PRJNA437204 | 69973 | 265 | 1.34375 | 3.5609375 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 116 | 4.27e-28 | NR | MBX9687050.1 | 2364082 | g69674 | i0 | 64.2 | 1.82264150943396 | 81 | 29 | 91.7 | 0 | 22 | 264 | 128 | 208 | MBX9687050.1 membrane protein insertase YidC [Candidatus Obscuribacterales bacterium] | diamond | 483 | 116 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31893906 | 31893906 | PRJNA437204_P_NODE_106837_length_245_cov_0.895349_g106538_i0 | PRJNA437204 | 106837 | 245 | 0.895349 | 2.19360505 | Candidatus Obscuribacter | 1906156 | Bacteria | Bacteria | 162 | 2.38e-45 | NR | MBX3137679.1 | 2364082 | g106538 | i0 | 100 | 1.98367346938776 | 81 | 0 | 99.2 | 0 | 245 | 3 | 301 | 381 | MBX3137679.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 486 | 162 | 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);;