contig_metadata
19 rows where bioproject = "PRJNA1174207", tax_kingdom = "Orthornavirae" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1040785 | 1040785 | PRJNA1174207_P_NODE_43381_length_223_cov_4.086667_g42852_i0 | PRJNA1174207 | 43381 | 223 | 4.086667 | 9.11326741 | Tobamovirus | 12234 | Viruses | Viruses | 411 | 2.84e-110 | NTclustered | gi|2647550519|gb|OR843964.1| | 12242 | g42852 | i0 | 100 | 99.5515695067265 | 222 | 0 | 99 | 0 | 1 | 222 | 2340 | 2561 | Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds | blastn | 22200 | 411 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 2315956 | 2315956 | PRJNA1174207_P_NODE_32482_length_254_cov_1.701657_g31953_i0 | PRJNA1174207 | 32482 | 254 | 1.701657 | 4.32220878 | Tobamovirus | 12234 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|2647550519|gb|OR843964.1| | 12242 | g31953 | i0 | 100 | 100 | 254 | 0 | 100 | 0 | 1 | 254 | 1567 | 1820 | Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds | blastn | 25400 | 470 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 2316205 | 2316205 | PRJNA1174207_P_NODE_9902_length_487_cov_2.202899_g9376_i0 | PRJNA1174207 | 9902 | 487 | 2.202899 | 10.72811813 | Tobamovirus | 12234 | Viruses | Viruses | 893 | 0 | NTclustered | gi|1805995756|gb|MN882044.1| | 1761477 | g9376 | i0 | 99.794 | 99.7946611909651 | 486 | 1 | 99 | 0 | 2 | 487 | 6323 | 5838 | Tomato brown rugose fruit virus isolate 39563388_A, complete genome | blastn | 48600 | 893 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 3591183 | 3591183 | PRJNA1174207_P_NODE_3763_length_921_cov_3.476415_g3323_i0 | PRJNA1174207 | 3763 | 921 | 3.476415 | 32.01778215 | Alphavirus | 11019 | Viruses | Viruses | 1696 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g3323 | i0 | 99.891 | 99.9978284473398 | 921 | 1 | 100 | 0 | 1 | 921 | 4931 | 5851 | Getah virus strain M1, complete genome | blastn | 92098 | 1701 | 0.997060552616108 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 3591243 | 3591243 | PRJNA1174207_P_NODE_42983_length_228_cov_3.432258_g42454_i0 | PRJNA1174207 | 42983 | 228 | 3.432258 | 7.82554824 | Tobamovirus | 12234 | Viruses | Viruses | 422 | 1.34e-113 | NTclustered | gi|2701262864|gb|PP481220.1| | 12253 | g42454 | i0 | 100 | 100 | 228 | 0 | 100 | 0 | 1 | 228 | 3109 | 3336 | Tomato mosaic virus isolate INIFAP JM3, complete genome | blastn | 22800 | 422 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 3591376 | 3591376 | PRJNA1174207_P_NODE_983_length_1940_cov_5.472951_g793_i0 | PRJNA1174207 | 983 | 1940 | 5.472951 | 106.1752494 | Alphavirus | 11019 | Viruses | Viruses | 3572 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g793 | i0 | 99.897 | 100.148453608247 | 1940 | 2 | 100 | 0 | 1 | 1940 | 5890 | 7829 | Getah virus strain M1, complete genome | blastn | 194288 | 3572 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 6143296 | 6143296 | PRJNA1174207_P_NODE_15385_length_368_cov_1.345763_g14856_i0 | PRJNA1174207 | 15385 | 368 | 1.345763 | 4.95240784 | Tobamovirus | 12234 | Viruses | Viruses | 675 | 0 | NTclustered | gi|2701262864|gb|PP481220.1| | 12253 | g14856 | i0 | 99.728 | 98.991847826087 | 368 | 1 | 100 | 0 | 1 | 368 | 4782 | 4415 | Tomato mosaic virus isolate INIFAP JM3, complete genome | blastn | 36429 | 680 | 0.992647058823529 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 6143458 | 6143458 | PRJNA1174207_P_NODE_25945_length_281_cov_4.389423_g25416_i0 | PRJNA1174207 | 25945 | 281 | 4.389423 | 12.33427863 | Tobamovirus | 12234 | Viruses | Viruses | 520 | 5.909999999999999e-143 | NTclustered | gi|2647550519|gb|OR843964.1| | 12242 | g25416 | i0 | 100 | 100 | 281 | 0 | 100 | 0 | 1 | 281 | 2227 | 1947 | Tobacco mosaic virus strain MR644-18E/3430 nonstructural polyprotein p183, nonstructural polyprotein p126, and movement protein genes, partial cds | blastn | 28100 | 520 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 11243714 | 11243714 | PRJNA1174207_P_NODE_15229_length_370_cov_1.821549_g14700_i0 | PRJNA1174207 | 15229 | 370 | 1.821549 | 6.7397313 | Tobamovirus | 12234 | Viruses | Viruses | 673 | 0 | NTclustered | gi|2201440261|gb|OL652662.1| | 12253 | g14700 | i0 | 99.459 | 100 | 370 | 2 | 100 | 0 | 1 | 370 | 5394 | 5763 | Tomato mosaic virus isolate NVWA36783860, complete genome | blastn | 37000 | 673 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 11244120 | 11244120 | PRJNA1174207_P_NODE_609_length_2460_cov_4.854629_g475_i0 | PRJNA1174207 | 609 | 2460 | 4.854629 | 119.4238734 | Alphavirus | 11019 | Viruses | Viruses | 4521 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g475 | i0 | 99.837 | 99.8642276422764 | 2460 | 4 | 100 | 0 | 1 | 2460 | 11369 | 8910 | Getah virus strain M1, complete genome | blastn | 245666 | 4538 | 0.996253856324372 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 14344610 | 14344610 | PRJNA1174207_P_NODE_27892_length_273_cov_2.035000_g27363_i0 | PRJNA1174207 | 27892 | 273 | 2.035 | 5.55555 | Tobamovirus capsici | 3432865 | Viruses | Viruses | 503 | 5.76e-138 | NTclustered | gi|2431684801|gb|ON557629.1| | 12239 | g27363 | i0 | 100 | 99.5347985347985 | 272 | 0 | 99 | 0 | 1 | 272 | 4497 | 4768 | Pepper mild mottle virus isolate G07, partial genome | blastn | 27173 | 503 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus capsici | ||
| 15068297 | 15068297 | PRJNA1174207_P_NODE_28172_length_272_cov_1.547739_g27643_i0 | PRJNA1174207 | 28172 | 272 | 1.547739 | 4.20985008 | Tobamovirus | 12234 | Viruses | Viruses | 501 | 2.06e-137 | NTclustered | gi|16580717|emb|AJ417701.1| | 12253 | g27643 | i0 | 100 | 99.5073529411765 | 271 | 0 | 99 | 0 | 1 | 271 | 2142 | 2412 | Tomato mosaic virus camellia strain, complete genome | blastn | 27066 | 501 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tomatotessellati | ||
| 16342922 | 16342922 | PRJNA1174207_P_NODE_13793_length_393_cov_1.925000_g13264_i0 | PRJNA1174207 | 13793 | 393 | 1.925 | 7.56525 | Tobamovirus | 12234 | Viruses | Viruses | 721 | 0 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g13264 | i0 | 99.746 | 100 | 393 | 1 | 100 | 0 | 1 | 393 | 3833 | 3441 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 39300 | 721 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 16343167 | 16343167 | PRJNA1174207_P_NODE_3013_length_1056_cov_2.970498_g2607_i0 | PRJNA1174207 | 3013 | 1056 | 2.970498 | 31.36845888 | Alphavirus | 11019 | Viruses | Viruses | 1945 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g2607 | i0 | 99.905 | 99.9943181818182 | 1056 | 1 | 100 | 0 | 1 | 1056 | 3920 | 4975 | Getah virus strain M1, complete genome | blastn | 105594 | 1945 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 17618184 | 17618184 | PRJNA1174207_P_NODE_1314_length_1675_cov_2.543071_g1070_i0 | PRJNA1174207 | 1314 | 1675 | 2.543071 | 42.59643925 | Alphavirus | 11019 | Viruses | Viruses | 3094 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g1070 | i0 | 100 | 99.9982089552239 | 1675 | 0 | 100 | 0 | 1 | 1675 | 2264 | 3938 | Getah virus strain M1, complete genome | blastn | 167497 | 3094 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 22717305 | 22717305 | PRJNA1174207_P_NODE_12918_length_408_cov_2.743284_g12391_i0 | PRJNA1174207 | 12918 | 408 | 2.743284 | 11.19259872 | Alphavirus | 11019 | Viruses | Viruses | 749 | 0 | NTclustered | gi|52631669|gb|AY702913.1| | 59300 | g12391 | i0 | 99.755 | 99.4656862745098 | 408 | 1 | 100 | 0 | 1 | 408 | 409 | 2 | Getah virus from South Korea, complete genome | blastn | 40582 | 749 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 23992517 | 23992517 | PRJNA1174207_P_NODE_10419_length_471_cov_1.467337_g9893_i0 | PRJNA1174207 | 10419 | 471 | 1.467337 | 6.91115727 | Alphavirus | 11019 | Viruses | Viruses | 870 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g9893 | i0 | 100 | 100 | 471 | 0 | 100 | 0 | 1 | 471 | 1298 | 1768 | Getah virus strain M1, complete genome | blastn | 47100 | 870 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 25267160 | 25267160 | PRJNA1174207_P_NODE_8560_length_536_cov_1.341253_g8036_i0 | PRJNA1174207 | 8560 | 536 | 1.341253 | 7.18911608 | Alphavirus | 11019 | Viruses | Viruses | 974 | 0 | NTclustered | gi|157734228|gb|EU015061.1| | 59300 | g8036 | i0 | 99.44 | 99.9365671641791 | 536 | 3 | 100 | 0 | 1 | 536 | 8807 | 8272 | Getah virus strain M1, complete genome | blastn | 53566 | 974 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Togaviridae | Alphavirus | Alphavirus getah | ||
| 29030281 | 29030281 | PRJNA1174207_P_NODE_35588_length_248_cov_1.554286_g35059_i0 | PRJNA1174207 | 35588 | 248 | 1.554286 | 3.85462928 | Erysiphe necator associated virga-like virus 13 | 2743128 | Viruses | Viruses | 57.4 | 2.78e-7 | NR | QKN22650.1 | 2743128 | g35059 | i0 | 48.3 | 0.725806451612903 | 60 | 31 | 72.6 | 0 | 3 | 182 | 1103 | 1162 | QKN22650.1 RNA-dependent RNA polymerase [Erysiphe necator associated virga-like virus 13] | diamond | 180 | 57.4 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Erysiphe necator associated virga-like virus 13 |
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);;