contig_metadata
6 rows where bioproject = "PRJNA758087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2009642 | 2009642 | PRJNA758087_P_NODE_35862_length_324_cov_2.075697_g34542_i0 | PRJNA758087 | 35862 | 324 | 2.075697 | 6.72525828 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 216 | 3.81e-66 | NR | MBX9687186.1 | 2364082 | g34542 | i0 | 96.3 | 1 | 108 | 4 | 100 | 0 | 324 | 1 | 109 | 216 | MBX9687186.1 NADP-dependent phosphogluconate dehydrogenase [Candidatus Obscuribacterales bacterium] | diamond | 324 | 216 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 18585269 | 18585269 | PRJNA758087_P_NODE_27315_length_457_cov_12.450521_g25995_i0 | PRJNA758087 | 27315 | 457 | 12.450521 | 56.89888097 | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_ | 2052166 | Bacteria | Bacteria | 185 | 2.93e-54 | NR | OGI18742.1 | 1801607 | g25995 | i0 | 65.9 | 0.905908096280088 | 138 | 34 | 82.7 | 2 | 79 | 456 | 148 | 284 | OGI18742.1 MAG: tRNA preQ1(34) S-adenosylmethionine ribosyltransferase-isomerase QueA [Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12] | diamond | 414 | 185 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Melainabacteria bacterium RIFCSPHIGHO2_02_FULL_34_12 | |||||
| 21136138 | 21136138 | PRJNA758087_P_NODE_34117_length_348_cov_7.123636_g32797_i0 | PRJNA758087 | 34117 | 348 | 7.123636 | 24.79025328 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 143 | 2.54e-37 | NR | MBX9688495.1 | 2364082 | g32797 | i0 | 77.6 | 2.22413793103448 | 85 | 19 | 73.3 | 0 | 70 | 324 | 9 | 93 | MBX9688495.1 ATP-binding cassette domain-containing protein [Candidatus Obscuribacterales bacterium] | diamond | 774 | 143 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 28063602 | 28063602 | PRJNA758087_P_NODE_39985_length_272_cov_4.015075_g38665_i0 | PRJNA758087 | 39985 | 272 | 4.015075 | 10.921004 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 80.9 | 2.05e-15 | NR | MBX9686575.1 | 2364082 | g38665 | i0 | 57.1 | 1.48897058823529 | 70 | 30 | 77.2 | 0 | 56 | 265 | 226 | 295 | MBX9686575.1 S53 family peptidase [Candidatus Obscuribacterales bacterium] | diamond | 405 | 80.9 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 29137457 | 29137457 | PRJNA758087_P_NODE_31809_length_383_cov_1.470968_g30489_i0 | PRJNA758087 | 31809 | 383 | 1.470968 | 5.63380744 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 159 | 8.88e-44 | NR | MBX9687936.1 | 2364082 | g30489 | i0 | 85.4 | 1.2845953002611 | 82 | 12 | 64.2 | 0 | 354 | 109 | 129 | 210 | MBX9687936.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Candidatus Obscuribacterales bacterium] | diamond | 492 | 159 | 1 | Bacteria | Cyanobacteriota/Melainabacteria group | Bacillati | Candidatus Melainabacteria | Candidatus Obscuribacterales | Candidatus Obscuribacterales bacterium | ||||
| 30653094 | 30653094 | PRJNA758087_P_NODE_33793_length_353_cov_3.528571_g32473_i0 | PRJNA758087 | 33793 | 353 | 3.528571 | 12.45585563 | Candidatus Obscuribacterales bacterium | 2364082 | Bacteria | Bacteria | 60.1 | 1.03e-8 | NR | MBX9687174.1 | 2364082 | g32473 | i0 | 40 | 0.637393767705382 | 75 | 43 | 63.7 | 1 | 120 | 344 | 4 | 76 | MBX9687174.1 hypothetical protein [Candidatus Obscuribacterales bacterium] | diamond | 225 | 60.1 | 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);;