contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA385064" and tax_phylum = "Actinomycetota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8728568 | 8728568 | PRJNA385064_P_NODE_7307_length_164_cov_0.886957_g7182_i0 | PRJNA385064 | 7307 | 164 | 0.886957 | 1.45460948 | Corynebacterium striatum | 43770 | Bacteria | Bacteria | 114 | 2.97e-30 | NR | WP_080969961.1 | 43770 | g7182 | i0 | 100 | 0.98780487804878 | 54 | 0 | 98.8 | 0 | 162 | 1 | 95 | 148 | WP_080969961.1 PIN domain-containing protein [Corynebacterium striatum] | diamond | 162 | 114 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium striatum | ||
| 26885511 | 26885511 | PRJNA385064_P_NODE_3881_length_220_cov_2.578947_g3756_i0 | PRJNA385064 | 3881 | 220 | 2.578947 | 5.6736834 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 46.2 | 0.00168 | NR | MFQ5554000.1 | 2080302 | g3756 | i0 | 44.6 | 0.886363636363636 | 65 | 31 | 81.8 | 2 | 34 | 213 | 90 | 154 | MFQ5554000.1 hypothetical protein [Acidimicrobiia bacterium] | diamond | 195 | 46.2 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 27454592 | 27454592 | PRJNA385064_P_NODE_3223_length_244_cov_1.307692_g3098_i0 | PRJNA385064 | 3223 | 244 | 1.307692 | 3.19076848 | Georgenia sp. | 1873458 | Bacteria | Bacteria | 107 | 7.51e-26 | NR | HLT85933.1 | 1873458 | g3098 | i0 | 56.8 | 0.995901639344262 | 81 | 35 | 99.6 | 0 | 244 | 2 | 126 | 206 | HLT85933.1 hypothetical protein [Georgenia sp.] | diamond | 243 | 107 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Bogoriellaceae | Georgenia | Georgenia sp. | ||
| 27580614 | 27580614 | PRJNA385064_P_NODE_7384_length_164_cov_0.886957_g7259_i0 | PRJNA385064 | 7384 | 164 | 0.886957 | 1.45460948 | Pseudactinotalea sp. HY158 | 2654547 | Bacteria | Bacteria | 46.6 | 5.52e-4 | NR | WP_194928858.1 | 2654547 | g7259 | i0 | 84.6 | 0.475609756097561 | 26 | 4 | 47.6 | 0 | 148 | 71 | 360 | 385 | WP_194928858.1 glycerate kinase [Pseudactinotalea sp. HY158] | diamond | 78 | 46.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Cellulomonadaceae | Pseudactinotalea | Pseudactinotalea sp. HY158 | ||
| 28117323 | 28117323 | PRJNA385064_P_NODE_3025_length_253_cov_1.000000_g2900_i0 | PRJNA385064 | 3025 | 253 | 1 | 2.53 | uncultured Actinomyces sp. | 249061 | Bacteria | Bacteria | 129 | 3.1500000000000004e-36 | NR | WP_311470439.1 | 249061 | g2900 | i0 | 96.9 | 0.770750988142292 | 65 | 2 | 77.1 | 0 | 253 | 59 | 83 | 147 | WP_311470439.1 hypothetical protein [uncultured Actinomyces sp.] | diamond | 195 | 129 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | uncultured Actinomyces sp. | ||
| 28338514 | 28338514 | PRJNA385064_P_NODE_4786_length_196_cov_1.278912_g4661_i0 | PRJNA385064 | 4786 | 196 | 1.278912 | 2.50666752 | Eggerthellaceae bacterium | 1972561 | Bacteria | Bacteria | 43.1 | 0.015 | NR | MBQ2681247.1 | 1972561 | g4661 | i0 | 45 | 0.612244897959184 | 40 | 22 | 61.2 | 0 | 4 | 123 | 659 | 698 | MBQ2681247.1 sulfatase-like hydrolase/transferase [Eggerthellaceae bacterium] | diamond | 120 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Eggerthellales | Eggerthellaceae | Eggerthellaceae bacterium | |||
| 28528110 | 28528110 | PRJNA385064_P_NODE_7647_length_163_cov_0.859649_g7522_i0 | PRJNA385064 | 7647 | 163 | 0.859649 | 1.40122787 | Propionicimonas paludicola | 185243 | Bacteria | Bacteria | 95.9 | 3.9e-22 | NR | WP_098461678.1 | 185243 | g7522 | i0 | 86.8 | 0.975460122699387 | 53 | 7 | 97.5 | 0 | 162 | 4 | 173 | 225 | WP_098461678.1 dihydropteroate synthase [Propionicimonas paludicola] | diamond | 159 | 95.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Propionicimonas | Propionicimonas paludicola | ||
| 28748923 | 28748923 | PRJNA385064_P_NODE_6867_length_166_cov_0.871795_g6742_i0 | PRJNA385064 | 6867 | 166 | 0.871795 | 1.4471797 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 117 | 1.06e-29 | NR | WP_394268102.1 | 1528099 | g6742 | i0 | 98.2 | 0.993975903614458 | 55 | 1 | 99.4 | 0 | 2 | 166 | 237 | 291 | WP_394268102.1 AMP-binding protein [Lawsonella clevelandensis] | diamond | 165 | 117 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 29885779 | 29885779 | PRJNA385064_P_NODE_6411_length_168_cov_0.705882_g6286_i0 | PRJNA385064 | 6411 | 168 | 0.705882 | 1.18588176 | Paractinoplanes bogorensis | 1610840 | Bacteria | Bacteria | 42 | 0.0264 | NR | WP_215790945.1 | 1610840 | g6286 | i0 | 40 | 0.982142857142857 | 55 | 33 | 98.2 | 0 | 165 | 1 | 252 | 306 | WP_215790945.1 sigma-54-dependent Fis family transcriptional regulator [Paractinoplanes bogorensis] | diamond | 165 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Paractinoplanes | Paractinoplanes bogorensis | ||
| 30043505 | 30043505 | PRJNA385064_P_NODE_6571_length_167_cov_0.864407_g6446_i0 | PRJNA385064 | 6571 | 167 | 0.864407 | 1.44355969 | Micromonospora sp. WMMD11 | 1876 | Bacteria | Bacteria | 78.2 | 1.83e-15 | NR | WP_278060642.1 | 3016105 | g6446 | i0 | 66.7 | 2.89221556886228 | 54 | 18 | 97 | 0 | 165 | 4 | 194 | 247 | WP_278060642.1 hypothetical protein [Micromonospora sp. WMMD1102] | diamond | 483 | 78.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora sp. WMMD1102 | ||
| 30517511 | 30517511 | PRJNA385064_P_NODE_3733_length_225_cov_1.073864_g3608_i0 | PRJNA385064 | 3733 | 225 | 1.073864 | 2.416194 | Gaiellaceae bacterium | 2838783 | Bacteria | Bacteria | 40 | 0.0493 | NR | HVW90608.1 | 2838783 | g3608 | i0 | 43.1 | 0.68 | 51 | 25 | 65.3 | 2 | 9 | 155 | 22 | 70 | HVW90608.1 hypothetical protein [Gaiellaceae bacterium] | diamond | 153 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 30991542 | 30991542 | PRJNA385064_P_NODE_5854_length_176_cov_0.976378_g5729_i0 | PRJNA385064 | 5854 | 176 | 0.976378 | 1.71842528 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 41.2 | 0.0477 | NR | HEU4811850.1 | 35761 | g5729 | i0 | 43.6 | 0.9375 | 55 | 27 | 86.9 | 1 | 11 | 163 | 70 | 124 | HEU4811850.1 5-formyltetrahydrofolate cyclo-ligase [Nocardioides sp.] | diamond | 165 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 31971704 | 31971704 | PRJNA385064_P_NODE_6658_length_167_cov_0.864407_g6533_i0 | PRJNA385064 | 6658 | 167 | 0.864407 | 1.44355969 | uncultured Corynebacterium sp. | 159447 | Bacteria | Bacteria | 106 | 5.3e-26 | NR | WP_293791152.1 | 159447 | g6533 | i0 | 92.7 | 0.988023952095808 | 55 | 4 | 98.8 | 0 | 3 | 167 | 15 | 69 | WP_293791152.1 HAD-IIA family hydrolase [uncultured Corynebacterium sp.] | diamond | 165 | 106 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | uncultured Corynebacterium sp. | ||
| 32193329 | 32193329 | PRJNA385064_P_NODE_6598_length_167_cov_0.864407_g6473_i0 | PRJNA385064 | 6598 | 167 | 0.864407 | 1.44355969 | Lawsonella | 1847725 | Bacteria | Bacteria | 113 | 5.63e-28 | NR | WP_290595325.1 | 1847725 | g6473 | i0 | 100 | 0.988023952095808 | 55 | 0 | 98.8 | 0 | 166 | 2 | 131 | 185 | WP_290595325.1 MULTISPECIES: class I SAM-dependent RNA methyltransferase [Lawsonella] | diamond | 165 | 113 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | |||
| 32761820 | 32761820 | PRJNA385064_P_NODE_7840_length_162_cov_0.902655_g7715_i0 | PRJNA385064 | 7840 | 162 | 0.902655 | 1.4623011 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 115 | 4.22e-28 | NR | GHT86527.1 | 2900548 | g7715 | i0 | 98.1 | 1 | 54 | 1 | 100 | 0 | 1 | 162 | 179 | 232 | GHT86527.1 multifunctional 2-oxoglutarate metabolism enzyme [Actinomycetota bacterium] | diamond | 162 | 115 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota 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);;