contig_metadata
20 rows where bioproject = "PRJNA1204310" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19455636 | 19455636 | PRJNA1204310_P_NODE_51876_length_252_cov_0.871508_g51579_i0 | PRJNA1204310 | 51876 | 252 | 0.871508 | 2.19620016 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79 | 7.48e-15 | NR | MEZ0208545.1 | 2053589 | g51579 | i0 | 49.4 | 0.988095238095238 | 83 | 41 | 97.6 | 1 | 248 | 3 | 1101 | 1183 | MEZ0208545.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 249 | 79 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27388866 | 27388866 | PRJNA1204310_P_NODE_41783_length_287_cov_1.116822_g41486_i0 | PRJNA1204310 | 41783 | 287 | 1.116822 | 3.20527914 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 100 | 1.9300000000000001e-22 | NR | MEZ0208865.1 | 2053589 | g41486 | i0 | 51.6 | 0.97212543554007 | 93 | 45 | 97.2 | 0 | 279 | 1 | 91 | 183 | MEZ0208865.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 279 | 100 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27609787 | 27609787 | PRJNA1204310_P_NODE_4864_length_765_cov_2.408960_g4606_i0 | PRJNA1204310 | 4864 | 765 | 2.40896 | 18.428544 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 77.8 | 3.6e-12 | NR | MEZ0208674.1 | 2053589 | g4606 | i0 | 36.2 | 0.541176470588235 | 138 | 66 | 45.5 | 3 | 415 | 762 | 1 | 138 | MEZ0208674.1 reverse transcriptase family protein [Candidatus Paceibacterota bacterium] | diamond | 414 | 77.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27767760 | 27767760 | PRJNA1204310_P_NODE_19564_length_408_cov_1.376119_g19267_i0 | PRJNA1204310 | 19564 | 408 | 1.376119 | 5.61456552 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 155 | 8.32e-41 | NR | MEZ0208986.1 | 2053589 | g19267 | i0 | 55.9 | 1 | 136 | 59 | 99.3 | 1 | 2 | 406 | 1225 | 1360 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 408 | 155 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27893760 | 27893760 | PRJNA1204310_P_NODE_45345_length_274_cov_1.343284_g45048_i0 | PRJNA1204310 | 45345 | 274 | 1.343284 | 3.68059816 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 106 | 2.1599999999999998e-24 | NR | MEZ0208921.1 | 2053589 | g45048 | i0 | 61.1 | 0.985401459854015 | 90 | 35 | 98.5 | 0 | 274 | 5 | 283 | 372 | MEZ0208921.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 270 | 106 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28272543 | 28272543 | PRJNA1204310_P_NODE_27906_length_350_cov_3.061372_g27609_i0 | PRJNA1204310 | 27906 | 350 | 3.061372 | 10.714802 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 115 | 4.05e-27 | NR | MEZ0208674.1 | 2053589 | g27609 | i0 | 49.6 | 1.00285714285714 | 117 | 58 | 99.4 | 1 | 3 | 350 | 148 | 264 | MEZ0208674.1 reverse transcriptase family protein [Candidatus Paceibacterota bacterium] | diamond | 351 | 115 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28809166 | 28809166 | PRJNA1204310_P_NODE_22188_length_387_cov_0.993631_g21891_i0 | PRJNA1204310 | 22188 | 387 | 0.993631 | 3.84535197 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 163 | 2.6299999999999997e-45 | NR | MEZ0209058.1 | 2053589 | g21891 | i0 | 61.7 | 0.992248062015504 | 128 | 49 | 99.2 | 0 | 4 | 387 | 105 | 232 | MEZ0209058.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 384 | 163 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29377865 | 29377865 | PRJNA1204310_P_NODE_41349_length_288_cov_1.483721_g41052_i0 | PRJNA1204310 | 41349 | 288 | 1.483721 | 4.27311648 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 72.8 | 1.77e-12 | NR | MEZ0208986.1 | 2053589 | g41052 | i0 | 36.6 | 0.96875 | 93 | 58 | 96.9 | 1 | 9 | 287 | 799 | 890 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 279 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29567173 | 29567173 | PRJNA1204310_P_NODE_57910_length_247_cov_0.867816_g57613_i0 | PRJNA1204310 | 57910 | 247 | 0.867816 | 2.14350552 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.5 | 1.07e-7 | NR | MEZ0209072.1 | 2053589 | g57613 | i0 | 41.8 | 0.813765182186235 | 67 | 39 | 81.4 | 0 | 246 | 46 | 34 | 100 | MEZ0209072.1 DDE-type integrase/transposase/recombinase [Candidatus Paceibacterota bacterium] | diamond | 201 | 58.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30135431 | 30135431 | PRJNA1204310_P_NODE_14552_length_465_cov_1.420918_g14255_i0 | PRJNA1204310 | 14552 | 465 | 1.420918 | 6.6072687 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 155 | 1.76e-40 | NR | MEZ0208867.1 | 2053589 | g14255 | i0 | 60.7 | 0.754838709677419 | 117 | 45 | 75.5 | 1 | 5 | 355 | 1905 | 2020 | MEZ0208867.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 351 | 155 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30957478 | 30957478 | PRJNA1204310_P_NODE_55734_length_249_cov_0.886364_g55437_i0 | PRJNA1204310 | 55734 | 249 | 0.886364 | 2.20704636 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 75.5 | 7.84e-15 | NR | MEZ0209059.1 | 2053589 | g55437 | i0 | 51.2 | 0.987951807228916 | 82 | 39 | 98.8 | 1 | 4 | 249 | 22 | 102 | MEZ0209059.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 246 | 75.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31020561 | 31020561 | PRJNA1204310_P_NODE_48915_length_260_cov_1.251337_g48618_i0 | PRJNA1204310 | 48915 | 260 | 1.251337 | 3.2534762 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.5 | 2.23e-9 | NR | MEZ0208867.1 | 2053589 | g48618 | i0 | 33.3 | 1.00384615384615 | 87 | 57 | 99.2 | 1 | 258 | 1 | 391 | 477 | MEZ0208867.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 261 | 63.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31273302 | 31273302 | PRJNA1204310_P_NODE_39035_length_297_cov_1.325893_g38738_i0 | PRJNA1204310 | 39035 | 297 | 1.325893 | 3.93790221 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 109 | 1.44e-25 | NR | MEZ0208865.1 | 2053589 | g38738 | i0 | 59.1 | 0.888888888888889 | 88 | 35 | 88.9 | 1 | 3 | 266 | 354 | 440 | MEZ0208865.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 264 | 109 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31652669 | 31652669 | PRJNA1204310_P_NODE_45377_length_274_cov_1.208955_g45080_i0 | PRJNA1204310 | 45377 | 274 | 1.208955 | 3.3125367 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 87 | 1.5e-17 | NR | MEZ0208986.1 | 2053589 | g45080 | i0 | 44.9 | 0.974452554744526 | 89 | 48 | 97.4 | 1 | 4 | 270 | 1035 | 1122 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 267 | 87 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32064021 | 32064021 | PRJNA1204310_P_NODE_42258_length_285_cov_1.471698_g41961_i0 | PRJNA1204310 | 42258 | 285 | 1.471698 | 4.1943393 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 94.7 | 3.34e-20 | NR | MEZ0208986.1 | 2053589 | g41961 | i0 | 47.6 | 1.08421052631579 | 103 | 43 | 96.8 | 2 | 278 | 3 | 741 | 843 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 309 | 94.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32127587 | 32127587 | PRJNA1204310_P_NODE_34238_length_319_cov_1.365854_g33941_i0 | PRJNA1204310 | 34238 | 319 | 1.365854 | 4.35707426 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 95.9 | 1.99e-22 | NR | MEZ0209059.1 | 2053589 | g33941 | i0 | 59.6 | 0.978056426332288 | 104 | 37 | 95.9 | 2 | 314 | 9 | 1 | 101 | MEZ0209059.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 312 | 95.9 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32190772 | 32190772 | PRJNA1204310_P_NODE_43898_length_279_cov_2.053398_g43601_i0 | PRJNA1204310 | 43898 | 279 | 2.053398 | 5.72898042 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42 | 0.0186 | NR | MFA6050621.1 | 2053589 | g43601 | i0 | 41.8 | 0.591397849462366 | 55 | 31 | 58.1 | 1 | 70 | 231 | 6 | 60 | MFA6050621.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 165 | 42 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32254295 | 32254295 | PRJNA1204310_P_NODE_41478_length_288_cov_1.144186_g41181_i0 | PRJNA1204310 | 41478 | 288 | 1.144186 | 3.29525568 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 122 | 4.85e-30 | NR | MEZ0208867.1 | 2053589 | g41181 | i0 | 61.1 | 0.989583333333333 | 95 | 37 | 99 | 0 | 3 | 287 | 1203 | 1297 | MEZ0208867.1 reverse transcriptase domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 285 | 122 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32538972 | 32538972 | PRJNA1204310_P_NODE_7419_length_635_cov_2.190391_g7133_i0 | PRJNA1204310 | 7419 | 635 | 2.190391 | 13.90898285 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 111 | 2.49e-24 | NR | MEZ0208674.1 | 2053589 | g7133 | i0 | 42.9 | 0.737007874015748 | 156 | 67 | 69.4 | 6 | 633 | 193 | 274 | 416 | MEZ0208674.1 reverse transcriptase family protein [Candidatus Paceibacterota bacterium] | diamond | 468 | 111 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32759296 | 32759296 | PRJNA1204310_P_NODE_56740_length_248_cov_0.891429_g56443_i0 | PRJNA1204310 | 56740 | 248 | 0.891429 | 2.21074392 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 107 | 9.68e-25 | NR | MEZ0208986.1 | 2053589 | g56443 | i0 | 51.3 | 0.943548387096774 | 78 | 37 | 94.4 | 1 | 1 | 234 | 889 | 965 | MEZ0208986.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 234 | 107 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota 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);;