contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJEB2925" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988077 | 988077 | PRJEB2925_P_NODE_1361_length_1741_cov_3.152989_g1005_i0 | PRJEB2925 | 1361 | 1741 | 3.152989 | 54.89353849 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 3216 | 0 | NTclustered | gi|229892773|gb|GQ132173.1| | 644377 | g1005 | i0 | 100 | 100 | 1741 | 0 | 100 | 0 | 1 | 1741 | 377 | 2117 | Influenza A virus (A/Canada-ON/RV1529/2009(H1N1)) segment 3 polymerase PA (PA) gene, complete cds | blastn | 174100 | 3216 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 1300313 | 1300313 | PRJEB2925_P_NODE_1182_length_2034_cov_3.874437_g892_i0 | PRJEB2925 | 1182 | 2034 | 3.874437 | 78.80604858 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 3404 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g892 | i0 | 96.858 | 3.00196656833825 | 2037 | 61 | 100 | 1 | 1 | 2034 | 5783 | 3747 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 6106 | 3404 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 1300401 | 1300401 | PRJEB2925_P_NODE_5082_length_602_cov_2.077601_g4072_i0 | PRJEB2925 | 5082 | 602 | 2.077601 | 12.50715802 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 431 | 6.549999999999998e-116 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g4072 | i0 | 97.244 | 2.66445182724252 | 254 | 7 | 89 | 0 | 180 | 433 | 3126 | 3379 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1604 | 431 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 2263355 | 2263355 | PRJEB2925_P_NODE_10662_length_347_cov_3.522436_g9389_i0 | PRJEB2925 | 10662 | 347 | 3.522436 | 12.22285292 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 436 | 7.759999999999999e-118 | NTclustered | gi|2740074559|gb|PP874780.1| | 11320 | g9389 | i0 | 100 | 68.8703170028818 | 236 | 0 | 68 | 0 | 112 | 347 | 126 | 361 | Influenza A virus (A/Colombia/M6406/2016(H1N1)) segment 2 polymerase PB1 (PB1) gene, complete cds; and nonfunctional PB1-F2 protein (PB1-F2) gene, complete sequence | blastn | 23898 | 436 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 2263374 | 2263374 | PRJEB2925_P_NODE_12862_length_295_cov_1.965385_g11585_i0 | PRJEB2925 | 12862 | 295 | 1.965385 | 5.79788575 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 326 | 1.46e-84 | NTclustered | gi|2449947150|gb|OQ535201.1| | 11320 | g11585 | i0 | 100 | 98.3932203389831 | 176 | 0 | 100 | 0 | 120 | 295 | 682 | 507 | Influenza A virus (A/USA/8A3/2011(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 29026 | 327 | 0.996941896024465 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 2263432 | 2263432 | PRJEB2925_P_NODE_8002_length_440_cov_4.355556_g6782_i0 | PRJEB2925 | 8002 | 440 | 4.355556 | 19.1644464 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 680 | 0 | NTclustered | gi|2624562272|gb|OR874284.1| | 11320 | g6782 | i0 | 99.73 | 87.4590909090909 | 371 | 1 | 84 | 0 | 70 | 440 | 1289 | 919 | Influenza A virus (A/Kenya/CDC-Nyeri/002/2009(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 38482 | 686 | 0.991253644314869 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 2576036 | 2576036 | PRJEB2925_P_NODE_8143_length_435_cov_1.750000_g6916_i0 | PRJEB2925 | 8143 | 435 | 1.75 | 7.6125 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 505 | 2.68e-138 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g6916 | i0 | 96.7 | 2.58850574712644 | 303 | 10 | 70 | 0 | 133 | 435 | 1985 | 2287 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1126 | 505 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 3538658 | 3538658 | PRJEB2925_P_NODE_1203_length_1999_cov_3.382892_g904_i0 | PRJEB2925 | 1203 | 1999 | 3.382892 | 67.62401108 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 2963 | 0 | NTclustered | gi|1920167247|gb|MW185783.1| | 11320 | g904 | i0 | 98.188 | 97.3856928464232 | 1711 | 3 | 96 | 9 | 74 | 1768 | 2232 | 534 | Influenza A virus (A/Lithuania/1167/2009(H1N1)) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 194674 | 2968 | 0.998315363881402 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 3538665 | 3538665 | PRJEB2925_P_NODE_1443_length_1617_cov_2.952592_g1063_i0 | PRJEB2925 | 1443 | 1617 | 2.952592 | 47.74341264 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 2032 | 0 | NTclustered | gi|2332152027|gb|OP862000.1| | 11320 | g1063 | i0 | 96.617 | 87.2467532467532 | 1212 | 24 | 86 | 2 | 108 | 1302 | 128 | 1339 | Influenza A virus (A/Nepal/FLUNP09A-394/2009(H1N1)) segment 4 hemagglutinin (HA) gene, complete cds | blastn | 141078 | 2049 | 0.99170326988775 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 3852275 | 3852275 | PRJEB2925_P_NODE_4644_length_636_cov_2.234609_g3684_i0 | PRJEB2925 | 4644 | 636 | 2.234609 | 14.21211324 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 715 | 0 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g3684 | i0 | 94.255 | 2.95911949685535 | 470 | 24 | 98 | 3 | 1 | 467 | 2910 | 3379 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1882 | 715 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 6091202 | 6091202 | PRJEB2925_P_NODE_17365_length_208_cov_4.109827_g16087_i0 | PRJEB2925 | 17365 | 208 | 4.109827 | 8.54844016 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 385 | 1.58e-102 | NTclustered | gi|2810150290|gb|PQ384650.1| | 11320 | g16087 | i0 | 100 | 100 | 208 | 0 | 100 | 0 | 1 | 208 | 2166 | 1959 | Influenza A virus (A/mus musculus/Ohio/H1N1_Parent_PB1_consensus/2023(H1N1)) segment 2 polymerase PB1 (PB1) gene, complete cds; and nonfunctional PB1-F2 protein (PB1-F2) gene, complete sequence | blastn | 20800 | 385 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 7678324 | 7678324 | PRJEB2925_P_NODE_13307_length_286_cov_7.378486_g12030_i0 | PRJEB2925 | 13307 | 286 | 7.378486 | 21.10246996 | Mitovirus sp. | 2587224 | Viruses | Viruses | 171 | 6.99e-38 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g12030 | i0 | 94.545 | 3.27622377622378 | 110 | 6 | 38 | 0 | 1 | 110 | 3 | 112 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 937 | 171 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 8953081 | 8953081 | PRJEB2925_P_NODE_14608_length_266_cov_2.688312_g13330_i0 | PRJEB2925 | 14608 | 266 | 2.688312 | 7.15090992 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 431 | 2.67e-116 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g13330 | i0 | 95.865 | 2.9887218045112798 | 266 | 11 | 100 | 0 | 1 | 266 | 2913 | 2648 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 795 | 431 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 15015924 | 15015924 | PRJEB2925_P_NODE_12792_length_296_cov_4.111111_g11515_i0 | PRJEB2925 | 12792 | 296 | 4.111111 | 12.16888856 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 412 | 1.0899999999999999e-110 | NTclustered | gi|2624562240|gb|OR874268.1| | 11320 | g11515 | i0 | 100 | 75.8243243243243 | 223 | 0 | 75 | 0 | 1 | 223 | 354 | 132 | Influenza A virus (A/Kenya/CDC-Nakuru/094/2009(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 22444 | 412 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 15015943 | 15015943 | PRJEB2925_P_NODE_2412_length_1009_cov_5.626283_g1796_i0 | PRJEB2925 | 2412 | 1009 | 5.626283 | 56.76919547 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1626 | 0 | NTclustered | gi|1059146602|gb|GQ360066.2| | 657546 | g1796 | i0 | 99.887 | 89.6778989098117 | 883 | 1 | 91 | 0 | 107 | 989 | 142 | 1024 | Influenza A virus (A/Stockholm/32/2009(H1N1)) segment 7 matrix protein 2 (M2) and matrix protein 1 (M1) genes, complete cds | blastn | 90485 | 1633 | 0.995713410900184 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 16290780 | 16290780 | PRJEB2925_P_NODE_3113_length_835_cov_6.588750_g2374_i0 | PRJEB2925 | 3113 | 835 | 6.58875 | 55.0160625 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1254 | 0 | NTclustered | gi|1408060286|gb|MH328713.1| | 11320 | g2374 | i0 | 100 | 84.9724550898204 | 679 | 0 | 81 | 0 | 72 | 750 | 776 | 98 | Influenza A virus (A/Taiwan/90001/2010(H1N1)) segment 8 nuclear export protein (NEP) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 70952 | 1256 | 0.998407643312102 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 16290811 | 16290811 | PRJEB2925_P_NODE_8653_length_414_cov_4.823219_g7403_i0 | PRJEB2925 | 8653 | 414 | 4.823219 | 19.96812666 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 645 | 1.4399999999999993e-180 | NTclustered | gi|257472135|gb|CY045241.1| | 669985 | g7403 | i0 | 96.345 | 82.3574879227053 | 383 | 11 | 92 | 1 | 22 | 401 | 1 | 383 | Influenza A virus (A/Taiwan/137/2009(H1N1)) segment 3 sequence | blastn | 34096 | 651 | 0.990783410138249 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 17565956 | 17565956 | PRJEB2925_P_NODE_1774_length_1315_cov_2.360156_g1311_i0 | PRJEB2925 | 1774 | 1315 | 2.360156 | 31.0360514 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 2211 | 0 | NTclustered | gi|1408061143|gb|MH328801.1| | 11320 | g1311 | i0 | 99.917 | 91.280608365019 | 1200 | 1 | 91 | 0 | 116 | 1315 | 145 | 1344 | Influenza A virus (A/Taiwan/02727/2009(H1N1)) segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 120034 | 2217 | 0.997293640054127 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 20426742 | 20426742 | PRJEB2925_P_NODE_1057_length_2387_cov_6.837160_g799_i0 | PRJEB2925 | 1057 | 2387 | 6.83716 | 163.2030092 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 4013 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g799 | i0 | 97.848 | 3.10808546292417 | 2323 | 50 | 100 | 0 | 1 | 2323 | 5811 | 8133 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 7419 | 4013 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21390254 | 21390254 | PRJEB2925_P_NODE_1817_length_1288_cov_2.887470_g904_i1 | PRJEB2925 | 1817 | 1288 | 2.88747 | 37.1906136 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 1620 | 0 | NTclustered | gi|1920167247|gb|MW185783.1| | 11320 | g904 | i1 | 98.083 | 90.8501552795031 | 939 | 2 | 90 | 8 | 1 | 923 | 1472 | 534 | Influenza A virus (A/Lithuania/1167/2009(H1N1)) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 117015 | 1626 | 0.996309963099631 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 22664948 | 22664948 | PRJEB2925_P_NODE_12698_length_298_cov_2.235741_g11421_i0 | PRJEB2925 | 12698 | 298 | 2.235741 | 6.66250818 | Alphainfluenzavirus | 197911 | Viruses | Viruses | 327 | 4.11e-85 | NTclustered | gi|2449947150|gb|OQ535201.1| | 11320 | g11421 | i0 | 100 | 99.996644295302 | 177 | 0 | 100 | 0 | 122 | 298 | 683 | 507 | Influenza A virus (A/USA/8A3/2011(H1N1)) segment 6 neuraminidase (NA) gene, complete cds | blastn | 29799 | 327 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Alphainfluenzavirus influenzae | ||
| 24251845 | 24251845 | PRJEB2925_P_NODE_10680_length_347_cov_1.685897_g9407_i0 | PRJEB2925 | 10680 | 347 | 1.685897 | 5.85006259 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 348 | 3.74e-91 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g9407 | i0 | 98.477 | 2.11239193083573 | 197 | 3 | 57 | 0 | 151 | 347 | 3774 | 3578 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 733 | 348 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 |
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);;