contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA664479" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26682016 | 26682016 | PRJNA664479_S_NODE_16841_length_164_cov_0.869565_g16765_i0 | PRJNA664479 | 16841 | 164 | 0.869565 | 1.4260866 | root | 1 | Root_unresolved | Root_unresolved | 75.5 | 2.19e-15 | NR | WP_151874162.1 | 817 | g16765 | i0 | 75.9 | 94.5548780487805 | 54 | 13 | 98.8 | 0 | 164 | 3 | 92 | 145 | WP_151874162.1 30S ribosomal protein S4, partial [Bacteroides fragilis] | diamond | 15507 | 75.5 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Bacteroidaceae | Bacteroides | Bacteroides fragilis | |
| 27271100 | 27271100 | PRJNA664479_S_NODE_17963_length_162_cov_0.902655_g17887_i0 | PRJNA664479 | 17963 | 162 | 0.902655 | 1.4623011 | Chitinophagaceae bacterium | 1869212 | Bacteria | Bacteria | 83.6 | 2.91e-18 | NR | HUQ97798.1 | 1869212 | g17887 | i0 | 79.2 | 1.96296296296296 | 53 | 10 | 98.1 | 1 | 161 | 3 | 18 | 69 | HUQ97798.1 RdgB/HAM1 family non-canonical purine NTP pyrophosphatase [Chitinophagaceae bacterium] | diamond | 318 | 83.6 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Chitinophagia | Chitinophagales | Chitinophagaceae | Chitinophagaceae bacterium | ||
| 27745111 | 27745111 | PRJNA664479_S_NODE_15724_length_165_cov_0.879310_g15648_i0 | PRJNA664479 | 15724 | 165 | 0.87931 | 1.4508615 | Cloacibacterium rupense | 517423 | Bacteria | Bacteria | 108 | 6.12e-26 | NR | WP_188618631.1 | 517423 | g15648 | i0 | 92.6 | 0.981818181818182 | 54 | 4 | 98.2 | 0 | 2 | 163 | 154 | 207 | WP_188618631.1 ATP-dependent helicase [Cloacibacterium rupense] | diamond | 162 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Cloacibacterium | Cloacibacterium rupense | |
| 27871046 | 27871046 | PRJNA664479_S_NODE_14685_length_167_cov_0.864407_g14609_i0 | PRJNA664479 | 14685 | 167 | 0.864407 | 1.44355969 | Muribaculaceae bacterium | 2498093 | Bacteria | Bacteria | 84.3 | 2.7e-17 | NR | MBQ9216630.1 | 2498093 | g14609 | i0 | 76.4 | 1.97604790419162 | 55 | 13 | 98.8 | 0 | 3 | 167 | 400 | 454 | MBQ9216630.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Muribaculaceae bacterium] | diamond | 330 | 84.3 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Muribaculaceae | Muribaculaceae bacterium | ||
| 28313267 | 28313267 | PRJNA664479_S_NODE_16686_length_164_cov_0.886957_g16610_i0 | PRJNA664479 | 16686 | 164 | 0.886957 | 1.45460948 | uncultured Flavobacterium sp. | 165435 | Bacteria | Bacteria | 115 | 5.66e-29 | NR | WP_294820642.1 | 165435 | g16610 | i0 | 98.1 | 1.97560975609756 | 54 | 1 | 98.8 | 0 | 3 | 164 | 201 | 254 | WP_294820642.1 aminopeptidase C [uncultured Flavobacterium sp.] | diamond | 324 | 115 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | uncultured Flavobacterium sp. | |
| 28325227 | 28325227 | PRJNA664479_S_NODE_3066_length_288_cov_4.447699_g2990_i0 | PRJNA664479 | 3066 | 288 | 4.447699 | 12.80937312 | Bacteroidia | 200643 | Bacteria | Bacteria | 44.7 | 0.0123 | NR | WP_025865170.1 | 314319 | g2990 | i0 | 61.5 | 2.97916666666667 | 26 | 10 | 27.1 | 0 | 18 | 95 | 294 | 319 | WP_025865170.1 type I glyceraldehyde-3-phosphate dehydrogenase [Prolixibacter bellariivorans] | diamond | 858 | 45.1 | 0.991130820399113 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Marinilabiliales | Prolixibacteraceae | Prolixibacter | Prolixibacter bellariivorans | |
| 29008123 | 29008123 | PRJNA664479_S_NODE_18008_length_162_cov_0.902655_g17932_i0 | PRJNA664479 | 18008 | 162 | 0.902655 | 1.4623011 | Myroides sp. | 1874736 | Bacteria | Bacteria | 82.8 | 4.99e-17 | NR | MDO5637570.1 | 1874736 | g17932 | i0 | 79.2 | 2.92592592592593 | 53 | 11 | 98.1 | 0 | 2 | 160 | 172 | 224 | MDO5637570.1 COX15/CtaA family protein [Myroides sp.] | diamond | 474 | 82.8 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Myroides | Myroides sp. | |
| 30776674 | 30776674 | PRJNA664479_S_NODE_15014_length_166_cov_0.871795_g14938_i0 | PRJNA664479 | 15014 | 166 | 0.871795 | 1.4471797 | Elizabethkingia anophelis | 1117645 | Bacteria | Bacteria | 108 | 6.41e-26 | NR | WP_407497252.1 | 1117645 | g14938 | i0 | 100 | 1.98795180722892 | 55 | 0 | 99.4 | 0 | 166 | 2 | 581 | 635 | WP_407497252.1 Eco57I restriction-modification methylase domain-containing protein [Elizabethkingia anophelis] | diamond | 330 | 108 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Weeksellaceae | Elizabethkingia | Elizabethkingia anophelis |
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);;