contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6590249 | 6590249 | PRJNA1103784_P_NODE_6386_length_247_cov_2.597701_g6331_i0 | PRJNA1103784 | 6386 | 247 | 2.597701 | 6.41632147 | Flavobacterium sp. | 239 | Bacteria | Bacteria | 148 | 3.54e-42 | NR | WP_374542109.1 | 239 | g6331 | i0 | 98.8 | 0.995951417004049 | 82 | 1 | 99.6 | 0 | 2 | 247 | 40 | 121 | WP_374542109.1 OmpH family outer membrane protein [Flavobacterium sp.] | diamond | 246 | 148 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Flavobacterium | Flavobacterium sp. | |
| 18063803 | 18063803 | PRJNA1103784_P_NODE_2595_length_335_cov_2.007634_g2540_i0 | PRJNA1103784 | 2595 | 335 | 2.007634 | 6.7255739 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 191 | 4.709999999999999e-56 | NR | MDP3445275.1 | 2053306 | g2540 | i0 | 85.6 | 0.994029850746269 | 111 | 16 | 99.4 | 0 | 334 | 2 | 104 | 214 | MDP3445275.1 Hsp70 family protein [Ignavibacteria bacterium] | diamond | 333 | 191 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 18871766 | 18871766 | PRJNA1103784_P_NODE_315_length_836_cov_2.732634_g267_i0 | PRJNA1103784 | 315 | 836 | 2.732634 | 22.84482024 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 375 | 8.8e-125 | NR | MDP3445275.1 | 2053306 | g267 | i0 | 80.3 | 0.911483253588517 | 254 | 50 | 91.1 | 0 | 836 | 75 | 218 | 471 | MDP3445275.1 Hsp70 family protein [Ignavibacteria bacterium] | diamond | 762 | 375 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27193997 | 27193997 | PRJNA1103784_P_NODE_4302_length_276_cov_1.315271_g4247_i0 | PRJNA1103784 | 4302 | 276 | 1.315271 | 3.63014796 | Balneolaceae bacterium | 2053516 | Bacteria | Bacteria | 45.4 | 0.00585 | NR | MEX0905646.1 | 2053516 | g4247 | i0 | 34.6 | 1.66304347826087 | 78 | 46 | 82.6 | 3 | 250 | 23 | 156 | 230 | MEX0905646.1 FAD/NAD(P)-binding oxidoreductase [Balneolaceae bacterium] | diamond | 459 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium | ||
| 29269280 | 29269280 | PRJNA1103784_P_NODE_3609_length_291_cov_1.747706_g3554_i0 | PRJNA1103784 | 3609 | 291 | 1.747706 | 5.08582446 | Bacteroidota | 976 | Bacteria | Bacteria | 67 | 2.02e-11 | NR | WP_166552178.1 | 2683263 | g3554 | i0 | 100 | 1.05154639175258 | 51 | 0 | 52.6 | 0 | 249 | 97 | 1 | 51 | WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP] | diamond | 306 | 67 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Flavobacteriia | Flavobacteriales | Flavobacteriaceae | Cellulophaga | Cellulophaga sp. BC115SP | |
| 30130527 | 30130527 | PRJNA1103784_P_NODE_1892_length_380_cov_1.446254_g1837_i0 | PRJNA1103784 | 1892 | 380 | 1.446254 | 5.4957652 | Candidatus Kapaibacterium sp. | 2447898 | Bacteria | Bacteria | 120 | 5.51e-32 | NR | HPI20161.1 | 2447898 | g1837 | i0 | 52.9 | 2.4 | 102 | 48 | 80.5 | 0 | 4 | 309 | 61 | 162 | HPI20161.1 glutathione peroxidase [Candidatus Kapaibacterium sp.] | diamond | 912 | 120 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Kapaibacteriota | Candidatus Kapaibacteriia | Candidatus Kapaibacteriales | Candidatus Kapaibacteriaceae | Candidatus Kapaibacterium | Candidatus Kapaibacterium sp. | |
| 32628247 | 32628247 | PRJNA1103784_P_NODE_7320_length_243_cov_0.905882_g7265_i0 | PRJNA1103784 | 7320 | 243 | 0.905882 | 2.20129326 | Prevotella disiens | 28130 | Bacteria | Bacteria | 149 | 3.1e-42 | NR | WP_004358443.1 | 28130 | g7265 | i0 | 100 | 0.987654320987654 | 80 | 0 | 98.8 | 0 | 2 | 241 | 114 | 193 | WP_004358443.1 polyprenyl synthetase family protein [Prevotella disiens] | diamond | 240 | 149 | 1 | Bacteria | FCB group | Pseudomonadati | Bacteroidota | Bacteroidia | Bacteroidales | Prevotellaceae | Prevotella | Prevotella disiens |
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);;