contig_metadata
22 rows where bioproject = "PRJNA763243", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2019426 | 2019426 | PRJNA763243_P_NODE_43022_length_269_cov_14.913265_g42676_i0 | PRJNA763243 | 43022 | 269 | 14.913265 | 40.11668285 | Tobamovirus tropici | 3432893 | Viruses | Viruses | 481 | 2.65e-131 | NTclustered | gi|1893169051|gb|MT130385.1| | 327387 | g42676 | i0 | 99.248 | 10.8773234200743 | 266 | 2 | 99 | 0 | 4 | 269 | 1734 | 1999 | Tropical soda apple mosaic virus isolate I4-11-TSAMV 183 kDa replicase, movement protein, and coat protein genes, complete cds | blastn | 2926 | 481 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tropici | ||
| 2020006 | 2020006 | PRJNA763243_P_NODE_69002_length_225_cov_12.138158_g68656_i0 | PRJNA763243 | 69002 | 225 | 12.138158 | 27.3108555 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 403 | 4.799999999999998e-108 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g68656 | i0 | 99.107 | 93.7511111111111 | 224 | 2 | 99 | 0 | 1 | 224 | 5133 | 4910 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 21094 | 403 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 2020061 | 2020061 | PRJNA763243_P_NODE_71262_length_214_cov_8.390071_g70916_i0 | PRJNA763243 | 71262 | 214 | 8.390071 | 17.95475194 | Tobamovirus tropici | 3432893 | Viruses | Viruses | 379 | 7.609999999999999e-101 | NTclustered | gi|1893169035|gb|MT130381.1| | 327387 | g70916 | i0 | 99.057 | 43.7523364485981 | 212 | 1 | 99 | 1 | 1 | 211 | 6214 | 6003 | Tropical soda apple mosaic virus isolate I2-5.5-TSAMV 183 kDa replicase, movement protein, and coat protein genes, complete cds | blastn | 9363 | 379 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tropici | ||
| 3294107 | 3294107 | PRJNA763243_P_NODE_20283_length_351_cov_11.690647_g19937_i0 | PRJNA763243 | 20283 | 351 | 11.690647 | 41.03417097 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 632 | 9.309999999999999e-177 | NTclustered | gi|1935641333|gb|MT665963.1| | 12239 | g19937 | i0 | 99.425 | 99.0968660968661 | 348 | 2 | 99 | 0 | 4 | 351 | 194 | 541 | Pepper mild mottle virus isolate I-T movement protein gene, partial cds; and coat protein gene, complete cds | blastn | 34783 | 632 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 4572504 | 4572504 | PRJNA763243_P_NODE_9764_length_478_cov_16.511111_g9421_i0 | PRJNA763243 | 9764 | 478 | 16.511111 | 78.92311058 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 841 | 0 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g9421 | i0 | 98.529 | 97.6652719665272 | 476 | 7 | 99 | 0 | 1 | 476 | 4310 | 3835 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 46684 | 841 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 5846341 | 5846341 | PRJNA763243_P_NODE_1905_length_937_cov_25.031250_g1682_i0 | PRJNA763243 | 1905 | 937 | 25.03125 | 234.5428125 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 1585 | 0 | NTclustered | gi|1933757594|gb|MW177751.1| | 2789423 | g1682 | i0 | 99.204 | 0.938100320170758 | 879 | 7 | 94 | 0 | 59 | 937 | 1270 | 392 | Skokie tombus-like virus strain USAdp coat protein gene, partial cds | blastn | 879 | 1585 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 5846612 | 5846612 | PRJNA763243_P_NODE_30165_length_308_cov_39.680851_g29819_i0 | PRJNA763243 | 30165 | 308 | 39.680851 | 122.21702108 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 564 | 2.99e-156 | NTclustered | gi|1933757594|gb|MW177751.1| | 2789423 | g29819 | i0 | 99.675 | 1 | 308 | 1 | 100 | 0 | 1 | 308 | 155 | 462 | Skokie tombus-like virus strain USAdp coat protein gene, partial cds | blastn | 308 | 564 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 7122816 | 7122816 | PRJNA763243_P_NODE_74106_length_201_cov_25.492188_g73760_i0 | PRJNA763243 | 74106 | 201 | 25.492188 | 51.23929788 | Tobamovirus tropici | 3432893 | Viruses | Viruses | 350 | 5.539999999999999e-92 | NTclustered | gi|1893169035|gb|MT130381.1| | 327387 | g73760 | i0 | 99.482 | 11.5273631840796 | 193 | 0 | 96 | 1 | 7 | 198 | 3824 | 3632 | Tropical soda apple mosaic virus isolate I2-5.5-TSAMV 183 kDa replicase, movement protein, and coat protein genes, complete cds | blastn | 2317 | 350 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tropici | ||
| 8858455 | 8858455 | PRJNA763243_P_NODE_70587_length_217_cov_15.555556_g70241_i0 | PRJNA763243 | 70587 | 217 | 15.555556 | 33.75555652 | Tobamovirus | 12234 | Viruses | Viruses | 381 | 2.1499999999999995e-101 | NTclustered | gi|139866184|dbj|AB276030.1| | 12239 | g70241 | i0 | 99.522 | 95.2995391705069 | 209 | 1 | 96 | 0 | 6 | 214 | 356 | 148 | Pepper mild mottle virus genomic RNA, complete genome, strain: L4BV | blastn | 20680 | 381 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 9671228 | 9671228 | PRJNA763243_P_NODE_20008_length_353_cov_5.278571_g19662_i0 | PRJNA763243 | 20008 | 353 | 5.278571 | 18.63335563 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 351 | 2.94e-92 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g19662 | i0 | 99.482 | 91.2606232294618 | 193 | 1 | 96 | 0 | 1 | 193 | 3461 | 3269 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 32215 | 351 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 10946822 | 10946822 | PRJNA763243_P_NODE_16949_length_378_cov_7.485246_g16604_i0 | PRJNA763243 | 16949 | 378 | 7.485246 | 28.29422988 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 693 | 0 | NTclustered | gi|1935607036|gb|MT747993.1| | 2789423 | g16604 | i0 | 99.735 | 1.99206349206349 | 378 | 1 | 100 | 0 | 1 | 378 | 824 | 1201 | Skokie tombus-like virus strain USAdp-1 RNA-dependent RNA polymerase gene, complete cds | blastn | 753 | 693 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 12222793 | 12222793 | PRJNA763243_P_NODE_34010_length_293_cov_7.722727_g33664_i0 | PRJNA763243 | 34010 | 293 | 7.722727 | 22.62759011 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 520 | 6.2e-143 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g33664 | i0 | 98.966 | 94.9965870307167 | 290 | 3 | 99 | 0 | 1 | 290 | 5509 | 5220 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 27834 | 520 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 14771572 | 14771572 | PRJNA763243_P_NODE_14192_length_407_cov_21.550898_g13847_i0 | PRJNA763243 | 14192 | 407 | 21.550898 | 87.71215486 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 725 | 0 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g13847 | i0 | 99.01 | 99.2874692874693 | 404 | 4 | 99 | 0 | 1 | 404 | 1000 | 597 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 40410 | 725 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 16045964 | 16045964 | PRJNA763243_P_NODE_41333_length_273_cov_7.165000_g40987_i0 | PRJNA763243 | 41333 | 273 | 7.165 | 19.56045 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 494 | 3.46e-135 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g40987 | i0 | 99.63 | 92.2930402930403 | 270 | 1 | 99 | 0 | 4 | 273 | 2416 | 2685 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 25196 | 494 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 17320975 | 17320975 | PRJNA763243_P_NODE_13174_length_420_cov_16.363112_g12829_i0 | PRJNA763243 | 13174 | 420 | 16.363112 | 68.7250704 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 750 | 0 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g12829 | i0 | 99.045 | 96.2714285714286 | 419 | 3 | 99 | 1 | 1 | 418 | 4902 | 4484 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 40434 | 750 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 17322471 | 17322471 | PRJNA763243_P_NODE_9194_length_490_cov_17.575540_g8852_i0 | PRJNA763243 | 9194 | 490 | 17.57554 | 86.120146 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 889 | 0 | NTclustered | gi|1933757591|gb|MW177750.1| | 2789423 | g8852 | i0 | 99.388 | 1.99795918367347 | 490 | 3 | 100 | 0 | 1 | 490 | 210 | 699 | Skokie tombus-like virus strain USAdp hypothetical protein 2 gene, partial cds | blastn | 979 | 889 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 18594365 | 18594365 | PRJNA763243_P_NODE_15975_length_387_cov_10.592357_g15630_i0 | PRJNA763243 | 15975 | 387 | 10.592357 | 40.99242159 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 702 | 0 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g15630 | i0 | 100 | 93.8785529715762 | 380 | 0 | 98 | 0 | 4 | 383 | 1220 | 1599 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 36331 | 702 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 18594910 | 18594910 | PRJNA763243_P_NODE_39335_length_278_cov_11.370732_g38989_i0 | PRJNA763243 | 39335 | 278 | 11.370732 | 31.61063496 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 508 | 1.26e-139 | NTclustered | gi|1935607036|gb|MT747993.1| | 2789423 | g38989 | i0 | 99.64 | 2 | 278 | 1 | 100 | 0 | 1 | 278 | 507 | 230 | Skokie tombus-like virus strain USAdp-1 RNA-dependent RNA polymerase gene, complete cds | blastn | 556 | 508 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 21146522 | 21146522 | PRJNA763243_P_NODE_69857_length_221_cov_5.250000_g69511_i0 | PRJNA763243 | 69857 | 221 | 5.25 | 11.6025 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 385 | 1.6999999999999995e-102 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g69511 | i0 | 98.618 | 96.5565610859728 | 217 | 3 | 98 | 0 | 4 | 220 | 1666 | 1882 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 21339 | 385 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 22421428 | 22421428 | PRJNA763243_P_NODE_8218_length_513_cov_12.831818_g7877_i0 | PRJNA763243 | 8218 | 513 | 12.831818 | 65.82722634 | Tobamovirus tropici | 3432893 | Viruses | Viruses | 933 | 0 | NTclustered | gi|1893169051|gb|MT130385.1| | 327387 | g7877 | i0 | 99.803 | 11.8752436647173 | 508 | 1 | 99 | 0 | 4 | 511 | 2601 | 2094 | Tropical soda apple mosaic virus isolate I4-11-TSAMV 183 kDa replicase, movement protein, and coat protein genes, complete cds | blastn | 6092 | 933 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tropici | ||
| 24969532 | 24969532 | PRJNA763243_P_NODE_24780_length_324_cov_14.852590_g24434_i0 | PRJNA763243 | 24780 | 324 | 14.85259 | 48.1223916 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 568 | 2.4399999999999993e-157 | NTclustered | gi|1893169063|gb|MT130388.1| | 12239 | g24434 | i0 | 98.746 | 96.5092592592593 | 319 | 4 | 98 | 0 | 3 | 321 | 3048 | 2730 | Pepper mild mottle virus isolate M2-PMMoV 180k replication protein gene, partial cds; and movement protein and coat protein genes, complete cds | blastn | 31269 | 568 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 27621982 | 27621982 | PRJNA763243_P_NODE_57284_length_246_cov_1.156069_g56938_i0 | PRJNA763243 | 57284 | 246 | 1.156069 | 2.84392974 | Hobart betaflexivirus 1 | 2201305 | Viruses | Viruses | 150 | 1.17e-41 | NR | AWK77907.1 | 2201305 | g56938 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 244 | 2 | 123 | 203 | AWK77907.1 movement protein [Hobart betaflexivirus 1] | diamond | 243 | 150 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Hobart betaflexivirus 1 |
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);;