contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1255065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 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);;