contig_metadata
11 rows where bioproject = "PRJNA998413" and tax_phylum = "Bacteroidota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2254393 | 2254393 | PRJNA998413_S_NODE_3142_length_316_cov_3.849802_g3111_i0 | PRJNA998413 | 3142 | 316 | 3.849802 | 12.16537432 | Flavobacterium dauae | 1563479 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2557430891|gb|CP130821.1| | 1563479 | g3111 | i0 | 100 | 0.0949367088607595 | 30 | 0 | 9 | 0 | 47 | 76 | 1161438 | 1161409 | Flavobacterium dauae strain TCH3-2 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium dauae | |
| 8632312 | 8632312 | PRJNA998413_S_NODE_7587_length_242_cov_1.871508_g7556_i0 | PRJNA998413 | 7587 | 242 | 1.871508 | 4.52904936 | Flectobacillus roseus | 502259 | Bacteria | Bacteria | 156 | 4.51e-43 | NR | WP_283346397.1 | 502259 | g7556 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 242 | 3 | 381 | 460 | WP_283346397.1 dihydroxy-acid dehydratase [Flectobacillus roseus] | diamond | 240 | 156 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Cytophagia | Cytophagales | Flectobacillaceae | Flectobacillus | Flectobacillus roseus | |
| 13732744 | 13732744 | PRJNA998413_S_NODE_9851_length_223_cov_1.575000_g9820_i0 | PRJNA998413 | 9851 | 223 | 1.575 | 3.51225 | Flavobacterium cerinum | 2502784 | Bacteria | Bacteria | 379 | 7.999999999999999e-101 | NTclustered | gi|2279330881|gb|CP101751.1| | 2502784 | g9820 | i0 | 97.309 | 1.30044843049327 | 223 | 6 | 100 | 0 | 1 | 223 | 463261 | 463483 | Flavobacterium cerinum strain C1 chromosome, complete genome | blastn | 290 | 379 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium cerinum | |
| 19125307 | 19125307 | PRJNA998413_S_NODE_5375_length_268_cov_3.697561_g5344_i0 | PRJNA998413 | 5375 | 268 | 3.697561 | 9.90946348 | Flavobacterium | 237 | Bacteria | Bacteria | 496 | 9.429999999999999e-136 | NTclustered | gi|2279330881|gb|CP101751.1| | 2502784 | g5344 | i0 | 100 | 623.007462686567 | 268 | 0 | 100 | 0 | 1 | 268 | 717834 | 718101 | Flavobacterium cerinum strain C1 chromosome, complete genome | blastn | 166966 | 496 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium cerinum | |
| 20105721 | 20105721 | PRJNA998413_S_NODE_5276_length_270_cov_0.971014_g5245_i0 | PRJNA998413 | 5276 | 270 | 0.971014 | 2.6217378 | Chitinophagaceae bacterium LGM1 | 2837399 | Bacteria | Bacteria | 350 | 7.84e-92 | NTclustered | gi|2046997110|gb|CP075895.1| | 2837399 | g5245 | i0 | 91.732 | 280.844444444444 | 254 | 17 | 97 | 4 | 18 | 270 | 1076632 | 1076382 | Chitinophagaceae bacterium LGM1 chromosome, complete genome | blastn | 75828 | 350 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium LGM1 | ||
| 23931573 | 23931573 | PRJNA998413_S_NODE_3299_length_312_cov_1.357430_g3268_i0 | PRJNA998413 | 3299 | 312 | 1.35743 | 4.2351816 | Candidatus Fluviicola riflensis | 1798018 | Bacteria | Bacteria | 431 | 3.21e-116 | NTclustered | gi|1229046090|gb|CP022585.1| | 1798018 | g3268 | i0 | 91.64 | 246.605769230769 | 311 | 26 | 99 | 0 | 1 | 311 | 786699 | 786389 | Candidatus Fluviicola riflensis chromosome, complete genome | blastn | 76941 | 431 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Crocinitomicaceae | Fluviicola | Candidatus Fluviicola riflensis | |
| 28605609 | 28605609 | PRJNA998413_S_NODE_12307_length_212_cov_1.114094_g12276_i0 | PRJNA998413 | 12307 | 212 | 1.114094 | 2.36187928 | Petrimonas sp. | 2023866 | Bacteria | Bacteria | 79.7 | 8.69e-16 | NR | MDD3787514.1 | 2023866 | g12276 | i0 | 71.7 | 0.849056603773585 | 60 | 13 | 84.9 | 1 | 184 | 5 | 1 | 56 | MDD3787514.1 TIM barrel protein [Petrimonas sp.] | diamond | 180 | 79.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Dysgonomonadaceae | Petrimonas | Petrimonas sp. | |
| 30626696 | 30626696 | PRJNA998413_S_NODE_11073_length_216_cov_1.313725_g11042_i0 | PRJNA998413 | 11073 | 216 | 1.313725 | 2.837646 | Prevotella sp. tc2-28 | 1761888 | Bacteria | Bacteria | 130 | 2.49e-34 | NR | WP_091958264.1 | 1761888 | g11042 | i0 | 87.3 | 7.90277777777778 | 71 | 9 | 98.6 | 0 | 215 | 3 | 9 | 79 | WP_091958264.1 aminopeptidase C [Prevotella sp. tc2-28] | diamond | 1707 | 130 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella sp. tc2-28 | |
| 32049556 | 32049556 | PRJNA998413_S_NODE_11778_length_214_cov_0.887417_g11747_i0 | PRJNA998413 | 11778 | 214 | 0.887417 | 1.89907238 | Saprospiraceae bacterium | 2202734 | Bacteria | Bacteria | 42.7 | 0.0267 | NR | MBX2872287.1 | 2202734 | g11747 | i0 | 31.5 | 0.757009345794392 | 54 | 37 | 75.7 | 0 | 34 | 195 | 1077 | 1130 | MBX2872287.1 carboxypeptidase-like regulatory domain-containing protein [Saprospiraceae bacterium] | diamond | 162 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Saprospiria | Saprospirales | Saprospiraceae | Saprospiraceae bacterium | ||
| 32650054 | 32650054 | PRJNA998413_S_NODE_12420_length_212_cov_0.899329_g12389_i0 | PRJNA998413 | 12420 | 212 | 0.899329 | 1.90657748 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 109 | 1.16e-29 | NR | NLY23810.1 | 2030927 | g12389 | i0 | 89.8 | 2.50471698113208 | 59 | 6 | 83.5 | 0 | 1 | 177 | 14 | 72 | NLY23810.1 hypothetical protein [Bacteroidales bacterium] | diamond | 531 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales bacterium | |||
| 32902139 | 32902139 | PRJNA998413_S_NODE_12060_length_213_cov_0.893333_g12029_i0 | PRJNA998413 | 12060 | 213 | 0.893333 | 1.90279929 | Bacteroidales bacterium | 2030927 | Bacteria | Bacteria | 45.8 | 0.00197 | NR | MFA6199038.1 | 2030927 | g12029 | i0 | 40.7 | 0.830985915492958 | 59 | 35 | 83.1 | 0 | 36 | 212 | 240 | 298 | MFA6199038.1 hypothetical protein [Bacteroidales bacterium] | diamond | 177 | 45.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidales 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);;