contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2096136 | 2096136 | PRJNA826497_S_NODE_12182_length_176_cov_6.349650_g12142_i0 | PRJNA826497 | 12182 | 176 | 6.34965 | 11.175384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 237 | 3.82e-58 | NTclustered | gi|2054701562|tpg|BK053026.1| | 2832643 | g12142 | i0 | 90.909 | 2 | 176 | 16 | 100 | 0 | 1 | 176 | 56597 | 56422 | MAG TPA_asm: Caudoviricetes sp. isolate ctf7p8, partial genome | blastn | 352 | 237 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 3780158 | 3780158 | PRJNA826497_S_NODE_4683_length_231_cov_4.398990_g4643_i0 | PRJNA826497 | 4683 | 231 | 4.39899 | 10.1616669 | Tobamovirus | 12234 | Viruses | Viruses | 425 | 1.0599999999999999e-114 | NTclustered | gi|66863602|dbj|AB113116.1| | 12239 | g4643 | i0 | 100 | 93.4502164502164 | 230 | 0 | 99 | 0 | 2 | 231 | 3559 | 3788 | Pepper mild mottle virus gene for 126k protein, complete cds, strain: Pa18 | blastn | 21587 | 425 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 5923900 | 5923900 | PRJNA826497_S_NODE_9905_length_188_cov_1.174194_g9865_i0 | PRJNA826497 | 9905 | 188 | 1.174194 | 2.20748472 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 265 | 1.9000000000000001e-66 | NTclustered | gi|2058119972|tpg|BK033910.1| | 2832643 | g9865 | i0 | 92.857 | 1.92553191489362 | 182 | 13 | 97 | 0 | 1 | 182 | 186890 | 186709 | MAG TPA_asm: Caudoviricetes sp. isolate ct5kF4, partial genome | blastn | 362 | 265 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7198820 | 7198820 | PRJNA826497_S_NODE_8686_length_195_cov_4.141975_g8646_i0 | PRJNA826497 | 8686 | 195 | 4.141975 | 8.07685125 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 215 | 2.03e-51 | NTclustered | gi|2053078945|tpg|BK020046.1| | 2832643 | g8646 | i0 | 98.361 | 0.923076923076923 | 122 | 2 | 63 | 0 | 68 | 189 | 5806 | 5927 | MAG TPA_asm: Caudoviricetes sp. isolate ctKcv1, partial genome | blastn | 180 | 215 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 7606249 | 7606249 | PRJNA826497_S_NODE_20346_length_150_cov_1.837607_g20306_i0 | PRJNA826497 | 20346 | 150 | 1.837607 | 2.7564105 | Vhmlvirus | 1922210 | Viruses | Viruses | 270 | 3.1e-68 | NTclustered | gi|27311175|ref|NC_004456.1| | 207597 | g20306 | i0 | 100 | 2.92 | 146 | 0 | 97 | 0 | 1 | 146 | 14512 | 14657 | Vibrio phage VHML, complete genome | blastn | 438 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vhmlvirus | Vhmlvirus VHML | ||||
| 8473503 | 8473503 | PRJNA826497_S_NODE_12547_length_175_cov_2.267606_g12507_i0 | PRJNA826497 | 12547 | 175 | 2.267606 | 3.9683105 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 248 | 1.7499999999999998e-61 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g12507 | i0 | 92.486 | 0.988571428571429 | 173 | 13 | 99 | 0 | 1 | 173 | 40451 | 40623 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 173 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 8881302 | 8881302 | PRJNA826497_S_NODE_4587_length_232_cov_8.150754_g4547_i0 | PRJNA826497 | 4587 | 232 | 8.150754 | 18.90974928 | root | 1 | Root_unresolved | Root_unresolved | 429 | 8.2e-116 | NTclustered | gi|2452970428|gb|OQ518271.1| | 10515 | g4547 | i0 | 100 | 100 | 232 | 0 | 100 | 0 | 1 | 232 | 33028 | 32797 | Human adenovirus 2 isolate HAdV-C2/USA/8A5/2011, complete genome | blastn | 23200 | 429 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari | ||
| 10156752 | 10156752 | PRJNA826497_S_NODE_7268_length_205_cov_3.366279_g7228_i0 | PRJNA826497 | 7268 | 205 | 3.366279 | 6.90087195 | root | 1 | Root_unresolved | Root_unresolved | 353 | 4.38e-93 | NTclustered | gi|2083029198|gb|MZ375249.1| | 10760 | g7228 | i0 | 99.485 | 94.6341463414634 | 194 | 1 | 95 | 0 | 1 | 194 | 5476 | 5669 | Mutant Escherichia phage T7 clone T7_90L, complete genome | blastn | 19400 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Teseptimavirus | Teseptimavirus T7 | ||
| 11024390 | 11024390 | PRJNA826497_S_NODE_6009_length_216_cov_6.016393_g5969_i0 | PRJNA826497 | 6009 | 216 | 6.016393 | 12.99540888 | Propionibacterium phage Moyashi | 1654781 | Viruses | Viruses | 388 | 1.28e-103 | NTclustered | gi|1070064454|ref|NC_031003.1| | 1654781 | g5969 | i0 | 99.074 | 100.180555555556 | 216 | 2 | 100 | 0 | 1 | 216 | 8523 | 8738 | Propionibacterium phage Moyashi, complete genome | blastn | 21639 | 388 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage Moyashi | ||||
| 11024394 | 11024394 | PRJNA826497_S_NODE_6869_length_208_cov_9.788571_g6829_i0 | PRJNA826497 | 6869 | 208 | 9.788571 | 20.36022768 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 316 | 5.849999999999998e-82 | NTclustered | gi|2906153236|gb|PQ646714.1| | 2833306 | g6829 | i0 | 94.203 | 0.995192307692308 | 207 | 12 | 99 | 0 | 1 | 207 | 382 | 588 | MAG: Tubulavirales sp. isolate k127_4197263 genomic sequence | blastn | 207 | 316 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales sp. | ||||
| 11024408 | 11024408 | PRJNA826497_S_NODE_9869_length_188_cov_2.380645_g9829_i0 | PRJNA826497 | 9869 | 188 | 2.380645 | 4.4756126 | Tubulavirales sp. | 2833306 | Viruses | Viruses | 303 | 4.03e-78 | NTclustered | gi|2906153236|gb|PQ646714.1| | 2833306 | g9829 | i0 | 95.745 | 1 | 188 | 8 | 100 | 0 | 1 | 188 | 856 | 669 | MAG: Tubulavirales sp. isolate k127_4197263 genomic sequence | blastn | 188 | 303 | 1 | Viruses | Loebvirae | Hofneiviricota | Faserviricetes | Tubulavirales | Tubulavirales sp. | ||||
| 11432012 | 11432012 | PRJNA826497_S_NODE_1989_length_285_cov_4.376984_g1949_i0 | PRJNA826497 | 1989 | 285 | 4.376984 | 12.4744044 | Pahexavirus | 1982251 | Viruses | Viruses | 503 | 6.049999999999998e-138 | NTclustered | gi|1338076784|gb|MG820643.1| | 2079407 | g1949 | i0 | 98.592 | 99.4280701754386 | 284 | 4 | 99 | 0 | 2 | 285 | 22194 | 22477 | Propionibacterium phage pa35, complete genome | blastn | 28337 | 503 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Propionibacterium phage pa35 | ||||
| 12299806 | 12299806 | PRJNA826497_S_NODE_12950_length_173_cov_3.707143_g12910_i0 | PRJNA826497 | 12950 | 173 | 3.707143 | 6.41335739 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 309 | 7.81e-80 | NTclustered | gi|2052248227|tpg|BK019545.1| | 2832643 | g12910 | i0 | 98.844 | 15.8843930635838 | 173 | 2 | 100 | 0 | 1 | 173 | 31411 | 31239 | MAG TPA_asm: Caudoviricetes sp. isolate ctCNH6, partial genome | blastn | 2748 | 309 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13574222 | 13574222 | PRJNA826497_S_NODE_891_length_347_cov_4.652866_g851_i0 | PRJNA826497 | 891 | 347 | 4.652866 | 16.14544502 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 196 | 1.43e-45 | NTclustered | gi|2053209107|tpg|BK017118.1| | 2832643 | g851 | i0 | 94.488 | 12.3342939481268 | 127 | 7 | 37 | 0 | 1 | 127 | 40561 | 40435 | MAG TPA_asm: Caudoviricetes sp. isolate ctmoW44, partial genome | blastn | 4280 | 196 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14848680 | 14848680 | PRJNA826497_S_NODE_14232_length_168_cov_2.437037_g14192_i0 | PRJNA826497 | 14232 | 168 | 2.437037 | 4.09422216 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 211 | 2.2e-50 | NTclustered | gi|2059607749|tpg|BK037240.1| | 2832643 | g14192 | i0 | 99.145 | 7.83928571428571 | 117 | 1 | 100 | 0 | 52 | 168 | 4111 | 4227 | MAG TPA_asm: Caudoviricetes sp. isolate ct7Ik1, partial genome | blastn | 1317 | 211 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 14848692 | 14848692 | PRJNA826497_S_NODE_15952_length_162_cov_2.503876_g15912_i0 | PRJNA826497 | 15952 | 162 | 2.503876 | 4.05627912 | Maltschvirus maltsch | 2956182 | Viruses | Viruses | 274 | 2.64e-69 | NTclustered | gi|1220004233|gb|MF417980.1| | 2100421 | g15912 | i0 | 97.5 | 16.1234567901235 | 160 | 4 | 99 | 0 | 1 | 160 | 1166 | 1007 | Uncultured Caudovirales phage clone 10F_4, partial genome | blastn | 2612 | 274 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Peduoviridae | Maltschvirus | Maltschvirus maltsch | |||
| 17805778 | 17805778 | PRJNA826497_S_NODE_694_length_368_cov_19627.310448_g654_i0 | PRJNA826497 | 694 | 368 | 19627.310448 | 72228.50244864 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 320 | 8.68e-83 | NTclustered | gi|31505997|gb|AY294658.1| | 232197 | g654 | i0 | 98.361 | 49.7472826086956 | 183 | 2 | 49 | 1 | 125 | 306 | 1378 | 1560 | Influenza A virus (A/Sw/ShanDong/1/2003(H9N2)) hemagglutinin (HA) mRNA, complete cds | blastn | 18307 | 320 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 18671972 | 18671972 | PRJNA826497_S_NODE_6755_length_209_cov_13.170455_g6715_i0 | PRJNA826497 | 6755 | 209 | 13.170455 | 27.52625095 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 387 | 4.42e-103 | NTclustered | gi|2056817596|tpg|BK057631.1| | 2832643 | g6715 | i0 | 100 | 7 | 209 | 0 | 100 | 0 | 1 | 209 | 22014 | 22222 | MAG TPA_asm: Caudoviricetes sp. isolate ctNWy2, partial genome | blastn | 1463 | 387 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19947225 | 19947225 | PRJNA826497_S_NODE_6336_length_213_cov_4.661111_g6296_i0 | PRJNA826497 | 6336 | 213 | 4.661111 | 9.92816643 | Siphoviridae sp. ctmHK1 | 2826452 | Viruses | Viruses | 392 | 9.72e-105 | NTclustered | gi|2051094504|tpg|BK014909.1| | 2826452 | g6296 | i0 | 100 | 10.8826291079812 | 212 | 0 | 99 | 0 | 1 | 212 | 10607 | 10818 | MAG TPA_asm: Siphoviridae sp. ctmHK1, partial genome | blastn | 2318 | 392 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Siphoviridae sp. ctmHK1 | |||||
| 20354593 | 20354593 | PRJNA826497_S_NODE_5756_length_218_cov_47.545946_g5716_i0 | PRJNA826497 | 5756 | 218 | 47.545946 | 103.65016228 | Mastadenovirus | 10509 | Viruses | Viruses | 283 | 6.28e-72 | NTclustered | gi|2566084967|gb|OR361563.1| | 28280 | g5716 | i0 | 100 | 100 | 153 | 0 | 95 | 0 | 61 | 213 | 34189 | 34341 | Human adenovirus E4 isolate HAdV-E4/USA/6C9/2010, complete genome | blastn | 21800 | 283 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus exoticum | ||
| 21222695 | 21222695 | PRJNA826497_S_NODE_517_length_399_cov_6.193989_g477_i0 | PRJNA826497 | 517 | 399 | 6.193989 | 24.71401611 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 691 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g477 | i0 | 97.99 | 0.99749373433584 | 398 | 8 | 99 | 0 | 1 | 398 | 2243 | 2640 | Malassezia restricta virus MrV40L, complete genome | blastn | 398 | 691 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 23773099 | 23773099 | PRJNA826497_S_NODE_8019_length_199_cov_10.807229_g7979_i0 | PRJNA826497 | 8019 | 199 | 10.807229 | 21.50638571 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 339 | 1.18e-88 | NTclustered | gi|2915038774|gb|OR222713.1| | 2832643 | g7979 | i0 | 97.475 | 11.2060301507538 | 198 | 5 | 99 | 0 | 2 | 199 | 51421 | 51618 | MAG: Caudoviricetes sp. isolate MSP0650 genomic sequence | blastn | 2230 | 339 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 25454828 | 25454828 | PRJNA826497_S_NODE_3100_length_256_cov_8.107623_g3060_i0 | PRJNA826497 | 3100 | 256 | 8.107623 | 20.75551488 | Pahexavirus | 1982251 | Viruses | Viruses | 457 | 4.22e-124 | NTclustered | gi|670145376|gb|KJ578768.1| | 1500808 | g3060 | i0 | 98.828 | 100.09765625 | 256 | 3 | 100 | 0 | 1 | 256 | 13092 | 12837 | Propionibacterium phage PHL082M00, complete genome | blastn | 25625 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Pahexavirus | Pahexavirus PHL082M03 |
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);;