contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJEB76780" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 138765 | 138765 | PRJEB76780_P_NODE_7781_length_290_cov_1.009217_g7681_i0 | PRJEB76780 | 7781 | 290 | 1.009217 | 2.9267293 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 90.9 | 7.39e-19 | NR | MBA3380768.1 | 2900548 | g7681 | i0 | 54.7 | 0.982758620689655 | 95 | 43 | 98.3 | 0 | 5 | 289 | 379 | 473 | MBA3380768.1 serine/threonine protein kinase [Actinomycetota bacterium] | diamond | 285 | 90.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 996410 | 996410 | PRJEB76780_P_NODE_13441_length_242_cov_0.923077_g13341_i0 | PRJEB76780 | 13441 | 242 | 0.923077 | 2.23384634 | Candidatus Brevibacterium intestinigallinarum | 2838516 | Bacteria | Bacteria | 156 | 6.8700000000000015e-44 | NR | HJA37896.1 | 2838516 | g13341 | i0 | 87.5 | 0.991735537190083 | 80 | 10 | 99.2 | 0 | 3 | 242 | 258 | 337 | HJA37896.1 M1 family metallopeptidase [Candidatus Brevibacterium intestinigallinarum] | diamond | 240 | 156 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Brevibacteriaceae | Brevibacterium | Candidatus Brevibacterium intestinigallinarum | ||
| 5241330 | 5241330 | PRJEB76780_P_NODE_12805_length_244_cov_0.912281_g12705_i0 | PRJEB76780 | 12805 | 244 | 0.912281 | 2.22596564 | Blastococcus sp. CT_GayMR19 | 2559608 | Bacteria | Bacteria | 138 | 1.06e-36 | NR | WP_348633826.1 | 2559608 | g12705 | i0 | 87.7 | 0.995901639344262 | 81 | 10 | 99.6 | 0 | 243 | 1 | 17 | 97 | WP_348633826.1 TrkH family potassium uptake protein [Blastococcus sp. CT_GayMR19] | diamond | 243 | 138 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Geodermatophilales | Geodermatophilaceae | Blastococcus | Blastococcus sp. CT_GayMR19 | ||
| 7373956 | 7373956 | PRJEB76780_P_NODE_8566_length_277_cov_1.318627_g8466_i0 | PRJEB76780 | 8566 | 277 | 1.318627 | 3.65259679 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 177 | 1.67e-51 | NR | HET9601393.1 | 2201156 | g8466 | i0 | 98.9 | 0.996389891696751 | 92 | 1 | 99.6 | 0 | 277 | 2 | 223 | 314 | HET9601393.1 glycogen/starch synthase [Acidimicrobiales bacterium] | diamond | 276 | 177 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 16715486 | 16715486 | PRJEB76780_P_NODE_494_length_1124_cov_1.752617_g438_i0 | PRJEB76780 | 494 | 1124 | 1.752617 | 19.69941508 | Acidimicrobiia bacterium | 2080302 | Bacteria | Bacteria | 288 | 1.84e-89 | NR | MBK5222091.1 | 2080302 | g438 | i0 | 42 | 0.979537366548043 | 367 | 202 | 95.8 | 2 | 2 | 1078 | 115 | 478 | MBK5222091.1 MFS transporter [Acidimicrobiia bacterium] | diamond | 1101 | 288 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium | |||||
| 23090663 | 23090663 | PRJEB76780_P_NODE_10999_length_251_cov_0.876404_g10899_i0 | PRJEB76780 | 10999 | 251 | 0.876404 | 2.19977404 | Brachybacterium sp. HMSC | 1891286 | Bacteria | Bacteria | 144 | 2.2199999999999998e-39 | NR | WP_141748205.1 | 1581127 | g10899 | i0 | 85.5 | 0.99203187250996006 | 83 | 12 | 99.2 | 0 | 3 | 251 | 307 | 389 | WP_141748205.1 hypothetical protein, partial [Brachybacterium sp. HMSC06H03] | diamond | 249 | 144 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermabacteraceae | Brachybacterium | Brachybacterium sp. HMSC06H03 | ||
| 26876309 | 26876309 | PRJEB76780_P_NODE_12441_length_245_cov_0.906977_g12341_i0 | PRJEB76780 | 12441 | 245 | 0.906977 | 2.22209365 | Dermatophilaceae bacterium | 2728912 | Bacteria | Bacteria | 88.2 | 5.7e-19 | NR | HZW45582.1 | 2728912 | g12341 | i0 | 57 | 3.72244897959184 | 79 | 34 | 96.7 | 0 | 4 | 240 | 108 | 186 | HZW45582.1 SGNH/GDSL hydrolase family protein [Dermatophilaceae bacterium] | diamond | 912 | 88.2 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Dermatophilaceae | Dermatophilaceae bacterium | |||
| 27413760 | 27413760 | PRJEB76780_P_NODE_1423_length_694_cov_1.660225_g1329_i0 | PRJEB76780 | 1423 | 694 | 1.660225 | 11.5219615 | Conexibacter sp. | 1929289 | Bacteria | Bacteria | 48.5 | 0.0157 | NR | MCW2954729.1 | 1929289 | g1329 | i0 | 29.3 | 2.68443804034582 | 164 | 93 | 67 | 6 | 687 | 223 | 200 | 349 | MCW2954729.1 conserved repeat domain protein [Conexibacter sp.] | diamond | 1863 | 48.5 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Conexibacteraceae | Conexibacter | Conexibacter sp. | ||
| 27729605 | 27729605 | PRJEB76780_P_NODE_1804_length_619_cov_1.571429_g1707_i0 | PRJEB76780 | 1804 | 619 | 1.571429 | 9.72714551 | Acidimicrobiales bacterium | 2201156 | Bacteria | Bacteria | 77.4 | 5.63e-13 | NR | HEX5947907.1 | 2201156 | g1707 | i0 | 31.8 | 5.80613893376414 | 198 | 121 | 92.6 | 8 | 23 | 595 | 113 | 303 | HEX5947907.1 hypothetical protein [Acidimicrobiales bacterium] | diamond | 3594 | 77.4 | 1 | Bacteria | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiales | Acidimicrobiales bacterium | ||||
| 27824122 | 27824122 | PRJEB76780_P_NODE_6284_length_322_cov_1.433735_g6184_i0 | PRJEB76780 | 6284 | 322 | 1.433735 | 4.6166267 | Rhodococcus sp. G-MC3 | 3046209 | Bacteria | Bacteria | 58.9 | 1.54e-7 | NR | WP_283511579.1 | 3046209 | g6184 | i0 | 30.8 | 2.89751552795031 | 107 | 64 | 99.7 | 2 | 322 | 2 | 46 | 142 | WP_283511579.1 NAD-dependent epimerase/dehydratase family protein [Rhodococcus sp. G-MC3] | diamond | 933 | 58.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Nocardiaceae | Rhodococcus | Rhodococcus sp. G-MC3 | ||
| 28107982 | 28107982 | PRJEB76780_P_NODE_8565_length_277_cov_1.333333_g8465_i0 | PRJEB76780 | 8565 | 277 | 1.333333 | 3.69333241 | Streptomyces sp. NPDC | 1931 | Bacteria | Bacteria | 63.9 | 2.02e-9 | NR | WP_358822004.1 | 3155349 | g8465 | i0 | 62.1 | 2.4043321299639002 | 66 | 23 | 69.3 | 1 | 86 | 277 | 421 | 486 | WP_358822004.1 SGNH/GDSL hydrolase family protein [Streptomyces sp. NPDC006173] | diamond | 666 | 63.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces sp. NPDC006173 | ||
| 28581899 | 28581899 | PRJEB76780_P_NODE_13467_length_241_cov_2.577381_g13367_i0 | PRJEB76780 | 13467 | 241 | 2.577381 | 6.21148821 | Solirubrobacteraceae bacterium | 2586742 | Bacteria | Bacteria | 118 | 1.02e-31 | NR | HWT25480.1 | 2586742 | g13367 | i0 | 75.9 | 2.97510373443983 | 79 | 19 | 98.3 | 0 | 237 | 1 | 22 | 100 | HWT25480.1 bifunctional phosphoglucose/phosphomannose isomerase [Solirubrobacteraceae bacterium] | diamond | 717 | 118 | 1 | Bacteria | Bacillati | Actinomycetota | Thermoleophilia | Solirubrobacterales | Solirubrobacteraceae | Solirubrobacteraceae bacterium | |||
| 29024160 | 29024160 | PRJEB76780_P_NODE_12568_length_245_cov_0.906977_g12468_i0 | PRJEB76780 | 12568 | 245 | 0.906977 | 2.22209365 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 73.9 | 3.07e-13 | NR | MCA1836587.1 | 2900548 | g12468 | i0 | 54.7 | 1.70204081632653 | 64 | 29 | 78.4 | 0 | 17 | 208 | 23 | 86 | MCA1836587.1 multicopper oxidase domain-containing protein [Actinomycetota bacterium] | diamond | 417 | 73.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 29395411 | 29395411 | PRJEB76780_P_NODE_3669_length_426_cov_1.325779_g3569_i0 | PRJEB76780 | 3669 | 426 | 1.325779 | 5.64781854 | Actinomycetes | 1760 | Bacteria | Bacteria | 130 | 8.239999999999998e-35 | NR | GDY55159.1 | 68280 | g3569 | i0 | 56.3 | 10.7535211267606 | 103 | 45 | 72.5 | 0 | 117 | 425 | 49 | 151 | GDY55159.1 hypothetical protein SVIO_057820 [Streptomyces violaceusniger] | diamond | 4581 | 131 | 0.99236641221374 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Kitasatosporales | Streptomycetaceae | Streptomyces | Streptomyces violaceusniger | ||
| 29433922 | 29433922 | PRJEB76780_P_NODE_13030_length_243_cov_0.917647_g12930_i0 | PRJEB76780 | 13030 | 243 | 0.917647 | 2.22988221 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 98.6 | 7.82e-22 | NR | MDQ1287883.1 | 2900548 | g12930 | i0 | 57.5 | 3.64197530864198 | 73 | 31 | 90.1 | 0 | 6 | 224 | 460 | 532 | MDQ1287883.1 hypothetical protein [Actinomycetota bacterium] | diamond | 885 | 98.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30002823 | 30002823 | PRJEB76780_P_NODE_8451_length_279_cov_1.135922_g8351_i0 | PRJEB76780 | 8451 | 279 | 1.135922 | 3.16922238 | Kocuria marina | 223184 | Bacteria | Bacteria | 181 | 5.98e-57 | NR | WP_145008130.1 | 223184 | g8351 | i0 | 100 | 1 | 93 | 0 | 100 | 0 | 279 | 1 | 17 | 109 | WP_145008130.1 hypothetical protein [Kocuria marina] | diamond | 279 | 181 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Micrococcaceae | Kocuria | Kocuria marina | ||
| 30223736 | 30223736 | PRJEB76780_P_NODE_13152_length_243_cov_0.917647_g13052_i0 | PRJEB76780 | 13152 | 243 | 0.917647 | 2.22988221 | Lawsonella clevelandensis | 1528099 | Bacteria | Bacteria | 161 | 8.459999999999999e-47 | NR | PZP89146.1 | 1528099 | g13052 | i0 | 100 | 1 | 81 | 0 | 100 | 0 | 243 | 1 | 74 | 154 | PZP89146.1 MAG: hypothetical protein DI579_04450 [Lawsonella clevelandensis] | diamond | 243 | 161 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Mycobacteriales | Lawsonellaceae | Lawsonella | Lawsonella clevelandensis | ||
| 30476744 | 30476744 | PRJEB76780_P_NODE_8213_length_283_cov_1.000000_g8113_i0 | PRJEB76780 | 8213 | 283 | 1 | 2.83 | Micromonospora echinaurantiaca | 47857 | Bacteria | Bacteria | 45.8 | 0.00493 | NR | WP_088993160.1 | 47857 | g8113 | i0 | 34.7 | 0.795053003533569 | 75 | 49 | 79.5 | 0 | 57 | 281 | 698 | 772 | WP_088993160.1 BTAD domain-containing putative transcriptional regulator [Micromonospora echinaurantiaca] | diamond | 225 | 45.8 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micromonosporales | Micromonosporaceae | Micromonospora | Micromonospora echinaurantiaca | ||
| 30602830 | 30602830 | PRJEB76780_P_NODE_13253_length_242_cov_0.923077_g13153_i0 | PRJEB76780 | 13253 | 242 | 0.923077 | 2.23384634 | Ornithinibacter sp. | 2862748 | Bacteria | Bacteria | 132 | 1.21e-34 | NR | HYN66500.1 | 2862748 | g13153 | i0 | 88.8 | 0.991735537190083 | 80 | 9 | 99.2 | 0 | 2 | 241 | 133 | 212 | HYN66500.1 ABC transporter permease [Ornithinibacter sp.] | diamond | 240 | 132 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Intrasporangiaceae | Ornithinibacter | Ornithinibacter sp. | ||
| 30761034 | 30761034 | PRJEB76780_P_NODE_9534_length_263_cov_1.231579_g9434_i0 | PRJEB76780 | 9534 | 263 | 1.231579 | 3.23905277 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 70.9 | 5.63e-12 | NR | NCG35923.1 | 2900548 | g9434 | i0 | 48.7 | 1.75665399239544 | 76 | 12 | 86.7 | 2 | 1 | 228 | 286 | 334 | NCG35923.1 iron-containing alcohol dehydrogenase [Actinomycetota bacterium] | diamond | 462 | 70.9 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 30792485 | 30792485 | PRJEB76780_P_NODE_12874_length_244_cov_0.912281_g12774_i0 | PRJEB76780 | 12874 | 244 | 0.912281 | 2.22596564 | Microbacterium sp. BR1 | 1070896 | Bacteria | Bacteria | 139 | 3.4899999999999995e-37 | NR | WP_157813898.1 | 1070896 | g12774 | i0 | 86.4 | 0.995901639344262 | 81 | 11 | 99.6 | 0 | 244 | 2 | 192 | 272 | WP_157813898.1 hypothetical protein [Microbacterium sp. BR1] | diamond | 243 | 139 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Micrococcales | Microbacteriaceae | Microbacterium | Microbacterium sp. BR1 | ||
| 31234749 | 31234749 | PRJEB76780_P_NODE_7115_length_303_cov_1.117391_g7015_i0 | PRJEB76780 | 7115 | 303 | 1.117391 | 3.38569473 | Actinomycetes bacterium | 1883427 | Bacteria | Bacteria | 129 | 9e-33 | NR | MCH9718370.1 | 1883427 | g7015 | i0 | 56 | 3.96039603960396 | 100 | 44 | 99 | 0 | 300 | 1 | 378 | 477 | MCH9718370.1 alpha/beta hydrolase [Actinomycetes bacterium] | diamond | 1200 | 129 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Actinomycetes bacterium | |||||
| 32088953 | 32088953 | PRJEB76780_P_NODE_13038_length_243_cov_0.917647_g12938_i0 | PRJEB76780 | 13038 | 243 | 0.917647 | 2.22988221 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 56.6 | 4.55e-8 | NR | MBA2752014.1 | 2900548 | g12938 | i0 | 58 | 0.617283950617284 | 50 | 20 | 61.7 | 1 | 182 | 33 | 6 | 54 | MBA2752014.1 protease inhibitor I42 family protein [Actinomycetota bacterium] | diamond | 150 | 56.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetota bacterium | ||||||
| 32120764 | 32120764 | PRJEB76780_P_NODE_11598_length_248_cov_0.891429_g11498_i0 | PRJEB76780 | 11598 | 248 | 0.891429 | 2.21074392 | Candidatus Nanopelagicus abundans | 1884916 | Bacteria | Bacteria | 56.6 | 4.16e-7 | NR | WP_095688594.1 | 1884916 | g11498 | i0 | 61.4 | 0.532258064516129 | 44 | 17 | 53.2 | 0 | 109 | 240 | 1 | 44 | WP_095688594.1 dTDP-4-dehydrorhamnose reductase [Candidatus Nanopelagicus abundans] | diamond | 132 | 56.6 | 1 | Bacteria | Bacillati | Actinomycetota | Actinomycetes | Candidatus Nanopelagicales | Candidatus Nanopelagicaceae | Candidatus Nanopelagicus | Candidatus Nanopelagicus abundans | ||
| 32689432 | 32689432 | PRJEB76780_P_NODE_9800_length_259_cov_1.677419_g9700_i0 | PRJEB76780 | 9800 | 259 | 1.677419 | 4.34451521 | Actinomycetota bacterium | 2900548 | Bacteria | Bacteria | 41.6 | 0.0243 | NR | MCA1845286.1 | 2900548 | g9700 | i0 | 71.4 | 0.324324324324324 | 28 | 8 | 32.4 | 0 | 2 | 85 | 6 | 33 | MCA1845286.1 VWA domain-containing protein [Actinomycetota bacterium] | diamond | 84 | 41.6 | 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);;