contig_metadata
24 rows where bioproject = "PRJNA757618", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4561195 | 4561195 | PRJNA757618_P_NODE_46304_length_243_cov_0.905882_g45252_i0 | PRJNA757618 | 46304 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 165 | 2.84e-45 | NR | RJP49650.1 | 2024896 | g45252 | i0 | 93.8 | 6 | 81 | 5 | 100 | 0 | 1 | 243 | 1131 | 1211 | RJP49650.1 MAG: hypothetical protein C4583_12010, partial [Anaerolineaceae bacterium] | diamond | 1458 | 166 | 0.993975903614458 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 5836134 | 5836134 | PRJNA757618_P_NODE_35505_length_248_cov_0.891429_g34453_i0 | PRJNA757618 | 35505 | 248 | 0.891429 | 2.21074392 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 161 | 6.839999999999999e-46 | NR | HEX7224706.1 | 3047546 | g34453 | i0 | 98.8 | 0.991935483870968 | 82 | 1 | 99.2 | 0 | 1 | 246 | 172 | 253 | HEX7224706.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Candidatus Limnocylindria bacterium] | diamond | 246 | 161 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 5836222 | 5836222 | PRJNA757618_P_NODE_42445_length_244_cov_1.801170_g41393_i0 | PRJNA757618 | 42445 | 244 | 1.80117 | 4.3948548 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 233 | 7.319999999999999e-57 | NTclustered | gi|2874253725|emb|OY969567.1| | 1672391 | g41393 | i0 | 84.016 | 79.1844262295082 | 244 | 37 | 99 | 2 | 2 | 244 | 2639914 | 2639672 | MAG: uncultured Chloroflexia bacterium isolate MFD01561.bin.c.1 genome assembly, chromosome: 1 | blastn | 19321 | 233 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 17780264 | 17780264 | PRJNA757618_P_NODE_39874_length_246_cov_0.895954_g38822_i0 | PRJNA757618 | 39874 | 246 | 0.895954 | 2.20404684 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 110 | 1.2200000000000002e-27 | NR | MEP7157877.1 | 2026724 | g38822 | i0 | 69.1 | 1.97560975609756 | 81 | 25 | 98.8 | 0 | 2 | 244 | 50 | 130 | MEP7157877.1 ABC transporter permease [Chloroflexota bacterium] | diamond | 486 | 110 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 18584552 | 18584552 | PRJNA757618_P_NODE_42035_length_245_cov_0.895349_g40983_i0 | PRJNA757618 | 42035 | 245 | 0.895349 | 2.19360505 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 58.9 | 6.48e-8 | NR | HET9758100.1 | 2952938 | g40983 | i0 | 53.1 | 1.18775510204082 | 49 | 22 | 60 | 1 | 243 | 97 | 25 | 72 | HET9758100.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 291 | 58.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 24959059 | 24959059 | PRJNA757618_P_NODE_28580_length_252_cov_0.865922_g27528_i0 | PRJNA757618 | 28580 | 252 | 0.865922 | 2.18212344 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 102 | 2.48e-24 | NR | HMQ29134.1 | 2562117 | g27528 | i0 | 66.3 | 2.96428571428571 | 83 | 28 | 98.8 | 0 | 3 | 251 | 34 | 116 | HMQ29134.1 DUF4397 domain-containing protein [Chloroflexaceae bacterium] | diamond | 747 | 102 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 26704550 | 26704550 | PRJNA757618_P_NODE_41881_length_245_cov_0.901163_g40829_i0 | PRJNA757618 | 41881 | 245 | 0.901163 | 2.20784935 | Herpetosiphon sp. | 71864 | Bacteria | Bacteria | 93.2 | 1.12e-20 | NR | WP_287045354.1 | 71864 | g40829 | i0 | 60 | 3.94285714285714 | 80 | 32 | 98 | 0 | 240 | 1 | 183 | 262 | WP_287045354.1 choice-of-anchor A family protein, partial [Herpetosiphon sp.] | diamond | 966 | 93.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphon | Herpetosiphon sp. | ||
| 27210785 | 27210785 | PRJNA757618_P_NODE_33182_length_249_cov_0.886364_g32130_i0 | PRJNA757618 | 33182 | 249 | 0.886364 | 2.20704636 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 78.2 | 1.1e-14 | NR | MCI0395226.1 | 2026724 | g32130 | i0 | 57.4 | 6.01204819277108 | 68 | 29 | 81.9 | 0 | 248 | 45 | 340 | 407 | MCI0395226.1 MFS transporter [Chloroflexota bacterium] | diamond | 1497 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28379374 | 28379374 | PRJNA757618_P_NODE_32766_length_249_cov_1.397727_g31714_i0 | PRJNA757618 | 32766 | 249 | 1.397727 | 3.48034023 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 115 | 1.35e-27 | NR | HLT84485.1 | 3069543 | g31714 | i0 | 63.4 | 4.91566265060241 | 82 | 30 | 98.8 | 0 | 2 | 247 | 389 | 470 | HLT84485.1 ribonucleoside-triphosphate reductase, adenosylcobalamin-dependent [Phototrophicaceae bacterium] | diamond | 1224 | 115 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 28505692 | 28505692 | PRJNA757618_P_NODE_32027_length_250_cov_0.875706_g30975_i0 | PRJNA757618 | 32027 | 250 | 0.875706 | 2.189265 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 144 | 4.21e-39 | NR | MDQ2690331.1 | 2026724 | g30975 | i0 | 79.5 | 0.996 | 83 | 17 | 99.6 | 0 | 249 | 1 | 93 | 175 | MDQ2690331.1 peptidase MA family metallohydrolase [Chloroflexota bacterium] | diamond | 249 | 144 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28852808 | 28852808 | PRJNA757618_P_NODE_29828_length_251_cov_0.876404_g28776_i0 | PRJNA757618 | 29828 | 251 | 0.876404 | 2.19977404 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 1.43e-33 | NR | MBM3190393.1 | 2026724 | g28776 | i0 | 71.1 | 0.99203187250996006 | 83 | 24 | 99.2 | 0 | 250 | 2 | 196 | 278 | MBM3190393.1 ABC transporter ATP-binding protein [Chloroflexota bacterium] | diamond | 249 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28852812 | 28852812 | PRJNA757618_P_NODE_40908_length_245_cov_0.906977_g39856_i0 | PRJNA757618 | 40908 | 245 | 0.906977 | 2.22209365 | Chloroflexales bacterium | 2725990 | Bacteria | Bacteria | 133 | 8.18e-39 | NR | MEI6179659.1 | 2725990 | g39856 | i0 | 97 | 1.64081632653061 | 67 | 2 | 82 | 0 | 43 | 243 | 1 | 67 | MEI6179659.1 deoxyhypusine synthase family protein [Chloroflexales bacterium] | diamond | 402 | 133 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexales bacterium | ||||
| 29137445 | 29137445 | PRJNA757618_P_NODE_40089_length_246_cov_0.890173_g39037_i0 | PRJNA757618 | 40089 | 246 | 0.890173 | 2.18982558 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 143 | 5.71e-38 | NR | HMQ29584.1 | 2562117 | g39037 | i0 | 90 | 1.95121951219512 | 80 | 8 | 97.6 | 0 | 241 | 2 | 481 | 560 | HMQ29584.1 penicillin-binding transpeptidase domain-containing protein [Chloroflexaceae bacterium] | diamond | 480 | 143 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 29232020 | 29232020 | PRJNA757618_P_NODE_41889_length_245_cov_0.901163_g40837_i0 | PRJNA757618 | 41889 | 245 | 0.901163 | 2.20784935 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 96.3 | 5.57e-21 | NR | HMQ30949.1 | 2562117 | g40837 | i0 | 57.5 | 0.979591836734694 | 80 | 34 | 98 | 0 | 5 | 244 | 203 | 282 | HMQ30949.1 glycosyl transferase [Chloroflexaceae bacterium] | diamond | 240 | 96.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 30021510 | 30021510 | PRJNA757618_P_NODE_40191_length_246_cov_0.884393_g39139_i0 | PRJNA757618 | 40191 | 246 | 0.884393 | 2.17560678 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 117 | 3.89e-29 | NR | HEU5013920.1 | 2762507 | g39139 | i0 | 73.7 | 0.926829268292683 | 76 | 20 | 92.7 | 0 | 18 | 245 | 261 | 336 | HEU5013920.1 DNA adenine methylase [Roseiflexaceae bacterium] | diamond | 228 | 117 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 30242641 | 30242641 | PRJNA757618_P_NODE_47012_length_242_cov_0.923077_g45960_i0 | PRJNA757618 | 47012 | 242 | 0.923077 | 2.23384634 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 106 | 4.32e-25 | NR | MBA2468864.1 | 2448782 | g45960 | i0 | 64.6 | 0.979338842975207 | 79 | 27 | 96.7 | 1 | 9 | 242 | 249 | 327 | MBA2468864.1 D-alanyl-D-alanine carboxypeptidase [Chloroflexia bacterium] | diamond | 237 | 106 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 30432492 | 30432492 | PRJNA757618_P_NODE_23173_length_264_cov_1.549738_g22121_i0 | PRJNA757618 | 23173 | 264 | 1.549738 | 4.0913083200000004 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 80.1 | 4.68e-17 | NR | MDQ2683049.1 | 2026724 | g22121 | i0 | 100 | 0.420454545454545 | 37 | 0 | 42 | 0 | 153 | 263 | 1 | 37 | MDQ2683049.1 Gfo/Idh/MocA family oxidoreductase [Chloroflexota bacterium] | diamond | 111 | 80.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31000915 | 31000915 | PRJNA757618_P_NODE_32514_length_250_cov_0.864407_g31462_i0 | PRJNA757618 | 32514 | 250 | 0.864407 | 2.1610175 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 174 | 6.429999999999999e-52 | NR | MFN8517161.1 | 2448782 | g31462 | i0 | 97.6 | 0.984 | 82 | 2 | 98.4 | 0 | 248 | 3 | 121 | 202 | MFN8517161.1 sugar ABC transporter permease [Chloroflexia bacterium] | diamond | 246 | 174 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 31064250 | 31064250 | PRJNA757618_P_NODE_43515_length_244_cov_0.906433_g42463_i0 | PRJNA757618 | 43515 | 244 | 0.906433 | 2.21169652 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 112 | 3.66e-30 | NR | MBA2299827.1 | 2026724 | g42463 | i0 | 74.1 | 3.98360655737705 | 81 | 21 | 99.6 | 0 | 2 | 244 | 5 | 85 | MBA2299827.1 AzlD domain-containing protein [Chloroflexota bacterium] | diamond | 972 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31285154 | 31285154 | PRJNA757618_P_NODE_25095_length_258_cov_0.972973_g24043_i0 | PRJNA757618 | 25095 | 258 | 0.972973 | 2.51027034 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 119 | 3.96e-29 | NR | HJP70198.1 | 3047546 | g24043 | i0 | 71.1 | 3.84883720930233 | 83 | 24 | 96.5 | 0 | 4 | 252 | 124 | 206 | HJP70198.1 S8 family serine peptidase [Candidatus Limnocylindria bacterium] | diamond | 993 | 119 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 31538485 | 31538485 | PRJNA757618_P_NODE_43036_length_244_cov_0.912281_g41984_i0 | PRJNA757618 | 43036 | 244 | 0.912281 | 2.22596564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 107 | 2.83e-26 | NR | MEO0598581.1 | 2026724 | g41984 | i0 | 71.6 | 2.72950819672131 | 74 | 21 | 91 | 0 | 238 | 17 | 165 | 238 | MEO0598581.1 ABC transporter transmembrane domain-containing protein [Chloroflexota bacterium] | diamond | 666 | 107 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31601717 | 31601717 | PRJNA757618_P_NODE_13256_length_316_cov_1.600823_g12204_i0 | PRJNA757618 | 13256 | 316 | 1.600823 | 5.05860068 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 48.5 | 1.78e-4 | NR | MFA5367306.1 | 2026734 | g12204 | i0 | 48.2 | 0.531645569620253 | 56 | 26 | 53.2 | 2 | 33 | 200 | 69 | 121 | MFA5367306.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 168 | 48.5 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32392490 | 32392490 | PRJNA757618_P_NODE_9479_length_363_cov_0.944828_g8427_i0 | PRJNA757618 | 9479 | 363 | 0.944828 | 3.42972564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 45.4 | 0.0137 | NR | MBM4433870.1 | 2026724 | g8427 | i0 | 38.8 | 1.10743801652893 | 67 | 39 | 53.7 | 1 | 314 | 120 | 34 | 100 | MBM4433870.1 branched-chain amino acid ABC transporter permease [Chloroflexota bacterium] | diamond | 402 | 45.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32551012 | 32551012 | PRJNA757618_P_NODE_30339_length_251_cov_0.870787_g29287_i0 | PRJNA757618 | 30339 | 251 | 0.870787 | 2.18567537 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 5.45e-33 | NR | MDQ2997219.1 | 2026724 | g29287 | i0 | 87 | 1.64940239043825 | 69 | 9 | 82.5 | 0 | 6 | 212 | 348 | 416 | MDQ2997219.1 hypothetical protein [Chloroflexota bacterium] | diamond | 414 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota 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);;