contig_metadata
22 rows where bioproject = "PRJNA217180", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26694053 | 26694053 | PRJNA217180_P_NODE_12561_length_167_cov_0.864407_g12461_i0 | PRJNA217180 | 12561 | 167 | 0.864407 | 1.44355969 | Candidatus Kouleothrix ribensis | 3140702 | Bacteria | Bacteria | 68.9 | 1.67e-13 | NR | MBK9944386.1 | 3140702 | g12461 | i0 | 59.3 | 0.970059880239521 | 54 | 22 | 97 | 0 | 162 | 1 | 2 | 55 | MBK9944386.1 hypothetical protein [Candidatus Kouleothrix ribensis] | diamond | 162 | 68.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Candidatus Kouleothrix ribensis | ||
| 27200192 | 27200192 | PRJNA217180_P_NODE_10202_length_185_cov_1.323529_g10102_i0 | PRJNA217180 | 10202 | 185 | 1.323529 | 2.44852865 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 46.2 | 0.00104 | NR | MFN8485324.1 | 2052143 | g10102 | i0 | 53.2 | 0.762162162162162 | 47 | 20 | 76.2 | 1 | 180 | 40 | 873 | 917 | MFN8485324.1 fibronectin type III domain-containing protein [Anaerolineae bacterium] | diamond | 141 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27421850 | 27421850 | PRJNA217180_P_NODE_12903_length_166_cov_0.871795_g12803_i0 | PRJNA217180 | 12903 | 166 | 0.871795 | 1.4471797 | Kouleothrix aurantiaca | 186479 | Bacteria | Bacteria | 94.4 | 2.5699999999999998e-23 | NR | KPV53389.1 | 186479 | g12803 | i0 | 83.6 | 0.993975903614458 | 55 | 9 | 99.4 | 0 | 166 | 2 | 39 | 93 | KPV53389.1 hypothetical protein SE17_09955 [Kouleothrix aurantiaca] | diamond | 165 | 94.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix aurantiaca | ||
| 27611185 | 27611185 | PRJNA217180_P_NODE_12704_length_167_cov_0.864407_g12604_i0 | PRJNA217180 | 12704 | 167 | 0.864407 | 1.44355969 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 51.2 | 8.63e-6 | NR | MBA2717737.1 | 2026724 | g12604 | i0 | 60 | 0.62874251497006 | 35 | 14 | 62.9 | 0 | 159 | 55 | 172 | 206 | MBA2717737.1 M15 family peptidase [Chloroflexota bacterium] | diamond | 105 | 51.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27642840 | 27642840 | PRJNA217180_P_NODE_12504_length_167_cov_0.864407_g12404_i0 | PRJNA217180 | 12504 | 167 | 0.864407 | 1.44355969 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 101 | 1.32e-24 | NR | HOU22808.1 | 2052143 | g12404 | i0 | 88.9 | 0.970059880239521 | 54 | 6 | 97 | 0 | 165 | 4 | 122 | 175 | HOU22808.1 hypothetical protein [Anaerolineae bacterium] | diamond | 162 | 101 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28463730 | 28463730 | PRJNA217180_P_NODE_9806_length_188_cov_1.316547_g9706_i0 | PRJNA217180 | 9806 | 188 | 1.316547 | 2.47510836 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 45.1 | 2.66e-4 | NR | MBV6436766.1 | 2052143 | g9706 | i0 | 57.6 | 0.526595744680851 | 33 | 14 | 52.7 | 0 | 185 | 87 | 2 | 34 | MBV6436766.1 hypothetical protein [Anaerolineae bacterium] | diamond | 99 | 45.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 28526919 | 28526919 | PRJNA217180_P_NODE_14127_length_164_cov_0.886957_g14027_i0 | PRJNA217180 | 14127 | 164 | 0.886957 | 1.45460948 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.00989 | NR | MBI1256571.1 | 2026724 | g14027 | i0 | 56.3 | 0.585365853658537 | 32 | 14 | 58.5 | 0 | 96 | 1 | 45 | 76 | MBI1256571.1 hypothetical protein [Chloroflexota bacterium] | diamond | 96 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29126881 | 29126881 | PRJNA217180_P_NODE_13969_length_164_cov_0.886957_g13869_i0 | PRJNA217180 | 13969 | 164 | 0.886957 | 1.45460948 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 49.7 | 3.18e-6 | NR | MBI5651743.1 | 2026724 | g13869 | i0 | 43.5 | 1.68292682926829 | 46 | 26 | 84.1 | 0 | 25 | 162 | 2 | 47 | MBI5651743.1 helix-turn-helix domain-containing protein [Chloroflexota bacterium] | diamond | 276 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29284292 | 29284292 | PRJNA217180_P_NODE_15409_length_161_cov_0.910714_g15309_i0 | PRJNA217180 | 15409 | 161 | 0.910714 | 1.46624954 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 63.2 | 7.55e-10 | NR | HUV26997.1 | 2073117 | g15309 | i0 | 52.8 | 0.987577639751553 | 53 | 25 | 98.8 | 0 | 2 | 160 | 269 | 321 | HUV26997.1 methyltransferase domain-containing protein [Anaerolineales bacterium] | diamond | 159 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 29442094 | 29442094 | PRJNA217180_P_NODE_14750_length_162_cov_0.902655_g14650_i0 | PRJNA217180 | 14750 | 162 | 0.902655 | 1.4623011 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 48.9 | 8.2e-5 | NR | MDD4985730.1 | 2026733 | g14650 | i0 | 43.8 | 0.888888888888889 | 48 | 27 | 88.9 | 0 | 9 | 152 | 759 | 806 | MDD4985730.1 IPT/TIG domain-containing protein [Dehalococcoidales bacterium] | diamond | 144 | 48.9 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 29757968 | 29757968 | PRJNA217180_P_NODE_14811_length_162_cov_0.902655_g14711_i0 | PRJNA217180 | 14811 | 162 | 0.902655 | 1.4623011 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 83.2 | 5.78e-17 | NR | MCC7371634.1 | 2026724 | g14711 | i0 | 83 | 0.981481481481482 | 53 | 9 | 98.1 | 0 | 2 | 160 | 227 | 279 | MCC7371634.1 phage major capsid protein [Chloroflexota bacterium] | diamond | 159 | 83.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29852910 | 29852910 | PRJNA217180_P_NODE_15091_length_162_cov_0.902655_g14991_i0 | PRJNA217180 | 15091 | 162 | 0.902655 | 1.4623011 | Candidatus Caldilinea saccharophila | 3140701 | Bacteria | Bacteria | 91.3 | 5.38e-22 | NR | MBK8800406.1 | 3140701 | g14991 | i0 | 80.8 | 0.962962962962963 | 52 | 10 | 96.3 | 0 | 157 | 2 | 50 | 101 | MBK8800406.1 hypothetical protein [Candidatus Caldilinea saccharophila] | diamond | 156 | 91.3 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Candidatus Caldilinea saccharophila | ||
| 30295556 | 30295556 | PRJNA217180_P_NODE_14852_length_162_cov_0.902655_g14752_i0 | PRJNA217180 | 14852 | 162 | 0.902655 | 1.4623011 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 42 | 0.0241 | NR | HXR66977.1 | 2740538 | g14752 | i0 | 46 | 0.925925925925926 | 50 | 26 | 90.7 | 1 | 10 | 156 | 315 | 364 | HXR66977.1 replicative DNA helicase [Ktedonobacteraceae bacterium] | diamond | 150 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 30691981 | 30691981 | PRJNA217180_P_NODE_15293_length_161_cov_0.910714_g15193_i0 | PRJNA217180 | 15293 | 161 | 0.910714 | 1.46624954 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.00258 | NR | HRA67426.1 | 2293560 | g15193 | i0 | 46.2 | 2.75776397515528 | 52 | 28 | 96.9 | 0 | 159 | 4 | 564 | 615 | HRA67426.1 tape measure protein [Caldilinea sp.] | diamond | 444 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. | ||
| 30958737 | 30958737 | PRJNA217180_P_NODE_14134_length_164_cov_0.886957_g14034_i0 | PRJNA217180 | 14134 | 164 | 0.886957 | 1.45460948 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 82 | 1.76e-16 | NR | HMN27944.1 | 2614250 | g14034 | i0 | 72.2 | 0.98780487804878 | 54 | 14 | 98.8 | 1 | 1 | 162 | 207 | 259 | HMN27944.1 phage/plasmid primase, P4 family [Caldilineaceae bacterium] | diamond | 162 | 82 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 31147803 | 31147803 | PRJNA217180_P_NODE_13315_length_165_cov_0.879310_g13215_i0 | PRJNA217180 | 13315 | 165 | 0.87931 | 1.4508615 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 47.4 | 2.32e-4 | NR | MDD5704270.1 | 2026733 | g13215 | i0 | 36.8 | 1.03636363636364 | 57 | 33 | 98.2 | 1 | 1 | 162 | 89 | 145 | MDD5704270.1 CHC2 zinc finger domain-containing protein [Dehalococcoidales bacterium] | diamond | 171 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 31210931 | 31210931 | PRJNA217180_P_NODE_14855_length_162_cov_0.902655_g14755_i0 | PRJNA217180 | 14855 | 162 | 0.902655 | 1.4623011 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 52 | 6.21e-6 | NR | HNH27053.1 | 2073117 | g14755 | i0 | 49 | 0.944444444444444 | 51 | 26 | 94.4 | 0 | 155 | 3 | 55 | 105 | HNH27053.1 DnaB-like helicase C-terminal domain-containing protein [Anaerolineales bacterium] | diamond | 153 | 52 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31527813 | 31527813 | PRJNA217180_P_NODE_14136_length_164_cov_0.886957_g14036_i0 | PRJNA217180 | 14136 | 164 | 0.886957 | 1.45460948 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 79.7 | 1.06e-15 | NR | MFN8565364.1 | 2052143 | g14036 | i0 | 71.7 | 0.969512195121951 | 53 | 15 | 97 | 0 | 160 | 2 | 39 | 91 | MFN8565364.1 hypothetical protein [Anaerolineae bacterium] | diamond | 159 | 79.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31622528 | 31622528 | PRJNA217180_P_NODE_13756_length_164_cov_1.391304_g13656_i0 | PRJNA217180 | 13756 | 164 | 1.391304 | 2.28173856 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 56.2 | 2.18e-7 | NR | MBP7687785.1 | 2497639 | g13656 | i0 | 88.5 | 0.475609756097561 | 26 | 3 | 47.6 | 0 | 1 | 78 | 374 | 399 | MBP7687785.1 hypothetical protein [Thermoflexales bacterium] | diamond | 78 | 56.2 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 32083197 | 32083197 | PRJNA217180_P_NODE_14138_length_164_cov_0.886957_g14038_i0 | PRJNA217180 | 14138 | 164 | 0.886957 | 1.45460948 | Bacillati | 1783272 | Bacteria | Bacteria | 68.9 | 1.69e-12 | NR | MEI6271679.1 | 2026724 | g14038 | i0 | 60 | 1.86585365853659 | 50 | 20 | 91.5 | 0 | 158 | 9 | 154 | 203 | MEI6271679.1 hypothetical protein [Chloroflexota bacterium] | diamond | 306 | 68.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32476986 | 32476986 | PRJNA217180_P_NODE_7859_length_211_cov_1.185185_g7759_i0 | PRJNA217180 | 7859 | 211 | 1.185185 | 2.50074035 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 77 | 1.52e-14 | NR | MFA5316205.1 | 2026733 | g7759 | i0 | 49.3 | 0.95260663507109 | 67 | 34 | 95.3 | 0 | 11 | 211 | 1 | 67 | MFA5316205.1 hypothetical protein [Dehalococcoidales bacterium] | diamond | 201 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 32823623 | 32823623 | PRJNA217180_P_NODE_13620_length_165_cov_0.879310_g13520_i0 | PRJNA217180 | 13620 | 165 | 0.87931 | 1.4508615 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 73.9 | 1.26e-13 | NR | MCO5189176.1 | 2052143 | g13520 | i0 | 66.7 | 0.981818181818182 | 54 | 18 | 98.2 | 0 | 164 | 3 | 435 | 488 | MCO5189176.1 hypothetical protein [Anaerolineae bacterium] | diamond | 162 | 73.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);;