contig_metadata
3 rows where bioproject = "PRJNA758398", tax_clade = "FCB group" and tax_phylum = "Balneolota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16507232 | 16507232 | PRJNA758398_S_NODE_18733_length_233_cov_1.358696_g18592_i0 | PRJNA758398 | 18733 | 233 | 1.358696 | 3.16576168 | Cyclonatronum proteinivorum | 1457365 | Bacteria | Bacteria | 134 | 1.47e-34 | NR | WP_114984734.1 | 1457365 | g18592 | i0 | 80.3 | 4.90557939914163 | 76 | 15 | 97.9 | 0 | 5 | 232 | 557 | 632 | WP_114984734.1 aminomethyl-transferring glycine dehydrogenase [Cyclonatronum proteinivorum] | diamond | 1143 | 134 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Cyclonatronaceae | Cyclonatronum | Cyclonatronum proteinivorum | |
| 30274469 | 30274469 | PRJNA758398_S_NODE_25792_length_206_cov_1.101911_g25651_i0 | PRJNA758398 | 25792 | 206 | 1.101911 | 2.26993666 | Fodinibius salinus | 860790 | Bacteria | Bacteria | 55.1 | 1.02e-6 | NR | WP_148897580.1 | 860790 | g25651 | i0 | 43.1 | 1.77669902912621 | 65 | 34 | 94.7 | 1 | 195 | 1 | 604 | 665 | WP_148897580.1 AAA family ATPase [Fodinibius salinus] | diamond | 366 | 55.1 | 1 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Fodinibius | Fodinibius salinus | |
| 31168391 | 31168391 | PRJNA758398_S_NODE_21535_length_221_cov_0.872093_g21394_i0 | PRJNA758398 | 21535 | 221 | 0.872093 | 1.92732553 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 98.2 | 6.02e-22 | NR | MBO6524942.1 | 2053516 | g21394 | i0 | 59.7 | 4.91402714932127 | 72 | 29 | 97.7 | 0 | 6 | 221 | 232 | 303 | MBO6524942.1 beta-glucosidase [Balneolaceae bacterium] | diamond | 1086 | 98.6 | 0.995943204868154 | Bacteria | FCB group | Pseudomonadati | Balneolota | Balneolia | Balneolales | Balneolaceae | Balneolaceae bacterium |
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);;