contig_metadata
26 rows where bioproject = "PRJNA1255065", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 360204 | 360204 | PRJNA1255065_P_NODE_27301_length_496_cov_1.315436_g25104_i0 | PRJNA1255065 | 27301 | 496 | 1.315436 | 6.52456256 | Leptolinea sp. HRD-7 | 2830982 | Bacteria | Bacteria | 496 | 1.86e-135 | NTclustered | gi|2250018340|dbj|AP024710.1| | 2830982 | g25104 | i0 | 84.959 | 243.332661290323 | 492 | 71 | 99 | 3 | 5 | 496 | 1245426 | 1245914 | Leptolinea sp. HRD-7 DNA, complete genome | blastn | 120693 | 496 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Leptolinea | Leptolinea sp. HRD-7 | ||
| 5463886 | 5463886 | PRJNA1255065_P_NODE_74265_length_211_cov_0.938272_g72037_i0 | PRJNA1255065 | 74265 | 211 | 0.938272 | 1.97975392 | Candidatus Chlorohelix allophototropha | 3003348 | Bacteria | Bacteria | 206 | 1.34e-48 | NTclustered | gi|2530750984|gb|CP128400.1| | 3003348 | g72037 | i0 | 90.385 | 653.748815165877 | 156 | 15 | 74 | 0 | 56 | 211 | 319916 | 319761 | Candidatus Chlorohelix allophototropha isolate L227-S17 chromosome 2, complete sequence | blastn | 137941 | 206 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Chloroheliales | Candidatus Chloroheliaceae | Candidatus Chlorohelix | Candidatus Chlorohelix allophototropha | ||
| 11838722 | 11838722 | PRJNA1255065_P_NODE_142170_length_163_cov_0.912281_g139942_i0 | PRJNA1255065 | 142170 | 163 | 0.912281 | 1.48701803 | Tepidiforma flava | 3004094 | Bacteria | Bacteria | 291 | 2.64e-74 | NTclustered | gi|2421951025|gb|CP115149.1| | 3004094 | g139942 | i0 | 98.773 | 2.00613496932515 | 163 | 2 | 100 | 0 | 1 | 163 | 1721268 | 1721106 | Tepidiforma flava strain YIM 72310 chromosome, complete genome | blastn | 327 | 291 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiforma | Tepidiforma flava | ||
| 16937097 | 16937097 | PRJNA1255065_P_NODE_112734_length_168_cov_0.873950_g110506_i0 | PRJNA1255065 | 112734 | 168 | 0.87395 | 1.468236 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 76.3 | 2.11e-14 | NR | HLB49915.1 | 2073117 | g110506 | i0 | 67.9 | 3.98214285714286 | 56 | 17 | 100 | 1 | 168 | 1 | 137 | 191 | HLB49915.1 serine/threonine-protein kinase [Anaerolineales bacterium] | diamond | 669 | 76.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 18212125 | 18212125 | PRJNA1255065_P_NODE_48435_length_298_cov_2.811245_g46209_i0 | PRJNA1255065 | 48435 | 298 | 2.811245 | 8.3775101 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 213 | 1.2e-50 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g46209 | i0 | 82.031 | 65.7080536912752 | 256 | 41 | 86 | 5 | 2 | 256 | 3494978 | 3494727 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 19581 | 213 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 19486039 | 19486039 | PRJNA1255065_P_NODE_130316_length_165_cov_0.896552_g128088_i0 | PRJNA1255065 | 130316 | 165 | 0.896552 | 1.4793108 | Herpetosiphon aurantiacus | 65 | Bacteria | Bacteria | 281 | 1.62e-71 | NTclustered | gi|159889572|gb|CP000875.1| | 316274 | g128088 | i0 | 97.576 | 1 | 165 | 3 | 100 | 1 | 1 | 165 | 171203 | 171040 | Herpetosiphon aurantiacus DSM 785, complete genome | blastn | 165 | 281 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 22036975 | 22036975 | PRJNA1255065_P_NODE_23738_length_550_cov_1.770459_g21580_i0 | PRJNA1255065 | 23738 | 550 | 1.770459 | 9.7375245 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 412 | 2.1599999999999993e-110 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g21580 | i0 | 80.541 | 61.7781818181818 | 555 | 93 | 100 | 13 | 1 | 550 | 3496080 | 3495536 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 33978 | 412 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 22037250 | 22037250 | PRJNA1255065_P_NODE_74218_length_211_cov_0.962963_g71990_i0 | PRJNA1255065 | 74218 | 211 | 0.962963 | 2.03185193 | Herpetosiphon aurantiacus | 65 | Bacteria | Bacteria | 150 | 6.389999999999998e-32 | NTclustered | gi|159889572|gb|CP000875.1| | 316274 | g71990 | i0 | 88.189 | 0.601895734597156 | 127 | 14 | 60 | 1 | 1 | 127 | 4626761 | 4626886 | Herpetosiphon aurantiacus DSM 785, complete genome | blastn | 127 | 150 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon aurantiacus | ||
| 23312410 | 23312410 | PRJNA1255065_P_NODE_151319_length_162_cov_0.920354_g149091_i0 | PRJNA1255065 | 151319 | 162 | 0.920354 | 1.49097348 | Tepidiforma flava | 3004094 | Bacteria | Bacteria | 261 | 2.06e-65 | NTclustered | gi|2421951025|gb|CP115149.1| | 3004094 | g149091 | i0 | 95.679 | 1.99382716049383 | 162 | 7 | 100 | 0 | 1 | 162 | 619362 | 619523 | Tepidiforma flava strain YIM 72310 chromosome, complete genome | blastn | 323 | 261 | 1 | Bacteria | Bacillati | Chloroflexota | Tepidiformia | Tepidiformales | Tepidiformaceae | Tepidiforma | Tepidiforma flava | ||
| 27421710 | 27421710 | PRJNA1255065_P_NODE_87703_length_189_cov_1.457143_g85475_i0 | PRJNA1255065 | 87703 | 189 | 1.457143 | 2.75400027 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0482 | NR | NBD36308.1 | 2026724 | g85475 | i0 | 46.9 | 0.777777777777778 | 49 | 22 | 73 | 2 | 34 | 171 | 247 | 294 | NBD36308.1 sulfatase-like hydrolase/transferase [Chloroflexota bacterium] | diamond | 147 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28526762 | 28526762 | PRJNA1255065_P_NODE_108007_length_169_cov_0.866667_g105779_i0 | PRJNA1255065 | 108007 | 169 | 0.866667 | 1.46466723 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 97.8 | 5.42e-24 | NR | HEX7225414.1 | 3047546 | g105779 | i0 | 85.7 | 0.994082840236686 | 56 | 8 | 99.4 | 0 | 168 | 1 | 6 | 61 | HEX7225414.1 1,2-phenylacetyl-CoA epoxidase subunit PaaD [Candidatus Limnocylindria bacterium] | diamond | 168 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28558268 | 28558268 | PRJNA1255065_P_NODE_114907_length_168_cov_0.873950_g112679_i0 | PRJNA1255065 | 114907 | 168 | 0.87395 | 1.468236 | Kouleothrix aurantiaca | 186479 | Bacteria | Bacteria | 97.8 | 9.02e-25 | NR | KPV54955.1 | 186479 | g112679 | i0 | 83.6 | 1.96428571428571 | 55 | 9 | 98.2 | 0 | 3 | 167 | 44 | 98 | KPV54955.1 TrmB family transcriptional regulator [Kouleothrix aurantiaca] | diamond | 330 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix aurantiaca | ||
| 28684610 | 28684610 | PRJNA1255065_P_NODE_132947_length_165_cov_0.896552_g130719_i0 | PRJNA1255065 | 132947 | 165 | 0.896552 | 1.4793108 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 60.1 | 1.26e-9 | NR | CAA9253207.1 | 1672391 | g130719 | i0 | 78.1 | 1.70909090909091 | 32 | 7 | 58.2 | 0 | 164 | 69 | 106 | 137 | CAA9253207.1 MAG: hypothetical protein AVDCRST_MAG26-1983 [uncultured Chloroflexia bacterium] | diamond | 282 | 60.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 28873828 | 28873828 | PRJNA1255065_P_NODE_152428_length_162_cov_0.920354_g150200_i0 | PRJNA1255065 | 152428 | 162 | 0.920354 | 1.49097348 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 52.4 | 5.7e-7 | NR | MBX3030490.1 | 2026724 | g150200 | i0 | 85.2 | 0.5 | 27 | 4 | 50 | 0 | 74 | 154 | 1 | 27 | MBX3030490.1 muconolactone Delta-isomerase family protein [Chloroflexota bacterium] | diamond | 81 | 52.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29095015 | 29095015 | PRJNA1255065_P_NODE_120548_length_167_cov_0.881356_g118320_i0 | PRJNA1255065 | 120548 | 167 | 0.881356 | 1.47186452 | Caldilinea sp. | 2293560 | Bacteria | Bacteria | 42.4 | 0.0169 | NR | WP_343402749.1 | 2293560 | g118320 | i0 | 90.5 | 0.754491017964072 | 21 | 2 | 37.7 | 0 | 1 | 63 | 213 | 233 | WP_343402749.1 transposase [Caldilinea sp.] | diamond | 126 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. | ||
| 29189759 | 29189759 | PRJNA1255065_P_NODE_114049_length_168_cov_0.873950_g111821_i0 | PRJNA1255065 | 114049 | 168 | 0.87395 | 1.468236 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 76.3 | 2.05e-14 | NR | MEI7469034.1 | 2026724 | g111821 | i0 | 61.8 | 3.94642857142857 | 55 | 21 | 98.2 | 0 | 168 | 4 | 376 | 430 | MEI7469034.1 nucleotide sugar dehydrogenase [Chloroflexota bacterium] | diamond | 663 | 76.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29252507 | 29252507 | PRJNA1255065_P_NODE_112089_length_168_cov_0.873950_g109861_i0 | PRJNA1255065 | 112089 | 168 | 0.87395 | 1.468236 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 44.7 | 0.00192 | NR | MDQ5852393.1 | 2026724 | g109861 | i0 | 54.5 | 0.589285714285714 | 33 | 15 | 58.9 | 0 | 2 | 100 | 47 | 79 | MDQ5852393.1 hypothetical protein [Chloroflexota bacterium] | diamond | 99 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29662847 | 29662847 | PRJNA1255065_P_NODE_68490_length_223_cov_0.977011_g66262_i0 | PRJNA1255065 | 68490 | 223 | 0.977011 | 2.17873453 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 42.4 | 0.0277 | NR | MCK6565124.1 | 2026734 | g66262 | i0 | 35.6 | 0.79372197309417 | 59 | 36 | 79.4 | 1 | 45 | 221 | 82 | 138 | MCK6565124.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 177 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30199974 | 30199974 | PRJNA1255065_P_NODE_119112_length_167_cov_0.881356_g116884_i0 | PRJNA1255065 | 119112 | 167 | 0.881356 | 1.47186452 | Anaerolinea sp. | 1872519 | Bacteria | Bacteria | 121 | 1.76e-33 | NR | MBA3876484.1 | 1872519 | g116884 | i0 | 100 | 0.988023952095808 | 55 | 0 | 98.8 | 0 | 1 | 165 | 62 | 116 | MBA3876484.1 hypothetical protein [Anaerolinea sp.] | diamond | 165 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 30516133 | 30516133 | PRJNA1255065_P_NODE_132993_length_165_cov_0.896552_g130765_i0 | PRJNA1255065 | 132993 | 165 | 0.896552 | 1.4793108 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 106 | 9.69e-28 | NR | PWH17381.1 | 2052143 | g130765 | i0 | 92.6 | 0.981818181818182 | 54 | 4 | 98.2 | 0 | 2 | 163 | 9 | 62 | PWH17381.1 MAG: methylglyoxal synthase [Anaerolineae bacterium] | diamond | 162 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30768995 | 30768995 | PRJNA1255065_P_NODE_118214_length_167_cov_0.881356_g115986_i0 | PRJNA1255065 | 118214 | 167 | 0.881356 | 1.47186452 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 85.9 | 6.7e-18 | NR | HUP26095.1 | 2952938 | g115986 | i0 | 74.5 | 0.988023952095808 | 55 | 14 | 98.8 | 0 | 166 | 2 | 269 | 323 | HUP26095.1 cell division FtsA domain-containing protein [Candidatus Limnocylindrales bacterium] | diamond | 165 | 85.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31053549 | 31053549 | PRJNA1255065_P_NODE_146595_length_163_cov_0.912281_g144367_i0 | PRJNA1255065 | 146595 | 163 | 0.912281 | 1.48701803 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 95.9 | 1.33e-21 | NR | MFL5725478.1 | 2026724 | g144367 | i0 | 80.8 | 0.957055214723926 | 52 | 10 | 95.7 | 0 | 6 | 161 | 100 | 151 | MFL5725478.1 AAA family ATPase [Chloroflexota bacterium] | diamond | 156 | 95.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31369639 | 31369639 | PRJNA1255065_P_NODE_152376_length_162_cov_0.920354_g150148_i0 | PRJNA1255065 | 152376 | 162 | 0.920354 | 1.49097348 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 59.3 | 1.72e-8 | NR | MEO5704103.1 | 2952938 | g150148 | i0 | 71.1 | 1.66666666666667 | 45 | 13 | 83.3 | 0 | 160 | 26 | 311 | 355 | MEO5704103.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatB [Candidatus Limnocylindrales bacterium] | diamond | 270 | 59.3 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 31717306 | 31717306 | PRJNA1255065_P_NODE_113037_length_168_cov_0.873950_g110809_i0 | PRJNA1255065 | 113037 | 168 | 0.87395 | 1.468236 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 63.5 | 6.3e-10 | NR | MCW1970324.1 | 2052143 | g110809 | i0 | 38 | 2.78571428571429 | 100 | 13 | 91.1 | 1 | 16 | 168 | 279 | 378 | MCW1970324.1 hypothetical protein [Anaerolineae bacterium] | diamond | 468 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32476803 | 32476803 | PRJNA1255065_P_NODE_113399_length_168_cov_0.873950_g111171_i0 | PRJNA1255065 | 113399 | 168 | 0.87395 | 1.468236 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 80.1 | 7.31e-16 | NR | NJM42298.1 | 2052143 | g111171 | i0 | 74.1 | 1.94642857142857 | 54 | 14 | 96.4 | 0 | 3 | 164 | 293 | 346 | NJM42298.1 hypothetical protein [Anaerolineae bacterium] | diamond | 327 | 80.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 32540164 | 32540164 | PRJNA1255065_P_NODE_139139_length_164_cov_0.904348_g136911_i0 | PRJNA1255065 | 139139 | 164 | 0.904348 | 1.48313072 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 125 | 9.18e-33 | NR | MEZ4728420.1 | 2614250 | g136911 | i0 | 96.3 | 0.98780487804878 | 54 | 2 | 98.8 | 0 | 162 | 1 | 80 | 133 | MEZ4728420.1 rhomboid family intramembrane serine protease [Caldilineaceae bacterium] | diamond | 162 | 125 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae 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);;