contig_metadata
11 rows where bioproject = "PRJNA382357", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1679477 | 1679477 | PRJNA382357_P_NODE_93502_length_249_cov_3.542553_g92763_i0 | PRJNA382357 | 93502 | 249 | 3.542553 | 8.82095697 | Qianjiang picobirna-like virus 2 | 3348870 | Viruses | Viruses | 324 | 4.33e-84 | NTclustered | gi|2806502550|gb|PQ054798.1| | 3348870 | g92763 | i0 | 95.98 | 200.345381526104 | 199 | 8 | 99 | 0 | 51 | 249 | 1054 | 1252 | MAG: Qianjiang picobirna-like virus 2 isolate QJ3MS693 genomic sequence | blastn | 49886 | 324 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Qianjiang picobirna-like virus 2 | |||
| 2955386 | 2955386 | PRJNA382357_P_NODE_99103_length_243_cov_1.659341_g98364_i0 | PRJNA382357 | 99103 | 243 | 1.659341 | 4.03219863 | Shenzhen dicistro-like virus | 2789378 | Viruses | Viruses | 263 | 9.3e-66 | NTclustered | gi|1940198121|gb|MT757492.1| | 2789378 | g98364 | i0 | 95.706 | 2.46502057613169 | 163 | 6 | 100 | 1 | 1 | 162 | 6368 | 6530 | Shenzhen dicistro-like virus strain CHNdp-2 polyprotein gene, complete cds | blastn | 599 | 263 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Shenzhen dicistro-like virus | |||
| 10607511 | 10607511 | PRJNA382357_P_NODE_36469_length_377_cov_18.322785_g35730_i0 | PRJNA382357 | 36469 | 377 | 18.322785 | 69.07689945 | uncultured partitivirus | 1075819 | Viruses | Viruses | 292 | 1.94e-74 | NTclustered | gi|379055516|emb|HE579553.1| | 1075819 | g35730 | i0 | 93.814 | 7.96021220159151 | 194 | 12 | 90 | 0 | 1 | 194 | 415 | 608 | Uncultured partitivirus genomic RNA containing putative CP, contig 87Pv1_cloning_4 | blastn | 3001 | 292 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | uncultured partitivirus | |||
| 19528936 | 19528936 | PRJNA382357_P_NODE_154816_length_202_cov_1.524823_g154077_i0 | PRJNA382357 | 154816 | 202 | 1.524823 | 3.08014246 | Betacoronavirus hongkongense | 3433758 | Viruses | Viruses | 206 | 1.28e-48 | NTclustered | gi|2431686138|gb|ON136172.1| | 290028 | g154077 | i0 | 100 | 102.475247524752 | 111 | 0 | 100 | 0 | 1 | 111 | 29594 | 29484 | Human coronavirus HKU1 isolate HKU1A_4, partial genome | blastn | 20700 | 206 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus hongkongense | ||
| 20805566 | 20805566 | PRJNA382357_P_NODE_5337_length_857_cov_2.032663_g4719_i0 | PRJNA382357 | 5337 | 857 | 2.032663 | 17.41992191 | Diplodia fraxini partitivirus 1 | 3073354 | Viruses | Viruses | 466 | 6.279999999999998e-160 | NR | WMY82295.1 | 3073354 | g4719 | i0 | 77.3 | 6.78763127187865 | 277 | 63 | 97 | 0 | 25 | 855 | 179 | 455 | WMY82295.1 RdRP [Diplodia fraxini partitivirus 1] | diamond | 5817 | 466 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Diplodia fraxini partitivirus 1 | |||
| 27328014 | 27328014 | PRJNA382357_P_NODE_102343_length_239_cov_466.264045_g101604_i0 | PRJNA382357 | 102343 | 239 | 466.264045 | 1114.37106755 | Fusarium solani virus 1 | 1511847 | Viruses | Viruses | 73.2 | 6.07e-13 | NR | NP_624351.1 | 1511847 | g101604 | i0 | 64.8 | 0.677824267782427 | 54 | 19 | 67.8 | 0 | 70 | 231 | 182 | 235 | NP_624351.1 capsid protein [Fusarium solani virus 1] | diamond | 162 | 73.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Gammapartitivirus | Gammapartitivirus fusarii | ||
| 28338378 | 28338378 | PRJNA382357_P_NODE_120886_length_222_cov_2.639752_g120147_i0 | PRJNA382357 | 120886 | 222 | 2.639752 | 5.86024944 | Iflaviridae sp. | 1955145 | Viruses | Viruses | 58.9 | 5.61e-8 | NR | XCO48851.1 | 1955145 | g120147 | i0 | 40.3 | 0.905405405405405 | 67 | 40 | 90.5 | 0 | 2 | 202 | 65 | 131 | XCO48851.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.] | diamond | 201 | 58.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae sp. | |||
| 29822142 | 29822142 | PRJNA382357_P_NODE_50751_length_326_cov_1.724528_g50012_i0 | PRJNA382357 | 50751 | 326 | 1.724528 | 5.62196128 | Sophora japonica powdery mildew-associated partitivirus | 1891704 | Viruses | Viruses | 184 | 2.86e-53 | NR | YP_009272945.1 | 1891704 | g50012 | i0 | 79.4 | 2.95398773006135 | 107 | 22 | 98.5 | 0 | 4 | 324 | 128 | 234 | YP_009272945.1 putative coat protein [Sophora japonica powdery mildew-associated partitivirus] | diamond | 963 | 184 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Sophora japonica powdery mildew-associated partitivirus | |||
| 29980358 | 29980358 | PRJNA382357_P_NODE_74811_length_275_cov_1.518692_g74072_i0 | PRJNA382357 | 74811 | 275 | 1.518692 | 4.176403 | Rosellinia necatrix partitivirus 12 | 2699380 | Viruses | Viruses | 113 | 6.240000000000001e-27 | NR | BBU59834.1 | 2699380 | g74072 | i0 | 62.5 | 0.96 | 88 | 33 | 96 | 0 | 269 | 6 | 445 | 532 | BBU59834.1 capsid protein [Rosellinia necatrix partitivirus 12] | diamond | 264 | 113 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Rosellinia necatrix partitivirus 12 | |||
| 30485901 | 30485901 | PRJNA382357_P_NODE_69553_length_284_cov_1.165919_g68814_i0 | PRJNA382357 | 69553 | 284 | 1.165919 | 3.31120996 | Rhizoctonia cerealis hypovirus | 3068667 | Viruses | Viruses | 95.1 | 2.43e-20 | NR | WMI40041.1 | 3068667 | g68814 | i0 | 49 | 1.01408450704225 | 96 | 46 | 99.3 | 2 | 1 | 282 | 1017 | 1111 | WMI40041.1 MAG: hypothetical protein [Rhizoctonia cerealis hypovirus] | diamond | 288 | 95.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Hypoviridae | Rhizoctonia cerealis hypovirus | |||
| 32558460 | 32558460 | PRJNA382357_P_NODE_83999_length_261_cov_2.650000_g83260_i0 | PRJNA382357 | 83999 | 261 | 2.65 | 6.9165 | Viruses | 10239 | Viruses | Viruses | 57.4 | 3.3e-7 | NR | XCO48758.1 | 1955145 | g83260 | i0 | 48.2 | 1.93103448275862 | 56 | 28 | 63.2 | 1 | 3 | 167 | 226 | 281 | XCO48758.1 MAG: putative ORF1 protein, partial [Iflaviridae sp.] | diamond | 504 | 57.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflaviridae 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);;