contig_metadata
20 rows where bioproject = "PRJNA1248471" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1051967 | 1051967 | PRJNA1248471_S_NODE_2041_length_329_cov_1.914286_g1941_i0 | PRJNA1248471 | 2041 | 329 | 1.914286 | 6.29800094 | Tobamovirus | 12234 | Viruses | Viruses | 597 | 3.169999999999999e-166 | NTclustered | gi|2701262864|gb|PP481220.1| | 12253 | g1941 | i0 | 99.392 | 86.4437689969605 | 329 | 2 | 100 | 0 | 1 | 329 | 6007 | 6335 | Tomato mosaic virus isolate INIFAP JM3, complete genome | blastn | 28440 | 597 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 1051976 | 1051976 | PRJNA1248471_S_NODE_24941_length_152_cov_2.475728_g24841_i0 | PRJNA1248471 | 24941 | 152 | 2.475728 | 3.76310656 | Tobamovirus | 12234 | Viruses | Viruses | 281 | 1.46e-71 | NTclustered | gi|323404090|gb|HQ593616.1| | 12253 | g24841 | i0 | 100 | 63.0657894736842 | 152 | 0 | 100 | 0 | 1 | 152 | 448 | 599 | Tomato mosaic virus isolate TMV-Jahrum coat protein (CP) mRNA, complete cds | blastn | 9586 | 281 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 5457086 | 5457086 | PRJNA1248471_S_NODE_685_length_440_cov_4.171355_g607_i0 | PRJNA1248471 | 685 | 440 | 4.171355 | 18.353962 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 802 | 0 | NTclustered | gi|756420392|gb|KP202857.1| | 1391702 | g607 | i0 | 99.545 | 99.1159090909091 | 440 | 2 | 100 | 0 | 1 | 440 | 1378 | 939 | Tomato mottle mosaic virus isolate 10-100, complete genome | blastn | 43611 | 802 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 6731283 | 6731283 | PRJNA1248471_S_NODE_106_length_1422_cov_6.335761_g105_i0 | PRJNA1248471 | 106 | 1422 | 6.335761 | 90.09452142 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 2571 | 0 | NTclustered | gi|2463200722|gb|ON987481.1| | 1391702 | g105 | i0 | 99.645 | 97.9345991561181 | 1407 | 5 | 99 | 0 | 16 | 1422 | 4641 | 6047 | Tomato mottle mosaic virus isolate NPPO-NL 41979438 RdRp, small replicase subunit, MP, and CP genes, complete cds | blastn | 139263 | 2571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 6731425 | 6731425 | PRJNA1248471_S_NODE_3946_length_277_cov_1.679825_g3846_i0 | PRJNA1248471 | 3946 | 277 | 1.679825 | 4.65311525 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 507 | 4.53e-139 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g3846 | i0 | 99.639 | 100 | 277 | 1 | 100 | 0 | 1 | 277 | 3300 | 3024 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 27700 | 507 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 6731467 | 6731467 | PRJNA1248471_S_NODE_86_length_2794_cov_4.997086_g85_i0 | PRJNA1248471 | 86 | 2794 | 4.997086 | 139.61858284 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 5036 | 0 | NTclustered | gi|2429409117|gb|ON146334.1| | 1391702 | g85 | i0 | 99.388 | 99.5619183965641 | 2779 | 16 | 99 | 1 | 1 | 2778 | 1369 | 4147 | Tomato mottle mosaic virus isolate MZWD RNA-dependent RNA polymerase, 126 kDa protein, movement protein, and coat protein genes, complete cds | blastn | 278176 | 5036 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 10557740 | 10557740 | PRJNA1248471_S_NODE_2089_length_327_cov_2.219424_g1989_i0 | PRJNA1248471 | 2089 | 327 | 2.219424 | 7.25751648 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 516 | 9.07e-142 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g1989 | i0 | 98.958 | 88.085626911315 | 288 | 3 | 88 | 0 | 1 | 288 | 681 | 394 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 28804 | 516 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 10557823 | 10557823 | PRJNA1248471_S_NODE_829_length_414_cov_6.983562_g749_i0 | PRJNA1248471 | 829 | 414 | 6.983562 | 28.91194668 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 763 | 0 | NTclustered | gi|2429409117|gb|ON146334.1| | 1391702 | g749 | i0 | 100 | 35.4734299516908 | 413 | 0 | 99 | 0 | 1 | 413 | 413 | 1 | Tomato mottle mosaic virus isolate MZWD RNA-dependent RNA polymerase, 126 kDa protein, movement protein, and coat protein genes, complete cds | blastn | 14686 | 763 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 12530591 | 12530591 | PRJNA1248471_S_NODE_1030_length_387_cov_4.363905_g945_i0 | PRJNA1248471 | 1030 | 387 | 4.363905 | 16.88831235 | Tobamovirus | 12234 | Viruses | Viruses | 710 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g945 | i0 | 99.742 | 99.2609819121447 | 387 | 1 | 100 | 0 | 1 | 387 | 4075 | 4461 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 38414 | 710 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 13107467 | 13107467 | PRJNA1248471_S_NODE_1351_length_361_cov_2.657051_g1256_i0 | PRJNA1248471 | 1351 | 361 | 2.657051 | 9.59195411 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 667 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g1256 | i0 | 100 | 99.9501385041551 | 361 | 0 | 100 | 0 | 1 | 361 | 2689 | 3049 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 36082 | 667 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 16930846 | 16930846 | PRJNA1248471_S_NODE_18634_length_167_cov_0.864407_g18534_i0 | PRJNA1248471 | 18634 | 167 | 0.864407 | 1.44355969 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 254 | 3.58e-63 | NTclustered | gi|756420392|gb|KP202857.1| | 1391702 | g18534 | i0 | 94.048 | 39.2335329341317 | 168 | 9 | 100 | 1 | 1 | 167 | 5251 | 5418 | Tomato mottle mosaic virus isolate 10-100, complete genome | blastn | 6552 | 254 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 16930936 | 16930936 | PRJNA1248471_S_NODE_714_length_435_cov_4.305699_g636_i0 | PRJNA1248471 | 714 | 435 | 4.305699 | 18.72979065 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 804 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g636 | i0 | 100 | 99.7287356321839 | 435 | 0 | 100 | 0 | 1 | 435 | 4826 | 4392 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 43382 | 804 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 16930958 | 16930958 | PRJNA1248471_S_NODE_9474_length_206_cov_1.121019_g9374_i0 | PRJNA1248471 | 9474 | 206 | 1.121019 | 2.30929914 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 370 | 4.38e-98 | NTclustered | gi|537711871|ref|NC_022230.1| | 1391702 | g9374 | i0 | 99.029 | 31.7087378640777 | 206 | 2 | 100 | 0 | 1 | 206 | 743 | 538 | Tomato mottle mosaic virus isolate MX5, complete genome | blastn | 6532 | 370 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 17629750 | 17629750 | PRJNA1248471_S_NODE_2534_length_312_cov_2.429658_g2434_i0 | PRJNA1248471 | 2534 | 312 | 2.429658 | 7.58053296 | Tobamovirus | 12234 | Viruses | Viruses | 571 | 1.81e-158 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g2434 | i0 | 99.679 | 99.900641025641 | 312 | 1 | 100 | 0 | 1 | 312 | 822 | 1133 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 31169 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 18205384 | 18205384 | PRJNA1248471_S_NODE_355_length_518_cov_4.761194_g324_i0 | PRJNA1248471 | 355 | 518 | 4.761194 | 24.66298492 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 878 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g324 | i0 | 99.381 | 105.84749034749 | 485 | 2 | 98 | 1 | 13 | 497 | 3888 | 3405 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 54829 | 878 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 21453832 | 21453832 | PRJNA1248471_S_NODE_217_length_645_cov_5.958054_g203_i0 | PRJNA1248471 | 217 | 645 | 5.958054 | 38.4294483 | Tobamovirus | 12234 | Viruses | Viruses | 1157 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g203 | i0 | 99.684 | 97.9410852713178 | 632 | 2 | 98 | 0 | 1 | 632 | 5606 | 4975 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 63172 | 1157 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 23305901 | 23305901 | PRJNA1248471_S_NODE_13319_length_188_cov_1.230216_g13219_i0 | PRJNA1248471 | 13319 | 188 | 1.230216 | 2.31280608 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 342 | 8.539999999999999e-90 | NTclustered | gi|756420392|gb|KP202857.1| | 1391702 | g13219 | i0 | 99.468 | 46.2925531914894 | 188 | 1 | 100 | 0 | 1 | 188 | 734 | 921 | Tomato mottle mosaic virus isolate 10-100, complete genome | blastn | 8703 | 342 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 23306026 | 23306026 | PRJNA1248471_S_NODE_479_length_479_cov_3.806977_g431_i0 | PRJNA1248471 | 479 | 479 | 3.806977 | 18.23541983 | Tobamovirus maculatessellati | 3432877 | Viruses | Viruses | 885 | 0 | NTclustered | gi|2429409117|gb|ON146334.1| | 1391702 | g431 | i0 | 100 | 98.9164926931106 | 479 | 0 | 100 | 0 | 1 | 479 | 4198 | 4676 | Tomato mottle mosaic virus isolate MZWD RNA-dependent RNA polymerase, 126 kDa protein, movement protein, and coat protein genes, complete cds | blastn | 47381 | 885 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus maculatessellati | ||
| 24580055 | 24580055 | PRJNA1248471_S_NODE_720_length_434_cov_4.815584_g642_i0 | PRJNA1248471 | 720 | 434 | 4.815584 | 20.89963456 | Tobamovirus tomatotessellati | 3432892 | Viruses | Viruses | 758 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g642 | i0 | 99.519 | 94.3202764976959 | 416 | 2 | 96 | 0 | 1 | 416 | 416 | 1 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 40935 | 758 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 25278080 | 25278080 | PRJNA1248471_S_NODE_100_length_1625_cov_3.886421_g99_i0 | PRJNA1248471 | 100 | 1625 | 3.886421 | 63.15434125 | Tobamovirus | 12234 | Viruses | Viruses | 2902 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g99 | i0 | 99.81 | 96.8683076923077 | 1580 | 3 | 97 | 0 | 46 | 1625 | 2691 | 1112 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 157411 | 2902 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati |
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);;