contig_metadata
11 rows where bioproject = "PRJNA493827" and tax_phylum = "Candidatus Poribacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26823814 | 26823814 | PRJNA493827_P_NODE_226341_length_242_cov_1.366864_g224143_i0 | PRJNA493827 | 226341 | 242 | 1.366864 | 3.30781088 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 96.7 | 1.55e-22 | NR | MAE20415.1 | 2026781 | g224143 | i0 | 54.4 | 0.979338842975207 | 79 | 36 | 97.9 | 0 | 3 | 239 | 87 | 165 | MAE20415.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 237 | 96.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 27203049 | 27203049 | PRJNA493827_P_NODE_56442_length_470_cov_2.617128_g54249_i0 | PRJNA493827 | 56442 | 470 | 2.617128 | 12.3005016 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 64.3 | 1.21e-8 | NR | MAE20462.1 | 2026781 | g54249 | i0 | 54.4 | 0.363829787234043 | 57 | 26 | 36.4 | 0 | 116 | 286 | 3 | 59 | MAE20462.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 171 | 64.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 28782008 | 28782008 | PRJNA493827_P_NODE_73907_length_403_cov_1.166667_g71709_i0 | PRJNA493827 | 73907 | 403 | 1.166667 | 4.70166801 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 53.5 | 1.85e-5 | NR | MAE20575.1 | 2026781 | g71709 | i0 | 44.6 | 1.06451612903226 | 74 | 30 | 54.3 | 3 | 401 | 183 | 126 | 189 | MAE20575.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 429 | 53.5 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 28908204 | 28908204 | PRJNA493827_P_NODE_81268_length_382_cov_1.284790_g79070_i0 | PRJNA493827 | 81268 | 382 | 1.28479 | 4.9078978 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 167 | 6.689999999999998e-47 | NR | MAE20606.1 | 2026781 | g79070 | i0 | 81.2 | 1.57853403141361 | 101 | 19 | 79.3 | 0 | 381 | 79 | 140 | 240 | MAE20606.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 603 | 167 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29697412 | 29697412 | PRJNA493827_P_NODE_67150_length_425_cov_1.622159_g64953_i0 | PRJNA493827 | 67150 | 425 | 1.622159 | 6.89417575 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 69.7 | 1.02e-10 | NR | MAE20462.1 | 2026781 | g64953 | i0 | 56.9 | 0.409411764705882 | 58 | 25 | 40.9 | 0 | 50 | 223 | 2 | 59 | MAE20462.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 174 | 69.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 29729170 | 29729170 | PRJNA493827_P_NODE_94770_length_352_cov_1.874552_g92572_i0 | PRJNA493827 | 94770 | 352 | 1.874552 | 6.59842304 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 62.4 | 9.68e-9 | NR | RKU09440.1 | 2026781 | g92572 | i0 | 35 | 0.877840909090909 | 103 | 65 | 86.9 | 2 | 7 | 312 | 49 | 150 | RKU09440.1 MAG: hypothetical protein C6502_13055 [Candidatus Poribacteria bacterium] | diamond | 309 | 62.4 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 30171438 | 30171438 | PRJNA493827_P_NODE_109152_length_327_cov_1.838583_g106954_i0 | PRJNA493827 | 109152 | 327 | 1.838583 | 6.01216641 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 58.2 | 4.11e-7 | NR | MAE20460.1 | 2026781 | g106954 | i0 | 35.2 | 0.834862385321101 | 91 | 58 | 82.6 | 1 | 291 | 22 | 977 | 1067 | MAE20460.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 273 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31056540 | 31056540 | PRJNA493827_P_NODE_147015_length_282_cov_1.473684_g144817_i0 | PRJNA493827 | 147015 | 282 | 1.473684 | 4.15578888 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 68.9 | 3.49e-11 | NR | MAE20478.1 | 2026781 | g144817 | i0 | 39.5 | 1.88297872340426 | 86 | 52 | 91.5 | 0 | 277 | 20 | 126 | 211 | MAE20478.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 531 | 68.9 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31625389 | 31625389 | PRJNA493827_P_NODE_217756_length_244_cov_0.900585_g215558_i0 | PRJNA493827 | 217756 | 244 | 0.900585 | 2.1974274 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 69.3 | 5.13e-12 | NR | MCZ6678385.1 | 2026781 | g215558 | i0 | 48.4 | 2.44672131147541 | 64 | 32 | 78.7 | 1 | 193 | 2 | 4 | 66 | MCZ6678385.1 HAD-IA family hydrolase [Candidatus Poribacteria bacterium] | diamond | 597 | 69.3 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 31973455 | 31973455 | PRJNA493827_P_NODE_87338_length_367_cov_3.129252_g85140_i0 | PRJNA493827 | 87338 | 367 | 3.129252 | 11.48435484 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 137 | 6.42e-38 | NR | MAE20555.1 | 2026781 | g85140 | i0 | 62.8 | 0.989100817438692 | 121 | 43 | 98.9 | 1 | 367 | 5 | 88 | 206 | MAE20555.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 363 | 137 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria bacterium | ||||||
| 32416432 | 32416432 | PRJNA493827_P_NODE_126779_length_303_cov_3.530435_g124581_i0 | PRJNA493827 | 126779 | 303 | 3.530435 | 10.69721805 | Candidatus Poribacteria bacterium | 2026781 | Bacteria | Bacteria | 104 | 2.53e-25 | NR | MAE20555.1 | 2026781 | g124581 | i0 | 60.2 | 0.871287128712871 | 88 | 35 | 87.1 | 0 | 40 | 303 | 6 | 93 | MAE20555.1 hypothetical protein [Candidatus Poribacteria bacterium] | diamond | 264 | 104 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Poribacteria | Candidatus Poribacteria 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);;