contig_metadata
23 rows where bioproject = "PRJNA764222" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1205783 | 1205783 | PRJNA764222_S_NODE_6981_length_287_cov_7.887500_g6823_i0 | PRJNA764222 | 6981 | 287 | 7.8875 | 22.637125 | Copiparvovirus | 1511888 | Viruses | Viruses | 520 | 6.049999999999999e-143 | NTclustered | gi|1725344901|ref|NC_031959.2| | 1917013 | g6823 | i0 | 99.303 | 4.56445993031359 | 287 | 2 | 100 | 0 | 1 | 287 | 5306 | 5020 | Bosavirus MS-2016a, complete genome | blastn | 1310 | 520 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Copiparvovirus | Copiparvovirus ungulate5 | ||
| 2020708 | 2020708 | PRJNA764222_S_NODE_2342_length_387_cov_5.723529_g2184_i0 | PRJNA764222 | 2342 | 387 | 5.723529 | 22.15005723 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 682 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g2184 | i0 | 98.45 | 3 | 387 | 6 | 100 | 0 | 1 | 387 | 5715 | 6101 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1161 | 682 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 2020869 | 2020869 | PRJNA764222_S_NODE_642_length_789_cov_115.111860_g525_i0 | PRJNA764222 | 642 | 789 | 115.11186 | 908.2325754 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1380 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g525 | i0 | 98.228 | 3.51584283903676 | 790 | 12 | 100 | 2 | 1 | 789 | 7449 | 8237 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 2774 | 1380 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 4573178 | 4573178 | PRJNA764222_S_NODE_684_length_755_cov_11.381356_g562_i0 | PRJNA764222 | 684 | 755 | 11.381356 | 85.9292378 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1297 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g562 | i0 | 97.742 | 2.99205298013245 | 753 | 17 | 99 | 0 | 1 | 753 | 5046 | 4294 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 2259 | 1297 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 7123302 | 7123302 | PRJNA764222_S_NODE_14146_length_238_cov_1.078534_g13988_i0 | PRJNA764222 | 14146 | 238 | 1.078534 | 2.56691092 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g13988 | i0 | 100 | 0.592436974789916 | 29 | 0 | 12 | 0 | 210 | 238 | 41 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8398084 | 8398084 | PRJNA764222_S_NODE_7987_length_278_cov_3.142857_g7829_i0 | PRJNA764222 | 7987 | 278 | 3.142857 | 8.73714246 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 486 | 5.919999999999998e-133 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g7829 | i0 | 98.201 | 2.99640287769784 | 278 | 5 | 100 | 0 | 1 | 278 | 6158 | 6435 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 833 | 486 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13498579 | 13498579 | PRJNA764222_S_NODE_51_length_3420_cov_29.450341_g42_i0 | PRJNA764222 | 51 | 3420 | 29.450341 | 1007.2016622 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 5541 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g42 | i0 | 95.912 | 3.00438596491228 | 3425 | 131 | 100 | 7 | 1 | 3420 | 96 | 3516 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 10275 | 5541 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14773744 | 14773744 | PRJNA764222_S_NODE_52_length_3420_cov_27.912541_g42_i1 | PRJNA764222 | 52 | 3420 | 27.912541 | 954.6089022 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 5546 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g42 | i1 | 95.942 | 3.00438596491228 | 3425 | 130 | 100 | 8 | 1 | 3420 | 3503 | 83 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 10275 | 5546 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 17323079 | 17323079 | PRJNA764222_S_NODE_28654_length_174_cov_1.622047_g28496_i0 | PRJNA764222 | 28654 | 174 | 1.622047 | 2.82236178 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 230 | 6.299999999999999e-56 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g28496 | i0 | 94.04 | 0.867816091954023 | 151 | 9 | 87 | 0 | 21 | 171 | 1442 | 1592 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 151 | 230 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 17323208 | 17323208 | PRJNA764222_S_NODE_9014_length_270_cov_1.650224_g8856_i0 | PRJNA764222 | 9014 | 270 | 1.650224 | 4.4556048 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 416 | 7.619999999999998e-112 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g8856 | i0 | 94.444 | 1 | 270 | 15 | 100 | 0 | 1 | 270 | 2417 | 2148 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 270 | 416 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 18596583 | 18596583 | PRJNA764222_S_NODE_9175_length_269_cov_1.193694_g9017_i0 | PRJNA764222 | 9175 | 269 | 1.193694 | 3.21103686 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.025 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g9017 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 0 | 1 | 28 | 14 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 19871332 | 19871332 | PRJNA764222_S_NODE_1236_length_527_cov_61.160417_g1084_i0 | PRJNA764222 | 1236 | 527 | 61.160417 | 322.31539759 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 723 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1084 | i0 | 91.412 | 0.994307400379507 | 524 | 45 | 99 | 0 | 1 | 524 | 6586 | 7109 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 524 | 723 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21147416 | 21147416 | PRJNA764222_S_NODE_757_length_709_cov_7.564955_g629_i0 | PRJNA764222 | 757 | 709 | 7.564955 | 53.63553095 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1205 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g629 | i0 | 97.32 | 3 | 709 | 19 | 100 | 0 | 1 | 709 | 3505 | 4213 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 2127 | 1205 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22421933 | 22421933 | PRJNA764222_S_NODE_20718_length_206_cov_1.660377_g20560_i0 | PRJNA764222 | 20718 | 206 | 1.660377 | 3.42037662 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 381 | 2.0199999999999994e-101 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g20560 | i0 | 100 | 8.97087378640777 | 206 | 0 | 100 | 0 | 1 | 206 | 3319 | 3524 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 1848 | 381 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 23697545 | 23697545 | PRJNA764222_S_NODE_16739_length_224_cov_2.909605_g16581_i0 | PRJNA764222 | 16739 | 224 | 2.909605 | 6.5175152 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.02 | NTclustered | gi|2058103431|tpg|BK033609.1| | 2832643 | g16581 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 193 | 220 | 40394 | 40367 | MAG TPA_asm: Caudoviricetes sp. isolate ctq0U24, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24971169 | 24971169 | PRJNA764222_S_NODE_13500_length_241_cov_2.427835_g13342_i0 | PRJNA764222 | 13500 | 241 | 2.427835 | 5.85108235 | Erythroparvovirus ungulate1 | 3052194 | Viruses | Viruses | 440 | 3.959999999999999e-119 | NTclustered | gi|2500352099|ref|NC_074970.1| | 172297 | g13342 | i0 | 99.585 | 9.00829875518672 | 241 | 1 | 100 | 0 | 1 | 241 | 1963 | 2203 | Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds | blastn | 2171 | 440 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Erythroparvovirus | Erythroparvovirus ungulate1 | ||
| 26704812 | 26704812 | PRJNA764222_S_NODE_18321_length_217_cov_2.029412_g18163_i0 | PRJNA764222 | 18321 | 217 | 2.029412 | 4.40382404 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 87.8 | 3.68e-18 | NR | AVM87439.1 | 3063761 | g18163 | i0 | 56.9 | 0.995391705069124 | 72 | 31 | 99.5 | 0 | 217 | 2 | 949 | 1020 | AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] | diamond | 216 | 87.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Danio blood picornavirus/Zebrafish picornavirus 2 | ||||
| 28221624 | 28221624 | PRJNA764222_S_NODE_20006_length_209_cov_2.209877_g19848_i0 | PRJNA764222 | 20006 | 209 | 2.209877 | 4.61864293 | Bacillus phage AR9 | 1815509 | Viruses | Viruses | 72.4 | 8.24e-13 | NR | YP_009283036.1 | 1815509 | g19848 | i0 | 58.5 | 0.933014354066986 | 65 | 26 | 93.3 | 1 | 13 | 207 | 112 | 175 | YP_009283036.1 DNA polymerase [Bacillus phage AR9] | diamond | 195 | 72.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Takahashivirus | Takahashivirus PBS1 | ||||
| 29042902 | 29042902 | PRJNA764222_S_NODE_28228_length_176_cov_1.178295_g28070_i0 | PRJNA764222 | 28228 | 176 | 1.178295 | 2.0737992 | Vibrio phage pVa-21 | 1958921 | Viruses | Viruses | 65.9 | 1.05e-10 | NR | AQT28126.1 | 1958921 | g28070 | i0 | 90.9 | 0.5625 | 33 | 3 | 56.3 | 0 | 67 | 165 | 101 | 133 | AQT28126.1 putative terminase large subunit [Vibrio phage pVa-21] | diamond | 99 | 65.9 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage pVa-21 | |||||
| 29620191 | 29620191 | PRJNA764222_S_NODE_29510_length_171_cov_1.661290_g29352_i0 | PRJNA764222 | 29510 | 171 | 1.66129 | 2.8408059 | root | 1 | Root_unresolved | Root_unresolved | 80.9 | 9.33e-18 | NR | DAL45530.1 | 2832643 | g29352 | i0 | 64.3 | 1.96491228070175 | 56 | 20 | 98.2 | 0 | 169 | 2 | 39 | 94 | DAL45530.1 MAG TPA_asm: hypothetical protein [Caudoviricetes sp.] | diamond | 336 | 81.3 | 0.995079950799508 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 30116282 | 30116282 | PRJNA764222_S_NODE_31472_length_165_cov_1.211864_g31314_i0 | PRJNA764222 | 31472 | 165 | 1.211864 | 1.9995756 | Faustovirus | 1477405 | Viruses | Viruses | 44.3 | 0.00327 | NR | QJX72331.1 | 1477405 | g31314 | i0 | 40 | 2.45454545454545 | 45 | 27 | 81.8 | 0 | 143 | 9 | 11 | 55 | QJX72331.1 ubiquitin-conjugating enzyme E2 [Faustovirus] | diamond | 405 | 44.3 | 1 | Viruses | Faustovirus | ||||||||
| 31064500 | 31064500 | PRJNA764222_S_NODE_16735_length_224_cov_3.016949_g16577_i0 | PRJNA764222 | 16735 | 224 | 3.016949 | 6.75796576 | Klebsiella phage | 2583037 | Viruses | Viruses | 66.6 | 1.06e-10 | NR | BBK09217.1 | 2583037 | g16577 | i0 | 53.6 | 1.55357142857143 | 56 | 26 | 75 | 0 | 177 | 10 | 166 | 221 | BBK09217.1 ADP-ribosylation [Klebsiella phage 05F01] | diamond | 348 | 66.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Klebsiella phage 05F01 | |||||
| 31358508 | 31358508 | PRJNA764222_S_NODE_8856_length_271_cov_2.316964_g8698_i0 | PRJNA764222 | 8856 | 271 | 2.316964 | 6.27897244 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 1.07e-4 | NR | ARB06284.1 | 1965372 | g8698 | i0 | 70 | 0.863468634686347 | 30 | 9 | 33.2 | 0 | 44 | 133 | 2 | 31 | ARB06284.1 hypothetical protein SppYZU01_47 [Shewanella phage SppYZU01] | diamond | 234 | 47.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Shewanella phage SppYZU01 |
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);;