contig_metadata
15 rows where bioproject = "PRJNA1008049" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1001276 | 1001276 | PRJNA1008049_S_NODE_3261_length_166_cov_2.518248_g3243_i0 | PRJNA1008049 | 3261 | 166 | 2.518248 | 4.18029168 | root | 1 | Root_unresolved | Root_unresolved | 278 | 2.11e-70 | NTclustered | gi|2052221413|tpg|BK056526.1| | 2832643 | g3243 | i0 | 97.531 | 99.9638554216867 | 162 | 4 | 98 | 0 | 5 | 166 | 312 | 151 | MAG TPA_asm: Caudoviricetes sp. isolate ct6kA1, partial genome | blastn | 16594 | 279 | 0.996415770609319 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 2703974 | 2703974 | PRJNA1008049_S_NODE_1663_length_188_cov_2.886792_g1645_i0 | PRJNA1008049 | 1663 | 188 | 2.886792 | 5.42716896 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 340 | 3.07e-89 | NTclustered | gi|2052201437|tpg|BK056134.1| | 2832643 | g1645 | i0 | 100 | 47.7287234042553 | 184 | 0 | 98 | 0 | 5 | 188 | 5585 | 5768 | MAG TPA_asm: Caudoviricetes sp. isolate ctDNN3, partial genome | blastn | 8973 | 340 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3980226 | 3980226 | PRJNA1008049_S_NODE_3904_length_159_cov_8.246154_g3886_i0 | PRJNA1008049 | 3904 | 159 | 8.246154 | 13.11138486 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 294 | 1.98e-75 | NTclustered | gi|2056743652|tpg|BK045160.1| | 2832643 | g3886 | i0 | 100 | 10.1572327044025 | 159 | 0 | 100 | 0 | 1 | 159 | 46453 | 46295 | MAG TPA_asm: Caudoviricetes sp. isolate ctl2Z5, partial genome | blastn | 1615 | 294 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 6531965 | 6531965 | PRJNA1008049_S_NODE_4186_length_157_cov_5.382812_g4168_i0 | PRJNA1008049 | 4186 | 157 | 5.382812 | 8.45101484 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 278 | 1.96e-70 | NTclustered | gi|2054522819|tpg|BK047507.1| | 2832643 | g4168 | i0 | 98.718 | 2.9171974522293 | 156 | 2 | 99 | 0 | 1 | 156 | 36918 | 36763 | MAG TPA_asm: Caudoviricetes sp. isolate cti5P2, partial genome | blastn | 458 | 278 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9081298 | 9081298 | PRJNA1008049_S_NODE_4868_length_152_cov_6.105691_g4850_i0 | PRJNA1008049 | 4868 | 152 | 6.105691 | 9.28065032 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 248 | 1.48e-61 | NTclustered | gi|2054763781|tpg|BK043668.1| | 2832643 | g4850 | i0 | 96.053 | 5.73684210526316 | 152 | 6 | 100 | 0 | 1 | 152 | 16956 | 17107 | MAG TPA_asm: Caudoviricetes sp. isolate ctiiE11, partial genome | blastn | 872 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10356944 | 10356944 | PRJNA1008049_S_NODE_3329_length_165_cov_5.669118_g3311_i0 | PRJNA1008049 | 3329 | 165 | 5.669118 | 9.3540447 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|2054657675|tpg|BK052145.1| | 2832643 | g3311 | i0 | 100 | 4 | 165 | 0 | 100 | 0 | 1 | 165 | 5870 | 6034 | MAG TPA_asm: Caudoviricetes sp. isolate ctf5e3, partial genome | blastn | 660 | 305 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11632394 | 11632394 | PRJNA1008049_S_NODE_3990_length_159_cov_1.776923_g3972_i0 | PRJNA1008049 | 3990 | 159 | 1.776923 | 2.82530757 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 185 | 1.2399999999999997e-42 | NTclustered | gi|2054663876|tpg|BK052267.1| | 2832643 | g3972 | i0 | 87.898 | 24.062893081761 | 157 | 19 | 99 | 0 | 3 | 159 | 5442 | 5598 | MAG TPA_asm: Caudoviricetes sp. isolate ctSeF1, partial genome | blastn | 3826 | 185 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15029043 | 15029043 | PRJNA1008049_S_NODE_1552_length_190_cov_11.900621_g1534_i0 | PRJNA1008049 | 1552 | 190 | 11.900621 | 22.6111799 | Pahexavirus | 1982251 | Viruses | Viruses | 318 | 1.46e-82 | NTclustered | gi|849255653|ref|NC_027389.1| | 1500821 | g1534 | i0 | 96.842 | 100.005263157895 | 190 | 6 | 100 | 0 | 1 | 190 | 7188 | 7377 | Propionibacterium phage PHL141N00, complete genome | blastn | 19001 | 318 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL141N00 | ||||
| 15456421 | 15456421 | PRJNA1008049_S_NODE_2813_length_171_cov_3.669014_g2795_i0 | PRJNA1008049 | 2813 | 171 | 3.669014 | 6.27401394 | Skunavirus jm2 | 2845474 | Viruses | Viruses | 265 | 1.69e-66 | NTclustered | gi|526244756|ref|NC_021860.1| | 1262535 | g2795 | i0 | 94.737 | 93.4619883040936 | 171 | 8 | 100 | 1 | 1 | 171 | 25087 | 24918 | Lactococcus phage jm2, complete genome | blastn | 15982 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Skunavirus | Skunavirus jm2 | ||||
| 16303806 | 16303806 | PRJNA1008049_S_NODE_4793_length_153_cov_1.862903_g4775_i0 | PRJNA1008049 | 4793 | 153 | 1.862903 | 2.85024159 | Aliceevansviridae | 3044455 | Viruses | Viruses | 279 | 5.28e-71 | NTclustered | gi|2437986536|ref|NC_070710.1| | 1971447 | g4775 | i0 | 100 | 97.9542483660131 | 151 | 0 | 99 | 0 | 3 | 153 | 30278 | 30128 | Streptococcus phage P9901, complete genome | blastn | 14987 | 279 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus P9901 | |||
| 17579134 | 17579134 | PRJNA1008049_S_NODE_1254_length_199_cov_7.917647_g1236_i0 | PRJNA1008049 | 1254 | 199 | 7.917647 | 15.75611753 | Pahexavirus | 1982251 | Viruses | Viruses | 344 | 2.5399999999999993e-90 | NTclustered | gi|1269173928|gb|MF919533.1| | 2041563 | g1236 | i0 | 98.462 | 95.321608040201 | 195 | 3 | 98 | 0 | 1 | 195 | 17997 | 17803 | Propionibacterium phage Supernova, complete genome | blastn | 18969 | 344 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage Supernova | ||||
| 19279354 | 19279354 | PRJNA1008049_S_NODE_4496_length_155_cov_1.928571_g4478_i0 | PRJNA1008049 | 4496 | 155 | 1.928571 | 2.98928505 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 283 | 4.15e-72 | NTclustered | gi|2059970893|tpg|BK025683.1| | 2832643 | g4478 | i0 | 100 | 4.93548387096774 | 153 | 0 | 99 | 0 | 3 | 155 | 1231 | 1383 | MAG TPA_asm: Caudoviricetes sp. isolate ctigG4, partial genome | blastn | 765 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 20127743 | 20127743 | PRJNA1008049_S_NODE_3156_length_167_cov_3.166667_g3138_i0 | PRJNA1008049 | 3156 | 167 | 3.166667 | 5.28833389 | Aliceevansviridae | 3044455 | Viruses | Viruses | 292 | 7.58e-75 | NTclustered | gi|2437986293|ref|NC_070705.1| | 1971433 | g3138 | i0 | 98.204 | 32.2455089820359 | 167 | 3 | 100 | 0 | 1 | 167 | 24497 | 24331 | Streptococcus phage P7631, complete genome | blastn | 5385 | 292 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Aliceevansviridae | Moineauvirus | Moineauvirus P7631 | |||
| 31298368 | 31298368 | PRJNA1008049_S_NODE_4855_length_152_cov_8.284553_g4837_i0 | PRJNA1008049 | 4855 | 152 | 8.284553 | 12.59252056 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 66.2 | 4.16e-11 | NR | DAV36789.1 | 2832643 | g4837 | i0 | 65.3 | 0.967105263157895 | 49 | 17 | 96.7 | 0 | 152 | 6 | 228 | 276 | DAV36789.1 MAG TPA: Protein of unknown function (DUF3232) [Caudoviricetes sp.] | diamond | 147 | 66.2 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 31329992 | 31329992 | PRJNA1008049_S_NODE_1656_length_188_cov_4.132075_g1638_i0 | PRJNA1008049 | 1656 | 188 | 4.132075 | 7.768301 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 80.5 | 8.88e-16 | NR | DAF07814.1 | 2832643 | g1638 | i0 | 68.3 | 0.957446808510638 | 60 | 17 | 95.7 | 1 | 180 | 1 | 902 | 959 | DAF07814.1 MAG TPA: Putative virion structural protein 2 [Caudoviricetes sp.] | diamond | 180 | 80.5 | 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);;