contig_metadata
14 rows where bioproject = "PRJNA939369", tax_kingdom = "Bacillati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26961555 | 26961555 | PRJNA939369_S_NODE_55882_length_251_cov_0.865169_g55465_i0 | PRJNA939369 | 55882 | 251 | 0.865169 | 2.17157419 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0452 | NR | MBU4225059.1 | 2026724 | g55465 | i0 | 53.6 | 0.334661354581673 | 28 | 11 | 31.1 | 1 | 17 | 94 | 10 | 37 | MBU4225059.1 hypothetical protein [Chloroflexota bacterium] | diamond | 84 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27877897 | 27877897 | PRJNA939369_S_NODE_64005_length_247_cov_0.885057_g63588_i0 | PRJNA939369 | 64005 | 247 | 0.885057 | 2.18609079 | Promineifilum sp. | 2664178 | Bacteria | Bacteria | 48.5 | 3.32e-4 | NR | MBP9500908.1 | 2664178 | g63588 | i0 | 38.8 | 0.97165991902834 | 80 | 41 | 97.2 | 5 | 245 | 6 | 231 | 302 | MBP9500908.1 toprim domain-containing protein [Promineifilum sp.] | diamond | 240 | 48.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Promineifilum sp. | ||
| 27948080 | 27948080 | PRJNA939369_S_NODE_61525_length_248_cov_0.880000_g61108_i0 | PRJNA939369 | 61525 | 248 | 0.88 | 2.1824 | Bacillati | 1783272 | Bacteria | Bacteria | 134 | 1.11e-38 | NR | MBQ6479734.1 | 2024896 | g61108 | i0 | 75.6 | 1.98387096774194 | 82 | 20 | 99.2 | 0 | 246 | 1 | 34 | 115 | MBQ6479734.1 DUF5055 domain-containing protein [Anaerolineaceae bacterium] | diamond | 492 | 135 | 0.992592592592593 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 28200415 | 28200415 | PRJNA939369_S_NODE_25266_length_316_cov_0.938272_g24849_i0 | PRJNA939369 | 25266 | 316 | 0.938272 | 2.96493952 | PVC group | 1783257 | Bacteria | Bacteria | 103 | 1.0099999999999999e-24 | NR | HHY89788.1 | 2026724 | g24849 | i0 | 50.5 | 2.93354430379747 | 103 | 51 | 97.8 | 0 | 311 | 3 | 59 | 161 | HHY89788.1 hypothetical protein [Chloroflexota bacterium] | diamond | 927 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28358359 | 28358359 | PRJNA939369_S_NODE_16746_length_357_cov_1.355634_g16329_i0 | PRJNA939369 | 16746 | 357 | 1.355634 | 4.83961338 | PVC group | 1783257 | Bacteria | Bacteria | 92.4 | 2.79e-20 | NR | HHY88308.1 | 2026724 | g16329 | i0 | 38.8 | 1.94957983193277 | 116 | 69 | 97.5 | 1 | 6 | 353 | 109 | 222 | HHY88308.1 hypothetical protein [Chloroflexota bacterium] | diamond | 696 | 92.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28793386 | 28793386 | PRJNA939369_S_NODE_65487_length_246_cov_0.890173_g65070_i0 | PRJNA939369 | 65487 | 246 | 0.890173 | 2.18982558 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 150 | 5.41e-40 | NR | MBQ6520913.1 | 2024896 | g65070 | i0 | 87.8 | 1 | 82 | 10 | 100 | 0 | 246 | 1 | 430 | 511 | MBQ6520913.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 246 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 28951627 | 28951627 | PRJNA939369_S_NODE_57828_length_250_cov_0.870056_g57411_i0 | PRJNA939369 | 57828 | 250 | 0.870056 | 2.17514 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.9 | 4.74e-19 | NR | MBM24280.1 | 2026724 | g57411 | i0 | 54.9 | 0.984 | 82 | 37 | 98.4 | 0 | 5 | 250 | 527 | 608 | MBM24280.1 hypothetical protein [Chloroflexota bacterium] | diamond | 246 | 90.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29077832 | 29077832 | PRJNA939369_S_NODE_12088_length_398_cov_1.040000_g11671_i0 | PRJNA939369 | 12088 | 398 | 1.04 | 4.1392 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 65.5 | 2.27e-9 | NR | HBF40449.1 | 2024896 | g11671 | i0 | 31.3 | 2.8643216080402 | 128 | 85 | 95 | 2 | 398 | 21 | 14 | 140 | HBF40449.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 1140 | 65.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 29361902 | 29361902 | PRJNA939369_S_NODE_39789_length_277_cov_1.132353_g39372_i0 | PRJNA939369 | 39789 | 277 | 1.132353 | 3.13661781 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 90.5 | 7.96e-20 | NR | MBM24262.1 | 2026724 | g39372 | i0 | 51.3 | 0.844765342960289 | 78 | 38 | 84.5 | 0 | 277 | 44 | 73 | 150 | MBM24262.1 ribonuclease HI [Chloroflexota bacterium] | diamond | 234 | 90.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29582532 | 29582532 | PRJNA939369_S_NODE_15770_length_364_cov_1.206186_g15353_i0 | PRJNA939369 | 15770 | 364 | 1.206186 | 4.39051704 | Flexilinea sp. | 2017390 | Bacteria | Bacteria | 71.6 | 3.56e-13 | NR | MBQ6503191.1 | 2017390 | g15353 | i0 | 38 | 0.997252747252747 | 121 | 50 | 89 | 5 | 24 | 347 | 18 | 126 | MBQ6503191.1 hypothetical protein [Flexilinea sp.] | diamond | 363 | 71.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Flexilinea | Flexilinea sp. | ||
| 30783300 | 30783300 | PRJNA939369_S_NODE_39294_length_278_cov_1.126829_g38877_i0 | PRJNA939369 | 39294 | 278 | 1.126829 | 3.13258462 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 135 | 6.19e-36 | NR | MBM24148.1 | 2026724 | g38877 | i0 | 68.5 | 0.992805755395683 | 92 | 29 | 99.3 | 0 | 1 | 276 | 142 | 233 | MBM24148.1 Type II secretion system F domain protein [Chloroflexota bacterium] | diamond | 276 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30878068 | 30878068 | PRJNA939369_S_NODE_64714_length_246_cov_1.300578_g64297_i0 | PRJNA939369 | 64714 | 246 | 1.300578 | 3.19942188 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 81.3 | 1.27e-17 | NR | MBQ6520910.1 | 2024896 | g64297 | i0 | 48.8 | 0.975609756097561 | 80 | 41 | 97.6 | 0 | 5 | 244 | 6 | 85 | MBQ6520910.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 240 | 81.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 31162167 | 31162167 | PRJNA939369_S_NODE_71475_length_243_cov_0.905882_g71058_i0 | PRJNA939369 | 71475 | 243 | 0.905882 | 2.20129326 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 68.2 | 4.15e-11 | NR | MEN6571397.1 | 2024896 | g71058 | i0 | 44 | 1.85185185185185 | 75 | 41 | 91.4 | 1 | 13 | 234 | 422 | 496 | MEN6571397.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 450 | 68.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32301598 | 32301598 | PRJNA939369_S_NODE_23599_length_322_cov_0.903614_g23182_i0 | PRJNA939369 | 23599 | 322 | 0.903614 | 2.90963708 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 66.6 | 1.33e-10 | NR | MBQ4512239.1 | 2024896 | g23182 | i0 | 60.4 | 1.37888198757764 | 53 | 21 | 49.4 | 0 | 163 | 5 | 5 | 57 | MBQ4512239.1 M23 family metallopeptidase [Anaerolineaceae bacterium] | diamond | 444 | 66.6 | 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);;