contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1730058 | 1730058 | PRJNA493244_P_NODE_1268122_length_306_cov_34.432653_g1244998_i0 | PRJNA493244 | 1268122 | 306 | 34.432653 | 105.36391818 | Carlavirus uniglycinis | 3427801 | Viruses | Viruses | 516 | 8.42e-142 | NTclustered | gi|2500382213|ref|NC_076917.1| | 2796532 | g1244998 | i0 | 99.645 | 3.40522875816993 | 282 | 1 | 92 | 0 | 2 | 283 | 8680 | 8399 | Soybean carlavirus 1 strain SCV1-IL, complete genome | blastn | 1042 | 516 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus uniglycinis | ||
| 1730428 | 1730428 | PRJNA493244_P_NODE_1436682_length_258_cov_6.248731_g1413557_i0 | PRJNA493244 | 1436682 | 258 | 6.248731 | 16.12172598 | Periplaneta americana dicistro-like virus | 3032225 | Viruses | Viruses | 333 | 7.489999999999999e-87 | NTclustered | gi|2754804027|tpg|BK063169.1| | 3032225 | g1413557 | i0 | 92.704 | 0.90310077519379806 | 233 | 14 | 90 | 3 | 4 | 236 | 4638 | 4409 | TPA_asm: Periplaneta americana dicistro-like virus hypothetical protein gene, partial cds | blastn | 233 | 333 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Periplaneta americana dicistro-like virus | |||
| 1730578 | 1730578 | PRJNA493244_P_NODE_1501282_length_242_cov_5.000000_g1478157_i0 | PRJNA493244 | 1501282 | 242 | 5 | 12.1 | Erysiphe necator associated ourmia-like virus 87 | 2741867 | Viruses | Viruses | 394 | 3.14e-105 | NTclustered | gi|2798495165|gb|PP945076.1| | 2741867 | g1478157 | i0 | 98.649 | 0.91735537190082606 | 222 | 3 | 92 | 0 | 21 | 242 | 1954 | 2175 | Erysiphe necator associated ourmia-like virus 87 strain China-NX113 RNA-dependent RNA polymerase gene, complete cds | blastn | 222 | 394 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Ourmiavirus | Erysiphe necator associated ourmia-like virus 87 | ||
| 1731072 | 1731072 | PRJNA493244_P_NODE_1699382_length_204_cov_0.895105_g1676257_i0 | PRJNA493244 | 1699382 | 204 | 0.895105 | 1.8260142 | Potexvirus pepini | 3433856 | Viruses | Viruses | 377 | 2.59e-100 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g1676257 | i0 | 100 | 62.843137254902 | 204 | 0 | 100 | 0 | 1 | 204 | 1888 | 2091 | Pepino mosaic virus strain CH2, complete genome | blastn | 12820 | 377 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3005878 | 3005878 | PRJNA493244_P_NODE_1201903_length_328_cov_2.397004_g1178779_i0 | PRJNA493244 | 1201903 | 328 | 2.397004 | 7.86217312 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 558 | 1.49e-154 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g1178779 | i0 | 99.672 | 1.45121951219512 | 305 | 1 | 93 | 0 | 24 | 328 | 3128 | 2824 | Malassezia restricta virus MrV40L, complete genome | blastn | 476 | 558 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 3006906 | 3006906 | PRJNA493244_P_NODE_16083_length_2467_cov_7.995844_g14384_i0 | PRJNA493244 | 16083 | 2467 | 7.995844 | 197.25747148 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 2586 | 0 | NTclustered | gi|2245490375|gb|ON164215.1| | 2583949 | g14384 | i0 | 97.674 | 0.623023915687069 | 1505 | 35 | 61 | 0 | 1 | 1505 | 89 | 1593 | MAG: Narnaviridae sp. isolate 176-k141_8579 RNA dependent RNA polymerase gene, partial cds | blastn | 1537 | 2586 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 3007067 | 3007067 | PRJNA493244_P_NODE_1666603_length_208_cov_0.870748_g1643478_i0 | PRJNA493244 | 1666603 | 208 | 0.870748 | 1.81115584 | Ustilaginoidea virens partitivirus | 1346082 | Viruses | Viruses | 316 | 5.849999999999998e-82 | NTclustered | gi|512746091|gb|KC503901.1| | 1346082 | g1643478 | i0 | 95.025 | 0.966346153846154 | 201 | 10 | 97 | 0 | 8 | 208 | 854 | 654 | Ustilaginoidea virens partitivirus segment 4, complete sequence | blastn | 201 | 316 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Ustilaginoidea virens partitivirus | |||
| 4928235 | 4928235 | PRJNA493244_P_NODE_67744_length_1728_cov_7.638272_g62593_i0 | PRJNA493244 | 67744 | 1728 | 7.638272 | 131.98934016 | Tobamovirus | 12234 | Viruses | Viruses | 3081 | 0 | NTclustered | gi|927657516|dbj|LC082099.1| | 12239 | g62593 | i0 | 98.843 | 95.9548611111111 | 1728 | 20 | 100 | 0 | 1 | 1728 | 3048 | 4775 | Pepper mild mottle virus genomic RNA, complete genome, strain: P2 | blastn | 165810 | 3097 | 0.994833710041976 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 5560047 | 5560047 | PRJNA493244_P_NODE_1733725_length_196_cov_2.770370_g1710600_i0 | PRJNA493244 | 1733725 | 196 | 2.7703700000000002 | 5.4299252 | Hainan alphaflexivirus 2 | 2824425 | Viruses | Viruses | 87.9 | 4.65e-13 | NTclustered | gi|2075444288|gb|MW897284.1| | 2824425 | g1710600 | i0 | 87.838 | 1.94897959183673 | 74 | 9 | 38 | 0 | 4 | 77 | 4236 | 4163 | MAG: Hainan alphaflexivirus 2 isolate R87-k141_314575 replicase gene, partial cds; and NTP-binding helicase and hypothetical protein genes, complete cds | blastn | 382 | 87.9 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Hainan alphaflexivirus 2 | |||
| 5561484 | 5561484 | PRJNA493244_P_NODE_993845_length_409_cov_19.195402_g970765_i0 | PRJNA493244 | 993845 | 409 | 19.195402 | 78.50919418 | Aspergillus flavus magoulivirus 1 | 2871716 | Viruses | Viruses | 226 | 2.19e-54 | NTclustered | gi|2095891259|gb|MZ600058.1| | 2871716 | g970765 | i0 | 79.883 | 0.838630806845966 | 343 | 41 | 80 | 20 | 12 | 337 | 381 | 50 | MAG: Aspergillus flavus magoulivirus 1 isolate UniPR4 genomic sequence, sequence | blastn | 343 | 226 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Magoulivirus | Aspergillus flavus magoulivirus 1 | ||
| 6834489 | 6834489 | PRJNA493244_P_NODE_316346_length_953_cov_4.123318_g300405_i0 | PRJNA493244 | 316346 | 953 | 4.123318 | 39.29522054 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 1729 | 0 | NTclustered | gi|2737472510|dbj|LC817996.1| | 12239 | g300405 | i0 | 99.474 | 94.0745015739769 | 951 | 5 | 99 | 0 | 1 | 951 | 4606 | 5556 | Pepper mild mottle virus PMMoV_YE_CNU1 genes for replication-associated protein, movement protein, coat protein, complete cds | blastn | 89653 | 1729 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 8109025 | 8109025 | PRJNA493244_P_NODE_1536527_length_234_cov_3.150289_g1513402_i0 | PRJNA493244 | 1536527 | 234 | 3.150289 | 7.37167626 | Chrocagost virus | 3129398 | Viruses | Viruses | 281 | 2.46e-71 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g1513402 | i0 | 92.424 | 312.551282051282 | 198 | 14 | 84 | 1 | 5 | 201 | 5664 | 5861 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 73137 | 281 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 9383175 | 9383175 | PRJNA493244_P_NODE_1276128_length_304_cov_1.983539_g1253004_i0 | PRJNA493244 | 1276128 | 304 | 1.983539 | 6.02995856 | Hebei scleroulivirus | 3371279 | Viruses | Viruses | 372 | 1.91e-98 | NTclustered | gi|2819062619|gb|PQ150490.1| | 3371279 | g1253004 | i0 | 93.6 | 1.00657894736842 | 250 | 15 | 82 | 1 | 24 | 272 | 2113 | 2362 | MAG: Hebei scleroulivirus isolate Beijing_119 genomic sequence | blastn | 306 | 372 | 1 | Viruses | Orthornavirae | Lenarviricota | Miaviricetes | Ourlivirales | Botourmiaviridae | Scleroulivirus | Hebei scleroulivirus | ||
| 9384016 | 9384016 | PRJNA493244_P_NODE_1603808_length_219_cov_7.841772_g1580683_i0 | PRJNA493244 | 1603808 | 219 | 7.841772 | 17.17348068 | Potexvirus pepini | 3433856 | Viruses | Viruses | 326 | 1.0299999999999999e-84 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g1580683 | i0 | 99.441 | 76.1552511415525 | 179 | 1 | 82 | 0 | 1 | 179 | 6412 | 6234 | Pepino mosaic virus strain CH2, complete genome | blastn | 16678 | 326 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 10658461 | 10658461 | PRJNA493244_P_NODE_1004189_length_405_cov_2.220930_g981096_i0 | PRJNA493244 | 1004189 | 405 | 2.22093 | 8.9947665 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 723 | 0 | NTclustered | gi|388240269|emb|HE818446.1| | 12242 | g981096 | i0 | 99.746 | 97.2888888888889 | 394 | 1 | 97 | 0 | 1 | 394 | 3812 | 3419 | Tobacco mosaic virus isolate Wenxing, complete genome | blastn | 39402 | 723 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 10660523 | 10660523 | PRJNA493244_P_NODE_295529_length_987_cov_3.389849_g280235_i0 | PRJNA493244 | 295529 | 987 | 3.389849 | 33.45780963 | Poaceae Liege partitivirus 6 | 2972889 | Viruses | Viruses | 1469 | 0 | NTclustered | gi|2288738604|gb|OL330745.1| | 2972889 | g280235 | i0 | 93.522 | 2.00506585612969 | 988 | 63 | 100 | 1 | 1 | 987 | 550 | 1537 | Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds | blastn | 1979 | 1469 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Poaceae Liege partitivirus 6 | |||
| 12578481 | 12578481 | PRJNA493244_P_NODE_1017410_length_399_cov_3.218935_g994310_i0 | PRJNA493244 | 1017410 | 399 | 3.218935 | 12.84355065 | Pestivirus | 11095 | Viruses | Viruses | 58.4 | 8.22e-4 | NTclustered | gi|3851366|gb|AF026733.1| | 61001 | g994310 | i0 | 100 | 0.380952380952381 | 31 | 0 | 8 | 0 | 6 | 36 | 171 | 141 | Border disease virus strain V1414 polyprotein gene, partial cds and partial 3'-noncoding region | blastn | 152 | 58.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus ovis | ||
| 13210650 | 13210650 | PRJNA493244_P_NODE_39831_length_1999_cov_37.811146_g36419_i0 | PRJNA493244 | 39831 | 1999 | 37.811146 | 755.84480854 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 3640 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g36419 | i0 | 99.899 | 0.989494747373687 | 1978 | 0 | 99 | 1 | 24 | 1999 | 666 | 2643 | Malassezia restricta virus MrV40L, complete genome | blastn | 1978 | 3640 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 15758766 | 15758766 | PRJNA493244_P_NODE_1613513_length_217_cov_4.012821_g1590388_i0 | PRJNA493244 | 1613513 | 217 | 4.012821 | 8.70782157 | Totiviridae sp. | 1955172 | Viruses | Viruses | 189 | 1.4e-43 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g1590388 | i0 | 83.92 | 2.75115207373272 | 199 | 31 | 92 | 1 | 6 | 204 | 4284 | 4481 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 597 | 189 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 24680787 | 24680787 | PRJNA493244_P_NODE_1067500_length_378_cov_3.123028_g1044383_i0 | PRJNA493244 | 1067500 | 378 | 3.123028 | 11.80504584 | Poaceae Liege partitivirus 6 | 2972889 | Viruses | Viruses | 510 | 4.94e-140 | NTclustered | gi|2288738604|gb|OL330745.1| | 2972889 | g1044383 | i0 | 91.029 | 1.0026455026455 | 379 | 33 | 100 | 1 | 1 | 378 | 109 | 487 | Poaceae Liege partitivirus 6 putative RNA-dependent RNA polymerase (ORF1) gene, complete cds | blastn | 379 | 510 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Poaceae Liege partitivirus 6 | |||
| 24682456 | 24682456 | PRJNA493244_P_NODE_1743160_length_189_cov_14.554688_g1720035_i0 | PRJNA493244 | 1743160 | 189 | 14.554688 | 27.50836032 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 76.8 | 9.62e-10 | NTclustered | gi|383213248|gb|CY112297.1| | RQ01 | g1720035 | i0 | 94 | 26.3968253968254 | 50 | 3 | 26 | 0 | 102 | 151 | 1050 | 1099 | Influenza A virus (A/Bilthoven/6022/1972(H3N2)) hemagglutinin (HA) gene, complete cds | blastn | 4989 | 76.8 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus |
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);;