contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA550047" and tax_clade = "delta/epsilon subdivisions"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5616841 | 5616841 | PRJNA550047_P_NODE_156145_length_345_cov_4.327206_g154185_i0 | PRJNA550047 | 156145 | 345 | 4.327206 | 14.9288607 | Bacteria | 2 | Bacteria | Bacteria | 58.9 | 1.28e-8 | NR | MCH8842216.1 | 2024889 | g154185 | i0 | 52 | 1.7304347826087 | 50 | 24 | 43.5 | 0 | 151 | 2 | 47 | 96 | MCH8842216.1 antibiotic biosynthesis monooxygenase [SAR324 cluster bacterium] | diamond | 597 | 58.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | SAR324 cluster bacterium | ||||||
| 17094540 | 17094540 | PRJNA550047_P_NODE_484534_length_235_cov_17.197531_g482561_i0 | PRJNA550047 | 484534 | 235 | 17.197531 | 40.41419785 | Myxococcota | 2818505 | Bacteria | Bacteria | 135 | 5.76e-36 | NR | OLC90403.1 | 1805117 | g482561 | i0 | 92.3 | 4.97872340425532 | 78 | 6 | 99.6 | 0 | 2 | 235 | 102 | 179 | OLC90403.1 MAG: hypothetical protein AUJ03_01280 [Deltaproteobacteria bacterium 13_1_40CM_3_71_4] | diamond | 1170 | 135 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium 13_1_40CM_3_71_4 | ||||||
| 24739389 | 24739389 | PRJNA550047_P_NODE_185060_length_344_cov_21.594096_g183100_i0 | PRJNA550047 | 185060 | 344 | 21.594096 | 74.28369024 | Myxococcota | 2818505 | Bacteria | Bacteria | 83.2 | 2.19e-16 | NR | OLC90735.1 | 1805117 | g183100 | i0 | 69.4 | 1.73546511627907 | 49 | 15 | 42.7 | 0 | 344 | 198 | 190 | 238 | OLC90735.1 MAG: hypothetical protein AUJ03_00505 [Deltaproteobacteria bacterium 13_1_40CM_3_71_4] | diamond | 597 | 83.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium 13_1_40CM_3_71_4 | ||||||
| 27488958 | 27488958 | PRJNA550047_P_NODE_462003_length_243_cov_7.400000_g460030_i0 | PRJNA550047 | 462003 | 243 | 7.4 | 17.982 | Deltaproteobacteria bacterium RIFCSPLOWO2_ | 2026735 | Bacteria | Bacteria | 138 | 1.02e-35 | NR | OGQ53910.1 | 1797882 | g460030 | i0 | 84.8 | 3.92592592592593 | 79 | 12 | 97.5 | 0 | 3 | 239 | 511 | 589 | OGQ53910.1 MAG: hypothetical protein A3J24_07170 [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8] | diamond | 954 | 138 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8 | ||||||
| 27551761 | 27551761 | PRJNA550047_P_NODE_308064_length_296_cov_8.264574_g306095_i0 | PRJNA550047 | 308064 | 296 | 8.264574 | 24.46313904 | Persicimonas sp. | 2766932 | Bacteria | Bacteria | 69.7 | 2.28e-11 | NR | MFP4600325.1 | 2766932 | g306095 | i0 | 66 | 0.506756756756757 | 50 | 17 | 50.7 | 0 | 145 | 294 | 214 | 263 | MFP4600325.1 hypothetical protein [Persicimonas sp.] | diamond | 150 | 69.7 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Bradymonadaceae | Persicimonas | Persicimonas sp. | |||
| 27551778 | 27551778 | PRJNA550047_P_NODE_347104_length_286_cov_8.286385_g345133_i0 | PRJNA550047 | 347104 | 286 | 8.286385 | 23.6990611 | Deltaproteobacteria bacterium 13_1_4 | 2026735 | Bacteria | Bacteria | 173 | 1.16e-50 | NR | OLC71229.1 | 1805121 | g345133 | i0 | 83.2 | 1.99300699300699 | 95 | 16 | 99.7 | 0 | 2 | 286 | 88 | 182 | OLC71229.1 MAG: hypothetical protein AUH83_16125 [Deltaproteobacteria bacterium 13_1_40CM_4_68_19] | diamond | 570 | 173 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium 13_1_40CM_4_68_19 | ||||||
| 27678520 | 27678520 | PRJNA550047_P_NODE_173044_length_345_cov_3.147059_g171084_i0 | PRJNA550047 | 173044 | 345 | 3.147059 | 10.85735355 | Deltaproteobacteria bacterium RIFOXYD2_FULL_66_9 | 1797907 | Bacteria | Bacteria | 66.2 | 1.06e-10 | NR | OGR21289.1 | 1797907 | g171084 | i0 | 65.3 | 0.852173913043478 | 49 | 17 | 42.6 | 0 | 344 | 198 | 19 | 67 | OGR21289.1 MAG: hypothetical protein A2559_00820 [Deltaproteobacteria bacterium RIFOXYD2_FULL_66_9] | diamond | 294 | 66.2 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFOXYD2_FULL_66_9 | ||||||
| 28040418 | 28040418 | PRJNA550047_P_NODE_526585_length_221_cov_14.209459_g524612_i0 | PRJNA550047 | 526585 | 221 | 14.209459 | 31.40290439 | Myxococcota | 2818505 | Bacteria | Bacteria | 70.9 | 3.38e-12 | NR | OGQ10590.1 | 1797848 | g524612 | i0 | 59.2 | 1.92760180995475 | 71 | 29 | 96.4 | 0 | 220 | 8 | 430 | 500 | OGQ10590.1 MAG: hypothetical protein A2138_07565 [Deltaproteobacteria bacterium RBG_16_71_12] | diamond | 426 | 70.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RBG_16_71_12 | ||||||
| 28214786 | 28214786 | PRJNA550047_P_NODE_275206_length_299_cov_7.592920_g273237_i0 | PRJNA550047 | 275206 | 299 | 7.59292 | 22.7028308 | Lujinxingiaceae bacterium | 2946527 | Bacteria | Bacteria | 80.1 | 4.87e-15 | NR | MBA2662048.1 | 2946527 | g273237 | i0 | 82 | 0.501672240802676 | 50 | 9 | 50.2 | 0 | 1 | 150 | 382 | 431 | MBA2662048.1 MFS transporter [Lujinxingiaceae bacterium] | diamond | 150 | 80.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Lujinxingiaceae | Lujinxingiaceae bacterium | ||||
| 29099201 | 29099201 | PRJNA550047_P_NODE_368428_length_277_cov_13.215686_g366457_i0 | PRJNA550047 | 368428 | 277 | 13.215686 | 36.60745022 | Deltaproteobacteria bacterium GWA2_55_1 | 2026735 | Bacteria | Bacteria | 65.1 | 9.95e-11 | NR | OGP19504.1 | 1797809 | g366457 | i0 | 53.4 | 0.790613718411552 | 73 | 27 | 79.1 | 1 | 57 | 275 | 5 | 70 | OGP19504.1 MAG: hypothetical protein A2054_01345 [Deltaproteobacteria bacterium GWA2_55_10] | diamond | 219 | 65.1 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium GWA2_55_10 | ||||||
| 30140967 | 30140967 | PRJNA550047_P_NODE_596312_length_199_cov_7.944444_g594339_i0 | PRJNA550047 | 596312 | 199 | 7.944444 | 15.80944356 | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8 | 2013758 | Bacteria | Bacteria | 112 | 6.0100000000000005e-27 | NR | PKN07903.1 | 2013758 | g594339 | i0 | 83.3 | 3.97989949748744 | 66 | 11 | 99.5 | 0 | 2 | 199 | 167 | 232 | PKN07903.1 MAG: DNA methyltransferase [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8] | diamond | 792 | 112 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-8 | ||||||
| 30282746 | 30282746 | PRJNA550047_P_NODE_399272_length_265_cov_8.838542_g397300_i0 | PRJNA550047 | 399272 | 265 | 8.838542 | 23.4221363 | Bacteria | 2 | Bacteria | Bacteria | 123 | 8.789999999999999e-32 | NR | OYV72578.1 | 1970506 | g397300 | i0 | 73.6 | 1.9811320754717 | 87 | 23 | 98.5 | 0 | 2 | 262 | 132 | 218 | OYV72578.1 MAG: N4-gp56 family major capsid protein [Deltaproteobacteria bacterium 21-66-5] | diamond | 525 | 123 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium 21-66-5 | ||||||
| 30678182 | 30678182 | PRJNA550047_P_NODE_346993_length_286_cov_8.938967_g345022_i0 | PRJNA550047 | 346993 | 286 | 8.938967 | 25.56544562 | Deltaproteobacteria bacterium 21-66-5 | 1970506 | Bacteria | Bacteria | 127 | 5.48e-33 | NR | OYV72578.1 | 1970506 | g345022 | i0 | 68.4 | 2.98951048951049 | 95 | 30 | 99.7 | 0 | 1 | 285 | 45 | 139 | OYV72578.1 MAG: N4-gp56 family major capsid protein [Deltaproteobacteria bacterium 21-66-5] | diamond | 855 | 127 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium 21-66-5 | ||||||
| 31578248 | 31578248 | PRJNA550047_P_NODE_550416_length_213_cov_14.500000_g548443_i0 | PRJNA550047 | 550416 | 213 | 14.5 | 30.885 | Myxococcota | 2818505 | Bacteria | Bacteria | 84.7 | 3.91e-17 | NR | PKN50023.1 | 2013748 | g548443 | i0 | 73.2 | 9.56338028169014 | 56 | 15 | 78.9 | 0 | 40 | 207 | 1 | 56 | PKN50023.1 MAG: type VI secretion system ATPase TssH, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20] | diamond | 2037 | 85.1 | 0.995299647473561 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium HGW-Deltaproteobacteria-20 | ||||||
| 31626687 | 31626687 | PRJNA550047_P_NODE_49516_length_345_cov_24.272059_g47556_i0 | PRJNA550047 | 49516 | 345 | 24.272059 | 83.73860355 | Deltaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_9 | 1797867 | Bacteria | Bacteria | 67.4 | 2.59e-10 | NR | OGQ34140.1 | 1797867 | g47556 | i0 | 59.2 | 1.6695652173913 | 49 | 20 | 42.6 | 0 | 344 | 198 | 322 | 370 | OGQ34140.1 MAG: oligopeptide-binding protein oppA [Deltaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_9] | diamond | 576 | 67.4 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium RIFCSPHIGHO2_12_FULL_43_9 | ||||||
| 32069574 | 32069574 | PRJNA550047_P_NODE_417518_length_258_cov_9.686486_g415546_i0 | PRJNA550047 | 417518 | 258 | 9.686486 | 24.99113388 | Microvenator marinus | 2600177 | Bacteria | Bacteria | 86.3 | 2.13e-17 | NR | WP_146959159.1 | 2600177 | g415546 | i0 | 50 | 1 | 86 | 38 | 95.3 | 3 | 247 | 2 | 468 | 552 | WP_146959159.1 choice-of-anchor D domain-containing protein [Microvenator marinus] | diamond | 258 | 86.3 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Bradymonadales | Microvenatoraceae | Microvenator | Microvenator marinus | |||
| 32259755 | 32259755 | PRJNA550047_P_NODE_393598_length_267_cov_11.927835_g391626_i0 | PRJNA550047 | 393598 | 267 | 11.927835 | 31.84731945 | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | 1973967 | Bacteria | Bacteria | 63.9 | 3.38e-11 | NR | PJB35771.1 | 1973967 | g391626 | i0 | 69 | 0.471910112359551 | 42 | 13 | 47.2 | 0 | 265 | 140 | 26 | 67 | PJB35771.1 MAG: DNA-binding protein [Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12] | diamond | 126 | 63.9 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium CG_4_9_14_3_um_filter_63_12 | ||||||
| 32417715 | 32417715 | PRJNA550047_P_NODE_320859_length_294_cov_8.674208_g318889_i0 | PRJNA550047 | 320859 | 294 | 8.674208 | 25.50217152 | Deltaproteobacteria bacterium PRO3 | 2575691 | Bacteria | Bacteria | 79 | 1.29e-14 | NR | MDL1870712.1 | 2575691 | g318889 | i0 | 69.6 | 0.887755102040816 | 46 | 14 | 46.9 | 0 | 5 | 142 | 815 | 860 | MDL1870712.1 sensor histidine kinase KdpD [Deltaproteobacteria bacterium PRO3] | diamond | 261 | 79 | 1 | Bacteria | delta/epsilon subdivisions | Deltaproteobacteria | Deltaproteobacteria bacterium PRO3 |
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);;