contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10935113 | 10935113 | PRJNA753704_P_NODE_24709_length_250_cov_0.881356_g24348_i0 | PRJNA753704 | 24709 | 250 | 0.881356 | 2.20339 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 111 | 1.21e-26 | NR | MCC6454279.1 | 2614250 | g24348 | i0 | 73.3 | 1.836 | 75 | 20 | 90 | 0 | 245 | 21 | 220 | 294 | MCC6454279.1 peptidylprolyl isomerase [Caldilineaceae bacterium] | diamond | 459 | 111 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 19053808 | 19053808 | PRJNA753704_P_NODE_24795_length_250_cov_0.881356_g24434_i0 | PRJNA753704 | 24795 | 250 | 0.881356 | 2.20339 | Chloroflexi bacterium 13_1_2 | 1805063 | Bacteria | Bacteria | 76.3 | 6.17e-16 | NR | OLD63741.1 | 1805063 | g24434 | i0 | 52.9 | 0.84 | 70 | 32 | 84 | 1 | 246 | 37 | 23 | 91 | OLD63741.1 MAG: hypothetical protein AUF65_01150 [Chloroflexi bacterium 13_1_20CM_50_12] | diamond | 210 | 76.3 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexi bacterium 13_1_20CM_50_12 | ||||||
| 26831452 | 26831452 | PRJNA753704_P_NODE_27361_length_244_cov_0.912281_g27000_i0 | PRJNA753704 | 27361 | 244 | 0.912281 | 2.22596564 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 95.5 | 1.08e-21 | NR | MCW1971027.1 | 2052143 | g27000 | i0 | 48.3 | 1.06967213114754 | 87 | 39 | 99.6 | 1 | 244 | 2 | 69 | 155 | MCW1971027.1 hypothetical protein [Anaerolineae bacterium] | diamond | 261 | 95.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27210747 | 27210747 | PRJNA753704_P_NODE_6902_length_440_cov_4.087193_g6541_i0 | PRJNA753704 | 6902 | 440 | 4.087193 | 17.9836492 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 105 | 9.409999999999999e-25 | NR | MDR3573577.1 | 2024896 | g6541 | i0 | 47.7 | 0.756818181818182 | 111 | 56 | 75.7 | 1 | 439 | 107 | 134 | 242 | MDR3573577.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 333 | 105 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27337492 | 27337492 | PRJNA753704_P_NODE_22763_length_256_cov_2.404372_g22402_i0 | PRJNA753704 | 22763 | 256 | 2.404372 | 6.15519232 | Bellilinea sp. | 2838785 | Bacteria | Bacteria | 89 | 2.43e-18 | NR | MEN4013721.1 | 2838785 | g22402 | i0 | 51.4 | 0.8671875 | 74 | 36 | 86.7 | 0 | 222 | 1 | 163 | 236 | MEN4013721.1 S8 family serine peptidase [Bellilinea sp.] | diamond | 222 | 89 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Bellilinea | Bellilinea sp. | ||
| 27874158 | 27874158 | PRJNA753704_P_NODE_25705_length_248_cov_0.891429_g25344_i0 | PRJNA753704 | 25705 | 248 | 0.891429 | 2.21074392 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 154 | 5.62e-42 | NR | MDH4141024.1 | 2026724 | g25344 | i0 | 89 | 0.991935483870968 | 82 | 9 | 99.2 | 0 | 1 | 246 | 425 | 506 | MDH4141024.1 hypothetical protein [Chloroflexota bacterium] | diamond | 246 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28884463 | 28884463 | PRJNA753704_P_NODE_25688_length_248_cov_0.891429_g25327_i0 | PRJNA753704 | 25688 | 248 | 0.891429 | 2.21074392 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 80.5 | 1.3e-17 | NR | MFN2200815.1 | 2614250 | g25327 | i0 | 50.6 | 0.955645161290323 | 79 | 35 | 95.6 | 1 | 1 | 237 | 18 | 92 | MFN2200815.1 DUF5132 domain-containing protein [Caldilineaceae bacterium] | diamond | 237 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28915850 | 28915850 | PRJNA753704_P_NODE_18728_length_280_cov_1.246377_g18367_i0 | PRJNA753704 | 18728 | 280 | 1.246377 | 3.4898556 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 98.6 | 1.4500000000000002e-21 | NR | HEX6288077.1 | 2720503 | g18367 | i0 | 56.3 | 0.857142857142857 | 80 | 35 | 85.7 | 0 | 279 | 40 | 1925 | 2004 | HEX6288077.1 non-ribosomal peptide synthase/polyketide synthase [Herpetosiphonaceae bacterium] | diamond | 240 | 98.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 29494298 | 29494298 | PRJNA753704_P_NODE_28530_length_242_cov_0.923077_g28169_i0 | PRJNA753704 | 28530 | 242 | 0.923077 | 2.23384634 | root | 1 | Root_unresolved | Root_unresolved | 55.8 | 6.64e-7 | NR | HOH21690.1 | 2024896 | g28169 | i0 | 46.1 | 1.88429752066116 | 76 | 38 | 93 | 2 | 17 | 241 | 51 | 124 | HOH21690.1 hypothetical protein [Anaerolineaceae bacterium] | diamond | 456 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 30115979 | 30115979 | PRJNA753704_P_NODE_18132_length_284_cov_1.265403_g17771_i0 | PRJNA753704 | 18132 | 284 | 1.265403 | 3.59374452 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 56.2 | 1.12e-6 | NR | NOZ30064.1 | 2026724 | g17771 | i0 | 40 | 0.792253521126761 | 75 | 43 | 77.1 | 1 | 271 | 53 | 443 | 517 | NOZ30064.1 tetratricopeptide repeat protein [Chloroflexota bacterium] | diamond | 225 | 56.2 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30748040 | 30748040 | PRJNA753704_P_NODE_12334_length_338_cov_2.569811_g11973_i0 | PRJNA753704 | 12334 | 338 | 2.569811 | 8.68596118 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 99.8 | 1.47e-23 | NR | MCU0495311.1 | 2562117 | g11973 | i0 | 64.4 | 0.772189349112426 | 87 | 31 | 77.2 | 0 | 76 | 336 | 42 | 128 | MCU0495311.1 DUF2809 domain-containing protein [Chloroflexaceae bacterium] | diamond | 261 | 99.8 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 30779608 | 30779608 | PRJNA753704_P_NODE_26374_length_246_cov_1.768786_g26013_i0 | PRJNA753704 | 26374 | 246 | 1.768786 | 4.35121356 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 57 | 3.71e-7 | NR | HEY9075989.1 | 2024896 | g26013 | i0 | 44.8 | 0.707317073170732 | 58 | 32 | 70.7 | 0 | 6 | 179 | 70 | 127 | HEY9075989.1 sortase [Anaerolineaceae bacterium] | diamond | 174 | 57 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 32044407 | 32044407 | PRJNA753704_P_NODE_27078_length_245_cov_0.906977_g26717_i0 | PRJNA753704 | 27078 | 245 | 0.906977 | 2.22209365 | Caldilinea sp. CFX5 | 2293554 | Bacteria | Bacteria | 47.4 | 8.89e-4 | NR | MCE7983218.1 | 2293554 | g26717 | i0 | 43.2 | 0.991836734693878 | 81 | 35 | 99.2 | 2 | 244 | 2 | 70 | 139 | MCE7983218.1 M23 family peptidase [Caldilinea sp. CFX5] | diamond | 243 | 47.4 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilinea | Caldilinea sp. CFX5 | ||
| 32234529 | 32234529 | PRJNA753704_P_NODE_13778_length_321_cov_2.758065_g13417_i0 | PRJNA753704 | 13778 | 321 | 2.758065 | 8.85338865 | Candidatus Promineifilaceae bacterium | 3085104 | Bacteria | Bacteria | 70.9 | 1.11e-11 | NR | MDX1616302.1 | 3085104 | g13417 | i0 | 42.3 | 1.42056074766355 | 78 | 39 | 72.9 | 1 | 270 | 37 | 53 | 124 | MDX1616302.1 tyrosinase family protein [Candidatus Promineifilaceae bacterium] | diamond | 456 | 70.9 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilaceae bacterium | |||
| 32865552 | 32865552 | PRJNA753704_P_NODE_26640_length_246_cov_0.901734_g26279_i0 | PRJNA753704 | 26640 | 246 | 0.901734 | 2.21826564 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 68.6 | 3.08e-11 | NR | MCB0083329.1 | 2614250 | g26279 | i0 | 50.6 | 1.97560975609756 | 81 | 35 | 92.7 | 2 | 236 | 9 | 351 | 431 | MCB0083329.1 hypothetical protein [Caldilineaceae bacterium] | diamond | 486 | 68.6 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 32896890 | 32896890 | PRJNA753704_P_NODE_14820_length_311_cov_1.592437_g14459_i0 | PRJNA753704 | 14820 | 311 | 1.592437 | 4.95247907 | Thermosporothrix hazakensis | 644383 | Bacteria | Bacteria | 78.2 | 1.47e-14 | NR | WP_111323242.1 | 644383 | g14459 | i0 | 42.9 | 0.877813504823151 | 91 | 46 | 82 | 3 | 311 | 57 | 142 | 232 | WP_111323242.1 trypsin-like serine peptidase [Thermosporothrix hazakensis] | diamond | 273 | 78.2 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Thermosporotrichaceae | Thermosporothrix | Thermosporothrix hazakensis |
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);;