contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA702290" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 683742 | 683742 | PRJNA702290_P_NODE_1281_length_190_cov_10.933775_g1273_i0 | PRJNA702290 | 1281 | 190 | 10.933775 | 20.7741725 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 135 | 1.5800000000000002e-27 | NTclustered | gi|2083529913|tpd|BR001721.1| | 104580 | g1273 | i0 | 98.684 | 0.778947368421053 | 76 | 1 | 78 | 0 | 3 | 78 | 338 | 413 | TPA_asm: Kadipiro virus rat/2019/410 RdRp gene for RNA-dependent RNA polymerase, partial cds | blastn | 148 | 135 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 683744 | 683744 | PRJNA702290_P_NODE_1421_length_168_cov_22.488372_g1413_i0 | PRJNA702290 | 1421 | 168 | 22.488372 | 37.78046496 | Poinsettia mosaic virus | 113553 | Viruses | Viruses | 270 | 3.5799999999999998e-68 | NTclustered | gi|2891455944|gb|PQ661191.1| | 113553 | g1413 | i0 | 95.808 | 14.8988095238095 | 167 | 7 | 99 | 0 | 1 | 167 | 1061 | 1227 | Poinsettia mosaic virus isolate 24-11, complete genome | blastn | 2503 | 270 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Poinsettia mosaic virus | |||
| 683764 | 683764 | PRJNA702290_P_NODE_881_length_191_cov_11.118421_g873_i0 | PRJNA702290 | 881 | 191 | 11.118421 | 21.23618411 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 137 | 4.41e-28 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g873 | i0 | 100 | 1.0261780104712 | 74 | 0 | 78 | 0 | 112 | 185 | 5615 | 5542 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 196 | 137 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 1959779 | 1959779 | PRJNA702290_P_NODE_1062_length_191_cov_6.842105_g1054_i0 | PRJNA702290 | 1062 | 191 | 6.842105 | 13.06842055 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 139 | 1.23e-28 | NTclustered | gi|2083529927|tpd|BR001728.1| | 104580 | g1054 | i0 | 100 | 0.769633507853403 | 75 | 0 | 77 | 0 | 116 | 190 | 1296 | 1370 | TPA_asm: Kadipiro virus rat/2019/399 gene for putative VP8 protein, complete cds | blastn | 147 | 139 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 3234774 | 3234774 | PRJNA702290_P_NODE_563_length_191_cov_39.664474_g555_i0 | PRJNA702290 | 563 | 191 | 39.664474 | 75.75914534 | Poinsettia mosaic virus | 113553 | Viruses | Viruses | 145 | 2.63e-30 | NTclustered | gi|302698755|dbj|AB550792.1| | 113553 | g555 | i0 | 97.619 | 12.5340314136126 | 84 | 2 | 84 | 0 | 3 | 86 | 3273 | 3356 | Poinsettia mosaic virus genomic RNA, complete genome, isolate: JO5 | blastn | 2394 | 145 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Poinsettia mosaic virus | |||
| 4511838 | 4511838 | PRJNA702290_P_NODE_1544_length_159_cov_15.266667_g1536_i0 | PRJNA702290 | 1544 | 159 | 15.266667 | 24.27400053 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 139 | 9.82e-29 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g1536 | i0 | 97.531 | 0.509433962264151 | 81 | 2 | 51 | 0 | 79 | 159 | 7891 | 7971 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 81 | 139 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 5787297 | 5787297 | PRJNA702290_P_NODE_445_length_212_cov_41.537572_g437_i0 | PRJNA702290 | 445 | 212 | 41.537572 | 88.05965264 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 359 | 9.81e-95 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g437 | i0 | 97.608 | 1.92924528301887 | 209 | 5 | 99 | 0 | 1 | 209 | 476 | 268 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 409 | 359 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 7062365 | 7062365 | PRJNA702290_P_NODE_1806_length_157_cov_6.398305_g1798_i0 | PRJNA702290 | 1806 | 157 | 6.398305 | 10.04533885 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 135 | 1.25e-27 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g1798 | i0 | 97.468 | 0.993630573248408 | 79 | 2 | 97 | 0 | 78 | 156 | 8170 | 8248 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 156 | 135 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 9612257 | 9612257 | PRJNA702290_P_NODE_1488_length_160_cov_22.041322_g1480_i0 | PRJNA702290 | 1488 | 160 | 22.041322 | 35.2661152 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 200 | 4.48e-47 | NTclustered | gi|2058130956|tpg|BK034114.1| | 2832643 | g1480 | i0 | 90.184 | 1.01875 | 163 | 2 | 93 | 1 | 5 | 153 | 26575 | 26737 | MAG TPA_asm: Caudoviricetes sp. isolate ctp3l1, partial genome | blastn | 163 | 200 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10887843 | 10887843 | PRJNA702290_P_NODE_1109_length_191_cov_5.348684_g1101_i0 | PRJNA702290 | 1109 | 191 | 5.348684 | 10.21598644 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 141 | 3.41e-29 | NTclustered | gi|2057844767|tpg|BK055780.1| | 2832643 | g1101 | i0 | 100 | 0.785340314136126 | 76 | 0 | 79 | 0 | 5 | 80 | 35816 | 35741 | MAG TPA_asm: Caudoviricetes sp. isolate ctvEa3, partial genome | blastn | 150 | 141 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 10887849 | 10887849 | PRJNA702290_P_NODE_1429_length_167_cov_31.937500_g1421_i0 | PRJNA702290 | 1429 | 167 | 31.9375 | 53.335625 | Poinsettia mosaic virus | 113553 | Viruses | Viruses | 250 | 4.63e-62 | NTclustered | gi|190609632|emb|AM412237.1| | 113553 | g1421 | i0 | 96.104 | 13.8383233532934 | 154 | 5 | 92 | 1 | 9 | 161 | 2364 | 2517 | Poinsettia mosaic virus gene for polyprotein, isolate Norwegian 1, genomic RNA | blastn | 2311 | 250 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Poinsettia mosaic virus | |||
| 10887869 | 10887869 | PRJNA702290_P_NODE_629_length_191_cov_19.171053_g621_i0 | PRJNA702290 | 629 | 191 | 19.171053 | 36.61671123 | Hubei tombus-like virus 8 | 1923295 | Viruses | Viruses | 126 | 9.54e-25 | NTclustered | gi|1132370709|ref|NC_032884.1| | 1923295 | g621 | i0 | 96.104 | 1.6020942408377 | 77 | 3 | 80 | 0 | 4 | 80 | 3035 | 2959 | Hubei tombus-like virus 8 strain WHCC116238 hypothetical protein 1, hypothetical protein 2, and hypothetical protein 3 genes, complete cds | blastn | 306 | 126 | 1 | Viruses | Hubei tombus-like virus 8 | ||||||||
| 12162976 | 12162976 | PRJNA702290_P_NODE_110_length_404_cov_27.347945_g103_i0 | PRJNA702290 | 110 | 404 | 27.347945 | 110.4856978 | Riboviria sp. | 2585031 | Viruses | Viruses | 267 | 1.27e-66 | NTclustered | gi|1822041645|gb|MT085275.1| | 2585031 | g103 | i0 | 99.32 | 0.363861386138614 | 147 | 1 | 36 | 0 | 1 | 147 | 147 | 1 | Riboviria sp. isolate RtMce-NcV/Tp2006, partial genome | blastn | 147 | 267 | 1 | Viruses | Riboviria sp. | ||||||||
| 13437506 | 13437506 | PRJNA702290_P_NODE_1751_length_157_cov_22.669492_g1743_i0 | PRJNA702290 | 1751 | 157 | 22.669492 | 35.59110244 | Crocidura lasiura ribovirus 8 | 3139504 | Viruses | Viruses | 135 | 1.25e-27 | NTclustered | gi|2717469869|gb|PP272574.1| | 3139504 | g1743 | i0 | 100 | 1.88535031847134 | 73 | 0 | 93 | 0 | 80 | 152 | 581 | 653 | MAG: Crocidura lasiura ribovirus 8 isolate ribo_20 hypothetical protein gene, complete cds | blastn | 296 | 135 | 1 | Viruses | Crocidura lasiura ribovirus 8 | ||||||||
| 14712755 | 14712755 | PRJNA702290_P_NODE_1392_length_172_cov_18.135338_g1384_i0 | PRJNA702290 | 1392 | 172 | 18.135338 | 31.19278136 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 303 | 3.61e-78 | NTclustered | gi|2754692226|gb|PP872826.1| | 3003959 | g1384 | i0 | 100 | 0.953488372093023 | 164 | 0 | 95 | 0 | 7 | 170 | 5887 | 6050 | MAG: Picornavirales sp. isolate TC-PLV-270 MR233-17E/1459 genomic sequence | blastn | 164 | 303 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 15986374 | 15986374 | PRJNA702290_P_NODE_193_length_332_cov_18.255973_g186_i0 | PRJNA702290 | 193 | 332 | 18.255973 | 60.60983036 | Tolivirales sp. | 2809914 | Viruses | Viruses | 453 | 7.34e-123 | NTclustered | gi|2647549457|gb|OR843652.1| | 2809914 | g186 | i0 | 90.56 | 1.54518072289157 | 339 | 17 | 98 | 3 | 3 | 326 | 1659 | 1321 | Tolivirales sp. strain MR233-17E/2125 polyprotein, tombus P33-like protein, and structural protein genes, complete cds | blastn | 513 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tolivirales sp. | ||||
| 17261697 | 17261697 | PRJNA702290_P_NODE_1114_length_191_cov_5.157895_g1106_i0 | PRJNA702290 | 1114 | 191 | 5.157895 | 9.85157945 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 89.8 | 1.25e-13 | NTclustered | gi|2754691654|gb|PP872616.1| | 3003959 | g1106 | i0 | 94.737 | 0.596858638743455 | 57 | 3 | 30 | 0 | 11 | 67 | 6420 | 6364 | MAG: Picornavirales sp. isolate TC-PLV-60 MR233-17E/328 genomic sequence | blastn | 114 | 89.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 17261719 | 17261719 | PRJNA702290_P_NODE_334_length_249_cov_29.795238_g326_i0 | PRJNA702290 | 334 | 249 | 29.795238 | 74.19014262 | Riboviria sp. | 2585031 | Viruses | Viruses | 255 | 1.6e-63 | NTclustered | gi|1822041645|gb|MT085275.1| | 2585031 | g326 | i0 | 100 | 0.847389558232932 | 138 | 0 | 85 | 0 | 1 | 138 | 351 | 214 | Riboviria sp. isolate RtMce-NcV/Tp2006, partial genome | blastn | 211 | 255 | 1 | Viruses | Riboviria sp. | ||||||||
| 18535581 | 18535581 | PRJNA702290_P_NODE_915_length_191_cov_10.263158_g907_i0 | PRJNA702290 | 915 | 191 | 10.263158 | 19.60263178 | Qianjiang tombus-like virus 183 | 3347850 | Viruses | Viruses | 95.3 | 2.69e-15 | NTclustered | gi|2806501255|gb|PQ054305.1| | 3347850 | g907 | i0 | 90.278 | 0.37696335078534 | 72 | 7 | 38 | 0 | 8 | 79 | 522 | 593 | MAG: Qianjiang tombus-like virus 183 isolate QJ3DG70 genomic sequence | blastn | 72 | 95.3 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Qianjiang tombus-like virus 183 | |||
| 19810682 | 19810682 | PRJNA702290_P_NODE_1896_length_155_cov_31.793103_g1888_i0 | PRJNA702290 | 1896 | 155 | 31.793103 | 49.27930965 | Poinsettia mosaic virus | 113553 | Viruses | Viruses | 263 | 5.41e-66 | NTclustered | gi|302698755|dbj|AB550792.1| | 113553 | g1888 | i0 | 99.31 | 16.8129032258065 | 145 | 1 | 94 | 0 | 4 | 148 | 5859 | 5715 | Poinsettia mosaic virus genomic RNA, complete genome, isolate: JO5 | blastn | 2606 | 263 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Poinsettia mosaic virus | |||
| 19810689 | 19810689 | PRJNA702290_P_NODE_376_length_233_cov_13.175258_g368_i0 | PRJNA702290 | 376 | 233 | 13.175258 | 30.69835114 | Chihuahua culicoides tombusvirus 1 | 3239316 | Viruses | Viruses | 270 | 5.2899999999999986e-68 | NTclustered | gi|2781977543|gb|PP101795.1| | 3239316 | g368 | i0 | 99.329 | 1.1931330472103 | 149 | 1 | 64 | 0 | 79 | 227 | 322 | 174 | Chihuahua culicoides tombusvirus 1 capsid protein gene, partial cds | blastn | 278 | 270 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Chihuahua culicoides tombusvirus 1 | ||
| 22360944 | 22360944 | PRJNA702290_P_NODE_1358_length_179_cov_45.150000_g1350_i0 | PRJNA702290 | 1358 | 179 | 45.15 | 80.8185 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 315 | 1.75e-81 | NTclustered | gi|2083529913|tpd|BR001721.1| | 104580 | g1350 | i0 | 99.422 | 0.966480446927374 | 173 | 1 | 97 | 0 | 3 | 175 | 2405 | 2233 | TPA_asm: Kadipiro virus rat/2019/410 RdRp gene for RNA-dependent RNA polymerase, partial cds | blastn | 173 | 315 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 22360966 | 22360966 | PRJNA702290_P_NODE_318_length_258_cov_34.831050_g310_i0 | PRJNA702290 | 318 | 258 | 34.83105 | 89.864109 | Poinsettia mosaic virus | 113553 | Viruses | Viruses | 442 | 1.1899999999999995e-119 | NTclustered | gi|302698755|dbj|AB550792.1| | 113553 | g310 | i0 | 98.406 | 19.015503875969 | 251 | 4 | 97 | 0 | 7 | 257 | 165 | 415 | Poinsettia mosaic virus genomic RNA, complete genome, isolate: JO5 | blastn | 4906 | 442 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Poinsettia mosaic virus | |||
| 22360980 | 22360980 | PRJNA702290_P_NODE_918_length_191_cov_10.190789_g910_i0 | PRJNA702290 | 918 | 191 | 10.190789 | 19.46440699 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 143 | 9.479999999999999e-30 | NTclustered | gi|2083529913|tpd|BR001721.1| | 104580 | g910 | i0 | 98.75 | 1.8848167539267 | 80 | 1 | 80 | 0 | 112 | 191 | 827 | 748 | TPA_asm: Kadipiro virus rat/2019/410 RdRp gene for RNA-dependent RNA polymerase, partial cds | blastn | 360 | 143 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 24136398 | 24136398 | PRJNA702290_P_NODE_819_length_191_cov_12.322368_g811_i0 | PRJNA702290 | 819 | 191 | 12.322368 | 23.53572288 | Arfiviricetes | 2732423 | Viruses | Viruses | 141 | 3.41e-29 | NTclustered | gi|2626080284|gb|OR270688.1| | 1954248 | g811 | i0 | 100 | 4.9738219895288 | 76 | 0 | 78 | 0 | 5 | 80 | 2058 | 1983 | MAG: Circoviridae sp. isolate GL83, complete genome | blastn | 950 | 141 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Rohanvirales | Nenyaviridae | Galvornvirus | Galvornvirus isengard |
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);;