contig_metadata
4 rows where bioproject = "PRJNA1195374" and tax_phylum = "Uroviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15625014 | 15625014 | PRJNA1195374_P_NODE_73573_length_249_cov_1.113636_g73229_i0 | PRJNA1195374 | 73573 | 249 | 1.113636 | 2.77295364 | Xanthomonas phage Kintu | 3120010 | Viruses | Viruses | 326 | 1.2e-84 | NTclustered | gi|2677115081|gb|PP313117.1| | 3120010 | g73229 | i0 | 90.323 | 0.995983935742972 | 248 | 24 | 99 | 0 | 1 | 248 | 29614 | 29861 | Xanthomonas phage Kintu, complete genome | blastn | 248 | 326 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Xanthomonas phage Kintu | |||||
| 20723390 | 20723390 | PRJNA1195374_P_NODE_63237_length_271_cov_1.368687_g62893_i0 | PRJNA1195374 | 63237 | 271 | 1.368687 | 3.70914177 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 228 | 3.8499999999999985e-55 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g62893 | i0 | 82.051 | 65.0811808118081 | 273 | 44 | 100 | 4 | 1 | 271 | 18259 | 17990 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 17637 | 228 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27577943 | 27577943 | PRJNA1195374_P_NODE_66884_length_261_cov_1.638298_g66540_i0 | PRJNA1195374 | 66884 | 261 | 1.638298 | 4.27595778 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 43.9 | 0.00773 | NR | DAS73008.1 | 2832643 | g66540 | i0 | 32.9 | 0.873563218390805 | 76 | 47 | 87.4 | 1 | 4 | 231 | 55 | 126 | DAS73008.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 228 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 27767620 | 27767620 | PRJNA1195374_P_NODE_75224_length_248_cov_0.880000_g74880_i0 | PRJNA1195374 | 75224 | 248 | 0.88 | 2.1824 | Ralstonia phage RsoM2USA | 2070027 | Viruses | Viruses | 101 | 3.9e-24 | NR | AVH85297.1 | 2070027 | g74880 | i0 | 57.3 | 0.991935483870968 | 82 | 35 | 99.2 | 0 | 246 | 1 | 41 | 122 | AVH85297.1 hypothetical protein RsoM2USA_369 [Ralstonia phage RsoM2USA] | diamond | 246 | 101 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Ralstonia phage RsoM2USA |
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);;