contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26726435 | 26726435 | PRJNA380660_P_NODE_7321_length_267_cov_3.500000_g6921_i0 | PRJNA380660 | 7321 | 267 | 3.5 | 9.345 | Gaiellaceae bacterium | 2838783 | Bacteria | Bacteria | 43.5 | 0.0226 | NR | HST17223.1 | 2838783 | g6921 | i0 | 52.2 | 0.51685393258427 | 46 | 20 | 49.4 | 2 | 105 | 236 | 35 | 80 | HST17223.1 hypothetical protein [Gaiellaceae bacterium] | diamond | 138 | 43.5 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Gaiellales | Gaiellaceae | Gaiellaceae bacterium | |||
| 27818770 | 27818770 | PRJNA380660_P_NODE_8164_length_244_cov_1.572093_g7764_i0 | PRJNA380660 | 8164 | 244 | 1.572093 | 3.83590692 | Bacteria | 2 | Bacteria | Bacteria | 48.5 | 3.36e-4 | NR | WP_347222009.1 | 39694 | g7764 | i0 | 42.9 | 2.56967213114754 | 77 | 36 | 87.3 | 2 | 1 | 213 | 232 | 306 | WP_347222009.1 integrin alpha, partial [Mycolicibacterium poriferae] | diamond | 627 | 48.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium poriferae | ||
| 28654086 | 28654086 | PRJNA380660_P_NODE_12387_length_161_cov_1.590909_g11987_i0 | PRJNA380660 | 12387 | 161 | 1.590909 | 2.56136349 | Ilumatobacteraceae bacterium | 2497619 | Bacteria | Bacteria | 49.3 | 5.24e-5 | NR | MCE2764894.1 | 2497619 | g11987 | i0 | 48.1 | 0.968944099378882 | 52 | 26 | 96.9 | 1 | 6 | 161 | 68 | 118 | MCE2764894.1 hypothetical protein [Ilumatobacteraceae bacterium] | diamond | 156 | 49.3 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Ilumatobacteraceae | Ilumatobacteraceae bacterium | |||
| 28654087 | 28654087 | PRJNA380660_P_NODE_3607_length_433_cov_3.995050_g3219_i0 | PRJNA380660 | 3607 | 433 | 3.99505 | 17.2985665 | Cryptosporangium aurantiacum | 134849 | Bacteria | Bacteria | 43.9 | 0.0337 | NR | WP_073266257.1 | 134849 | g3219 | i0 | 30.2 | 0.665127020785219 | 96 | 62 | 65.8 | 3 | 365 | 81 | 15 | 106 | WP_073266257.1 Zn-ribbon domain-containing OB-fold protein [Cryptosporangium aurantiacum] | diamond | 288 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Cryptosporangiales | Cryptosporangiaceae | Cryptosporangium | Cryptosporangium aurantiacum | ||
| 28797143 | 28797143 | PRJNA380660_P_NODE_8327_length_240_cov_2.184834_g7927_i0 | PRJNA380660 | 8327 | 240 | 2.184834 | 5.2436016 | Pseudonocardia | 1847 | Bacteria | Bacteria | 45.8 | 0.00298 | NR | WP_344418233.1 | 367279 | g7927 | i0 | 43.5 | 2.875 | 62 | 26 | 67.5 | 3 | 79 | 240 | 159 | 219 | WP_344418233.1 FAD-dependent oxidoreductase [Pseudonocardia ailaonensis] | diamond | 690 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Pseudonocardia | Pseudonocardia ailaonensis | ||
| 29397263 | 29397263 | PRJNA380660_P_NODE_4349_length_388_cov_2.069638_g3953_i0 | PRJNA380660 | 4349 | 388 | 2.069638 | 8.03019544 | Cyanobacteriota/Melainabacteria group | 1798711 | Bacteria | Bacteria | 139 | 2.0800000000000002e-36 | NR | WP_378058911.1 | 2044873 | g3953 | i0 | 56.8 | 11.9922680412371 | 125 | 51 | 95.1 | 3 | 12 | 380 | 239 | 362 | WP_378058911.1 amino acid adenylation domain-containing protein [Actinophytocola glycyrrhizae] | diamond | 4653 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinophytocola | Actinophytocola glycyrrhizae | ||
| 29807617 | 29807617 | PRJNA380660_P_NODE_11031_length_189_cov_1.606250_g10631_i0 | PRJNA380660 | 11031 | 189 | 1.60625 | 3.0358125 | Actinomycetota | 201174 | Bacteria | Bacteria | 47.4 | 2.82e-4 | NR | MBN2840643.1 | 2052159 | g10631 | i0 | 58.1 | 1.68253968253968 | 31 | 13 | 49.2 | 0 | 96 | 188 | 2 | 32 | MBN2840643.1 FABP family protein [Coriobacteriia bacterium] | diamond | 318 | 47.8 | 0.99163179916318 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriia bacterium | |||||
| 31592183 | 31592183 | PRJNA380660_P_NODE_7396_length_265_cov_2.364407_g6996_i0 | PRJNA380660 | 7396 | 265 | 2.364407 | 6.26567855 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 174 | 2.48e-53 | NR | PZP88504.1 | 1528099 | g6996 | i0 | 98.9 | 2.98867924528302 | 88 | 1 | 99.6 | 0 | 264 | 1 | 30 | 117 | PZP88504.1 MAG: nucleotide exchange factor GrpE [Lawsonella clevelandensis] | diamond | 792 | 174 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 31939829 | 31939829 | PRJNA380660_P_NODE_8217_length_242_cov_4.061033_g7817_i0 | PRJNA380660 | 8217 | 242 | 4.061033 | 9.82769986 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 75.9 | 8e-14 | NR | MCL4449639.1 | 2900548 | g7817 | i0 | 59.6 | 6.38429752066116 | 52 | 21 | 64.5 | 0 | 3 | 158 | 132 | 183 | MCL4449639.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Actinomycetota bacterium] | diamond | 1545 | 75.9 | 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);;