contig_metadata
9 rows where bioproject = "PRJNA438111", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27708249 | 27708249 | PRJNA438111_P_NODE_89484_length_151_cov_2.295082_g88859_i0 | PRJNA438111 | 89484 | 151 | 2.295082 | 3.46557382 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 65.5 | 9.21e-11 | NR | MBZ0187373.1 | 2364082 | g88859 | i0 | 61.2 | 0.973509933774834 | 49 | 19 | 97.4 | 0 | 4 | 150 | 146 | 194 | MBZ0187373.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Obscuribacterales bacterium] | diamond | 147 | 65.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28528859 | 28528859 | PRJNA438111_P_NODE_51847_length_179_cov_5.506667_g51222_i0 | PRJNA438111 | 51847 | 179 | 5.506667 | 9.85693393 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 100 | 2.6999999999999993e-24 | NR | MBX9688060.1 | 2364082 | g51222 | i0 | 72.4 | 0.972067039106145 | 58 | 16 | 97.2 | 0 | 177 | 4 | 49 | 106 | MBX9688060.1 xanthine dehydrogenase accessory protein XdhC [Candidatus Obscuribacterales bacterium] | diamond | 174 | 100 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28623573 | 28623573 | PRJNA438111_P_NODE_50147_length_181_cov_4.440789_g49522_i0 | PRJNA438111 | 50147 | 181 | 4.440789 | 8.03782809 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 101 | 1.73e-24 | NR | HIA53780.1 | 2052166 | g49522 | i0 | 72.1 | 1.01104972375691 | 61 | 16 | 99.4 | 1 | 181 | 2 | 59 | 119 | HIA53780.1 DUF4091 domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 183 | 101 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30486791 | 30486791 | PRJNA438111_P_NODE_68613_length_165_cov_3.808824_g67988_i0 | PRJNA438111 | 68613 | 165 | 3.808824 | 6.2845596 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 95.5 | 3.3e-21 | NR | MDZ4834169.1 | 2052166 | g67988 | i0 | 83.3 | 1.96363636363636 | 54 | 9 | 98.2 | 0 | 164 | 3 | 255 | 308 | MDZ4834169.1 ATP-binding cassette domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 324 | 95.5 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium | |||||
| 30739352 | 30739352 | PRJNA438111_P_NODE_10574_length_315_cov_3.993007_g9951_i0 | PRJNA438111 | 10574 | 315 | 3.993007 | 12.57797205 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 202 | 1.26e-64 | NR | HIN64516.1 | 2364082 | g9951 | i0 | 100 | 2 | 105 | 0 | 100 | 0 | 315 | 1 | 14 | 118 | HIN64516.1 IS5 family transposase [Candidatus Obscuribacterales bacterium] | diamond | 630 | 202 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31008580 | 31008580 | PRJNA438111_P_NODE_67714_length_166_cov_1.992701_g67089_i0 | PRJNA438111 | 67714 | 166 | 1.992701 | 3.30788366 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 76.6 | 1.48e-14 | NR | HSA06166.1 | 2137880 | g67089 | i0 | 70.4 | 4.87951807228916 | 54 | 16 | 97.6 | 0 | 166 | 5 | 504 | 557 | HSA06166.1 ATP-binding cassette domain-containing protein [Candidatus Gastranaerophilales bacterium] | diamond | 810 | 76.6 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Gastranaerophilales | Candidatus Gastranaerophilales bacterium | ||||
| 31371728 | 31371728 | PRJNA438111_P_NODE_72236_length_163_cov_1.985075_g71611_i0 | PRJNA438111 | 72236 | 163 | 1.985075 | 3.23567225 | Vampirovibrionales bacterium | 2692181 | Bacteria | Bacteria | 45.8 | 9.78e-4 | NR | MCE2930730.1 | 2692181 | g71611 | i0 | 47.3 | 1.96932515337423 | 55 | 21 | 97.5 | 2 | 3 | 161 | 233 | 281 | MCE2930730.1 diaminopimelate epimerase [Vampirovibrionales bacterium] | diamond | 321 | 45.8 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Vampirovibriophyceae | Vampirovibrionales | Vampirovibrionales bacterium | |||
| 31561469 | 31561469 | PRJNA438111_P_NODE_24276_length_220_cov_4.026178_g23651_i0 | PRJNA438111 | 24276 | 220 | 4.026178 | 8.8575916 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 102 | 1.54e-23 | NR | MBX9572342.1 | 2364082 | g23651 | i0 | 62.9 | 0.954545454545455 | 70 | 26 | 95.5 | 0 | 218 | 9 | 107 | 176 | MBX9572342.1 allantoinase AllB [Candidatus Obscuribacterales bacterium] | diamond | 210 | 102 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 31656016 | 31656016 | PRJNA438111_P_NODE_62037_length_170_cov_1.730496_g61412_i0 | PRJNA438111 | 62037 | 170 | 1.730496 | 2.9418432 | Candidatus Melainabacteria bacterium | 2052166 | Bacteria | Bacteria | 45.8 | 0.0011 | NR | MFN5540045.1 | 2052166 | g61412 | i0 | 43.5 | 1.09411764705882 | 62 | 25 | 98.8 | 3 | 169 | 2 | 87 | 144 | MFN5540045.1 DUF262 domain-containing protein [Candidatus Melainabacteria bacterium] | diamond | 186 | 45.8 | 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);;