contig_metadata
12 rows where bioproject = "PRJNA674050", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2441608 | 2441608 | PRJNA674050_P_NODE_13302_length_282_cov_4.583732_g13099_i0 | PRJNA674050 | 13302 | 282 | 4.583732 | 12.92612424 | Tobamovirus | 12234 | Viruses | Viruses | 521 | 1.6499999999999996e-143 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g13099 | i0 | 100 | 100 | 282 | 0 | 100 | 0 | 1 | 282 | 3753 | 3472 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 28200 | 521 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 7544257 | 7544257 | PRJNA674050_P_NODE_6046_length_335_cov_1.748092_g5843_i0 | PRJNA674050 | 6046 | 335 | 1.748092 | 5.8561082 | Potexvirus | 12176 | Viruses | Viruses | 619 | 6.91e-173 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g5843 | i0 | 100 | 86.044776119403 | 335 | 0 | 100 | 0 | 1 | 335 | 2627 | 2293 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 28825 | 619 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11369927 | 11369927 | PRJNA674050_P_NODE_6769_length_327_cov_1.342520_g6566_i0 | PRJNA674050 | 6769 | 327 | 1.34252 | 4.3900404 | Potexvirus | 12176 | Viruses | Viruses | 599 | 8.759999999999997e-167 | NTclustered | gi|375808845|gb|JN835466.1| | 112229 | g6566 | i0 | 99.694 | 58.4709480122324 | 327 | 1 | 100 | 0 | 1 | 327 | 779 | 453 | Pepino mosaic virus strain CH2, complete genome | blastn | 19120 | 599 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 11369936 | 11369936 | PRJNA674050_P_NODE_8789_length_309_cov_1.317797_g8586_i0 | PRJNA674050 | 8789 | 309 | 1.317797 | 4.07199273 | Potexvirus | 12176 | Viruses | Viruses | 558 | 1.39e-154 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g8586 | i0 | 99.351 | 56.831715210356 | 308 | 2 | 99 | 0 | 2 | 309 | 3036 | 2729 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 17561 | 558 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 13398608 | 13398608 | PRJNA674050_P_NODE_91_length_2022_cov_3.617753_g53_i0 | PRJNA674050 | 91 | 2022 | 3.617753 | 73.15096566 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 3718 | 0 | NTclustered | gi|2201445642|gb|OM515246.1| | 1761477 | g53 | i0 | 99.852 | 100 | 2022 | 3 | 100 | 0 | 1 | 2022 | 3466 | 1445 | Tomato brown rugose fruit virus isolate 39986364, complete genome | blastn | 202200 | 3718 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 14673449 | 14673449 | PRJNA674050_P_NODE_552_length_957_cov_7.289593_g397_i0 | PRJNA674050 | 552 | 957 | 7.289593 | 69.76140501 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 1768 | 0 | NTclustered | gi|2201445642|gb|OM515246.1| | 1761477 | g397 | i0 | 100 | 100 | 957 | 0 | 100 | 0 | 1 | 957 | 4788 | 5744 | Tomato brown rugose fruit virus isolate 39986364, complete genome | blastn | 95700 | 1768 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 15947145 | 15947145 | PRJNA674050_P_NODE_793_length_780_cov_6.454031_g617_i0 | PRJNA674050 | 793 | 780 | 6.454031 | 50.3414418 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 1441 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g617 | i0 | 100 | 100 | 780 | 0 | 100 | 0 | 1 | 780 | 4496 | 3717 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 78000 | 1441 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 19018048 | 19018048 | PRJNA674050_P_NODE_395_length_1160_cov_2.668813_g266_i0 | PRJNA674050 | 395 | 1160 | 2.668813 | 30.9582308 | Tobamovirus | 12234 | Viruses | Viruses | 2141 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g266 | i0 | 100 | 99.9137931034483 | 1159 | 0 | 99 | 0 | 1 | 1159 | 230 | 1388 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 115900 | 2141 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 24118202 | 24118202 | PRJNA674050_P_NODE_1139_length_633_cov_6.496429_g945_i0 | PRJNA674050 | 1139 | 633 | 6.496429 | 41.12239557 | Tobamovirus | 12234 | Viruses | Viruses | 1170 | 0 | NTclustered | gi|2837380407|gb|PP099942.1| | 1761477 | g945 | i0 | 100 | 100 | 633 | 0 | 100 | 0 | 1 | 633 | 5714 | 6346 | Tomato brown rugose fruit virus isolate NPPO-NL 41927291, complete genome | blastn | 63300 | 1170 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 25392832 | 25392832 | PRJNA674050_P_NODE_7920_length_316_cov_1.275720_g7717_i0 | PRJNA674050 | 7920 | 316 | 1.27572 | 4.0312752 | Potexvirus | 12176 | Viruses | Viruses | 582 | 8.489999999999998e-162 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g7717 | i0 | 100 | 57.8101265822785 | 315 | 0 | 99 | 0 | 2 | 316 | 1689 | 1375 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 18268 | 582 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 25392835 | 25392835 | PRJNA674050_P_NODE_8640_length_310_cov_1.565401_g8437_i0 | PRJNA674050 | 8640 | 310 | 1.565401 | 4.8527431 | Potexvirus | 12176 | Viruses | Viruses | 573 | 4.999999999999998e-159 | NTclustered | gi|2675378618|gb|PP116314.1| | 112229 | g8437 | i0 | 100 | 100 | 310 | 0 | 100 | 0 | 1 | 310 | 5061 | 4752 | MAG: Pepino mosaic virus isolate 7452_PepMV, complete genome | blastn | 31000 | 573 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 31167612 | 31167612 | PRJNA674050_P_NODE_3815_length_377_cov_1.493421_g3612_i0 | PRJNA674050 | 3815 | 377 | 1.493421 | 5.63019717 | Carlavirus | 12163 | Viruses | Viruses | 193 | 2.6099999999999998e-54 | NR | WOL52747.1 | 1092564 | g3612 | i0 | 78.4 | 1.9893899204244 | 125 | 27 | 99.5 | 0 | 3 | 377 | 285 | 409 | WOL52747.1 replicase [Cucumber vein-clearing virus] | diamond | 750 | 193 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus cucumis |
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);;