contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax_kingdom = "Heunggongvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7125666 | 7125666 | PRJNA770826_P_NODE_4146_length_424_cov_1.282667_g3975_i0 | PRJNA770826 | 4146 | 424 | 1.282667 | 5.43850808 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 704 | 0 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g3975 | i0 | 96.69 | 401.514150943396 | 423 | 14 | 99 | 0 | 1 | 423 | 18277 | 17855 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 170242 | 704 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13500654 | 13500654 | PRJNA770826_P_NODE_29971_length_167_cov_0.881356_g29800_i0 | PRJNA770826 | 29971 | 167 | 0.881356 | 1.47186452 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 303 | 3.5e-78 | NTclustered | gi|2914754492|gb|OR221467.1| | 2832643 | g29800 | i0 | 99.401 | 3 | 167 | 1 | 100 | 0 | 1 | 167 | 25698 | 25864 | MAG: Caudoviricetes sp. isolate MSP1619 genomic sequence | blastn | 501 | 303 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17325233 | 17325233 | PRJNA770826_P_NODE_26674_length_168_cov_0.873950_g26503_i0 | PRJNA770826 | 26674 | 168 | 0.87395 | 1.468236 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 2.12e-75 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g26503 | i0 | 98.225 | 5.75595238095238 | 169 | 2 | 100 | 1 | 1 | 168 | 6400 | 6568 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 967 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20333148 | 20333148 | PRJNA770826_P_NODE_39236_length_163_cov_0.912281_g39065_i0 | PRJNA770826 | 39236 | 163 | 0.912281 | 1.48701803 | root | 1 | Root_unresolved | Root_unresolved | 302 | 1.22e-77 | NTclustered | gi|2057959827|tpg|BK046364.1| | 2832643 | g39065 | i0 | 100 | 12.8588957055215 | 163 | 0 | 100 | 0 | 1 | 163 | 31475 | 31313 | MAG TPA_asm: Caudoviricetes sp. isolate ctThn6, partial genome | blastn | 2096 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21149584 | 21149584 | PRJNA770826_P_NODE_8837_length_272_cov_1.632287_g8666_i0 | PRJNA770826 | 8837 | 272 | 1.632287 | 4.43982064 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 62.1 | 4.15e-5 | NTclustered | gi|2906149976|gb|PQ646492.1| | 2832643 | g8666 | i0 | 89.583 | 0.308823529411765 | 48 | 5 | 18 | 0 | 218 | 265 | 14529 | 14576 | MAG: Caudoviricetes sp. isolate k127_1042512 genomic sequence | blastn | 84 | 62.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 23699847 | 23699847 | PRJNA770826_P_NODE_21379_length_175_cov_1.238095_g21208_i0 | PRJNA770826 | 21379 | 175 | 1.238095 | 2.16666625 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 252 | 1.3499999999999999e-62 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g21208 | i0 | 92.614 | 4.95428571428571 | 176 | 11 | 100 | 2 | 1 | 175 | 7566 | 7392 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 867 | 252 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. |
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);;