contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11159243 | 11159243 | PRJNA980587_P_NODE_58109_length_299_cov_1.362832_g57316_i0 | PRJNA980587 | 58109 | 299 | 1.362832 | 4.07486768 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 141 | 6.48e-41 | NR | HJZ46865.1 | 2762507 | g57316 | i0 | 63.3 | 6.91304347826087 | 98 | 36 | 98.3 | 0 | 1 | 294 | 11 | 108 | HJZ46865.1 glycine cleavage system protein GcvH [Roseiflexaceae bacterium] | diamond | 2067 | 141 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 14023467 | 14023467 | PRJNA980587_P_NODE_96051_length_235_cov_2.246914_g95258_i0 | PRJNA980587 | 96051 | 235 | 2.246914 | 5.2802479 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 144 | 7.45e-41 | NR | MDB5083111.1 | 2026724 | g95258 | i0 | 89.5 | 1.94042553191489 | 76 | 8 | 97 | 0 | 234 | 7 | 134 | 209 | MDB5083111.1 transporter, ATPase subunit [Chloroflexota bacterium] | diamond | 456 | 144 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 16259254 | 16259254 | PRJNA980587_P_NODE_94913_length_241_cov_0.916667_g94120_i0 | PRJNA980587 | 94913 | 241 | 0.916667 | 2.20916747 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 110 | 1.43e-26 | NR | MBA2598567.1 | 2448782 | g94120 | i0 | 90.8 | 1.61825726141079 | 65 | 6 | 80.9 | 0 | 239 | 45 | 324 | 388 | MBA2598567.1 acyl-CoA/acyl-ACP dehydrogenase [Chloroflexia bacterium] | diamond | 390 | 110 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 21358025 | 21358025 | PRJNA980587_P_NODE_67457_length_275_cov_1.569307_g66664_i0 | PRJNA980587 | 67457 | 275 | 1.569307 | 4.31559425 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 122 | 7.649999999999998e-32 | NR | MCC6629505.1 | 2026724 | g66664 | i0 | 71.7 | 1.00363636363636 | 92 | 25 | 99.3 | 1 | 275 | 3 | 33 | 124 | MCC6629505.1 methyltransferase domain-containing protein [Chloroflexota bacterium] | diamond | 276 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 26931302 | 26931302 | PRJNA980587_P_NODE_39342_length_373_cov_0.910000_g38549_i0 | PRJNA980587 | 39342 | 373 | 0.91 | 3.3943 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 92 | 2.78e-19 | NR | HRW07030.1 | 2614250 | g38549 | i0 | 37.7 | 1.92225201072386 | 122 | 71 | 97.3 | 4 | 364 | 2 | 103 | 220 | HRW07030.1 Gfo/Idh/MocA family oxidoreductase [Caldilineaceae bacterium] | diamond | 717 | 92 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 27374221 | 27374221 | PRJNA980587_P_NODE_87683_length_245_cov_1.430233_g86890_i0 | PRJNA980587 | 87683 | 245 | 1.430233 | 3.50407085 | Candidatus Promineofilum glycogenicum | 3140687 | Bacteria | Bacteria | 50.1 | 9.93e-5 | NR | MBK7218797.1 | 3140687 | g86890 | i0 | 40.8 | 1.08979591836735 | 49 | 29 | 60 | 0 | 236 | 90 | 260 | 308 | MBK7218797.1 SDR family NAD(P)-dependent oxidoreductase [Candidatus Promineofilum glycogenicum] | diamond | 267 | 50.1 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Candidatus Promineofilum glycogenicum | ||
| 27626653 | 27626653 | PRJNA980587_P_NODE_56844_length_303_cov_1.334783_g56051_i0 | PRJNA980587 | 56844 | 303 | 1.334783 | 4.04439249 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 56.6 | 1.68e-7 | NR | HQL92975.1 | 2024896 | g56051 | i0 | 53.7 | 1.06930693069307 | 54 | 23 | 53.5 | 1 | 2 | 163 | 90 | 141 | HQL92975.1 cytidine deaminase [Anaerolineaceae bacterium] | diamond | 324 | 56.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27910407 | 27910407 | PRJNA980587_P_NODE_95685_length_240_cov_2.538922_g94892_i0 | PRJNA980587 | 95685 | 240 | 2.538922 | 6.0934128 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 89.7 | 3.4e-19 | NR | RIK40757.1 | 2026724 | g94892 | i0 | 50.6 | 4.9375 | 79 | 39 | 98.8 | 0 | 3 | 239 | 191 | 269 | RIK40757.1 MAG: NAD-dependent isocitrate dehydrogenase, partial [Chloroflexota bacterium] | diamond | 1185 | 89.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28447596 | 28447596 | PRJNA980587_P_NODE_69346_length_271_cov_1.530303_g68553_i0 | PRJNA980587 | 69346 | 271 | 1.530303 | 4.14712113 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 119 | 9.43e-31 | NR | MDH5695258.1 | 2026734 | g68553 | i0 | 65.8 | 1.68265682656827 | 76 | 26 | 84.1 | 0 | 228 | 1 | 2 | 77 | MDH5695258.1 S-methyl-5'-thioadenosine phosphorylase [Dehalococcoidia bacterium] | diamond | 456 | 119 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 28706240 | 28706240 | PRJNA980587_P_NODE_81187_length_249_cov_1.750000_g80394_i0 | PRJNA980587 | 81187 | 249 | 1.75 | 4.3575 | PVC group | 1783257 | Bacteria | Bacteria | 69.7 | 1.26e-11 | NR | MCL5273327.1 | 2026724 | g80394 | i0 | 50 | 9.49397590361446 | 60 | 30 | 72.3 | 0 | 191 | 12 | 697 | 756 | MCL5273327.1 ATP-dependent Clp protease ATP-binding subunit [Chloroflexota bacterium] | diamond | 2364 | 70.1 | 0.994293865905849 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28769174 | 28769174 | PRJNA980587_P_NODE_50487_length_323_cov_3.480000_g49694_i0 | PRJNA980587 | 50487 | 323 | 3.48 | 11.2404 | Bacteria | 2 | Bacteria | Bacteria | 52.4 | 3.89e-5 | NR | MBV9120483.1 | 2026724 | g49694 | i0 | 51.9 | 2.11764705882353 | 54 | 23 | 47.4 | 1 | 3 | 155 | 402 | 455 | MBV9120483.1 bifunctional rhamnulose-1-phosphate aldolase/short-chain dehydrogenase [Chloroflexota bacterium] | diamond | 684 | 52.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29552281 | 29552281 | PRJNA980587_P_NODE_67190_length_276_cov_1.226601_g66397_i0 | PRJNA980587 | 67190 | 276 | 1.226601 | 3.38541876 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 94.7 | 2.46e-20 | NR | MCC7365115.1 | 2026734 | g66397 | i0 | 45.6 | 0.978260869565217 | 90 | 47 | 97.8 | 1 | 270 | 1 | 44 | 131 | MCC7365115.1 ammonium transporter [Dehalococcoidia bacterium] | diamond | 270 | 94.7 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 29583758 | 29583758 | PRJNA980587_P_NODE_39850_length_370_cov_1.037037_g39057_i0 | PRJNA980587 | 39850 | 370 | 1.037037 | 3.8370369 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 128 | 2.57e-34 | NR | MDD5312135.1 | 2026734 | g39057 | i0 | 55.8 | 1.97027027027027 | 120 | 52 | 96.5 | 1 | 4 | 360 | 12 | 131 | MDD5312135.1 hypothetical protein [Dehalococcoidia bacterium] | diamond | 729 | 128 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 30026351 | 30026351 | PRJNA980587_P_NODE_89131_length_244_cov_1.801170_g88338_i0 | PRJNA980587 | 89131 | 244 | 1.80117 | 4.3948548 | Kouleothrix aurantiaca | 186479 | Bacteria | Bacteria | 162 | 9.08e-48 | NR | KPV54430.1 | 186479 | g88338 | i0 | 98.8 | 0.983606557377049 | 80 | 1 | 98.4 | 0 | 3 | 242 | 148 | 227 | KPV54430.1 hypothetical protein SE17_03815 [Kouleothrix aurantiaca] | diamond | 240 | 162 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix aurantiaca | ||
| 30563014 | 30563014 | PRJNA980587_P_NODE_69233_length_271_cov_1.737374_g68440_i0 | PRJNA980587 | 69233 | 271 | 1.737374 | 4.70828354 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 63.5 | 1.17e-9 | NR | MFN2269912.1 | 2052143 | g68440 | i0 | 46.1 | 3 | 89 | 42 | 94.1 | 3 | 1 | 255 | 113 | 199 | MFN2269912.1 rhomboid family intramembrane serine protease [Anaerolineae bacterium] | diamond | 813 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30980377 | 30980377 | PRJNA980587_P_NODE_59574_length_295_cov_1.040541_g58781_i0 | PRJNA980587 | 59574 | 295 | 1.040541 | 3.06959595 | Bacteria | 2 | Bacteria | Bacteria | 111 | 4.630000000000001e-27 | NR | RLT36101.1 | 2026724 | g58781 | i0 | 60 | 2.90847457627119 | 95 | 37 | 95.6 | 1 | 12 | 293 | 68 | 162 | RLT36101.1 MAG: dephospho-CoA kinase [Chloroflexota bacterium] | diamond | 858 | 112 | 0.991071428571429 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31226728 | 31226728 | PRJNA980587_P_NODE_71955_length_265_cov_1.604167_g71162_i0 | PRJNA980587 | 71955 | 265 | 1.604167 | 4.25104255 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 53.5 | 7.48e-6 | NR | MEN4042535.1 | 2024896 | g71162 | i0 | 79.3 | 0.792452830188679 | 29 | 6 | 32.8 | 0 | 175 | 261 | 120 | 148 | MEN4042535.1 NBR1-Ig-like domain-containing protein [Anaerolineaceae bacterium] | diamond | 210 | 53.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 31353448 | 31353448 | PRJNA980587_P_NODE_84296_length_247_cov_1.770115_g83503_i0 | PRJNA980587 | 84296 | 247 | 1.770115 | 4.37218405 | Oscillochloris sp. | 2547424 | Bacteria | Bacteria | 86.7 | 2.36e-18 | NR | NTW01750.1 | 2547424 | g83503 | i0 | 48.2 | 3.02429149797571 | 83 | 42 | 99.6 | 1 | 1 | 246 | 172 | 254 | NTW01750.1 hypothetical protein [Oscillochloris sp.] | diamond | 747 | 86.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Oscillochloridaceae | Oscillochloris | Oscillochloris sp. | ||
| 31353452 | 31353452 | PRJNA980587_P_NODE_96456_length_228_cov_3.922581_g95663_i0 | PRJNA980587 | 96456 | 228 | 3.922581 | 8.94348468 | Caldilineaceae bacterium SB0665_bin_25 | 2605262 | Bacteria | Bacteria | 43.9 | 0.0119 | NR | MXZ22325.1 | 2605262 | g95663 | i0 | 36.4 | 1.72368421052632 | 66 | 33 | 86.8 | 3 | 205 | 8 | 381 | 437 | MXZ22325.1 DEAD/DEAH box helicase [Caldilineaceae bacterium SB0665_bin_25] | diamond | 393 | 43.9 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium SB0665_bin_25 | |||
| 31448326 | 31448326 | PRJNA980587_P_NODE_57976_length_299_cov_2.672566_g57183_i0 | PRJNA980587 | 57976 | 299 | 2.672566 | 7.99097234 | Thermoflexales bacterium | 2497639 | Bacteria | Bacteria | 134 | 6.959999999999999e-35 | NR | CAG0927520.1 | 2497639 | g57183 | i0 | 66.3 | 1.96655518394649 | 98 | 33 | 98.3 | 0 | 297 | 4 | 300 | 397 | CAG0927520.1 taurine---2-oxoglutarate transaminase [Thermoflexales bacterium] | diamond | 588 | 134 | 1 | Bacteria | Bacillati | Chloroflexota | Thermoflexia | Thermoflexales | Thermoflexales bacterium | ||||
| 32118802 | 32118802 | PRJNA980587_P_NODE_57838_length_300_cov_1.295154_g57045_i0 | PRJNA980587 | 57838 | 300 | 1.295154 | 3.885462 | Bacteria | 2 | Bacteria | Bacteria | 107 | 5.470000000000001e-26 | NR | RMG89386.1 | 2026724 | g57045 | i0 | 59.3 | 18.71 | 81 | 33 | 81 | 0 | 244 | 2 | 1 | 81 | RMG89386.1 MAG: S-methyl-5'-thioadenosine phosphorylase [Chloroflexota bacterium] | diamond | 5613 | 107 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32150416 | 32150416 | PRJNA980587_P_NODE_78658_length_251_cov_0.865169_g77865_i0 | PRJNA980587 | 78658 | 251 | 0.865169 | 2.17157419 | Bacteria | 2 | Bacteria | Bacteria | 64.3 | 4.24e-10 | NR | OGO60398.1 | 1797666 | g77865 | i0 | 54.7 | 5.12749003984064 | 53 | 24 | 63.3 | 0 | 1 | 159 | 177 | 229 | OGO60398.1 MAG: 50S ribosomal protein L1 [Chloroflexi bacterium RBG_19FT_COMBO_48_23] | diamond | 1287 | 64.7 | 0.993817619783617 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium RBG_19FT_COMBO_48_23 | ||||||
| 32681281 | 32681281 | PRJNA980587_P_NODE_72320_length_264_cov_1.759162_g71527_i0 | PRJNA980587 | 72320 | 264 | 1.759162 | 4.64418768 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 43.1 | 0.0321 | NR | UCG83687.1 | 2026734 | g71527 | i0 | 32.5 | 0.875 | 77 | 47 | 81.8 | 1 | 226 | 11 | 95 | 171 | UCG83687.1 MAG: dissimilatory-type sulfite reductase subunit alpha, partial [Dehalococcoidia bacterium] | diamond | 231 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 32744674 | 32744674 | PRJNA980587_P_NODE_75560_length_257_cov_1.429348_g74767_i0 | PRJNA980587 | 75560 | 257 | 1.429348 | 3.67342436 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.5 | 0.0238 | NR | TMG68759.1 | 2026724 | g74767 | i0 | 35 | 0.700389105058366 | 60 | 33 | 70 | 1 | 189 | 10 | 462 | 515 | TMG68759.1 MAG: glycosyltransferase [Chloroflexota bacterium] | diamond | 180 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32901822 | 32901822 | PRJNA980587_P_NODE_90060_length_244_cov_0.900585_g89267_i0 | PRJNA980587 | 90060 | 244 | 0.900585 | 2.1974274 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 95.1 | 6.95e-21 | NR | MBN1262489.1 | 2052143 | g89267 | i0 | 55 | 1.9672131147541 | 80 | 36 | 98.4 | 0 | 3 | 242 | 32 | 111 | MBN1262489.1 pyridoxal phosphate-dependent aminotransferase [Anaerolineae bacterium] | diamond | 480 | 95.1 | 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);;