contig_metadata
26 rows where bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2993451 | 2993451 | PRJNA454503_P_NODE_71443_length_206_cov_0.896552_g71114_i0 | PRJNA454503 | 71443 | 206 | 0.896552 | 1.84689712 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 381 | 2.0199999999999994e-101 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g71114 | i0 | 100 | 11 | 206 | 0 | 100 | 0 | 1 | 206 | 1262 | 1467 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2266 | 381 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 6820006 | 6820006 | PRJNA454503_P_NODE_33446_length_235_cov_1.344828_g33117_i0 | PRJNA454503 | 33446 | 235 | 1.344828 | 3.1603458 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 424 | 3.87e-114 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g33117 | i0 | 99.149 | 11 | 235 | 2 | 100 | 0 | 1 | 235 | 5534 | 5300 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2585 | 424 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 8095300 | 8095300 | PRJNA454503_P_NODE_23527_length_255_cov_1.005155_g23198_i0 | PRJNA454503 | 23527 | 255 | 1.005155 | 2.56314525 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 466 | 6.98e-127 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g23198 | i0 | 99.608 | 11 | 255 | 1 | 100 | 0 | 1 | 255 | 7179 | 6925 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2805 | 466 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 10022184 | 10022184 | PRJNA454503_P_NODE_82688_length_203_cov_0.915493_g82359_i0 | PRJNA454503 | 82688 | 203 | 0.915493 | 1.85845079 | Viruses | 10239 | Viruses | Viruses | 370 | 4.3e-98 | NTclustered | gi|1043460595|ref|NC_030480.1| | 1685502 | g82359 | i0 | 99.507 | 33 | 203 | 1 | 100 | 0 | 1 | 203 | 712 | 914 | Pseudogymnoascus destructans virus isolate PdV80251 RNA-dependent RNA polymerase gene, complete cds | blastn | 6699 | 370 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | Pseudogymnoascus destructans partitivirus-pa | |||
| 10646820 | 10646820 | PRJNA454503_P_NODE_85389_length_202_cov_0.921986_g85060_i0 | PRJNA454503 | 85389 | 202 | 0.921986 | 1.86241172 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 363 | 7.149999999999999e-96 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g85060 | i0 | 99.01 | 15 | 202 | 2 | 100 | 0 | 1 | 202 | 1830 | 2031 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 3030 | 363 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 11921143 | 11921143 | PRJNA454503_P_NODE_36690_length_231_cov_1.147059_g36361_i0 | PRJNA454503 | 36690 | 231 | 1.147059 | 2.64970629 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 422 | 1.37e-113 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g36361 | i0 | 99.567 | 11 | 231 | 1 | 100 | 0 | 1 | 231 | 3467 | 3697 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2541 | 422 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 17020153 | 17020153 | PRJNA454503_P_NODE_7254_length_418_cov_1.450980_g6925_i0 | PRJNA454503 | 7254 | 418 | 1.45098 | 6.0650964 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 773 | 0 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g6925 | i0 | 100 | 11 | 418 | 0 | 100 | 0 | 1 | 418 | 8284 | 7867 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 4598 | 773 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 22119072 | 22119072 | PRJNA454503_P_NODE_4958_length_520_cov_1.712418_g4633_i0 | PRJNA454503 | 4958 | 520 | 1.712418 | 8.9045736 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 139 | 2.19e-34 | NR | WAY16437.1 | 2809460 | g4633 | i0 | 43.5 | 0.980769230769231 | 170 | 95 | 97.5 | 1 | 508 | 2 | 1771 | 1940 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 510 | 139 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 26696184 | 26696184 | PRJNA454503_P_NODE_47361_length_218_cov_1.656051_g47032_i0 | PRJNA454503 | 47361 | 218 | 1.656051 | 3.61019118 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 118 | 7.680000000000001e-29 | NR | XCM67837.1 | 3003959 | g47032 | i0 | 79.2 | 0.990825688073395 | 72 | 15 | 99.1 | 0 | 1 | 216 | 90 | 161 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 216 | 118 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 26727525 | 26727525 | PRJNA454503_P_NODE_1461_length_987_cov_2.684665_g1221_i0 | PRJNA454503 | 1461 | 987 | 2.684665 | 26.49764355 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 113 | 1.37e-23 | NR | WAY16437.1 | 2809460 | g1221 | i0 | 50.4 | 0.367781155015198 | 121 | 59 | 36.5 | 1 | 980 | 621 | 1982 | 2102 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 363 | 113 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27044553 | 27044553 | PRJNA454503_P_NODE_2_length_9601_cov_20.024738_g1_i0 | PRJNA454503 | 2 | 9601 | 20.024738 | 1922.57509538 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 2280 | 0 | NR | UNY41988.1 | 3003959 | g1 | i0 | 42.9 | 0.986772211227997 | 3158 | 1431 | 94.2 | 53 | 9434 | 393 | 1 | 2938 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 9474 | 2280 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27076134 | 27076134 | PRJNA454503_P_NODE_14622_length_301_cov_2.166667_g14293_i0 | PRJNA454503 | 14622 | 301 | 2.166667 | 6.52166767 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 178 | 2.26e-49 | NR | XCM67837.1 | 3003959 | g14293 | i0 | 82 | 0.996677740863787 | 100 | 18 | 99.7 | 0 | 1 | 300 | 1613 | 1712 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 300 | 178 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27234190 | 27234190 | PRJNA454503_P_NODE_24343_length_252_cov_1.020942_g24014_i0 | PRJNA454503 | 24343 | 252 | 1.020942 | 2.57277384 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 71.2 | 3.84e-12 | NR | XCM67837.1 | 3003959 | g24014 | i0 | 49.4 | 0.988095238095238 | 83 | 24 | 98.8 | 1 | 250 | 2 | 275 | 339 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 249 | 71.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27392352 | 27392352 | PRJNA454503_P_NODE_10103_length_352_cov_1.563574_g9774_i0 | PRJNA454503 | 10103 | 352 | 1.563574 | 5.50378048 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 119 | 1.86e-28 | NR | WAY16435.1 | 2809460 | g9774 | i0 | 47.5 | 1.02272727272727 | 120 | 59 | 98.9 | 1 | 3 | 350 | 871 | 990 | WAY16435.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 360 | 119 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27392353 | 27392353 | PRJNA454503_P_NODE_15443_length_295_cov_1.303419_g15114_i0 | PRJNA454503 | 15443 | 295 | 1.303419 | 3.84508605 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 171 | 5.55e-47 | NR | XCM67837.1 | 3003959 | g15114 | i0 | 79.6 | 0.996610169491525 | 98 | 20 | 99.7 | 0 | 2 | 295 | 1392 | 1489 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 294 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28592125 | 28592125 | PRJNA454503_P_NODE_35847_length_232_cov_1.263158_g35518_i0 | PRJNA454503 | 35847 | 232 | 1.263158 | 2.93052656 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 114 | 2.9100000000000003e-27 | NR | XCM67837.1 | 3003959 | g35518 | i0 | 70.3 | 0.956896551724138 | 74 | 22 | 95.7 | 0 | 2 | 223 | 802 | 875 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 222 | 114 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29397568 | 29397568 | PRJNA454503_P_NODE_20129_length_268_cov_1.231884_g19800_i0 | PRJNA454503 | 20129 | 268 | 1.231884 | 3.30144912 | Phlebovirus | 11584 | Viruses | Viruses | 59.3 | 4.53e-9 | NR | UWX37260.1 | 206378 | g19800 | i0 | 41.6 | 5.52985074626866 | 77 | 45 | 86.2 | 0 | 17 | 247 | 25 | 101 | UWX37260.1 nucleoprotein, partial [Phlebovirus sp.] | diamond | 1482 | 59.7 | 0.993299832495812 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Phlebovirus | Phlebovirus sp. | ||
| 29760098 | 29760098 | PRJNA454503_P_NODE_34271_length_234_cov_1.248555_g33942_i0 | PRJNA454503 | 34271 | 234 | 1.248555 | 2.9216187 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 150 | 5.96e-40 | NR | XCM67837.1 | 3003959 | g33942 | i0 | 87 | 0.987179487179487 | 77 | 10 | 98.7 | 0 | 232 | 2 | 1480 | 1556 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 231 | 150 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30044456 | 30044456 | PRJNA454503_P_NODE_87111_length_200_cov_2.330935_g86782_i0 | PRJNA454503 | 87111 | 200 | 2.330935 | 4.66187 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 119 | 2.33e-29 | NR | XCM67837.1 | 3003959 | g86782 | i0 | 90.9 | 0.99 | 66 | 6 | 99 | 0 | 199 | 2 | 481 | 546 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 198 | 119 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30392545 | 30392545 | PRJNA454503_P_NODE_51173_length_214_cov_1.699346_g50844_i0 | PRJNA454503 | 51173 | 214 | 1.699346 | 3.63660044 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 45.1 | 0.0039 | NR | WAY16510.1 | 2809460 | g50844 | i0 | 30.8 | 0.911214953271028 | 65 | 45 | 91.1 | 0 | 3 | 197 | 773 | 837 | WAY16510.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 195 | 45.1 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 31308387 | 31308387 | PRJNA454503_P_NODE_47695_length_218_cov_1.636943_g47366_i0 | PRJNA454503 | 47695 | 218 | 1.636943 | 3.56853574 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 104 | 5.619999999999999e-24 | NR | XCM67837.1 | 3003959 | g47366 | i0 | 73.6 | 0.990825688073395 | 72 | 19 | 99.1 | 0 | 218 | 3 | 1325 | 1396 | XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 216 | 104 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32035999 | 32035999 | PRJNA454503_P_NODE_98_length_2797_cov_2.933480_g51_i0 | PRJNA454503 | 98 | 2797 | 2.93348 | 82.0494356 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 1179 | 0 | NR | XCM67838.1 | 3003959 | g51 | i0 | 65.8 | 0.946013585984984 | 882 | 277 | 92.1 | 4 | 2 | 2578 | 142 | 1021 | XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 2646 | 1179 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32162727 | 32162727 | PRJNA454503_P_NODE_7878_length_400_cov_1.719764_g7549_i0 | PRJNA454503 | 7878 | 400 | 1.719764 | 6.879056 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 47.8 | 0.00386 | NR | WAY16469.1 | 2809460 | g7549 | i0 | 30 | 0.9 | 120 | 78 | 89.3 | 2 | 35 | 391 | 1672 | 1786 | WAY16469.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 360 | 47.8 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 32321111 | 32321111 | PRJNA454503_P_NODE_4919_length_522_cov_2.509761_g4594_i0 | PRJNA454503 | 4919 | 522 | 2.509761 | 13.10095242 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 129 | 4.89e-31 | NR | XCM67838.1 | 3003959 | g4594 | i0 | 67 | 0.540229885057471 | 94 | 31 | 54 | 0 | 241 | 522 | 45 | 138 | XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] | diamond | 282 | 129 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 32605391 | 32605391 | PRJNA454503_P_NODE_420_length_1639_cov_3.500634_g281_i0 | PRJNA454503 | 420 | 1639 | 3.500634 | 57.37539126 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 353 | 2.7199999999999993e-112 | NR | WAY16471.1 | 2809460 | g281 | i0 | 42.9 | 1.79194630872483 | 494 | 253 | 87.3 | 8 | 1546 | 116 | 1 | 482 | WAY16471.1 hypothetical protein [Hepelivirales sp.] | diamond | 2937 | 353 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 32794042 | 32794042 | PRJNA454503_P_NODE_36620_length_231_cov_1.247059_g36291_i0 | PRJNA454503 | 36620 | 231 | 1.247059 | 2.88070629 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 55.5 | 1.1e-6 | NR | WAY16437.1 | 2809460 | g36291 | i0 | 31 | 1.7012987012987 | 71 | 49 | 92.2 | 0 | 228 | 16 | 207 | 277 | WAY16437.1 nonstructural polyprotein [Hepelivirales sp.] | diamond | 393 | 55.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. |
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);;