contig_metadata
20 rows where bioproject = "PRJNA896758", tax_phylum = "Chloroflexota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9800661 | 9800661 | PRJNA896758_P_NODE_20168_length_258_cov_1.654054_g19778_i0 | PRJNA896758 | 20168 | 258 | 1.654054 | 4.26745932 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 140 | 8.28e-38 | NR | HET7088837.1 | 2052143 | g19778 | i0 | 75.6 | 2 | 86 | 21 | 100 | 0 | 1 | 258 | 113 | 198 | HET7088837.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Anaerolineae bacterium] | diamond | 516 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26612369 | 26612369 | PRJNA896758_P_NODE_25841_length_242_cov_1.112426_g25451_i0 | PRJNA896758 | 25841 | 242 | 1.112426 | 2.69207092 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 43.1 | 0.0218 | NR | HMQ30078.1 | 2562117 | g25451 | i0 | 42.2 | 0.557851239669422 | 45 | 21 | 55.8 | 2 | 17 | 151 | 86 | 125 | HMQ30078.1 hypothetical protein [Chloroflexaceae bacterium] | diamond | 135 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 26675513 | 26675513 | PRJNA896758_P_NODE_15521_length_290_cov_1.235023_g15131_i0 | PRJNA896758 | 15521 | 290 | 1.235023 | 3.5815667 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 77.4 | 2.05e-14 | NR | MCC7162784.1 | 2052143 | g15131 | i0 | 49.5 | 3.6 | 93 | 42 | 93.1 | 2 | 11 | 280 | 147 | 237 | MCC7162784.1 nucleoside hydrolase [Anaerolineae bacterium] | diamond | 1044 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 26866155 | 26866155 | PRJNA896758_P_NODE_7581_length_412_cov_2.389381_g7191_i0 | PRJNA896758 | 7581 | 412 | 2.389381 | 9.84424972 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 70.5 | 1.54e-11 | NR | MCB0111190.1 | 2614250 | g7191 | i0 | 39.5 | 0.902912621359223 | 124 | 51 | 79.4 | 4 | 350 | 24 | 130 | 244 | MCB0111190.1 serine protease [Caldilineaceae bacterium] | diamond | 372 | 70.5 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 27063378 | 27063378 | PRJNA896758_P_NODE_14722_length_299_cov_0.907080_g14332_i0 | PRJNA896758 | 14722 | 299 | 0.90708 | 2.7121692 | Chloroflexota | 200795 | Bacteria | Bacteria | 136 | 1.98e-35 | NR | OQY32290.1 | 1971724 | g14332 | i0 | 60.2 | 3.93311036789298 | 98 | 39 | 98.3 | 0 | 296 | 3 | 189 | 286 | OQY32290.1 MAG: aspartate aminotransferase family protein [Anaerolineaceae bacterium 4572_5.1] | diamond | 1176 | 137 | 0.992700729927007 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium 4572_5.1 | |||
| 27498199 | 27498199 | PRJNA896758_P_NODE_26483_length_241_cov_0.916667_g26093_i0 | PRJNA896758 | 26483 | 241 | 0.916667 | 2.20916747 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 41.2 | 0.0232 | NR | HEY7835567.1 | 2306968 | g26093 | i0 | 42.6 | 0.672199170124481 | 54 | 29 | 67.2 | 2 | 80 | 241 | 10 | 61 | HEY7835567.1 hypothetical protein [Ktedonobacterales bacterium] | diamond | 162 | 41.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 27592952 | 27592952 | PRJNA896758_P_NODE_15204_length_293_cov_1.050000_g14814_i0 | PRJNA896758 | 15204 | 293 | 1.05 | 3.0765 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 58.5 | 8.8e-9 | NR | TDA67627.1 | 2026724 | g14814 | i0 | 46.6 | 0.593856655290102 | 58 | 30 | 59.4 | 1 | 210 | 37 | 6 | 62 | TDA67627.1 MAG: hypothetical protein D9V45_01830 [Chloroflexota bacterium] | diamond | 174 | 58.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28192484 | 28192484 | PRJNA896758_P_NODE_21946_length_250_cov_0.870056_g21556_i0 | PRJNA896758 | 21946 | 250 | 0.870056 | 2.17514 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 43.5 | 0.0116 | NR | HEY0734754.1 | 2720503 | g21556 | i0 | 44.2 | 0.516 | 43 | 24 | 51.6 | 0 | 4 | 132 | 20 | 62 | HEY0734754.1 tetratricopeptide repeat-containing protein [Herpetosiphonaceae bacterium] | diamond | 129 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 28823895 | 28823895 | PRJNA896758_P_NODE_14948_length_296_cov_1.000000_g14558_i0 | PRJNA896758 | 14948 | 296 | 1 | 2.96 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 43.9 | 0.0257 | NR | MEO5986898.1 | 3047546 | g14558 | i0 | 42 | 0.699324324324324 | 69 | 37 | 67.9 | 2 | 61 | 261 | 136 | 203 | MEO5986898.1 tRNA guanosine(34) transglycosylase Tgt [Candidatus Limnocylindria bacterium] | diamond | 207 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28823896 | 28823896 | PRJNA896758_P_NODE_15208_length_293_cov_1.027273_g14818_i0 | PRJNA896758 | 15208 | 293 | 1.027273 | 3.00990989 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 55.1 | 2.75e-6 | NR | RMF38463.1 | 2026724 | g14818 | i0 | 36 | 1.02389078498294 | 100 | 60 | 98.3 | 1 | 288 | 1 | 33 | 132 | RMF38463.1 MAG: hypothetical protein D6759_00870 [Chloroflexota bacterium] | diamond | 300 | 55.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29021679 | 29021679 | PRJNA896758_P_NODE_25028_length_244_cov_0.900585_g24638_i0 | PRJNA896758 | 25028 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 5.98e-6 | NR | WP_126631492.1 | 2014873 | g24638 | i0 | 41.6 | 10.1926229508197 | 77 | 36 | 84.8 | 3 | 243 | 37 | 48 | 123 | WP_126631492.1 right-handed parallel beta-helix repeat-containing protein [Dictyobacter alpinus] | diamond | 2487 | 53.5 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Dictyobacteraceae | Dictyobacter | Dictyobacter alpinus | ||
| 29518722 | 29518722 | PRJNA896758_P_NODE_11490_length_339_cov_1.176692_g11100_i0 | PRJNA896758 | 11490 | 339 | 1.176692 | 3.98898588 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.0207 | NR | MEA3345876.1 | 2026724 | g11100 | i0 | 37.5 | 0.778761061946903 | 88 | 43 | 67.3 | 2 | 48 | 275 | 3 | 90 | MEA3345876.1 hypothetical protein [Chloroflexota bacterium] | diamond | 264 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29581618 | 29581618 | PRJNA896758_P_NODE_25930_length_242_cov_0.911243_g25540_i0 | PRJNA896758 | 25930 | 242 | 0.911243 | 2.20520806 | Chloroflexi bacterium RBG_13_6 | 1797636 | Bacteria | Bacteria | 44.3 | 0.00254 | NR | OGO09954.1 | 1797636 | g25540 | i0 | 55.8 | 1.36363636363636 | 43 | 17 | 50.8 | 1 | 2 | 124 | 51 | 93 | OGO09954.1 MAG: hypothetical protein A3K46_05140 [Chloroflexi bacterium RBG_13_60_9] | diamond | 330 | 44.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_13_60_9 | ||||||
| 29613205 | 29613205 | PRJNA896758_P_NODE_25950_length_242_cov_0.911243_g25560_i0 | PRJNA896758 | 25950 | 242 | 0.911243 | 2.20520806 | Candidatus Limnocylindrales bacterium | 2952938 | Bacteria | Bacteria | 142 | 3.78e-39 | NR | HEY8168252.1 | 2952938 | g25560 | i0 | 93.8 | 1.98347107438017 | 80 | 5 | 99.2 | 0 | 2 | 241 | 17 | 96 | HEY8168252.1 hypothetical protein [Candidatus Limnocylindrales bacterium] | diamond | 480 | 142 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindrales | Candidatus Limnocylindrales bacterium | ||||
| 30087220 | 30087220 | PRJNA896758_P_NODE_24372_length_245_cov_0.895349_g23982_i0 | PRJNA896758 | 24372 | 245 | 0.895349 | 2.19360505 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 66.6 | 1.3e-10 | NR | MEX2160153.1 | 2026734 | g23982 | i0 | 44.3 | 0.96734693877551 | 79 | 38 | 91.8 | 4 | 236 | 12 | 106 | 182 | MEX2160153.1 kelch repeat-containing protein [Dehalococcoidia bacterium] | diamond | 237 | 66.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30094841 | 30094841 | PRJNA896758_P_NODE_25492_length_243_cov_0.905882_g25102_i0 | PRJNA896758 | 25492 | 243 | 0.905882 | 2.20129326 | Bacteria | 2 | Bacteria | Bacteria | 114 | 4.97e-29 | NR | MCS6843115.1 | 2306055 | g25102 | i0 | 68.4 | 14.641975308642 | 79 | 25 | 97.5 | 0 | 238 | 2 | 39 | 117 | MCS6843115.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Caldilineales bacterium] | diamond | 3558 | 115 | 0.991304347826087 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineales bacterium | ||||
| 30908903 | 30908903 | PRJNA896758_P_NODE_25414_length_243_cov_0.905882_g25024_i0 | PRJNA896758 | 25414 | 243 | 0.905882 | 2.20129326 | Aggregatilinea lenta | 913108 | Bacteria | Bacteria | 124 | 1.5999999999999998e-32 | NR | WP_119070884.1 | 913108 | g25024 | i0 | 78.8 | 0.987654320987654 | 80 | 17 | 98.8 | 0 | 242 | 3 | 150 | 229 | WP_119070884.1 carbohydrate ABC transporter permease [Aggregatilinea lenta] | diamond | 240 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Aggregatilineaceae | Aggregatilinea | Aggregatilinea lenta | ||
| 32268846 | 32268846 | PRJNA896758_P_NODE_25598_length_243_cov_0.905882_g25208_i0 | PRJNA896758 | 25598 | 243 | 0.905882 | 2.20129326 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 76.6 | 4.25e-14 | NR | HAD06929.1 | 2024896 | g25208 | i0 | 44.4 | 1.98765432098765 | 81 | 44 | 98.8 | 1 | 2 | 241 | 692 | 772 | HAD06929.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 483 | 76.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32899728 | 32899728 | PRJNA896758_P_NODE_22920_length_248_cov_0.880000_g22530_i0 | PRJNA896758 | 22920 | 248 | 0.88 | 2.1824 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 141 | 2.11e-39 | NR | CAA9364578.1 | 1672391 | g22530 | i0 | 79.3 | 0.991935483870968 | 82 | 17 | 99.2 | 0 | 247 | 2 | 148 | 229 | CAA9364578.1 MAG: Mobile element protein [uncultured Chloroflexia bacterium] | diamond | 246 | 141 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 32907449 | 32907449 | PRJNA896758_P_NODE_14800_length_298_cov_1.017778_g14410_i0 | PRJNA896758 | 14800 | 298 | 1.017778 | 3.03297844 | Bacillati | 1783272 | Bacteria | Bacteria | 48.1 | 8.69e-4 | NR | MCC6457233.1 | 2614250 | g14410 | i0 | 34.2 | 3.71476510067114 | 73 | 48 | 73.5 | 0 | 2 | 220 | 8 | 80 | MCC6457233.1 NAD-dependent epimerase/dehydratase family protein [Caldilineaceae bacterium] | diamond | 1107 | 48.5 | 0.991752577319588 | 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);;