contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1240805" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 349282 | 349282 | PRJNA1240805_P_NODE_1801_length_361_cov_5.589744_g1752_i0 | PRJNA1240805 | 1801 | 361 | 5.589744 | 20.17897584 | Dolerus tritici iflavirus 1 | 3350209 | Viruses | Viruses | 54.7 | 0.01 | NTclustered | gi|2833733277|gb|PQ323359.2| | 3350209 | g1752 | i0 | 100 | 0.0803324099722992 | 29 | 0 | 8 | 0 | 1 | 29 | 58 | 86 | Dolerus tritici iflavirus 1 isolate HN-WS polyprotein gene, complete cds | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Dolerus tritici iflavirus 1 | ||
| 349313 | 349313 | PRJNA1240805_P_NODE_4121_length_226_cov_14.994350_g4072_i0 | PRJNA1240805 | 4121 | 226 | 14.99435 | 33.887231 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g4072 | i0 | 100 | 0.256637168141593 | 30 | 0 | 13 | 0 | 1 | 30 | 6 | 35 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 349334 | 349334 | PRJNA1240805_P_NODE_5561_length_193_cov_6.111111_g5512_i0 | PRJNA1240805 | 5561 | 193 | 6.111111 | 11.79444423 | Porcine bastrovirus | 2588662 | Viruses | Viruses | 54.7 | 0.005 | NTclustered | gi|1682068313|gb|MK387176.1| | 2588662 | g5512 | i0 | 100 | 0.150259067357513 | 29 | 0 | 15 | 0 | 165 | 193 | 44 | 16 | Porcine bastrovirus isolate PBastV_USA 2017-1, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Porcine bastrovirus | |||
| 4176569 | 4176569 | PRJNA1240805_P_NODE_1844_length_357_cov_13.775974_g1795_i0 | PRJNA1240805 | 1844 | 357 | 13.775974 | 49.18022718 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 52.8 | 0.034 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g1795 | i0 | 100 | 0.0784313725490196 | 28 | 0 | 8 | 0 | 1 | 28 | 15 | 42 | Carnation latent virus isolate KL, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 8002773 | 8002773 | PRJNA1240805_P_NODE_5907_length_188_cov_3.618705_g5858_i0 | PRJNA1240805 | 5907 | 188 | 3.618705 | 6.8031654 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 248 | 1.91e-61 | NTclustered | gi|2053118490|tpg|BK020869.1| | 2832643 | g5858 | i0 | 91.667 | 0.957446808510638 | 180 | 14 | 96 | 1 | 9 | 188 | 2229 | 2407 | MAG TPA_asm: Caudoviricetes sp. isolate ctW5v3, partial genome | blastn | 180 | 248 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9277672 | 9277672 | PRJNA1240805_P_NODE_2568_length_296_cov_2.060729_g2519_i0 | PRJNA1240805 | 2568 | 296 | 2.060729 | 6.09975784 | Pestivirus bovis | 3052619 | Viruses | Viruses | 508 | 1.36e-139 | NTclustered | gi|1129880483|gb|KX170609.1| | 11099 | g2519 | i0 | 97.635 | 98.7364864864865 | 296 | 7 | 100 | 0 | 1 | 296 | 616 | 321 | Bovine viral diarrhea virus 1 isolate V087 NS5A gene, partial cds | blastn | 29226 | 508 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 11828096 | 11828096 | PRJNA1240805_P_NODE_3390_length_252_cov_4.507389_g3341_i0 | PRJNA1240805 | 3390 | 252 | 4.507389 | 11.35862028 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 425 | 1.17e-114 | NTclustered | gi|2083529913|tpd|BR001721.1| | 104580 | g3341 | i0 | 100 | 1.82539682539683 | 230 | 0 | 91 | 0 | 23 | 252 | 921 | 692 | TPA_asm: Kadipiro virus rat/2019/410 RdRp gene for RNA-dependent RNA polymerase, partial cds | blastn | 460 | 425 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 13103292 | 13103292 | PRJNA1240805_P_NODE_5791_length_190_cov_2.595745_g5742_i0 | PRJNA1240805 | 5791 | 190 | 2.595745 | 4.9319155 | Sopawol virus | 3131668 | Viruses | Viruses | 167 | 5.589999999999999e-37 | NTclustered | gi|2717323098|gb|PP173969.1| | 3131668 | g5742 | i0 | 84.615 | 1.14210526315789 | 169 | 25 | 89 | 1 | 3 | 171 | 336 | 169 | MAG: Sopawol virus isolate SP1B_k141_158324 genomic sequence | blastn | 217 | 167 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Sopawol virus | |||||
| 13103295 | 13103295 | PRJNA1240805_P_NODE_5971_length_187_cov_4.268116_g5922_i0 | PRJNA1240805 | 5971 | 187 | 4.268116 | 7.98137692 | Blacklegged tick picorna-like virus 2 | 2080259 | Viruses | Viruses | 283 | 5.209999999999999e-72 | NTclustered | gi|1338075553|gb|MG647772.1| | 2080259 | g5922 | i0 | 97.59 | 7.61497326203209 | 166 | 3 | 88 | 1 | 1 | 165 | 368 | 203 | Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds | blastn | 1424 | 283 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Blacklegged tick picorna-like virus 2 | ||||
| 18201172 | 18201172 | PRJNA1240805_P_NODE_3855_length_235_cov_8.059140_g3806_i0 | PRJNA1240805 | 3855 | 235 | 8.05914 | 18.938979 | Jujube closterovirus 1 | 3043313 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2496749738|gb|OP673405.1| | 3043313 | g3806 | i0 | 100 | 0.123404255319149 | 29 | 0 | 12 | 0 | 207 | 235 | 36 | 8 | Jujube closterovirus 1 isolate AKS15-20, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Closteroviridae | Jujube closterovirus 1 | |||
| 18201181 | 18201181 | PRJNA1240805_P_NODE_4715_length_210_cov_13.832298_g4666_i0 | PRJNA1240805 | 4715 | 210 | 13.832298 | 29.0478258 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 331 | 2.11e-86 | NTclustered | gi|2754692002|gb|PP872741.1| | 3003959 | g4666 | i0 | 98.404 | 0.895238095238095 | 188 | 3 | 90 | 0 | 17 | 204 | 8443 | 8630 | MAG: Picornavirales sp. isolate TC-PLV-185 MR233-17E/652 genomic sequence | blastn | 188 | 331 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 19475513 | 19475513 | PRJNA1240805_P_NODE_6816_length_175_cov_12.674603_g6767_i0 | PRJNA1240805 | 6816 | 175 | 12.674603 | 22.18055525 | Marnaviridae sp. | 2715102 | Viruses | Viruses | 65.8 | 1.89e-6 | NTclustered | gi|2196309042|gb|MZ679248.1| | 2715102 | g6767 | i0 | 78.182 | 0.628571428571429 | 110 | 18 | 61 | 5 | 38 | 144 | 1216 | 1110 | MAG: Marnaviridae sp. isolate R65-k141_733993 hypothetical protein gene, complete cds | blastn | 110 | 65.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Marnaviridae | Marnaviridae sp. | |||
| 20176686 | 20176686 | PRJNA1240805_P_NODE_3916_length_233_cov_15.913043_g3867_i0 | PRJNA1240805 | 3916 | 233 | 15.913043 | 37.07739019 | Tobamovirus | 12234 | Viruses | Viruses | 388 | 1.4e-103 | NTclustered | gi|1496534726|gb|MH271428.1| | 12235 | g3867 | i0 | 100 | 40.3948497854077 | 210 | 0 | 90 | 0 | 24 | 233 | 834 | 1043 | Cucumber green mottle mosaic virus isolate CG023, complete genome | blastn | 9412 | 388 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 20750980 | 20750980 | PRJNA1240805_P_NODE_5437_length_196_cov_1.557823_g5388_i0 | PRJNA1240805 | 5437 | 196 | 1.557823 | 3.05333308 | Pestivirus bovis | 3052619 | Viruses | Viruses | 346 | 6.94e-91 | NTclustered | gi|575471150|gb|KF772785.1| | 11099 | g5388 | i0 | 98.469 | 99.780612244898 | 196 | 3 | 100 | 0 | 1 | 196 | 7710 | 7515 | Bovine viral diarrhea virus 1 isolate CC13B, complete genome | blastn | 19557 | 346 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis | ||
| 20751022 | 20751022 | PRJNA1240805_P_NODE_9137_length_152_cov_4.378641_g9088_i0 | PRJNA1240805 | 9137 | 152 | 4.378641 | 6.65553432 | Pijolavirus Pf17397FPD1 | 3431676 | Viruses | Viruses | 246 | 5.31e-61 | NTclustered | gi|2190146233|gb|OM131411.1| | 2914026 | g9088 | i0 | 96.026 | 0.993421052631579 | 151 | 6 | 99 | 0 | 1 | 151 | 9993 | 10143 | Pseudomonas phage Pf17397_F_PD1, complete genome | blastn | 151 | 246 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Pijolavirus | Pijolavirus Pf17397FPD1 | ||
| 22026218 | 22026218 | PRJNA1240805_P_NODE_5818_length_189_cov_6.978571_g5769_i0 | PRJNA1240805 | 5818 | 189 | 6.978571 | 13.18949919 | Sobemovirus sp. | 2809869 | Viruses | Viruses | 95.3 | 2.66e-15 | NTclustered | gi|2171145024|gb|MZ218240.1| | 2809869 | g5769 | i0 | 78.205 | 102.148148148148 | 156 | 28 | 81 | 6 | 9 | 162 | 5309 | 5158 | MAG: Sobemovirus sp. isolate 267-k141_60134 genomic sequence | blastn | 19306 | 95.3 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Sobelivirales | Solemoviridae | Sobemovirus | Sobemovirus sp. | ||
| 22026226 | 22026226 | PRJNA1240805_P_NODE_6358_length_181_cov_10.401515_g6309_i0 | PRJNA1240805 | 6358 | 181 | 10.401515 | 18.82674215 | Parvovirus macaca3116 | 3117124 | Viruses | Viruses | 52.8 | 0.015 | NTclustered | gi|2710391813|tpg|BK066549.1| | 3117124 | g6309 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 154 | 181 | 29 | 2 | MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence | blastn | 28 | 52.8 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Parvovirus macaca3116 | |||
| 22026235 | 22026235 | PRJNA1240805_P_NODE_7258_length_171_cov_2.213115_g7209_i0 | PRJNA1240805 | 7258 | 171 | 2.213115 | 3.78442665 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 316 | 4.6e-82 | NTclustered | gi|2083529923|tpd|BR001726.1| | 104580 | g7209 | i0 | 100 | 1 | 171 | 0 | 100 | 0 | 1 | 171 | 378 | 548 | TPA_asm: Kadipiro virus rat/2019/399 gene for VP6 protein, complete cds | blastn | 171 | 316 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 22727402 | 22727402 | PRJNA1240805_P_NODE_1498_length_401_cov_78.164773_g1449_i0 | PRJNA1240805 | 1498 | 401 | 78.164773 | 313.44073973 | Chatterjeevirus | 2732679 | Viruses | Viruses | 58.4 | 8.26e-4 | NTclustered | gi|281416165|ref|NC_013651.1| | 644563 | g1449 | i0 | 89.362 | 2.81296758104738 | 47 | 4 | 12 | 1 | 168 | 214 | 34671 | 34716 | Vibrio phage N4, complete genome | blastn | 1128 | 58.4 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Autographivirales | Autotranscriptaviridae | Chatterjeevirus | Chatterjeevirus N4 | ||
| 23301842 | 23301842 | PRJNA1240805_P_NODE_2819_length_281_cov_6.793103_g2770_i0 | PRJNA1240805 | 2819 | 281 | 6.793103 | 19.08861943 | Tuatara cloaca-associated tombusvirus-1 | 2970558 | Viruses | Viruses | 89.8 | 1.97e-13 | NTclustered | gi|2284660261|gb|OP080581.1| | 2970558 | g2770 | i0 | 85.556 | 3.2135231316726 | 90 | 8 | 31 | 4 | 49 | 134 | 3177 | 3265 | MAG: Tuatara cloaca-associated tombusvirus-1 isolate T65 RNA-dependent RNA polymerase and coat protein genes, complete cds | blastn | 903 | 89.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusvirus | Tuatara cloaca-associated tombusvirus-1 | ||
| 23301891 | 23301891 | PRJNA1240805_P_NODE_6439_length_180_cov_7.030534_g6390_i0 | PRJNA1240805 | 6439 | 180 | 7.030534 | 12.6549612 | Carlavirus latensdianthi | 3427766 | Viruses | Viruses | 54.7 | 0.004 | NTclustered | gi|1995060321|gb|MN450069.1| | 12164 | g6390 | i0 | 100 | 0.161111111111111 | 29 | 0 | 16 | 0 | 152 | 180 | 43 | 15 | Carnation latent virus isolate KL, complete genome | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensdianthi | ||
| 24575765 | 24575765 | PRJNA1240805_P_NODE_4460_length_216_cov_22.155689_g4411_i0 | PRJNA1240805 | 4460 | 216 | 22.155689 | 47.85628824 | Seadornavirus kadipiroense | 3241299 | Viruses | Viruses | 363 | 7.749999999999998e-96 | NTclustered | gi|2083529919|tpd|BR001724.1| | 104580 | g4411 | i0 | 99.497 | 2.72222222222222 | 199 | 1 | 92 | 0 | 1 | 199 | 1277 | 1079 | TPA_asm: Kadipiro virus rat/2019/395 gene for VP4 protein, complete cds | blastn | 588 | 363 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Seadornavirus | Seadornavirus kadipiroense | ||
| 24575783 | 24575783 | PRJNA1240805_P_NODE_5660_length_192_cov_1.818182_g5611_i0 | PRJNA1240805 | 5660 | 192 | 1.818182 | 3.49090944 | Pestivirus bovis | 3052619 | Viruses | Viruses | 294 | 2.49e-75 | NTclustered | gi|77799881|dbj|AB111964.2| | 233886 | g5611 | i0 | 94.271 | 96.8020833333333 | 192 | 11 | 100 | 0 | 1 | 192 | 1774 | 1965 | Bovine viral diarrhea virus 839cp gene for poryprotein, partai cds, strain: 839cp | blastn | 18586 | 294 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Flasuviricetes | Amarillovirales | Flaviviridae | Pestivirus | Pestivirus bovis |
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);;