contig_metadata
18 rows where bioproject = "PRJEB20058", tax_phylum = "Negarnaviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22662853 | 22662853 | PRJEB20058_S_NODE_3898_length_326_cov_0.988679_g3860_i0 | PRJEB20058 | 3898 | 326 | 0.988679 | 3.22309354 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 473 | 5.519999999999999e-129 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g3860 | i0 | 99.237 | 80.3466257668712 | 262 | 2 | 80 | 0 | 1 | 262 | 528 | 789 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 26193 | 473 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 23938235 | 23938235 | PRJEB20058_S_NODE_1139_length_637_cov_4.244792_g1102_i0 | PRJEB20058 | 1139 | 637 | 4.244792 | 27.03932504 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 966 | 0 | NTclustered | gi|75181074|gb|CY002744.1| | 332746 | g1102 | i0 | 99.622 | 82.7378335949765 | 529 | 2 | 83 | 0 | 63 | 591 | 1220 | 1748 | Influenza A virus (A/Memphis/109/1972(H3N2)) hemagglutinin (HA) gene, complete cds | blastn | 52704 | 974 | 0.991786447638604 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25515501 | 25515501 | PRJEB20058_P_NODE_162233_length_297_cov_1.961864_g159410_i0 | PRJEB20058 | 162233 | 297 | 1.961864 | 5.82673608 | Grapevine associated cogu-like virus 2 | 2716184 | Viruses | Viruses | 481 | 2.97e-131 | NTclustered | gi|2500668871|ref|NC_078437.1| | 2716184 | g159410 | i0 | 95.946 | 1.58922558922559 | 296 | 12 | 99 | 0 | 2 | 297 | 1944 | 2239 | Grapevine associated cogu-like virus 2 isolate DMG 86 segment RNA1 P1 (QK698_sRNA1gp1) gene, complete cds | blastn | 472 | 481 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Laulavirus | Laulavirus alphaviticulum | ||
| 25612978 | 25612978 | PRJEB20058_P_NODE_173153_length_283_cov_46.612613_g170330_i0 | PRJEB20058 | 173153 | 283 | 46.612613 | 131.91369479 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 261 | 3.99e-65 | NTclustered | gi|315076809|gb|CY077791.1| | 936107 | g170330 | i0 | 100 | 49.5547703180212 | 141 | 0 | 50 | 0 | 93 | 233 | 142 | 2 | Influenza A virus (A/Bilthoven/1761/1976(H3N2)) polymerase PB2 (PB2) gene, complete cds | blastn | 14024 | 261 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25750337 | 25750337 | PRJEB20058_P_NODE_27066_length_803_cov_3976.037736_g4283_i2 | PRJEB20058 | 27066 | 803 | 3976.037736 | 31927.58302008 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1009 | 0 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g4283 | i2 | 100 | 73.4545454545455 | 546 | 0 | 76 | 0 | 122 | 667 | 212 | 757 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 58984 | 1009 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25786505 | 25786505 | PRJEB20058_P_NODE_13795_length_1117_cov_3.081439_g12065_i0 | PRJEB20058 | 13795 | 1117 | 3.081439 | 34.41967363 | Influenza A virus (A/swine/Hong Kong/127/1982(H3N2)) | 384483 | Viruses | Viruses | 71.3 | 3.14e-7 | NTclustered | gi|432357|dbj|D21182.1|FLAHAS127 | 384483 | g12065 | i0 | 93.878 | 4.2094897045658 | 49 | 0 | 4 | 2 | 1069 | 1117 | 718 | 673 | Influenza A virus (A/swine/Hong Kong/127/1982(H3N2)) gene for hemagglutinin, partial cds | blastn | 4702 | 71.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 25791099 | 25791099 | PRJEB20058_P_NODE_28147_length_789_cov_11.070055_g25762_i0 | PRJEB20058 | 28147 | 789 | 11.070055 | 87.34273395 | Coleopteran phasma-related virus OKIAV235 | 2746309 | Viruses | Viruses | 1330 | 0 | NTclustered | gi|2500668694|ref|NC_078332.1| | 2746309 | g25762 | i0 | 98.413 | 0.958174904942966 | 756 | 12 | 96 | 0 | 20 | 775 | 3125 | 2370 | Coleopteran phasma-related virus OKIAV235 segment L genomic sequence | blastn | 756 | 1330 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Elliovirales | Phasmaviridae | Orthophasmavirus | Orthophasmavirus sp. 'coleopterus' | ||
| 25791273 | 25791273 | PRJEB20058_P_NODE_31131_length_752_cov_2.308249_g28639_i0 | PRJEB20058 | 31131 | 752 | 2.308249 | 17.35803248 | Sonemauk virus | 3131582 | Viruses | Viruses | 144 | 2.98e-35 | NR | WZH61623.1 | 3131582 | g28639 | i0 | 38.5 | 1.78723404255319 | 221 | 126 | 85.4 | 5 | 69 | 710 | 1069 | 1286 | WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus] | diamond | 1344 | 144 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sonemauk virus | ||||
| 26021673 | 26021673 | PRJEB20058_P_NODE_196444_length_259_cov_1.161616_g193620_i0 | PRJEB20058 | 196444 | 259 | 1.161616 | 3.00858544 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 479 | 9.13e-131 | NTclustered | gi|13274643|gb|AF258842.1| | 153970 | g193620 | i0 | 100 | 100 | 259 | 0 | 100 | 0 | 1 | 259 | 1203 | 1461 | Influenza A virus (A/Hong Kong/498/97(H3N2)) RNA polymerase (PB2) gene, complete cds | blastn | 25900 | 479 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 26022983 | 26022983 | PRJEB20058_P_NODE_5196_length_1935_cov_2640.768943_g4283_i1 | PRJEB20058 | 5196 | 1935 | 2640.768943 | 51098.87904705 | root | 1 | Root_unresolved | Root_unresolved | 1838 | 0 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g4283 | i1 | 99.9 | 83.4547803617571 | 998 | 1 | 83 | 0 | 122 | 1119 | 212 | 1209 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 161485 | 1838 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 26156430 | 26156430 | PRJEB20058_P_NODE_108053_length_389_cov_4.179878_g105242_i0 | PRJEB20058 | 108053 | 389 | 4.179878 | 16.25972542 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 520 | 8.479999999999999e-143 | NTclustered | gi|2905074022|gb|PV081923.1| | 11320 | g105242 | i0 | 98.635 | 75.2159383033419 | 293 | 4 | 75 | 0 | 49 | 341 | 414 | 122 | Influenza A virus (A/MDCK serial passage/San Diego/Serial passage/2021(H3N2)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 29259 | 520 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 26157714 | 26157714 | PRJEB20058_P_NODE_188965_length_266_cov_3.273171_g186141_i0 | PRJEB20058 | 188965 | 266 | 3.273171 | 8.70663486 | Negarnaviricota | 2497569 | Viruses | Viruses | 433 | 7.44e-117 | NTclustered | gi|2500668869|ref|NC_078436.1| | 2716184 | g186141 | i0 | 97.992 | 1.85714285714286 | 249 | 5 | 94 | 0 | 1 | 249 | 250 | 2 | Grapevine associated cogu-like virus 2 isolate DMG 86 segment RNA3 P3 (QK698_sRNA3gp1) gene, complete cds | blastn | 494 | 433 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Laulavirus | Laulavirus alphaviticulum | ||
| 26430855 | 26430855 | PRJEB20058_P_NODE_5191_length_1936_cov_2698.298133_g4283_i0 | PRJEB20058 | 5191 | 1936 | 2698.298133 | 52239.05185488 | root | 1 | Root_unresolved | Root_unresolved | 1838 | 0 | NTclustered | gi|2905083291|gb|PV081924.1| | 11320 | g4283 | i0 | 99.9 | 83.4101239669422 | 998 | 1 | 83 | 0 | 122 | 1119 | 212 | 1209 | Influenza A virus (A/MDCK serial passage/San Diego/serial passage/2021(H3N2)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 161482 | 1838 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 26475444 | 26475444 | PRJEB20058_P_NODE_9888_length_1326_cov_6.308300_g8450_i0 | PRJEB20058 | 9888 | 1326 | 6.3083 | 83.648058 | Influenza A virus (A/Victoria/3/1975(H3N2)) | 392809 | Viruses | Viruses | 2401 | 0 | NTclustered | gi|383276899|gb|CY113186.1| | 392809 | g8450 | i0 | 100 | 98.0392156862745 | 1300 | 0 | 98 | 0 | 1 | 1300 | 1962 | 663 | Influenza A virus (A/Victoria/3/1975(H3N2)) polymerase PA (PA) gene, complete cds | blastn | 130000 | 2401 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 32928044 | 32928044 | PRJEB20058_P_NODE_19417_length_942_cov_2.770715_g17366_i0 | PRJEB20058 | 19417 | 942 | 2.770715 | 26.1001353 | Plasmopara viticola lesion associated mycobunyavirales-like virus 1 | 2689124 | Viruses | Viruses | 147 | 1.7199999999999998e-35 | NR | QGY72638.1 | 2689124 | g17366 | i0 | 34.3 | 0.993630573248408 | 312 | 185 | 93.6 | 8 | 2 | 883 | 615 | 924 | QGY72638.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated mycobunyavirales-like virus 1] | diamond | 936 | 147 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Plasmopara viticola lesion associated mycobunyavirales-like virus 1 | ||||
| 32962904 | 32962904 | PRJEB20058_P_NODE_54810_length_567_cov_27.339921_g52065_i0 | PRJEB20058 | 54810 | 567 | 27.339921 | 155.01735207 | Rhizoctonia cerealis bunyavirus | 3068840 | Viruses | Viruses | 56.6 | 6.96e-6 | NR | WMI40170.1 | 3068840 | g52065 | i0 | 26.3 | 0.804232804232804 | 152 | 105 | 79.9 | 2 | 45 | 497 | 84 | 229 | WMI40170.1 MAG: hypothetical protein [Rhizoctonia cerealis bunyavirus] | diamond | 456 | 56.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Rhizoctonia cerealis bunyavirus | ||||
| 33013644 | 33013644 | PRJEB20058_P_NODE_229780_length_232_cov_3.491228_g226955_i0 | PRJEB20058 | 229780 | 232 | 3.491228 | 8.09964896 | Sonemauk virus | 3131582 | Viruses | Viruses | 75.9 | 7.14e-14 | NR | WZH61623.1 | 3131582 | g226955 | i0 | 50.6 | 0.995689655172414 | 77 | 38 | 99.6 | 0 | 231 | 1 | 1150 | 1226 | WZH61623.1 MAG: RNA-dependent RNA polymerase [Sonemauk virus] | diamond | 231 | 75.9 | 1 | Viruses | Orthornavirae | Negarnaviricota | Ellioviricetes | Bunyavirales | Sonemauk virus | ||||
| 33030920 | 33030920 | PRJEB20058_P_NODE_30508_length_759_cov_30.325215_g28033_i0 | PRJEB20058 | 30508 | 759 | 30.325215 | 230.16838185 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 125 | 1.47e-28 | NR | WLN26256.1 | 3065075 | g28033 | i0 | 44.1 | 0.573122529644269 | 145 | 81 | 57.3 | 0 | 736 | 302 | 90 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 435 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus |
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);;