contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA811714" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19936117 | 19936117 | PRJNA811714_P_NODE_27616_length_226_cov_3.019608_g27423_i0 | PRJNA811714 | 27616 | 226 | 3.019608 | 6.82431408 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 150 | 3.82e-40 | NR | MEE8596102.1 | 2026742 | g27423 | i0 | 98.6 | 0.982300884955752 | 74 | 1 | 98.2 | 0 | 3 | 224 | 897 | 970 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 222 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 27970209 | 27970209 | PRJNA811714_P_NODE_10845_length_297_cov_4.125000_g10652_i0 | PRJNA811714 | 10845 | 297 | 4.125 | 12.25125 | Elizabethkingia meningoseptica | 238 | Bacteria | Bacteria | 153 | 4.32e-46 | NR | WP_342855241.1 | 238 | g10652 | i0 | 100 | 1.88888888888889 | 88 | 0 | 88.9 | 0 | 264 | 1 | 1 | 88 | WP_342855241.1 YDG domain-containing protein, partial [Elizabethkingia meningoseptica] | diamond | 561 | 153 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Elizabethkingia | Elizabethkingia meningoseptica | |
| 29801446 | 29801446 | PRJNA811714_P_NODE_17591_length_256_cov_3.032787_g17398_i0 | PRJNA811714 | 17591 | 256 | 3.032787 | 7.76393472 | Roseisolibacter agri | 2014610 | Bacteria | Bacteria | 47 | 0.00138 | NR | WP_284348802.1 | 2014610 | g17398 | i0 | 50 | 0.6328125 | 54 | 23 | 63.3 | 1 | 62 | 223 | 349 | 398 | WP_284348802.1 APC family permease [Roseisolibacter agri] | diamond | 162 | 47 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Roseisolibacter | Roseisolibacter agri | |
| 30085755 | 30085755 | PRJNA811714_P_NODE_24072_length_235_cov_2.685185_g23879_i0 | PRJNA811714 | 24072 | 235 | 2.685185 | 6.31018475 | Bacteroidota bacterium | 1898104 | Bacteria | Bacteria | 46.2 | 0.0019 | NR | MFN7300647.1 | 1898104 | g23879 | i0 | 32.3 | 1.58297872340426 | 62 | 39 | 75.3 | 1 | 33 | 209 | 111 | 172 | MFN7300647.1 NAD(P)-dependent oxidoreductase [Bacteroidota bacterium] | diamond | 372 | 46.2 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidota bacterium | |||||
| 30591334 | 30591334 | PRJNA811714_P_NODE_27153_length_227_cov_3.000000_g26960_i0 | PRJNA811714 | 27153 | 227 | 3 | 6.81 | Bacteroides acidifaciens | 85831 | Bacteria | Bacteria | 42.7 | 0.0291 | NR | WP_300915839.1 | 85831 | g26960 | i0 | 35.8 | 0.700440528634361 | 53 | 32 | 70 | 1 | 187 | 29 | 119 | 169 | WP_300915839.1 ComEC/Rec2 family competence protein [Bacteroides acidifaciens] | diamond | 159 | 42.7 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides acidifaciens | |
| 31159716 | 31159716 | PRJNA811714_P_NODE_27395_length_226_cov_6.039216_g27202_i0 | PRJNA811714 | 27395 | 226 | 6.039216 | 13.64862816 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 88.6 | 2.22e-18 | NR | HEV3049408.1 | 2029185 | g27202 | i0 | 66.2 | 0.86283185840708 | 65 | 22 | 86.3 | 0 | 14 | 208 | 743 | 807 | HEV3049408.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] | diamond | 195 | 88.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 31476503 | 31476503 | PRJNA811714_P_NODE_21616_length_242_cov_2.733728_g21423_i0 | PRJNA811714 | 21616 | 242 | 2.733728 | 6.61562176 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 163 | 4.81e-45 | NR | MBX9733134.1 | 1869212 | g21423 | i0 | 98.8 | 0.991735537190083 | 80 | 1 | 99.2 | 0 | 241 | 2 | 178 | 257 | MBX9733134.1 DUF1800 domain-containing protein [Chitinophagaceae bacterium] | diamond | 240 | 163 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 32235962 | 32235962 | PRJNA811714_P_NODE_29618_length_214_cov_8.510638_g29425_i0 | PRJNA811714 | 29618 | 214 | 8.510638 | 18.21276532 | Sediminibacterium sp. | 1917865 | Bacteria | Bacteria | 155 | 3.42e-42 | NR | MBR2649213.1 | 1917865 | g29425 | i0 | 100 | 0.995327102803738 | 71 | 0 | 99.5 | 0 | 2 | 214 | 393 | 463 | MBR2649213.1 hypothetical protein [Sediminibacterium sp.] | diamond | 213 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Sediminibacterium | Sediminibacterium 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);;