RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA454503", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Viruses · 17 ✖

tax_phylum 1

  • Pisuviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA454503 · 17 ✖

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

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