RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA680334" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA680334 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
649533 649533 PRJNA680334_S_NODE_35341_length_213_cov_11.938889_g34855_i0 PRJNA680334 35341 213 11.938889 25.42983357 Grapevine partitivirus 1256786 Viruses Viruses 385 1.63e-102   NTclustered gi|1613874758|gb|MH802024.1| 1256786 g34855 i0 99.526 1.981220657277 211 1 99 0 1 211 1679 1889 Grapevine partitivirus isolate 12G4125, complete sequence blastn 422 385 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Grapevine partitivirus
5752906 5752906 PRJNA680334_S_NODE_16565_length_269_cov_7.241525_g16079_i0 PRJNA680334 16565 269 7.241525 19.47970225 Alphapartitivirus carotae 3426226 Viruses Viruses 496 9.47e-136   NTclustered gi|1464310058|ref|NC_038824.1| 589918 g16079 i0 100 0.996282527881041 268 0 99 0 1 268 1906 1639 Carrot cryptic virus segment RNA 1 RNA-dependent RNA polymerase gene, complete cds blastn 268 496 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Alphapartitivirus carotae
7027981 7027981 PRJNA680334_S_NODE_19366_length_257_cov_2.937500_g18880_i0 PRJNA680334 19366 257 2.9375 7.549375 Fushun dicistrovirus 1 2905403 Viruses Viruses 394 3.37e-105   NTclustered gi|2169232434|gb|MZ210045.1| 2905403 g18880 i0 94.862 0.98443579766537 253 11 98 2 7 257 8611 8863 MAG: Fushun dicistrovirus 1 isolate XSZFS89, complete genome blastn 253 394 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Fushun dicistrovirus 1
10853379 10853379 PRJNA680334_S_NODE_1729_length_540_cov_47.282051_g1273_i0 PRJNA680334 1729 540 47.282051 255.3230754 Zebrafish jaw picornavirus RQ13 Viruses Viruses 499 1.5799999999999999e-136   NTclustered gi|2626604933|gb|OR645505.1| RQ13 g1273 i0 85.2 4.82407407407407 500 59 91 14 2 493 7324 7816 MAG: Passerivirus GPS isolate OM4 polyprotein gene, complete cds blastn 2605 499 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Passerivirus Zebrafish jaw picornavirus
10853689 10853689 PRJNA680334_S_NODE_3349_length_435_cov_5.783582_g2868_i0 PRJNA680334 3349 435 5.783582 25.1585817 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 693 0   NTclustered gi|2196304039|gb|MZ679032.1| 3003959 g2868 i0 95.612 8.50574712643678 433 17 99 2 1 433 4730 5160 MAG: Picornavirales sp. isolate 377R-k141_737244 putative polyprotein gene, partial cds blastn 3700 693 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
12128412 12128412 PRJNA680334_S_NODE_10010_length_314_cov_6.583630_g9524_i0 PRJNA680334 10010 314 6.58363 20.6725982 Red mite dicistrovirus 1 2936551 Viruses Viruses 529 1.1099999999999996e-145   NTclustered gi|2239998172|gb|ON160029.1| 2936551 g9524 i0 97.125 0.996815286624204 313 9 99 0 1 313 2139 2451 Red mite dicistrovirus 1 isolate RMDIV1 polyprotein gene, complete cds blastn 313 529 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Red mite dicistrovirus 1
12129689 12129689 PRJNA680334_S_NODE_74090_length_169_cov_2.867647_g73604_i0 PRJNA680334 74090 169 2.867647 4.84632343 Zebrafish jaw picornavirus RQ13 Viruses Viruses 196 6.16e-46   NTclustered gi|2626604933|gb|OR645505.1| RQ13 g73604 i0 87.952 1.94674556213018 166 20 98 0 1 166 7348 7183 MAG: Passerivirus GPS isolate OM4 polyprotein gene, complete cds blastn 329 196 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Passerivirus Zebrafish jaw picornavirus
14679261 14679261 PRJNA680334_S_NODE_6872_length_351_cov_7.025157_g6386_i0 PRJNA680334 6872 351 7.025157 24.65830107 Nepovirus avii 3047741 Viruses Viruses 625 1.5599999999999998e-174   NTclustered gi|2419396264|gb|ON924207.1| 12615 g6386 i0 98.86 96.1168091168091 351 3 99 1 2 351 6005 6355 Cherry leaf roll virus isolate DSMZ PV-0200 segment RNA 2, complete sequence blastn 33737 625 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
15952584 15952584 PRJNA680334_S_NODE_44893_length_198_cov_5.266667_g44407_i0 PRJNA680334 44893 198 5.266667 10.42800066 Alphapartitivirus carotae 3426226 Viruses Viruses 366 5.4e-97   NTclustered gi|1464310056|ref|NC_038823.1| 589918 g44407 i0 100 1 198 0 100 0 1 198 1458 1261 Carrot cryptic virus segment RNA 2 coat protein gene, complete cds blastn 198 366 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Alphapartitivirus Alphapartitivirus carotae
17228358 17228358 PRJNA680334_S_NODE_754_length_799_cov_25.552219_g377_i0 PRJNA680334 754 799 25.552219 204.16222981 Red mite dicistrovirus 1 2936551 Viruses Viruses 778 0   NTclustered gi|2239998172|gb|ON160029.1| 2936551 g377 i0 97.577 0.996245306633292 454 11 98 0 339 792 8562 9015 Red mite dicistrovirus 1 isolate RMDIV1 polyprotein gene, complete cds blastn 796 778 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Red mite dicistrovirus 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);;