contig_metadata
11 rows where bioproject = "PRJEB66218" and tax_phylum = "Candidatus Kapaibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26653959 | 26653959 | PRJEB66218_P_NODE_87681_length_333_cov_1.481618_g85254_i0 | PRJEB66218 | 87681 | 333 | 1.481618 | 4.93378794 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 178 | 2.54e-49 | NR | MCU0425070.1 | 2447898 | g85254 | i0 | 80.9 | 2.02702702702703 | 115 | 17 | 99.1 | 1 | 332 | 3 | 2005 | 2119 | MCU0425070.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 675 | 178 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 27191889 | 27191889 | PRJEB66218_P_NODE_151982_length_240_cov_1.452514_g149553_i0 | PRJEB66218 | 151982 | 240 | 1.452514 | 3.4860336 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 47.8 | 6.24e-4 | NR | TAE31352.1 | 2447898 | g149553 | i0 | 38.5 | 1.975 | 78 | 44 | 96.3 | 3 | 8 | 238 | 1759 | 1833 | TAE31352.1 MAG: hypothetical protein EAZ92_02995, partial [Candidatus Kapaibacterium sp.] | diamond | 474 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29055277 | 29055277 | PRJEB66218_P_NODE_209928_length_208_cov_1.591837_g207498_i0 | PRJEB66218 | 209928 | 208 | 1.591837 | 3.31102096 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 122 | 1.62e-30 | NR | MBL7993068.1 | 2447898 | g207498 | i0 | 92.8 | 0.995192307692308 | 69 | 5 | 99.5 | 0 | 2 | 208 | 2390 | 2458 | MBL7993068.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 207 | 122 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29086798 | 29086798 | PRJEB66218_P_NODE_134168_length_257_cov_1.658163_g131739_i0 | PRJEB66218 | 134168 | 257 | 1.658163 | 4.26147891 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 141 | 1.07e-36 | NR | MBL7993068.1 | 2447898 | g131739 | i0 | 87.1 | 0.992217898832685 | 85 | 10 | 99.2 | 1 | 1 | 255 | 953 | 1036 | MBL7993068.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 255 | 141 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29717842 | 29717842 | PRJEB66218_P_NODE_134070_length_257_cov_1.959184_g131641_i0 | PRJEB66218 | 134070 | 257 | 1.959184 | 5.03510288 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 169 | 2.0799999999999998e-46 | NR | MBL7993068.1 | 2447898 | g131641 | i0 | 94.1 | 0.992217898832685 | 85 | 5 | 99.2 | 0 | 2 | 256 | 2638 | 2722 | MBL7993068.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 255 | 169 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 29907841 | 29907841 | PRJEB66218_P_NODE_237011_length_203_cov_0.915493_g234580_i0 | PRJEB66218 | 237011 | 203 | 0.915493 | 1.85845079 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 96.7 | 4.42e-22 | NR | MBL7990090.1 | 2447898 | g234580 | i0 | 96.1 | 0.753694581280788 | 51 | 2 | 75.4 | 0 | 153 | 1 | 1 | 51 | MBL7990090.1 protein translocase subunit SecF [Candidatus Kapaibacterium sp.] | diamond | 153 | 96.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30382047 | 30382047 | PRJEB66218_P_NODE_56953_length_440_cov_1.203166_g54533_i0 | PRJEB66218 | 56953 | 440 | 1.203166 | 5.2939304 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 65.9 | 2.8e-9 | NR | MBL7990637.1 | 2447898 | g54533 | i0 | 40.3 | 2.60454545454545 | 124 | 71 | 84.5 | 3 | 5 | 376 | 183 | 303 | MBL7990637.1 IPT/TIG domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 1146 | 65.9 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30476533 | 30476533 | PRJEB66218_P_NODE_220493_length_206_cov_0.896552_g218063_i0 | PRJEB66218 | 220493 | 206 | 0.896552 | 1.84689712 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 55.1 | 1.05e-6 | NR | MCU0424158.1 | 2447898 | g218063 | i0 | 46.9 | 0.932038834951456 | 64 | 33 | 91.7 | 1 | 204 | 16 | 31 | 94 | MCU0424158.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 192 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 30823876 | 30823876 | PRJEB66218_P_NODE_139934_length_251_cov_1.368421_g137505_i0 | PRJEB66218 | 139934 | 251 | 1.368421 | 3.43473671 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 156 | 5.359999999999998e-42 | NR | MBL7989897.1 | 2447898 | g137505 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 1 | 249 | 1135 | 1217 | MBL7989897.1 hypothetical protein [Candidatus Kapaibacterium sp.] | diamond | 249 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31076837 | 31076837 | PRJEB66218_P_NODE_241495_length_202_cov_0.921986_g239064_i0 | PRJEB66218 | 241495 | 202 | 0.921986 | 1.86241172 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 132 | 4.14e-34 | NR | MCU0426963.1 | 2447898 | g239064 | i0 | 95.3 | 1.9009900990099 | 64 | 3 | 95 | 0 | 200 | 9 | 29 | 92 | MCU0426963.1 M1 family metallopeptidase [Candidatus Kapaibacterium sp.] | diamond | 384 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 31614166 | 31614166 | PRJEB66218_P_NODE_116256_length_280_cov_1.447489_g113827_i0 | PRJEB66218 | 116256 | 280 | 1.447489 | 4.0529692 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 171 | 5.92e-47 | NR | MBL7993068.1 | 2447898 | g113827 | i0 | 93.5 | 0.985714285714286 | 92 | 6 | 98.6 | 0 | 278 | 3 | 2084 | 2175 | MBL7993068.1 T9SS type A sorting domain-containing protein [Candidatus Kapaibacterium sp.] | diamond | 276 | 171 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. |
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);;