contig_metadata
21 rows where bioproject = "PRJNA1035005", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1443352 | 1443352 | PRJNA1035005_P_NODE_11642_length_348_cov_1.090909_g11237_i0 | PRJNA1035005 | 11642 | 348 | 1.090909 | 3.79636332 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 643 | 4.279999999999998e-180 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g11237 | i0 | 100 | 100 | 348 | 0 | 100 | 0 | 1 | 348 | 1383 | 1730 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 34800 | 643 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 2719064 | 2719064 | PRJNA1035005_P_NODE_13903_length_330_cov_1.723735_g13497_i0 | PRJNA1035005 | 13903 | 330 | 1.723735 | 5.6883255 | Potexvirus pepini | 3433856 | Viruses | Viruses | 599 | 8.849999999999995e-167 | NTclustered | gi|251821320|emb|FN429033.1| | 112229 | g13497 | i0 | 99.394 | 99.9969696969697 | 330 | 2 | 100 | 0 | 1 | 330 | 620 | 291 | Pepino mosaic virus partial CP gene for coat protein, strain PV-0554, genomic RNA | blastn | 32999 | 599 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 2719193 | 2719193 | PRJNA1035005_P_NODE_27363_length_286_cov_1.417840_g26957_i0 | PRJNA1035005 | 27363 | 286 | 1.41784 | 4.0550224 | Allexivirus alphallii | 3433708 | Viruses | Viruses | 516 | 7.799999999999999e-142 | NTclustered | gi|1722560694|gb|MN059278.1| | 12433 | g26957 | i0 | 99.298 | 46.6818181818182 | 285 | 2 | 99 | 0 | 2 | 286 | 3559 | 3275 | Garlic virus A isolate G39, complete genome | blastn | 13351 | 516 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Allexivirus | Allexivirus alphallii | ||
| 3995296 | 3995296 | PRJNA1035005_P_NODE_29924_length_282_cov_3.023923_g29518_i0 | PRJNA1035005 | 29924 | 282 | 3.023923 | 8.52746286 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 510 | 3.57e-140 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g29518 | i0 | 99.291 | 3.00709219858156 | 282 | 2 | 100 | 0 | 1 | 282 | 5690 | 5409 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 848 | 510 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 3995334 | 3995334 | PRJNA1035005_P_NODE_3584_length_572_cov_2.184369_g3191_i0 | PRJNA1035005 | 3584 | 572 | 2.184369 | 12.49459068 | Potexvirus pepini | 3433856 | Viruses | Viruses | 1042 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g3191 | i0 | 99.649 | 59.520979020979 | 570 | 2 | 99 | 0 | 1 | 570 | 1168 | 1737 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 34046 | 1042 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 6111062 | 6111062 | PRJNA1035005_P_NODE_5305_length_461_cov_1.206186_g4905_i0 | PRJNA1035005 | 5305 | 461 | 1.206186 | 5.56051746 | Potexvirus | 12176 | Viruses | Viruses | 835 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g4905 | i0 | 99.349 | 81.5162689804772 | 461 | 3 | 100 | 0 | 1 | 461 | 2857 | 2397 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 37579 | 835 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 8660926 | 8660926 | PRJNA1035005_P_NODE_2327_length_760_cov_2.374090_g1952_i0 | PRJNA1035005 | 2327 | 760 | 2.37409 | 18.043084 | Potexvirus | 12176 | Viruses | Viruses | 1393 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g1952 | i0 | 99.737 | 100 | 760 | 2 | 100 | 0 | 1 | 760 | 4638 | 5397 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 76000 | 1393 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 8661047 | 8661047 | PRJNA1035005_P_NODE_5687_length_446_cov_1.718499_g5287_i0 | PRJNA1035005 | 5687 | 446 | 1.718499 | 7.66450554 | Potexvirus | 12176 | Viruses | Viruses | 824 | 0 | NTclustered | gi|2106121581|gb|MW848530.1| | 112229 | g5287 | i0 | 100 | 58.5762331838565 | 446 | 0 | 100 | 0 | 1 | 446 | 2083 | 2528 | Pepino mosaic virus isolate NGSTPS18, complete genome | blastn | 26125 | 824 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 9096476 | 9096476 | PRJNA1035005_P_NODE_4728_length_490_cov_2.062350_g4328_i0 | PRJNA1035005 | 4728 | 490 | 2.06235 | 10.105515 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 828 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g4328 | i0 | 97.143 | 1 | 490 | 14 | 100 | 0 | 1 | 490 | 4238 | 4727 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 490 | 828 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 9935839 | 9935839 | PRJNA1035005_P_NODE_12728_length_338_cov_3.532075_g12323_i0 | PRJNA1035005 | 12728 | 338 | 3.532075 | 11.9384135 | Potexvirus | 12176 | Viruses | Viruses | 614 | 3.2499999999999993e-171 | NTclustered | gi|2523281636|gb|OR082776.1| | 112229 | g12323 | i0 | 99.408 | 98.8757396449704 | 338 | 2 | 100 | 0 | 1 | 338 | 47 | 384 | Pepino mosaic virus isolate DSMZ PV-0999, complete genome | blastn | 33420 | 614 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 10372070 | 10372070 | PRJNA1035005_P_NODE_3989_length_535_cov_2.261905_g3591_i0 | PRJNA1035005 | 3989 | 535 | 2.261905 | 12.10119175 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 854 | 0 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g3591 | i0 | 95.841 | 0.988785046728972 | 529 | 21 | 99 | 1 | 7 | 535 | 5816 | 6343 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 529 | 854 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 11211159 | 11211159 | PRJNA1035005_P_NODE_4089_length_528_cov_2.006593_g3691_i0 | PRJNA1035005 | 4089 | 528 | 2.006593 | 10.59481104 | Potexvirus | 12176 | Viruses | Viruses | 965 | 0 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g3691 | i0 | 99.621 | 97.6325757575758 | 528 | 2 | 100 | 0 | 1 | 528 | 4040 | 4567 | Pepino mosaic virus strain CH2, complete genome | blastn | 51550 | 965 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11647451 | 11647451 | PRJNA1035005_P_NODE_51270_length_255_cov_1.714286_g50864_i0 | PRJNA1035005 | 51270 | 255 | 1.714286 | 4.3714293 | Potexvirus pepini | 3433856 | Viruses | Viruses | 472 | 1.5e-128 | NTclustered | gi|2106121581|gb|MW848530.1| | 112229 | g50864 | i0 | 100 | 41.4980392156863 | 255 | 0 | 100 | 0 | 1 | 255 | 3414 | 3160 | Pepino mosaic virus isolate NGSTPS18, complete genome | blastn | 10582 | 472 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 12486600 | 12486600 | PRJNA1035005_P_NODE_13030_length_336_cov_2.019011_g12624_i0 | PRJNA1035005 | 13030 | 336 | 2.019011 | 6.78387696 | Potexvirus | 12176 | Viruses | Viruses | 616 | 8.96e-172 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g12624 | i0 | 99.702 | 60.7678571428571 | 336 | 1 | 100 | 0 | 1 | 336 | 3198 | 3533 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 20418 | 616 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 17585736 | 17585736 | PRJNA1035005_P_NODE_6254_length_429_cov_1.314607_g5852_i0 | PRJNA1035005 | 6254 | 429 | 1.314607 | 5.63966403 | Potexvirus | 12176 | Viruses | Viruses | 776 | 0 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g5852 | i0 | 99.301 | 88.013986013986 | 429 | 3 | 100 | 0 | 1 | 429 | 3209 | 2781 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 37758 | 776 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18020500 | 18020500 | PRJNA1035005_P_NODE_1395_length_1084_cov_2.214639_g1096_i0 | PRJNA1035005 | 1395 | 1084 | 2.214639 | 24.00668676 | Potexvirus pepini | 3433856 | Viruses | Viruses | 2002 | 0 | NTclustered | gi|1345606524|gb|MF422616.1| | 112229 | g1096 | i0 | 100 | 98.8717712177122 | 1084 | 0 | 100 | 0 | 1 | 1084 | 17 | 1100 | Pepino mosaic virus isolate LP_HYT25, complete genome | blastn | 107177 | 2002 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18020720 | 18020720 | PRJNA1035005_P_NODE_4075_length_529_cov_2.778509_g3677_i0 | PRJNA1035005 | 4075 | 529 | 2.778509 | 14.69831261 | Potexvirus pepini | 3433856 | Viruses | Viruses | 931 | 0 | NTclustered | gi|1345606524|gb|MF422616.1| | 112229 | g3677 | i0 | 100 | 95.3534971644612 | 504 | 0 | 95 | 0 | 1 | 504 | 5282 | 5785 | Pepino mosaic virus isolate LP_HYT25, complete genome | blastn | 50442 | 931 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18021074 | 18021074 | PRJNA1035005_P_NODE_86775_length_240_cov_2.802395_g86369_i0 | PRJNA1035005 | 86775 | 240 | 2.802395 | 6.725748 | Potexvirus pepini | 3433856 | Viruses | Viruses | 444 | 3.05e-120 | NTclustered | gi|2106121581|gb|MW848530.1| | 112229 | g86369 | i0 | 100 | 100 | 240 | 0 | 100 | 0 | 1 | 240 | 4752 | 4991 | Pepino mosaic virus isolate NGSTPS18, complete genome | blastn | 24000 | 444 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18859522 | 18859522 | PRJNA1035005_P_NODE_5715_length_445_cov_1.677419_g5315_i0 | PRJNA1035005 | 5715 | 445 | 1.677419 | 7.46451455 | Potexvirus | 12176 | Viruses | Viruses | 822 | 0 | NTclustered | gi|2419393209|gb|ON398497.1| | 112229 | g5315 | i0 | 100 | 39.6696629213483 | 445 | 0 | 100 | 0 | 1 | 445 | 3145 | 2701 | Pepino mosaic virus isolate DSMZ PV-0554, complete genome | blastn | 17653 | 822 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 21845556 | 21845556 | PRJNA1035005_P_NODE_14238_length_328_cov_1.435294_g13832_i0 | PRJNA1035005 | 14238 | 328 | 1.435294 | 4.70776432 | brine shrimp tymo-like virus 1 | 2900478 | Viruses | Viruses | 556 | 5.36e-154 | NTclustered | gi|2209095027|gb|OL472799.1| | 2900478 | g13832 | i0 | 97.256 | 1.71951219512195 | 328 | 9 | 100 | 0 | 1 | 328 | 4226 | 3899 | MAG: Brine shrimp tymo-like virus 1 isolate YC/91 RNA-dependent RNA polymerase and coat superfamily protein genes, complete cds | blastn | 564 | 556 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | brine shrimp tymo-like virus 1 | |||
| 23960333 | 23960333 | PRJNA1035005_P_NODE_9519_length_370_cov_1.050505_g9115_i0 | PRJNA1035005 | 9519 | 370 | 1.050505 | 3.8868685 | Tobamovirus | 12234 | Viruses | Viruses | 673 | 0 | NTclustered | gi|2201445597|gb|OM515237.1| | 1761477 | g9115 | i0 | 99.459 | 100 | 370 | 2 | 100 | 0 | 1 | 370 | 5898 | 5529 | Tomato brown rugose fruit virus isolate 6166394_2, complete genome | blastn | 37000 | 673 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum |
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);;