RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 8 ✖

bioproject 1

  • PRJNA796753 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
4609128 4609128 PRJNA796753_P_NODE_44344_length_248_cov_0.880000_g44032_i0 PRJNA796753 44344 248 0.88 2.1824 Zebrafish picornavirus 1 2304617 Viruses Viruses 453 5.2600000000000005e-123   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g44032 i0 99.597 3 248 1 100 0 1 248 557 310 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 744 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14809162 14809162 PRJNA796753_P_NODE_15972_length_359_cov_1.272727_g15660_i0 PRJNA796753 15972 359 1.272727 4.56908993 Zebrafish picornavirus 1 2304617 Viruses Viruses 586 7.539999999999998e-163   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g15660 i0 96.1 3 359 14 100 0 1 359 6215 5857 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 1077 586 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14809165 14809165 PRJNA796753_P_NODE_16672_length_353_cov_1.307143_g16360_i0 PRJNA796753 16672 353 1.307143 4.61421479 Zebrafish picornavirus 1 2304617 Viruses Viruses 614 3.389999999999999e-171   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g16360 i0 98.017 3 353 7 100 0 1 353 7064 6712 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 1059 614 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
14809321 14809321 PRJNA796753_P_NODE_40792_length_250_cov_0.870056_g40480_i0 PRJNA796753 40792 250 0.870056 2.17514 Potyvirus phaseoluteum 3240594 Viruses Viruses 52.8 0.023   NTclustered gi|6409350|gb|AF192783.1|AF192783 12197 g40480 i0 100 0.112 28 0 11 0 84 111 38 65 Bean yellow mosaic virus strain LCbk-NN polyprotein mRNA, partial cds blastn 28 52.8 1 Viruses   Orthornavirae Pisuviricota Stelpaviricetes Patatavirales Potyviridae Potyvirus Potyvirus phaseoluteum
14809348 14809348 PRJNA796753_P_NODE_45392_length_247_cov_0.885057_g45080_i0 PRJNA796753 45392 247 0.885057 2.18609079 Ripafren virus 3130475 Viruses Viruses 348 2.5400000000000004e-91   NTclustered gi|2717319844|gb|PP172777.1| 3130475 g45080 i0 92.308 496.113360323887 247 16 100 2 1 247 946 703 MAG: Ripafren virus isolate KCAP1_k141_546482 genomic sequence blastn 122540 348 1 Viruses   Orthornavirae Lenarviricota Amabiliviricetes       Ripafren virus
18632072 18632072 PRJNA796753_P_NODE_14755_length_370_cov_3.582492_g14443_i0 PRJNA796753 14755 370 3.582492 13.2552204 Sopigix virus 3131702 Viruses Viruses 97.1 1.6e-15   NTclustered gi|2717323189|gb|PP174003.1| 3131702 g14443 i0 81.667 18.6918918918919 120 19 32 3 227 344 172 54 MAG: Sopigix virus isolate SP1B_k141_275369 genomic sequence blastn 6916 97.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Sopigix virus
19907461 19907461 PRJNA796753_P_NODE_24376_length_304_cov_1.000000_g24064_i0 PRJNA796753 24376 304 1 3.04 Zebrafish picornavirus 1 2304617 Viruses Viruses 512 1.08e-140   NTclustered gi|1812398529|gb|MN524064.1| 2304617 g24064 i0 97.039 3 304 9 100 0 1 304 2012 2315 Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome blastn 912 512 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Zebrafish picornavirus 1
25007055 25007055 PRJNA796753_P_NODE_20680_length_325_cov_1.222222_g20368_i0 PRJNA796753 20680 325 1.222222 3.9722215 Zebrafish picornavirus 1 2304617 Viruses Viruses 540 5.35e-149   NTclustered gi|2500378199|ref|NC_076245.1| 2304617 g20368 i0 96.615 3 325 11 100 0 1 325 1352 1676 Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome blastn 975 540 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);;