RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA764222" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 12 ✖

bioproject 1

  • PRJNA764222 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
2020708 2020708 PRJNA764222_S_NODE_2342_length_387_cov_5.723529_g2184_i0 PRJNA764222 2342 387 5.723529 22.15005723 Zebrafish picornavirus 1 2304617 Viruses Viruses 682 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g2184 i0 98.45 3 387 6 100 0 1 387 5715 6101 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1161 682 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
2020869 2020869 PRJNA764222_S_NODE_642_length_789_cov_115.111860_g525_i0 PRJNA764222 642 789 115.11186 908.2325754 Zebrafish picornavirus 1 2304617 Viruses Viruses 1380 0   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g525 i0 98.228 3.51584283903676 790 12 100 2 1 789 7449 8237 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 2774 1380 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
4573178 4573178 PRJNA764222_S_NODE_684_length_755_cov_11.381356_g562_i0 PRJNA764222 684 755 11.381356 85.9292378 Zebrafish picornavirus 1 2304617 Viruses Viruses 1297 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g562 i0 97.742 2.99205298013245 753 17 99 0 1 753 5046 4294 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 2259 1297 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
7123302 7123302 PRJNA764222_S_NODE_14146_length_238_cov_1.078534_g13988_i0 PRJNA764222 14146 238 1.078534 2.56691092 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.006   NTclustered gi|1995060321|gb|MN450069.1| 12164 g13988 i0 100 0.592436974789916 29 0 12 0 210 238 41 13 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
8398084 8398084 PRJNA764222_S_NODE_7987_length_278_cov_3.142857_g7829_i0 PRJNA764222 7987 278 3.142857 8.73714246 Zebrafish picornavirus 1 2304617 Viruses Viruses 486 5.919999999999998e-133   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g7829 i0 98.201 2.99640287769784 278 5 100 0 1 278 6158 6435 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 833 486 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
13498579 13498579 PRJNA764222_S_NODE_51_length_3420_cov_29.450341_g42_i0 PRJNA764222 51 3420 29.450341 1007.2016622 Zebrafish picornavirus 1 2304617 Viruses Viruses 5541 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g42 i0 95.912 3.00438596491228 3425 131 100 7 1 3420 96 3516 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 10275 5541 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14773744 14773744 PRJNA764222_S_NODE_52_length_3420_cov_27.912541_g42_i1 PRJNA764222 52 3420 27.912541 954.6089022 Zebrafish picornavirus 1 2304617 Viruses Viruses 5546 0   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g42 i1 95.942 3.00438596491228 3425 130 100 8 1 3420 3503 83 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 10275 5546 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
17323079 17323079 PRJNA764222_S_NODE_28654_length_174_cov_1.622047_g28496_i0 PRJNA764222 28654 174 1.622047 2.82236178 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 230 6.299999999999999e-56   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g28496 i0 94.04 0.867816091954023 151 9 87 0 21 171 1442 1592 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 151 230 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
17323208 17323208 PRJNA764222_S_NODE_9014_length_270_cov_1.650224_g8856_i0 PRJNA764222 9014 270 1.650224 4.4556048 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 416 7.619999999999998e-112   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8856 i0 94.444 1 270 15 100 0 1 270 2417 2148 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 270 416 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
18596583 18596583 PRJNA764222_S_NODE_9175_length_269_cov_1.193694_g9017_i0 PRJNA764222 9175 269 1.193694 3.21103686 Carlavirus latensdianthi 3427766 Viruses Viruses 52.8 0.025   NTclustered gi|1995060321|gb|MN450069.1| 12164 g9017 i0 100 0.104089219330855 28 0 10 0 1 28 14 41 Carnation latent virus isolate KL, complete genome blastn 28 52.8 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
19871332 19871332 PRJNA764222_S_NODE_1236_length_527_cov_61.160417_g1084_i0 PRJNA764222 1236 527 61.160417 322.31539759 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 723 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1084 i0 91.412 0.994307400379507 524 45 99 0 1 524 6586 7109 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 524 723 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
21147416 21147416 PRJNA764222_S_NODE_757_length_709_cov_7.564955_g629_i0 PRJNA764222 757 709 7.564955 53.63553095 Zebrafish picornavirus 1 2304617 Viruses Viruses 1205 0   NTclustered gi|1990739381|tpg|BK011179.1| 2304617 g629 i0 97.32 3 709 19 100 0 1 709 3505 4213 TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome blastn 2127 1205 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1

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