contig_metadata
7 rows where bioproject = "PRJNA397733" and tax_clade = "FCB group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2962884 | 2962884 | PRJNA397733_S_NODE_7583_length_219_cov_3.500000_g7495_i0 | PRJNA397733 | 7583 | 219 | 3.5 | 7.665 | Chryseobacterium sp. | 1871047 | Bacteria | Bacteria | 394 | 2.79e-105 | NTclustered | gi|1757093052|gb|CP044507.1| | 1871047 | g7495 | i0 | 99.087 | 457.022831050228 | 219 | 2 | 100 | 0 | 1 | 219 | 454200 | 454418 | Chryseobacterium sp. strain SNU WT7 chromosome, complete genome | blastn | 100088 | 394 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium sp. | |
| 4907900 | 4907900 | PRJNA397733_S_NODE_13464_length_166_cov_3.102190_g13376_i0 | PRJNA397733 | 13464 | 166 | 3.10219 | 5.1496354 | Cloacibacterium | 501783 | Bacteria | Bacteria | 307 | 2.69e-79 | NTclustered | gi|1527207946|gb|CP034157.1| | 237258 | g13376 | i0 | 100 | 476.006024096386 | 166 | 0 | 100 | 0 | 1 | 166 | 131843 | 132008 | Cloacibacterium normanense strain NRS-1 chromosome, complete genome | blastn | 79017 | 307 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Cloacibacterium | Cloacibacterium normanense | |
| 8732680 | 8732680 | PRJNA397733_S_NODE_11027_length_182_cov_2.764706_g10939_i0 | PRJNA397733 | 11027 | 182 | 2.764706 | 5.03176492 | Weeksellaceae | 2762318 | Bacteria | Bacteria | 226 | 8.619999999999999e-55 | NTclustered | gi|1678513594|gb|CP040694.1| | 2583851 | g10939 | i0 | 89.888 | 400.225274725275 | 178 | 14 | 97 | 4 | 3 | 179 | 648065 | 648239 | Elizabethkingia sp. JS20170427COW chromosome, complete genome | blastn | 72841 | 226 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Elizabethkingia | Elizabethkingia sp. JS20170427COW | |
| 12558625 | 12558625 | PRJNA397733_S_NODE_15990_length_154_cov_2.600000_g15902_i0 | PRJNA397733 | 15990 | 154 | 2.6 | 4.004 | Weeksellaceae | 2762318 | Bacteria | Bacteria | 263 | 5.36e-66 | NTclustered | gi|1519580736|gb|CP033930.1| | 253 | g15902 | i0 | 97.403 | 441.012987012987 | 154 | 4 | 100 | 0 | 1 | 154 | 2943976 | 2944129 | Chryseobacterium indologenes strain H5559 chromosome, complete genome | blastn | 67916 | 263 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Chryseobacterium | Chryseobacterium indologenes | |
| 19537992 | 19537992 | PRJNA397733_S_NODE_14476_length_161_cov_2.522727_g14388_i0 | PRJNA397733 | 14476 | 161 | 2.522727 | 4.06159047 | Porphyromonas sp. oral taxon 275 | 712435 | Bacteria | Bacteria | 287 | 3.37e-73 | NTclustered | gi|2028834772|gb|CP072333.1| | 712435 | g14388 | i0 | 98.758 | 408.875776397516 | 161 | 2 | 100 | 0 | 1 | 161 | 442971 | 443131 | Porphyromonas sp. oral taxon 275 strain W7780 chromosome, complete genome | blastn | 65829 | 287 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Porphyromonadaceae | Porphyromonas | Porphyromonas sp. oral taxon 275 | |
| 26790665 | 26790665 | PRJNA397733_S_NODE_14041_length_163_cov_2.731343_g13953_i0 | PRJNA397733 | 14041 | 163 | 2.731343 | 4.45208909 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 40.4 | 0.0228 | NR | MCZ7616069.1 | 2651163 | g13953 | i0 | 50 | 0.699386503067485 | 38 | 19 | 69.9 | 0 | 44 | 157 | 39 | 76 | MCZ7616069.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 114 | 40.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 28338711 | 28338711 | PRJNA397733_S_NODE_15366_length_157_cov_2.289062_g15278_i0 | PRJNA397733 | 15366 | 157 | 2.289062 | 3.59382734 | Polaribacter litorisediminis | 1908341 | Bacteria | Bacteria | 43.5 | 0.0045 | NR | WP_223439602.1 | 1908341 | g15278 | i0 | 39.1 | 0.878980891719745 | 46 | 28 | 87.9 | 0 | 152 | 15 | 120 | 165 | WP_223439602.1 PAS domain-containing protein [Polaribacter litorisediminis] | diamond | 138 | 43.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Polaribacter | Polaribacter litorisediminis |
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);;