contig_metadata
15 rows where bioproject = "PRJNA498309", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3030985 | 3030985 | PRJNA498309_P_NODE_105563_length_181_cov_40.020833_g103414_i0 | PRJNA498309 | 105563 | 181 | 40.020833 | 72.43770773 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g103414 | i0 | 100 | 0.160220994475138 | 29 | 0 | 16 | 0 | 1 | 29 | 58 | 86 | 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 | ||
| 8134377 | 8134377 | PRJNA498309_P_NODE_74347_length_270_cov_1.708155_g72198_i0 | PRJNA498309 | 74347 | 270 | 1.708155 | 4.6120185 | Sclerotinia sclerotiorum hypovirus 9 | 2879905 | Viruses | Viruses | 388 | 1.66e-103 | NTclustered | gi|2111886846|gb|MW454884.1| | 2879905 | g72198 | i0 | 92.62 | 1.0037037037037 | 271 | 19 | 100 | 1 | 1 | 270 | 9991 | 10261 | Sclerotinia sclerotiorum hypovirus 9 isolate GB375-1 polyprotein gene, complete cds | blastn | 271 | 388 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Sclerotinia sclerotiorum hypovirus 9 | ||
| 9408940 | 9408940 | PRJNA498309_P_NODE_50528_length_373_cov_7.636905_g48382_i0 | PRJNA498309 | 50528 | 373 | 7.636905 | 28.485655650000002 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 52.8 | 0.035 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g48382 | i0 | 100 | 0.0750670241286863 | 28 | 0 | 8 | 0 | 346 | 373 | 42 | 15 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 9409303 | 9409303 | PRJNA498309_P_NODE_72148_length_277_cov_44.712500_g69999_i0 | PRJNA498309 | 72148 | 277 | 44.7125 | 123.853625 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.007 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g69999 | i0 | 100 | 0.104693140794224 | 29 | 0 | 10 | 0 | 1 | 29 | 58 | 86 | 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 | ||
| 13234688 | 13234688 | PRJNA498309_P_NODE_48711_length_383_cov_8.664740_g46573_i0 | PRJNA498309 | 48711 | 383 | 8.66474 | 33.1859542 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 52.8 | 0.037 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g46573 | i0 | 100 | 0.0731070496083551 | 28 | 0 | 7 | 0 | 356 | 383 | 86 | 59 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 15784571 | 15784571 | PRJNA498309_S_NODE_18553_length_489_cov_11.693833_g16482_i0 | PRJNA498309 | 18553 | 489 | 11.693833 | 57.18284337 | Sclerotinia sclerotiorum hypovirus 9 | 2879905 | Viruses | Viruses | 614 | 4.849999999999999e-171 | NTclustered | gi|2111886846|gb|MW454884.1| | 2879905 | g16482 | i0 | 91.667 | 0.907975460122699 | 444 | 36 | 91 | 1 | 26 | 468 | 10268 | 9825 | Sclerotinia sclerotiorum hypovirus 9 isolate GB375-1 polyprotein gene, complete cds | blastn | 444 | 614 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Sclerotinia sclerotiorum hypovirus 9 | ||
| 15784877 | 15784877 | PRJNA498309_S_NODE_30693_length_293_cov_1.461240_g28525_i0 | PRJNA498309 | 30693 | 293 | 1.46124 | 4.2814332 | Nepovirus alphaparis | 3431076 | Viruses | Viruses | 52.8 | 0.027 | NTclustered | gi|2392416652|gb|OP374158.1| | 3002895 | g28525 | i0 | 100 | 0.0955631399317406 | 28 | 0 | 10 | 0 | 2 | 29 | 1 | 28 | Paris nepovirus 1 isolate YLJ segment RNA 1, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus alphaparis | ||
| 16411849 | 16411849 | PRJNA498309_P_NODE_81833_length_244_cov_157.347826_g79684_i0 | PRJNA498309 | 81833 | 244 | 157.347826 | 383.92869544 | Norovirus | 142786 | Viruses | Viruses | 298 | 2.56e-76 | NTclustered | gi|436410|emb|X76716.1| | 11974 | g79684 | i0 | 100 | 89.2868852459016 | 161 | 0 | 90 | 0 | 59 | 219 | 1428 | 1268 | Caliciviridae mRNA for capsid protein, ORF2 and ORF3 | blastn | 21786 | 298 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | ||||
| 20882867 | 20882867 | PRJNA498309_P_NODE_49557_length_379_cov_2.324561_g47416_i0 | PRJNA498309 | 49557 | 379 | 2.324561 | 8.81008619 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.003 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g47416 | i0 | 100 | 0.153034300791557 | 30 | 0 | 8 | 0 | 350 | 379 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 20883586 | 20883586 | PRJNA498309_P_NODE_96117_length_203_cov_21.560241_g93968_i0 | PRJNA498309 | 96117 | 203 | 21.560241 | 43.76728923 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g93968 | i0 | 100 | 0.280788177339901 | 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 | |||
| 20884038 | 20884038 | PRJNA498309_S_NODE_23017_length_400_cov_165.101370_g20865_i0 | PRJNA498309 | 23017 | 400 | 165.10137 | 660.40548 | Sclerotinia sclerotiorum hypovirus 9 | 2879905 | Viruses | Viruses | 451 | 3.2300000000000004e-122 | NTclustered | gi|2111886846|gb|MW454884.1| | 2879905 | g20865 | i0 | 89.773 | 0.88 | 352 | 36 | 88 | 0 | 12 | 363 | 10616 | 10967 | Sclerotinia sclerotiorum hypovirus 9 isolate GB375-1 polyprotein gene, complete cds | blastn | 352 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Hypovirus | Sclerotinia sclerotiorum hypovirus 9 | ||
| 23433554 | 23433554 | PRJNA498309_P_NODE_62259_length_317_cov_21.560714_g60111_i0 | PRJNA498309 | 62259 | 317 | 21.560714 | 68.34746338 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.008 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g60111 | i0 | 100 | 0.17981072555205 | 29 | 0 | 9 | 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 | |||
| 23433950 | 23433950 | PRJNA498309_P_NODE_88719_length_223_cov_86.059140_g86570_i0 | PRJNA498309 | 88719 | 223 | 86.05914 | 191.9118822 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g86570 | i0 | 100 | 0.130044843049327 | 29 | 0 | 13 | 0 | 195 | 223 | 86 | 58 | 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 | ||
| 24707177 | 24707177 | PRJNA498309_P_NODE_74140_length_270_cov_14.287554_g71991_i0 | PRJNA498309 | 74140 | 270 | 14.287554 | 38.5763958 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g71991 | i0 | 100 | 0.21481481481481501 | 30 | 0 | 11 | 0 | 241 | 270 | 42 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 30961764 | 30961764 | PRJNA498309_P_NODE_101854_length_190_cov_1.045752_g99705_i0 | PRJNA498309 | 101854 | 190 | 1.045752 | 1.9869288 | Patatavirales sp. | 2809655 | Viruses | Viruses | 65.5 | 1.72e-10 | NR | WRQ64747.1 | 2809655 | g99705 | i0 | 57.7 | 3.94736842105263 | 52 | 22 | 82.1 | 0 | 21 | 176 | 165 | 216 | WRQ64747.1 polyprotein 2 [Patatavirales sp.] | diamond | 750 | 65.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Patatavirales | Patatavirales sp. |
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);;