RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA977246", tax_phylum = "Pisuviricota" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 5 ✖

tax_phylum 1

  • Pisuviricota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA977246 · 5 ✖

analysis 1

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
7329430 7329430 PRJNA977246_S_NODE_48126_length_158_cov_2.860465_g47134_i0 PRJNA977246 48126 158 2.860465 4.5195347 Cripavirus mortiferum 3047369 Viruses Viruses 272 9.21e-69   NTclustered gi|1877229187|gb|MT336161.1| 209529 g47134 i0 97.5 92.1772151898734 160 2 100 2 1 158 2628 2469 Aphid lethal paralysis virus isolate Ir-Wi, complete genome blastn 14564 272 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
16254542 16254542 PRJNA977246_S_NODE_47173_length_160_cov_4.320611_g46181_i0 PRJNA977246 47173 160 4.320611 6.9129776 Nepovirus avii 3047741 Viruses Viruses 272 9.36e-69   NTclustered gi|2583712472|gb|OR450104.1| 12615 g46181 i0 97.484 96.925 159 4 99 0 1 159 250 408 Cherry leaf roll virus isolate WL1 3' UTR blastn 15508 272 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus avii
17529665 17529665 PRJNA977246_S_NODE_47474_length_160_cov_1.480916_g46482_i0 PRJNA977246 47474 160 1.480916 2.3694656 Cripavirus sp. 1955141 Viruses Viruses 279 5.59e-71   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g46482 i0 98.125 36.8625 160 3 100 0 1 160 4258 4099 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 5898 279 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
20077445 20077445 PRJNA977246_S_NODE_14196_length_391_cov_8.522099_g13211_i0 PRJNA977246 14196 391 8.522099 33.32140709 Cripavirus mortiferum 3047369 Viruses Viruses 630 3.769999999999999e-176   NTclustered gi|24943167|ref|NC_004365.1| 209529 g13211 i0 98.072 63.3120204603581 363 6 93 1 6 368 9803 9442 Aphid lethal paralysis virus, complete genome blastn 24755 630 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
21352949 21352949 PRJNA977246_S_NODE_14717_length_382_cov_5402.575071_g13728_i0 PRJNA977246 14717 382 5402.575071 20637.83677122 Cripavirus sp. 1955141 Viruses Viruses 592 1.7399999999999993e-164   NTclustered gi|2754691479|gb|PP872551.1| 1955141 g13728 i0 98.795 86.151832460733 332 4 87 0 1 332 3541 3210 MAG: Cripavirus sp. isolate TC-CrV-1 MR233-17E/2200 genomic sequence blastn 32910 592 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus 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);;