RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJNA784298 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
7143841 7143841 PRJNA784298_P_NODE_24686_length_248_cov_0.880000_g24485_i0 PRJNA784298 24686 248 0.88 2.1824 Botourmiaviridae sp. 2808997 Viruses Viruses 128 3.62e-25   NTclustered gi|2320142628|gb|ON585088.1| 2808997 g24485 i0 87.5 0.451612903225806 112 12 45 2 49 159 1341 1451 MAG: Botourmiaviridae sp. isolate PMS2_Contig239 RNA-dependent RNA polymerase gene, complete cds blastn 112 128 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Botourmiaviridae sp.
12244918 12244918 PRJNA784298_P_NODE_19750_length_278_cov_1.473171_g19549_i0 PRJNA784298 19750 278 1.473171 4.09541538 Grapevine wood holobiome associated ourmia-like virus 24 3399168 Viruses Viruses 183 8.7e-42   NTclustered gi|2917510545|gb|PQ773470.1| 3399168 g19549 i0 81.59 1.16187050359712 239 28 82 14 49 276 311 78 Grapevine wood holobiome associated ourmia-like virus 24 RdRp gene, complete cds blastn 323 183 1 Viruses   Orthornavirae Lenarviricota Miaviricetes Ourlivirales Botourmiaviridae   Grapevine wood holobiome associated ourmia-like virus 24
13519171 13519171 PRJNA784298_P_NODE_24891_length_247_cov_0.885057_g24690_i0 PRJNA784298 24891 247 0.885057 2.18609079 Cripavirus mortiferum 3047369 Viruses Viruses 418 1.9099999999999998e-112   NTclustered gi|1877229187|gb|MT336161.1| 209529 g24690 i0 97.166 59.0161943319838 247 7 100 0 1 247 2265 2511 Aphid lethal paralysis virus isolate Ir-Wi, complete genome blastn 14577 418 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
19892104 19892104 PRJNA784298_P_NODE_15136_length_320_cov_1.627530_g14935_i0 PRJNA784298 15136 320 1.62753 5.208096 Cripavirus mortiferum 3047369 Viruses Viruses 558 1.45e-154   NTclustered gi|1822266507|gb|MT096523.1| 209529 g14935 i0 98.125 20.20625 320 6 100 0 1 320 673 354 MAG: Aphid lethal paralysis virus isolate FTA2-1, complete genome blastn 6466 558 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
19892143 19892143 PRJNA784298_P_NODE_19896_length_277_cov_1.352941_g19695_i0 PRJNA784298 19896 277 1.352941 3.74764657 Cripavirus mortiferum 3047369 Viruses Viruses 501 2.11e-137   NTclustered gi|1877229187|gb|MT336161.1| 209529 g19695 i0 99.278 88.0469314079422 277 2 100 0 1 277 7140 6864 Aphid lethal paralysis virus isolate Ir-Wi, complete genome blastn 24389 501 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
21167873 21167873 PRJNA784298_P_NODE_21157_length_267_cov_2.293814_g20956_i0 PRJNA784298 21157 267 2.293814 6.12448338 Tombusviridae sp. 2583950 Viruses Viruses 268 2.23e-67   NTclustered gi|2171146054|gb|MZ218543.1| 2583950 g20956 i0 86.4 0.936329588014981 250 28 92 6 22 267 251 4 MAG: Tombusviridae sp. isolate 277-k141_9923 genomic sequence blastn 250 268 1 Viruses   Orthornavirae Kitrinoviricota Tolucaviricetes Tolivirales Tombusviridae   Tombusviridae sp.

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