contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644772 | 644772 | PRJNA674308_P_NODE_44501_length_165_cov_2.275862_g44266_i0 | PRJNA674308 | 44501 | 165 | 2.275862 | 3.7551723 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 305 | 9.59e-79 | NTclustered | gi|1240393784|gb|MF141071.1| | 2034334 | g44266 | i0 | 100 | 4 | 165 | 0 | 100 | 0 | 1 | 165 | 2371 | 2535 | Norway luteo-like virus 4 isolate NOR/S5/Kilen/2014 RNA-dependent RNA-polymerase gene, partial cds | blastn | 660 | 305 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 1920701 | 1920701 | PRJNA674308_P_NODE_14202_length_255_cov_7.946602_g13967_i0 | PRJNA674308 | 14202 | 255 | 7.946602 | 20.2638351 | Sopidub virus | 3131684 | Viruses | Viruses | 169 | 2.2e-37 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g13967 | i0 | 91.129 | 59.4509803921569 | 124 | 11 | 49 | 0 | 132 | 255 | 2130 | 2253 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 15160 | 169 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 1920796 | 1920796 | PRJNA674308_P_NODE_24882_length_200_cov_1.721854_g24647_i0 | PRJNA674308 | 24882 | 200 | 1.721854 | 3.443708 | Malassezia restricta associated totivirus 2 | 3048758 | Viruses | Viruses | 320 | 4.31e-83 | NTclustered | gi|2512878154|emb|OX637980.1| | 3048758 | g24647 | i0 | 95.5 | 3.91 | 200 | 9 | 100 | 0 | 1 | 200 | 272 | 471 | Malassezia restricta associated totivirus 2 CP gene for capsid protein | blastn | 782 | 320 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Orthototiviridae | Totivirus | Malassezia restricta associated totivirus 2 | ||
| 1921043 | 1921043 | PRJNA674308_P_NODE_54882_length_152_cov_2.009709_g54647_i0 | PRJNA674308 | 54882 | 152 | 2.009709 | 3.05475768 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 270 | 3.15e-68 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g54647 | i0 | 98.684 | 2 | 152 | 2 | 100 | 0 | 1 | 152 | 3026 | 3177 | Malassezia restricta virus MrV40L, complete genome | blastn | 304 | 270 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 7023272 | 7023272 | PRJNA674308_P_NODE_15746_length_244_cov_1.594872_g15511_i0 | PRJNA674308 | 15746 | 244 | 1.594872 | 3.89148768 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 346 | 9.019999999999999e-91 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g15511 | i0 | 92.245 | 1.00409836065574 | 245 | 18 | 100 | 1 | 1 | 244 | 689 | 933 | Malassezia restricta virus MrV40S, complete genome | blastn | 245 | 346 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 7023501 | 7023501 | PRJNA674308_P_NODE_42066_length_166_cov_59596.615385_g41831_i0 | PRJNA674308 | 42066 | 166 | 59596.615385 | 98930.3815391 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 102 | 1.36e-17 | NTclustered | gi|2155033579|emb|OV039277.1| | 2697049 | g41831 | i0 | 84 | 11.4638554216867 | 125 | 0 | 63 | 2 | 62 | 166 | 30637 | 30513 | Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 | blastn | 1903 | 102 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 8298067 | 8298067 | PRJNA674308_P_NODE_30407_length_183_cov_1.552239_g30172_i0 | PRJNA674308 | 30407 | 183 | 1.552239 | 2.84059737 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 307 | 3.0100000000000005e-79 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g30172 | i0 | 97.253 | 0.994535519125683 | 182 | 3 | 99 | 2 | 1 | 181 | 1782 | 1962 | Malassezia restricta virus MrV40L, complete genome | blastn | 182 | 307 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 9573474 | 9573474 | PRJNA674308_P_NODE_54308_length_159_cov_2.836364_g54073_i0 | PRJNA674308 | 54308 | 159 | 2.836364 | 4.50981876 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 187 | 3.459999999999999e-43 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g54073 | i0 | 88.387 | 0.974842767295597 | 155 | 18 | 97 | 0 | 3 | 157 | 1 | 155 | Malassezia restricta virus MrV40S, complete genome | blastn | 155 | 187 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 10095075 | 10095075 | PRJNA674308_P_NODE_12148_length_275_cov_1.610619_g11913_i0 | PRJNA674308 | 12148 | 275 | 1.610619 | 4.42920225 | Tobamovirus | 12234 | Viruses | Viruses | 503 | 5.809999999999998e-138 | NTclustered | gi|1559989139|gb|MK273185.1| | 1761477 | g11913 | i0 | 99.636 | 100 | 275 | 1 | 100 | 0 | 1 | 275 | 875 | 601 | Tomato brown rugose fruit virus isolate TAN3 RNA-dependent RNA polymerase (RdRp) gene, partial cds | blastn | 27500 | 503 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 12123881 | 12123881 | PRJNA674308_P_NODE_12950_length_267_cov_0.885321_g12715_i0 | PRJNA674308 | 12950 | 267 | 0.885321 | 2.36380707 | Malassezia restricta virus MrV40L | 2727863 | Viruses | Viruses | 422 | 1.62e-113 | NTclustered | gi|1832308141|gb|MN603497.1| | 2727863 | g12715 | i0 | 95.131 | 1.50187265917603 | 267 | 13 | 100 | 0 | 1 | 267 | 443 | 177 | Malassezia restricta virus MrV40L, complete genome | blastn | 401 | 422 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40L | |||
| 14673630 | 14673630 | PRJNA674308_P_NODE_15932_length_243_cov_1.072165_g15697_i0 | PRJNA674308 | 15932 | 243 | 1.072165 | 2.60536095 | Tobamovirus fructirugosum | 3432872 | Viruses | Viruses | 449 | 6.65e-122 | NTclustered | gi|2048770702|gb|MW314091.1| | 1761477 | g15697 | i0 | 100 | 100 | 243 | 0 | 100 | 0 | 1 | 243 | 2894 | 3136 | Tomato brown rugose fruit virus isolate 6189975_2, partial genome | blastn | 24300 | 449 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum | ||
| 14673710 | 14673710 | PRJNA674308_P_NODE_25032_length_200_cov_1.178808_g24797_i0 | PRJNA674308 | 25032 | 200 | 1.178808 | 2.357616 | Polemovirus PNLV | 3431723 | Viruses | Viruses | 368 | 1.52e-97 | NTclustered | gi|2419393215|gb|ON398503.1| | 305785 | g24797 | i0 | 100 | 3.98 | 199 | 0 | 99 | 0 | 1 | 199 | 1220 | 1418 | Poinsettia latent virus isolate PV-0629 P0 protein, suppressor of RNA silencing (ORF0), P1-P2 protein, RNA-dependent RNA polymerase (ORF1-ORF2), P1 protein, replication-associated protein (ORF1), and coat protein (ORF3) genes, complete cds | blastn | 796 | 368 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Polemovirus | Polemovirus PNLV | ||
| 17222733 | 17222733 | PRJNA674308_P_NODE_22314_length_210_cov_1.291925_g22079_i0 | PRJNA674308 | 22314 | 210 | 1.291925 | 2.7130425 | Norway luteo-like virus 4 | 2034334 | Viruses | Viruses | 388 | 1.24e-103 | NTclustered | gi|1240393781|gb|MF141070.1| | 2034334 | g22079 | i0 | 100 | 3.00952380952381 | 210 | 0 | 100 | 0 | 1 | 210 | 3777 | 3568 | Norway luteo-like virus 4 isolate NOR/B1V/Tofte/2014 RNA-dependent RNA-polymerase and coat protein genes, complete cds | blastn | 632 | 388 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Norway luteo-like virus 4 | ||||
| 19771433 | 19771433 | PRJNA674308_P_NODE_10356_length_296_cov_2.842105_g10121_i0 | PRJNA674308 | 10356 | 296 | 2.842105 | 8.4126308 | Malassezia restricta virus MrV40S | 2727864 | Viruses | Viruses | 309 | 1.48e-79 | NTclustered | gi|1832308146|gb|MN603498.1| | 2727864 | g10121 | i0 | 96.277 | 0.635135135135135 | 188 | 7 | 64 | 0 | 1 | 188 | 916 | 1103 | Malassezia restricta virus MrV40S, complete genome | blastn | 188 | 309 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Malassezia restricta virus MrV40S | |||
| 21047235 | 21047235 | PRJNA674308_P_NODE_29277_length_186_cov_1.992701_g29042_i0 | PRJNA674308 | 29277 | 186 | 1.992701 | 3.70642386 | Tobamovirus mititessellati | 3432879 | Viruses | Viruses | 333 | 5.069999999999999e-87 | NTclustered | gi|443385357|gb|JX534224.2| | 12241 | g29042 | i0 | 98.925 | 48.1344086021505 | 186 | 2 | 100 | 0 | 1 | 186 | 3240 | 3425 | Tobacco mild green mosaic virus isolate Xiamen, complete genome | blastn | 8953 | 333 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus mititessellati | ||
| 22322032 | 22322032 | PRJNA674308_P_NODE_28898_length_187_cov_9840.318841_g28663_i0 | PRJNA674308 | 28898 | 187 | 9840.318841 | 18401.39623267 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 99 | 2.03e-16 | NTclustered | gi|2155033579|emb|OV039277.1| | 2697049 | g28663 | i0 | 100 | 16.7112299465241 | 53 | 0 | 55 | 0 | 1 | 53 | 30565 | 30513 | Severe acute respiratory syndrome coronavirus 2 isolate 165 genome assembly, chromosome: 165 | blastn | 3125 | 99 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 22322068 | 22322068 | PRJNA674308_P_NODE_34738_length_172_cov_1.000000_g34503_i0 | PRJNA674308 | 34738 | 172 | 1 | 1.72 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 259 | 7.92e-65 | NTclustered | gi|2874131729|dbj|LC612823.1| | 12242 | g34503 | i0 | 93.714 | 101.575581395349 | 175 | 8 | 100 | 2 | 1 | 172 | 5913 | 6087 | Tobacco mosaic virus Jiou genomic RNA, complete genome | blastn | 17471 | 259 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 22322117 | 22322117 | PRJNA674308_P_NODE_40578_length_167_cov_0.881356_g40343_i0 | PRJNA674308 | 40578 | 167 | 0.881356 | 1.47186452 | Hebei narnavirus 13 | 3371267 | Viruses | Viruses | 254 | 3.58e-63 | NTclustered | gi|2819074229|gb|PQ150570.1| | 3371267 | g40343 | i0 | 96.129 | 1.75449101796407 | 155 | 6 | 93 | 0 | 13 | 167 | 244 | 90 | MAG: Hebei narnavirus 13 isolate Hebei_112 genomic sequence | blastn | 293 | 254 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Hebei narnavirus 13 | ||
| 23597464 | 23597464 | PRJNA674308_P_NODE_18759_length_226_cov_1.175141_g18524_i0 | PRJNA674308 | 18759 | 226 | 1.175141 | 2.65581866 | Chemarfal virus 258 | 3063149 | Viruses | Viruses | 412 | 8.01e-111 | NTclustered | gi|2626079799|gb|OR270470.1| | 3063149 | g18524 | i0 | 99.558 | 4.01327433628319 | 226 | 1 | 100 | 0 | 1 | 226 | 1320 | 1545 | MAG: Chemarfal virus 258 isolate ML188 genomic sequence | blastn | 907 | 412 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Chemarfal virus 258 | ||||
| 23597527 | 23597527 | PRJNA674308_P_NODE_25479_length_198_cov_2.013423_g25244_i0 | PRJNA674308 | 25479 | 198 | 2.013423 | 3.98657754 | Chrocagost virus | 3129398 | Viruses | Viruses | 220 | 4.45e-53 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g25244 | i0 | 86.802 | 412.181818181818 | 197 | 26 | 99 | 0 | 2 | 198 | 5654 | 5850 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 81612 | 220 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 25393137 | 25393137 | PRJNA674308_P_NODE_44120_length_166_cov_0.888889_g43885_i0 | PRJNA674308 | 44120 | 166 | 0.888889 | 1.47555574 | Tobamovirus | 12234 | Viruses | Viruses | 307 | 2.69e-79 | NTclustered | gi|2837380181|gb|PP099897.1| | 1761477 | g43885 | i0 | 100 | 100 | 166 | 0 | 100 | 0 | 1 | 166 | 4061 | 3896 | Tomato brown rugose fruit virus isolate NPPO-NL 36648757, complete genome | blastn | 16600 | 307 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus fructirugosum |
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);;