contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA404067" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1689728 | 1689728 | PRJNA404067_P_NODE_6402_length_491_cov_459.460465_g6026_i0 | PRJNA404067 | 6402 | 491 | 459.460465 | 2255.95088315 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.013 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g6026 | i0 | 96.875 | 0.122199592668024 | 32 | 1 | 7 | 0 | 460 | 491 | 44 | 13 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 60 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 2965332 | 2965332 | PRJNA404067_P_NODE_2643_length_1301_cov_10.150806_g2395_i0 | PRJNA404067 | 2643 | 1301 | 10.150806 | 132.06198606 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 56.5 | 0.01 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g2395 | i0 | 100 | 0.0453497309761722 | 30 | 0 | 2 | 0 | 1272 | 1301 | 85 | 56 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 59 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 6792568 | 6792568 | PRJNA404067_P_NODE_40346_length_195_cov_4.522388_g39959_i0 | PRJNA404067 | 40346 | 195 | 4.522388 | 8.8186566 | Triticeae associated alphaendornavirus | 2789206 | Viruses | Viruses | 327 | 2.5e-85 | NTclustered | gi|1933854982|gb|MW091544.1| | 2789206 | g39959 | i0 | 96.923 | 1 | 195 | 6 | 100 | 0 | 1 | 195 | 8837 | 8643 | Triticeae associated alphaendornavirus isolate Wheeler, complete genome | blastn | 195 | 327 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Triticeae associated alphaendornavirus | ||
| 13168250 | 13168250 | PRJNA404067_P_NODE_20031_length_237_cov_0.772727_g19644_i0 | PRJNA404067 | 20031 | 237 | 0.772727 | 1.83136299 | Triticeae associated alphaendornavirus | 2789206 | Viruses | Viruses | 394 | 3.069999999999999e-105 | NTclustered | gi|1933854982|gb|MW091544.1| | 2789206 | g19644 | i0 | 96.624 | 1 | 237 | 8 | 100 | 0 | 1 | 237 | 1784 | 1548 | Triticeae associated alphaendornavirus isolate Wheeler, complete genome | blastn | 237 | 394 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Endornaviridae | Alphaendornavirus | Triticeae associated alphaendornavirus | ||
| 14443471 | 14443471 | PRJNA404067_P_NODE_22892_length_228_cov_1.640719_g22505_i0 | PRJNA404067 | 22892 | 228 | 1.640719 | 3.74083932 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 399 | 6.299999999999999e-107 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g22505 | i0 | 98.246 | 1.49122807017544 | 228 | 4 | 100 | 0 | 1 | 228 | 3550 | 3323 | Malassezia restricta virus MrV40L, complete genome | blastn | 340 | 399 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 16992013 | 16992013 | PRJNA404067_P_NODE_21074_length_233_cov_2.930233_g20687_i0 | PRJNA404067 | 21074 | 233 | 2.930233 | 6.82744289 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 414 | 2.3099999999999998e-111 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g20687 | i0 | 98.712 | 1.44635193133047 | 233 | 3 | 100 | 0 | 1 | 233 | 413 | 181 | Malassezia restricta virus MrV40L, complete genome | blastn | 337 | 414 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 20816146 | 20816146 | PRJNA404067_P_NODE_20557_length_235_cov_1.183908_g20170_i0 | PRJNA404067 | 20557 | 235 | 1.183908 | 2.7821838 | Chrocagost virus | 3129398 | Viruses | Viruses | 309 | 1.13e-79 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g20170 | i0 | 90.87 | 467.825531914894 | 230 | 21 | 98 | 0 | 6 | 235 | 5619 | 5848 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 109939 | 309 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 24640863 | 24640863 | PRJNA404067_P_NODE_17640_length_248_cov_0.823529_g17253_i0 | PRJNA404067 | 17640 | 248 | 0.823529 | 2.04235192 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 414 | 2.48e-111 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g17253 | i0 | 96.787 | 1.00403225806452 | 249 | 6 | 100 | 2 | 1 | 248 | 2081 | 1834 | Malassezia restricta virus MrV40L, complete genome | blastn | 249 | 414 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 24641165 | 24641165 | PRJNA404067_P_NODE_34980_length_204_cov_3.482517_g34593_i0 | PRJNA404067 | 34980 | 204 | 3.482517 | 7.10433468 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 372 | 1.2e-98 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g34593 | i0 | 99.51 | 2 | 204 | 1 | 100 | 0 | 1 | 204 | 2969 | 3172 | Malassezia restricta virus MrV40L, complete genome | blastn | 408 | 372 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L |
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);;