contig_metadata
10 rows where bioproject = "PRJNA348537" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 393545 | 393545 | PRJNA348537_S_NODE_3861_length_161_cov_2.357143_g3815_i0 | PRJNA348537 | 3861 | 161 | 2.357143 | 3.79500023 | Pahexavirus P101A | 1982267 | Viruses | Viruses | 281 | 1.57e-71 | NTclustered | gi|408905836|ref|NC_018841.1| | 1229786 | g3815 | i0 | 98.137 | 99.9627329192547 | 161 | 3 | 100 | 0 | 1 | 161 | 22622 | 22462 | Propionibacterium phage P101A, complete genome | blastn | 16094 | 281 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus P101A | ||||
| 4220744 | 4220744 | PRJNA348537_S_NODE_2864_length_182_cov_2.768707_g2818_i0 | PRJNA348537 | 2864 | 182 | 2.768707 | 5.03904674 | Propionibacterium phage pa28 | 2079401 | Viruses | Viruses | 327 | 2.3e-85 | NTclustered | gi|1338076777|gb|MG820642.1| | 2079401 | g2818 | i0 | 99.444 | 102.120879120879 | 180 | 1 | 99 | 0 | 3 | 182 | 25667 | 25488 | Propionibacterium phage pa28, complete genome | blastn | 18586 | 327 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa28 | ||||
| 9321500 | 9321500 | PRJNA348537_S_NODE_2948_length_180_cov_1.655172_g2902_i0 | PRJNA348537 | 2948 | 180 | 1.655172 | 2.9793096 | Propionibacterium phage pa29399-1-D_2 | 2079403 | Viruses | Viruses | 324 | 2.93e-84 | NTclustered | gi|1338076736|gb|MG820636.1| | 2079403 | g2902 | i0 | 99.438 | 97.6277777777778 | 178 | 1 | 99 | 0 | 1 | 178 | 13284 | 13461 | Propionibacterium phage pa29399-1-D_2, complete genome | blastn | 17573 | 324 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa29399-1-D_2 | ||||
| 17648064 | 17648064 | PRJNA348537_S_NODE_4294_length_155_cov_1.391667_g4248_i0 | PRJNA348537 | 4294 | 155 | 1.391667 | 2.15708385 | Pahexavirus | 1982251 | Viruses | Viruses | 237 | 3.2800000000000004e-58 | NTclustered | gi|543171262|ref|NC_022334.1| | 1235654 | g4248 | i0 | 95.89 | 93.2 | 146 | 6 | 94 | 0 | 4 | 149 | 6728 | 6873 | Propionibacterium phage PHL112N00, complete genome | blastn | 14446 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL112N00 | ||||
| 20794881 | 20794881 | PRJNA348537_S_NODE_3477_length_168_cov_2.548872_g3431_i0 | PRJNA348537 | 3477 | 168 | 2.548872 | 4.28210496 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 145 | 2.26e-30 | NTclustered | gi|2054644585|tpg|BK051890.1| | 2832643 | g3431 | i0 | 82.53 | 0.988095238095238 | 166 | 27 | 98 | 2 | 4 | 168 | 10707 | 10871 | MAG TPA_asm: Caudoviricetes sp. isolate ctsm13, partial genome | blastn | 166 | 145 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22747366 | 22747366 | PRJNA348537_S_NODE_798_length_316_cov_2.644128_g752_i0 | PRJNA348537 | 798 | 316 | 2.644128 | 8.35544448 | Pahexavirus | 1982251 | Viruses | Viruses | 545 | 1.11e-150 | NTclustered | gi|906476064|ref|NC_027627.1| | 1655021 | g752 | i0 | 97.785 | 99.9398734177215 | 316 | 7 | 100 | 0 | 1 | 316 | 1244 | 1559 | Propionibacterium phage Solid, complete genome | blastn | 31581 | 545 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus solid | ||||
| 25296657 | 25296657 | PRJNA348537_S_NODE_4440_length_153_cov_3.610169_g4394_i0 | PRJNA348537 | 4440 | 153 | 3.610169 | 5.52355857 | Pahexavirus | 1982251 | Viruses | Viruses | 283 | 4.0799999999999995e-72 | NTclustered | gi|1338076751|gb|MG820638.1| | 2079411 | g4394 | i0 | 100 | 97.9150326797386 | 153 | 0 | 100 | 0 | 1 | 153 | 25350 | 25502 | Propionibacterium phage pa6919-4, complete genome | blastn | 14981 | 283 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa6919-4 | ||||
| 27611966 | 27611966 | PRJNA348537_S_NODE_2384_length_196_cov_4.335404_g2338_i0 | PRJNA348537 | 2384 | 196 | 4.335404 | 8.49739184 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 98.6 | 4.38e-22 | NR | DAM41230.1 | 2832643 | g2338 | i0 | 79 | 0.948979591836735 | 62 | 13 | 94.9 | 0 | 187 | 2 | 78 | 139 | DAM41230.1 MAG TPA: DNA polymerase B, partial [Caudoviricetes sp.] | diamond | 186 | 98.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 28116929 | 28116929 | PRJNA348537_S_NODE_505_length_384_cov_3.816619_g459_i0 | PRJNA348537 | 505 | 384 | 3.816619 | 14.65581696 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 127 | 9.29e-34 | NR | DAM41232.1 | 2832643 | g459 | i0 | 55.2 | 0.9765625 | 125 | 56 | 97.7 | 0 | 378 | 4 | 62 | 186 | DAM41232.1 MAG TPA: head to tail adaptor [Caudoviricetes sp.] | diamond | 375 | 127 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32161391 | 32161391 | PRJNA348537_S_NODE_1238_length_261_cov_5.977876_g1192_i0 | PRJNA348537 | 1238 | 261 | 5.977876 | 15.60225636 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 156 | 3.63e-44 | NR | DAM41229.1 | 2832643 | g1192 | i0 | 83.9 | 1 | 87 | 14 | 100 | 0 | 1 | 261 | 63 | 149 | DAM41229.1 MAG TPA: DNA encapsidation protein, partial [Caudoviricetes sp.] | diamond | 261 | 156 | 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);;