contig_metadata
23 rows where bioproject = "PRJNA438572", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 434869 | 434869 | PRJNA438572_P_NODE_13441_length_283_cov_1.323810_g13322_i0 | PRJNA438572 | 13441 | 283 | 1.32381 | 3.7463823 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 152 | 2.4999999999999997e-32 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g13322 | i0 | 76.491 | 1.46643109540636 | 285 | 63 | 100 | 4 | 1 | 283 | 441211 | 440929 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 415 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 1709795 | 1709795 | PRJNA438572_P_NODE_14862_length_270_cov_1.187817_g14743_i0 | PRJNA438572 | 14862 | 270 | 1.187817 | 3.2071059 | Roseiflexus sp. RS-1 | 357808 | Bacteria | Bacteria | 167 | 8.47e-37 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g14743 | i0 | 79.231 | 9.2962962962963 | 260 | 38 | 94 | 13 | 16 | 270 | 1428 | 1180 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 2510 | 167 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 24042903 | 24042903 | PRJNA438572_P_NODE_3399_length_534_cov_2.696312_g3281_i0 | PRJNA438572 | 3399 | 534 | 2.696312 | 14.39830608 | Herpetosiphon | 64 | Bacteria | Bacteria | 412 | 2.0899999999999993e-110 | NTclustered | gi|470482680|ref|NR_076546.1| | 65 | g3281 | i0 | 81.765 | 251.790262172285 | 510 | 77 | 94 | 15 | 1 | 504 | 937 | 438 | Herpetosiphon aurantiacus strain DSM 785 23S ribosomal RNA gene, complete sequence | blastn | 134456 | 412 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 24661456 | 24661456 | PRJNA438572_P_NODE_7840_length_363_cov_1.058621_g7721_i0 | PRJNA438572 | 7840 | 363 | 1.058621 | 3.84279423 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 60.2 | 2.06e-4 | NTclustered | gi|2814788336|emb|OY760867.2| | 2026734 | g7721 | i0 | 97.143 | 0.575757575757576 | 35 | 1 | 10 | 0 | 125 | 159 | 3495592 | 3495558 | MAG: Dehalococcoidia bacterium isolate ec36dd00-29ce-491f-9a3f-6816ace52b4b genome assembly, chromosome: 1 | blastn | 209 | 60.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26854753 | 26854753 | PRJNA438572_P_NODE_5941_length_410_cov_1.620178_g5822_i0 | PRJNA438572 | 5941 | 410 | 1.620178 | 6.6427298 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 50.4 | 3.9e-4 | NR | MCC6387746.1 | 2026734 | g5822 | i0 | 34.7 | 1.16341463414634 | 75 | 49 | 54.9 | 0 | 362 | 138 | 161 | 235 | MCC6387746.1 SH3 domain-containing protein [Dehalococcoidia bacterium] | diamond | 477 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27044395 | 27044395 | PRJNA438572_P_NODE_22562_length_245_cov_0.877907_g22443_i0 | PRJNA438572 | 22562 | 245 | 0.877907 | 2.15087215 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 147 | 1.4e-40 | NR | MCC6458143.1 | 2614250 | g22443 | i0 | 91.1 | 2.91428571428571 | 79 | 7 | 96.7 | 0 | 3 | 239 | 22 | 100 | MCC6458143.1 amidohydrolase [Caldilineaceae bacterium] | diamond | 714 | 147 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 27075971 | 27075971 | PRJNA438572_P_NODE_18142_length_251_cov_0.876404_g18023_i0 | PRJNA438572 | 18142 | 251 | 0.876404 | 2.19977404 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 114 | 1.08e-27 | NR | RIK53353.1 | 2026724 | g18023 | i0 | 72.3 | 1.9601593625498 | 83 | 23 | 99.2 | 0 | 250 | 2 | 236 | 318 | RIK53353.1 MAG: two-component sensor histidine kinase [Chloroflexota bacterium] | diamond | 492 | 114 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27455419 | 27455419 | PRJNA438572_P_NODE_6823_length_385_cov_1.250000_g6704_i0 | PRJNA438572 | 6823 | 385 | 1.25 | 4.8125 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 45.1 | 0.0295 | NR | MAU10680.1 | 2024896 | g6704 | i0 | 41 | 0.646753246753247 | 83 | 43 | 64.7 | 2 | 352 | 104 | 3558 | 3634 | MAU10680.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 249 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27613252 | 27613252 | PRJNA438572_P_NODE_23904_length_243_cov_0.876471_g23785_i0 | PRJNA438572 | 23904 | 243 | 0.876471 | 2.12982453 | Litorilinea aerophila | 1204385 | Bacteria | Bacteria | 78.6 | 8.9e-15 | NR | WP_229964171.1 | 1204385 | g23785 | i0 | 57 | 4.87654320987654 | 79 | 34 | 97.5 | 0 | 238 | 2 | 565 | 643 | WP_229964171.1 MFS transporter [Litorilinea aerophila] | diamond | 1185 | 78.6 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Litorilinea | Litorilinea aerophila | ||
| 28212729 | 28212729 | PRJNA438572_P_NODE_21666_length_246_cov_0.901734_g21547_i0 | PRJNA438572 | 21666 | 246 | 0.901734 | 2.21826564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.1 | 3.11e-7 | NR | MEO8393802.1 | 2026724 | g21547 | i0 | 37.3 | 0.914634146341463 | 75 | 46 | 90.2 | 1 | 3 | 224 | 45 | 119 | MEO8393802.1 RDD family protein [Chloroflexota bacterium] | diamond | 225 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28402440 | 28402440 | PRJNA438572_P_NODE_23606_length_243_cov_0.917647_g23487_i0 | PRJNA438572 | 23606 | 243 | 0.917647 | 2.22988221 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.4 | 0.0483 | NR | MBA2631456.1 | 2026724 | g23487 | i0 | 37.7 | 0.753086419753086 | 61 | 32 | 72.8 | 2 | 199 | 23 | 63 | 119 | MBA2631456.1 hypothetical protein [Chloroflexota bacterium] | diamond | 183 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28497267 | 28497267 | PRJNA438572_P_NODE_23107_length_244_cov_0.912281_g22988_i0 | PRJNA438572 | 23107 | 244 | 0.912281 | 2.22596564 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 118 | 3.88e-29 | NR | MCB9137102.1 | 2614250 | g22988 | i0 | 74.3 | 0.860655737704918 | 70 | 18 | 86.1 | 0 | 2 | 211 | 401 | 470 | MCB9137102.1 fucose isomerase [Caldilineaceae bacterium] | diamond | 210 | 118 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28592000 | 28592000 | PRJNA438572_P_NODE_15587_length_263_cov_2.273684_g15468_i0 | PRJNA438572 | 15587 | 263 | 2.273684 | 5.97978892 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 42.7 | 0.0431 | NR | HEU5205436.1 | 2952938 | g15468 | i0 | 49.1 | 0.627376425855513 | 55 | 25 | 59.3 | 2 | 179 | 24 | 203 | 257 | HEU5205436.1 c-type cytochrome [Candidatus Limnocylindrales bacterium] | diamond | 165 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 29981274 | 29981274 | PRJNA438572_P_NODE_71_length_2160_cov_1.712027_g62_i0 | PRJNA438572 | 71 | 2160 | 1.712027 | 36.9797832 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 113 | 1.88e-21 | NR | MFA5379264.1 | 2026734 | g62 | i0 | 30.3 | 0.779166666666667 | 300 | 185 | 41 | 9 | 2037 | 1153 | 1558 | 1838 | MFA5379264.1 PKD domain-containing protein [Dehalococcoidia bacterium] | diamond | 1683 | 113 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30455480 | 30455480 | PRJNA438572_P_NODE_13913_length_279_cov_1.014563_g13794_i0 | PRJNA438572 | 13913 | 279 | 1.014563 | 2.83063077 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.8 | 0.00469 | NR | MDP9235829.1 | 2026724 | g13794 | i0 | 36.6 | 1 | 93 | 51 | 94.6 | 3 | 8 | 271 | 337 | 426 | MDP9235829.1 NHL repeat-containing protein [Chloroflexota bacterium] | diamond | 279 | 45.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30518334 | 30518334 | PRJNA438572_P_NODE_20293_length_248_cov_0.891429_g20174_i0 | PRJNA438572 | 20293 | 248 | 0.891429 | 2.21074392 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 103 | 4.0999999999999994e-24 | NR | HEX5942454.1 | 2073117 | g20174 | i0 | 89.5 | 0.689516129032258 | 57 | 6 | 69 | 0 | 78 | 248 | 149 | 205 | HEX5942454.1 GGDEF domain-containing protein [Anaerolineales bacterium] | diamond | 171 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30707853 | 30707853 | PRJNA438572_P_NODE_23294_length_243_cov_1.617647_g23175_i0 | PRJNA438572 | 23294 | 243 | 1.617647 | 3.93088221 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 70.9 | 4.62e-12 | NR | MBI4339085.1 | 2026724 | g23175 | i0 | 54.4 | 3.87654320987654 | 79 | 30 | 96.3 | 3 | 5 | 238 | 1183 | 1256 | MBI4339085.1 fibronectin type III domain-containing protein [Chloroflexota bacterium] | diamond | 942 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30787441 | 30787441 | PRJNA438572_P_NODE_12634_length_290_cov_1.474654_g12515_i0 | PRJNA438572 | 12634 | 290 | 1.474654 | 4.2764966 | Chloroflexota | 200795 | Bacteria | Bacteria | 52 | 9.8199999999999992e-06 | NR | MBA4181137.1 | 1872519 | g12515 | i0 | 84 | 1.81034482758621 | 25 | 4 | 25.9 | 0 | 289 | 215 | 125 | 149 | MBA4181137.1 nucleoside-diphosphate kinase [Anaerolinea sp.] | diamond | 525 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 31403368 | 31403368 | PRJNA438572_P_NODE_22016_length_245_cov_0.906977_g21897_i0 | PRJNA438572 | 22016 | 245 | 0.906977 | 2.22209365 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 130 | 5.66e-36 | NR | HEU5090624.1 | 2762507 | g21897 | i0 | 70.4 | 1.98367346938776 | 81 | 24 | 99.2 | 0 | 2 | 244 | 77 | 157 | HEU5090624.1 Rad52/Rad22 family DNA repair protein [Roseiflexaceae bacterium] | diamond | 486 | 130 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 31957172 | 31957172 | PRJNA438572_P_NODE_4237_length_477_cov_4.235149_g4119_i0 | PRJNA438572 | 4237 | 477 | 4.235149 | 20.20166073 | Bacteria | 2 | Bacteria | Bacteria | 98.2 | 9.01e-24 | NR | MEO0563457.1 | 2026724 | g4119 | i0 | 73.8 | 2.79245283018868 | 61 | 16 | 38.4 | 0 | 108 | 290 | 3 | 63 | MEO0563457.1 cold-shock protein [Chloroflexota bacterium] | diamond | 1332 | 98.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32652626 | 32652626 | PRJNA438572_P_NODE_23740_length_243_cov_0.917647_g23621_i0 | PRJNA438572 | 23740 | 243 | 0.917647 | 2.22988221 | Bacteria | 2 | Bacteria | Bacteria | 48.1 | 4.34e-4 | NR | HEX2696215.1 | 2073117 | g23621 | i0 | 38.8 | 2.34567901234568 | 80 | 42 | 98.8 | 2 | 241 | 2 | 178 | 250 | HEX2696215.1 Gfo/Idh/MocA family oxidoreductase [Anaerolineales bacterium] | diamond | 570 | 48.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32731237 | 32731237 | PRJNA438572_P_NODE_12240_length_294_cov_1.217195_g12121_i0 | PRJNA438572 | 12240 | 294 | 1.217195 | 3.5785533 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 44.7 | 0.0142 | NR | HEX9076739.1 | 2052143 | g12121 | i0 | 37.8 | 1.6734693877551 | 82 | 44 | 83.7 | 1 | 282 | 37 | 307 | 381 | HEX9076739.1 UDP-N-acetylmuramoyl-tripeptide--D-alanyl-D-alanine ligase [Anaerolineae bacterium] | diamond | 492 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32793873 | 32793873 | PRJNA438572_P_NODE_1640_length_746_cov_3.588410_g1536_i0 | PRJNA438572 | 1640 | 746 | 3.58841 | 26.7695386 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 80.9 | 2.54e-15 | NR | MCW5848612.1 | 2052143 | g1536 | i0 | 43.5 | 0.526809651474531 | 131 | 67 | 52.7 | 3 | 45 | 437 | 1 | 124 | MCW5848612.1 profilin [Anaerolineae bacterium] | diamond | 393 | 80.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae 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);;