contig_metadata
21 rows where bioproject = "PRJEB29441" and tax_phylum = "Kitrinoviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1301086 | 1301086 | PRJEB29441_P_NODE_47422_length_161_cov_0.910714_g46981_i0 | PRJEB29441 | 47422 | 161 | 0.910714 | 1.46624954 | Potexvirus pepini | 3433856 | Viruses | Viruses | 298 | 1.56e-76 | NTclustered | gi|1421680372|gb|MH550178.1| | 112229 | g46981 | i0 | 100 | 100 | 161 | 0 | 100 | 0 | 1 | 161 | 84 | 244 | Pepino mosaic virus isolate AG17-12b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 16100 | 298 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3852868 | 3852868 | PRJEB29441_P_NODE_39924_length_166_cov_1.452991_g39483_i0 | PRJEB29441 | 39924 | 166 | 1.452991 | 2.41196506 | Carlavirus sigmasolani | 3427796 | Viruses | Viruses | 302 | 1.2500000000000001e-77 | NTclustered | gi|1594663021|gb|MH937416.1| | 12169 | g39483 | i0 | 99.398 | 86.7409638554217 | 166 | 1 | 100 | 0 | 1 | 166 | 1325 | 1490 | Potato virus S isolate PvS-W13-136, complete genome | blastn | 14399 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus sigmasolani | ||
| 5129033 | 5129033 | PRJEB29441_P_NODE_36005_length_174_cov_1.240000_g35564_i0 | PRJEB29441 | 36005 | 174 | 1.24 | 2.1576 | Tolivirales sp. | 2809914 | Viruses | Viruses | 300 | 4.73e-77 | NTclustered | gi|2647550279|gb|OR843880.1| | 2809914 | g35564 | i0 | 97.701 | 1 | 174 | 4 | 100 | 0 | 1 | 174 | 618 | 445 | Tolivirales sp. strain MR233-17E/17828 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 174 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 12780033 | 12780033 | PRJEB29441_P_NODE_27111_length_201_cov_4.210526_g26670_i0 | PRJEB29441 | 27111 | 201 | 4.210526 | 8.46315726 | Hubei sediment luteo-like virus 2 | 2933247 | Viruses | Viruses | 180 | 7.69e-41 | NTclustered | gi|2171145464|gb|MZ218404.1| | 2933247 | g26670 | i0 | 82.915 | 1.98009950248756 | 199 | 34 | 99 | 0 | 3 | 201 | 1290 | 1488 | MAG: Hubei sediment luteo-like virus 2 isolate 84-k141_114889 hypothetical protein 1 and hypothetical protein 2 genes, complete cds; and hypothetical protein 3 gene, partial cds | blastn | 398 | 180 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Hubei sediment luteo-like virus 2 | ||||
| 14054750 | 14054750 | PRJEB29441_P_NODE_32312_length_184_cov_1.511111_g31871_i0 | PRJEB29441 | 32312 | 184 | 1.511111 | 2.78044424 | Tolivirales sp. | 2809914 | Viruses | Viruses | 302 | 1.41e-77 | NTclustered | gi|2647550279|gb|OR843880.1| | 2809914 | g31871 | i0 | 96.196 | 1.6304347826087 | 184 | 7 | 100 | 0 | 1 | 184 | 471 | 288 | Tolivirales sp. strain MR233-17E/17828 RNA-dependent RNA polymerase and hypothetical protein genes, partial cds | blastn | 300 | 302 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 16603694 | 16603694 | PRJEB29441_P_NODE_7674_length_418_cov_3.498645_g7235_i0 | PRJEB29441 | 7674 | 418 | 3.498645 | 14.6243361 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 222 | 2.9e-53 | NTclustered | gi|2171145498|gb|MZ218414.1| | 1955165 | g7235 | i0 | 77.573 | 4.48086124401914 | 379 | 77 | 90 | 8 | 44 | 418 | 1941 | 2315 | MAG: Luteoviridae sp. isolate 248-k141_241782 genomic sequence | blastn | 1873 | 222 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 19151987 | 19151987 | PRJEB29441_P_NODE_26016_length_206_cov_1.547771_g25575_i0 | PRJEB29441 | 26016 | 206 | 1.547771 | 3.18840826 | Reagent-associated tombus-like virus 3 | 2875820 | Viruses | Viruses | 368 | 1.57e-97 | NTclustered | gi|2094552978|gb|MZ824227.1| | 2875820 | g25575 | i0 | 99.029 | 1 | 206 | 1 | 100 | 1 | 1 | 206 | 630 | 834 | Reagent-associated tombus-like virus 3 isolate 5 replicase-like gene, partial sequence | blastn | 206 | 368 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Reagent-associated tombus-like virus 3 | |||
| 26837028 | 26837028 | PRJEB29441_P_NODE_18121_length_252_cov_2.142857_g17680_i0 | PRJEB29441 | 18121 | 252 | 2.142857 | 5.39999964 | Orthornavirae | 2732396 | Viruses | Viruses | 72.8 | 1.09e-12 | NR | XII42506.1 | 1955165 | g17680 | i0 | 81.1 | 1.76190476190476 | 37 | 7 | 44 | 0 | 250 | 140 | 1065 | 1101 | XII42506.1 MAG: RNA-dependent RNA polymerase [Luteoviridae sp.] | diamond | 444 | 72.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 26906698 | 26906698 | PRJEB29441_P_NODE_39742_length_166_cov_2.273504_g39301_i0 | PRJEB29441 | 39742 | 166 | 2.273504 | 3.77401664 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 102 | 3.6499999999999996e-24 | NR | UHS71944.1 | 1955165 | g39301 | i0 | 80 | 5.96385542168675 | 55 | 11 | 99.4 | 0 | 166 | 2 | 57 | 111 | UHS71944.1 MAG: hypothetical protein 3 [Luteoviridae sp.] | diamond | 990 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 27001397 | 27001397 | PRJEB29441_P_NODE_28622_length_196_cov_1.278912_g28181_i0 | PRJEB29441 | 28622 | 196 | 1.278912 | 2.50666752 | Ginkgo biloba tombusvirus | 2739248 | Viruses | Viruses | 127 | 4.81e-33 | NR | QKI28841.1 | 2739248 | g28181 | i0 | 93.8 | 0.994897959183674 | 65 | 4 | 99.5 | 0 | 195 | 1 | 345 | 409 | QKI28841.1 hypothetical protein 2 [Ginkgo biloba tombusvirus] | diamond | 195 | 127 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Ginkgo biloba tombusvirus | ||
| 28549386 | 28549386 | PRJEB29441_P_NODE_38107_length_168_cov_2.142857_g37666_i0 | PRJEB29441 | 38107 | 168 | 2.142857 | 3.59999976 | Tolivirales sp. | 2809914 | Viruses | Viruses | 50.8 | 1.91e-5 | NR | WRQ65695.1 | 2809914 | g37666 | i0 | 78.6 | 0.5 | 28 | 6 | 50 | 0 | 84 | 1 | 76 | 103 | WRQ65695.1 structural protein [Tolivirales sp.] | diamond | 84 | 50.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 28738636 | 28738636 | PRJEB29441_P_NODE_24407_length_213_cov_2.231707_g23966_i0 | PRJEB29441 | 24407 | 213 | 2.231707 | 4.75353591 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 90.5 | 3.94e-19 | NR | UHS72003.1 | 1955165 | g23966 | i0 | 62.3 | 0.971830985915493 | 69 | 21 | 97.2 | 1 | 210 | 4 | 590 | 653 | UHS72003.1 MAG: RNA-dependent RNA polymerase, partial [Luteoviridae sp.] | diamond | 207 | 90.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 29023146 | 29023146 | PRJEB29441_P_NODE_38088_length_168_cov_2.369748_g37647_i0 | PRJEB29441 | 38088 | 168 | 2.369748 | 3.98117664 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 72.4 | 4.13e-13 | NR | UHS71971.1 | 1955165 | g37647 | i0 | 64.3 | 1 | 56 | 20 | 100 | 0 | 1 | 168 | 224 | 279 | UHS71971.1 MAG: hypothetical protein 3 [Luteoviridae sp.] | diamond | 168 | 72.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 29875395 | 29875395 | PRJEB29441_P_NODE_48111_length_157_cov_2.472222_g47670_i0 | PRJEB29441 | 48111 | 157 | 2.472222 | 3.88138854 | Qianjiang noda-like virus 174 | 3348550 | Viruses | Viruses | 60.5 | 6.2e-9 | NR | XHA86202.1 | 3348550 | g47670 | i0 | 60 | 1.81528662420382 | 45 | 18 | 86 | 0 | 137 | 3 | 323 | 367 | XHA86202.1 MAG: polyprotein [Qianjiang noda-like virus 174] | diamond | 285 | 60.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Qianjiang noda-like virus 174 | |||
| 30033376 | 30033376 | PRJEB29441_P_NODE_13411_length_301_cov_1.730159_g12970_i0 | PRJEB29441 | 13411 | 301 | 1.730159 | 5.20777859 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 93.2 | 1.46e-19 | NR | UHS71965.1 | 1955165 | g12970 | i0 | 44.4 | 0.98671096345515 | 99 | 54 | 98.7 | 1 | 1 | 297 | 175 | 272 | UHS71965.1 MAG: hypothetical protein 1 [Luteoviridae sp.] | diamond | 297 | 93.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 30696651 | 30696651 | PRJEB29441_P_NODE_35394_length_175_cov_2.507937_g34953_i0 | PRJEB29441 | 35394 | 175 | 2.507937 | 4.38888975 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 45.1 | 0.00212 | NR | UHS71986.1 | 1955165 | g34953 | i0 | 44.9 | 0.84 | 49 | 26 | 84 | 1 | 164 | 18 | 96 | 143 | UHS71986.1 MAG: hypothetical protein 2 [Luteoviridae sp.] | diamond | 147 | 45.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 31297159 | 31297159 | PRJEB29441_P_NODE_36715_length_172_cov_1.479675_g36274_i0 | PRJEB29441 | 36715 | 172 | 1.479675 | 2.545041 | Ginkgo biloba tombusvirus | 2739248 | Viruses | Viruses | 90.1 | 2.44e-19 | NR | QKI28841.1 | 2739248 | g36274 | i0 | 75.4 | 0.994186046511628 | 57 | 14 | 99.4 | 0 | 1 | 171 | 33 | 89 | QKI28841.1 hypothetical protein 2 [Ginkgo biloba tombusvirus] | diamond | 171 | 90.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Ginkgo biloba tombusvirus | ||
| 31550451 | 31550451 | PRJEB29441_P_NODE_16456_length_267_cov_1.403670_g16015_i0 | PRJEB29441 | 16456 | 267 | 1.40367 | 3.7477989 | Luteoviridae sp. | 1955165 | Viruses | Viruses | 115 | 6.1e-29 | NR | UHS71954.1 | 1955165 | g16015 | i0 | 71.6 | 3.67415730337079 | 81 | 23 | 91 | 0 | 244 | 2 | 28 | 108 | UHS71954.1 MAG: hypothetical protein 2 [Luteoviridae sp.] | diamond | 981 | 115 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Luteoviridae sp. | ||||
| 31581989 | 31581989 | PRJEB29441_P_NODE_39976_length_166_cov_1.307692_g39535_i0 | PRJEB29441 | 39976 | 166 | 1.307692 | 2.17076872 | Ginkgo biloba tombusvirus | 2739248 | Viruses | Viruses | 106 | 2.11e-25 | NR | QKI28841.1 | 2739248 | g39535 | i0 | 88.9 | 0.975903614457831 | 54 | 6 | 97.6 | 0 | 3 | 164 | 77 | 130 | QKI28841.1 hypothetical protein 2 [Ginkgo biloba tombusvirus] | diamond | 162 | 106 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Ginkgo biloba tombusvirus | ||
| 31644950 | 31644950 | PRJEB29441_P_NODE_10377_length_350_cov_2.425249_g9936_i0 | PRJEB29441 | 10377 | 350 | 2.425249 | 8.4883715 | Forni cryoconite toluca-like virus 2 | 3367771 | Viruses | Viruses | 140 | 2.93e-39 | NR | XHY08966.1 | 3367771 | g9936 | i0 | 56.5 | 0.985714285714286 | 115 | 50 | 98.6 | 0 | 348 | 4 | 92 | 206 | XHY08966.1 MAG: RNA-dependent RNA polymerase [Forni cryoconite toluca-like virus 2] | diamond | 345 | 140 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Forni cryoconite toluca-like virus 2 | |||||
| 31834704 | 31834704 | PRJEB29441_P_NODE_32877_length_182_cov_2.624060_g32436_i0 | PRJEB29441 | 32877 | 182 | 2.62406 | 4.7757892 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 60.5 | 9.08e-9 | NR | XHA86821.1 | 3347850 | g32436 | i0 | 44.1 | 1.92857142857143 | 59 | 33 | 97.3 | 0 | 4 | 180 | 27 | 85 | XHA86821.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang tombus-like virus 183] | diamond | 351 | 60.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 |
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);;