contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26799891 | 26799891 | PRJNA760976_P_NODE_15361_length_383_cov_0.983871_g15040_i0 | PRJNA760976 | 15361 | 383 | 0.983871 | 3.76822593 | Actinobacteria bacterium RBG_19FT_COMBO_36_27 | 1797206 | Bacteria | Bacteria | 160 | 7.32e-43 | NR | OFW63940.1 | 1797206 | g15040 | i0 | 62.2 | 3.97911227154047 | 127 | 48 | 99.5 | 0 | 3 | 383 | 121 | 247 | OFW63940.1 MAG: pyruvate, phosphate dikinase, partial [Actinobacteria bacterium RBG_19FT_COMBO_36_27] | diamond | 1524 | 160 | 1 | Bacteria | Bacillati | Actinomycetota | Actinobacteria bacterium RBG_19FT_COMBO_36_27 | ||||||
| 26863612 | 26863612 | PRJNA760976_P_NODE_14401_length_392_cov_0.905956_g14081_i0 | PRJNA760976 | 14401 | 392 | 0.905956 | 3.55134752 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 82 | 3.31e-15 | NR | HEV3352619.1 | 2201156 | g14081 | i0 | 43.2 | 2.7015306122449 | 118 | 63 | 90.3 | 4 | 391 | 38 | 222 | 335 | HEV3352619.1 Ig-like domain repeat protein [Acidimicrobiales bacterium] | diamond | 1059 | 82 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 27021523 | 27021523 | PRJNA760976_P_NODE_34702_length_287_cov_1.037383_g34381_i0 | PRJNA760976 | 34702 | 287 | 1.037383 | 2.97728921 | Actinokineospora inagensis | 103730 | Bacteria | Bacteria | 48.9 | 4.51e-4 | NR | WP_026423909.1 | 103730 | g34381 | i0 | 38.4 | 1.79790940766551 | 86 | 49 | 87.8 | 2 | 15 | 266 | 1662 | 1745 | WP_026423909.1 CARDB domain-containing protein [Actinokineospora inagensis] | diamond | 516 | 48.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora inagensis | ||
| 27600099 | 27600099 | PRJNA760976_P_NODE_56644_length_241_cov_0.880952_g56323_i0 | PRJNA760976 | 56644 | 241 | 0.880952 | 2.12309432 | root | 1 | Root_unresolved | Root_unresolved | 43.9 | 0.0136 | NR | WP_103493233.1 | 1883 | g56323 | i0 | 36.1 | 6.33609958506224 | 72 | 43 | 89.6 | 1 | 237 | 22 | 233 | 301 | WP_103493233.1 MULTISPECIES: STM4015 family protein [Streptomyces] | diamond | 1527 | 44.3 | 0.99097065462754 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | |||
| 27947281 | 27947281 | PRJNA760976_P_NODE_57645_length_230_cov_2.878981_g57324_i0 | PRJNA760976 | 57645 | 230 | 2.878981 | 6.6216563 | Mycolicibacterium | 1866885 | Bacteria | Bacteria | 154 | 1.6499999999999998e-42 | NR | WP_412098625.1 | 912594 | g57324 | i0 | 93.4 | 2.97391304347826 | 76 | 5 | 99.1 | 0 | 2 | 229 | 187 | 262 | WP_412098625.1 IS21 family transposase [Mycolicibacterium iranicum] | diamond | 684 | 155 | 0.993548387096774 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycolicibacterium | Mycolicibacterium iranicum | ||
| 29137627 | 29137627 | PRJNA760976_P_NODE_48629_length_250_cov_0.870056_g48308_i0 | PRJNA760976 | 48629 | 250 | 0.870056 | 2.17514 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 89 | 6.86e-19 | NR | PZP88766.1 | 1528099 | g48308 | i0 | 100 | 0.48 | 40 | 0 | 48 | 0 | 3 | 122 | 286 | 325 | PZP88766.1 MAG: hypothetical protein DI579_05235 [Lawsonella clevelandensis] | diamond | 120 | 89 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 29610652 | 29610652 | PRJNA760976_P_NODE_17930_length_362_cov_1.342561_g17609_i0 | PRJNA760976 | 17930 | 362 | 1.342561 | 4.86007082 | Rubrobacter sp. | 2036010 | Bacteria | Bacteria | 61.2 | 5.3e-9 | NR | HZB10785.1 | 2036010 | g17609 | i0 | 36.7 | 0.74585635359116 | 90 | 56 | 74.6 | 1 | 87 | 356 | 14 | 102 | HZB10785.1 DUF1772 domain-containing protein [Rubrobacter sp.] | diamond | 270 | 61.2 | 1 | Bacteria | Bacillati | Actinomycetota | Rubrobacteria | Rubrobacterales | Rubrobacteraceae | Rubrobacter | Rubrobacter sp. | ||
| 29936547 | 29936547 | PRJNA760976_P_NODE_57331_length_235_cov_2.265432_g57010_i0 | PRJNA760976 | 57331 | 235 | 2.265432 | 5.3237652 | PVC group | 1783257 | Bacteria | Bacteria | 59.3 | 4.72e-8 | NR | MCW2548333.1 | 1785 | g57010 | i0 | 65.9 | 8.02978723404255 | 44 | 15 | 56.2 | 0 | 135 | 4 | 51 | 94 | MCW2548333.1 hypothetical protein [Mycobacterium sp.] | diamond | 1887 | 59.7 | 0.993299832495812 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Mycobacteriaceae | Mycobacterium | Mycobacterium sp. | ||
| 30653272 | 30653272 | PRJNA760976_P_NODE_32753_length_293_cov_1.209091_g32432_i0 | PRJNA760976 | 32753 | 293 | 1.209091 | 3.54263663 | Nocardioides sp. | 35761 | Bacteria | Bacteria | 129 | 4.5600000000000005e-33 | NR | MCD6641075.1 | 35761 | g32432 | i0 | 67 | 7.94539249146758 | 97 | 32 | 99.3 | 0 | 292 | 2 | 367 | 463 | MCD6641075.1 NAD-dependent succinate-semialdehyde dehydrogenase [Nocardioides sp.] | diamond | 2328 | 129 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Nocardioidaceae | Nocardioides | Nocardioides sp. | ||
| 30906402 | 30906402 | PRJNA760976_P_NODE_44094_length_260_cov_2.401070_g43773_i0 | PRJNA760976 | 44094 | 260 | 2.40107 | 6.242782 | Dactylosporangium sp. NPDC | 60453 | Bacteria | Bacteria | 50.8 | 6.36e-5 | NR | WP_354786846.1 | 3154889 | g43773 | i0 | 38.2 | 0.784615384615385 | 68 | 41 | 77.3 | 1 | 249 | 49 | 472 | 539 | WP_354786846.1 cellulose binding domain-containing protein [Dactylosporangium sp. NPDC005555] | diamond | 204 | 50.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Dactylosporangium | Dactylosporangium sp. NPDC005555 | ||
| 31221940 | 31221940 | PRJNA760976_P_NODE_17315_length_367_cov_0.982993_g16994_i0 | PRJNA760976 | 17315 | 367 | 0.982993 | 3.60758431 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 52 | 7.73e-5 | NR | MDQ3151283.1 | 2900548 | g16994 | i0 | 65 | 0.326975476839237 | 40 | 13 | 32.7 | 1 | 2 | 121 | 264 | 302 | MDQ3151283.1 matrilysin family metalloendoprotease [Actinomycetota bacterium] | diamond | 120 | 52 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31317060 | 31317060 | PRJNA760976_P_NODE_42855_length_264_cov_1.172775_g42534_i0 | PRJNA760976 | 42855 | 264 | 1.172775 | 3.096126 | Streptomyces murinus | 33900 | Bacteria | Bacteria | 92 | 2.23e-19 | NR | WP_199571634.1 | 33900 | g42534 | i0 | 51.7 | 4.92045454545455 | 87 | 42 | 98.9 | 0 | 262 | 2 | 926 | 1012 | WP_199571634.1 hypothetical protein [Streptomyces murinus] | diamond | 1299 | 92 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces murinus | ||
| 31411991 | 31411991 | PRJNA760976_P_NODE_24656_length_324_cov_1.521912_g24335_i0 | PRJNA760976 | 24656 | 324 | 1.521912 | 4.93099488 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 66.2 | 5.16e-10 | NR | MEY3505807.1 | 2900548 | g24335 | i0 | 46.3 | 1.47222222222222 | 82 | 43 | 75.9 | 1 | 1 | 246 | 163 | 243 | MEY3505807.1 hypothetical protein [Actinomycetota bacterium] | diamond | 477 | 66.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31453423 | 31453423 | PRJNA760976_P_NODE_7736_length_496_cov_1.300236_g7417_i0 | PRJNA760976 | 7736 | 496 | 1.300236 | 6.44917056 | Bacteria | 2 | Bacteria | Bacteria | 88.2 | 1.42e-18 | NR | GMV20487.1 | 2080302 | g7417 | i0 | 49.5 | 4.28225806451613 | 103 | 50 | 61.1 | 1 | 11 | 313 | 64 | 166 | GMV20487.1 MAG: osteoblast specific factor 2-related protein [Acidimicrobiia bacterium] | diamond | 2124 | 88.6 | 0.99548532731377 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 31475326 | 31475326 | PRJNA760976_P_NODE_30436_length_301_cov_1.013158_g30115_i0 | PRJNA760976 | 30436 | 301 | 1.013158 | 3.04960558 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 160 | 1.3899999999999998e-48 | NR | MBS1889789.1 | 2900548 | g30115 | i0 | 78 | 0.996677740863787 | 100 | 21 | 99.7 | 1 | 1 | 300 | 23 | 121 | MBS1889789.1 hypothetical protein [Actinomycetota bacterium] | diamond | 300 | 160 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 31601900 | 31601900 | PRJNA760976_P_NODE_56816_length_241_cov_0.875000_g56495_i0 | PRJNA760976 | 56816 | 241 | 0.875 | 2.10875 | Corynebacterium sp. ED61 | 2211360 | Bacteria | Bacteria | 150 | 3.6399999999999997e-40 | NR | WP_194187701.1 | 2211360 | g56495 | i0 | 95 | 0.995850622406639 | 80 | 4 | 99.6 | 0 | 2 | 241 | 105 | 184 | WP_194187701.1 MobF family relaxase [Corynebacterium sp. ED61] | diamond | 240 | 150 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium sp. ED61 | ||
| 31981200 | 31981200 | PRJNA760976_P_NODE_18238_length_360_cov_1.296167_g17917_i0 | PRJNA760976 | 18238 | 360 | 1.296167 | 4.6662012 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 61.6 | 2.27e-8 | NR | MDW3177977.1 | 2080302 | g17917 | i0 | 33.6 | 1.06666666666667 | 128 | 75 | 100 | 5 | 360 | 1 | 133 | 258 | MDW3177977.1 hypothetical protein [Acidimicrobiia bacterium] | diamond | 384 | 61.6 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 32234776 | 32234776 | PRJNA760976_P_NODE_44898_length_258_cov_2.443243_g44577_i0 | PRJNA760976 | 44898 | 258 | 2.443243 | 6.30356694 | Yaniella sp. | 2773929 | Bacteria | Bacteria | 103 | 8.42e-25 | NR | HEY4576576.1 | 2773929 | g44577 | i0 | 98 | 0.581395348837209 | 50 | 1 | 58.1 | 0 | 2 | 151 | 201 | 250 | HEY4576576.1 hypothetical protein [Yaniella sp.] | diamond | 150 | 103 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Yaniella | Yaniella sp. | ||
| 32361276 | 32361276 | PRJNA760976_P_NODE_38719_length_275_cov_1.465347_g38398_i0 | PRJNA760976 | 38719 | 275 | 1.465347 | 4.02970425 | Kribbella sp. NPDC | 1871183 | Bacteria | Bacteria | 95.9 | 1.2500000000000001e-22 | NR | WP_355464220.1 | 3156893 | g38398 | i0 | 50.5 | 1.94181818181818 | 91 | 45 | 99.3 | 0 | 2 | 274 | 81 | 171 | WP_355464220.1 hemerythrin domain-containing protein [Kribbella sp. NPDC005582] | diamond | 534 | 95.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Kribbellaceae | Kribbella | Kribbella sp. NPDC005582 |
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);;