contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA980587" and tax_kingdom = "Fusobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27120714 | 27120714 | PRJNA980587_P_NODE_27382_length_467_cov_2.670051_g26589_i0 | PRJNA980587 | 27382 | 467 | 2.670051 | 12.46913817 | Cetobacterium sp. ZWU | 2071632 | Bacteria | Bacteria | 307 | 2.24e-103 | NR | WP_047384851.1 | 1340502 | g26589 | i0 | 100 | 0.995717344753747 | 155 | 0 | 99.6 | 0 | 1 | 465 | 42 | 196 | WP_047384851.1 Rpn family recombination-promoting nuclease/putative transposase [Cetobacterium sp. ZWU0022] | diamond | 465 | 307 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | Cetobacterium sp. ZWU0022 | ||
| 28068495 | 28068495 | PRJNA980587_P_NODE_38725_length_376_cov_1.808581_g37932_i0 | PRJNA980587 | 38725 | 376 | 1.808581 | 6.80026456 | uncultured Cetobacterium sp. | 527638 | Bacteria | Bacteria | 236 | 2.89e-78 | NR | WP_293724003.1 | 527638 | g37932 | i0 | 100 | 0.933510638297872 | 117 | 0 | 93.4 | 0 | 26 | 376 | 1 | 117 | WP_293724003.1 Fur family transcriptional regulator [uncultured Cetobacterium sp.] | diamond | 351 | 236 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | uncultured Cetobacterium sp. | ||
| 32144244 | 32144244 | PRJNA980587_P_NODE_42838_length_354_cov_1.362989_g42045_i0 | PRJNA980587 | 42838 | 354 | 1.362989 | 4.82498106 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 234 | 8.65e-78 | NR | WP_047382390.1 | 2630983 | g42045 | i0 | 100 | 0.957627118644068 | 113 | 0 | 95.8 | 0 | 341 | 3 | 1 | 113 | WP_047382390.1 MULTISPECIES: arsenate reductase family protein [unclassified Cetobacterium] | diamond | 339 | 234 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium | |||
| 32492482 | 32492482 | PRJNA980587_P_NODE_96199_length_232_cov_3.182390_g95406_i0 | PRJNA980587 | 96199 | 232 | 3.18239 | 7.3831448 | unclassified Cetobacterium | 2630983 | Bacteria | Bacteria | 134 | 1.92e-37 | NR | WP_047382694.1 | 2630983 | g95406 | i0 | 98.5 | 0.879310344827586 | 68 | 1 | 87.9 | 0 | 230 | 27 | 2 | 69 | WP_047382694.1 MULTISPECIES: glycosyltransferase family 2 protein [unclassified Cetobacterium] | diamond | 204 | 134 | 1 | Bacteria | Fusobacteriati | Fusobacteriota | Fusobacteriia | Fusobacteriales | Fusobacteriaceae | Cetobacterium |
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);;