contig_metadata
14 rows where bioproject = "PRJNA782235", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2039369 | 2039369 | PRJNA782235_P_NODE_24722_length_244_cov_0.900585_g24533_i0 | PRJNA782235 | 24722 | 244 | 0.900585 | 2.1974274 | uncultured Dehalococcoidia bacterium | 498747 | Bacteria | Bacteria | 108 | 4.63e-19 | NTclustered | gi|2531976033|emb|OY282371.1| | 498747 | g24533 | i0 | 82.308 | 1.14754098360656 | 130 | 18 | 52 | 5 | 112 | 239 | 1051070 | 1051196 | MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1 | blastn | 280 | 108 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | uncultured Dehalococcoidia bacterium | |||||
| 16065859 | 16065859 | PRJNA782235_P_NODE_26073_length_243_cov_0.905882_g25884_i0 | PRJNA782235 | 26073 | 243 | 0.905882 | 2.20129326 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 134 | 1e-36 | NR | HSH82570.1 | 2720503 | g25884 | i0 | 81 | 0.975308641975309 | 79 | 15 | 97.5 | 0 | 6 | 242 | 131 | 209 | HSH82570.1 alanine racemase [Herpetosiphonaceae bacterium] | diamond | 237 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 26610197 | 26610197 | PRJNA782235_P_NODE_25641_length_243_cov_0.905882_g25452_i0 | PRJNA782235 | 25641 | 243 | 0.905882 | 2.20129326 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 97.1 | 2.82e-21 | NR | MDQ5850554.1 | 2026724 | g25452 | i0 | 53.2 | 0.950617283950617 | 77 | 36 | 95.1 | 0 | 242 | 12 | 310 | 386 | MDQ5850554.1 prolyl oligopeptidase family serine peptidase [Chloroflexota bacterium] | diamond | 231 | 97.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26832128 | 26832128 | PRJNA782235_P_NODE_27241_length_242_cov_0.911243_g27052_i0 | PRJNA782235 | 27241 | 242 | 0.911243 | 2.20520806 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 77 | 2.95e-14 | NR | MDQ2934706.1 | 2026724 | g27052 | i0 | 46.5 | 1.83471074380165 | 71 | 38 | 88 | 0 | 3 | 215 | 303 | 373 | MDQ2934706.1 hypothetical protein [Chloroflexota bacterium] | diamond | 444 | 77 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27780296 | 27780296 | PRJNA782235_P_NODE_17524_length_250_cov_0.870056_g17335_i0 | PRJNA782235 | 17524 | 250 | 0.870056 | 2.17514 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 51.6 | 3.12e-5 | NR | HEU4745652.1 | 2073117 | g17335 | i0 | 43.3 | 0.72 | 60 | 34 | 72 | 0 | 181 | 2 | 6 | 65 | HEU4745652.1 DNRLRE domain-containing protein [Anaerolineales bacterium] | diamond | 180 | 51.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 28853467 | 28853467 | PRJNA782235_P_NODE_18048_length_250_cov_0.870056_g17859_i0 | PRJNA782235 | 18048 | 250 | 0.870056 | 2.17514 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 55.8 | 3.95e-7 | NR | MCL4862132.1 | 2614250 | g17859 | i0 | 85.4 | 0.492 | 41 | 6 | 49.2 | 0 | 250 | 128 | 36 | 76 | MCL4862132.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 123 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29011886 | 29011886 | PRJNA782235_P_NODE_28908_length_217_cov_4.118056_g28719_i0 | PRJNA782235 | 28908 | 217 | 4.118056 | 8.93618152 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 73.9 | 1.56e-13 | NR | HEX2517121.1 | 2026724 | g28719 | i0 | 63.3 | 0.829493087557604 | 60 | 19 | 78.8 | 1 | 47 | 217 | 50 | 109 | HEX2517121.1 DUF6544 family protein [Chloroflexota bacterium] | diamond | 180 | 73.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29043285 | 29043285 | PRJNA782235_P_NODE_27208_length_242_cov_0.911243_g27019_i0 | PRJNA782235 | 27208 | 242 | 0.911243 | 2.20520806 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 146 | 1.64e-41 | NR | MFN8464511.1 | 2614250 | g27019 | i0 | 88.8 | 0.991735537190083 | 80 | 9 | 99.2 | 0 | 3 | 242 | 29 | 108 | MFN8464511.1 GNAT family N-acetyltransferase [Caldilineaceae bacterium] | diamond | 240 | 146 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 29201142 | 29201142 | PRJNA782235_P_NODE_26369_length_242_cov_1.142012_g26180_i0 | PRJNA782235 | 26369 | 242 | 1.142012 | 2.76366904 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 82.8 | 2.91e-16 | NR | HEX8220911.1 | 2448782 | g26180 | i0 | 52.5 | 0.991735537190083 | 80 | 38 | 99.2 | 0 | 241 | 2 | 901 | 980 | HEX8220911.1 two-component regulator propeller domain-containing protein [Chloroflexia bacterium] | diamond | 240 | 82.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 29611149 | 29611149 | PRJNA782235_P_NODE_15790_length_253_cov_1.566667_g15601_i0 | PRJNA782235 | 15790 | 253 | 1.566667 | 3.96366751 | Candidatus Leptofilum proximum | 3140689 | Bacteria | Bacteria | 128 | 2.57e-33 | NR | MBK8900364.1 | 3140689 | g15601 | i0 | 76.2 | 1.9802371541502 | 84 | 20 | 99.6 | 0 | 2 | 253 | 127 | 210 | MBK8900364.1 beta-propeller fold lactonase family protein [Candidatus Leptofilum proximum] | diamond | 501 | 128 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Leptofilum | Candidatus Leptofilum proximum | ||
| 29715150 | 29715150 | PRJNA782235_P_NODE_27150_length_242_cov_0.911243_g26961_i0 | PRJNA782235 | 27150 | 242 | 0.911243 | 2.20520806 | Chloroflexales | 32064 | Bacteria | Bacteria | 131 | 3.5099999999999992e-34 | NR | NWF81329.1 | 2026724 | g26961 | i0 | 85 | 5.92561983471074 | 80 | 12 | 99.2 | 0 | 240 | 1 | 189 | 268 | NWF81329.1 beta-ketoacyl-ACP synthase II [Chloroflexota bacterium] | diamond | 1434 | 131 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29737492 | 29737492 | PRJNA782235_P_NODE_25230_length_243_cov_1.494118_g25041_i0 | PRJNA782235 | 25230 | 243 | 1.494118 | 3.63070674 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 124 | 4.95e-31 | NR | CAA9324362.1 | 1672391 | g25041 | i0 | 71.4 | 0.950617283950617 | 77 | 22 | 95.1 | 0 | 238 | 8 | 31 | 107 | CAA9324362.1 MAG: diguanylate cyclase/phosphodiesterase (GGDEF & EAL domains) with PAS/PAC sensor(s) [uncultured Chloroflexia bacterium] | diamond | 231 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 30938427 | 30938427 | PRJNA782235_P_NODE_24774_length_244_cov_0.900585_g24585_i0 | PRJNA782235 | 24774 | 244 | 0.900585 | 2.1974274 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 81.3 | 1.02e-16 | NR | GIV98256.1 | 2720503 | g24585 | i0 | 78.3 | 0.565573770491803 | 46 | 10 | 56.6 | 0 | 139 | 2 | 10 | 55 | GIV98256.1 MAG: membrane protein [Herpetosiphonaceae bacterium] | diamond | 138 | 81.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 32614398 | 32614398 | PRJNA782235_P_NODE_26160_length_243_cov_0.905882_g25971_i0 | PRJNA782235 | 26160 | 243 | 0.905882 | 2.20129326 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 43.9 | 0.00534 | NR | MBA2452775.1 | 2448782 | g25971 | i0 | 61.1 | 0.444444444444444 | 36 | 14 | 44.4 | 0 | 25 | 132 | 93 | 128 | MBA2452775.1 helix-turn-helix transcriptional regulator [Chloroflexia bacterium] | diamond | 108 | 43.9 | 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);;