contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax_clade = "Bacteria candidate phyla"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8365141 | 8365141 | PRJNA725806_P_NODE_192247_length_151_cov_3.026316_g191945_i0 | PRJNA725806 | 192247 | 151 | 3.026316 | 4.56973716 | Candidatus Phycocordibacter aenigmaticus | 1948796 | Bacteria | Bacteria | 52.8 | 0.012 | NTclustered | gi|2862534145|gb|CP174359.1| | 1948796 | g191945 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 106 | 133 | 338988 | 339015 | MAG: Patescibacteria group bacterium UBA2163 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccia | Candidatus Phycocordibacterales | Candidatus Phycocordibacteraceae | Candidatus Phycocordibacter | Candidatus Phycocordibacter aenigmaticus | ||
| 8365236 | 8365236 | PRJNA725806_P_NODE_59327_length_236_cov_1.216080_g59030_i0 | PRJNA725806 | 59327 | 236 | 1.21608 | 2.8699488 | Candidatus Nealsonbacteria bacterium DGGOD1a | 3043262 | Bacteria | Bacteria | 52.8 | 0.021 | NTclustered | gi|2205901313|gb|CP092821.1| | 3043262 | g59030 | i0 | 100 | 0.11864406779661 | 28 | 0 | 12 | 0 | 88 | 115 | 492038 | 492065 | MAG: Candidatus Nealsonbacteria bacterium DGGOD1a chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nealsoniibacteriota | Candidatus Nealsonbacteria bacterium DGGOD1a | ||||||
| 11398116 | 11398116 | PRJNA725806_P_NODE_54449_length_242_cov_3.741463_g54152_i0 | PRJNA725806 | 54449 | 242 | 3.741463 | 9.05434046 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|2314743697|dbj|AP026679.1| | 2099670 | g54152 | i0 | 100 | 0.239669421487603 | 29 | 0 | 12 | 0 | 98 | 126 | 262706 | 262678 | MAG: Candidatus Dojkabacteria bacterium KatS3mg084 DNA, complete genome | blastn | 58 | 54.7 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Dojkabacteria bacterium | |||||||
| 23664771 | 23664771 | PRJNA725806_P_NODE_13179_length_351_cov_6.216561_g12889_i0 | PRJNA725806 | 13179 | 351 | 6.216561 | 21.82012911 | Candidatus Aminicenantes bacterium | 2052149 | Bacteria | Bacteria | 52.8 | 0.033 | NTclustered | gi|2108435138|gb|CP070627.1| | 2052149 | g12889 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 94 | 121 | 2876108 | 2876135 | MAG: Candidatus Aminicenantes bacterium isolate bin99 chromosome | blastn | 28 | 52.8 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Aminicenantota | Candidatus Aminicenantes 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);;