contig_metadata
24 rows where analysis = "blastn", bioproject = "PRJNA939369" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1256108 | 1256108 | PRJNA939369_S_NODE_661_length_1284_cov_12.716763_g420_i0 | PRJNA939369 | 661 | 1284 | 12.716763 | 163.28323692 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 2213 | 0 | NTclustered | gi|1328406500|ref|NC_036620.1| | 1511083 | g420 | i0 | 99.669 | 93.0381619937695 | 1210 | 4 | 94 | 0 | 1 | 1210 | 1211 | 2 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 6 P42 (P42) gene, complete cds | blastn | 119461 | 2224 | 0.995053956834532 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 3808090 | 3808090 | PRJNA939369_S_NODE_363_length_1768_cov_25.598820_g200_i0 | PRJNA939369 | 363 | 1768 | 25.59882 | 452.5871376 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3230 | 0 | NTclustered | gi|2050655392|gb|MZ264975.1| | 1511083 | g200 | i0 | 99.66 | 98.3964932126697 | 1767 | 6 | 99 | 0 | 2 | 1768 | 2 | 1768 | Influenza D virus (D/bovine/Italy/287448/2015) segment 5 nucleocapsid protein (NP) gene, complete cds | blastn | 173965 | 3241 | 0.99660598580685 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 4742565 | 4742565 | PRJNA939369_S_NODE_18844_length_344_cov_1.369004_g18427_i0 | PRJNA939369 | 18844 | 344 | 1.369004 | 4.70937376 | Penaeus vannamei solinvivirus | 2973956 | Viruses | Viruses | 499 | 9.67e-137 | NTclustered | gi|2304762575|gb|OP265432.1| | 2973956 | g18427 | i0 | 93.003 | 30.2122093023256 | 343 | 22 | 99 | 2 | 1 | 342 | 342 | 1 | Penaeus vannamei solinvivirus isolate 20-905-APL polyprotein gene, complete cds | blastn | 10393 | 499 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Solinviviridae | Penaeus vannamei solinvivirus | |||
| 4742917 | 4742917 | PRJNA939369_S_NODE_68384_length_245_cov_0.877907_g67967_i0 | PRJNA939369 | 68384 | 245 | 0.877907 | 2.15087215 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 1.02e-5 | NTclustered | gi|2557634435|emb|OY691424.1| | 2697049 | g67967 | i0 | 97.297 | 14.9102040816327 | 37 | 1 | 15 | 0 | 209 | 245 | 7552 | 7588 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3653 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5084345 | 5084345 | PRJNA939369_S_NODE_1544_length_862_cov_34.152091_g1198_i0 | PRJNA939369 | 1544 | 862 | 34.152091 | 294.39102442 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 1580 | 0 | NTclustered | gi|1328406502|ref|NC_036621.1| | 1511083 | g1198 | i0 | 99.768 | 99.1786542923434 | 861 | 2 | 99 | 0 | 1 | 861 | 861 | 1 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 7 nonstructural protein 2 (NS2) and nonstructural protein 1 (NS1) genes, complete cds | blastn | 85492 | 1580 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 8908891 | 8908891 | PRJNA939369_S_NODE_267_length_2041_cov_12.819614_g130_i0 | PRJNA939369 | 267 | 2041 | 12.819614 | 261.64832174 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3716 | 0 | NTclustered | gi|1847502554|gb|MT349585.1| | 1511083 | g130 | i0 | 99.51 | 98.5188633023028 | 2041 | 10 | 100 | 0 | 1 | 2041 | 2041 | 1 | Influenza D virus (D/bovine/Italy/188812-1/2017) hemagglutinin-esterase gene, complete cds | blastn | 201077 | 3718 | 0.999462076385153 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 9842171 | 9842171 | PRJNA939369_S_NODE_10288_length_420_cov_1.832853_g9871_i0 | PRJNA939369 | 10288 | 420 | 1.832853 | 7.6979826 | Picobirnavirus sp. | 1907787 | Viruses | Viruses | 339 | 2.77e-88 | NTclustered | gi|2071757898|gb|MW930290.1| | 1907787 | g9871 | i0 | 81.598 | 5.15238095238095 | 413 | 73 | 98 | 3 | 10 | 420 | 1150 | 1561 | MAG: Picobirnavirus sp. isolate XZ28 RNA-dependent RNA-polymerase gene, complete cds | blastn | 2164 | 339 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 11118266 | 11118266 | PRJNA939369_S_NODE_75549_length_241_cov_0.958333_g75132_i0 | PRJNA939369 | 75549 | 241 | 0.958333 | 2.30958253 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 122 | 1.6299999999999994e-23 | NTclustered | gi|2165834194|emb|OV195900.1| | 2697049 | g75132 | i0 | 96.053 | 29.8132780082988 | 76 | 1 | 31 | 2 | 5 | 79 | 30066 | 29992 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7185 | 122 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12393364 | 12393364 | PRJNA939369_S_NODE_10710_length_414_cov_3.533724_g10293_i0 | PRJNA939369 | 10710 | 414 | 3.533724 | 14.62961736 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10293 | i0 | 100 | 0.140096618357488 | 30 | 0 | 7 | 0 | 385 | 414 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 13668039 | 13668039 | PRJNA939369_S_NODE_49491_length_259_cov_0.994624_g49074_i0 | PRJNA939369 | 49491 | 259 | 0.994624 | 2.57607616 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 62.1 | 3.92e-5 | NTclustered | gi|2557633336|emb|OY694998.1| | 2697049 | g49074 | i0 | 97.222 | 1.78378378378378 | 36 | 1 | 14 | 0 | 7 | 42 | 19685 | 19650 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 462 | 62.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 14010035 | 14010035 | PRJNA939369_S_NODE_211_length_2346_cov_12.398592_g90_i0 | PRJNA939369 | 211 | 2346 | 12.398592 | 290.87096832 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 4294 | 0 | NTclustered | gi|1328406492|ref|NC_036616.1| | 1511083 | g90 | i0 | 99.702 | 99.5618073316283 | 2346 | 7 | 100 | 0 | 1 | 2346 | 12 | 2357 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 1 polymerase PB2 (PB2) gene, complete cds | blastn | 233572 | 4316 | 0.994902687673772 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 17492562 | 17492562 | PRJNA939369_S_NODE_24554_length_318_cov_1.800000_g24137_i0 | PRJNA939369 | 24554 | 318 | 1.8 | 5.724 | Porcine picobirnavirus | 442302 | Viruses | Viruses | 278 | 4.52e-70 | NTclustered | gi|2095880661|gb|MW978536.1| | 442302 | g24137 | i0 | 88.938 | 63.2421383647799 | 226 | 24 | 71 | 1 | 1 | 225 | 2667 | 2892 | MAG: Porcine picobirnavirus isolate 15217_NODE_84_len_2958_cov_626.749569 hypothetical protein and capsid protein-like gene, partial sequence | blastn | 20111 | 278 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Porcine picobirnavirus | ||
| 20041025 | 20041025 | PRJNA939369_S_NODE_42016_length_272_cov_2.216080_g41599_i0 | PRJNA939369 | 42016 | 272 | 2.21608 | 6.0277376 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g41599 | i0 | 100 | 0.213235294117647 | 30 | 0 | 11 | 0 | 243 | 272 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 21316247 | 21316247 | PRJNA939369_S_NODE_13997_length_379_cov_1.258170_g13580_i0 | PRJNA939369 | 13997 | 379 | 1.25817 | 4.7684643 | Stralarivirus lychnis | 3052754 | Viruses | Viruses | 281 | 4.23e-71 | NTclustered | gi|2500669232|ref|NC_078686.1| | 1676256 | g13580 | i0 | 82.5 | 3.83641160949868 | 320 | 56 | 84 | 0 | 19 | 338 | 1146 | 827 | Lychnis mottle virus isolate Andong segment RNA2, complete sequence | blastn | 1454 | 281 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Stralarivirus | Stralarivirus lychnis | ||
| 21316524 | 21316524 | PRJNA939369_S_NODE_55577_length_251_cov_0.865169_g55160_i0 | PRJNA939369 | 55577 | 251 | 0.865169 | 2.17157419 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 126 | 1.32e-24 | NTclustered | gi|2155043488|emb|OV016109.1| | 2697049 | g55160 | i0 | 96.154 | 28.9043824701195 | 78 | 1 | 30 | 2 | 2 | 77 | 30068 | 29991 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 7255 | 126 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 21316570 | 21316570 | PRJNA939369_S_NODE_61757_length_248_cov_0.880000_g61340_i0 | PRJNA939369 | 61757 | 248 | 0.88 | 2.1824 | Orthoflavivirus denguei | 3052464 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2126762592|gb|OL314736.1| | 11070 | g61340 | i0 | 100 | 0.67741935483871 | 28 | 0 | 11 | 0 | 57 | 84 | 9735 | 9762 | Dengue virus 4 isolate JBB-007, complete genome | blastn | 168 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Orthoflavivirus | Orthoflavivirus denguei | ||
| 21316707 | 21316707 | PRJNA939369_S_NODE_79837_length_213_cov_12.328571_g79420_i0 | PRJNA939369 | 79837 | 213 | 12.328571 | 26.25985623 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g79420 | i0 | 100 | 0.7981220657277 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Carnation latent virus isolate KL, complete genome | blastn | 170 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 22591253 | 22591253 | PRJNA939369_S_NODE_18578_length_345_cov_17.915441_g18161_i0 | PRJNA939369 | 18578 | 345 | 17.915441 | 61.80827145 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g18161 | i0 | 94.444 | 0.510144927536232 | 36 | 2 | 10 | 0 | 310 | 345 | 48 | 13 | Carnation latent virus isolate KL, complete genome | blastn | 176 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 23866633 | 23866633 | PRJNA939369_S_NODE_20759_length_334_cov_1.555556_g20342_i0 | PRJNA939369 | 20759 | 334 | 1.555556 | 5.19555704 | Penaeus vannamei solinvivirus | 2973956 | Viruses | Viruses | 484 | 2.6199999999999996e-132 | NTclustered | gi|2304762575|gb|OP265432.1| | 2973956 | g20342 | i0 | 92.814 | 30.3023952095808 | 334 | 24 | 100 | 0 | 1 | 334 | 4008 | 3675 | Penaeus vannamei solinvivirus isolate 20-905-APL polyprotein gene, complete cds | blastn | 10121 | 484 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Solinviviridae | Penaeus vannamei solinvivirus | |||
| 24207627 | 24207627 | PRJNA939369_S_NODE_219_length_2316_cov_13.310299_g94_i0 | PRJNA939369 | 219 | 2316 | 13.310299 | 308.26652484 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 4261 | 0 | NTclustered | gi|1707337734|gb|MN165245.1| | 1511083 | g94 | i0 | 99.87 | 99.5034542314335 | 2316 | 3 | 100 | 0 | 1 | 2316 | 2322 | 7 | Influenza D virus (D/bovine/Italy/12002-1/2018) segment 2 polymerase PB1 (PB1) gene, complete cds | blastn | 230450 | 4272 | 0.997425093632959 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 24207631 | 24207631 | PRJNA939369_S_NODE_239_length_2188_cov_13.160757_g109_i0 | PRJNA939369 | 239 | 2188 | 13.160757 | 287.95736316 | Deltainfluenzavirus | 1511083 | Viruses | Viruses | 3988 | 0 | NTclustered | gi|1328406498|ref|NC_036619.1| | 1511083 | g109 | i0 | 99.588 | 98.8423217550274 | 2186 | 9 | 99 | 0 | 3 | 2188 | 2 | 2187 | Influenza D virus (D/swine/Oklahoma/1334/2011) segment 3 polymerase 3 (P3) gene, complete cds | blastn | 216267 | 4026 | 0.990561351217089 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Deltainfluenzavirus | Deltainfluenzavirus | ||
| 25140423 | 25140423 | PRJNA939369_S_NODE_28400_length_305_cov_2.383621_g27983_i0 | PRJNA939369 | 28400 | 305 | 2.383621 | 7.27004405 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g27983 | i0 | 100 | 0.462295081967213 | 29 | 0 | 10 | 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 | ||
| 25140545 | 25140545 | PRJNA939369_S_NODE_48840_length_260_cov_1.053476_g48423_i0 | PRJNA939369 | 48840 | 260 | 1.053476 | 2.7390376 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 117 | 8.28e-22 | NTclustered | gi|2165837646|emb|OV197539.1| | 2697049 | g48423 | i0 | 93.671 | 34.55 | 79 | 3 | 30 | 2 | 3 | 80 | 29948 | 29871 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 8983 | 117 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 25482569 | 25482569 | PRJNA939369_S_NODE_11000_length_411_cov_1.594675_g10583_i0 | PRJNA939369 | 11000 | 411 | 1.594675 | 6.55411425 | Viruses | 10239 | Viruses | Viruses | 477 | 5.4999999999999985e-130 | NTclustered | gi|2677147979|gb|OR996055.1| | 2665152 | g10583 | i0 | 87.99 | 60.1849148418491 | 408 | 44 | 99 | 5 | 4 | 408 | 3713 | 3308 | MAG: Cnidium vein yellowing virus isolate Jinan segment RNA2, complete sequence | blastn | 24736 | 477 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Cnidium vein yellowing 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);;