contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA928559" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7281881 | 7281881 | PRJNA928559_P_NODE_30026_length_596_cov_3.009560_g28499_i0 | PRJNA928559 | 30026 | 596 | 3.00956 | 17.9369776 | Candidatus Minusculum obligatum | 1948790 | Bacteria | Bacteria | 630 | 5.9499999999999984e-176 | NTclustered | gi|2862534883|gb|CP174360.1| | 1948790 | g28499 | i0 | 86.528 | 128.575503355705 | 579 | 70 | 97 | 8 | 20 | 595 | 191634 | 191061 | MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome | blastn | 76631 | 630 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Candidatus Phycocordibacterales | Candidatus Phycocordibacteraceae | Candidatus Minusculum | Candidatus Minusculum obligatum | ||
| 12383632 | 12383632 | PRJNA928559_P_NODE_82450_length_391_cov_1.603774_g80881_i0 | PRJNA928559 | 82450 | 391 | 1.603774 | 6.27075634 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 351 | 3.289999999999999e-92 | NTclustered | gi|2556886971|gb|CP129473.1| | 2053589 | g80881 | i0 | 83.204 | 13.2378516624041 | 387 | 61 | 98 | 3 | 7 | 391 | 441718 | 441334 | MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome | blastn | 5176 | 351 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 17481808 | 17481808 | PRJNA928559_P_NODE_22214_length_677_cov_2.625828_g20727_i0 | PRJNA928559 | 22214 | 677 | 2.625828 | 17.77685556 | Candidatus Phycocordibacter aenigmaticus | 1948796 | Bacteria | Bacteria | 525 | 3.31e-144 | NTclustered | gi|2862534145|gb|CP174359.1| | 1948796 | g20727 | i0 | 80.87 | 42.9675036927622 | 690 | 113 | 100 | 16 | 1 | 677 | 75241 | 75924 | MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome | blastn | 29089 | 525 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Candidatus Phycocordibacterales | Candidatus Phycocordibacteraceae | Candidatus Phycocordibacter | Candidatus Phycocordibacter aenigmaticus |
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);;