contig_metadata
12 rows where bioproject = "PRJNA560029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1819536 | 1819536 | PRJNA560029_S_NODE_2082_length_585_cov_12.806641_g1864_i0 | PRJNA560029 | 2082 | 585 | 12.806641 | 74.91884985 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.016 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g1864 | i0 | 100 | 0.0495726495726496 | 29 | 0 | 5 | 0 | 557 | 585 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 6922166 | 6922166 | PRJNA560029_S_NODE_36286_length_234_cov_18.422360_g36062_i0 | PRJNA560029 | 36286 | 234 | 18.42236 | 43.1083224 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 60.2 | 1.25e-4 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g36062 | i0 | 100 | 0.615384615384615 | 32 | 0 | 14 | 0 | 1 | 32 | 13 | 44 | Carnation latent virus isolate KL, complete genome | blastn | 144 | 60.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 6922168 | 6922168 | PRJNA560029_S_NODE_3646_length_478_cov_5.108642_g3423_i0 | PRJNA560029 | 3646 | 478 | 5.108642 | 24.41930876 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 817 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g3423 | i0 | 97.495 | 4.01464435146443 | 479 | 11 | 100 | 1 | 1 | 478 | 7762 | 8240 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1919 | 817 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12023053 | 12023053 | PRJNA560029_S_NODE_25930_length_275_cov_2.826733_g25706_i0 | PRJNA560029 | 25930 | 275 | 2.826733 | 7.77351575 | uncultured phage | 278008 | Viruses | Viruses | 459 | 1.27e-124 | NTclustered | gi|2575859744|emb|OY731452.1| | 278008 | g25706 | i0 | 96.727 | 14.0909090909091 | 275 | 9 | 100 | 0 | 1 | 275 | 8760 | 9034 | uncultured phage genome assembly, chromosome: 1 | blastn | 3875 | 459 | 1 | Viruses | uncultured phage | ||||||||
| 17708392 | 17708392 | PRJNA560029_S_NODE_3294_length_495_cov_2.426540_g3072_i0 | PRJNA560029 | 3294 | 495 | 2.42654 | 12.011373 | Botourmiaviridae | 2560063 | Viruses | Viruses | 82.4 | 6.16e-11 | NTclustered | gi|2500381378|ref|NC_076801.1| | 2686545 | g3072 | i0 | 100 | 2.55757575757576 | 44 | 0 | 9 | 0 | 409 | 452 | 2288 | 2331 | Plasmopara viticola lesion associated ourmia-like virus 72 isolate DMG-F_43929 RNA dependent RNA polymerase (QKR77_gp1) gene, complete cds | blastn | 1266 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Scleroulivirus lambdaplasmoparae | ||
| 19670750 | 19670750 | PRJNA560029_S_NODE_7396_length_395_cov_4.381988_g7172_i0 | PRJNA560029 | 7396 | 395 | 4.381988 | 17.3088526 | Polycipiviridae sp. | 2496155 | Viruses | Viruses | 52.8 | 0.038 | NTclustered | gi|2756421824|gb|PP744841.1| | 2496155 | g7172 | i0 | 90.244 | 0.10379746835443 | 41 | 3 | 10 | 1 | 343 | 382 | 9211 | 9171 | MAG: Polycipiviridae sp. isolate 086_167342 genomic sequence | blastn | 41 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Polycipiviridae | Polycipiviridae sp. | |||
| 22221168 | 22221168 | PRJNA560029_S_NODE_3058_length_507_cov_90.850230_g2836_i0 | PRJNA560029 | 3058 | 507 | 90.85023 | 460.6106661 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g2836 | i0 | 100 | 0.112426035502959 | 29 | 0 | 6 | 0 | 479 | 507 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 23496307 | 23496307 | PRJNA560029_S_NODE_22739_length_290_cov_1.064516_g22515_i0 | PRJNA560029 | 22739 | 290 | 1.064516 | 3.0870964 | Bacteriophage sp. | 38018 | Viruses | Viruses | 531 | 2.83e-146 | NTclustered | gi|2295199330|gb|OP074424.1| | 38018 | g22515 | i0 | 99.655 | 28.9344827586207 | 290 | 1 | 100 | 0 | 1 | 290 | 30888 | 31177 | MAG: Bacteriophage sp. isolate 2226_130423, complete genome | blastn | 8391 | 531 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 23496654 | 23496654 | PRJNA560029_S_NODE_7479_length_394_cov_3.897196_g7255_i0 | PRJNA560029 | 7479 | 394 | 3.897196 | 15.35495224 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 536 | 8.539999999999998e-148 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g7255 | i0 | 91.304 | 0.99238578680203 | 391 | 33 | 99 | 1 | 1 | 390 | 6719 | 7109 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 391 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 28278904 | 28278904 | PRJNA560029_S_NODE_26006_length_275_cov_1.648515_g25782_i0 | PRJNA560029 | 26006 | 275 | 1.648515 | 4.53341625 | Sopatryd virus | 3131622 | Viruses | Viruses | 44.7 | 0.011 | NR | WZH61674.1 | 3131622 | g25782 | i0 | 34.1 | 0.894545454545455 | 82 | 39 | 73.1 | 2 | 211 | 11 | 1 | 82 | WZH61674.1 MAG: maturation protein [Sopatryd virus] | diamond | 246 | 44.7 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopatryd virus | |||||
| 30615991 | 30615991 | PRJNA560029_S_NODE_22593_length_290_cov_3.852535_g22369_i0 | PRJNA560029 | 22593 | 290 | 3.852535 | 11.1723515 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 61.6 | 1.1e-8 | NR | XOR77704.1 | 2832643 | g22369 | i0 | 43.5 | 0.713793103448276 | 69 | 38 | 71.4 | 1 | 287 | 81 | 7 | 74 | XOR77704.1 MAG: hypothetical protein [Caudoviricetes sp.] | diamond | 207 | 61.6 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 32292359 | 32292359 | PRJNA560029_S_NODE_5619_length_422_cov_9.819484_g5395_i0 | PRJNA560029 | 5619 | 422 | 9.819484 | 41.43822248 | ssRNA phage SRR696 | 3429138 | Viruses | Viruses | 129 | 9.48e-33 | NR | YP_010769112.1 | 2786515 | g5395 | i0 | 51.1 | 2.00473933649289 | 141 | 63 | 97.4 | 2 | 1 | 411 | 257 | 395 | YP_010769112.1 maturation protein [ssRNA phage SRR6960507_5] | diamond | 846 | 129 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Haeldovirus | Haeldovirus asiohabitans |
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);;