contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6758664 | 6758664 | PRJNA315314_S_NODE_4586_length_374_cov_3.075362_g4265_i0 | PRJNA315314 | 4586 | 374 | 3.075362 | 11.50185388 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 192 | 1.9699999999999995e-55 | NR | HMV29231.1 | 2073117 | g4265 | i0 | 93.8 | 0.77807486631016 | 97 | 6 | 77.8 | 0 | 291 | 1 | 30 | 126 | HMV29231.1 group II intron reverse transcriptase/maturase [Anaerolineales bacterium] | diamond | 291 | 192 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 26680233 | 26680233 | PRJNA315314_S_NODE_3641_length_419_cov_4.707692_g3321_i0 | PRJNA315314 | 3641 | 419 | 4.707692 | 19.72522948 | Bacteria | 2 | Bacteria | Bacteria | 72.4 | 1.16e-12 | NR | WP_054521446.1 | 869279 | g3321 | i0 | 52.7 | 1.86873508353222 | 74 | 32 | 50.8 | 2 | 14 | 226 | 26 | 99 | WP_054521446.1 hypothetical protein [Thermanaerothrix daxensis] | diamond | 783 | 72.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Thermanaerothrix | Thermanaerothrix daxensis | ||
| 26694419 | 26694419 | PRJNA315314_S_NODE_32381_length_150_cov_2.454545_g32060_i0 | PRJNA315314 | 32381 | 150 | 2.454545 | 3.6818175 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 80.9 | 3.68e-16 | NR | MFL5735492.1 | 2448782 | g32060 | i0 | 76.1 | 1.9 | 46 | 11 | 92 | 0 | 139 | 2 | 269 | 314 | MFL5735492.1 S8 family serine peptidase [Chloroflexia bacterium] | diamond | 285 | 80.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 26884686 | 26884686 | PRJNA315314_S_NODE_5381_length_346_cov_3.198738_g5060_i0 | PRJNA315314 | 5381 | 346 | 3.198738 | 11.06763348 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 152 | 3.88e-44 | NR | HNC91688.1 | 2073117 | g5060 | i0 | 73.9 | 0.997109826589595 | 115 | 22 | 99.7 | 1 | 346 | 2 | 13 | 119 | HNC91688.1 hypothetical protein [Anaerolineales bacterium] | diamond | 345 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 27408132 | 27408132 | PRJNA315314_S_NODE_14883_length_212_cov_2.032787_g14562_i0 | PRJNA315314 | 14883 | 212 | 2.032787 | 4.30950844 | Bacillati | 1783272 | Bacteria | Bacteria | 42.7 | 0.0248 | NR | HEU0295538.1 | 2073117 | g14562 | i0 | 40.4 | 1.65566037735849 | 57 | 33 | 80.7 | 1 | 198 | 28 | 278 | 333 | HEU0295538.1 efflux RND transporter periplasmic adaptor subunit [Anaerolineales bacterium] | diamond | 351 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28558839 | 28558839 | PRJNA315314_S_NODE_23587_length_172_cov_1.755245_g23266_i0 | PRJNA315314 | 23587 | 172 | 1.755245 | 3.0190214 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 80.5 | 5.02e-16 | NR | HEX9797167.1 | 2073117 | g23266 | i0 | 66.7 | 8.94767441860465 | 57 | 19 | 99.4 | 0 | 172 | 2 | 264 | 320 | HEX9797167.1 UDP-N-acetylglucosamine 2-epimerase (non-hydrolyzing) [Anaerolineales bacterium] | diamond | 1539 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28590383 | 28590383 | PRJNA315314_S_NODE_17347_length_197_cov_9.720238_g17026_i0 | PRJNA315314 | 17347 | 197 | 9.720238 | 19.14886886 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 40.8 | 0.0407 | NR | MBM3189776.1 | 2026724 | g17026 | i0 | 45 | 0.609137055837564 | 40 | 22 | 60.9 | 0 | 35 | 154 | 10 | 49 | MBM3189776.1 DUF454 domain-containing protein [Chloroflexota bacterium] | diamond | 120 | 40.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29001048 | 29001048 | PRJNA315314_S_NODE_21488_length_179_cov_2.106667_g21167_i0 | PRJNA315314 | 21488 | 179 | 2.106667 | 3.77093393 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 76.6 | 1.76e-14 | NR | HSJ88362.1 | 2073117 | g21167 | i0 | 62.7 | 1.97765363128492 | 59 | 22 | 98.9 | 0 | 177 | 1 | 364 | 422 | HSJ88362.1 S8 family serine peptidase [Anaerolineales bacterium] | diamond | 354 | 76.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29853258 | 29853258 | PRJNA315314_S_NODE_13511_length_222_cov_1.953368_g13190_i0 | PRJNA315314 | 13511 | 222 | 1.953368 | 4.33647696 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 64.7 | 5.12e-10 | NR | MFC2036027.1 | 2026724 | g13190 | i0 | 60 | 0.540540540540541 | 40 | 16 | 54.1 | 0 | 170 | 51 | 359 | 398 | MFC2036027.1 MauE/DoxX family redox-associated membrane protein [Chloroflexota bacterium] | diamond | 120 | 64.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29884944 | 29884944 | PRJNA315314_S_NODE_13531_length_222_cov_1.424870_g13210_i0 | PRJNA315314 | 13531 | 222 | 1.42487 | 3.1632114 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 70.5 | 2.9e-12 | NR | GIK74415.1 | 2026724 | g13210 | i0 | 46.6 | 0.986486486486487 | 73 | 35 | 98.6 | 1 | 221 | 3 | 154 | 222 | GIK74415.1 MAG: hypothetical protein BroJett021_34030 [Chloroflexota bacterium] | diamond | 219 | 70.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29965560 | 29965560 | PRJNA315314_S_NODE_21211_length_180_cov_1.940397_g20890_i0 | PRJNA315314 | 21211 | 180 | 1.940397 | 3.4927146 | Bacteria | 2 | Bacteria | Bacteria | 70.5 | 4.5e-13 | NR | NTV35470.1 | 2024896 | g20890 | i0 | 66 | 3.65 | 50 | 15 | 83.3 | 1 | 31 | 180 | 64 | 111 | NTV35470.1 SET domain-containing protein-lysine N-methyltransferase [Anaerolineaceae bacterium] | diamond | 657 | 71.2 | 0.990168539325843 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 31197275 | 31197275 | PRJNA315314_S_NODE_4035_length_398_cov_3.327913_g3714_i0 | PRJNA315314 | 4035 | 398 | 3.327913 | 13.24509374 | Bacillati | 1783272 | Bacteria | Bacteria | 94.7 | 1.41e-19 | NR | MCA9938168.1 | 2073117 | g3714 | i0 | 47.8 | 3.01507537688442 | 134 | 62 | 99.5 | 6 | 398 | 3 | 893 | 1020 | MCA9938168.1 tandem-95 repeat protein [Anaerolineales bacterium] | diamond | 1200 | 95.1 | 0.995793901156677 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31465061 | 31465061 | PRJNA315314_S_NODE_31116_length_153_cov_1.112903_g30795_i0 | PRJNA315314 | 31116 | 153 | 1.112903 | 1.70274159 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.7 | 0.00225 | NR | MDB5079371.1 | 2026724 | g30795 | i0 | 52.1 | 1.92156862745098 | 48 | 23 | 94.1 | 0 | 145 | 2 | 382 | 429 | MDB5079371.1 metE [Chloroflexota bacterium] | diamond | 294 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31830071 | 31830071 | PRJNA315314_S_NODE_31897_length_151_cov_2.385246_g31576_i0 | PRJNA315314 | 31897 | 151 | 2.385246 | 3.60172146 | Bacillati | 1783272 | Bacteria | Bacteria | 65.1 | 1.39e-10 | NR | MBE2222355.1 | 2052143 | g31576 | i0 | 59.2 | 3.85430463576159 | 49 | 20 | 97.4 | 0 | 4 | 150 | 1518 | 1566 | MBE2222355.1 type I polyketide synthase [Anaerolineae bacterium] | diamond | 582 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31844233 | 31844233 | PRJNA315314_S_NODE_10777_length_247_cov_2.114679_g10456_i0 | PRJNA315314 | 10777 | 247 | 2.114679 | 5.22325713 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 53.1 | 2.94e-6 | NR | NOH03458.1 | 2026724 | g10456 | i0 | 48.9 | 1.10526315789474 | 45 | 23 | 54.7 | 0 | 157 | 23 | 5 | 49 | NOH03458.1 SET domain-containing protein-lysine N-methyltransferase [Chloroflexota bacterium] | diamond | 273 | 53.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32729581 | 32729581 | PRJNA315314_S_NODE_31080_length_153_cov_1.419355_g30759_i0 | PRJNA315314 | 31080 | 153 | 1.419355 | 2.17161315 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 67 | 2.92e-11 | NR | HWS23319.1 | 2073117 | g30759 | i0 | 56 | 7.84313725490196 | 50 | 22 | 98 | 0 | 151 | 2 | 35 | 84 | HWS23319.1 penicillin acylase family protein [Anaerolineales bacterium] | diamond | 1200 | 67 | 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);;