contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1749810 | 1749810 | PRJNA493828_P_NODE_40622_length_238_cov_3.266667_g40203_i0 | PRJNA493828 | 40622 | 238 | 3.266667 | 7.77466746 | Caldilineales bacterium | 2306055 | Bacteria | Bacteria | 127 | 5.489999999999999e-32 | NR | MCS6843764.1 | 2306055 | g40203 | i0 | 72.2 | 1.99159663865546 | 79 | 22 | 99.6 | 0 | 237 | 1 | 62 | 140 | MCS6843764.1 bifunctional ADP-dependent NAD(P)H-hydrate dehydratase/NAD(P)H-hydrate epimerase [Caldilineales bacterium] | diamond | 474 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineales bacterium | ||||
| 8127766 | 8127766 | PRJNA493828_P_NODE_29347_length_258_cov_1.318919_g28928_i0 | PRJNA493828 | 29347 | 258 | 1.318919 | 3.40281102 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 137 | 2.07e-37 | NR | MFL5801572.1 | 2762507 | g28928 | i0 | 77.6 | 5.91860465116279 | 85 | 19 | 98.8 | 0 | 256 | 2 | 64 | 148 | MFL5801572.1 arginase [Roseiflexaceae bacterium] | diamond | 1527 | 137 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 9402964 | 9402964 | PRJNA493828_P_NODE_48088_length_199_cov_4.880952_g47669_i0 | PRJNA493828 | 48088 | 199 | 4.880952 | 9.71309448 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 132 | 8.83e-36 | NR | MDQ4044571.1 | 2026724 | g47669 | i0 | 95.5 | 1.98994974874372 | 66 | 3 | 99.5 | 0 | 1 | 198 | 170 | 235 | MDQ4044571.1 FAD-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 396 | 132 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 11309769 | 11309769 | PRJNA493828_P_NODE_38409_length_242_cov_3.236686_g37990_i0 | PRJNA493828 | 38409 | 242 | 3.236686 | 7.83278012 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 109 | 5.96e-26 | NR | MCC6178410.1 | 2026724 | g37990 | i0 | 88.1 | 2.92561983471074 | 59 | 7 | 73.1 | 0 | 179 | 3 | 1 | 59 | MCC6178410.1 glycosyltransferase family 4 protein [Chloroflexota bacterium] | diamond | 708 | 109 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 22151444 | 22151444 | PRJNA493828_P_NODE_40718_length_238_cov_2.551515_g40299_i0 | PRJNA493828 | 40718 | 238 | 2.551515 | 6.0726057 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 155 | 1.0699999999999998e-41 | NR | HRI56924.1 | 2052143 | g40299 | i0 | 93.6 | 2.94957983193277 | 78 | 5 | 98.3 | 0 | 237 | 4 | 794 | 871 | HRI56924.1 SUMF1/EgtB/PvdO family nonheme iron enzyme [Anaerolineae bacterium] | diamond | 702 | 155 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 23427280 | 23427280 | PRJNA493828_P_NODE_38399_length_242_cov_3.295858_g37980_i0 | PRJNA493828 | 38399 | 242 | 3.295858 | 7.97597636 | Roseiflexaceae | 1508635 | Bacteria | Bacteria | 157 | 6.18e-46 | NR | WP_409571240.1 | 2779161 | g37980 | i0 | 96.3 | 2.97520661157025 | 80 | 3 | 99.2 | 0 | 3 | 242 | 148 | 227 | WP_409571240.1 30S ribosomal protein S3 [Kouleothrix sp.] | diamond | 720 | 157 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix sp. | ||
| 24700731 | 24700731 | PRJNA493828_P_NODE_33940_length_248_cov_2.720000_g33521_i0 | PRJNA493828 | 33940 | 248 | 2.72 | 6.7456 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 136 | 2.34e-35 | NR | HEU4326261.1 | 2762507 | g33521 | i0 | 76.5 | 0.979838709677419 | 81 | 18 | 98 | 1 | 248 | 6 | 300 | 379 | HEU4326261.1 alpha-amylase family glycosyl hydrolase [Roseiflexaceae bacterium] | diamond | 243 | 136 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 26601821 | 26601821 | PRJNA493828_P_NODE_45761_length_213_cov_4.028571_g45342_i0 | PRJNA493828 | 45761 | 213 | 4.028571 | 8.58085623 | Candidatus Limnocylindria bacterium | 3047546 | Bacteria | Bacteria | 116 | 8.9e-29 | NR | HEX7196025.1 | 3047546 | g45342 | i0 | 73.9 | 0.971830985915493 | 69 | 18 | 97.2 | 0 | 212 | 6 | 58 | 126 | HEX7196025.1 hypothetical protein [Candidatus Limnocylindria bacterium] | diamond | 207 | 116 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Limnocylindria | Candidatus Limnocylindria bacterium | |||||
| 28940275 | 28940275 | PRJNA493828_P_NODE_19508_length_289_cov_2.157407_g19089_i0 | PRJNA493828 | 19508 | 289 | 2.157407 | 6.23490623 | Kouleothrix aurantiaca | 186479 | Bacteria | Bacteria | 148 | 4.0999999999999994e-44 | NR | KPV52618.1 | 186479 | g19089 | i0 | 100 | 0.86159169550173 | 83 | 0 | 86.2 | 0 | 39 | 287 | 1 | 83 | KPV52618.1 hypothetical protein SE17_14405 [Kouleothrix aurantiaca] | diamond | 249 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix aurantiaca | ||
| 29634321 | 29634321 | PRJNA493828_P_NODE_29970_length_256_cov_1.934426_g29551_i0 | PRJNA493828 | 29970 | 256 | 1.934426 | 4.95213056 | Kouleothrix sp. | 2779161 | Bacteria | Bacteria | 99.4 | 5.34e-23 | NR | WP_409568729.1 | 2779161 | g29551 | i0 | 100 | 0.62109375 | 53 | 0 | 62.1 | 0 | 97 | 255 | 1 | 53 | WP_409568729.1 F0F1 ATP synthase subunit gamma [Kouleothrix sp.] | diamond | 159 | 99.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix sp. | ||
| 29665907 | 29665907 | PRJNA493828_P_NODE_32990_length_250_cov_0.870056_g32571_i0 | PRJNA493828 | 32990 | 250 | 0.870056 | 2.17514 | Chloroflexia bacterium | 2448782 | Bacteria | Bacteria | 122 | 2.43e-32 | NR | HET7078539.1 | 2448782 | g32571 | i0 | 75 | 0.96 | 80 | 20 | 96 | 0 | 1 | 240 | 183 | 262 | HET7078539.1 hypothetical protein [Chloroflexia bacterium] | diamond | 240 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexia bacterium | |||||
| 30393298 | 30393298 | PRJNA493828_P_NODE_33213_length_249_cov_2.284091_g32794_i0 | PRJNA493828 | 33213 | 249 | 2.284091 | 5.68738659 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 100 | 1.9e-22 | NR | HEX2990881.1 | 2073117 | g32794 | i0 | 53.7 | 0.987951807228916 | 82 | 37 | 98.8 | 1 | 248 | 3 | 478 | 558 | HEX2990881.1 PAS domain-containing protein [Anaerolineales bacterium] | diamond | 246 | 100 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 30613890 | 30613890 | PRJNA493828_P_NODE_18173_length_295_cov_3.333333_g17754_i0 | PRJNA493828 | 18173 | 295 | 3.333333 | 9.83333235 | Kouleothrix sp. | 2779161 | Bacteria | Bacteria | 160 | 1.34e-46 | NR | WP_409573587.1 | 2779161 | g17754 | i0 | 76 | 1.95254237288136 | 96 | 23 | 97.6 | 0 | 295 | 8 | 89 | 184 | WP_409573587.1 class I SAM-dependent methyltransferase [Kouleothrix sp.] | diamond | 576 | 160 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Kouleothrix | Kouleothrix sp. | ||
| 30708706 | 30708706 | PRJNA493828_P_NODE_9954_length_361_cov_3.381944_g9536_i0 | PRJNA493828 | 9954 | 361 | 3.381944 | 12.20881784 | Anaerolineales bacterium | 2073117 | Bacteria | Bacteria | 65.1 | 1.85e-10 | NR | MCA9983625.1 | 2073117 | g9536 | i0 | 38.6 | 0.731301939058172 | 88 | 53 | 73.1 | 1 | 274 | 11 | 1 | 87 | MCA9983625.1 hypothetical protein [Anaerolineales bacterium] | diamond | 264 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineales bacterium | ||||
| 31815276 | 31815276 | PRJNA493828_P_NODE_15537_length_310_cov_2.919831_g15118_i0 | PRJNA493828 | 15537 | 310 | 2.919831 | 9.0514761 | Promineifilum sp. | 2664178 | Bacteria | Bacteria | 82.8 | 5.44e-16 | NR | HRO24312.1 | 2664178 | g15118 | i0 | 87.8 | 1.42258064516129 | 49 | 6 | 47.4 | 0 | 1 | 147 | 44 | 92 | HRO24312.1 hypothetical protein [Promineifilum sp.] | diamond | 441 | 82.8 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Promineifilum sp. | ||
| 32511684 | 32511684 | PRJNA493828_P_NODE_28519_length_260_cov_1.620321_g28100_i0 | PRJNA493828 | 28519 | 260 | 1.620321 | 4.2128346 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 89.7 | 1.35e-18 | NR | HEX9370336.1 | 2762507 | g28100 | i0 | 55.4 | 1.06153846153846 | 92 | 34 | 98.1 | 1 | 255 | 1 | 215 | 306 | HEX9370336.1 glycosyltransferase family 39 protein [Roseiflexaceae bacterium] | diamond | 276 | 89.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 32794771 | 32794771 | PRJNA493828_P_NODE_34840_length_247_cov_1.672414_g34421_i0 | PRJNA493828 | 34840 | 247 | 1.672414 | 4.13086258 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 148 | 3.04e-40 | NR | HEU5098900.1 | 2762507 | g34421 | i0 | 94.8 | 1.87044534412955 | 77 | 4 | 93.5 | 0 | 246 | 16 | 151 | 227 | HEU5098900.1 PLP-dependent aminotransferase family protein [Roseiflexaceae bacterium] | diamond | 462 | 148 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae 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);;