contig_metadata
20 rows where bioproject = "PRJNA944406", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2199627 | 2199627 | PRJNA944406_P_NODE_1862_length_1024_cov_2.683491_g1215_i0 | PRJNA944406 | 1862 | 1024 | 2.683491 | 27.47894784 | Galium odoratum potexvirus | 2738917 | Viruses | Viruses | 773 | 0 | NTclustered | gi|1845309154|gb|MN814316.1| | 2738917 | g1215 | i0 | 80.483 | 17.953125 | 1035 | 180 | 100 | 15 | 1 | 1024 | 618 | 1641 | Galium odoratum potexvirus strain pt040-lat-5, complete genome | blastn | 18384 | 773 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Galium odoratum potexvirus | ||
| 3475031 | 3475031 | PRJNA944406_P_NODE_18763_length_303_cov_2.356522_g17804_i0 | PRJNA944406 | 18763 | 303 | 2.356522 | 7.14026166 | Bromovirus BMV | 3427622 | Viruses | Viruses | 532 | 8.269999999999998e-147 | NTclustered | gi|2204717160|gb|MZ504791.1| | 12302 | g17804 | i0 | 98.35 | 40.4488448844885 | 303 | 5 | 100 | 0 | 1 | 303 | 1857 | 1555 | Brome mosaic virus isolate BMV-MJ segment RNA3, complete sequence | blastn | 12256 | 532 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 4752665 | 4752665 | PRJNA944406_P_NODE_20164_length_294_cov_1.714932_g19205_i0 | PRJNA944406 | 20164 | 294 | 1.714932 | 5.04190008 | Carlavirus latensgaillardiae | 3427768 | Viruses | Viruses | 466 | 8.22e-127 | NTclustered | gi|1842103655|dbj|LC485538.1| | 1468172 | g19205 | i0 | 95.238 | 2.98639455782313 | 294 | 14 | 100 | 0 | 1 | 294 | 266 | 559 | Gaillardia latent virus Vf1 genomic RNA, nearly complete genome | blastn | 878 | 466 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensgaillardiae | ||
| 7302242 | 7302242 | PRJNA944406_P_NODE_112626_length_228_cov_3.974194_g111667_i0 | PRJNA944406 | 112626 | 228 | 3.974194 | 9.06116232 | Bromovirus BMV | 3427622 | Viruses | Viruses | 374 | 3.8199999999999984e-99 | NTclustered | gi|2214792971|gb|MW581056.1| | 12302 | g111667 | i0 | 96.46 | 33.7105263157895 | 226 | 8 | 99 | 0 | 1 | 226 | 1974 | 2199 | Brome mosaic virus isolate BMV-Ch4 RdRp polymerase gene, complete cds | blastn | 7686 | 374 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 7302681 | 7302681 | PRJNA944406_P_NODE_48646_length_264_cov_1.952880_g47687_i0 | PRJNA944406 | 48646 | 264 | 1.95288 | 5.1556032 | Panicovirus dactylis | 3047766 | Viruses | Viruses | 346 | 9.880000000000002e-91 | NTclustered | gi|195546694|ref|NC_011108.1| | 479060 | g47687 | i0 | 90.226 | 3.01893939393939 | 266 | 24 | 100 | 1 | 1 | 264 | 1361 | 1096 | Cocksfoot mild mosaic virus, complete genome | blastn | 797 | 346 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Panicovirus | Panicovirus dactylis | ||
| 8577686 | 8577686 | PRJNA944406_P_NODE_6247_length_513_cov_1.961364_g5292_i0 | PRJNA944406 | 6247 | 513 | 1.961364 | 10.06179732 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 542 | 2.44e-149 | NTclustered | gi|2520252303|gb|OQ993368.1| | 12188 | g5292 | i0 | 85.855 | 3.93567251461988 | 509 | 72 | 99 | 0 | 5 | 513 | 3268 | 2760 | White clover mosaic virus isolate DSMZ PV-1074, complete genome | blastn | 2019 | 542 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 14952162 | 14952162 | PRJNA944406_P_NODE_12592_length_356_cov_1.614841_g11633_i0 | PRJNA944406 | 12592 | 356 | 1.614841 | 5.74883396 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 390 | 6.289999999999999e-104 | NTclustered | gi|1036484819|dbj|LC159490.1| | 12188 | g11633 | i0 | 87.353 | 14.0898876404494 | 340 | 43 | 96 | 0 | 15 | 354 | 4167 | 3828 | White clover mosaic virus genomic RNA, complete genome, strain: RC, isolate: Cheongdo-2 | blastn | 5016 | 390 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 17502693 | 17502693 | PRJNA944406_P_NODE_35894_length_276_cov_1.517241_g34935_i0 | PRJNA944406 | 35894 | 276 | 1.517241 | 4.18758516 | Bromovirus BMV | 3427622 | Viruses | Viruses | 510 | 3.48e-140 | NTclustered | gi|2239525832|gb|MW568008.1| | 12302 | g34935 | i0 | 100 | 37.9927536231884 | 276 | 0 | 100 | 0 | 1 | 276 | 1554 | 1279 | Brome mosaic virus isolate BMV-N replication-associated protein gene, complete cds | blastn | 10486 | 510 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 18776292 | 18776292 | PRJNA944406_P_NODE_4115_length_652_cov_2.749568_g3209_i0 | PRJNA944406 | 4115 | 652 | 2.749568 | 17.92718336 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 896 | 0 | NTclustered | gi|2792601926|gb|PQ162444.1| | 12188 | g3209 | i0 | 91.538 | 22.5843558282209 | 650 | 55 | 99 | 0 | 3 | 652 | 15 | 664 | White clover mosaic virus isolate DSMZ PV-1407, complete genome | blastn | 14725 | 896 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 20050840 | 20050840 | PRJNA944406_P_NODE_11796_length_366_cov_0.989761_g10837_i0 | PRJNA944406 | 11796 | 366 | 0.989761 | 3.62252526 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 632 | 9.759999999999998e-177 | NTclustered | gi|1935607036|gb|MT747993.1| | 2789423 | g10837 | i0 | 97.814 | 1.99726775956284 | 366 | 8 | 100 | 0 | 1 | 366 | 106 | 471 | Skokie tombus-like virus strain USAdp-1 RNA-dependent RNA polymerase gene, complete cds | blastn | 731 | 632 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 20051123 | 20051123 | PRJNA944406_P_NODE_3756_length_690_cov_2.382496_g2871_i0 | PRJNA944406 | 3756 | 690 | 2.382496 | 16.4392224 | Skokie tombus-like virus | 2789423 | Viruses | Viruses | 1175 | 0 | NTclustered | gi|1933757594|gb|MW177751.1| | 2789423 | g2871 | i0 | 97.391 | 1 | 690 | 18 | 100 | 0 | 1 | 690 | 699 | 10 | Skokie tombus-like virus strain USAdp coat protein gene, partial cds | blastn | 690 | 1175 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 21326451 | 21326451 | PRJNA944406_P_NODE_2337_length_912_cov_2.507747_g1599_i0 | PRJNA944406 | 2337 | 912 | 2.507747 | 22.87065264 | Potexvirus trifolii | 3433859 | Viruses | Viruses | 756 | 0 | NTclustered | gi|1843793417|gb|MN399741.1| | 12188 | g1599 | i0 | 81.749 | 6.24451754385965 | 915 | 157 | 99 | 9 | 2 | 911 | 5163 | 4254 | White clover mosaic virus isolate Kreis Stormarn_17 RNA replication protein, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and coat protein genes, complete cds | blastn | 5695 | 756 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 21326764 | 21326764 | PRJNA944406_P_NODE_48977_length_264_cov_1.591623_g48018_i0 | PRJNA944406 | 48977 | 264 | 1.591623 | 4.20188472 | Ripothoz virus | 3131336 | Viruses | Viruses | 224 | 4.8299999999999996e-54 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g48018 | i0 | 82.397 | 40.3977272727273 | 267 | 37 | 100 | 8 | 1 | 264 | 5326 | 5585 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 10665 | 224 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 24211029 | 24211029 | PRJNA944406_P_NODE_4279_length_639_cov_1.196113_g3367_i0 | PRJNA944406 | 4279 | 639 | 1.196113 | 7.64316207 | Viruses | 10239 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|1933757591|gb|MW177750.1| | 2789423 | g3367 | i0 | 96.703 | 1.99687010954617 | 637 | 21 | 99 | 0 | 1 | 637 | 982 | 346 | Skokie tombus-like virus strain USAdp hypothetical protein 2 gene, partial cds | blastn | 1276 | 1064 | 0.99718045112781994 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Skokie tombus-like virus | |||
| 26898861 | 26898861 | PRJNA944406_P_NODE_49401_length_264_cov_1.209424_g48442_i0 | PRJNA944406 | 49401 | 264 | 1.209424 | 3.19287936 | White clover mosaic virus | 12188 | Viruses | Viruses | 175 | 1.1399999999999999e-48 | NR | NP_620715.1 | 12188 | g48442 | i0 | 98.9 | 0.988636363636364 | 87 | 1 | 98.9 | 0 | 262 | 2 | 1110 | 1196 | NP_620715.1 RNA replication protein [White clover mosaic virus] | diamond | 261 | 175 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 27720820 | 27720820 | PRJNA944406_P_NODE_6064_length_521_cov_2.406250_g5111_i0 | PRJNA944406 | 6064 | 521 | 2.40625 | 12.5365625 | White clover mosaic virus | 12188 | Viruses | Viruses | 336 | 1.8399999999999998e-104 | NR | NP_620715.1 | 12188 | g5111 | i0 | 95.4 | 0.99616122840691 | 173 | 8 | 99.6 | 0 | 519 | 1 | 723 | 895 | NP_620715.1 RNA replication protein [White clover mosaic virus] | diamond | 519 | 336 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus trifolii | ||
| 29937399 | 29937399 | PRJNA944406_P_NODE_34431_length_278_cov_1.195122_g33472_i0 | PRJNA944406 | 34431 | 278 | 1.195122 | 3.32243916 | Deltaflexivirus | 2169569 | Viruses | Viruses | 118 | 1.79e-28 | NR | QKN22675.1 | 2743100 | g33472 | i0 | 67 | 3.91726618705036 | 88 | 29 | 95 | 0 | 11 | 274 | 199 | 286 | QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3] | diamond | 1089 | 118 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Erysiphe necator associated flexivirus 3 | ||||
| 30341802 | 30341802 | PRJNA944406_P_NODE_112032_length_232_cov_2.358491_g111073_i0 | PRJNA944406 | 112032 | 232 | 2.358491 | 5.47169912 | Leptosphaeria biglobosa deltaflexivirus 2 | 2985705 | Viruses | Viruses | 102 | 4.5e-23 | NR | UYL94495.1 | 2985705 | g111073 | i0 | 65.3 | 0.969827586206897 | 75 | 26 | 97 | 0 | 231 | 7 | 1503 | 1577 | UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2] | diamond | 225 | 102 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Leptosphaeria biglobosa deltaflexivirus 2 | |||
| 30815181 | 30815181 | PRJNA944406_P_NODE_30694_length_281_cov_1.480769_g29735_i0 | PRJNA944406 | 30694 | 281 | 1.480769 | 4.16096089 | Grapevine-associated tymo-like virus 1 | 2814377 | Viruses | Viruses | 141 | 1.09e-36 | NR | QXN75447.1 | 2814377 | g29735 | i0 | 64.1 | 2.91459074733096 | 92 | 33 | 98.2 | 0 | 280 | 5 | 559 | 650 | QXN75447.1 MAG: RNA-dependent RNA polymerase [Grapevine-associated tymo-like virus 1] | diamond | 819 | 141 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Grapevine-associated tymo-like virus 1 | ||||
| 31194005 | 31194005 | PRJNA944406_P_NODE_83775_length_247_cov_0.885057_g82816_i0 | PRJNA944406 | 83775 | 247 | 0.885057 | 2.18609079 | Leptosphaeria biglobosa deltaflexivirus 2 | 2985705 | Viruses | Viruses | 154 | 2.319999999999999e-41 | NR | UYL94495.1 | 2985705 | g82816 | i0 | 92.6 | 0.983805668016194 | 81 | 6 | 98.4 | 0 | 245 | 3 | 1379 | 1459 | UYL94495.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa deltaflexivirus 2] | diamond | 243 | 154 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Leptosphaeria biglobosa deltaflexivirus 2 |
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);;