RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA1093008" 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

  • PRJNA1093008 · 8 ✖

analysis 1

  • diamond · 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
20600020 20600020 PRJNA1093008_S_NODE_93537_length_242_cov_2.733728_g93210_i0 PRJNA1093008 93537 242 2.733728 6.61562176 Partitiviridae sp. 1955170 Viruses Viruses 127 1.94e-33   NR QDH91349.1 1955170 g93210 i0 82.2 5.4297520661157 73 13 90.5 0 221 3 163 235 QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.] diamond 1314 127 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Partitiviridae sp.
27510086 27510086 PRJNA1093008_S_NODE_45063_length_303_cov_1.339130_g44736_i0 PRJNA1093008 45063 303 1.33913 4.0575639 Lepidopteran phasma-related virus OKIAV246 2746306 Viruses Viruses 97.8 3.53e-21   NR QMP82218.1 2746306 g44736 i0 44 0.99009900990099 100 56 99 0 2 301 1155 1254 QMP82218.1 RNA-dependent RNA polymerase, partial [Lepidopteran phasma-related virus OKIAV246] diamond 300 97.8 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Lepidopteran phasma-related virus OKIAV246
27510087 27510087 PRJNA1093008_S_NODE_47483_length_298_cov_3.071111_g47156_i0 PRJNA1093008 47483 298 3.071111 9.15191078 Lepidopteran phasma-related virus OKIAV246 2746306 Viruses Viruses 114 5.3e-27   NR QMP82218.1 2746306 g47156 i0 61.6 0.996644295302013 99 38 99.7 0 2 298 176 274 QMP82218.1 RNA-dependent RNA polymerase, partial [Lepidopteran phasma-related virus OKIAV246] diamond 297 114 1 Viruses   Orthornavirae Negarnaviricota Bunyaviricetes Elliovirales Phasmaviridae   Lepidopteran phasma-related virus OKIAV246
27825810 27825810 PRJNA1093008_S_NODE_34324_length_326_cov_2.407115_g33997_i0 PRJNA1093008 34324 326 2.407115 7.8471949 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 104 2.4799999999999994e-23   NR AVM87439.1 3063761 g33997 i0 54.5 0.809815950920245 88 40 81 0 264 1 928 1015 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 264 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
27880231 27880231 PRJNA1093008_S_NODE_7665_length_478_cov_3.140741_g7340_i0 PRJNA1093008 7665 478 3.140741 15.01274198 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 114 7.23e-26   NR YP_009104360.1 3063761 g7340 i0 48.4 3.55230125523013 128 63 78.5 3 70 444 765 892 YP_009104360.1 polyprotein [Crohivirus A] diamond 1698 115 0.991304347826087 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae Crohivirus Danio blood picornavirus/Zebrafish picornavirus 2
29878177 29878177 PRJNA1093008_S_NODE_75351_length_258_cov_1.248649_g75024_i0 PRJNA1093008 75351 258 1.248649 3.22151442 Betapartitivirus sp. 1955169 Viruses Viruses 111 2.46e-26   NR UDL14392.1 1955169 g75024 i0 64.7 0.988372093023256 85 30 98.8 0 2 256 55 139 UDL14392.1 MAG: putative RNA-dependent RNA polymerase, partial [Betapartitivirus sp.] diamond 255 111 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae Betapartitivirus Betapartitivirus sp.
32502321 32502321 PRJNA1093008_S_NODE_90239_length_245_cov_0.895349_g89912_i0 PRJNA1093008 90239 245 0.895349 2.19360505 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 107 5.01e-25   NR AVM87439.1 3063761 g89912 i0 60.5 0.991836734693878 81 32 99.2 0 1 243 247 327 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 243 107 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
32722847 32722847 PRJNA1093008_S_NODE_37280_length_319_cov_2.414634_g36953_i0 PRJNA1093008 37280 319 2.414634 7.70268246 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 79.7 1.01e-14   NR AVM87439.1 3063761 g36953 i0 44.4 0.931034482758621 99 47 88.4 3 38 319 1440 1535 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 297 79.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2

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