contig_metadata
13 rows where bioproject = "PRJNA674048", tax_phylum = "Kitrinoviricota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 643106 | 643106 | PRJNA674048_P_NODE_33261_length_159_cov_3.709091_g33058_i0 | PRJNA674048 | 33261 | 159 | 3.709091 | 5.89745469 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 272 | 9.28e-69 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g33058 | i0 | 97.484 | 1 | 159 | 4 | 100 | 0 | 1 | 159 | 5616 | 5774 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 159 | 272 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 3717948 | 3717948 | PRJNA674048_P_NODE_8343_length_334_cov_3.396491_g8140_i0 | PRJNA674048 | 8343 | 334 | 3.396491 | 11.34427994 | root | 1 | Root_unresolved | Root_unresolved | 606 | 5.359999999999998e-169 | NTclustered | gi|388240305|emb|HE818455.1| | 12242 | g8140 | i0 | 99.401 | 100 | 334 | 2 | 100 | 0 | 1 | 334 | 2380 | 2047 | Tobacco mosaic virus isolate Yihan-1, complete genome | blastn | 33400 | 606 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 5746586 | 5746586 | PRJNA674048_P_NODE_25325_length_174_cov_2.104000_g25122_i0 | PRJNA674048 | 25325 | 174 | 2.104 | 3.66096 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 316 | 4.7e-82 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g25122 | i0 | 100 | 0.982758620689655 | 171 | 0 | 98 | 0 | 4 | 174 | 3997 | 3827 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 171 | 316 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 7021644 | 7021644 | PRJNA674048_P_NODE_12126_length_263_cov_5.780374_g11923_i0 | PRJNA674048 | 12126 | 263 | 5.780374 | 15.20238362 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 481 | 2.58e-131 | NTclustered | gi|348605458|gb|JF920727.1| | 12242 | g11923 | i0 | 99.62 | 99.6349809885932 | 263 | 1 | 100 | 0 | 1 | 263 | 6382 | 6120 | Tobacco mosaic virus isolate Shanxi, complete genome | blastn | 26204 | 481 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 11369398 | 11369398 | PRJNA674048_P_NODE_13069_length_251_cov_4.103960_g12866_i0 | PRJNA674048 | 13069 | 251 | 4.10396 | 10.3009396 | root | 1 | Root_unresolved | Root_unresolved | 459 | 1.1499999999999996e-124 | NTclustered | gi|388240305|emb|HE818455.1| | 12242 | g12866 | i0 | 99.602 | 99.9521912350598 | 251 | 1 | 100 | 0 | 1 | 251 | 4561 | 4811 | Tobacco mosaic virus isolate Yihan-1, complete genome | blastn | 25088 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12122314 | 12122314 | PRJNA674048_P_NODE_12570_length_257_cov_2.927885_g12367_i0 | PRJNA674048 | 12570 | 257 | 2.927885 | 7.52466445 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 459 | 1.18e-124 | NTclustered | gi|388240269|emb|HE818446.1| | 12242 | g12367 | i0 | 98.833 | 100.007782101167 | 257 | 3 | 100 | 0 | 1 | 257 | 3584 | 3840 | Tobacco mosaic virus isolate Wenxing, complete genome | blastn | 25702 | 459 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 18495440 | 18495440 | PRJNA674048_P_NODE_19435_length_200_cov_2.390728_g19232_i0 | PRJNA674048 | 19435 | 200 | 2.390728 | 4.781456 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 363 | 7.069999999999999e-96 | NTclustered | gi|2770826564|gb|PQ032045.1| | 12242 | g19232 | i0 | 99.497 | 99.505 | 199 | 1 | 99 | 0 | 1 | 199 | 4027 | 4225 | Tobacco mosaic virus isolate Sru-1, complete genome | blastn | 19901 | 363 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 19770086 | 19770086 | PRJNA674048_P_NODE_9876_length_300_cov_3.988048_g9673_i0 | PRJNA674048 | 9876 | 300 | 3.988048 | 11.964144 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 544 | 3.78e-150 | NTclustered | gi|2727871481|gb|OR360694.1| | 12242 | g9673 | i0 | 99.333 | 100 | 300 | 2 | 100 | 0 | 1 | 300 | 406 | 107 | Tobacco mosaic virus isolate TMV/ZT/120 coat protein (CP) gene, complete cds | blastn | 30000 | 544 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 22843673 | 22843673 | PRJNA674048_P_NODE_6458_length_396_cov_2.452450_g6255_i0 | PRJNA674048 | 6458 | 396 | 2.45245 | 9.711702 | Tobamovirus | 12234 | Viruses | Viruses | 715 | 0 | NTclustered | gi|2327914667|gb|OM366242.1| | 12242 | g6255 | i0 | 99.242 | 99.9343434343434 | 396 | 3 | 100 | 0 | 1 | 396 | 653 | 258 | Tobacco mosaic virus isolate Yunnanwenshan replicase protein gene, complete cds | blastn | 39574 | 715 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 22843718 | 22843718 | PRJNA674048_P_NODE_9718_length_303_cov_3.102362_g9515_i0 | PRJNA674048 | 9718 | 303 | 3.102362 | 9.40015686 | Tobamovirus | 12234 | Viruses | Viruses | 555 | 1.7599999999999995e-153 | NTclustered | gi|1823692201|gb|MN186255.1| | 12242 | g9515 | i0 | 100 | 99.990099009901 | 300 | 0 | 99 | 0 | 4 | 303 | 5237 | 4938 | Tobacco mosaic virus isolate Henan9-2-2017 CP, MP, 183K protein, and 130K protein genes, complete cds | blastn | 30297 | 555 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 23595896 | 23595896 | PRJNA674048_P_NODE_17339_length_213_cov_2.219512_g17136_i0 | PRJNA674048 | 17339 | 213 | 2.219512 | 4.72756056 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 377 | 2.72e-100 | NTclustered | gi|388240233|emb|HE818437.1| | 12242 | g17136 | i0 | 98.592 | 99.7370892018779 | 213 | 3 | 100 | 0 | 1 | 213 | 2049 | 1837 | Tobacco mosaic virus isolate Mangshi-2, complete genome | blastn | 21244 | 377 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 23595916 | 23595916 | PRJNA674048_P_NODE_1939_length_846_cov_2.392723_g1798_i0 | PRJNA674048 | 1939 | 846 | 2.392723 | 20.24243658 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1502 | 0 | NTclustered | gi|388240305|emb|HE818455.1| | 12242 | g1798 | i0 | 98.7 | 100.039007092199 | 846 | 11 | 100 | 0 | 1 | 846 | 4904 | 5749 | Tobacco mosaic virus isolate Yihan-1, complete genome | blastn | 84633 | 1502 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 32421384 | 32421384 | PRJNA674048_P_NODE_25459_length_174_cov_1.272000_g25256_i0 | PRJNA674048 | 25459 | 174 | 1.272 | 2.21328 | Tolivirales sp. | 2809914 | Viruses | Viruses | 49.3 | 6.99e-5 | NR | WRQ65701.1 | 2809914 | g25256 | i0 | 44.9 | 0.844827586206897 | 49 | 27 | 84.5 | 0 | 152 | 6 | 18 | 66 | WRQ65701.1 structural protein [Tolivirales sp.] | diamond | 147 | 49.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales 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);;