contig_metadata
22 rows where bioproject = "PRJNA889065", tax_phylum = "Pisuviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 863340 | 863340 | PRJNA889065_S_NODE_201_length_1220_cov_14.244690_g161_i0 | PRJNA889065 | 201 | 1220 | 14.24469 | 173.785218 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.035 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g161 | i0 | 100 | 0.023770491803278702 | 29 | 0 | 2 | 0 | 1 | 29 | 57 | 85 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 4691843 | 4691843 | PRJNA889065_S_NODE_764_length_845_cov_6.548628_g651_i0 | PRJNA889065 | 764 | 845 | 6.548628 | 55.3359066 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.024 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g651 | i0 | 100 | 0.0343195266272189 | 29 | 0 | 3 | 0 | 817 | 845 | 85 | 57 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 5966566 | 5966566 | PRJNA889065_S_NODE_10925_length_290_cov_2.380567_g10687_i0 | PRJNA889065 | 10925 | 290 | 2.380567 | 6.9036443 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10687 | i0 | 100 | 0.196551724137931 | 29 | 0 | 10 | 0 | 262 | 290 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 5966685 | 5966685 | PRJNA889065_S_NODE_3525_length_481_cov_52.052511_g3296_i0 | PRJNA889065 | 3525 | 481 | 52.052511 | 250.37257791 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g3296 | i0 | 100 | 0.118503118503119 | 29 | 0 | 6 | 0 | 453 | 481 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 5966691 | 5966691 | PRJNA889065_S_NODE_3685_length_474_cov_4.742459_g3456_i0 | PRJNA889065 | 3685 | 474 | 4.742459 | 22.47925566 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g3456 | i0 | 100 | 0.120253164556962 | 29 | 0 | 6 | 0 | 446 | 474 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 8516169 | 8516169 | PRJNA889065_S_NODE_10367_length_297_cov_2.649606_g10129_i0 | PRJNA889065 | 10367 | 297 | 2.649606 | 7.86932982 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10129 | i0 | 100 | 0.195286195286195 | 30 | 0 | 10 | 0 | 268 | 297 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 8516303 | 8516303 | PRJNA889065_S_NODE_4487_length_438_cov_18.964557_g4251_i0 | PRJNA889065 | 4487 | 438 | 18.964557 | 83.064759660000007 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g4251 | i0 | 100 | 0.132420091324201 | 30 | 0 | 7 | 0 | 409 | 438 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 9791217 | 9791217 | PRJNA889065_S_NODE_11208_length_286_cov_6.403292_g10970_i0 | PRJNA889065 | 11208 | 286 | 6.403292 | 18.31341512 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10970 | i0 | 100 | 0.199300699300699 | 29 | 0 | 10 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 9791344 | 9791344 | PRJNA889065_S_NODE_4008_length_458_cov_17.486747_g3774_i0 | PRJNA889065 | 4008 | 458 | 17.486747 | 80.08930126 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g3774 | i0 | 100 | 0.126637554585153 | 30 | 0 | 7 | 0 | 1 | 30 | 13 | 42 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 13617025 | 13617025 | PRJNA889065_S_NODE_23971_length_198_cov_4.167742_g23733_i0 | PRJNA889065 | 23971 | 198 | 4.167742 | 8.25212916 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g23733 | i0 | 100 | 0.287878787878788 | 29 | 0 | 15 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 13617087 | 13617087 | PRJNA889065_S_NODE_5191_length_412_cov_7.113821_g4953_i0 | PRJNA889065 | 5191 | 412 | 7.113821 | 29.30894252 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.011 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g4953 | i0 | 100 | 0.138349514563107 | 29 | 0 | 7 | 0 | 384 | 412 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 14891287 | 14891287 | PRJNA889065_S_NODE_13772_length_260_cov_9.341014_g13534_i0 | PRJNA889065 | 13772 | 260 | 9.341014 | 24.2866364 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g13534 | i0 | 100 | 0.223076923076923 | 30 | 0 | 12 | 0 | 231 | 260 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 17441474 | 17441474 | PRJNA889065_S_NODE_1054_length_754_cov_11.876231_g910_i0 | PRJNA889065 | 1054 | 754 | 11.876231 | 89.54678174 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.021 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g910 | i0 | 100 | 0.0384615384615385 | 29 | 0 | 4 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 17441477 | 17441477 | PRJNA889065_S_NODE_11134_length_287_cov_3.840164_g10896_i0 | PRJNA889065 | 11134 | 287 | 3.840164 | 11.02127068 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10896 | i0 | 96.97 | 0.212543554006969 | 33 | 0 | 11 | 1 | 255 | 287 | 44 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 61 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18714759 | 18714759 | PRJNA889065_S_NODE_3435_length_485_cov_85.226244_g3206_i0 | PRJNA889065 | 3435 | 485 | 85.226244 | 413.3472834 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g3206 | i0 | 100 | 0.117525773195876 | 29 | 0 | 6 | 0 | 457 | 485 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 18714798 | 18714798 | PRJNA889065_S_NODE_815_length_827_cov_3.339286_g697_i0 | PRJNA889065 | 815 | 827 | 3.339286 | 27.61589522 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.006 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g697 | i0 | 100 | 0.0362756952841596 | 30 | 0 | 4 | 0 | 798 | 827 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 30 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 19990062 | 19990062 | PRJNA889065_S_NODE_7056_length_356_cov_1.766773_g6818_i0 | PRJNA889065 | 7056 | 356 | 1.766773 | 6.28971188 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g6818 | i0 | 100 | 0.162921348314607 | 30 | 0 | 8 | 0 | 1 | 30 | 13 | 42 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22540091 | 22540091 | PRJNA889065_S_NODE_10358_length_297_cov_2.952756_g10120_i0 | PRJNA889065 | 10358 | 297 | 2.952756 | 8.76968532 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g10120 | i0 | 100 | 0.195286195286195 | 30 | 0 | 10 | 0 | 268 | 297 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22540103 | 22540103 | PRJNA889065_S_NODE_12178_length_275_cov_32.866379_g11940_i0 | PRJNA889065 | 12178 | 275 | 32.866379 | 90.38254225 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g11940 | i0 | 100 | 0.210909090909091 | 30 | 0 | 11 | 0 | 1 | 30 | 13 | 42 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22540156 | 22540156 | PRJNA889065_S_NODE_20718_length_214_cov_1.345029_g20480_i0 | PRJNA889065 | 20718 | 214 | 1.345029 | 2.87836206 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g20480 | i0 | 100 | 0.266355140186916 | 29 | 0 | 14 | 0 | 1 | 29 | 13 | 41 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 22540192 | 22540192 | PRJNA889065_S_NODE_2598_length_538_cov_40.703030_g2379_i0 | PRJNA889065 | 2598 | 538 | 40.70303 | 218.9823014 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 60.2 | 3.16e-4 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g2379 | i0 | 100 | 0.113382899628253 | 32 | 0 | 6 | 0 | 1 | 32 | 56 | 87 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 61 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 23815553 | 23815553 | PRJNA889065_S_NODE_2779_length_526_cov_23.840580_g2556_i0 | PRJNA889065 | 2779 | 526 | 23.84058 | 125.4014508 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g2556 | i0 | 100 | 0.0551330798479087 | 29 | 0 | 6 | 0 | 498 | 526 | 41 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus |
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);;