contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145097 | 145097 | PRJNA1000943_P_NODE_10161_length_263_cov_1.247368_g10023_i0 | PRJNA1000943 | 10161 | 263 | 1.247368 | 3.28057784 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 470 | 5.59e-128 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g10023 | i0 | 98.859 | 23.5703422053232 | 263 | 3 | 100 | 0 | 1 | 263 | 351 | 89 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 6199 | 470 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 1419858 | 1419858 | PRJNA1000943_P_NODE_2842_length_456_cov_1.838120_g2705_i0 | PRJNA1000943 | 2842 | 456 | 1.83812 | 8.3818272 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 760 | 0 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g2705 | i0 | 96.711 | 33.4276315789474 | 456 | 15 | 100 | 0 | 1 | 456 | 1606 | 1151 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 15243 | 760 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 2695287 | 2695287 | PRJNA1000943_P_NODE_11703_length_251_cov_1.398876_g11565_i0 | PRJNA1000943 | 11703 | 251 | 1.398876 | 3.51117876 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 453 | 5.34e-123 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g11565 | i0 | 99.203 | 31.4382470119522 | 251 | 2 | 100 | 0 | 1 | 251 | 3326 | 3576 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 7891 | 453 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 3971375 | 3971375 | PRJNA1000943_P_NODE_1184_length_691_cov_2.631068_g1054_i0 | PRJNA1000943 | 1184 | 691 | 2.631068 | 18.18067988 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1243 | 0 | NTclustered | gi|2671680470|gb|OR496452.1| | 294365 | g1054 | i0 | 99.273 | 91.7149059334298 | 688 | 5 | 99 | 0 | 4 | 691 | 7056 | 6369 | MAG: Israeli acute paralysis virus isolate Andong genomic sequence | blastn | 63375 | 1243 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 3971436 | 3971436 | PRJNA1000943_P_NODE_2204_length_513_cov_2.772727_g2067_i0 | PRJNA1000943 | 2204 | 513 | 2.772727 | 14.22408951 | Aparavirus israelense | 3048155 | Viruses | Viruses | 887 | 0 | NTclustered | gi|2671680486|gb|OR496456.1| | 294365 | g2067 | i0 | 97.856 | 54 | 513 | 11 | 100 | 0 | 1 | 513 | 4150 | 3638 | MAG: Israeli acute paralysis virus isolate Gyeongju genomic sequence | blastn | 27702 | 887 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 7797595 | 7797595 | PRJNA1000943_P_NODE_1267_length_670_cov_3.311558_g1136_i0 | PRJNA1000943 | 1267 | 670 | 3.311558 | 22.1874386 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1175 | 0 | NTclustered | gi|2671680494|gb|OR496458.1| | 294365 | g1136 | i0 | 98.358 | 90.5716417910448 | 670 | 10 | 99 | 1 | 2 | 670 | 887 | 218 | MAG: Israeli acute paralysis virus isolate Uiseong genomic sequence | blastn | 60683 | 1175 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 7797644 | 7797644 | PRJNA1000943_P_NODE_2147_length_518_cov_4.256180_g2010_i0 | PRJNA1000943 | 2147 | 518 | 4.25618 | 22.0470124 | Aparavirus israelense | 3048155 | Viruses | Viruses | 891 | 0 | NTclustered | gi|2671680486|gb|OR496456.1| | 294365 | g2010 | i0 | 97.683 | 53.9382239382239 | 518 | 12 | 100 | 0 | 1 | 518 | 3114 | 3631 | MAG: Israeli acute paralysis virus isolate Gyeongju genomic sequence | blastn | 27940 | 891 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 10348226 | 10348226 | PRJNA1000943_P_NODE_13849_length_246_cov_0.901734_g13711_i0 | PRJNA1000943 | 13849 | 246 | 0.901734 | 2.21826564 | Sopapen virus | 3131614 | Viruses | Viruses | 139 | 1.66e-28 | NTclustered | gi|2717322942|gb|PP173915.1| | 3131614 | g13711 | i0 | 93.548 | 9.98373983739837 | 93 | 6 | 38 | 0 | 22 | 114 | 527 | 435 | MAG: Sopapen virus isolate SP1A_k141_131186 genomic sequence | blastn | 2456 | 139 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Sopapen virus | |||||
| 10348275 | 10348275 | PRJNA1000943_P_NODE_2809_length_458_cov_2.129870_g2672_i0 | PRJNA1000943 | 2809 | 458 | 2.12987 | 9.7548046 | Aparavirus israelense | 3048155 | Viruses | Viruses | 813 | 0 | NTclustered | gi|2127009797|gb|MZ821845.1| | 294365 | g2672 | i0 | 98.69 | 79.9606986899563 | 458 | 6 | 100 | 0 | 1 | 458 | 2949 | 2492 | MAG: Israeli acute paralysis virus isolate IAPV_No6_Mi020-JL2018-10 replicase polyprotein and capsid protein genes, complete cds | blastn | 36622 | 813 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 10348305 | 10348305 | PRJNA1000943_P_NODE_5469_length_342_cov_2.029740_g5331_i0 | PRJNA1000943 | 5469 | 342 | 2.02974 | 6.9417108 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 577 | 4.31e-160 | NTclustered | gi|2737472559|dbj|LC818006.1| | 1080798 | g5331 | i0 | 97.076 | 18.4736842105263 | 342 | 10 | 100 | 0 | 1 | 342 | 2538 | 2197 | Soybean yellow common mosaic virus SYCMV_NA_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete cds | blastn | 6318 | 577 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 14173684 | 14173684 | PRJNA1000943_P_NODE_1012_length_741_cov_2.320359_g886_i0 | PRJNA1000943 | 1012 | 741 | 2.320359 | 17.19386019 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1308 | 0 | NTclustered | gi|2514754451|gb|OP972882.1| | 294365 | g886 | i0 | 98.516 | 71.195681511471 | 741 | 11 | 100 | 0 | 1 | 741 | 8156 | 7416 | MAG: Israeli acute paralysis virus isolate Hwasun_B, complete genome | blastn | 52756 | 1308 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173755 | 14173755 | PRJNA1000943_P_NODE_1932_length_546_cov_2.391121_g1796_i0 | PRJNA1000943 | 1932 | 546 | 2.391121 | 13.055520660000001 | Aparavirus israelense | 3048155 | Viruses | Viruses | 992 | 0 | NTclustered | gi|2127009794|gb|MZ821844.1| | 294365 | g1796 | i0 | 99.451 | 53.5586080586081 | 546 | 3 | 100 | 0 | 1 | 546 | 1028 | 1573 | MAG: Israeli acute paralysis virus isolate IAPV_No5_Mi002-AH2018 replicase polyprotein and capsid protein genes, complete cds | blastn | 29243 | 992 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173759 | 14173759 | PRJNA1000943_P_NODE_2492_length_484_cov_2.440389_g2355_i0 | PRJNA1000943 | 2492 | 484 | 2.440389 | 11.81148276 | Aparavirus israelense | 3048155 | Viruses | Viruses | 872 | 0 | NTclustered | gi|2514754445|gb|OP972880.1| | 294365 | g2355 | i0 | 99.174 | 65.1074380165289 | 484 | 4 | 100 | 0 | 1 | 484 | 8923 | 8440 | MAG: Israeli acute paralysis virus isolate Geochang_A genomic sequence | blastn | 31512 | 872 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 14173775 | 14173775 | PRJNA1000943_P_NODE_412_length_1076_cov_2.985045_g339_i0 | PRJNA1000943 | 412 | 1076 | 2.985045 | 32.1190842 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1905 | 0 | NTclustered | gi|2671680470|gb|OR496452.1| | 294365 | g339 | i0 | 98.695 | 71.8996282527881 | 1073 | 14 | 99 | 0 | 4 | 1076 | 5523 | 4451 | MAG: Israeli acute paralysis virus isolate Andong genomic sequence | blastn | 77364 | 1905 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 15447909 | 15447909 | PRJNA1000943_P_NODE_7613_length_298_cov_1.733333_g7475_i0 | PRJNA1000943 | 7613 | 298 | 1.733333 | 5.16533234 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 507 | 4.92e-139 | NTclustered | gi|2737472559|dbj|LC818006.1| | 1080798 | g7475 | i0 | 97.315 | 15.8489932885906 | 298 | 8 | 100 | 0 | 1 | 298 | 800 | 1097 | Soybean yellow common mosaic virus SYCMV_NA_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete cds | blastn | 4723 | 507 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 16721998 | 16721998 | PRJNA1000943_P_NODE_1594_length_601_cov_1.791667_g1459_i0 | PRJNA1000943 | 1594 | 601 | 1.791667 | 10.76791867 | Aparavirus israelense | 3048155 | Viruses | Viruses | 1038 | 0 | NTclustered | gi|491846189|gb|KC690270.1| | 294365 | g1459 | i0 | 97.841 | 66.2745424292845 | 602 | 12 | 100 | 1 | 1 | 601 | 1713 | 2314 | Israeli acute paralysis virus strain Korea3, complete genome | blastn | 39831 | 1038 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 16722091 | 16722091 | PRJNA1000943_P_NODE_9574_length_269_cov_2.556122_g9436_i0 | PRJNA1000943 | 9574 | 269 | 2.556122 | 6.87596818 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 492 | 1.23e-134 | NTclustered | gi|2056529904|gb|MT997092.1| | 1080798 | g9436 | i0 | 99.628 | 43.2862453531598 | 269 | 1 | 100 | 0 | 1 | 269 | 1889 | 1621 | Soybean yellow common mosaic virus isolate CHN-JZ-02, partial genome | blastn | 11644 | 492 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 17996882 | 17996882 | PRJNA1000943_P_NODE_635_length_902_cov_12.401689_g534_i0 | PRJNA1000943 | 635 | 902 | 12.401689 | 111.86323478 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 1666 | 0 | NTclustered | gi|1836048744|gb|MT415897.1| | 2697049 | g534 | i0 | 100 | 100 | 902 | 0 | 100 | 0 | 1 | 902 | 29176 | 28275 | Severe acute respiratory syndrome coronavirus 2 isolate SARS-CoV-2/human/USA/VA-DCLS-0072/2020, complete genome | blastn | 90200 | 1666 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 20546346 | 20546346 | PRJNA1000943_P_NODE_7537_length_299_cov_2.190265_g7399_i0 | PRJNA1000943 | 7537 | 299 | 2.190265 | 6.54889235 | Aparavirus israelense | 3048155 | Viruses | Viruses | 516 | 8.2e-142 | NTclustered | gi|2574590679|gb|OR416402.1| | 294365 | g7399 | i0 | 97.674 | 65.5852842809364 | 301 | 5 | 100 | 1 | 1 | 299 | 5259 | 5559 | MAG: Israeli acute paralysis virus isolate IAPV-Vcra nonstructural polyprotein gene, complete cds | blastn | 19610 | 516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Aparavirus | Aparavirus israelense | ||
| 23097335 | 23097335 | PRJNA1000943_P_NODE_5339_length_346_cov_2.274725_g5201_i0 | PRJNA1000943 | 5339 | 346 | 2.274725 | 7.8705485 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 614 | 3.329999999999999e-171 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g5201 | i0 | 98.837 | 22.150289017341 | 344 | 4 | 99 | 0 | 3 | 346 | 671 | 328 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 7664 | 614 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV | ||
| 23097350 | 23097350 | PRJNA1000943_P_NODE_6219_length_324_cov_2.486056_g6081_i0 | PRJNA1000943 | 6219 | 324 | 2.486056 | 8.05482144 | Sobemovirus SYCMV | 3432513 | Viruses | Viruses | 571 | 1.8899999999999993e-158 | NTclustered | gi|2737472539|dbj|LC818002.1| | 1080798 | g6081 | i0 | 98.457 | 20.7654320987654 | 324 | 5 | 100 | 0 | 1 | 324 | 2856 | 3179 | Soybean yellow common mosaic virus SYCMV_SE_CNU1 SYCMV_gp1, SYCMV_gp3, SYCMV_gp2, SYCMV_gp4 genes for putative movement protein, polyprotein P2ab, polyprotein P2a, capsid protein, complete and partial cds | blastn | 6728 | 571 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus SYCMV |
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);;