contig_metadata
16 rows where bioproject = "PRJNA631796" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1152003 | 1152003 | PRJNA631796_P_NODE_13581_length_195_cov_2.432836_g13303_i0 | PRJNA631796 | 13581 | 195 | 2.432836 | 4.7440302 | Potexvirus | 12176 | Viruses | Viruses | 350 | 5.34e-92 | NTclustered | gi|1805119874|gb|MN038406.1| | 112229 | g13303 | i0 | 98.974 | 58.9384615384615 | 195 | 2 | 100 | 0 | 1 | 195 | 795 | 989 | Pepino mosaic virus strain MZ3, complete genome | blastn | 11493 | 350 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 3154260 | 3154260 | PRJNA631796_P_NODE_2003_length_504_cov_1.029345_g1728_i0 | PRJNA631796 | 2003 | 504 | 1.029345 | 5.1878988 | Potexvirus pepini | 3433856 | Viruses | Viruses | 893 | 0 | NTclustered | gi|336288971|gb|HQ663890.1| | 112229 | g1728 | i0 | 98.611 | 58.2757936507937 | 504 | 7 | 100 | 0 | 1 | 504 | 1221 | 1724 | Pepino mosaic virus isolate SAR09, complete genome | blastn | 29371 | 893 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 5707029 | 5707029 | PRJNA631796_P_NODE_7305_length_252_cov_1.586387_g7027_i0 | PRJNA631796 | 7305 | 252 | 1.586387 | 3.99769524 | Potexvirus pepini | 3433856 | Viruses | Viruses | 466 | 6.89e-127 | NTclustered | gi|1421680462|gb|MH550196.1| | 112229 | g7027 | i0 | 100 | 100 | 252 | 0 | 100 | 0 | 1 | 252 | 660 | 911 | Pepino mosaic virus isolate AG17-9b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 25200 | 466 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 8804973 | 8804973 | PRJNA631796_P_NODE_3887_length_353_cov_4.787671_g3609_i0 | PRJNA631796 | 3887 | 353 | 4.787671 | 16.90047863 | Potexvirus | 12176 | Viruses | Viruses | 625 | 1.5699999999999996e-174 | NTclustered | gi|1830461458|gb|MT018448.1| | 112229 | g3609 | i0 | 98.584 | 61.9830028328612 | 353 | 5 | 100 | 0 | 1 | 353 | 3879 | 3527 | Pepino mosaic virus isolate Mo, complete genome | blastn | 21880 | 625 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11355431 | 11355431 | PRJNA631796_P_NODE_3509_length_373_cov_4.009615_g3232_i0 | PRJNA631796 | 3509 | 373 | 4.009615 | 14.95586395 | Potexvirus | 12176 | Viruses | Viruses | 678 | 0 | NTclustered | gi|217031250|gb|FJ457097.1| | 112229 | g3232 | i0 | 99.464 | 59.8900804289544 | 373 | 2 | 100 | 0 | 1 | 373 | 1991 | 1619 | Pepino mosaic virus isolate PCH 06/104 replicase, triple gene block protein 1 (TGBp1), triple gene block protein 2 (TGBp2), triple gene block protein 3 (TGBp3), and coat protein genes, complete cds | blastn | 22339 | 678 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 14632319 | 14632319 | PRJNA631796_P_NODE_1432_length_601_cov_3.583333_g1168_i0 | PRJNA631796 | 1432 | 601 | 3.583333 | 21.53583133 | Potexvirus pepini | 3433856 | Viruses | Viruses | 1088 | 0 | NTclustered | gi|217031250|gb|FJ457097.1| | 112229 | g1168 | i0 | 99.334 | 70.1131447587354 | 601 | 4 | 100 | 0 | 1 | 601 | 3137 | 2537 | Pepino mosaic virus isolate PCH 06/104 replicase, triple gene block protein 1 (TGBp1), triple gene block protein 2 (TGBp2), triple gene block protein 3 (TGBp3), and coat protein genes, complete cds | blastn | 42138 | 1088 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 16454791 | 16454791 | PRJNA631796_P_NODE_5553_length_292_cov_3.783550_g5275_i0 | PRJNA631796 | 5553 | 292 | 3.78355 | 11.047966 | Potexvirus | 12176 | Viruses | Viruses | 529 | 1.0299999999999996e-145 | NTclustered | gi|2523281636|gb|OR082776.1| | 112229 | g5275 | i0 | 99.315 | 60.8527397260274 | 292 | 2 | 100 | 0 | 1 | 292 | 3261 | 3552 | Pepino mosaic virus isolate DSMZ PV-0999, complete genome | blastn | 17769 | 529 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 17729880 | 17729880 | PRJNA631796_P_NODE_13734_length_192_cov_4.030534_g13456_i0 | PRJNA631796 | 13734 | 192 | 4.030534 | 7.73862528 | Potexvirus | 12176 | Viruses | Viruses | 355 | 1.13e-93 | NTclustered | gi|1839429935|gb|MK860472.1| | 112229 | g13456 | i0 | 100 | 100 | 192 | 0 | 100 | 0 | 1 | 192 | 564 | 373 | Pepino mosaic virus isolate MU14_11.15a_Ra TGB1 protein, TGB2 protein, TGB3 protein, and CP protein genes, complete cds | blastn | 19200 | 355 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 17729896 | 17729896 | PRJNA631796_P_NODE_3214_length_390_cov_3.963526_g2937_i0 | PRJNA631796 | 3214 | 390 | 3.963526 | 15.4577514 | Potexvirus | 12176 | Viruses | Viruses | 710 | 0 | NTclustered | gi|2546780442|gb|OR138034.1| | 112229 | g2937 | i0 | 99.487 | 99.6076923076923 | 390 | 2 | 100 | 0 | 1 | 390 | 58 | 447 | Pepino mosaic virus isolate MXM18 RNA-dependent RNA polymerase gene, partial cds | blastn | 38847 | 710 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 18455506 | 18455506 | PRJNA631796_P_NODE_9775_length_220_cov_1.572327_g9497_i0 | PRJNA631796 | 9775 | 220 | 1.572327 | 3.4591194 | Bromovirus BMV | 3427622 | Viruses | Viruses | 363 | 7.92e-96 | NTclustered | gi|2239525971|gb|MW568013.1| | 12302 | g9497 | i0 | 96.364 | 34.3590909090909 | 220 | 8 | 100 | 0 | 1 | 220 | 667 | 448 | Brome mosaic virus isolate BMV-PK RdRp polymerase gene, complete cds | blastn | 7559 | 363 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 19729967 | 19729967 | PRJNA631796_P_NODE_11396_length_207_cov_5.410959_g11118_i0 | PRJNA631796 | 11396 | 207 | 5.410959 | 11.20068513 | Potexvirus pepini | 3433856 | Viruses | Viruses | 383 | 5.65e-102 | NTclustered | gi|2575892324|gb|OR233202.1| | 112229 | g11118 | i0 | 100 | 62.9710144927536 | 207 | 0 | 100 | 0 | 1 | 207 | 1238 | 1032 | Pepino mosaic virus isolate DSMZ PV-0716, complete genome | blastn | 13035 | 383 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 19730005 | 19730005 | PRJNA631796_P_NODE_3196_length_391_cov_3.603030_g2919_i0 | PRJNA631796 | 3196 | 391 | 3.60303 | 14.0878473 | Potexvirus pepini | 3433856 | Viruses | Viruses | 723 | 0 | NTclustered | gi|429474434|gb|JX866667.1| | 112229 | g2919 | i0 | 100 | 97.0204603580563 | 391 | 0 | 100 | 0 | 1 | 391 | 408 | 18 | Pepino mosaic virus isolate VFTX12-19, complete genome | blastn | 37935 | 723 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 19730021 | 19730021 | PRJNA631796_P_NODE_6476_length_269_cov_3.278846_g6198_i0 | PRJNA631796 | 6476 | 269 | 3.278846 | 8.82009574 | Potexvirus pepini | 3433856 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|1805119886|gb|MN038408.1| | 112229 | g6198 | i0 | 99.628 | 93.8289962825279 | 269 | 1 | 100 | 0 | 1 | 269 | 801 | 533 | Pepino mosaic virus strain AG2, complete genome | blastn | 25240 | 492 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 22280510 | 22280510 | PRJNA631796_P_NODE_9758_length_220_cov_1.855346_g9480_i0 | PRJNA631796 | 9758 | 220 | 1.855346 | 4.0817612 | Potexvirus pepini | 3433856 | Viruses | Viruses | 407 | 3.61e-109 | NTclustered | gi|1421680462|gb|MH550196.1| | 112229 | g9480 | i0 | 100 | 100 | 220 | 0 | 100 | 0 | 1 | 220 | 1094 | 875 | Pepino mosaic virus isolate AG17-9b TGBp1, TGBp2, TGBp3, and CP genes, complete cds | blastn | 22000 | 407 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 22829477 | 22829477 | PRJNA631796_P_NODE_6718_length_263_cov_2.866337_g6440_i0 | PRJNA631796 | 6718 | 263 | 2.866337 | 7.53846631 | Potexvirus | 12176 | Viruses | Viruses | 475 | 1.2e-129 | NTclustered | gi|148283741|gb|EF408821.3| | 112229 | g6440 | i0 | 99.24 | 97.8098859315589 | 263 | 2 | 100 | 0 | 1 | 263 | 4144 | 3882 | Pepino mosaic virus isolate PepMV-PK, complete genome | blastn | 25724 | 475 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 26922745 | 26922745 | PRJNA631796_P_NODE_12922_length_202_cov_0.907801_g12644_i0 | PRJNA631796 | 12922 | 202 | 0.907801 | 1.83375802 | Grapevine-associated tombus-like virus 3 | 2814343 | Viruses | Viruses | 67 | 2.17e-11 | NR | QXN75444.1 | 2814343 | g12644 | i0 | 61.4 | 0.653465346534653 | 44 | 17 | 65.3 | 0 | 66 | 197 | 2 | 45 | QXN75444.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated tombus-like virus 3] | diamond | 132 | 67 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Grapevine-associated tombus-like virus 3 |
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);;