contig_metadata
17 rows where bioproject = "PRJNA725806", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6298393 | 6298393 | PRJNA725806_P_NODE_12725_length_354_cov_5.113565_g12435_i0 | PRJNA725806 | 12725 | 354 | 5.113565 | 18.1020201 | Bacillati | 1783272 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|156231356|gb|CP000804.1| | 383372 | g12435 | i0 | 100 | 0.15819209039548 | 28 | 0 | 8 | 0 | 231 | 258 | 3946681 | 3946708 | Roseiflexus castenholzii DSM 13941, complete genome | blastn | 56 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus castenholzii | ||
| 12191254 | 12191254 | PRJNA725806_P_NODE_43510_length_259_cov_3.099099_g43213_i0 | PRJNA725806 | 43510 | 259 | 3.099099 | 8.02666641 | Leptolinea sp. HRD-7 | 2830982 | Bacteria | Bacteria | 52.8 | 0.024 | NTclustered | gi|2250018340|dbj|AP024710.1| | 2830982 | g43213 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 64 | 91 | 1563839 | 1563866 | Leptolinea sp. HRD-7 DNA, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Leptolinea | Leptolinea sp. HRD-7 | ||
| 13465610 | 13465610 | PRJNA725806_P_NODE_196331_length_150_cov_1.132743_g196029_i0 | PRJNA725806 | 196331 | 150 | 1.132743 | 1.6991145 | Ktedonobacteria bacterium brp13 | 2717365 | Bacteria | Bacteria | 200 | 4.119999999999999e-47 | NTclustered | gi|1915456248|dbj|AP024096.1| | 2717365 | g196029 | i0 | 92.254 | 19.48 | 142 | 10 | 95 | 1 | 9 | 150 | 792780 | 792640 | Ktedonobacteria bacterium brp13 DNA, complete genome | blastn | 2922 | 200 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacteria bacterium brp13 | |||||
| 18563453 | 18563453 | PRJNA725806_P_NODE_110995_length_190_cov_1.235294_g110693_i0 | PRJNA725806 | 110995 | 190 | 1.235294 | 2.3470586 | Thermosporothrix sp. COM3 | 2490863 | Bacteria | Bacteria | 261 | 2.49e-65 | NTclustered | gi|1606557374|dbj|AP019376.1| | 2490863 | g110693 | i0 | 93.714 | 229.863157894737 | 175 | 9 | 92 | 2 | 17 | 190 | 3565269 | 3565096 | Thermosporothrix sp. COM3 DNA, nearly complete genome | blastn | 43674 | 261 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Thermosporotrichaceae | Thermosporothrix | Thermosporothrix sp. COM3 | ||
| 23664840 | 23664840 | PRJNA725806_P_NODE_177379_length_157_cov_1.300000_g177077_i0 | PRJNA725806 | 177379 | 157 | 1.3 | 2.041 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 148 | 1.61e-31 | NTclustered | gi|2874253706|emb|OY969433.1| | 1672391 | g177077 | i0 | 85.034 | 8.47770700636943 | 147 | 21 | 93 | 1 | 1 | 146 | 1067519 | 1067373 | MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1 | blastn | 1331 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 27115294 | 27115294 | PRJNA725806_P_NODE_83542_length_210_cov_4.872832_g83241_i0 | PRJNA725806 | 83542 | 210 | 4.872832 | 10.2329472 | Dehalococcoidales bacterium | 2026733 | Bacteria | Bacteria | 42 | 0.0439 | NR | MDD5604764.1 | 2026733 | g83241 | i0 | 40.5 | 1.2 | 42 | 24 | 58.6 | 1 | 208 | 86 | 125 | 166 | MDD5604764.1 DHHW family protein [Dehalococcoidales bacterium] | diamond | 252 | 42 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidales bacterium | ||||
| 28073234 | 28073234 | PRJNA725806_P_NODE_69985_length_223_cov_4.301075_g69684_i0 | PRJNA725806 | 69985 | 223 | 4.301075 | 9.59139725 | FCB group | 1783270 | Bacteria | Bacteria | 40.4 | 0.0356 | NR | OLB40520.1 | 1805233 | g69684 | i0 | 55.9 | 0.874439461883408 | 34 | 15 | 45.7 | 0 | 85 | 186 | 42 | 75 | OLB40520.1 MAG: hypothetical protein AUH05_09460 [Ktedonobacter sp. 13_2_20CM_53_11] | diamond | 195 | 40.8 | 0.990196078431373 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacter | Ktedonobacter sp. 13_2_20CM_53_11 | ||
| 28347126 | 28347126 | PRJNA725806_P_NODE_169986_length_160_cov_1.243902_g169684_i0 | PRJNA725806 | 169986 | 160 | 1.243902 | 1.9902432 | Reticulibacter mediterranei | 2778369 | Bacteria | Bacteria | 84 | 3.12e-17 | NR | WP_220202994.1 | 2778369 | g169684 | i0 | 80 | 0.9375 | 50 | 10 | 93.8 | 0 | 3 | 152 | 410 | 459 | WP_220202994.1 FAD-binding oxidoreductase [Reticulibacter mediterranei] | diamond | 150 | 84 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Reticulibacteraceae | Reticulibacter | Reticulibacter mediterranei | ||
| 30526166 | 30526166 | PRJNA725806_P_NODE_51593_length_246_cov_3.751196_g51296_i0 | PRJNA725806 | 51593 | 246 | 3.751196 | 9.22794216 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 51.6 | 2.86e-5 | NR | HEX9014280.1 | 2024896 | g51296 | i0 | 95.8 | 0.878048780487805 | 24 | 1 | 29.3 | 0 | 229 | 158 | 111 | 134 | HEX9014280.1 6-phosphofructokinase [Anaerolineaceae bacterium] | diamond | 216 | 51.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 30810564 | 30810564 | PRJNA725806_P_NODE_190054_length_152_cov_2.034783_g189752_i0 | PRJNA725806 | 190054 | 152 | 2.034783 | 3.09287016 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.5 | 0.00583 | NR | MCP4541269.1 | 2026724 | g189752 | i0 | 47.4 | 0.75 | 38 | 20 | 75 | 0 | 125 | 12 | 1755 | 1792 | MCP4541269.1 hypothetical protein [Chloroflexota bacterium] | diamond | 114 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30905487 | 30905487 | PRJNA725806_P_NODE_58254_length_237_cov_3.255000_g57957_i0 | PRJNA725806 | 58254 | 237 | 3.255 | 7.71435 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 42.4 | 0.0298 | NR | MEE9277181.1 | 2026734 | g57957 | i0 | 33.3 | 0.721518987341772 | 57 | 38 | 72.2 | 0 | 229 | 59 | 26 | 82 | MEE9277181.1 CoA transferase [Dehalococcoidia bacterium] | diamond | 171 | 42.4 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31663986 | 31663986 | PRJNA725806_P_NODE_137237_length_175_cov_1.376812_g136935_i0 | PRJNA725806 | 137237 | 175 | 1.376812 | 2.409421 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 89.4 | 5.73e-19 | NR | MCI0578785.1 | 2026724 | g136935 | i0 | 71.9 | 1.95428571428571 | 57 | 16 | 97.7 | 0 | 5 | 175 | 118 | 174 | MCI0578785.1 hypothetical protein [Chloroflexota bacterium] | diamond | 342 | 89.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31706062 | 31706062 | PRJNA725806_P_NODE_101997_length_196_cov_1.773585_g101695_i0 | PRJNA725806 | 101997 | 196 | 1.773585 | 3.4762266 | Bacillati | 1783272 | Bacteria | Bacteria | 115 | 8.06e-30 | NR | MDP9366187.1 | 2026724 | g101695 | i0 | 92.2 | 1.95918367346939 | 64 | 5 | 98 | 0 | 195 | 4 | 122 | 185 | MDP9366187.1 ParA family protein [Chloroflexota bacterium] | diamond | 384 | 116 | 0.991379310344828 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31790442 | 31790442 | PRJNA725806_P_NODE_21177_length_313_cov_4.706522_g20881_i0 | PRJNA725806 | 21177 | 313 | 4.706522 | 14.73141386 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 42.7 | 0.0461 | NR | MCZ7575082.1 | 2614247 | g20881 | i0 | 43.4 | 0.507987220447284 | 53 | 25 | 46 | 1 | 226 | 83 | 32 | 84 | MCZ7575082.1 hypothetical protein [Ardenticatenaceae bacterium] | diamond | 159 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 32307522 | 32307522 | PRJNA725806_P_NODE_145199_length_171_cov_2.000000_g144897_i0 | PRJNA725806 | 145199 | 171 | 2 | 3.42 | Bacillati | 1783272 | Bacteria | Bacteria | 67 | 3.78e-11 | NR | MEA2652613.1 | 2026724 | g144897 | i0 | 64.7 | 7.52631578947368 | 51 | 18 | 89.5 | 0 | 171 | 19 | 51 | 101 | MEA2652613.1 molybdopterin molybdotransferase [Chloroflexota bacterium] | diamond | 1287 | 67 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32402250 | 32402250 | PRJNA725806_P_NODE_101759_length_196_cov_2.635220_g101457_i0 | PRJNA725806 | 101759 | 196 | 2.63522 | 5.1650312 | Bacteria | 2 | Bacteria | Bacteria | 41.6 | 0.0497 | NR | MCY3637672.1 | 2026724 | g101457 | i0 | 42.9 | 1.19387755102041 | 42 | 23 | 64.3 | 1 | 196 | 71 | 213 | 253 | MCY3637672.1 hypothetical protein [Chloroflexota bacterium] | diamond | 234 | 42 | 0.990476190476191 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32770402 | 32770402 | PRJNA725806_P_NODE_83580_length_210_cov_4.578035_g83279_i0 | PRJNA725806 | 83580 | 210 | 4.578035 | 9.6138735 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 42.4 | 0.0344 | NR | HFD40882.1 | 2052143 | g83279 | i0 | 39.6 | 0.757142857142857 | 53 | 30 | 72.9 | 1 | 162 | 10 | 145 | 197 | HFD40882.1 putative baseplate assembly protein [Anaerolineae bacterium] | diamond | 159 | 42.4 | 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);;