contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJEB14175" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25916145 | 25916145 | PRJEB14175_P_NODE_25740_length_728_cov_12.496252_g23738_i0 | PRJEB14175 | 25740 | 728 | 12.496252 | 90.97271456 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 254 | 1.9e-80 | NR | MFA5433179.1 | 2053589 | g23738 | i0 | 87.2 | 0.60989010989011 | 148 | 19 | 61 | 0 | 283 | 726 | 1 | 148 | MFA5433179.1 DUF3644 domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 444 | 254 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26317586 | 26317586 | PRJEB14175_P_NODE_110063_length_337_cov_7.192029_g107797_i0 | PRJEB14175 | 110063 | 337 | 7.192029 | 24.23713773 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 106 | 2.04e-25 | NR | MFM7088893.1 | 2053589 | g107797 | i0 | 49.5 | 2.66172106824926 | 103 | 52 | 91.7 | 0 | 3 | 311 | 67 | 169 | MFM7088893.1 deoxyribonuclease IV [Candidatus Paceibacterota bacterium] | diamond | 897 | 106 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32910166 | 32910166 | PRJEB14175_P_NODE_82785_length_400_cov_8.200590_g80521_i0 | PRJEB14175 | 82785 | 400 | 8.20059 | 32.80236 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.2 | 1.3e-8 | NR | HEY6020108.1 | 2053589 | g80521 | i0 | 46.8 | 1.005 | 79 | 39 | 57 | 2 | 3 | 230 | 129 | 207 | HEY6020108.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 402 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32927393 | 32927393 | PRJEB14175_P_NODE_88777_length_384_cov_8.904025_g86512_i0 | PRJEB14175 | 88777 | 384 | 8.904025 | 34.191456 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 83.2 | 1.59e-17 | NR | MDR3549426.1 | 2053589 | g86512 | i0 | 55.2 | 0.75 | 96 | 33 | 73.4 | 3 | 368 | 87 | 1 | 88 | MDR3549426.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 288 | 83.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32943226 | 32943226 | PRJEB14175_P_NODE_188282_length_237_cov_40.568182_g186015_i0 | PRJEB14175 | 188282 | 237 | 40.568182 | 96.14659134 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 85.5 | 3.01e-17 | NR | HEY4490285.1 | 2053589 | g186015 | i0 | 59.7 | 0.848101265822785 | 67 | 26 | 84.8 | 1 | 212 | 12 | 771 | 836 | HEY4490285.1 preprotein translocase subunit SecA [Candidatus Paceibacterota bacterium] | diamond | 201 | 85.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32960004 | 32960004 | PRJEB14175_P_NODE_14210_length_950_cov_330.377953_g12615_i0 | PRJEB14175 | 14210 | 950 | 330.377953 | 3138.5905535 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 182 | 3.4899999999999995e-52 | NR | HZS43383.1 | 2053589 | g12615 | i0 | 45.5 | 0.735789473684211 | 233 | 127 | 73.6 | 0 | 173 | 871 | 5 | 237 | HZS43383.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 699 | 182 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32977620 | 32977620 | PRJEB14175_P_NODE_194227_length_233_cov_1.116279_g191960_i0 | PRJEB14175 | 194227 | 233 | 1.116279 | 2.60093007 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 51.6 | 3.8e-6 | NR | HWO07159.1 | 2053589 | g191960 | i0 | 55.6 | 1.10729613733906 | 45 | 20 | 57.9 | 0 | 66 | 200 | 5 | 49 | HWO07159.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 258 | 51.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33029378 | 33029378 | PRJEB14175_P_NODE_276860_length_175_cov_54.263158_g274592_i0 | PRJEB14175 | 276860 | 175 | 54.263158 | 94.9605265 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 67.4 | 6.52e-12 | NR | MDD4804377.1 | 2053589 | g274592 | i0 | 77.5 | 0.685714285714286 | 40 | 9 | 68.6 | 0 | 49 | 168 | 101 | 140 | MDD4804377.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 120 | 67.4 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33063693 | 33063693 | PRJEB14175_P_NODE_63293_length_465_cov_11.923267_g61037_i0 | PRJEB14175 | 63293 | 465 | 11.923267 | 55.44319155 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 153 | 6.659999999999999e-45 | NR | MDR3570671.1 | 2053589 | g61037 | i0 | 80.8 | 0.638709677419355 | 99 | 19 | 63.9 | 0 | 4 | 300 | 13 | 111 | MDR3570671.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 297 | 153 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33063773 | 33063773 | PRJEB14175_P_NODE_71053_length_437_cov_3.571809_g68794_i0 | PRJEB14175 | 71053 | 437 | 3.571809 | 15.60880533 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 155 | 1.45e-44 | NR | HZS43394.1 | 2053589 | g68794 | i0 | 56.4 | 1.9908466819222 | 140 | 56 | 96.1 | 2 | 3 | 422 | 67 | 201 | HZS43394.1 FAD-dependent thymidylate synthase [Candidatus Paceibacterota bacterium] | diamond | 870 | 155 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33080159 | 33080159 | PRJEB14175_P_NODE_233406_length_207_cov_28.205479_g231138_i0 | PRJEB14175 | 233406 | 207 | 28.205479 | 58.38534153 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.2 | 1.43e-9 | NR | HEY4515934.1 | 2053589 | g231138 | i0 | 88.6 | 2.02898550724638 | 35 | 4 | 50.7 | 0 | 102 | 206 | 83 | 117 | HEY4515934.1 valine--tRNA ligase [Candidatus Paceibacterota bacterium] | diamond | 420 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33113359 | 33113359 | PRJEB14175_P_NODE_139599_length_290_cov_2.794760_g137332_i0 | PRJEB14175 | 139599 | 290 | 2.79476 | 8.104804 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 61.6 | 1.32e-8 | NR | MDD5356582.1 | 2053589 | g137332 | i0 | 40.7 | 2.2448275862069 | 113 | 36 | 96.2 | 5 | 279 | 1 | 73 | 174 | MDD5356582.1 CHC2 zinc finger domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 651 | 61.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33127546 | 33127546 | PRJEB14175_P_NODE_3943_length_1708_cov_3.995750_g3160_i0 | PRJEB14175 | 3943 | 1708 | 3.99575 | 68.24741 | Bacteria | 2 | Bacteria | Bacteria | 100 | 5.02e-20 | NR | HRT09899.1 | 2053589 | g3160 | i0 | 51.6 | 0.511124121779859 | 122 | 58 | 21.4 | 1 | 728 | 363 | 23 | 143 | HRT09899.1 PEP-CTERM sorting domain-containing protein [Candidatus Paceibacterota bacterium] | diamond | 873 | 100 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 33165459 | 33165459 | PRJEB14175_P_NODE_240080_length_206_cov_0.882759_g237812_i0 | PRJEB14175 | 240080 | 206 | 0.882759 | 1.81848354 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 92.4 | 2.36e-20 | NR | HMO77691.1 | 2053589 | g237812 | i0 | 73.8 | 2.76699029126214 | 61 | 16 | 88.8 | 0 | 23 | 205 | 84 | 144 | HMO77691.1 UDP-N-acetylmuramate dehydrogenase [Candidatus Paceibacterota bacterium] | diamond | 570 | 92.4 | 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);;