contig_metadata
20 rows where bioproject = "PRJNA414225" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15110794 | 15110794 | PRJNA414225_P_NODE_1772_length_322_cov_2.054945_g1685_i0 | PRJNA414225 | 1772 | 322 | 2.054945 | 6.6169229 | Caldilinea | 233191 | Bacteria | Bacteria | 425 | 1.55e-114 | NTclustered | gi|470476010|ref|NR_076314.1| | 133453 | g1685 | i0 | 90.462 | 293.742236024845 | 325 | 27 | 99 | 3 | 2 | 322 | 537 | 861 | Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence | blastn | 94585 | 425 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea aerophila | ||
| 27012224 | 27012224 | PRJNA414225_P_NODE_60802_length_166_cov_0.871795_g60715_i0 | PRJNA414225 | 60802 | 166 | 0.871795 | 1.4471797 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 102 | 2.59e-24 | NR | HEX9132357.1 | 2740538 | g60715 | i0 | 86.8 | 0.957831325301205 | 53 | 7 | 95.8 | 0 | 159 | 1 | 225 | 277 | HEX9132357.1 RRXRR domain-containing protein [Ktedonobacteraceae bacterium] | diamond | 159 | 102 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 27296837 | 27296837 | PRJNA414225_P_NODE_23883_length_184_cov_1.511111_g23796_i0 | PRJNA414225 | 23883 | 184 | 1.511111 | 2.78044424 | Thermogemmatispora sp. | 1968838 | Bacteria | Bacteria | 117 | 7.319999999999999e-31 | NR | WP_376793978.1 | 1968838 | g23796 | i0 | 100 | 0.864130434782609 | 53 | 0 | 86.4 | 0 | 25 | 183 | 1 | 53 | WP_376793978.1 DUF6683 family protein [Thermogemmatispora sp.] | diamond | 159 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Thermogemmatisporales | Thermogemmatisporaceae | Thermogemmatispora | Thermogemmatispora sp. | ||
| 27724390 | 27724390 | PRJNA414225_P_NODE_79084_length_163_cov_0.894737_g78997_i0 | PRJNA414225 | 79084 | 163 | 0.894737 | 1.45842131 | FCB group | 1783270 | Bacteria | Bacteria | 99 | 1.5000000000000002e-22 | NR | MEE8385708.1 | 2026734 | g78997 | i0 | 85.2 | 3.95705521472393 | 54 | 8 | 99.4 | 0 | 2 | 163 | 146 | 199 | MEE8385708.1 adenylosuccinate lyase [Dehalococcoidia bacterium] | diamond | 645 | 100 | 0.99 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 27770740 | 27770740 | PRJNA414225_P_NODE_69744_length_164_cov_1.434783_g69657_i0 | PRJNA414225 | 69744 | 164 | 1.434783 | 2.35304412 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 57.4 | 2.8e-9 | NR | RPJ58302.1 | 2026734 | g69657 | i0 | 60 | 1.70121951219512 | 45 | 18 | 82.3 | 0 | 135 | 1 | 8 | 52 | RPJ58302.1 MAG: hypothetical protein EHM12_08060 [Dehalococcoidia bacterium] | diamond | 279 | 57.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28212312 | 28212312 | PRJNA414225_P_NODE_52166_length_167_cov_0.864407_g52079_i0 | PRJNA414225 | 52166 | 167 | 0.864407 | 1.44355969 | Caldilinea sp. CFX5 | 2293554 | Bacteria | Bacteria | 88.6 | 9.42e-19 | NR | MCE7988308.1 | 2293554 | g52079 | i0 | 83.6 | 0.988023952095808 | 55 | 9 | 98.8 | 0 | 167 | 3 | 953 | 1007 | MCE7988308.1 AAA family ATPase [Caldilinea sp. CFX5] | diamond | 165 | 88.6 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. CFX5 | ||
| 28387020 | 28387020 | PRJNA414225_P_NODE_3086_length_271_cov_0.918919_g2999_i0 | PRJNA414225 | 3086 | 271 | 0.918919 | 2.49027049 | Bacteria | 2 | Bacteria | Bacteria | 76.3 | 5.1e-14 | NR | HWO94204.1 | 2026734 | g2999 | i0 | 77.6 | 1.08487084870849 | 49 | 11 | 54.2 | 0 | 269 | 123 | 73 | 121 | HWO94204.1 DEAD/DEAH box helicase [Dehalococcoidia bacterium] | diamond | 294 | 77 | 0.990909090909091 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28717843 | 28717843 | PRJNA414225_P_NODE_70407_length_164_cov_0.886957_g70320_i0 | PRJNA414225 | 70407 | 164 | 0.886957 | 1.45460948 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 53.1 | 1.87e-6 | NR | MDP9311762.1 | 2026724 | g70320 | i0 | 49 | 1.73780487804878 | 49 | 24 | 89.6 | 1 | 3 | 149 | 74 | 121 | MDP9311762.1 YwqG family protein [Chloroflexota bacterium] | diamond | 285 | 53.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28780732 | 28780732 | PRJNA414225_P_NODE_50447_length_167_cov_0.864407_g50360_i0 | PRJNA414225 | 50447 | 167 | 0.864407 | 1.44355969 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 80.5 | 2.84e-18 | NR | HWP29984.1 | 2026724 | g50360 | i0 | 100 | 0.736526946107784 | 41 | 0 | 73.7 | 0 | 45 | 167 | 1 | 41 | HWP29984.1 heavy-metal-associated domain-containing protein [Chloroflexota bacterium] | diamond | 123 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28955645 | 28955645 | PRJNA414225_P_NODE_81768_length_163_cov_0.894737_g81681_i0 | PRJNA414225 | 81768 | 163 | 0.894737 | 1.45842131 | Bacteria | 2 | Bacteria | Bacteria | 84 | 9.66e-18 | NR | MDP9363947.1 | 2026724 | g81681 | i0 | 78.8 | 1.93251533742331 | 52 | 11 | 95.7 | 0 | 158 | 3 | 111 | 162 | MDP9363947.1 FAD-binding oxidoreductase [Chloroflexota bacterium] | diamond | 315 | 84.3 | 0.99644128113879 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29128458 | 29128458 | PRJNA414225_P_NODE_51249_length_167_cov_0.864407_g51162_i0 | PRJNA414225 | 51249 | 167 | 0.864407 | 1.44355969 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 108 | 5.59e-27 | NR | HZY41916.1 | 2052143 | g51162 | i0 | 90.9 | 0.988023952095808 | 55 | 5 | 98.8 | 0 | 165 | 1 | 50 | 104 | HZY41916.1 glycerophosphodiester phosphodiesterase [Anaerolineae bacterium] | diamond | 165 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29727836 | 29727836 | PRJNA414225_P_NODE_31950_length_177_cov_1.593750_g31863_i0 | PRJNA414225 | 31950 | 177 | 1.59375 | 2.8209375 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 51.6 | 8.73e-6 | NR | HET8841558.1 | 2740538 | g31863 | i0 | 68.6 | 1.71186440677966 | 35 | 11 | 59.3 | 0 | 1 | 105 | 198 | 232 | HET8841558.1 substrate-binding domain-containing protein [Ktedonobacteraceae bacterium] | diamond | 303 | 51.6 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 29886171 | 29886171 | PRJNA414225_P_NODE_47331_length_167_cov_1.542373_g47244_i0 | PRJNA414225 | 47331 | 167 | 1.542373 | 2.57576291 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 103 | 5.44e-24 | NR | MCK6628735.1 | 2052143 | g47244 | i0 | 81.8 | 4.92215568862275 | 55 | 10 | 98.8 | 0 | 167 | 3 | 189 | 243 | MCK6628735.1 type I restriction-modification system subunit M [Anaerolineae bacterium] | diamond | 822 | 103 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31040331 | 31040331 | PRJNA414225_P_NODE_4455_length_249_cov_1.305000_g4368_i0 | PRJNA414225 | 4455 | 249 | 1.305 | 3.24945 | Bacillati | 1783272 | Bacteria | Bacteria | 111 | 6.12e-28 | NR | MDQ5827184.1 | 2026724 | g4368 | i0 | 83.9 | 3.72289156626506 | 62 | 10 | 74.7 | 0 | 1 | 186 | 208 | 269 | MDQ5827184.1 transposase [Chloroflexota bacterium] | diamond | 927 | 111 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31324471 | 31324471 | PRJNA414225_P_NODE_25255_length_183_cov_1.514925_g25168_i0 | PRJNA414225 | 25255 | 183 | 1.514925 | 2.77231275 | FCB group | 1783270 | Bacteria | Bacteria | 59.3 | 1.36e-8 | NR | WP_376788786.1 | 1969742 | g25168 | i0 | 68.2 | 1.49180327868852 | 44 | 14 | 72.1 | 0 | 48 | 179 | 110 | 153 | WP_376788786.1 molybdenum cofactor biosynthesis protein [Thermoflexus sp.] | diamond | 273 | 59.7 | 0.993299832495812 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexaceae | Thermoflexus | Thermoflexus sp. | ||
| 31561107 | 31561107 | PRJNA414225_P_NODE_50256_length_167_cov_0.864407_g50169_i0 | PRJNA414225 | 50256 | 167 | 0.864407 | 1.44355969 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 77.8 | 2.13e-16 | NR | MCJ7807532.1 | 2026734 | g50169 | i0 | 70.4 | 2.91017964071856 | 54 | 16 | 97 | 0 | 164 | 3 | 43 | 96 | MCJ7807532.1 ATP-binding domain-containing protein [Dehalococcoidia bacterium] | diamond | 486 | 77.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31750561 | 31750561 | PRJNA414225_P_NODE_63237_length_165_cov_0.879310_g63150_i0 | PRJNA414225 | 63237 | 165 | 0.87931 | 1.4508615 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 48.9 | 5.15e-5 | NR | MBI3974437.1 | 2026724 | g63150 | i0 | 70.6 | 1.58181818181818 | 34 | 10 | 61.8 | 0 | 152 | 51 | 25 | 58 | MBI3974437.1 thioredoxin family protein [Chloroflexota bacterium] | diamond | 261 | 48.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31813948 | 31813948 | PRJNA414225_P_NODE_39557_length_172_cov_1.658537_g39470_i0 | PRJNA414225 | 39557 | 172 | 1.658537 | 2.85268364 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 92.8 | 3.34e-20 | NR | MFL5800637.1 | 2762507 | g39470 | i0 | 80.7 | 3.97674418604651 | 57 | 11 | 99.4 | 0 | 172 | 2 | 730 | 786 | MFL5800637.1 carboxypeptidase regulatory-like domain-containing protein [Roseiflexaceae bacterium] | diamond | 684 | 92.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 31877057 | 31877057 | PRJNA414225_P_NODE_65197_length_165_cov_0.879310_g65110_i0 | PRJNA414225 | 65197 | 165 | 0.87931 | 1.4508615 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 43.1 | 0.00879 | NR | MBN1535229.1 | 2073117 | g65110 | i0 | 50 | 4.23636363636364 | 42 | 21 | 76.4 | 0 | 127 | 2 | 90 | 131 | MBN1535229.1 zinc ribbon domain-containing protein [Anaerolineales bacterium] | diamond | 699 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32715821 | 32715821 | PRJNA414225_P_NODE_70680_length_164_cov_0.886957_g70593_i0 | PRJNA414225 | 70680 | 164 | 0.886957 | 1.45460948 | FCB group | 1783270 | Bacteria | Bacteria | 55.8 | 3.02e-7 | NR | MCH7744830.1 | 2026724 | g70593 | i0 | 61.5 | 2.70731707317073 | 39 | 15 | 71.3 | 0 | 164 | 48 | 792 | 830 | MCH7744830.1 peptidase M14 [Chloroflexota bacterium] | diamond | 444 | 56.2 | 0.99288256227758 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;