contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166865 | 166865 | PRJNA1031674_P_NODE_6521_length_341_cov_3.869403_g6310_i0 | PRJNA1031674 | 6521 | 341 | 3.869403 | 13.19466423 | Chronacard virus | 3129783 | Viruses | Viruses | 420 | 7.67e-113 | NTclustered | gi|2717318323|gb|PP172180.1| | 3129783 | g6310 | i0 | 96.825 | 253.513196480938 | 252 | 6 | 74 | 2 | 1 | 251 | 251 | 1 | MAG: Chronacard virus isolate CN1A_k141_43539 genomic sequence | blastn | 86448 | 420 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Chronacard virus | |||
| 3993047 | 3993047 | PRJNA1031674_P_NODE_1004_length_720_cov_1.183926_g809_i0 | PRJNA1031674 | 1004 | 720 | 1.183926 | 8.5242672 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 1280 | 0 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g809 | i0 | 98.75 | 2.78055555555556 | 720 | 9 | 100 | 0 | 1 | 720 | 3358 | 4077 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 2002 | 1280 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 3993175 | 3993175 | PRJNA1031674_P_NODE_17864_length_267_cov_1.587629_g17653_i0 | PRJNA1031674 | 17864 | 267 | 1.587629 | 4.23896943 | Crinivirus flavisolani | 3428113 | Viruses | Viruses | 62.1 | 4.06e-5 | NTclustered | gi|375127651|gb|JN701960.1| | 103881 | g17653 | i0 | 100 | 3.21348314606742 | 33 | 0 | 12 | 0 | 77 | 109 | 379 | 411 | Potato yellow vein virus isolate 716 Ipiales heat shock protein gene, complete cds | blastn | 858 | 62.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Crinivirus | Crinivirus flavisolani | ||
| 9094118 | 9094118 | PRJNA1031674_P_NODE_12448_length_285_cov_1.702830_g12237_i0 | PRJNA1031674 | 12448 | 285 | 1.70283 | 4.8530655 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 518 | 2.16e-142 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g12237 | i0 | 99.647 | 1.9859649122807 | 283 | 1 | 99 | 0 | 3 | 285 | 4385 | 4103 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 566 | 518 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 10369951 | 10369951 | PRJNA1031674_P_NODE_22249_length_251_cov_0.865169_g22038_i0 | PRJNA1031674 | 22249 | 251 | 0.865169 | 2.17157419 | Sobemovirus RGMOV | 3432504 | Viruses | Viruses | 448 | 2.48e-121 | NTclustered | gi|2129881132|gb|OK424596.1| | 119910 | g22038 | i0 | 98.805 | 10.804780876494 | 251 | 3 | 100 | 0 | 1 | 251 | 3550 | 3300 | Ryegrass mottle virus isolate RMV/Seattle/USA/2021, complete genome | blastn | 2712 | 448 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus RGMOV | ||
| 12920266 | 12920266 | PRJNA1031674_P_NODE_10151_length_295_cov_2.450450_g9940_i0 | PRJNA1031674 | 10151 | 295 | 2.45045 | 7.2288275 | Skokie dicistro-like virus | 2789443 | Viruses | Viruses | 518 | 2.25e-142 | NTclustered | gi|2806502719|gb|PQ054859.1| | 2789443 | g9940 | i0 | 98.305 | 7.18983050847458 | 295 | 5 | 100 | 0 | 1 | 295 | 1660 | 1954 | MAG: Skokie dicistro-like virus isolate QJ5MS4721 genomic sequence | blastn | 2121 | 518 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Skokie dicistro-like virus | |||
| 12920387 | 12920387 | PRJNA1031674_P_NODE_17511_length_268_cov_2.194872_g17300_i0 | PRJNA1031674 | 17511 | 268 | 2.194872 | 5.88225696 | Bromovirus BMV | 3427622 | Viruses | Viruses | 484 | 2.0399999999999996e-132 | NTclustered | gi|2329659857|gb|OK558642.1| | 12302 | g17300 | i0 | 99.257 | 33.910447761194 | 269 | 1 | 100 | 1 | 1 | 268 | 1671 | 1939 | Brome mosaic virus isolate VRS-315 hypothetical protein gene, complete cds | blastn | 9088 | 484 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 15469465 | 15469465 | PRJNA1031674_P_NODE_17253_length_269_cov_2.117347_g17042_i0 | PRJNA1031674 | 17253 | 269 | 2.117347 | 5.69566343 | Johnsongrass virus | 2845206 | Viruses | Viruses | 497 | 2.63e-136 | NTclustered | gi|2052625483|gb|MW756210.1| | 2845206 | g17042 | i0 | 100 | 7 | 269 | 0 | 100 | 0 | 1 | 269 | 1928 | 2196 | Johnsongrass virus isolate JVG-1 polyprotein gene, complete cds | blastn | 1883 | 497 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Johnsongrass virus |
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);;