contig_metadata
14 rows where bioproject = "PRJNA407886", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1692262 | 1692262 | PRJNA407886_P_NODE_41922_length_337_cov_1.102273_g40228_i0 | PRJNA407886 | 41922 | 337 | 1.102273 | 3.71466001 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 52.8 | 0.032 | NTclustered | gi|2893358443|emb|OZ220735.1| | 3069543 | g40228 | i0 | 100 | 0.0830860534124629 | 28 | 0 | 8 | 0 | 159 | 186 | 2226432 | 2226459 | MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 15720754 | 15720754 | PRJNA407886_P_NODE_74933_length_247_cov_0.885057_g73239_i0 | PRJNA407886 | 74933 | 247 | 0.885057 | 2.18609079 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 61.6 | 1.55e-9 | NR | MEO8626088.1 | 2952938 | g73239 | i0 | 43.1 | 0.874493927125506 | 72 | 37 | 87.4 | 1 | 243 | 28 | 96 | 163 | MEO8626088.1 copper resistance CopC family protein [Candidatus Limnocylindrales bacterium] | diamond | 216 | 61.6 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 26980534 | 26980534 | PRJNA407886_P_NODE_71302_length_250_cov_0.870056_g69608_i0 | PRJNA407886 | 71302 | 250 | 0.870056 | 2.17514 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 72 | 1.11e-12 | NR | MCC7354188.1 | 2052143 | g69608 | i0 | 52.3 | 1.548 | 65 | 28 | 76.8 | 3 | 194 | 3 | 233 | 295 | MCC7354188.1 hypothetical protein [Anaerolineae bacterium] | diamond | 387 | 72 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27360108 | 27360108 | PRJNA407886_P_NODE_44843_length_324_cov_1.474104_g43149_i0 | PRJNA407886 | 44843 | 324 | 1.474104 | 4.77609696 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 47.8 | 0.00162 | NR | MEW5985999.1 | 2026724 | g43149 | i0 | 36 | 1.61111111111111 | 89 | 56 | 82.4 | 1 | 267 | 1 | 23 | 110 | MEW5985999.1 S8 family serine peptidase [Chloroflexota bacterium] | diamond | 522 | 47.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28481793 | 28481793 | PRJNA407886_P_NODE_73126_length_248_cov_0.880000_g71432_i0 | PRJNA407886 | 73126 | 248 | 0.88 | 2.1824 | Chloroflexota | 200795 | Bacteria | Bacteria | 95.5 | 2.13e-21 | NR | HZQ08140.1 | 2052143 | g71432 | i0 | 57.3 | 2.96370967741935 | 82 | 34 | 99.2 | 1 | 2 | 247 | 69 | 149 | HZQ08140.1 glycosyltransferase family 4 protein [Anaerolineae bacterium] | diamond | 735 | 95.9 | 0.995828988529718 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29412218 | 29412218 | PRJNA407886_P_NODE_60409_length_273_cov_1.540000_g58715_i0 | PRJNA407886 | 60409 | 273 | 1.54 | 4.2042 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 105 | 4.63e-24 | NR | MBX7213414.1 | 2497639 | g58715 | i0 | 55.8 | 0.945054945054945 | 86 | 36 | 92.3 | 1 | 268 | 17 | 819 | 904 | MBX7213414.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Thermoflexales bacterium] | diamond | 258 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 29980763 | 29980763 | PRJNA407886_P_NODE_66891_length_257_cov_1.673913_g65197_i0 | PRJNA407886 | 66891 | 257 | 1.673913 | 4.30195641 | Aggregatilineales bacterium | 2952883 | Bacteria | Bacteria | 48.9 | 3.06e-4 | NR | HUN07214.1 | 2952883 | g65197 | i0 | 35.4 | 0.957198443579767 | 82 | 52 | 95.7 | 1 | 252 | 7 | 570 | 650 | HUN07214.1 VWA domain-containing protein [Aggregatilineales bacterium] | diamond | 246 | 48.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Aggregatilineales bacterium | ||||
| 30881985 | 30881985 | PRJNA407886_P_NODE_38454_length_355_cov_1.443262_g36760_i0 | PRJNA407886 | 38454 | 355 | 1.443262 | 5.1235801 | Bacteria | 2 | Bacteria | Bacteria | 117 | 4.53e-29 | NR | MDE2785175.1 | 2026724 | g36760 | i0 | 43.2 | 9.88732394366197 | 118 | 67 | 99.7 | 0 | 354 | 1 | 125 | 242 | MDE2785175.1 polyamine aminopropyltransferase [Chloroflexota bacterium] | diamond | 3510 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31023368 | 31023368 | PRJNA407886_P_NODE_28195_length_436_cov_2.545455_g26502_i0 | PRJNA407886 | 28195 | 436 | 2.545455 | 11.0981838 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 57.4 | 2.22e-7 | NR | MCW5848612.1 | 2052143 | g26502 | i0 | 42.5 | 0.598623853211009 | 87 | 48 | 59.2 | 2 | 13 | 270 | 39 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 261 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31529365 | 31529365 | PRJNA407886_P_NODE_17236_length_643_cov_1.591228_g15574_i0 | PRJNA407886 | 17236 | 643 | 1.591228 | 10.23159604 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 52.4 | 6.53e-4 | NR | MBX2997503.1 | 2614250 | g15574 | i0 | 30.9 | 0.816485225505443 | 175 | 104 | 77 | 9 | 582 | 88 | 262 | 429 | MBX2997503.1 DUF11 domain-containing protein [Caldilineaceae bacterium] | diamond | 525 | 52.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 31782077 | 31782077 | PRJNA407886_P_NODE_33197_length_390_cov_2.829653_g31503_i0 | PRJNA407886 | 33197 | 390 | 2.829653 | 11.0356467 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 50.4 | 1.05e-4 | NR | MBP7690251.1 | 2497639 | g31503 | i0 | 39.2 | 0.784615384615385 | 102 | 56 | 78.5 | 2 | 375 | 70 | 54 | 149 | MBP7690251.1 SRPBCC family protein [Thermoflexales bacterium] | diamond | 306 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 32115449 | 32115449 | PRJNA407886_P_NODE_38078_length_357_cov_1.401408_g36384_i0 | PRJNA407886 | 38078 | 357 | 1.401408 | 5.00302656 | Bacteria | 2 | Bacteria | Bacteria | 87 | 4.43e-18 | NR | MFC1913912.1 | 2026724 | g36384 | i0 | 43.7 | 9.73109243697479 | 103 | 50 | 86.6 | 1 | 8 | 316 | 140 | 234 | MFC1913912.1 MIP family channel protein [Chloroflexota bacterium] | diamond | 3474 | 87 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32162098 | 32162098 | PRJNA407886_P_NODE_53218_length_294_cov_1.045249_g51524_i0 | PRJNA407886 | 53218 | 294 | 1.045249 | 3.07303206 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 43.1 | 0.0486 | NR | MFP4441253.1 | 2562117 | g51524 | i0 | 34.1 | 0.897959183673469 | 88 | 44 | 79.6 | 4 | 288 | 55 | 290 | 373 | MFP4441253.1 WGR domain-containing protein [Chloroflexaceae bacterium] | diamond | 264 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 32699083 | 32699083 | PRJNA407886_P_NODE_73340_length_248_cov_0.880000_g71646_i0 | PRJNA407886 | 73340 | 248 | 0.88 | 2.1824 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 94 | 2.68e-20 | NR | HKZ69802.1 | 2073117 | g71646 | i0 | 66.7 | 0.798387096774194 | 66 | 22 | 79.8 | 0 | 203 | 6 | 4 | 69 | HKZ69802.1 aspartate aminotransferase family protein [Anaerolineales bacterium] | diamond | 198 | 94 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales 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);;