contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA816527" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2094969 | 2094969 | PRJNA816527_P_NODE_16902_length_251_cov_0.865169_g16852_i0 | PRJNA816527 | 16902 | 251 | 0.865169 | 2.17157419 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 335 | 2.0199999999999998e-87 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g16852 | i0 | 94.144 | 31.2549800796813 | 222 | 9 | 88 | 2 | 30 | 251 | 91325 | 91108 | Klebsiella phage pzk-kv8, complete genome | blastn | 7845 | 335 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 3370174 | 3370174 | PRJNA816527_P_NODE_14163_length_279_cov_1.490291_g14113_i0 | PRJNA816527 | 14163 | 279 | 1.490291 | 4.15791189 | Klebsiella phage pzk-kv8 | 3062826 | Viruses | Viruses | 394 | 3.709999999999999e-105 | NTclustered | gi|2554109259|gb|OR231917.1| | 3062826 | g14113 | i0 | 92.115 | 1 | 279 | 22 | 100 | 0 | 1 | 279 | 105586 | 105864 | Klebsiella phage pzk-kv8, complete genome | blastn | 279 | 394 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage pzk-kv8 | ||||
| 7197485 | 7197485 | PRJNA816527_P_NODE_13946_length_281_cov_1.480769_g13896_i0 | PRJNA816527 | 13946 | 281 | 1.480769 | 4.16096089 | Klebsiella phage EI | 2601625 | Viruses | Viruses | 370 | 6.3e-98 | NTclustered | gi|1735348037|gb|MN106245.1| | 2601625 | g13896 | i0 | 90.391 | 40.5338078291815 | 281 | 27 | 100 | 0 | 1 | 281 | 134356 | 134076 | Klebsiella phage EI, complete genome | blastn | 11390 | 370 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Klebsiella phage EI | ||||
| 13573029 | 13573029 | PRJNA816527_P_NODE_18751_length_246_cov_0.890173_g18701_i0 | PRJNA816527 | 18751 | 246 | 0.890173 | 2.18982558 | Marfavirus F48 | 2845079 | Viruses | Viruses | 233 | 7.39e-57 | NTclustered | gi|2132900028|gb|MZ571829.1| | 2866697 | g18701 | i0 | 83.74 | 2.95121951219512 | 246 | 40 | 100 | 0 | 1 | 246 | 15342 | 15097 | Klebsiella phage vB_KpnM-VAC36, complete genome | blastn | 726 | 233 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 15256009 | 15256009 | PRJNA816527_P_NODE_20172_length_242_cov_0.911243_g20122_i0 | PRJNA816527 | 20172 | 242 | 0.911243 | 2.20520806 | Hennigervirus | 3424959 | Viruses | Viruses | 435 | 1.85e-117 | NTclustered | gi|1842037666|ref|NC_048200.1| | 1729933 | g20122 | i0 | 99.17 | 39.8884297520661 | 241 | 2 | 99 | 0 | 2 | 242 | 32732 | 32492 | Pseudomonas phage shl2 genome assembly, chromosome: 1 | blastn | 9653 | 435 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Hennigervirus | Hennigervirus shl2 | ||
| 21221422 | 21221422 | PRJNA816527_P_NODE_15237_length_268_cov_1.041026_g15187_i0 | PRJNA816527 | 15237 | 268 | 1.041026 | 2.78994968 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 490 | 4.39e-134 | NTclustered | gi|2914751570|gb|OR221330.1| | 2832643 | g15187 | i0 | 99.627 | 1 | 268 | 1 | 100 | 0 | 1 | 268 | 1790 | 1523 | MAG: Caudoviricetes sp. isolate MSP1779 genomic sequence | blastn | 268 | 490 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 22905453 | 22905453 | PRJNA816527_P_NODE_11198_length_314_cov_1.917012_g11148_i0 | PRJNA816527 | 11198 | 314 | 1.917012 | 6.01941768 | Marfavirus | 2843419 | Viruses | Viruses | 520 | 6.6999999999999985e-143 | NTclustered | gi|1726264207|gb|MN013081.1| | 2591366 | g11148 | i0 | 96.497 | 20 | 314 | 11 | 100 | 0 | 1 | 314 | 120128 | 119815 | Klebsiella phage vB_KpnM_Potts1, complete genome | blastn | 6280 | 520 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 | ||||
| 24179608 | 24179608 | PRJNA816527_P_NODE_15479_length_265_cov_1.354167_g15429_i0 | PRJNA816527 | 15479 | 265 | 1.354167 | 3.58854255 | Marfavirus | 2843419 | Viruses | Viruses | 300 | 7.830000000000001e-77 | NTclustered | gi|2179809833|gb|MZ634347.1| | 2863266 | g15429 | i0 | 87.121 | 14.9433962264151 | 264 | 34 | 99 | 0 | 2 | 265 | 91496 | 91233 | Klebsiella phage PWKp16, complete genome | blastn | 3960 | 300 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marfavirus | Marfavirus F48 |
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);;