RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA703759", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 4 ✖

tax_kingdom 1

  • Orthornavirae · 4 ✖

bioproject 1

  • PRJNA703759 · 4 ✖

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
684873 684873 PRJNA703759_P_NODE_52641_length_208_cov_5.466667_g52165_i0 PRJNA703759 52641 208 5.466667 11.37066736 Cripavirus sp. 1955141 Viruses Viruses 374 3.4199999999999996e-99   NTclustered gi|2672713333|gb|OR723604.1| 1955141 g52165 i0 99.038 99.875 208 2 100 0 1 208 1778 1571 MAG: Cripavirus sp. isolate MSJDC22/4628 genomic sequence blastn 20774 374 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
5787600 5787600 PRJNA703759_P_NODE_17725_length_325_cov_1.547619_g17249_i0 PRJNA703759 17725 325 1.547619 5.02976175 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 538 1.9199999999999998e-148   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g17249 i0 96.584 0.990769230769231 322 11 99 0 2 323 6985 6664 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 322 538 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
15987541 15987541 PRJNA703759_P_NODE_693_length_2684_cov_3.439295_g425_i0 PRJNA703759 693 2684 3.439295 92.3106778 Cripavirus mortiferum 3047369 Viruses Viruses 4453 0   NTclustered gi|2395734185|gb|ON811696.1| 209529 g425 i0 96.61 88.5264530551416 2684 91 100 0 1 2684 9749 7066 MAG: Aphid lethal paralysis virus isolate TIGMIC_1, complete genome blastn 237605 4453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum
23637341 23637341 PRJNA703759_P_NODE_339_length_6608_cov_4.835042_g168_i0 PRJNA703759 339 6608 4.835042 319.49957536 Cripavirus mortiferum 3047369 Viruses Viruses 10586 0   NTclustered gi|2395734185|gb|ON811696.1| 209529 g168 i0 95.634 97.6820520581114 6597 287 99 1 11 6607 1 6596 MAG: Aphid lethal paralysis virus isolate TIGMIC_1, complete genome blastn 645483 10586 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus mortiferum

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