contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1973147 | 1973147 | PRJNA704949_P_NODE_37362_length_1268_cov_7.850697_g27610_i0 | PRJNA704949 | 37362 | 1268 | 7.850697 | 99.54683796 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2242 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g27610 | i0 | 98.58 | 1 | 1268 | 18 | 100 | 0 | 1 | 1268 | 2739 | 1472 | Malassezia restricta virus MrV40L, complete genome | blastn | 1268 | 2242 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 2462677 | 2462677 | PRJNA704949_P_NODE_1748642_length_181_cov_1.575758_g1733303_i0 | PRJNA704949 | 1748642 | 181 | 1.575758 | 2.85212198 | Vesiculovirus | 11271 | Viruses | Viruses | 320 | 3.82e-83 | NTclustered | gi|61832|emb|V01213.1| | 11276 | g1733303 | i0 | 99.432 | 97.2044198895028 | 176 | 1 | 97 | 0 | 6 | 181 | 256 | 431 | Vesicular stomatitis virus gene fragment encoding the G protein | blastn | 17594 | 320 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 5019248 | 5019248 | PRJNA704949_P_NODE_95364_length_800_cov_4.909454_g83061_i0 | PRJNA704949 | 95364 | 800 | 4.909454 | 39.275632 | root | 1 | Root_unresolved | Root_unresolved | 1445 | 0 | NTclustered | gi|2649349941|gb|OR995580.1| | 11276 | g83061 | i0 | 100 | 98.79625 | 782 | 0 | 98 | 0 | 19 | 800 | 3498 | 4279 | Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome | blastn | 79037 | 1445 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Vesiculovirus | Vesicular stomatitis virus | ||
| 8343837 | 8343837 | PRJNA704949_P_NODE_1581947_length_194_cov_1.331034_g1566608_i0 | PRJNA704949 | 1581947 | 194 | 1.331034 | 2.58220596 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 353 | 4.1e-93 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g1566608 | i0 | 99.485 | 1.70103092783505 | 194 | 1 | 100 | 0 | 1 | 194 | 3492 | 3299 | Malassezia restricta virus MrV40L, complete genome | blastn | 330 | 353 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 8838828 | 8838828 | PRJNA704949_P_NODE_1241107_length_227_cov_1.752809_g1225770_i0 | PRJNA704949 | 1241107 | 227 | 1.752809 | 3.97887643 | Viruses | 10239 | Viruses | Viruses | 69.4 | 2.01e-7 | NTclustered | gi|2557652486|emb|OY682391.1| | 2697049 | g1225770 | i0 | 95.455 | 16.8370044052863 | 44 | 0 | 19 | 2 | 1 | 44 | 11279 | 11238 | Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite | blastn | 3822 | 69.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 12180013 | 12180013 | PRJNA704949_P_NODE_772610_length_304_cov_1.819608_g757279_i0 | PRJNA704949 | 772610 | 304 | 1.819608 | 5.53160832 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 52.8 | 0.028 | NTclustered | gi|2196304047|gb|MZ679036.1| | 3003959 | g757279 | i0 | 94.286 | 0.115131578947368 | 35 | 1 | 12 | 1 | 143 | 177 | 4155 | 4188 | MAG: Picornavirales sp. isolate s56-k141_864870 putative polyprotein gene, complete cds | blastn | 35 | 52.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 14725031 | 14725031 | PRJNA704949_P_NODE_273672_length_511_cov_3.461039_g259002_i0 | PRJNA704949 | 273672 | 511 | 3.461039 | 17.68590929 | Ilarvirus PNRSV | 3429931 | Viruses | Viruses | 939 | 0 | NTclustered | gi|1530829376|gb|MH427285.1| | 37733 | g259002 | i0 | 99.804 | 99.9804305283757 | 511 | 1 | 100 | 0 | 1 | 511 | 337 | 847 | Prunus necrotic ringspot virus isolate PNRSV-RNA3-SA movement protein and coat protein genes, complete cds | blastn | 51090 | 939 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Ilarvirus | Ilarvirus PNRSV | ||
| 19816065 | 19816065 | PRJNA704949_P_NODE_1396996_length_210_cov_2.260870_g1381658_i0 | PRJNA704949 | 1396996 | 210 | 2.26087 | 4.747827 | Tobamovirus rapae | 3432887 | Viruses | Viruses | 383 | 5.75e-102 | NTclustered | gi|691192970|gb|KM067150.1| | 29272 | g1381658 | i0 | 99.524 | 17.947619047619 | 210 | 1 | 100 | 0 | 1 | 210 | 440 | 231 | Turnip vein-clearing virus isolate Minnesota movement protein (MP) and coat protein (CP) genes, partial cds | blastn | 3769 | 383 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus rapae | ||
| 19824876 | 19824876 | PRJNA704949_P_NODE_460116_length_401_cov_3.642045_g444905_i0 | PRJNA704949 | 460116 | 401 | 3.642045 | 14.60460045 | Totiviridae sp. | 1955172 | Viruses | Viruses | 243 | 2.12e-59 | NTclustered | gi|2396038768|gb|ON812661.1| | 1955172 | g444905 | i0 | 80.984 | 2.40648379052369 | 305 | 58 | 76 | 0 | 96 | 400 | 4520 | 4216 | MAG: Totiviridae sp. isolate TIGMIC_4, complete genome | blastn | 965 | 243 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Totiviridae sp. | |||
| 21091613 | 21091613 | PRJNA704949_P_NODE_1390917_length_211_cov_1.401235_g1375579_i0 | PRJNA704949 | 1390917 | 211 | 1.401235 | 2.95660585 | Chemarfal virus 260 | 3063286 | Viruses | Viruses | 331 | 2.13e-86 | NTclustered | gi|2626079958|gb|OR270550.1| | 3063286 | g1375579 | i0 | 96.078 | 3.75355450236967 | 204 | 6 | 97 | 2 | 7 | 210 | 146 | 347 | MAG: Chemarfal virus 260 isolate ML188 genomic sequence | blastn | 792 | 331 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 260 | ||||
| 22374035 | 22374035 | PRJNA704949_P_NODE_322738_length_475_cov_1.708920_g307845_i0 | PRJNA704949 | 322738 | 475 | 1.70892 | 8.11737 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 850 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g307845 | i0 | 98.947 | 1.49263157894737 | 475 | 5 | 100 | 0 | 1 | 475 | 3191 | 2717 | Malassezia restricta virus MrV40L, complete genome | blastn | 709 | 850 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 23649709 | 23649709 | PRJNA704949_P_NODE_31699_length_1403_cov_2.081979_g22473_i0 | PRJNA704949 | 31699 | 1403 | 2.081979 | 29.21016537 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 2023 | 0 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g22473 | i0 | 98.517 | 1.23093371347113 | 1146 | 17 | 99 | 0 | 258 | 1403 | 333 | 1478 | Malassezia restricta virus MrV40L, complete genome | blastn | 1727 | 2023 | 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);;