contig_metadata
23 rows where bioproject = "PRJNA1196438", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1597911 | 1597911 | PRJNA1196438_P_NODE_55802_length_264_cov_2.764398_g55375_i0 | PRJNA1196438 | 55802 | 264 | 2.764398 | 7.29801072 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 54.7 | 0.007 | NTclustered | gi|2874253741|emb|OY969584.1| | 1672391 | g55375 | i0 | 94.286 | 0.462121212121212 | 35 | 2 | 13 | 0 | 160 | 194 | 2265328 | 2265362 | MAG: uncultured Chloroflexia bacterium isolate MFD01299.bin.c.4 genome assembly, chromosome: 1 | blastn | 122 | 54.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 4150314 | 4150314 | PRJNA1196438_P_NODE_64484_length_252_cov_2.340782_g64057_i0 | PRJNA1196438 | 64484 | 252 | 2.340782 | 5.89877064 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 99 | 6.78e-22 | NR | HUS16730.1 | 2448782 | g64057 | i0 | 65.9 | 1.01190476190476 | 85 | 27 | 100 | 2 | 1 | 252 | 194 | 277 | HUS16730.1 non-homologous end-joining DNA ligase [Chloroflexia bacterium] | diamond | 255 | 99 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 6701504 | 6701504 | PRJNA1196438_P_NODE_79306_length_235_cov_3.376543_g78879_i0 | PRJNA1196438 | 79306 | 235 | 3.376543 | 7.93487605 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 200 | 7.11e-47 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g78879 | i0 | 83.111 | 0.957446808510638 | 225 | 33 | 95 | 4 | 1 | 224 | 126824 | 126604 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 225 | 200 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 7976490 | 7976490 | PRJNA1196438_P_NODE_42827_length_284_cov_3.317536_g42400_i0 | PRJNA1196438 | 42827 | 284 | 3.317536 | 9.42180224 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 86.3 | 5.95e-18 | NR | MBV9892651.1 | 2026724 | g42400 | i0 | 69.6 | 0.971830985915493 | 92 | 18 | 86.6 | 1 | 283 | 38 | 29 | 120 | MBV9892651.1 hypothetical protein [Chloroflexota bacterium] | diamond | 276 | 86.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 18174837 | 18174837 | PRJNA1196438_P_NODE_50615_length_272_cov_2.025126_g50188_i0 | PRJNA1196438 | 50615 | 272 | 2.025126 | 5.50834272 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 60.2 | 1.49e-4 | NTclustered | gi|2893358382|emb|OZ220676.1| | 2614250 | g50188 | i0 | 100 | 0.441176470588235 | 32 | 0 | 12 | 0 | 158 | 189 | 1354571 | 1354602 | MAG: Caldilineaceae bacterium isolate 6911f4b3-f793-4dac-9473-b80504ec0e1d genome assembly, chromosome: 1 | blastn | 120 | 60.2 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 18175134 | 18175134 | PRJNA1196438_P_NODE_7195_length_382_cov_1.495146_g6773_i0 | PRJNA1196438 | 7195 | 382 | 1.495146 | 5.71145772 | uncultured Dehalococcoidia bacterium | 498747 | Bacteria | Bacteria | 60.2 | 2.18e-4 | NTclustered | gi|2518550964|emb|OX638324.1| | 498747 | g6773 | i0 | 94.872 | 2.38219895287958 | 39 | 1 | 10 | 1 | 222 | 260 | 1682414 | 1682451 | MAG: uncultured Dehalococcoidia bacterium isolate 3cc91b85-964c-4eee-822c-8c355d828f5f genome assembly, chromosome: 1 | blastn | 910 | 60.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | uncultured Dehalococcoidia bacterium | |||||
| 26882784 | 26882784 | PRJNA1196438_P_NODE_12241_length_312_cov_10.891213_g11815_i0 | PRJNA1196438 | 12241 | 312 | 10.891213 | 33.98058456 | Thermoflexus | 1495649 | Bacteria | Bacteria | 90.9 | 1.07e-18 | NR | WP_303897221.1 | 1495649 | g11815 | i0 | 81.3 | 0.923076923076923 | 48 | 9 | 46.2 | 0 | 149 | 6 | 1015 | 1062 | WP_303897221.1 MULTISPECIES: Eco57I restriction-modification methylase domain-containing protein [Thermoflexus] | diamond | 288 | 90.9 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexaceae | Thermoflexus | |||
| 27736236 | 27736236 | PRJNA1196438_P_NODE_84944_length_217_cov_5.451389_g84516_i0 | PRJNA1196438 | 84944 | 217 | 5.451389 | 11.82951413 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 132 | 3.4199999999999992e-34 | NR | HHY54861.1 | 2026724 | g84516 | i0 | 93.1 | 0.995391705069124 | 72 | 5 | 99.5 | 0 | 1 | 216 | 464 | 535 | HHY54861.1 SulP family inorganic anion transporter [Chloroflexota bacterium] | diamond | 216 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27893603 | 27893603 | PRJNA1196438_P_NODE_14525_length_312_cov_4.426778_g14099_i0 | PRJNA1196438 | 14525 | 312 | 4.426778 | 13.81154736 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 148 | 1.82e-42 | NR | HET8572119.1 | 3047546 | g14099 | i0 | 77.1 | 2.01923076923077 | 105 | 21 | 99 | 2 | 3 | 311 | 64 | 167 | HET8572119.1 DRTGG domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 630 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28544381 | 28544381 | PRJNA1196438_P_NODE_55687_length_264_cov_3.685864_g55260_i0 | PRJNA1196438 | 55687 | 264 | 3.685864 | 9.73068096 | FCB group | 1783270 | Bacteria | Bacteria | 57.4 | 3.03e-7 | NR | TMC50304.1 | 2026724 | g55260 | i0 | 47.9 | 3.17045454545455 | 48 | 20 | 54.5 | 1 | 147 | 4 | 95 | 137 | TMC50304.1 MAG: hypothetical protein E6J26_09970 [Chloroflexota bacterium] | diamond | 837 | 57.8 | 0.993079584775087 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28556929 | 28556929 | PRJNA1196438_P_NODE_15327_length_312_cov_4.058577_g14901_i0 | PRJNA1196438 | 15327 | 312 | 4.058577 | 12.66276024 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 97.8 | 3.58e-22 | NR | HEX2173770.1 | 2026734 | g14901 | i0 | 78.7 | 3.00961538461538 | 61 | 9 | 58.7 | 1 | 184 | 2 | 68 | 124 | HEX2173770.1 IS5 family transposase [Dehalococcoidia bacterium] | diamond | 939 | 97.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28809078 | 28809078 | PRJNA1196438_P_NODE_63948_length_253_cov_0.866667_g63521_i0 | PRJNA1196438 | 63948 | 253 | 0.866667 | 2.19266751 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 118 | 4.47e-29 | NR | HLT84384.1 | 3069543 | g63521 | i0 | 79.5 | 0.984189723320158 | 83 | 17 | 98.4 | 0 | 252 | 4 | 160 | 242 | HLT84384.1 histidine kinase [Phototrophicaceae bacterium] | diamond | 249 | 118 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 29207380 | 29207380 | PRJNA1196438_P_NODE_83009_length_228_cov_2.006452_g82582_i0 | PRJNA1196438 | 83009 | 228 | 2.006452 | 4.57471056 | Bacteria | 2 | Bacteria | Bacteria | 65.9 | 1.96e-10 | NR | TME12401.1 | 2026724 | g82582 | i0 | 47.2 | 6.63157894736842 | 72 | 35 | 93.4 | 2 | 217 | 5 | 140 | 209 | TME12401.1 MAG: IS200/IS605 family element transposase accessory protein TnpB [Chloroflexota bacterium] | diamond | 1512 | 65.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29409245 | 29409245 | PRJNA1196438_P_NODE_69329_length_248_cov_0.891429_g68902_i0 | PRJNA1196438 | 69329 | 248 | 0.891429 | 2.21074392 | SAR202 cluster bacterium | 2030829 | Bacteria | Bacteria | 44.7 | 0.00827 | NR | MQF98045.1 | 2030829 | g68902 | i0 | 32.8 | 1.77822580645161 | 67 | 44 | 79.8 | 1 | 198 | 1 | 454 | 520 | MQF98045.1 hypothetical protein [SAR202 cluster bacterium] | diamond | 441 | 44.7 | 1 | Bacteria | SAR202 cluster | Bacillati | Chloroflexota | Dehalococcoidia | SAR202 cluster bacterium | ||||
| 29427979 | 29427979 | PRJNA1196438_P_NODE_82329_length_229_cov_2.250000_g81902_i0 | PRJNA1196438 | 82329 | 229 | 2.25 | 5.1525 | Bacteria | 2 | Bacteria | Bacteria | 92 | 6.87e-21 | NR | MDZ7727693.1 | 2026734 | g81902 | i0 | 57.9 | 2.68558951965066 | 76 | 30 | 99.6 | 1 | 1 | 228 | 1 | 74 | MDZ7727693.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 615 | 92 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29491314 | 29491314 | PRJNA1196438_P_NODE_69110_length_248_cov_1.702857_g68683_i0 | PRJNA1196438 | 69110 | 248 | 1.702857 | 4.22308536 | Flexilinea | 1769713 | Bacteria | Bacteria | 137 | 2.69e-38 | NR | MBQ6503336.1 | 2017390 | g68683 | i0 | 76.5 | 4.92338709677419 | 81 | 19 | 98 | 0 | 4 | 246 | 132 | 212 | MBQ6503336.1 AzlC family ABC transporter permease [Flexilinea sp.] | diamond | 1221 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Flexilinea | Flexilinea sp. | ||
| 29914682 | 29914682 | PRJNA1196438_P_NODE_11391_length_317_cov_1.905738_g10965_i0 | PRJNA1196438 | 11391 | 317 | 1.905738 | 6.04118946 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 169 | 9.91e-50 | NR | MEA3340924.1 | 2026724 | g10965 | i0 | 73.1 | 2.95268138801262 | 104 | 28 | 98.4 | 0 | 4 | 315 | 146 | 249 | MEA3340924.1 bstEII [Chloroflexota bacterium] | diamond | 936 | 169 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30072417 | 30072417 | PRJNA1196438_P_NODE_63212_length_253_cov_3.038889_g62785_i0 | PRJNA1196438 | 63212 | 253 | 3.038889 | 7.68838917 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 132 | 4.42e-35 | NR | MEI6186819.1 | 2026734 | g62785 | i0 | 78 | 0.972332015810277 | 82 | 16 | 97.2 | 1 | 3 | 248 | 183 | 262 | MEI6186819.1 IS630 family transposase [Dehalococcoidia bacterium] | diamond | 246 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30294067 | 30294067 | PRJNA1196438_P_NODE_59452_length_259_cov_1.677419_g59025_i0 | PRJNA1196438 | 59452 | 259 | 1.677419 | 4.34451521 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 59.3 | 1.71e-9 | NR | MBQ4514403.1 | 2024896 | g59025 | i0 | 62.2 | 0.428571428571429 | 37 | 14 | 42.9 | 0 | 145 | 255 | 1 | 37 | MBQ4514403.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 111 | 59.3 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 31020420 | 31020420 | PRJNA1196438_P_NODE_19695_length_312_cov_3.066946_g19269_i0 | PRJNA1196438 | 19695 | 312 | 3.066946 | 9.56887152 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 89.4 | 2e-18 | NR | MCK5319140.1 | 2073117 | g19269 | i0 | 84 | 1.44230769230769 | 50 | 8 | 48.1 | 0 | 163 | 312 | 94 | 143 | MCK5319140.1 hypothetical protein [Anaerolineales bacterium] | diamond | 450 | 89.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31336295 | 31336295 | PRJNA1196438_P_NODE_47636_length_277_cov_1.524510_g47209_i0 | PRJNA1196438 | 47636 | 277 | 1.52451 | 4.2228927 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 49.7 | 1.93e-4 | NR | HBY93934.1 | 2026724 | g47209 | i0 | 64.6 | 0.855595667870036 | 79 | 18 | 74.7 | 2 | 209 | 3 | 1 | 79 | HBY93934.1 IS66 family transposase [Chloroflexota bacterium] | diamond | 237 | 49.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32146270 | 32146270 | PRJNA1196438_P_NODE_20518_length_312_cov_2.958159_g20092_i0 | PRJNA1196438 | 20518 | 312 | 2.958159 | 9.22945608 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 1e-20 | NR | HUS13787.1 | 2448782 | g20092 | i0 | 81.8 | 4.79807692307692 | 55 | 10 | 52.9 | 0 | 146 | 310 | 204 | 258 | HUS13787.1 IS110 family transposase [Chloroflexia bacterium] | diamond | 1497 | 95.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 32475507 | 32475507 | PRJNA1196438_P_NODE_34919_length_297_cov_3.151786_g34493_i0 | PRJNA1196438 | 34919 | 297 | 3.151786 | 9.36080442 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 77.4 | 4.42e-14 | NR | HET9493199.1 | 2448782 | g34493 | i0 | 68 | 1.06060606060606 | 50 | 16 | 50.5 | 0 | 296 | 147 | 148 | 197 | HET9493199.1 glucoamylase family protein [Chloroflexia bacterium] | diamond | 315 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia 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);;