contig_metadata
8 rows where bioproject = "PRJNA773778" and tax_phylum = "Chloroflexota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 751110 | 751110 | PRJNA773778_S_NODE_29861_length_283_cov_1.838095_g29711_i0 | PRJNA773778 | 29861 | 283 | 1.838095 | 5.20180885 | Pelolinea submarina | 913107 | Bacteria | Bacteria | 130 | 1.17e-25 | NTclustered | gi|1446038753|dbj|AP018437.1| | 913107 | g29711 | i0 | 86.555 | 0.420494699646643 | 119 | 15 | 42 | 1 | 1 | 119 | 1886538 | 1886421 | Pelolinea submarina MO-CFX1 DNA, complete genome | blastn | 119 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Pelolinea | Pelolinea submarina | ||
| 4578982 | 4578982 | PRJNA773778_S_NODE_15364_length_364_cov_3.642612_g15214_i0 | PRJNA773778 | 15364 | 364 | 3.642612 | 13.25910768 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 473 | 6.219999999999999e-129 | NTclustered | gi|2621703607|emb|OY762613.1| | 2024896 | g15214 | i0 | 90.137 | 13.2994505494505 | 365 | 35 | 100 | 1 | 1 | 364 | 2075279 | 2074915 | MAG: Anaerolineaceae bacterium isolate 484d0fed-5884-4132-919b-d0a78980a3b8 genome assembly, chromosome: 1 | blastn | 4841 | 473 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 5854578 | 5854578 | PRJNA773778_S_NODE_26265_length_298_cov_1.271111_g26115_i0 | PRJNA773778 | 26265 | 298 | 1.271111 | 3.78791078 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 390 | 5.17e-104 | NTclustered | gi|2621713652|emb|OY771913.1| | 2024896 | g26115 | i0 | 90.541 | 1.9261744966443 | 296 | 27 | 99 | 1 | 1 | 296 | 611223 | 610929 | MAG: Anaerolineaceae bacterium isolate c74f872c-e933-4053-8305-e1536b6d7914 genome assembly, chromosome: 1 | blastn | 574 | 390 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 14779533 | 14779533 | PRJNA773778_S_NODE_12952_length_389_cov_9.360759_g12802_i0 | PRJNA773778 | 12952 | 389 | 9.360759 | 36.41335251 | Kallotenue papyrolyticum | 1325125 | Bacteria | Bacteria | 154 | 1.8099999999999993e-43 | NR | WP_025745966.1 | 1325125 | g12802 | i0 | 83.7 | 0.663239074550129 | 86 | 14 | 66.3 | 0 | 98 | 355 | 1 | 86 | WP_025745966.1 2-phospho-L-lactate transferase [Kallotenue papyrolyticum] | diamond | 258 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Kallotenuales | Kallotenuaceae | Kallotenue | Kallotenue papyrolyticum | ||
| 17784827 | 17784827 | PRJNA773778_S_NODE_13394_length_384_cov_7.543408_g13244_i0 | PRJNA773778 | 13394 | 384 | 7.543408 | 28.96668672 | Candidatus Chloroploca sp. Khr17 | 2496869 | Bacteria | Bacteria | 227 | 9.39e-68 | NR | WP_129671738.1 | 2496869 | g13244 | i0 | 84.3 | 2.8359375 | 121 | 19 | 94.5 | 0 | 384 | 22 | 524 | 644 | WP_129671738.1 glycogen debranching protein GlgX [Candidatus Chloroploca sp. Khr17] | diamond | 1089 | 227 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Oscillochloridaceae | Candidatus Chloroploca | Candidatus Chloroploca sp. Khr17 | ||
| 26704948 | 26704948 | PRJNA773778_S_NODE_20161_length_328_cov_1.501961_g20011_i0 | PRJNA773778 | 20161 | 328 | 1.501961 | 4.92643208 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 100 | 1.2e-22 | NR | NLF12398.1 | 2024896 | g20011 | i0 | 97.9 | 0.429878048780488 | 47 | 1 | 43 | 0 | 141 | 1 | 1 | 47 | NLF12398.1 zinc ribbon domain-containing protein [Anaerolineaceae bacterium] | diamond | 141 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 26768495 | 26768495 | PRJNA773778_S_NODE_30881_length_280_cov_1.038647_g30731_i0 | PRJNA773778 | 30881 | 280 | 1.038647 | 2.9082116 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 194 | 3.7099999999999995e-57 | NR | MCK9247215.1 | 2024896 | g30731 | i0 | 100 | 0.996428571428571 | 93 | 0 | 99.6 | 0 | 279 | 1 | 415 | 507 | MCK9247215.1 IS66 family transposase [Anaerolineaceae bacterium] | diamond | 279 | 194 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27905932 | 27905932 | PRJNA773778_S_NODE_22425_length_316_cov_0.950617_g22275_i0 | PRJNA773778 | 22425 | 316 | 0.950617 | 3.00394972 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 185 | 1.4899999999999999e-53 | NR | MCK9247215.1 | 2024896 | g22275 | i0 | 100 | 0.939873417721519 | 99 | 0 | 94 | 0 | 298 | 2 | 1 | 99 | MCK9247215.1 IS66 family transposase [Anaerolineaceae bacterium] | diamond | 297 | 185 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae 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);;