contig_metadata
16 rows where bioproject = "PRJNA854078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2510325 | 2510325 | PRJNA854078_P_NODE_16802_length_238_cov_2.836364_g16590_i0 | PRJNA854078 | 16802 | 238 | 2.836364 | 6.75054632 | Corynebacterium | 1716 | Bacteria | Bacteria | 440 | 3.899999999999999e-119 | NTclustered | gi|1540233514|emb|LR134504.1| | 43768 | g16590 | i0 | 100 | 103 | 238 | 0 | 100 | 0 | 1 | 238 | 522341 | 522104 | Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1 | blastn | 24514 | 440 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium matruchotii | ||
| 3392376 | 3392376 | PRJNA854078_P_NODE_16683_length_241_cov_0.916667_g16471_i0 | PRJNA854078 | 16683 | 241 | 0.916667 | 2.20916747 | Corynebacterium marquesiae | 2913503 | Bacteria | Bacteria | 412 | 8.64e-111 | NTclustered | gi|2869847307|gb|CP175787.1| | 2913503 | g16471 | i0 | 97.51 | 13.0580912863071 | 241 | 6 | 100 | 0 | 1 | 241 | 372995 | 372755 | Corynebacterium marquesiae strain YSMAA1_1_H4 chromosome, complete genome | blastn | 3147 | 412 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium marquesiae | ||
| 5944962 | 5944962 | PRJNA854078_P_NODE_9885_length_299_cov_1.831858_g9673_i0 | PRJNA854078 | 9885 | 299 | 1.831858 | 5.47725542 | Corynebacterium matruchotii | 43768 | Bacteria | Bacteria | 553 | 6.25e-153 | NTclustered | gi|1540233514|emb|LR134504.1| | 43768 | g9673 | i0 | 100 | 389.501672240803 | 299 | 0 | 100 | 0 | 1 | 299 | 519491 | 519193 | Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1 | blastn | 116461 | 553 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Corynebacteriaceae | Corynebacterium | Corynebacterium matruchotii | ||
| 7612778 | 7612778 | PRJNA854078_P_NODE_10226_length_294_cov_1.393665_g10014_i0 | PRJNA854078 | 10226 | 294 | 1.393665 | 4.0973751 | Actinomyces | 1654 | Bacteria | Bacteria | 481 | 2.94e-131 | NTclustered | gi|2219514734|dbj|AP025697.1| | 1655 | g10014 | i0 | 96.271 | 249.119047619048 | 295 | 8 | 100 | 3 | 1 | 294 | 486949 | 486657 | Actinomyces naeslundii ATCC 27039 DNA, complete genome | blastn | 73241 | 481 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetales | Actinomycetaceae | Actinomyces | Actinomyces naeslundii | ||
| 12714349 | 12714349 | PRJNA854078_P_NODE_16390_length_242_cov_0.911243_g16178_i0 | PRJNA854078 | 16390 | 242 | 0.911243 | 2.20520806 | Cutibacterium | 1912216 | Bacteria | Bacteria | 436 | 5.1499999999999985e-118 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g16178 | i0 | 99.174 | 51 | 242 | 2 | 100 | 0 | 1 | 242 | 617633 | 617392 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 12342 | 436 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 19086305 | 19086305 | PRJNA854078_P_NODE_15815_length_244_cov_0.900585_g15603_i0 | PRJNA854078 | 15815 | 244 | 0.900585 | 2.1974274 | Cutibacterium | 1912216 | Bacteria | Bacteria | 451 | 1.86e-122 | NTclustered | gi|1446500593|gb|CP031442.1| | 1747 | g15603 | i0 | 100 | 53.9631147540984 | 244 | 0 | 100 | 0 | 1 | 244 | 1634685 | 1634928 | Cutibacterium acnes strain KCOM 1315 chromosome, complete genome | blastn | 13167 | 451 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Propionibacteriales | Propionibacteriaceae | Cutibacterium | Cutibacterium acnes | ||
| 19086306 | 19086306 | PRJNA854078_P_NODE_16595_length_241_cov_0.916667_g16383_i0 | PRJNA854078 | 16595 | 241 | 0.916667 | 2.20916747 | Rothia | 32207 | Bacteria | Bacteria | 313 | 9.01e-81 | NTclustered | gi|1247210625|gb|CP023510.1| | 43675 | g16383 | i0 | 90.083 | 5.79668049792531 | 242 | 22 | 100 | 2 | 1 | 241 | 1722642 | 1722882 | Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome | blastn | 1397 | 313 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Rothia | Rothia mucilaginosa | ||
| 20361111 | 20361111 | PRJNA854078_P_NODE_4396_length_453_cov_1.784211_g4184_i0 | PRJNA854078 | 4396 | 453 | 1.784211 | 8.08247583 | Pseudarthrobacter | 1742993 | Bacteria | Bacteria | 54.7 | 0.012 | NTclustered | gi|1695528078|gb|CP041187.1| | 2590774 | g4184 | i0 | 100 | 0.1280353200883 | 29 | 0 | 6 | 0 | 381 | 409 | 1838926 | 1838954 | Pseudarthrobacter sp. NIBRBAC000502771 chromosome, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Pseudarthrobacter | Pseudarthrobacter sp. NIBRBAC000502771 | ||
| 27442739 | 27442739 | PRJNA854078_P_NODE_43_length_3600_cov_10.246952_g33_i0 | PRJNA854078 | 43 | 3600 | 10.246952 | 368.890272 | Bacillati | 1783272 | Bacteria | Bacteria | 106 | 5.57e-19 | NR | WP_307859796.1 | 547056 | g33 | i0 | 31.1 | 1.65083333333333 | 460 | 290 | 37.1 | 16 | 2848 | 1514 | 202 | 649 | WP_307859796.1 fibronectin type III domain-containing protein [Actinokineospora baliensis] | diamond | 5943 | 106 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora baliensis | ||
| 28570860 | 28570860 | PRJNA854078_P_NODE_47_length_3553_cov_8.945977_g33_i1 | PRJNA854078 | 47 | 3553 | 8.945977 | 317.85056281 | Actinokineospora baliensis | 547056 | Bacteria | Bacteria | 105 | 1.24e-18 | NR | WP_307859796.1 | 547056 | g33 | i1 | 30.9 | 1.0520686743597 | 460 | 291 | 37.6 | 16 | 2848 | 1514 | 202 | 649 | WP_307859796.1 fibronectin type III domain-containing protein [Actinokineospora baliensis] | diamond | 3738 | 105 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora baliensis | ||
| 29052874 | 29052874 | PRJNA854078_P_NODE_468_length_1354_cov_1.722092_g364_i0 | PRJNA854078 | 468 | 1354 | 1.722092 | 23.31712568 | root | 1 | Root_unresolved | Root_unresolved | 80.5 | 6.37e-12 | NR | WP_253878436.1 | 559627 | g364 | i0 | 26.3 | 1.44903988183161 | 407 | 267 | 87.7 | 13 | 1237 | 50 | 410 | 794 | WP_253878436.1 fibronectin type III domain-containing protein [Actinomadura rupiterrae] | diamond | 1962 | 80.5 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Streptosporangiales | Thermomonosporaceae | Actinomadura | Actinomadura rupiterrae | ||
| 29675693 | 29675693 | PRJNA854078_P_NODE_1470_length_789_cov_3.709497_g1282_i0 | PRJNA854078 | 1470 | 789 | 3.709497 | 29.26793133 | Microbacterium sp. CIAB417 | 2860287 | Bacteria | Bacteria | 59.7 | 5.3e-6 | NR | WP_243226804.1 | 2860287 | g1282 | i0 | 28.9 | 0.749049429657795 | 197 | 126 | 71.1 | 7 | 612 | 52 | 1509 | 1701 | WP_243226804.1 fibronectin type III domain-containing protein [Microbacterium sp. CIAB417] | diamond | 591 | 59.7 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. CIAB417 | ||
| 30813290 | 30813290 | PRJNA854078_P_NODE_12954_length_261_cov_1.611702_g12742_i0 | PRJNA854078 | 12954 | 261 | 1.611702 | 4.20654222 | Amycolatopsis | 1813 | Bacteria | Bacteria | 50.1 | 8.68e-5 | NR | WP_067584438.1 | 1813 | g12742 | i0 | 34.9 | 0.954022988505747 | 83 | 45 | 95.4 | 2 | 10 | 258 | 124 | 197 | WP_067584438.1 MULTISPECIES: S1 family peptidase [Amycolatopsis] | diamond | 249 | 50.1 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Amycolatopsis | |||
| 31223898 | 31223898 | PRJNA854078_P_NODE_11815_length_274_cov_1.532338_g11603_i0 | PRJNA854078 | 11815 | 274 | 1.532338 | 4.19860612 | Coriobacteriia bacterium | 2052159 | Bacteria | Bacteria | 43.1 | 0.0368 | NR | HSK46834.1 | 2052159 | g11603 | i0 | 36.7 | 0.536496350364963 | 49 | 31 | 53.6 | 0 | 179 | 33 | 12 | 60 | HSK46834.1 GAF domain-containing protein [Coriobacteriia bacterium] | diamond | 147 | 43.1 | 1 | Bacteria | Bacillati | Actinomycetota | Coriobacteriia | Coriobacteriia bacterium | |||||
| 31920008 | 31920008 | PRJNA854078_P_NODE_7897_length_335_cov_0.862595_g7685_i0 | PRJNA854078 | 7897 | 335 | 0.862595 | 2.88969325 | Streptomyces chartreusis NRRL 3882 | 1079985 | Bacteria | Bacteria | 50.4 | 1.89e-4 | NR | SOR82164.1 | 1079985 | g7685 | i0 | 46.8 | 0.68955223880597 | 77 | 28 | 61.8 | 4 | 325 | 119 | 125 | 196 | SOR82164.1 hypothetical protein SCNRRL3882_5616 [Streptomyces chartreusis NRRL 3882] | diamond | 231 | 50.4 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces chartreusis | ||
| 32308164 | 32308164 | PRJNA854078_P_NODE_59_length_3408_cov_10.503148_g33_i2 | PRJNA854078 | 59 | 3408 | 10.503148 | 357.94728384 | Bacillati | 1783272 | Bacteria | Bacteria | 106 | 5.09e-19 | NR | WP_307859796.1 | 547056 | g33 | i2 | 31.1 | 1.74383802816901 | 460 | 290 | 39.2 | 16 | 561 | 1895 | 202 | 649 | WP_307859796.1 fibronectin type III domain-containing protein [Actinokineospora baliensis] | diamond | 5943 | 106 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Pseudonocardiales | Pseudonocardiaceae | Actinokineospora | Actinokineospora baliensis |
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);;