contig_metadata
27 rows where bioproject = "PRJNA1097627" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 208550 | 208550 | PRJNA1097627_P_NODE_4801_length_509_cov_2.561927_g4514_i0 | PRJNA1097627 | 4801 | 509 | 2.561927 | 13.04020843 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 928 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g4514 | i0 | 99.606 | 0.99803536345776 | 508 | 2 | 99 | 0 | 1 | 508 | 2547 | 2040 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 508 | 928 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 1019666 | 1019666 | PRJNA1097627_P_NODE_145361_length_250_cov_0.870056_g145068_i0 | PRJNA1097627 | 145361 | 250 | 0.870056 | 2.17514 | Orthorubulavirus | 2560195 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|1378763606|gb|MF170889.1| | 2560580 | g145068 | i0 | 100 | 68 | 250 | 0 | 100 | 0 | 1 | 250 | 10498 | 10747 | Mammalian orthorubulavirus 5 strain Rigel, complete genome | blastn | 17000 | 462 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 2761626 | 2761626 | PRJNA1097627_P_NODE_96783_length_276_cov_1.068966_g96490_i0 | PRJNA1097627 | 96783 | 276 | 1.068966 | 2.95034616 | Potyviridae sp. | 2681589 | Viruses | Viruses | 499 | 7.54e-137 | NTclustered | gi|2697177281|gb|OR867843.1| | 2681589 | g96490 | i0 | 100 | 0.978260869565217 | 270 | 0 | 98 | 0 | 7 | 276 | 5557 | 5288 | MAG: Potyviridae sp. isolate JTYGF13_16/3 genomic sequence | blastn | 270 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyviridae sp. | |||
| 5310569 | 5310569 | PRJNA1097627_P_NODE_285_length_2057_cov_4.197581_g183_i0 | PRJNA1097627 | 285 | 2057 | 4.197581 | 86.34424117 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3747 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g183 | i0 | 99.562 | 2.00145843461351 | 2057 | 8 | 100 | 1 | 1 | 2057 | 8695 | 6640 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 4117 | 3747 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 6588642 | 6588642 | PRJNA1097627_P_NODE_886_length_992_cov_2.684440_g660_i0 | PRJNA1097627 | 886 | 992 | 2.68444 | 26.6296448 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 1810 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g660 | i0 | 99.597 | 1 | 992 | 4 | 100 | 0 | 1 | 992 | 2064 | 1073 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 992 | 1810 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 9947917 | 9947917 | PRJNA1097627_P_NODE_156408_length_248_cov_1.320000_g156115_i0 | PRJNA1097627 | 156408 | 248 | 1.32 | 3.2736 | Orthorubulavirus | 2560195 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|1806608684|gb|MN604146.1| | 2560580 | g156115 | i0 | 100 | 82.4596774193548 | 248 | 0 | 100 | 0 | 1 | 248 | 2293 | 2046 | Mammalian orthorubulavirus 5 isolate XJ033, complete genome | blastn | 20450 | 459 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Paramyxoviridae | Orthorubulavirus | Orthorubulavirus mammalis | ||
| 10412914 | 10412914 | PRJNA1097627_P_NODE_67649_length_297_cov_3.218750_g67356_i0 | PRJNA1097627 | 67649 | 297 | 3.21875 | 9.5596875 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 549 | 8.029999999999997e-152 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g67356 | i0 | 100 | 1 | 297 | 0 | 100 | 0 | 1 | 297 | 513 | 809 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 297 | 549 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 11683890 | 11683890 | PRJNA1097627_P_NODE_163970_length_247_cov_0.885057_g163677_i0 | PRJNA1097627 | 163970 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 401 | 1.9199999999999992e-107 | NTclustered | gi|2057906957|tpg|BK051254.1| | 2832643 | g163677 | i0 | 95.951 | 5 | 247 | 10 | 100 | 0 | 1 | 247 | 55695 | 55941 | MAG TPA_asm: Caudoviricetes sp. isolate ctgkm6, partial genome | blastn | 1235 | 401 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11689378 | 11689378 | PRJNA1097627_P_NODE_90_length_4234_cov_5.235520_g7_i1 | PRJNA1097627 | 90 | 4234 | 5.23552 | 221.6719168 | Gammaretrovirus murleu | 3428959 | Viruses | Viruses | 7529 | 0 | NTclustered | gi|1071348744|gb|KX173421.1| | 11786 | g7 | i1 | 98.663 | 99.371280113368 | 4262 | 29 | 100 | 10 | 1 | 4234 | 2545 | 6806 | Murine leukemia virus clone 26, complete sequence | blastn | 420738 | 7529 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 11689600 | 11689600 | PRJNA1097627_P_NODE_95610_length_276_cov_1.753695_g95317_i0 | PRJNA1097627 | 95610 | 276 | 1.753695 | 4.8401982 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 483 | 7.589999999999998e-132 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g95317 | i0 | 98.188 | 1 | 276 | 5 | 100 | 0 | 1 | 276 | 6608 | 6333 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 276 | 483 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 14233202 | 14233202 | PRJNA1097627_P_NODE_148692_length_250_cov_0.870056_g148399_i0 | PRJNA1097627 | 148692 | 250 | 0.870056 | 2.17514 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 462 | 8.83e-126 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g148399 | i0 | 100 | 94.592 | 250 | 0 | 100 | 0 | 1 | 250 | 5851 | 6100 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 23648 | 462 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 14233906 | 14233906 | PRJNA1097627_P_NODE_163332_length_247_cov_0.885057_g163039_i0 | PRJNA1097627 | 163332 | 247 | 0.885057 | 2.18609079 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 457 | 4.05e-124 | NTclustered | gi|2059665777|tpg|BK029014.1| | 2832643 | g163039 | i0 | 100 | 31.9595141700405 | 247 | 0 | 100 | 0 | 1 | 247 | 13046 | 12800 | MAG TPA_asm: Caudoviricetes sp. isolate ctK2j6, partial genome | blastn | 7894 | 457 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15506957 | 15506957 | PRJNA1097627_P_NODE_145253_length_250_cov_0.870056_g144960_i0 | PRJNA1097627 | 145253 | 250 | 0.870056 | 2.17514 | Amaranthus caudatus fabavirus | 3090866 | Viruses | Viruses | 377 | 3.29e-100 | NTclustered | gi|2616762693|gb|OP783967.1| | 3090866 | g144960 | i0 | 93.976 | 2.988 | 249 | 15 | 99 | 0 | 1 | 249 | 4297 | 4545 | Amaranthus caudatus fabavirus isolate BJ-1 segment RNA1, complete sequence | blastn | 747 | 377 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Fabavirus | Amaranthus caudatus fabavirus | ||
| 16785023 | 16785023 | PRJNA1097627_P_NODE_334_length_1881_cov_3.530973_g215_i0 | PRJNA1097627 | 334 | 1881 | 3.530973 | 66.41760213 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3430 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g215 | i0 | 99.575 | 1 | 1881 | 8 | 100 | 0 | 1 | 1881 | 6319 | 4439 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 1881 | 3430 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 18056060 | 18056060 | PRJNA1097627_P_NODE_146575_length_250_cov_0.870056_g146282_i0 | PRJNA1097627 | 146575 | 250 | 0.870056 | 2.17514 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 364 | 2.559999999999999e-96 | NTclustered | gi|2914792039|gb|OR222787.1| | 2832643 | g146282 | i0 | 93.173 | 0.996 | 249 | 15 | 99 | 2 | 1 | 248 | 46201 | 46448 | MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence | blastn | 249 | 364 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18058130 | 18058130 | PRJNA1097627_P_NODE_18975_length_382_cov_1.067961_g18684_i0 | PRJNA1097627 | 18975 | 382 | 1.067961 | 4.07961102 | Gammaretrovirus gibleu | 3428953 | Viruses | Viruses | 699 | 0 | NTclustered | gi|971888245|gb|KT724047.1| | 11840 | g18684 | i0 | 99.738 | 27.2879581151832 | 382 | 0 | 100 | 1 | 1 | 382 | 7981 | 7601 | Gibbon ape leukemia virus strain San Francisco, complete genome | blastn | 10424 | 699 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus gibleu | ||
| 19331288 | 19331288 | PRJNA1097627_P_NODE_171136_length_246_cov_0.890173_g170843_i0 | PRJNA1097627 | 171136 | 246 | 0.890173 | 2.18982558 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 73.1 | 1.71e-8 | NTclustered | gi|2914933639|gb|OR221620.1| | 2832643 | g170843 | i0 | 97.619 | 0.33739837398374 | 42 | 1 | 34 | 0 | 1 | 42 | 1951 | 1910 | MAG: Caudoviricetes sp. isolate MSP1439 genomic sequence | blastn | 83 | 73.1 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19332822 | 19332822 | PRJNA1097627_P_NODE_202876_length_241_cov_0.916667_g202583_i0 | PRJNA1097627 | 202876 | 241 | 0.916667 | 2.20916747 | Potyvirus sp. | 1955171 | Viruses | Viruses | 318 | 1.94e-82 | NTclustered | gi|2697177299|gb|OR867852.1| | 1955171 | g202583 | i0 | 100 | 24.9045643153527 | 172 | 0 | 71 | 0 | 64 | 235 | 1 | 172 | MAG: Potyvirus sp. isolate JTYGF13_16/282 genomic sequence | blastn | 6002 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sp. | ||
| 20603569 | 20603569 | PRJNA1097627_P_NODE_107257_length_269_cov_1.336735_g106964_i0 | PRJNA1097627 | 107257 | 269 | 1.336735 | 3.59581715 | Tetraparvovirus ungulate1 | 3052771 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|2277478573|gb|MZ502236.1| | 1096141 | g106964 | i0 | 99.628 | 16.907063197026 | 269 | 1 | 100 | 0 | 1 | 269 | 569 | 301 | Bovine hokovirus 2 isolate BCS1/USA nonstructural protein, minor structural protein, and major structural protein genes, complete cds | blastn | 4548 | 492 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Tetraparvovirus | Tetraparvovirus ungulate1 | ||
| 21884745 | 21884745 | PRJNA1097627_P_NODE_338_length_1862_cov_3.001118_g217_i0 | PRJNA1097627 | 338 | 1862 | 3.001118 | 55.88081716 | Harmonia axyridis virus 1 | 2654694 | Viruses | Viruses | 3422 | 0 | NTclustered | gi|1767893575|gb|MK729664.1| | 2654694 | g217 | i0 | 99.839 | 1.0187969924812 | 1862 | 3 | 100 | 0 | 1 | 1862 | 4376 | 2515 | Harmonia axyridis virus 1 strain SDAU1 ORF1 and ORF2 genes, complete cds | blastn | 1897 | 3422 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Harmonia axyridis virus 1 | ||||
| 22696653 | 22696653 | PRJNA1097627_P_NODE_10958_length_425_cov_1.156250_g10669_i0 | PRJNA1097627 | 10958 | 425 | 1.15625 | 4.9140625 | Betapolyomavirus | 1891714 | Viruses | Viruses | 774 | 0 | NTclustered | gi|13345942|gb|AF332562.1| | 1891767 | g10669 | i0 | 99.529 | 106 | 425 | 2 | 100 | 0 | 1 | 425 | 3717 | 3293 | Simian virus 40 strain 777, complete genome | blastn | 45050 | 780 | 0.992307692307692 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Sepolyvirales | Polyomaviridae | Betapolyomavirus | Betapolyomavirus macacae | ||
| 22696678 | 22696678 | PRJNA1097627_P_NODE_149258_length_249_cov_2.482955_g148965_i0 | PRJNA1097627 | 149258 | 249 | 2.482955 | 6.18255795 | root | 1 | Root_unresolved | Root_unresolved | 460 | 3.16e-125 | NTclustered | gi|332105|gb|L01464.1|MMTGAGPRO | 11757 | g148965 | i0 | 100 | 26.5261044176707 | 249 | 0 | 100 | 0 | 1 | 249 | 391 | 143 | Mouse mammary tumor virus protease (pro) gene, 3' end | blastn | 6605 | 460 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 23157590 | 23157590 | PRJNA1097627_P_NODE_167199_length_247_cov_0.867816_g166906_i0 | PRJNA1097627 | 167199 | 247 | 0.867816 | 2.14350552 | Potyvirus sp. | 1955171 | Viruses | Viruses | 431 | 2.45e-116 | NTclustered | gi|2697177301|gb|OR867853.1| | 1955171 | g166906 | i0 | 100 | 1.88259109311741 | 233 | 0 | 94 | 0 | 9 | 241 | 760 | 528 | MAG: Potyvirus sp. isolate JTYGF13_16/55 genomic sequence | blastn | 465 | 431 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Potyviridae | Potyvirus | Potyvirus sp. | ||
| 27762886 | 27762886 | PRJNA1097627_P_NODE_165764_length_247_cov_0.885057_g165471_i0 | PRJNA1097627 | 165764 | 247 | 0.885057 | 2.18609079 | Guiyang chuvirus 1 | 2905498 | Viruses | Viruses | 46.2 | 0.00232 | NR | UHK03045.1 | 2905498 | g165471 | i0 | 64.7 | 0.412955465587045 | 34 | 12 | 41.3 | 0 | 3 | 104 | 177 | 210 | UHK03045.1 MAG: hypothetical protein GuCV1_gp2 [Guiyang chuvirus 1] | diamond | 102 | 46.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Guiyang chuvirus 1 | ||
| 30130486 | 30130486 | PRJNA1097627_P_NODE_188132_length_243_cov_0.905882_g187839_i0 | PRJNA1097627 | 188132 | 243 | 0.905882 | 2.20129326 | Comovirinae sp. | 2767531 | Viruses | Viruses | 137 | 2.5799999999999996e-35 | NR | QNN26327.1 | 2767531 | g187839 | i0 | 92.5 | 0.987654320987654 | 80 | 6 | 98.8 | 0 | 242 | 3 | 23 | 102 | QNN26327.1 polyprotein 2 [Comovirinae sp.] | diamond | 240 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae sp. | |||
| 30162196 | 30162196 | PRJNA1097627_P_NODE_159632_length_248_cov_0.880000_g159339_i0 | PRJNA1097627 | 159632 | 248 | 0.88 | 2.1824 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 40.4 | 0.0464 | NR | DAY40205.1 | 2832643 | g159339 | i0 | 39.6 | 0.580645161290323 | 48 | 29 | 58.1 | 0 | 75 | 218 | 3 | 50 | DAY40205.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] | diamond | 144 | 40.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32122607 | 32122607 | PRJNA1097627_P_NODE_47598_length_320_cov_1.097166_g47306_i0 | PRJNA1097627 | 47598 | 320 | 1.097166 | 3.5109312 | Comovirinae sp. | 2767531 | Viruses | Viruses | 200 | 2.15e-57 | NR | QNN26327.1 | 2767531 | g47306 | i0 | 95.3 | 0.99375 | 106 | 5 | 99.4 | 0 | 318 | 1 | 101 | 206 | QNN26327.1 polyprotein 2 [Comovirinae sp.] | diamond | 318 | 200 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Comovirinae 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);;