contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26602526 | 26602526 | PRJNA532380_P_NODE_3741_length_532_cov_1.184265_g3421_i0 | PRJNA532380 | 3741 | 532 | 1.184265 | 6.3002898 | uncultured Arthrobacter sp. | 114050 | Bacteria | Bacteria | 130 | 1.1499999999999999e-32 | NR | WP_346925879.1 | 114050 | g3421 | i0 | 41.5 | 0.992481203007519 | 176 | 101 | 99.2 | 1 | 2 | 529 | 13 | 186 | WP_346925879.1 hypothetical protein [uncultured Arthrobacter sp.] | diamond | 528 | 130 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Arthrobacter | uncultured Arthrobacter sp. | ||
| 27583024 | 27583024 | PRJNA532380_P_NODE_26484_length_172_cov_1.349593_g26159_i0 | PRJNA532380 | 26484 | 172 | 1.349593 | 2.32129996 | Streptomyces luteolus | 3043615 | Bacteria | Bacteria | 41.2 | 0.0469 | NR | WP_282533273.1 | 3043615 | g26159 | i0 | 47.9 | 0.837209302325581 | 48 | 22 | 83.7 | 2 | 145 | 2 | 25 | 69 | WP_282533273.1 hypothetical protein [Streptomyces luteolus] | diamond | 144 | 41.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces luteolus | ||
| 27930427 | 27930427 | PRJNA532380_P_NODE_25365_length_177_cov_0.968750_g25040_i0 | PRJNA532380 | 25365 | 177 | 0.96875 | 1.7146875 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 42.7 | 0.0106 | NR | HET8664776.1 | 35761 | g25040 | i0 | 38.5 | 0.88135593220339 | 52 | 32 | 88.1 | 0 | 19 | 174 | 85 | 136 | HET8664776.1 Rv3235 family protein [Nocardioides sp.] | diamond | 156 | 42.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 28025207 | 28025207 | PRJNA532380_P_NODE_22385_length_190_cov_0.929078_g22060_i0 | PRJNA532380 | 22385 | 190 | 0.929078 | 1.7652482 | Nonomuraea corallina | 2989783 | Bacteria | Bacteria | 44.3 | 0.00527 | NR | WP_270156369.1 | 2989783 | g22060 | i0 | 51.9 | 0.852631578947368 | 54 | 21 | 78.9 | 3 | 17 | 166 | 182 | 234 | WP_270156369.1 acyltransferase family protein [Nonomuraea corallina] | diamond | 162 | 44.3 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Streptosporangiaceae | Nonomuraea | Nonomuraea corallina | ||
| 28088158 | 28088158 | PRJNA532380_P_NODE_26225_length_173_cov_1.395161_g25900_i0 | PRJNA532380 | 26225 | 173 | 1.395161 | 2.41362853 | Rubrobacteraceae bacterium | 2740537 | Bacteria | Bacteria | 40 | 0.0457 | NR | MBA3491742.1 | 2740537 | g25900 | i0 | 47.4 | 0.658959537572254 | 38 | 17 | 65.9 | 1 | 29 | 142 | 67 | 101 | MBA3491742.1 AI-2E family transporter [Rubrobacteraceae bacterium] | diamond | 114 | 40 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacteraceae bacterium | |||
| 30425564 | 30425564 | PRJNA532380_P_NODE_12613_length_256_cov_1.574879_g12288_i0 | PRJNA532380 | 12613 | 256 | 1.574879 | 4.03169024 | Streptomyces sp. NRRL F-5727 | 1463871 | Bacteria | Bacteria | 43.9 | 0.0162 | NR | WP_051716732.1 | 1463871 | g12288 | i0 | 45.1 | 1.1953125 | 51 | 26 | 59.8 | 1 | 224 | 72 | 322 | 370 | WP_051716732.1 MATE family efflux transporter [Streptomyces sp. NRRL F-5727] | diamond | 306 | 43.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NRRL F-5727 | ||
| 31563204 | 31563204 | PRJNA532380_P_NODE_19156_length_206_cov_0.993631_g18831_i0 | PRJNA532380 | 19156 | 206 | 0.993631 | 2.04687986 | Piscicoccus intestinalis | 746033 | Bacteria | Bacteria | 42 | 0.0418 | NR | WP_068430052.1 | 746033 | g18831 | i0 | 47.5 | 0.58252427184466 | 40 | 21 | 58.3 | 0 | 87 | 206 | 205 | 244 | WP_068430052.1 universal stress protein [Piscicoccus intestinalis] | diamond | 120 | 42 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermatophilaceae | Piscicoccus | Piscicoccus intestinalis | ||
| 31957556 | 31957556 | PRJNA532380_P_NODE_13837_length_243_cov_2.520619_g13512_i0 | PRJNA532380 | 13837 | 243 | 2.520619 | 6.12510417 | Conexibacter | 191494 | Bacteria | Bacteria | 88.6 | 9.72e-19 | NR | HMJ02477.1 | 1929289 | g13512 | i0 | 61.1 | 2.81481481481481 | 72 | 26 | 88.9 | 1 | 240 | 25 | 227 | 296 | HMJ02477.1 malate dehydrogenase [Conexibacter sp.] | diamond | 684 | 88.6 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter sp. |
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);;