contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA407087" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10618860 | 10618860 | PRJNA407087_S_NODE_1609_length_530_cov_7.938124_g613_i1 | PRJNA407087 | 1609 | 530 | 7.938124 | 42.0720572 | Candidatus Altimarinota bacterium | 2044595 | Bacteria | Bacteria | 154 | 2.47e-41 | NR | MDD5769349.1 | 2044595 | g613 | i1 | 49.7 | 11.1735849056604 | 157 | 77 | 88.9 | 1 | 8 | 478 | 295 | 449 | MDD5769349.1 leucyl aminopeptidase family protein [Candidatus Altimarinota bacterium] | diamond | 5922 | 154 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Altimarinota | Candidatus Altimarinota bacterium | ||||||
| 28702847 | 28702847 | PRJNA407087_S_NODE_3487_length_312_cov_2.996466_g3024_i0 | PRJNA407087 | 3487 | 312 | 2.996466 | 9.34897392 | Bacteria | 2 | Bacteria | Bacteria | 90.5 | 8.47e-19 | NR | MCS7245191.1 | 2052148 | g3024 | i0 | 44.7 | 3.98076923076923 | 103 | 51 | 99 | 2 | 312 | 4 | 298 | 394 | MCS7245191.1 ornithine--oxo-acid transaminase [candidate division WOR-3 bacterium] | diamond | 1242 | 90.9 | 0.995599559955996 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 bacterium | ||||||
| 29033635 | 29033635 | PRJNA407087_S_NODE_8088_length_169_cov_3.571429_g7625_i0 | PRJNA407087 | 8088 | 169 | 3.571429 | 6.03571501 | Candidatus Babelota bacterium | 2030827 | Bacteria | Bacteria | 57.4 | 4.65e-8 | NR | MCA9770713.1 | 2030827 | g7625 | i0 | 51.9 | 0.958579881656805 | 54 | 26 | 95.9 | 0 | 166 | 5 | 105 | 158 | MCA9770713.1 ribosomal protein L13e [Candidatus Dependentiae bacterium] | diamond | 162 | 57.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Babelota bacterium | |||||||
| 29254154 | 29254154 | PRJNA407087_S_NODE_3589_length_304_cov_4.658182_g3126_i0 | PRJNA407087 | 3589 | 304 | 4.658182 | 14.16087328 | Candidatus Methylomirabilota bacterium | 2072417 | Bacteria | Bacteria | 114 | 4.7e-29 | NR | HTZ34286.1 | 2072417 | g3126 | i0 | 64.3 | 5.0625 | 84 | 29 | 82.9 | 1 | 254 | 3 | 4 | 86 | HTZ34286.1 CoA transferase subunit A [Candidatus Methylomirabilota bacterium] | diamond | 1539 | 114 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilota bacterium | ||||||
| 30233410 | 30233410 | PRJNA407087_S_NODE_3012_length_352_cov_5.111455_g2550_i0 | PRJNA407087 | 3012 | 352 | 5.111455 | 17.9923216 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 45.1 | 0.0197 | NR | MFO7979824.1 | 2052149 | g2550 | i0 | 26.6 | 0.801136363636364 | 94 | 59 | 71.6 | 2 | 262 | 11 | 56 | 149 | MFO7979824.1 hypothetical protein [Candidatus Aminicenantes bacterium] | diamond | 282 | 45.1 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes bacterium | ||||||
| 30612428 | 30612428 | PRJNA407087_S_NODE_9073_length_158_cov_4.100775_g8610_i0 | PRJNA407087 | 9073 | 158 | 4.100775 | 6.4792245 | Candidatus Methylomirabilales bacterium | 3159508 | Bacteria | Bacteria | 39.3 | 0.0283 | NR | MFQ5847743.1 | 3159508 | g8610 | i0 | 41.7 | 0.683544303797468 | 36 | 21 | 68.4 | 0 | 51 | 158 | 8 | 43 | MFQ5847743.1 zinc ribbon domain-containing protein [Candidatus Methylomirabilales bacterium] | diamond | 108 | 39.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Methylomirabilota | Candidatus Methylomirabilia | Candidatus Methylomirabilales | Candidatus Methylomirabilales bacterium | ||||
| 31687260 | 31687260 | PRJNA407087_S_NODE_6937_length_187_cov_2.215190_g6474_i0 | PRJNA407087 | 6937 | 187 | 2.21519 | 4.1424053 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 40 | 0.0415 | NR | MEX0598774.1 | 2053589 | g6474 | i0 | 41.9 | 0.994652406417112 | 62 | 29 | 94.7 | 2 | 184 | 8 | 20 | 77 | MEX0598774.1 30S ribosomal protein S15 [Candidatus Paceibacterota bacterium] | diamond | 186 | 40 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31908758 | 31908758 | PRJNA407087_S_NODE_6617_length_193_cov_3.048780_g6154_i0 | PRJNA407087 | 6617 | 193 | 3.04878 | 5.8841454 | Candidatus Hydrothermia bacterium | 3014280 | Bacteria | Bacteria | 90.5 | 1.65e-19 | NR | MDT7879665.1 | 3014280 | g6154 | i0 | 67.8 | 0.917098445595855 | 59 | 19 | 91.7 | 0 | 9 | 185 | 270 | 328 | MDT7879665.1 ornithine--oxo-acid transaminase [Candidatus Hydrothermia bacterium] | diamond | 177 | 90.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Hydrothermota | Candidatus Hydrothermia | Candidatus Hydrothermia bacterium | |||||
| 32193595 | 32193595 | PRJNA407087_S_NODE_438_length_1150_cov_8.553078_g267_i0 | PRJNA407087 | 438 | 1150 | 8.553078 | 98.360397 | Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_ | 2053557 | Bacteria | Bacteria | 48.9 | 0.0373 | NR | OGF66689.1 | 1798332 | g267 | i0 | 26.1 | 0.42 | 161 | 105 | 40.4 | 4 | 666 | 1130 | 487 | 639 | OGF66689.1 MAG: sodium-translocating pyrophosphatase [Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_43_32] | diamond | 483 | 48.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Giovannoniibacteriota | Candidatus Giovannonibacteria bacterium RIFCSPHIGHO2_02_FULL_43_32 | ||||||
| 32887880 | 32887880 | PRJNA407087_S_NODE_7360_length_180_cov_1.662252_g6897_i0 | PRJNA407087 | 7360 | 180 | 1.662252 | 2.9920536 | Candidatus Dojkabacteria bacterium | 2099670 | Bacteria | Bacteria | 48.5 | 7.31e-5 | NR | HRP38035.1 | 2099670 | g6897 | i0 | 40.7 | 0.9 | 54 | 32 | 90 | 0 | 8 | 169 | 49 | 102 | HRP38035.1 hypothetical protein [Candidatus Dojkabacteria bacterium] | diamond | 162 | 48.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 32887881 | 32887881 | PRJNA407087_S_NODE_8780_length_161_cov_4.204545_g8317_i0 | PRJNA407087 | 8780 | 161 | 4.204545 | 6.76931745 | candidate division WOR-3 bacterium | 2052148 | Bacteria | Bacteria | 55.1 | 9.18e-8 | NR | MCX7785919.1 | 2052148 | g8317 | i0 | 58.3 | 5.29192546583851 | 48 | 18 | 89.4 | 1 | 144 | 1 | 12 | 57 | MCX7785919.1 RidA family protein [candidate division WOR-3 bacterium] | diamond | 852 | 55.1 | 1 | Bacteria | Bacteria candidate phyla | candidate division WOR-3 | candidate division WOR-3 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);;