contig_metadata
12 rows where bioproject = "PRJNA904835" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3434337 | 3434337 | PRJNA904835_P_NODE_55943_length_245_cov_0.895349_g55687_i0 | PRJNA904835 | 55943 | 245 | 0.895349 | 2.19360505 | Begomovirus | 10814 | Viruses | Viruses | 79 | 4.46e-15 | NR | AGZ91416.1 | 10832 | g55687 | i0 | 66 | 7.62857142857143 | 53 | 18 | 64.9 | 0 | 243 | 85 | 299 | 351 | AGZ91416.1 replication associated protein [Tomato yellow leaf curl virus] | diamond | 1869 | 79.3 | 0.996216897856242 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Begomovirus | Begomovirus coheni | ||
| 7625325 | 7625325 | PRJNA904835_P_NODE_16506_length_506_cov_1.905312_g16252_i0 | PRJNA904835 | 16506 | 506 | 1.905312 | 9.64087872 | Alphanecrovirus | 1299309 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|2273761011|gb|OL472227.1| | 12054 | g16252 | i0 | 100 | 0.114624505928854 | 29 | 0 | 6 | 0 | 159 | 187 | 1284 | 1256 | MAG: Unidentified tobacco necrosis virus isolate PAR19AT, complete genome | blastn | 58 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | unidentified tobacco necrosis virus | |||
| 16185237 | 16185237 | PRJNA904835_P_NODE_14913_length_538_cov_1.006452_g14661_i0 | PRJNA904835 | 14913 | 538 | 1.006452 | 5.41471176 | Yellow silver pine badnavirus 5 | 3068784 | Viruses | Viruses | 82 | 1.85e-14 | NR | WPR16502.1 | 3068784 | g14661 | i0 | 73.9 | 1.02602230483271 | 46 | 12 | 25.7 | 0 | 217 | 354 | 1054 | 1099 | WPR16502.1 MAG: polyprotein [Yellow silver pine badnavirus 5] | diamond | 552 | 82 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Yellow silver pine badnavirus 5 | ||
| 18735190 | 18735190 | PRJNA904835_P_NODE_56635_length_244_cov_0.900585_g56379_i0 | PRJNA904835 | 56635 | 244 | 0.900585 | 2.1974274 | aphis 2 virus | 3041036 | Viruses | Viruses | 451 | 1.86e-122 | NTclustered | gi|2638767858|tpg|BK063262.1| | 3041036 | g56379 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 1933 | 2176 | TPA_asm: Aphis 2 virus replicase protein gene, complete cds | blastn | 244 | 451 | 1 | Viruses | aphis 2 virus | ||||||||
| 18735198 | 18735198 | PRJNA904835_P_NODE_56955_length_243_cov_2.258824_g56699_i0 | PRJNA904835 | 56955 | 243 | 2.258824 | 5.48894232 | Begomovirus nicotianae | 3426882 | Viruses | Viruses | 58.4 | 4.71e-4 | NTclustered | gi|1817986057|gb|MN481176.1| | 180526 | g56699 | i0 | 100 | 5.12345679012346 | 31 | 0 | 13 | 0 | 105 | 135 | 2732 | 2702 | Tobacco curly shoot virus isolate YN6303 clone 9, complete genome | blastn | 1245 | 58.4 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Begomovirus | Begomovirus nicotianae | ||
| 20009927 | 20009927 | PRJNA904835_P_NODE_42876_length_286_cov_1.079812_g42620_i0 | PRJNA904835 | 42876 | 286 | 1.079812 | 3.08826232 | Begomovirus | 10814 | Viruses | Viruses | 149 | 1.75e-41 | NR | QIJ32567.1 | 10832 | g42620 | i0 | 74 | 11.0769230769231 | 96 | 19 | 94.4 | 1 | 16 | 285 | 31 | 126 | QIJ32567.1 replication protein [Tomato yellow leaf curl virus] | diamond | 3168 | 149 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Geminiviridae | Begomovirus | Begomovirus coheni | ||
| 20373694 | 20373694 | PRJNA904835_P_NODE_35596_length_323_cov_1.540000_g35340_i0 | PRJNA904835 | 35596 | 323 | 1.54 | 4.9742 | Gammaretrovirus | 153135 | Viruses | Viruses | 592 | 1.4499999999999999e-164 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g35340 | i0 | 99.69 | 100 | 323 | 1 | 100 | 0 | 1 | 323 | 4050 | 3728 | Moloney murine leukemia virus, complete genome | blastn | 32300 | 592 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 25474180 | 25474180 | PRJNA904835_P_NODE_6760_length_835_cov_1.274278_g6553_i0 | PRJNA904835 | 6760 | 835 | 1.274278 | 10.6402213 | Moloney murine leukemia virus | 11801 | Viruses | Viruses | 516 | 1.73e-167 | NR | NP_057933.2 | 11801 | g6553 | i0 | 97.6 | 7.26826347305389 | 253 | 6 | 90.9 | 0 | 76 | 834 | 658 | 910 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 6069 | 516 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 27727250 | 27727250 | PRJNA904835_P_NODE_45384_length_274_cov_1.532338_g45128_i0 | PRJNA904835 | 45384 | 274 | 1.532338 | 4.19860612 | Gammaretrovirus | 153135 | Viruses | Viruses | 170 | 1.0099999999999999e-46 | NR | NP_057933.2 | 11801 | g45128 | i0 | 95.6 | 13.7627737226277 | 90 | 4 | 98.5 | 0 | 3 | 272 | 1165 | 1254 | NP_057933.2 Pr180 [Moloney murine leukemia virus] | diamond | 3771 | 170 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 29171833 | 29171833 | PRJNA904835_P_NODE_58449_length_242_cov_0.911243_g58193_i0 | PRJNA904835 | 58449 | 242 | 0.911243 | 2.20520806 | Blackberry virus F | 2560349 | Viruses | Viruses | 109 | 1.01e-25 | NR | XHV14367.1 | 2560349 | g58193 | i0 | 66.3 | 5.9504132231405 | 80 | 27 | 99.2 | 0 | 1 | 240 | 1489 | 1568 | XHV14367.1 MAG: polyprotein [Blackberry virus F] | diamond | 1440 | 109 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Badnavirus phirubi | ||
| 29803093 | 29803093 | PRJNA904835_P_NODE_39611_length_301_cov_2.026316_g39355_i0 | PRJNA904835 | 39611 | 301 | 2.026316 | 6.09921116 | Peanut chlorotic streak virus | 35593 | Viruses | Viruses | 85.1 | 8.46e-17 | NR | NP_042512.1 | 35593 | g39355 | i0 | 53.9 | 0.887043189368771 | 89 | 25 | 72.8 | 2 | 223 | 5 | 190 | 278 | NP_042512.1 hypothetical protein [Peanut chlorotic streak virus] | diamond | 267 | 85.1 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Soymovirus | Soymovirus virgarachidis | ||
| 32458844 | 32458844 | PRJNA904835_P_NODE_44079_length_280_cov_1.487923_g43823_i0 | PRJNA904835 | 44079 | 280 | 1.487923 | 4.1661844 | Blackberry virus F | 2560349 | Viruses | Viruses | 128 | 4.219999999999999e-32 | NR | XHV14355.1 | 2560349 | g43823 | i0 | 65.6 | 5.97857142857143 | 93 | 32 | 99.6 | 0 | 1 | 279 | 1497 | 1589 | XHV14355.1 MAG: polyprotein [Blackberry virus F] | diamond | 1674 | 128 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Badnavirus phirubi |
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);;