contig_metadata
18 rows where bioproject = "PRJNA603943", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10781734 | 10781734 | PRJNA603943_P_NODE_48329_length_265_cov_1.166667_g48137_i0 | PRJNA603943 | 48329 | 265 | 1.166667 | 3.09166755 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 142 | 1.68e-38 | NR | MBA3643122.1 | 2448782 | g48137 | i0 | 78.4 | 1.99245283018868 | 88 | 19 | 99.6 | 0 | 1 | 264 | 306 | 393 | MBA3643122.1 M20 family metallopeptidase [Chloroflexia bacterium] | diamond | 528 | 142 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 26984985 | 26984985 | PRJNA603943_P_NODE_60622_length_247_cov_0.885057_g60430_i0 | PRJNA603943 | 60622 | 247 | 0.885057 | 2.18609079 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.1 | 0.0164 | NR | MCI0850001.1 | 2026724 | g60430 | i0 | 41.3 | 0.765182186234818 | 63 | 22 | 75.3 | 3 | 204 | 19 | 22 | 70 | MCI0850001.1 flippase-like domain-containing protein [Chloroflexota bacterium] | diamond | 189 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27048405 | 27048405 | PRJNA603943_P_NODE_2442_length_906_cov_6.769508_g2293_i0 | PRJNA603943 | 2442 | 906 | 6.769508 | 61.33174248 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 165 | 1.1399999999999999e-46 | NR | MCL6509834.1 | 2052143 | g2293 | i0 | 54.5 | 1.03311258278146 | 156 | 68 | 51.7 | 2 | 438 | 905 | 1 | 153 | MCL6509834.1 conjugative transfer signal peptidase TraF [Anaerolineae bacterium] | diamond | 936 | 165 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27156075 | 27156075 | PRJNA603943_P_NODE_47962_length_266_cov_1.196891_g47770_i0 | PRJNA603943 | 47962 | 266 | 1.196891 | 3.18373006 | Bacillati | 1783272 | Bacteria | Bacteria | 171 | 1.3900000000000001e-49 | NR | WP_103908323.1 | 61435 | g47770 | i0 | 94.3 | 12.9022556390977 | 88 | 5 | 99.2 | 0 | 2 | 265 | 45 | 132 | WP_103908323.1 MFS transporter [Dehalococcoides mccartyi] | diamond | 3432 | 171 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidaceae | Dehalococcoides | Dehalococcoides mccartyi | ||
| 28216700 | 28216700 | PRJNA603943_P_NODE_41646_length_286_cov_1.169014_g41454_i0 | PRJNA603943 | 41646 | 286 | 1.169014 | 3.34338004 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 154 | 1.98e-43 | NR | MCL6509811.1 | 2052143 | g41454 | i0 | 77.9 | 0.996503496503496 | 95 | 21 | 99.7 | 0 | 285 | 1 | 187 | 281 | MCL6509811.1 P-type conjugative transfer protein TrbG [Anaerolineae bacterium] | diamond | 285 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28343263 | 28343263 | PRJNA603943_P_NODE_8226_length_547_cov_1.677215_g8039_i0 | PRJNA603943 | 8226 | 547 | 1.677215 | 9.17436605 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 90.1 | 9.99e-19 | NR | MCL6509849.1 | 2052143 | g8039 | i0 | 59.7 | 0.394881170018282 | 72 | 28 | 38.9 | 1 | 513 | 301 | 131 | 202 | MCL6509849.1 hypothetical protein [Anaerolineae bacterium] | diamond | 216 | 90.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28438117 | 28438117 | PRJNA603943_P_NODE_33306_length_316_cov_1.267490_g33114_i0 | PRJNA603943 | 33306 | 316 | 1.26749 | 4.0052684 | Chloroflexus aggregans | 152260 | Bacteria | Bacteria | 88.2 | 9.89e-18 | NR | WP_012615970.1 | 152260 | g33114 | i0 | 51.5 | 2.81962025316456 | 99 | 44 | 92.1 | 3 | 26 | 316 | 185 | 281 | WP_012615970.1 RCC1 domain-containing protein [Chloroflexus aggregans] | diamond | 891 | 88.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | Chloroflexus aggregans | ||
| 28879904 | 28879904 | PRJNA603943_P_NODE_22688_length_365_cov_1.726027_g22496_i0 | PRJNA603943 | 22688 | 365 | 1.726027 | 6.29999855 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 106 | 5.1e-27 | NR | MCL6509826.1 | 2052143 | g22496 | i0 | 61.7 | 0.772602739726027 | 94 | 36 | 77.3 | 0 | 1 | 282 | 22 | 115 | MCL6509826.1 hypothetical protein [Anaerolineae bacterium] | diamond | 282 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28879930 | 28879930 | PRJNA603943_P_NODE_65188_length_244_cov_0.900585_g64996_i0 | PRJNA603943 | 65188 | 244 | 0.900585 | 2.1974274 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 80.1 | 6.09e-16 | NR | MCW1970525.1 | 2052143 | g64996 | i0 | 59 | 1.52459016393443 | 61 | 25 | 75 | 0 | 59 | 241 | 5 | 65 | MCW1970525.1 phytanoyl-CoA dioxygenase family protein [Anaerolineae bacterium] | diamond | 372 | 80.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29101095 | 29101095 | PRJNA603943_P_NODE_15028_length_428_cov_1.447887_g14836_i0 | PRJNA603943 | 15028 | 428 | 1.447887 | 6.19695636 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 120 | 3.7e-30 | NR | MCL6509847.1 | 2052143 | g14836 | i0 | 72 | 0.525700934579439 | 75 | 21 | 52.6 | 0 | 203 | 427 | 48 | 122 | MCL6509847.1 replication initiator protein A [Anaerolineae bacterium] | diamond | 225 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30490759 | 30490759 | PRJNA603943_P_NODE_1953_length_991_cov_1.517429_g1815_i0 | PRJNA603943 | 1953 | 991 | 1.517429 | 15.03772139 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 399 | 1.61e-129 | NR | MCL6509816.1 | 2052143 | g1815 | i0 | 72 | 0.778002018163471 | 257 | 72 | 77.8 | 0 | 219 | 989 | 1 | 257 | MCL6509816.1 conjugal transfer protein TrbE [Anaerolineae bacterium] | diamond | 771 | 399 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30585341 | 30585341 | PRJNA603943_P_NODE_52893_length_251_cov_0.865169_g52701_i0 | PRJNA603943 | 52893 | 251 | 0.865169 | 2.17157419 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 94.7 | 2.05e-20 | NR | MCL6509831.1 | 2052143 | g52701 | i0 | 61.3 | 0.956175298804781 | 80 | 31 | 95.6 | 0 | 11 | 250 | 337 | 416 | MCL6509831.1 ssDNA-binding domain-containing protein [Anaerolineae bacterium] | diamond | 240 | 94.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30869805 | 30869805 | PRJNA603943_P_NODE_19154_length_389_cov_2.746835_g18962_i0 | PRJNA603943 | 19154 | 389 | 2.746835 | 10.68518815 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 122 | 4.239999999999999e-31 | NR | MCL6509822.1 | 2052143 | g18962 | i0 | 67.4 | 0.709511568123393 | 92 | 27 | 71 | 1 | 279 | 4 | 3 | 91 | MCL6509822.1 zeta toxin family protein [Anaerolineae bacterium] | diamond | 276 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31185544 | 31185544 | PRJNA603943_P_NODE_69775_length_241_cov_0.916667_g69583_i0 | PRJNA603943 | 69775 | 241 | 0.916667 | 2.20916747 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 62.8 | 1.39e-9 | NR | NLV75342.1 | 2026724 | g69583 | i0 | 81.6 | 0.473029045643154 | 38 | 7 | 47.3 | 0 | 117 | 4 | 1 | 38 | NLV75342.1 polyphosphate polymerase domain-containing protein [Chloroflexota bacterium] | diamond | 114 | 62.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31660030 | 31660030 | PRJNA603943_P_NODE_10037_length_504_cov_2.415313_g9846_i0 | PRJNA603943 | 10037 | 504 | 2.415313 | 12.17317752 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 124 | 1.49e-29 | NR | MCL6509831.1 | 2052143 | g9846 | i0 | 60.4 | 0.660714285714286 | 111 | 42 | 65.5 | 2 | 15 | 344 | 506 | 615 | MCL6509831.1 ssDNA-binding domain-containing protein [Anaerolineae bacterium] | diamond | 333 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31660054 | 31660054 | PRJNA603943_P_NODE_54237_length_250_cov_1.305085_g54045_i0 | PRJNA603943 | 54237 | 250 | 1.305085 | 3.2627125 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 63.2 | 2.13e-9 | NR | MCL6509848.1 | 2052143 | g54045 | i0 | 45.5 | 0.924 | 77 | 39 | 88.8 | 1 | 1 | 222 | 48 | 124 | MCL6509848.1 OmpA family protein [Anaerolineae bacterium] | diamond | 231 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32134901 | 32134901 | PRJNA603943_P_NODE_52638_length_251_cov_0.865169_g52446_i0 | PRJNA603943 | 52638 | 251 | 0.865169 | 2.17157419 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 45.4 | 0.00408 | NR | QLQ06590.1 | 2052143 | g52446 | i0 | 40.9 | 0.788844621513944 | 66 | 37 | 76.5 | 1 | 193 | 2 | 128 | 193 | QLQ06590.1 MAG: hypothetical protein HZY76_11455 [Anaerolineae bacterium] | diamond | 198 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32716877 | 32716877 | PRJNA603943_P_NODE_62060_length_246_cov_0.890173_g61868_i0 | PRJNA603943 | 62060 | 246 | 0.890173 | 2.18982558 | Chloroflexota | 200795 | Bacteria | Bacteria | 105 | 4.339999999999999e-24 | NR | MBE2270471.1 | 1872519 | g61868 | i0 | 58 | 1.97560975609756 | 81 | 34 | 98.8 | 0 | 2 | 244 | 680 | 760 | MBE2270471.1 cytochrome c oxidase subunit I [Anaerolinea sp.] | diamond | 486 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. |
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);;