contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA929924" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909068 | 909068 | PRJNA929924_P_NODE_9121_length_274_cov_2.311111_g8958_i0 | PRJNA929924 | 9121 | 274 | 2.311111 | 6.33244414 | Mitovirus sp. | 2587224 | Viruses | Viruses | 148 | 3.1199999999999997e-31 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g8958 | i0 | 93.878 | 3.37591240875912 | 98 | 6 | 36 | 0 | 177 | 274 | 112 | 15 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 925 | 148 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 1254188 | 1254188 | PRJNA929924_P_NODE_17681_length_163_cov_0.912281_g17518_i0 | PRJNA929924 | 17681 | 163 | 0.912281 | 1.48701803 | Vapochuvirus | 3044851 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|1882567225|gb|MT153353.1| | 2746342 | g17518 | i0 | 100 | 3 | 163 | 0 | 100 | 0 | 1 | 163 | 874 | 1036 | Hemipteran chu-related virus OKIAV138 segment N cRNA sequence, sequence | blastn | 489 | 302 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Hemipteran chu-related virus OKIAV138 | |||
| 2184214 | 2184214 | PRJNA929924_P_NODE_13842_length_181_cov_1.181818_g13679_i0 | PRJNA929924 | 13842 | 181 | 1.181818 | 2.13909058 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 324 | 2.95e-84 | NTclustered | gi|1940198090|gb|MT757477.1| | 2789443 | g13679 | i0 | 98.895 | 2.9171270718232 | 181 | 2 | 100 | 0 | 1 | 181 | 187 | 367 | Skokie dicistro-like virus strain CHNdf-3 polyprotein gene, partial cds | blastn | 528 | 324 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 2184417 | 2184417 | PRJNA929924_P_NODE_9182_length_272_cov_0.883408_g9019_i0 | PRJNA929924 | 9182 | 272 | 0.883408 | 2.40286976 | Newfield virus | 1654354 | Viruses | Viruses | 425 | 1.28e-114 | NTclustered | gi|1417910537|gb|MH384307.1| | 1654354 | g9019 | i0 | 94.853 | 5.8125 | 272 | 14 | 100 | 0 | 1 | 272 | 1155 | 884 | Newfield virus strain MARplus10845 putative RNA-dependent RNA polymerase and orf2 genes, complete cds | blastn | 1581 | 425 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 4737239 | 4737239 | PRJNA929924_P_NODE_13964_length_179_cov_2.400000_g13801_i0 | PRJNA929924 | 13964 | 179 | 2.4 | 4.296 | Newfield virus | 1654354 | Viruses | Viruses | 326 | 8.09e-85 | NTclustered | gi|1417910521|gb|MH384302.1| | 1654354 | g13801 | i0 | 99.441 | 5.98882681564246 | 179 | 1 | 100 | 0 | 1 | 179 | 2900 | 2722 | Newfield virus strain MARminus3606 putative RNA-dependent RNA polymerase and orf2 genes, complete cds | blastn | 1072 | 326 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 4737378 | 4737378 | PRJNA929924_P_NODE_6444_length_459_cov_1.648780_g6281_i0 | PRJNA929924 | 6444 | 459 | 1.64878 | 7.5679002 | Austropotamobius pallipes associated mitovirus 1 | 2993407 | Viruses | Viruses | 387 | 1.07e-102 | NTclustered | gi|2431564461|tpg|BK062829.1| | 2993407 | g6281 | i0 | 83.532 | 0.912854030501089 | 419 | 63 | 91 | 5 | 2 | 417 | 27 | 442 | TPA_asm: Austropotamobius pallipes associated mitovirus 1 RdRp gene, partial cds | blastn | 419 | 387 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Austropotamobius pallipes associated mitovirus 1 | ||
| 11112555 | 11112555 | PRJNA929924_P_NODE_17869_length_163_cov_0.912281_g17706_i0 | PRJNA929924 | 17869 | 163 | 0.912281 | 1.48701803 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 285 | 1.23e-72 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g17706 | i0 | 98.16 | 1 | 163 | 3 | 100 | 0 | 1 | 163 | 1612 | 1774 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 163 | 285 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 12388218 | 12388218 | PRJNA929924_P_NODE_9770_length_252_cov_1.280788_g9607_i0 | PRJNA929924 | 9770 | 252 | 1.280788 | 3.22758576 | Newfield virus | 1654354 | Viruses | Viruses | 414 | 2.53e-111 | NTclustered | gi|1417910521|gb|MH384302.1| | 1654354 | g9607 | i0 | 96.414 | 4.98015873015873 | 251 | 9 | 99 | 0 | 1 | 251 | 1167 | 1417 | Newfield virus strain MARminus3606 putative RNA-dependent RNA polymerase and orf2 genes, complete cds | blastn | 1255 | 414 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 13662553 | 13662553 | PRJNA929924_P_NODE_18291_length_162_cov_0.920354_g18128_i0 | PRJNA929924 | 18291 | 162 | 0.920354 | 1.49097348 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 158 | 2.78e-34 | NTclustered | gi|2183471323|gb|MZ680098.1| | 2583949 | g18128 | i0 | 84.375 | 0.987654320987654 | 160 | 25 | 99 | 0 | 1 | 160 | 2681 | 2840 | MAG: Narnaviridae sp. isolate 45cR-k141_151619 putative RNA-dependent RNA polymerase gene, partial cds; and hypothetical protein gene, complete cds | blastn | 160 | 158 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 15282064 | 15282064 | PRJNA929924_P_NODE_10912_length_224_cov_1.782857_g10749_i0 | PRJNA929924 | 10912 | 224 | 1.782857 | 3.99359968 | Viruses | 10239 | Viruses | Viruses | 414 | 2.1999999999999996e-111 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g10749 | i0 | 100 | 3.125 | 224 | 0 | 100 | 0 | 1 | 224 | 3333 | 3556 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 700 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 18760449 | 18760449 | PRJNA929924_P_NODE_10415_length_235_cov_1.118280_g10252_i0 | PRJNA929924 | 10415 | 235 | 1.11828 | 2.627958 | Newfield virus | 1654354 | Viruses | Viruses | 407 | 3.9e-109 | NTclustered | gi|1417910521|gb|MH384302.1| | 1654354 | g10252 | i0 | 97.872 | 6 | 235 | 5 | 100 | 0 | 1 | 235 | 2005 | 2239 | Newfield virus strain MARminus3606 putative RNA-dependent RNA polymerase and orf2 genes, complete cds | blastn | 1410 | 407 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 21310954 | 21310954 | PRJNA929924_P_NODE_11317_length_216_cov_1.520958_g11154_i0 | PRJNA929924 | 11317 | 216 | 1.520958 | 3.28526928 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 377 | 2.77e-100 | NTclustered | gi|2054434277|tpg|BK035998.1| | 2832643 | g11154 | i0 | 98.148 | 328.930555555556 | 216 | 4 | 100 | 0 | 1 | 216 | 18074 | 18289 | MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome | blastn | 71049 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21311126 | 21311126 | PRJNA929924_P_NODE_77_length_4615_cov_299.372098_g69_i0 | PRJNA929924 | 77 | 4615 | 299.372098 | 13816.0223227 | Totivirus ni | 3432954 | Viruses | Viruses | 8323 | 0 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g69 | i0 | 99.305 | 3.94842903575298 | 4605 | 29 | 99 | 3 | 13 | 4615 | 4614 | 11 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 18222 | 8323 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni | ||
| 21311145 | 21311145 | PRJNA929924_P_NODE_9897_length_248_cov_1.432161_g9734_i0 | PRJNA929924 | 9897 | 248 | 1.432161 | 3.55175928 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 411 | 3.2099999999999995e-110 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g9734 | i0 | 96.414 | 1.01209677419355 | 251 | 6 | 100 | 1 | 1 | 248 | 3121 | 3371 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 251 | 411 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 22585873 | 22585873 | PRJNA929924_P_NODE_14738_length_171_cov_1.278689_g14575_i0 | PRJNA929924 | 14738 | 171 | 1.278689 | 2.18655819 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 294 | 2.16e-75 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g14575 | i0 | 97.661 | 1 | 171 | 4 | 100 | 0 | 1 | 171 | 1920 | 1750 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 171 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 22585879 | 22585879 | PRJNA929924_P_NODE_16158_length_166_cov_1.777778_g15995_i0 | PRJNA929924 | 16158 | 166 | 1.777778 | 2.95111148 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 285 | 1.26e-72 | NTclustered | gi|1935607033|gb|MT747992.1| | 2789443 | g15995 | i0 | 97.59 | 1 | 166 | 4 | 100 | 0 | 1 | 166 | 1134 | 1299 | Skokie dicistro-like virus strain USAdf-2 polyprotein 1 and polyprotein 2 genes, complete cds | blastn | 166 | 285 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 22585999 | 22585999 | PRJNA929924_P_NODE_6098_length_499_cov_1.837778_g5935_i0 | PRJNA929924 | 6098 | 499 | 1.837778 | 9.17051222 | Newfield virus | 1654354 | Viruses | Viruses | 628 | 1.7699999999999998e-175 | NTclustered | gi|1417910521|gb|MH384302.1| | 1654354 | g5935 | i0 | 89.379 | 5 | 499 | 53 | 100 | 0 | 1 | 499 | 4040 | 4538 | Newfield virus strain MARminus3606 putative RNA-dependent RNA polymerase and orf2 genes, complete cds | blastn | 2495 | 628 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 23861350 | 23861350 | PRJNA929924_P_NODE_7299_length_379_cov_1.733333_g7136_i0 | PRJNA929924 | 7299 | 379 | 1.733333 | 6.56933207 | Newfield virus | 1654354 | Viruses | Viruses | 540 | 6.32e-149 | NTclustered | gi|2463635389|gb|OP263084.1| | 1654354 | g7136 | i0 | 92.348 | 4.98416886543536 | 379 | 29 | 100 | 0 | 1 | 379 | 3967 | 3589 | Newfield virus isolate GBM386 putative RNA-dependent RNA polymerase gene, complete cds | blastn | 1889 | 540 | 1 | Viruses | Orthornavirae | Permutotetraviridae | Newfield virus | ||||||
| 25135017 | 25135017 | PRJNA929924_P_NODE_11980_length_204_cov_1.341935_g11817_i0 | PRJNA929924 | 11980 | 204 | 1.341935 | 2.7375474 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 355 | 1.21e-93 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g11817 | i0 | 98.039 | 1.98039215686275 | 204 | 4 | 100 | 0 | 1 | 204 | 4825 | 5028 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 404 | 355 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 25135020 | 25135020 | PRJNA929924_P_NODE_12100_length_202_cov_1.359477_g11937_i0 | PRJNA929924 | 12100 | 202 | 1.359477 | 2.74614354 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 374 | 3.3e-99 | NTclustered | gi|2028980905|gb|MZ002360.1| | 2697049 | g11937 | i0 | 100 | 100 | 202 | 0 | 100 | 0 | 1 | 202 | 29499 | 29700 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/WI-CDC-LC0038184/2021, complete genome | blastn | 20200 | 374 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25135240 | 25135240 | PRJNA929924_S_NODE_3440_length_230_cov_2.077720_g3396_i0 | PRJNA929924 | 3440 | 230 | 2.07772 | 4.778756 | Totivirus ni | 3432954 | Viruses | Viruses | 425 | 1.05e-114 | NTclustered | gi|9627980|ref|NC_001641.1| | 42478 | g3396 | i0 | 100 | 6.97391304347826 | 230 | 0 | 100 | 0 | 1 | 230 | 2135 | 2364 | Saccharomyces cerevisiae virus L-BC (La), complete genome | blastn | 1604 | 425 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Totivirus ni |
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);;