contig_metadata
8 rows where bioproject = "PRJNA766854" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3296215 | 3296215 | PRJNA766854_P_NODE_1903_length_306_cov_4.043321_g1778_i0 | PRJNA766854 | 1903 | 306 | 4.043321 | 12.37256226 | Shockervirus shocker | 3432426 | Viruses | Viruses | 87.9 | 7.82e-13 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g1778 | i0 | 90.769 | 0.212418300653595 | 65 | 6 | 21 | 0 | 181 | 245 | 40603 | 40539 | Microbacterium phage Shocker, complete genome | blastn | 65 | 87.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 7123669 | 7123669 | PRJNA766854_P_NODE_1106_length_399_cov_10.327027_g985_i0 | PRJNA766854 | 1106 | 399 | 10.327027 | 41.20483773 | Shockervirus shocker | 3432426 | Viruses | Viruses | 67.6 | 1.36e-6 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g985 | i0 | 87.931 | 0.290726817042607 | 58 | 5 | 14 | 2 | 88 | 144 | 484 | 428 | Microbacterium phage Shocker, complete genome | blastn | 116 | 67.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 9673412 | 9673412 | PRJNA766854_P_NODE_1848_length_308_cov_2.946237_g1723_i0 | PRJNA766854 | 1848 | 308 | 2.946237 | 9.07440996 | Shockervirus shocker | 3432426 | Viruses | Viruses | 84.2 | 1.02e-11 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g1723 | i0 | 94.444 | 0.175324675324675 | 54 | 3 | 18 | 0 | 193 | 246 | 41911 | 41858 | Microbacterium phage Shocker, complete genome | blastn | 54 | 84.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 9673418 | 9673418 | PRJNA766854_P_NODE_18848_length_155_cov_4.412698_g18721_i0 | PRJNA766854 | 18848 | 155 | 4.412698 | 6.8396819 | Shockervirus shocker | 3432426 | Viruses | Viruses | 191 | 2.59e-44 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g18721 | i0 | 98.165 | 0.703225806451613 | 109 | 2 | 70 | 0 | 2 | 110 | 41234 | 41126 | Microbacterium phage Shocker, complete genome | blastn | 109 | 191 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 12224643 | 12224643 | PRJNA766854_P_NODE_630_length_493_cov_2.952586_g530_i0 | PRJNA766854 | 630 | 493 | 2.952586 | 14.55624898 | Shockervirus shocker | 3432426 | Viruses | Viruses | 80.5 | 2.21e-10 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g530 | i0 | 95.918 | 0.0993914807302231 | 49 | 2 | 10 | 0 | 381 | 429 | 32077 | 32125 | Microbacterium phage Shocker, complete genome | blastn | 49 | 80.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 22422247 | 22422247 | PRJNA766854_P_NODE_1678_length_321_cov_2.582192_g1553_i0 | PRJNA766854 | 1678 | 321 | 2.582192 | 8.28883632 | Shockervirus shocker | 3432426 | Viruses | Viruses | 145 | 4.83e-30 | NTclustered | gi|2487592915|ref|NC_073470.1| | 2805839 | g1553 | i0 | 97.619 | 0.261682242990654 | 84 | 2 | 26 | 0 | 1 | 84 | 26786 | 26703 | Microbacterium phage Shocker, complete genome | blastn | 84 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 29800404 | 29800404 | PRJNA766854_P_NODE_1791_length_312_cov_1.780919_g1666_i0 | PRJNA766854 | 1791 | 312 | 1.780919 | 5.55646728 | Microbacterium phage Shocker | 2805839 | Viruses | Viruses | 43.9 | 0.0319 | NR | YP_010755454.1 | 2805839 | g1666 | i0 | 90 | 0.192307692307692 | 20 | 2 | 19.2 | 0 | 125 | 66 | 118 | 137 | YP_010755454.1 DNA primase/helicase [Microbacterium phage Shocker] | diamond | 60 | 43.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker | ||||
| 32897212 | 32897212 | PRJNA766854_P_NODE_1520_length_336_cov_3.276873_g1395_i0 | PRJNA766854 | 1520 | 336 | 3.276873 | 11.01029328 | Microbacterium phage Shocker | 2805839 | Viruses | Viruses | 47.4 | 3.6e-4 | NR | YP_010755426.1 | 2805839 | g1395 | i0 | 84 | 0.223214285714286 | 25 | 4 | 22.3 | 0 | 79 | 5 | 45 | 69 | YP_010755426.1 hypothetical protein QEH45_gp16 [Microbacterium phage Shocker] | diamond | 75 | 47.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shockervirus | Shockervirus shocker |
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);;