contig_metadata
21 rows where bioproject = "PRJNA195897", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28179108 | 28179108 | PRJNA195897_P_NODE_11686_length_164_cov_0.895652_g11653_i0 | PRJNA195897 | 11686 | 164 | 0.895652 | 1.46886928 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 109 | 3.22e-26 | NR | MEY3725784.1 | 2026724 | g11653 | i0 | 98.1 | 1.97560975609756 | 54 | 1 | 98.8 | 0 | 162 | 1 | 206 | 259 | MEY3725784.1 hypothetical protein [Chloroflexota bacterium] | diamond | 324 | 109 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28386552 | 28386552 | PRJNA195897_P_NODE_4526_length_225_cov_1.613636_g4493_i0 | PRJNA195897 | 4526 | 225 | 1.613636 | 3.630681 | Bacteria | 2 | Bacteria | Bacteria | 83.2 | 2.13e-18 | NR | HHH82258.1 | 2026724 | g4493 | i0 | 55.6 | 12.08 | 72 | 29 | 93.3 | 2 | 220 | 11 | 60 | 130 | HHH82258.1 glycine cleavage system protein GcvH [Chloroflexota bacterium] | diamond | 2718 | 83.6 | 0.995215311004785 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28495271 | 28495271 | PRJNA195897_P_NODE_5587_length_205_cov_1.666667_g5554_i0 | PRJNA195897 | 5587 | 205 | 1.666667 | 3.41666735 | Ardenticatenaceae bacterium | 2614247 | Bacteria | Bacteria | 50.4 | 4.19e-5 | NR | MCB8943027.1 | 2614247 | g5554 | i0 | 43.8 | 0.936585365853659 | 64 | 33 | 89.3 | 2 | 200 | 18 | 195 | 258 | MCB8943027.1 hypothetical protein [Ardenticatenaceae bacterium] | diamond | 192 | 50.4 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Ardenticatenales | Ardenticatenaceae | Ardenticatenaceae bacterium | |||
| 28842281 | 28842281 | PRJNA195897_P_NODE_6388_length_195_cov_1.068493_g6355_i0 | PRJNA195897 | 6388 | 195 | 1.068493 | 2.08356135 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 42.7 | 0.00509 | NR | MBI3953777.1 | 2026724 | g6355 | i0 | 48.8 | 0.630769230769231 | 41 | 21 | 63.1 | 0 | 8 | 130 | 59 | 99 | MBI3953777.1 spermidine synthase [Chloroflexota bacterium] | diamond | 123 | 42.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28842282 | 28842282 | PRJNA195897_P_NODE_768_length_621_cov_2.250000_g738_i0 | PRJNA195897 | 768 | 621 | 2.25 | 13.9725 | Ktedonosporobacter rubrisoli | 2509675 | Bacteria | Bacteria | 181 | 4.46e-53 | NR | WP_207229223.1 | 2509675 | g738 | i0 | 49.4 | 0.859903381642512 | 178 | 86 | 84.1 | 2 | 8 | 529 | 59 | 236 | WP_207229223.1 sulfotransferase family protein [Ktedonosporobacter rubrisoli] | diamond | 534 | 181 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonosporobacteraceae | Ktedonosporobacter | Ktedonosporobacter rubrisoli | ||
| 29032105 | 29032105 | PRJNA195897_P_NODE_6748_length_191_cov_0.978873_g6715_i0 | PRJNA195897 | 6748 | 191 | 0.978873 | 1.86964743 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 46.2 | 9.98e-4 | NR | MFC1914352.1 | 2026724 | g6715 | i0 | 58.3 | 1.69633507853403 | 36 | 15 | 56.5 | 0 | 83 | 190 | 191 | 226 | MFC1914352.1 SDR family NAD(P)-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 324 | 46.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29568564 | 29568564 | PRJNA195897_P_NODE_2270_length_336_cov_0.857143_g2237_i0 | PRJNA195897 | 2270 | 336 | 0.857143 | 2.88000048 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 75.1 | 2.95e-14 | NR | MFN2285900.1 | 2052143 | g2237 | i0 | 42.5 | 1.55357142857143 | 87 | 46 | 77.7 | 1 | 75 | 335 | 36 | 118 | MFN2285900.1 leucine-rich repeat domain-containing protein [Anaerolineae bacterium] | diamond | 522 | 75.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 29649176 | 29649176 | PRJNA195897_P_NODE_3830_length_246_cov_1.675127_g3797_i0 | PRJNA195897 | 3830 | 246 | 1.675127 | 4.12081242 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 107 | 6.590000000000001e-27 | NR | MEP6638151.1 | 2026724 | g3797 | i0 | 64.9 | 10.3170731707317 | 77 | 27 | 93.9 | 0 | 231 | 1 | 102 | 178 | MEP6638151.1 peptide-methionine (S)-S-oxide reductase MsrA [Chloroflexota bacterium] | diamond | 2538 | 107 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29884571 | 29884571 | PRJNA195897_P_NODE_7931_length_178_cov_1.209302_g7898_i0 | PRJNA195897 | 7931 | 178 | 1.209302 | 2.15255756 | Aggregatilineaceae bacterium | 2952881 | Bacteria | Bacteria | 53.9 | 1.5e-6 | NR | HEX3049482.1 | 2952881 | g7898 | i0 | 47.1 | 5.89887640449438 | 51 | 27 | 86 | 0 | 153 | 1 | 150 | 200 | HEX3049482.1 SDR family oxidoreductase [Aggregatilineaceae bacterium] | diamond | 1050 | 53.9 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Aggregatilineaceae | Aggregatilineaceae bacterium | |||
| 29916178 | 29916178 | PRJNA195897_P_NODE_6671_length_192_cov_0.958042_g6638_i0 | PRJNA195897 | 6671 | 192 | 0.958042 | 1.83944064 | Candidatus Avedoeria danica | 3140675 | Bacteria | Bacteria | 55.8 | 4.38e-7 | NR | MBK6768399.1 | 3140675 | g6638 | i0 | 48.3 | 0.9375 | 60 | 26 | 92.2 | 2 | 178 | 2 | 285 | 340 | MBK6768399.1 hypothetical protein [Candidatus Avedoeria danica] | diamond | 180 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Epilineales | Candidatus Epilineaceae | Candidatus Avedoeria | Candidatus Avedoeria danica | ||
| 29997104 | 29997104 | PRJNA195897_P_NODE_3131_length_278_cov_1.039301_g3098_i0 | PRJNA195897 | 3131 | 278 | 1.039301 | 2.88925678 | Bacteria | 2 | Bacteria | Bacteria | 100 | 1.1200000000000001e-22 | NR | MCH8063082.1 | 2026724 | g3098 | i0 | 52.7 | 3.92805755395683 | 91 | 42 | 97.1 | 1 | 270 | 1 | 269 | 359 | MCH8063082.1 dipeptidase [Chloroflexota bacterium] | diamond | 1092 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30516264 | 30516264 | PRJNA195897_P_NODE_4973_length_216_cov_1.209581_g4940_i0 | PRJNA195897 | 4973 | 216 | 1.209581 | 2.61269496 | Ktedonobacterales bacterium | 2306968 | Bacteria | Bacteria | 70.1 | 5.01e-12 | NR | HEX9056245.1 | 2306968 | g4940 | i0 | 63.6 | 0.763888888888889 | 55 | 20 | 76.4 | 0 | 51 | 215 | 31 | 85 | HEX9056245.1 class I SAM-dependent methyltransferase [Ktedonobacterales bacterium] | diamond | 165 | 70.1 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacterales bacterium | ||||
| 30769142 | 30769142 | PRJNA195897_P_NODE_6114_length_198_cov_1.744966_g6081_i0 | PRJNA195897 | 6114 | 198 | 1.744966 | 3.45503268 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 62.8 | 1.45e-9 | NR | HEY8173535.1 | 2026734 | g6081 | i0 | 49.2 | 0.984848484848485 | 65 | 30 | 98.5 | 1 | 196 | 2 | 55 | 116 | HEY8173535.1 oxidoreductase [Dehalococcoidia bacterium] | diamond | 195 | 62.8 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 31685667 | 31685667 | PRJNA195897_P_NODE_1517_length_427_cov_1.394180_g1484_i0 | PRJNA195897 | 1517 | 427 | 1.39418 | 5.9531486 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 128 | 3.56e-31 | NR | HEX2623445.1 | 3069543 | g1484 | i0 | 49.6 | 0.990632318501171 | 141 | 66 | 99.1 | 2 | 3 | 425 | 403 | 538 | HEX2623445.1 S8 family serine peptidase [Phototrophicaceae bacterium] | diamond | 423 | 128 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 31766814 | 31766814 | PRJNA195897_P_NODE_2917_length_289_cov_1.250000_g2884_i0 | PRJNA195897 | 2917 | 289 | 1.25 | 3.6125 | Chloroflexota | 200795 | Bacteria | Bacteria | 117 | 6.94e-30 | NR | MFO7683302.1 | 2026724 | g2884 | i0 | 63.5 | 9.79930795847751 | 85 | 31 | 88.2 | 0 | 3 | 257 | 205 | 289 | MFO7683302.1 MaoC/PaaZ C-terminal domain-containing protein [Chloroflexota bacterium] | diamond | 2832 | 118 | 0.991525423728814 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31812368 | 31812368 | PRJNA195897_P_NODE_817_length_598_cov_2.122040_g787_i0 | PRJNA195897 | 817 | 598 | 2.12204 | 12.6897992 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 121 | 5.46e-28 | NR | MDQ2809526.1 | 2026724 | g787 | i0 | 37.7 | 0.75752508361204 | 151 | 94 | 75.8 | 0 | 9 | 461 | 1033 | 1183 | MDQ2809526.1 choice-of-anchor A family protein [Chloroflexota bacterium] | diamond | 453 | 121 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31938746 | 31938746 | PRJNA195897_P_NODE_11677_length_164_cov_0.904348_g11644_i0 | PRJNA195897 | 11677 | 164 | 0.904348 | 1.48313072 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 63.2 | 7.9e-10 | NR | MBA2393284.1 | 2740538 | g11644 | i0 | 52.8 | 1.9390243902439 | 53 | 25 | 97 | 0 | 1 | 159 | 62 | 114 | MBA2393284.1 hypothetical protein [Ktedonobacteraceae bacterium] | diamond | 318 | 63.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 31970479 | 31970479 | PRJNA195897_P_NODE_5878_length_201_cov_2.085526_g5845_i0 | PRJNA195897 | 5878 | 201 | 2.085526 | 4.19190726 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 41.6 | 0.0204 | NR | MFO7540512.1 | 2026724 | g5845 | i0 | 39.6 | 0.791044776119403 | 53 | 30 | 76.1 | 1 | 32 | 184 | 14 | 66 | MFO7540512.1 hypothetical protein [Chloroflexota bacterium] | diamond | 159 | 41.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32160563 | 32160563 | PRJNA195897_P_NODE_5798_length_202_cov_2.483660_g5765_i0 | PRJNA195897 | 5798 | 202 | 2.48366 | 5.0169932 | Chloroflexi bacterium SZAS-1 | 2807729 | Bacteria | Bacteria | 70.9 | 2.51e-12 | NR | MBS1964903.1 | 2807729 | g5765 | i0 | 51.6 | 2.76237623762376 | 62 | 29 | 92.1 | 1 | 186 | 1 | 318 | 378 | MBS1964903.1 NAD(P)-binding domain-containing protein [Chloroflexi bacterium SZAS-1] | diamond | 558 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium SZAS-1 | ||||||
| 32603184 | 32603184 | PRJNA195897_P_NODE_3160_length_276_cov_1.348018_g3127_i0 | PRJNA195897 | 3160 | 276 | 1.348018 | 3.72052968 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 98.2 | 1.04e-21 | NR | HKZ69169.1 | 2073117 | g3127 | i0 | 55.4 | 1 | 92 | 36 | 95.7 | 2 | 271 | 8 | 34 | 124 | HKZ69169.1 fumarylacetoacetase [Anaerolineales bacterium] | diamond | 276 | 98.2 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 32729154 | 32729154 | PRJNA195897_P_NODE_4920_length_217_cov_1.178571_g4887_i0 | PRJNA195897 | 4920 | 217 | 1.178571 | 2.55749907 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 77.8 | 1.85e-16 | NR | MFC2035475.1 | 2026724 | g4887 | i0 | 58 | 0.953917050691244 | 69 | 29 | 95.4 | 0 | 10 | 216 | 48 | 116 | MFC2035475.1 50S ribosomal protein L17 [Chloroflexota bacterium] | diamond | 207 | 77.8 | 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);;