RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA743294 · 21 ✖

analysis 1

  • blastn · 21 ✖

tax_clade 0

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
721931 721931 PRJNA743294_P_NODE_1_length_9367_cov_113.821283_g0_i0 PRJNA743294 1 9367 113.821283 10661.63957861 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 7862 0   NTclustered gi|2754691670|gb|PP872622.1| 3003959 g0 i0 92.62 2.57489057328921 5474 395 97 8 3365 8834 5826 358 MAG: Picornavirales sp. isolate TC-PLV-66 MR233-17E/340 genomic sequence blastn 24119 7862 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
722229 722229 PRJNA743294_P_NODE_7901_length_558_cov_2.536082_g7446_i0 PRJNA743294 7901 558 2.536082 14.15133756 Robinvale bee virus 8 2201319 Viruses Viruses 348 6.26e-91   NTclustered gi|1390040462|gb|MG995716.1| 2201319 g7446 i0 89.455 1.81182795698925 275 29 49 0 3 277 8980 8706 Robinvale bee virus 8 isolate VN1-22 nonstructural polyprotein and structural polyprotein genes, complete cds blastn 1011 348 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Robinvale bee virus 8
1998040 1998040 PRJNA743294_P_NODE_2_length_9231_cov_92.919633_g1_i0 PRJNA743294 2 9231 92.919633 8577.41132223 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 15623 0   NTclustered gi|2754692388|gb|PP872891.1| 3003959 g1 i0 97.216 3.6487921135305 9231 257 100 0 1 9231 9 9239 MAG: Picornavirales sp. isolate TC-PLV-335 MR233-17E/2332 genomic sequence blastn 33682 15623 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
3273423 3273423 PRJNA743294_P_NODE_3_length_8692_cov_61.340991_g2_i0 PRJNA743294 3 8692 61.340991 5331.75893772 Marnaviridae sp. 2715102 Viruses Viruses 14622 0   NTclustered gi|2196307271|gb|MZ679144.1| 2715102 g2 i0 97.339 3.79993097100782 8607 226 99 3 87 8692 8615 11 MAG: Marnaviridae sp. isolate s48-k141_130300 hypothetical protein gene, complete cds blastn 33029 14622 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
3273521 3273521 PRJNA743294_P_NODE_52203_length_246_cov_1.803468_g51747_i0 PRJNA743294 52203 246 1.803468 4.43653128 Robinvale bee virus 8 2201319 Viruses Viruses 383 6.94e-102   NTclustered gi|1390040462|gb|MG995716.1| 2201319 g51747 i0 94.715 4.57723577235772 246 13 100 0 1 246 6211 5966 Robinvale bee virus 8 isolate VN1-22 nonstructural polyprotein and structural polyprotein genes, complete cds blastn 1126 383 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Robinvale bee virus 8
5825812 5825812 PRJNA743294_P_NODE_5_length_6388_cov_34.196991_g0_i1 PRJNA743294 5 6388 34.196991 2184.50378508 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 7873 0   NTclustered gi|2754691670|gb|PP872622.1| 3003959 g0 i1 92.656 2.8891671884784 5474 393 98 8 386 5855 5826 358 MAG: Picornavirales sp. isolate TC-PLV-66 MR233-17E/340 genomic sequence blastn 18456 7873 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
7100719 7100719 PRJNA743294_P_NODE_29966_length_304_cov_1.350649_g29510_i0 PRJNA743294 29966 304 1.350649 4.10597296 Enterovirus cerhino 3428504 Viruses Viruses 520 6.459999999999999e-143   NTclustered gi|2699854052|gb|PP187408.1| 1604833 g29510 i0 97.682 8.10855263157895 302 7 99 0 1 302 6441 6140 MAG: Rhinovirus C54 isolate RV-C54/USA/273556/2023 genomic sequence blastn 2465 520 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Enterovirus Enterovirus cerhino
7100840 7100840 PRJNA743294_P_NODE_45686_length_254_cov_1.679558_g45230_i0 PRJNA743294 45686 254 1.679558 4.26607732 Crogonang virus 95 3063218 Viruses Viruses 320 5.73e-83   NTclustered gi|2626079828|gb|OR270483.1| 3063218 g45230 i0 89.641 2.9488188976378 251 26 99 0 1 251 1092 1342 MAG: Crogonang virus 95 isolate CGH03 genomic sequence blastn 749 320 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 95
7100952 7100952 PRJNA743294_P_NODE_6_length_6270_cov_41.360820_g4_i0 PRJNA743294 6 6270 41.36082 2593.323414 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 8889 0   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g4 i0 94.574 3.82870813397129 5750 310 96 2 1 5750 3 5750 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 24006 8889 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
8375314 8375314 PRJNA743294_P_NODE_26667_length_320_cov_1.485830_g26211_i0 PRJNA743294 26667 320 1.48583 4.754656 Robinvale bee virus 8 2201319 Viruses Viruses 431 3.3e-116   NTclustered gi|1390040462|gb|MG995716.1| 2201319 g26211 i0 90.938 3.525 320 29 100 0 1 320 5307 4988 Robinvale bee virus 8 isolate VN1-22 nonstructural polyprotein and structural polyprotein genes, complete cds blastn 1128 431 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Robinvale bee virus 8
8375591 8375591 PRJNA743294_P_NODE_7_length_6270_cov_40.109892_g4_i1 PRJNA743294 7 6270 40.109892 2514.8902284 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 8661 0   NTclustered gi|2214231736|gb|OM622340.1| 3003959 g4 i1 93.862 3.82870813397129 5751 349 96 4 1 5750 3 5750 MAG: Picornavirales sp. isolate HPLV-85 genomic sequence blastn 24006 8661 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
9650480 9650480 PRJNA743294_P_NODE_30948_length_300_cov_1.030837_g30492_i0 PRJNA743294 30948 300 1.030837 3.092511 Robinvale bee virus 8 2201319 Viruses Viruses 438 1.8299999999999998e-118   NTclustered gi|1390040462|gb|MG995716.1| 2201319 g30492 i0 93 1 300 21 100 0 1 300 1129 830 Robinvale bee virus 8 isolate VN1-22 nonstructural polyprotein and structural polyprotein genes, complete cds blastn 300 438 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Robinvale bee virus 8
12201249 12201249 PRJNA743294_P_NODE_10_length_4997_cov_4.967506_g7_i0 PRJNA743294 10 4997 4.967506 248.22627482 Marnaviridae sp. 2715102 Viruses Viruses 3086 0   NTclustered gi|2196309030|gb|MZ679235.1| 2715102 g7 i0 82.693 0.885931558935361 3490 590 70 12 890 4372 31 3513 MAG: Marnaviridae sp. isolate R45-k141_578670 polyprotein gene, partial cds blastn 4427 3086 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
12201367 12201367 PRJNA743294_P_NODE_2450_length_941_cov_28.967742_g0_i2 PRJNA743294 2450 941 28.967742 272.58645222 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 381 1.07e-100   NTclustered gi|2754691670|gb|PP872622.1| 3003959 g0 i2 95.798 1.40913921360255 238 7 70 1 451 688 345 111 MAG: Picornavirales sp. isolate TC-PLV-66 MR233-17E/340 genomic sequence blastn 1326 381 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
12201585 12201585 PRJNA743294_P_NODE_51990_length_246_cov_4.410405_g51534_i0 PRJNA743294 51990 246 4.410405 10.8495963 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 134 7.71e-27   NTclustered gi|2754691670|gb|PP872622.1| 3003959 g51534 i0 95.238 0.682926829268293 84 4 34 0 3 86 8781 8698 MAG: Picornavirales sp. isolate TC-PLV-66 MR233-17E/340 genomic sequence blastn 168 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
19848932 19848932 PRJNA743294_P_NODE_16_length_4440_cov_100.192810_g4_i4 PRJNA743294 16 4440 100.19281 4448.560764 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 4811 0   NTclustered gi|2754692266|gb|PP872842.1| 3003959 g4 i4 96.314 3.2 2930 106 94 2 1 2929 8949 6021 MAG: Picornavirales sp. isolate TC-PLV-286 MR233-17E/1659 genomic sequence blastn 14208 4811 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22399357 22399357 PRJNA743294_P_NODE_13058_length_442_cov_1.547425_g12602_i0 PRJNA743294 13058 442 1.547425 6.8396185 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 318 3.82e-82   NTclustered gi|2754692774|gb|PP873055.1| 3003959 g12602 i0 79.684 1.25565610859729 443 88 100 2 1 442 1098 657 MAG: Picornavirales sp. isolate TC-PLV-499 MR233-17E/5335 genomic sequence blastn 555 318 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
22399408 22399408 PRJNA743294_P_NODE_18_length_4061_cov_159.799900_g1_i1 PRJNA743294 18 4061 159.7999 6489.473939 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 5105 0   NTclustered gi|2754692388|gb|PP872891.1| 3003959 g1 i1 95.496 2.10243782319626 3197 143 87 1 1 3197 9239 6044 MAG: Picornavirales sp. isolate TC-PLV-335 MR233-17E/2332 genomic sequence blastn 8538 5105 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
23674980 23674980 PRJNA743294_P_NODE_24599_length_331_cov_4.899225_g24143_i0 PRJNA743294 24599 331 4.899225 16.21643475 Lactuca sativa marnavirus 2739890 Viruses Viruses 163 1.3799999999999998e-35   NTclustered gi|1854297561|gb|MN823692.1| 2739890 g24143 i0 80.088 0.81570996978852 226 40 68 4 9 232 7967 7745 Lactuca sativa marnavirus strain pt151-mar-12, complete genome blastn 270 163 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Marnavirus Lactuca sativa marnavirus
24149942 24149942 PRJNA743294_P_NODE_19_length_4061_cov_151.578485_g1_i2 PRJNA743294 19 4061 151.578485 6155.60227585 Locarnavirus 2560169 Viruses Viruses 4927 0   NTclustered gi|1694999168|ref|NC_043518.1| 1416631 g1 i2 94.681 2.10243782319626 3177 166 86 3 22 3197 9311 6137 Marine RNA virus SF-2 gp1 and gp2 genes, complete cds blastn 8538 4955 0.994349142280525 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus derisii
24948466 24948466 PRJNA743294_P_NODE_24680_length_331_cov_2.007752_g24224_i0 PRJNA743294 24680 331 2.007752 6.64565912 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 235 2.8799999999999995e-57   NTclustered gi|2754692774|gb|PP873055.1| 3003959 g24224 i0 80.061 0.984894259818731 326 57 97 8 8 329 3527 3848 MAG: Picornavirales sp. isolate TC-PLV-499 MR233-17E/5335 genomic sequence blastn 326 235 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;