contig_metadata
15 rows where bioproject = "PRJNA1167252" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19440626 | 19440626 | PRJNA1167252_P_NODE_29536_length_242_cov_0.923077_g29263_i0 | PRJNA1167252 | 29536 | 242 | 0.923077 | 2.23384634 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 140 | 5.469999999999999e-38 | NR | MCW9097803.1 | 2651163 | g29263 | i0 | 81.3 | 2.97520661157025 | 80 | 15 | 99.2 | 0 | 1 | 240 | 211 | 290 | MCW9097803.1 group II intron reverse transcriptase/maturase [Ignavibacteriaceae bacterium] | diamond | 720 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 26616491 | 26616491 | PRJNA1167252_P_NODE_25821_length_248_cov_0.891429_g25548_i0 | PRJNA1167252 | 25821 | 248 | 0.891429 | 2.21074392 | Bacteria | 2 | Bacteria | Bacteria | 117 | 1.33e-30 | NR | MCB0749385.1 | 2026749 | g25548 | i0 | 70.4 | 1.95967741935484 | 81 | 24 | 98 | 0 | 1 | 243 | 44 | 124 | MCB0749385.1 bacillithiol biosynthesis deacetylase BshB1 [Ignavibacteriota bacterium] | diamond | 486 | 117 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 26692210 | 26692210 | PRJNA1167252_P_NODE_29641_length_242_cov_0.893491_g29368_i0 | PRJNA1167252 | 29641 | 242 | 0.893491 | 2.16224822 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 103 | 4.3999999999999995e-25 | NR | MCB9247838.1 | 2049428 | g29368 | i0 | 62.5 | 0.991735537190083 | 80 | 30 | 99.2 | 0 | 241 | 2 | 66 | 145 | MCB9247838.1 CDP-alcohol phosphatidyltransferase family protein [Ignavibacteriales bacterium] | diamond | 240 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 26711187 | 26711187 | PRJNA1167252_P_NODE_27141_length_246_cov_0.901734_g26868_i0 | PRJNA1167252 | 27141 | 246 | 0.901734 | 2.21826564 | Bacteria | 2 | Bacteria | Bacteria | 123 | 1.85e-30 | NR | MCB0742718.1 | 2026749 | g26868 | i0 | 70.7 | 1.98780487804878 | 82 | 24 | 100 | 0 | 246 | 1 | 597 | 678 | MCB0742718.1 polyphosphate kinase 1 [Ignavibacteriota bacterium] | diamond | 489 | 123 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27912380 | 27912380 | PRJNA1167252_P_NODE_25265_length_249_cov_0.886364_g24992_i0 | PRJNA1167252 | 25265 | 249 | 0.886364 | 2.20704636 | Bacteria | 2 | Bacteria | Bacteria | 115 | 1.36e-28 | NR | MCB0732226.1 | 2026749 | g24992 | i0 | 67.1 | 1.86746987951807 | 79 | 26 | 95.2 | 0 | 1 | 237 | 191 | 269 | MCB0732226.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 465 | 116 | 0.991379310344828 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 28461905 | 28461905 | PRJNA1167252_P_NODE_22426_length_254_cov_1.397790_g22153_i0 | PRJNA1167252 | 22426 | 254 | 1.39779 | 3.5503866 | Ignavibacterium album | 591197 | Bacteria | Bacteria | 152 | 4.49e-42 | NR | WP_014561592.1 | 591197 | g22153 | i0 | 90.5 | 2.97637795275591 | 84 | 8 | 99.2 | 0 | 252 | 1 | 235 | 318 | WP_014561592.1 PhoH family protein [Ignavibacterium album] | diamond | 756 | 152 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium album | |
| 29345842 | 29345842 | PRJNA1167252_P_NODE_23229_length_252_cov_0.871508_g22956_i0 | PRJNA1167252 | 23229 | 252 | 0.871508 | 2.19620016 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 139 | 2.24e-39 | NR | MCL6493826.1 | 2651167 | g22956 | i0 | 91.6 | 0.988095238095238 | 83 | 7 | 98.8 | 0 | 2 | 250 | 74 | 156 | MCL6493826.1 hypothetical protein [Ignavibacterium sp.] | diamond | 249 | 139 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 29535203 | 29535203 | PRJNA1167252_P_NODE_27750_length_245_cov_0.906977_g27477_i0 | PRJNA1167252 | 27750 | 245 | 0.906977 | 2.22209365 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 105 | 1.08e-25 | NR | MCB0729989.1 | 2026749 | g27477 | i0 | 83.6 | 0.746938775510204 | 61 | 10 | 74.7 | 0 | 2 | 184 | 215 | 275 | MCB0729989.1 HDOD domain-containing protein [Ignavibacteriota bacterium] | diamond | 183 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 30040518 | 30040518 | PRJNA1167252_P_NODE_27491_length_245_cov_0.906977_g27218_i0 | PRJNA1167252 | 27491 | 245 | 0.906977 | 2.22209365 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 47 | 0.00121 | NR | MCW8850084.1 | 2614255 | g27218 | i0 | 74.1 | 0.330612244897959 | 27 | 7 | 33.1 | 0 | 3 | 83 | 577 | 603 | MCW8850084.1 outer membrane protein assembly factor [Melioribacteraceae bacterium] | diamond | 81 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 30609098 | 30609098 | PRJNA1167252_P_NODE_23233_length_252_cov_0.871508_g22960_i0 | PRJNA1167252 | 23233 | 252 | 0.871508 | 2.19620016 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 132 | 5.62e-36 | NR | HMN48039.1 | 2651163 | g22960 | i0 | 70.2 | 1 | 84 | 25 | 100 | 0 | 252 | 1 | 60 | 143 | HMN48039.1 class I SAM-dependent methyltransferase [Ignavibacteriaceae bacterium] | diamond | 252 | 132 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30956954 | 30956954 | PRJNA1167252_P_NODE_23454_length_252_cov_0.871508_g23181_i0 | PRJNA1167252 | 23454 | 252 | 0.871508 | 2.19620016 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 140 | 4.4299999999999997e-38 | NR | MBK7499251.1 | 2049428 | g23181 | i0 | 84.3 | 1.97619047619048 | 83 | 13 | 98.8 | 0 | 3 | 251 | 189 | 271 | MBK7499251.1 DUF1624 domain-containing protein [Ignavibacteriales bacterium] | diamond | 498 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 32095234 | 32095234 | PRJNA1167252_P_NODE_29298_length_242_cov_0.923077_g29025_i0 | PRJNA1167252 | 29298 | 242 | 0.923077 | 2.23384634 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 165 | 1.94e-46 | NR | MCL6494024.1 | 2651167 | g29025 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 241 | 2 | 140 | 219 | MCL6494024.1 hypothetical protein [Ignavibacterium sp.] | diamond | 240 | 165 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 32127092 | 32127092 | PRJNA1167252_P_NODE_23238_length_252_cov_0.871508_g22965_i0 | PRJNA1167252 | 23238 | 252 | 0.871508 | 2.19620016 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 79 | 2.35e-15 | NR | MCL6494721.1 | 2651167 | g22965 | i0 | 90.2 | 0.488095238095238 | 41 | 4 | 48.8 | 0 | 2 | 124 | 239 | 279 | MCL6494721.1 cupin-like domain-containing protein [Ignavibacterium sp.] | diamond | 123 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 32367831 | 32367831 | PRJNA1167252_P_NODE_24399_length_250_cov_0.881356_g24126_i0 | PRJNA1167252 | 24399 | 250 | 0.881356 | 2.20339 | Bacteria | 2 | Bacteria | Bacteria | 85.5 | 8.17e-19 | NR | MCB0751858.1 | 2026749 | g24126 | i0 | 69.1 | 1.98 | 55 | 17 | 66 | 0 | 2 | 166 | 105 | 159 | MCB0751858.1 hypothetical protein [Ignavibacteriota bacterium] | diamond | 495 | 85.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 32601374 | 32601374 | PRJNA1167252_P_NODE_27640_length_245_cov_0.906977_g27367_i0 | PRJNA1167252 | 27640 | 245 | 0.906977 | 2.22209365 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 119 | 1.8599999999999995e-31 | NR | HEX9252213.1 | 2651163 | g27367 | i0 | 69.1 | 2.95102040816327 | 81 | 25 | 99.2 | 0 | 3 | 245 | 84 | 164 | HEX9252213.1 ribose-5-phosphate isomerase RpiA [Ignavibacteriaceae bacterium] | diamond | 723 | 119 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae 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);;