contig_metadata
23 rows where bioproject = "PRJNA939369", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3465134 | 3465134 | PRJNA939369_S_NODE_33223_length_292_cov_1.100457_g32806_i0 | PRJNA939369 | 33223 | 292 | 1.100457 | 3.21333444 | Camellia sinensis secoviridae virus 1 | 2957729 | Viruses | Viruses | 199 | 7.429999999999999e-57 | NR | USS99170.1 | 2957729 | g32806 | i0 | 95.8 | 6.9041095890411 | 96 | 4 | 98.6 | 0 | 3 | 290 | 1779 | 1874 | USS99170.1 polyprotein [Camellia sinensis secoviridae virus 1] | diamond | 2016 | 199 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Camellia sinensis secoviridae virus 1 | |||
| 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 | ||
| 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 | ||
| 16217224 | 16217224 | PRJNA939369_S_NODE_2453_length_716_cov_1.819596_g2069_i0 | PRJNA939369 | 2453 | 716 | 1.819596 | 13.02830736 | Picobirnavirus sp. | 1907787 | Viruses | Viruses | 370 | 2.84e-123 | NR | QXV86716.1 | 1907787 | g2069 | i0 | 75.2 | 0.99720670391061506 | 238 | 59 | 99.7 | 0 | 714 | 1 | 130 | 367 | QXV86716.1 MAG: RNA-dependent RNA-polymerase [Picobirnavirus sp.] | diamond | 714 | 370 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 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 | |||
| 21316231 | 21316231 | PRJNA939369_S_NODE_1117_length_990_cov_2.451472_g809_i0 | PRJNA939369 | 1117 | 990 | 2.451472 | 24.2695728 | Orthopicobirnavirus | 2948851 | Viruses | Viruses | 425 | 1.2599999999999996e-143 | NR | USE08238.1 | 1907787 | g809 | i0 | 63.5 | 4.85151515151515 | 329 | 115 | 99.1 | 2 | 981 | 1 | 124 | 449 | USE08238.1 MAG: putative RNA-dependent RNA polymerase, partial [Picobirnavirus sp.] | diamond | 4803 | 429 | 0.990675990675991 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Picobirnavirus sp. | ||
| 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 | ||
| 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 | |||
| 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 | ||||
| 27031900 | 27031900 | PRJNA939369_S_NODE_72902_length_242_cov_2.201183_g72485_i0 | PRJNA939369 | 72902 | 242 | 2.201183 | 5.32686286 | Orthopicobirnavirus | 2948851 | Viruses | Viruses | 122 | 1.25e-30 | NR | UAW00543.1 | 442302 | g72485 | i0 | 75.3 | 1.92148760330579 | 77 | 19 | 95.5 | 0 | 1 | 231 | 44 | 120 | UAW00543.1 MAG: RNA-dependent RNA polymerase [Porcine picobirnavirus] | diamond | 465 | 123 | 0.991869918699187 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Porcine picobirnavirus | ||
| 28098810 | 28098810 | PRJNA939369_S_NODE_33225_length_292_cov_1.073059_g32808_i0 | PRJNA939369 | 33225 | 292 | 1.073059 | 3.13333228 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 61.2 | 9.35e-9 | NR | AVX53416.1 | 2161795 | g32808 | i0 | 46.6 | 0.75 | 73 | 39 | 75 | 0 | 68 | 286 | 121 | 193 | AVX53416.1 putative ORF1 [Marmot picobirnavirus] | diamond | 219 | 61.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 29930423 | 29930423 | PRJNA939369_S_NODE_20291_length_336_cov_2.148289_g19874_i0 | PRJNA939369 | 20291 | 336 | 2.148289 | 7.21825104 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 94.4 | 3.9e-21 | NR | AVX53416.1 | 2161795 | g19874 | i0 | 63.8 | 0.714285714285714 | 80 | 29 | 71.4 | 0 | 37 | 276 | 14 | 93 | AVX53416.1 putative ORF1 [Marmot picobirnavirus] | diamond | 240 | 94.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 30909811 | 30909811 | PRJNA939369_S_NODE_2654_length_694_cov_1.975845_g2260_i0 | PRJNA939369 | 2654 | 694 | 1.975845 | 13.7123643 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 102 | 3.96e-21 | NR | AVX53395.1 | 2161795 | g2260 | i0 | 35.8 | 2.48991354466859 | 162 | 91 | 70 | 2 | 497 | 12 | 44 | 192 | AVX53395.1 putative capsid [Marmot picobirnavirus] | diamond | 1728 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 30948484 | 30948484 | PRJNA939369_S_NODE_6854_length_484_cov_1.423358_g6437_i0 | PRJNA939369 | 6854 | 484 | 1.423358 | 6.88905272 | Stralarivirus | 2948915 | Viruses | Viruses | 184 | 1.06e-50 | NR | BBG58107.1 | 1676255 | g6437 | i0 | 95.7 | 2.87603305785124 | 93 | 4 | 57.6 | 0 | 484 | 206 | 450 | 542 | BBG58107.1 polyprotein, partial [Cnidium vein yellowing virus 2] | diamond | 1392 | 184 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Cnidium vein yellowing virus 2 | ||||
| 31320476 | 31320476 | PRJNA939369_S_NODE_1035_length_1027_cov_1.708595_g749_i0 | PRJNA939369 | 1035 | 1027 | 1.708595 | 17.54727065 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 319 | 2.15e-102 | NR | AVX53417.1 | 2161795 | g749 | i0 | 49.6 | 0.984420642648491 | 337 | 160 | 96.4 | 5 | 3 | 992 | 115 | 448 | AVX53417.1 putative capsid, partial [Marmot picobirnavirus] | diamond | 1011 | 319 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus | ||
| 31889823 | 31889823 | PRJNA939369_S_NODE_197_length_2435_cov_6.287045_g83_i0 | PRJNA939369 | 197 | 2435 | 6.287045 | 153.08954575 | Marmot picobirnavirus | 2161795 | Viruses | Viruses | 414 | 4.68e-133 | NR | AVX53417.1 | 2161795 | g83 | i0 | 48.2 | 0.590143737166324 | 479 | 221 | 57.4 | 9 | 1399 | 2 | 2 | 466 | AVX53417.1 putative capsid, partial [Marmot picobirnavirus] | diamond | 1437 | 414 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Orthopicobirnavirus | Marmot picobirnavirus |
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);;