contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675308 | 1675308 | PRJNA379145_P_NODE_18942_length_622_cov_2.073005_g17116_i0 | PRJNA379145 | 18942 | 622 | 2.073005 | 12.8940911 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 363 | 2.51e-95 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g17116 | i0 | 92.49 | 0.406752411575563 | 253 | 19 | 41 | 0 | 1 | 253 | 1694 | 1442 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 253 | 363 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 1675574 | 1675574 | PRJNA379145_P_NODE_39162_length_310_cov_2.837545_g37011_i0 | PRJNA379145 | 39162 | 310 | 2.837545 | 8.7963895 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 562 | 1.08e-155 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g37011 | i0 | 99.355 | 5 | 310 | 2 | 100 | 0 | 1 | 310 | 2135 | 2444 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 1550 | 562 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 1675885 | 1675885 | PRJNA379145_P_NODE_73622_length_151_cov_1.813559_g71467_i0 | PRJNA379145 | 73622 | 151 | 1.813559 | 2.73847409 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 268 | 1.12e-67 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g71467 | i0 | 98.675 | 3 | 151 | 2 | 100 | 0 | 1 | 151 | 1242 | 1392 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 453 | 268 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 2349358 | 2349358 | PRJNA379145_P_NODE_51162_length_227_cov_1.716495_g49008_i0 | PRJNA379145 | 51162 | 227 | 1.716495 | 3.89644365 | Potexvirus | 12176 | Viruses | Viruses | 418 | 1.7299999999999996e-112 | NTclustered | gi|1839430140|gb|MK860513.1| | 112229 | g49008 | i0 | 100 | 99.5594713656388 | 226 | 0 | 99 | 0 | 1 | 226 | 739 | 964 | Pepino mosaic virus isolate MU14_4.19a_Mo TGB1 protein, TGB2 protein, TGB3 protein, and CP protein genes, complete cds | blastn | 22600 | 418 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 2951321 | 2951321 | PRJNA379145_P_NODE_23343_length_526_cov_1.933063_g21360_i0 | PRJNA379145 | 23343 | 526 | 1.933063 | 10.16791138 | Martellivirales sp. | 2809552 | Viruses | Viruses | 54.7 | 0.014 | NTclustered | gi|2647548574|gb|OR843378.1| | 2809552 | g21360 | i0 | 100 | 0.0551330798479087 | 29 | 0 | 6 | 0 | 245 | 273 | 12322 | 12294 | Martellivirales sp. strain MR233-17E/76 polyprotein gene, partial cds | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Martellivirales sp. | ||||
| 2951642 | 2951642 | PRJNA379145_P_NODE_543_length_2859_cov_5.615711_g450_i0 | PRJNA379145 | 543 | 2859 | 5.615711 | 160.55317749 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 4732 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g450 | i0 | 96.537 | 3.0912906610703 | 2859 | 99 | 100 | 0 | 1 | 2859 | 5284 | 8142 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 8838 | 4732 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 6177009 | 6177009 | PRJNA379145_P_NODE_63625_length_177_cov_1.006944_g61471_i0 | PRJNA379145 | 63625 | 177 | 1.006944 | 1.78229088 | Potexvirus | 12176 | Viruses | Viruses | 311 | 2.23e-80 | NTclustered | gi|1805119874|gb|MN038406.1| | 112229 | g61471 | i0 | 98.305 | 93.9604519774011 | 177 | 3 | 100 | 0 | 1 | 177 | 2374 | 2198 | Pepino mosaic virus strain MZ3, complete genome | blastn | 16631 | 311 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 6778659 | 6778659 | PRJNA379145_P_NODE_44486_length_267_cov_8.884615_g42334_i0 | PRJNA379145 | 44486 | 267 | 8.884615 | 23.72192205 | Mitovirus sp. | 2587224 | Viruses | Viruses | 159 | 1.4e-34 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g42334 | i0 | 91.379 | 1.10861423220974 | 116 | 10 | 43 | 0 | 145 | 260 | 116 | 1 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 296 | 159 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 8054203 | 8054203 | PRJNA379145_P_NODE_48847_length_240_cov_1.797101_g46693_i0 | PRJNA379145 | 48847 | 240 | 1.797101 | 4.3130424 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 438 | 1.4199999999999995e-118 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g46693 | i0 | 99.583 | 4.825 | 240 | 1 | 100 | 0 | 1 | 240 | 343 | 104 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 1158 | 438 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 9329033 | 9329033 | PRJNA379145_P_NODE_47928_length_245_cov_8.594340_g45775_i0 | PRJNA379145 | 47928 | 245 | 8.59434 | 21.056133 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.15e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g45775 | i0 | 93.671 | 0.322448979591837 | 79 | 5 | 32 | 0 | 145 | 223 | 111 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 79 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 13154297 | 13154297 | PRJNA379145_P_NODE_14831_length_741_cov_2.179379_g13238_i0 | PRJNA379145 | 14831 | 741 | 2.179379 | 16.14919839 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 710 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13238 | i0 | 94.248 | 2.95816464237517 | 452 | 26 | 99 | 0 | 290 | 741 | 4803 | 5254 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2192 | 710 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13154683 | 13154683 | PRJNA379145_P_NODE_45811_length_259_cov_1.420354_g43658_i0 | PRJNA379145 | 45811 | 259 | 1.420354 | 3.67871686 | Potexvirus pepini | 3433856 | Viruses | Viruses | 468 | 1.98e-127 | NTclustered | gi|148283741|gb|EF408821.3| | 112229 | g43658 | i0 | 99.228 | 96.030888030888 | 259 | 2 | 100 | 0 | 1 | 259 | 19 | 277 | Pepino mosaic virus isolate PepMV-PK, complete genome | blastn | 24872 | 468 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus pepini | ||
| 14429713 | 14429713 | PRJNA379145_P_NODE_48572_length_241_cov_15.865385_g46418_i0 | PRJNA379145 | 48572 | 241 | 15.865385 | 38.23557785 | Mitovirus sp. | 2587224 | Viruses | Viruses | 119 | 2.11e-22 | NTclustered | gi|1698234317|gb|MN033515.1| | 2587224 | g46418 | i0 | 93.671 | 0.327800829875519 | 79 | 5 | 33 | 0 | 141 | 219 | 111 | 33 | MAG: Mitovirus sp. isolate H1_Rhizo_26_FD_scaffold_6751 sequence | blastn | 79 | 119 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 14429854 | 14429854 | PRJNA379145_P_NODE_64752_length_173_cov_1.928571_g62598_i0 | PRJNA379145 | 64752 | 173 | 1.928571 | 3.33642783 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 320 | 3.61e-83 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g62598 | i0 | 100 | 5 | 173 | 0 | 100 | 0 | 1 | 173 | 914 | 742 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 865 | 320 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 15703800 | 15703800 | PRJNA379145_P_NODE_62113_length_181_cov_3.763514_g59959_i0 | PRJNA379145 | 62113 | 181 | 3.763514 | 6.81196034 | Narnaviridae sp. | 2583949 | Viruses | Viruses | 329 | 6.340000000000001e-86 | NTclustered | gi|2053223585|tpg|BK018547.1| | 2583949 | g59959 | i0 | 99.448 | 4.97790055248619 | 181 | 1 | 100 | 0 | 1 | 181 | 1492 | 1312 | MAG TPA_asm: Narnaviridae sp. isolate ctd2J1, partial genome | blastn | 901 | 329 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnaviridae sp. | |||
| 15703846 | 15703846 | PRJNA379145_P_NODE_67953_length_165_cov_1.037879_g65799_i0 | PRJNA379145 | 67953 | 165 | 1.037879 | 1.71250035 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 294 | 2.08e-75 | NTclustered | gi|2813525801|dbj|LC846392.1| | 12242 | g65799 | i0 | 98.788 | 100.012121212121 | 165 | 2 | 100 | 0 | 1 | 165 | 3948 | 3784 | Tobacco mosaic virus TMV-Du-CNU1 genomic RNA, complete genome | blastn | 16502 | 294 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 18252485 | 18252485 | PRJNA379145_P_NODE_35_length_5346_cov_14.880858_g28_i0 | PRJNA379145 | 35 | 5346 | 14.880858 | 795.53066868 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2516 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g28 | i0 | 92.144 | 0.667040778151889 | 1782 | 136 | 67 | 4 | 3566 | 5345 | 5329 | 7108 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 3566 | 2516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 19526992 | 19526992 | PRJNA379145_P_NODE_67916_length_165_cov_1.136364_g65762_i0 | PRJNA379145 | 67916 | 165 | 1.136364 | 1.8750006 | Tobamovirus tabaci | 3432891 | Viruses | Viruses | 300 | 4.46e-77 | NTclustered | gi|388240225|emb|HE818435.1| | 12242 | g65762 | i0 | 99.394 | 99.9333333333333 | 165 | 1 | 100 | 0 | 1 | 165 | 4278 | 4442 | Tobacco mosaic virus isolate Ludian, complete genome | blastn | 16489 | 300 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus tabaci | ||
| 20801986 | 20801986 | PRJNA379145_P_NODE_12197_length_845_cov_2.288177_g10822_i0 | PRJNA379145 | 12197 | 845 | 2.288177 | 19.33509565 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1053 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g10822 | i0 | 96.546 | 0.753846153846154 | 637 | 21 | 75 | 1 | 37 | 673 | 4 | 639 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 637 | 1053 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 20802393 | 20802393 | PRJNA379145_P_NODE_47037_length_251_cov_1.866972_g44884_i0 | PRJNA379145 | 47037 | 251 | 1.866972 | 4.68609972 | Ripothoz virus | 3131336 | Viruses | Viruses | 130 | 1.02e-25 | NTclustered | gi|2717322249|gb|PP173638.1| | 3131336 | g44884 | i0 | 96.25 | 1.51792828685259 | 80 | 2 | 31 | 1 | 19 | 97 | 5631 | 5552 | MAG: Ripothoz virus isolate MP3_k141_314104 genomic sequence | blastn | 381 | 130 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Ripothoz virus | ||||
| 20802563 | 20802563 | PRJNA379145_P_NODE_67237_length_166_cov_2.052632_g65083_i0 | PRJNA379145 | 67237 | 166 | 2.052632 | 3.40736912 | Ripafren virus | 3130475 | Viruses | Viruses | 224 | 2.7799999999999995e-54 | NTclustered | gi|2717319844|gb|PP172777.1| | 3130475 | g65083 | i0 | 91.071 | 44.4939759036145 | 168 | 11 | 100 | 3 | 1 | 166 | 939 | 774 | MAG: Ripafren virus isolate KCAP1_k141_546482 genomic sequence | blastn | 7386 | 224 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Ripafren 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);;