contig_metadata
13 rows where bioproject = "PRJNA1004255" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153281 | 153281 | PRJNA1004255_S_NODE_401_length_642_cov_14.053422_g225_i0 | PRJNA1004255 | 401 | 642 | 14.053422 | 90.22296924 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.018 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g225 | i0 | 100 | 0.0451713395638629 | 29 | 0 | 5 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 153311 | 153311 | PRJNA1004255_S_NODE_9241_length_208_cov_1.709091_g9033_i0 | PRJNA1004255 | 9241 | 208 | 1.709091 | 3.55490928 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g9033 | i0 | 100 | 0.677884615384615 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 141 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 5256204 | 5256204 | PRJNA1004255_S_NODE_8725_length_213_cov_2.211765_g8517_i0 | PRJNA1004255 | 8725 | 213 | 2.211765 | 4.71105945 | Erysiphe necator associated deltaflexivirus 4 | 2743097 | Viruses | Viruses | 394 | 2.7e-105 | NTclustered | gi|2288523299|gb|ON811606.1| | 2743097 | g8517 | i0 | 100 | 4.92488262910798 | 213 | 0 | 100 | 0 | 1 | 213 | 7030 | 6818 | MAG: Erysiphe necator associated deltaflexivirus 4 isolate TIGMIC_2, complete genome | blastn | 1049 | 394 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Erysiphe necator associated deltaflexivirus 4 | ||
| 14181941 | 14181941 | PRJNA1004255_S_NODE_2472_length_333_cov_4.558621_g2264_i0 | PRJNA1004255 | 2472 | 333 | 4.558621 | 15.18020793 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 544 | 4.25e-150 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g2264 | i0 | 96.096 | 280.111111111111 | 333 | 13 | 100 | 0 | 1 | 333 | 17851 | 18183 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 93277 | 544 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 15455906 | 15455906 | PRJNA1004255_S_NODE_3873_length_287_cov_1.155738_g3665_i0 | PRJNA1004255 | 3873 | 287 | 1.155738 | 3.31696806 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 359 | 1.4e-94 | NTclustered | gi|2914813421|gb|OR221882.1| | 2832643 | g3665 | i0 | 89.437 | 4.94076655052265 | 284 | 30 | 99 | 0 | 4 | 287 | 31110 | 30827 | MAG: Caudoviricetes sp. isolate MSP1122 genomic sequence | blastn | 1418 | 359 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 19278849 | 19278849 | PRJNA1004255_S_NODE_6856_length_234_cov_2.345550_g6648_i0 | PRJNA1004255 | 6856 | 234 | 2.34555 | 5.488587 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g6648 | i0 | 100 | 0.243589743589744 | 29 | 0 | 12 | 0 | 206 | 234 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 23105538 | 23105538 | PRJNA1004255_S_NODE_9379_length_206_cov_10.000000_g9171_i0 | PRJNA1004255 | 9379 | 206 | 10 | 20.6 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g9171 | i0 | 100 | 0.276699029126214 | 29 | 0 | 14 | 0 | 178 | 206 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 24379261 | 24379261 | PRJNA1004255_S_NODE_2300_length_340_cov_6.939394_g2092_i0 | PRJNA1004255 | 2300 | 340 | 6.939394 | 23.5939396 | Betaentomopoxvirus amoorei | 28321 | Viruses | Viruses | 52.8 | 0.032 | NTclustered | gi|9964314|ref|NC_002520.1| | 28321 | g2092 | i0 | 94.286 | 0.102941176470588 | 35 | 1 | 10 | 1 | 204 | 237 | 153509 | 153475 | Amsacta moorei entomopoxvirus 'L', complete genome | blastn | 35 | 52.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Betaentomopoxvirus | Betaentomopoxvirus amoorei | ||
| 27382238 | 27382238 | PRJNA1004255_S_NODE_8563_length_215_cov_1.366279_g8355_i0 | PRJNA1004255 | 8563 | 215 | 1.366279 | 2.93749985 | Vibrio phage vB_VhaM_VH-8 | 2660693 | Viruses | Viruses | 129 | 1.25e-33 | NR | QGH73847.1 | 2660693 | g8355 | i0 | 88.6 | 0.976744186046512 | 70 | 8 | 97.7 | 0 | 1 | 210 | 16 | 85 | QGH73847.1 large subunit terminase [Vibrio phage vB_VhaM_VH-8] | diamond | 210 | 129 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Vibrio phage vB_VhaM_VH-8 | |||||
| 30350940 | 30350940 | PRJNA1004255_S_NODE_52_length_2059_cov_29.102183_g3_i0 | PRJNA1004255 | 52 | 2059 | 29.102183 | 599.21394797 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 1294 | 0 | NR | NP_057933.2 | 11801 | g3 | i0 | 97.6 | 2.88052452646916 | 659 | 16 | 96 | 0 | 31 | 2007 | 677 | 1335 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 5931 | 1294 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 30571352 | 30571352 | PRJNA1004255_S_NODE_15533_length_165_cov_1.155738_g15325_i0 | PRJNA1004255 | 15533 | 165 | 1.155738 | 1.9069677 | Erythrocytic necrosis virus | 1543320 | Viruses | Viruses | 42 | 0.00467 | NR | QCF47508.1 | 1543320 | g15325 | i0 | 64.7 | 1.23636363636364 | 34 | 12 | 61.8 | 0 | 105 | 4 | 16 | 49 | QCF47508.1 putative RNA-dependent DNA polymerase [Erythrocytic necrosis virus] | diamond | 204 | 42 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Iridoviridae | Erythrocytic necrosis virus | |||
| 31298327 | 31298327 | PRJNA1004255_S_NODE_11055_length_192_cov_4.986577_g10847_i0 | PRJNA1004255 | 11055 | 192 | 4.986577 | 9.57422784 | Erysiphe necator associated ourmia-like virus 111 | 2741771 | Viruses | Viruses | 131 | 1.01e-33 | NR | QKI79940.1 | 2741771 | g10847 | i0 | 92.2 | 1 | 64 | 5 | 100 | 0 | 192 | 1 | 153 | 216 | QKI79940.1 RNA-dependent RNA polymerase [Erysiphe necator associated ourmia-like virus 111] | diamond | 192 | 131 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 111 | ||
| 31891888 | 31891888 | PRJNA1004255_S_NODE_14177_length_172_cov_3.643411_g13969_i0 | PRJNA1004255 | 14177 | 172 | 3.643411 | 6.26666692 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.0194 | NR | DAP24817.1 | 38018 | g13969 | i0 | 48 | 2.68604651162791 | 50 | 24 | 83.7 | 1 | 27 | 170 | 980 | 1029 | DAP24817.1 MAG TPA: Tail needle protein [Bacteriophage sp.] | diamond | 462 | 42.7 | 0.992974238875878 | Viruses | Bacteriophage 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);;