contig_metadata
10 rows where bioproject = "PRJNA565778" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 558423 | 558423 | PRJNA565778_S_NODE_3781_length_520_cov_265.521739_g3577_i0 | PRJNA565778 | 3781 | 520 | 265.521739 | 1380.7130428 | Potexvirus pepini | 3433856 | Viruses | Viruses | 876 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g3577 | i0 | 99.38 | 87.7403846153846 | 484 | 2 | 93 | 1 | 38 | 520 | 5898 | 6381 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 45625 | 876 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3108972 | 3108972 | PRJNA565778_S_NODE_13183_length_302_cov_441.962264_g12887_i0 | PRJNA565778 | 13183 | 302 | 441.962264 | 1334.72603728 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 473 | 5.059999999999999e-129 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g12887 | i0 | 98.868 | 87.7748344370861 | 265 | 3 | 88 | 0 | 1 | 265 | 2571 | 2307 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 26508 | 473 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 3108988 | 3108988 | PRJNA565778_S_NODE_1403_length_751_cov_11.747899_g1303_i0 | PRJNA565778 | 1403 | 751 | 11.747899 | 88.22672149 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 1306 | 0 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g1303 | i0 | 99.444 | 95.7470039946738 | 719 | 4 | 96 | 0 | 1 | 719 | 5614 | 4896 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 71906 | 1306 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 4385857 | 4385857 | PRJNA565778_S_NODE_33844_length_187_cov_194.833333_g33548_i0 | PRJNA565778 | 33844 | 187 | 194.833333 | 364.33833271 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 268 | 1.46e-67 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g33548 | i0 | 99.329 | 79.6844919786096 | 149 | 0 | 79 | 1 | 38 | 185 | 3672 | 3820 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 14901 | 268 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 10762756 | 10762756 | PRJNA565778_S_NODE_4089_length_503_cov_73.881974_g3875_i0 | PRJNA565778 | 4089 | 503 | 73.881974 | 371.62632922 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 846 | 0 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g3875 | i0 | 99.57 | 92.4453280318091 | 465 | 1 | 92 | 1 | 3 | 466 | 3820 | 3356 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 46500 | 846 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 12037131 | 12037131 | PRJNA565778_S_NODE_11550_length_321_cov_258.095070_g11254_i0 | PRJNA565778 | 11550 | 321 | 258.09507 | 828.4851747 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 512 | 1.1499999999999998e-140 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g11254 | i0 | 99.643 | 86.8847352024922 | 280 | 1 | 87 | 0 | 5 | 284 | 5967 | 5688 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 27890 | 512 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 13312201 | 13312201 | PRJNA565778_S_NODE_22551_length_233_cov_6.224490_g22255_i0 | PRJNA565778 | 22551 | 233 | 6.22449 | 14.5030617 | Potexvirus pepini | 3433856 | Viruses | Viruses | 431 | 2.2899999999999996e-116 | NTclustered | gi|57282636|emb|AJ606361.1| | 112229 | g22255 | i0 | 100 | 81.4892703862661 | 233 | 0 | 100 | 0 | 1 | 233 | 6185 | 6417 | Pepino mosaic virus complete genome, isolate LP-2001 | blastn | 18987 | 431 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 17136184 | 17136184 | PRJNA565778_S_NODE_8674_length_366_cov_4.601824_g8378_i0 | PRJNA565778 | 8674 | 366 | 4.601824 | 16.84267584 | Potexvirus pepini | 3433856 | Viruses | Viruses | 625 | 1.6299999999999995e-174 | NTclustered | gi|251821320|emb|FN429033.1| | 112229 | g8378 | i0 | 100 | 92.3415300546448 | 338 | 0 | 92 | 0 | 29 | 366 | 239 | 576 | Pepino mosaic virus partial CP gene for coat protein, strain PV-0554, genomic RNA | blastn | 33797 | 625 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 20960248 | 20960248 | PRJNA565778_S_NODE_12697_length_308_cov_45.535055_g12401_i0 | PRJNA565778 | 12697 | 308 | 45.535055 | 140.2479694 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 472 | 1.86e-128 | NTclustered | gi|2217162015|gb|OL584366.1| | 12242 | g12401 | i0 | 98.864 | 85.7077922077922 | 264 | 3 | 86 | 0 | 37 | 300 | 1440 | 1703 | Tobacco mosaic virus isolate DSMZ PV-1199 genomic sequence | blastn | 26398 | 472 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20960394 | 20960394 | PRJNA565778_S_NODE_23477_length_228_cov_7.607330_g23181_i0 | PRJNA565778 | 23477 | 228 | 7.60733 | 17.3447124 | Bromovirus BMV | 3427622 | Viruses | Viruses | 344 | 2.99e-90 | NTclustered | gi|2214792991|gb|MW581063.1| | 12302 | g23181 | i0 | 98.469 | 28.3684210526316 | 196 | 2 | 86 | 1 | 1 | 195 | 1189 | 994 | Brome mosaic virus isolate BMV-R movement protein and coat protein genes, complete cds | blastn | 6468 | 344 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV |
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);;