contig_metadata
7 rows where bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28935269 | 28935269 | PRJNA1159911_P_NODE_91068_length_248_cov_0.880000_g90526_i0 | PRJNA1159911 | 91068 | 248 | 0.88 | 2.1824 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 151 | 1.31e-40 | NR | HIA54823.1 | 2052166 | g90526 | i0 | 85.4 | 0.991935483870968 | 82 | 12 | 99.2 | 0 | 246 | 1 | 92 | 173 | HIA54823.1 type IV secretory system conjugative DNA transfer family protein [Candidatus Melainabacteria bacterium] | diamond | 246 | 151 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 29629451 | 29629451 | PRJNA1159911_P_NODE_95110_length_245_cov_0.895349_g94568_i0 | PRJNA1159911 | 95110 | 245 | 0.895349 | 2.19360505 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 114 | 8.79e-28 | NR | MBY0548834.1 | 2364082 | g94568 | i0 | 91.4 | 0.991836734693878 | 81 | 7 | 99.2 | 0 | 245 | 3 | 335 | 415 | MBY0548834.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium] | diamond | 243 | 114 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30008995 | 30008995 | PRJNA1159911_P_NODE_83851_length_256_cov_1.360656_g83309_i0 | PRJNA1159911 | 83851 | 256 | 1.360656 | 3.48327936 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 171 | 9.65e-50 | NR | PZM83381.1 | 2052166 | g83309 | i0 | 96.5 | 0.99609375 | 85 | 3 | 99.6 | 0 | 2 | 256 | 233 | 317 | PZM83381.1 MAG: glycosidase [Candidatus Melainabacteria bacterium] | diamond | 255 | 171 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30071865 | 30071865 | PRJNA1159911_P_NODE_72732_length_277_cov_2.161765_g72190_i0 | PRJNA1159911 | 72732 | 277 | 2.161765 | 5.98808905 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 153 | 8.37e-46 | NR | MBX9722668.1 | 2364082 | g72190 | i0 | 81.1 | 0.974729241877256 | 90 | 17 | 97.5 | 0 | 1 | 270 | 39 | 128 | MBX9722668.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 270 | 153 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30514316 | 30514316 | PRJNA1159911_P_NODE_89653_length_249_cov_0.875000_g89111_i0 | PRJNA1159911 | 89653 | 249 | 0.875 | 2.17875 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 155 | 7.1e-44 | NR | PZM84537.1 | 2052166 | g89111 | i0 | 100 | 1 | 83 | 0 | 100 | 0 | 249 | 1 | 117 | 199 | PZM84537.1 MAG: hypothetical protein DKT66_07850 [Candidatus Melainabacteria bacterium] | diamond | 249 | 155 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30881127 | 30881127 | PRJNA1159911_P_NODE_70734_length_282_cov_1.186603_g70192_i0 | PRJNA1159911 | 70734 | 282 | 1.186603 | 3.34622046 | Bacillati | 1783272 | Bacteria | Bacteria | 108 | 3.62e-27 | NR | MDR3615357.1 | 2364082 | g70192 | i0 | 56.7 | 5.82978723404255 | 90 | 39 | 95.7 | 0 | 13 | 282 | 30 | 119 | MDR3615357.1 tyrosine-type recombinase/integrase [Candidatus Obscuribacterales bacterium] | diamond | 1644 | 108 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 32632464 | 32632464 | PRJNA1159911_P_NODE_95680_length_245_cov_0.895349_g95138_i0 | PRJNA1159911 | 95680 | 245 | 0.895349 | 2.19360505 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 157 | 2.849999999999999e-43 | NR | MBX9950447.1 | 2364082 | g95138 | i0 | 96.3 | 0.991836734693878 | 81 | 3 | 99.2 | 0 | 245 | 3 | 290 | 370 | MBX9950447.1 DUF4388 domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 243 | 157 | 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);;