RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA784298" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 15 ✖

bioproject 1

  • PRJNA784298 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
1213104 1213104 PRJNA784298_P_NODE_12461_length_354_cov_1.334520_g12260_i0 PRJNA784298 12461 354 1.33452 4.7242008 Karamvirus 1913650 Viruses Viruses 95.3 5.49e-15   NTclustered gi|311992992|ref|NC_014662.1| 709484 g12260 i0 88.462 19.9858757062147 78 9 22 0 212 289 69941 70018 Enterobacteria phage CC31, complete genome blastn 7075 95.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Karamvirus Karamvirus cc31
3316576 3316576 PRJNA784298_P_NODE_18523_length_287_cov_3.037383_g18322_i0 PRJNA784298 18523 287 3.037383 8.71728921 Caudoviricetes sp. 2832643 Viruses Viruses 52.8 0.027   NTclustered gi|2053160346|tpg|BK019134.1| 2832643 g18322 i0 100 0.0975609756097561 28 0 10 0 230 257 7398 7371 MAG TPA_asm: Caudoviricetes sp. isolate ctHIK12, partial genome blastn 28 52.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
4593523 4593523 PRJNA784298_P_NODE_15364_length_317_cov_3.012295_g15163_i0 PRJNA784298 15364 317 3.012295 9.54897515 Caudoviricetes sp. 2832643 Viruses Viruses 134 1.03e-26   NTclustered gi|2054423370|tpg|BK035796.1| 2832643 g15163 i0 91.089 31.807570977918 101 6 32 2 196 295 31910 31812 MAG TPA_asm: Caudoviricetes sp. isolate ctihG4, partial genome blastn 10083 134 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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.
9693752 9693752 PRJNA784298_P_NODE_25828_length_244_cov_0.900585_g25627_i0 PRJNA784298 25828 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 407 4.08e-109   NTclustered gi|2057947732|tpg|BK046127.1| 2832643 g25627 i0 96.721 1 244 8 100 0 1 244 10636 10879 MAG TPA_asm: Caudoviricetes sp. isolate ct1Na9, partial genome blastn 244 407 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10969490 10969490 PRJNA784298_P_NODE_23709_length_251_cov_0.865169_g23508_i0 PRJNA784298 23709 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 254 5.81e-63   NTclustered gi|2914927280|gb|OR221502.1| 2832643 g23508 i0 85.141 3.9681274900398402 249 35 99 2 1 248 27169 27416 MAG: Caudoviricetes sp. isolate MSP1578 genomic sequence blastn 996 254 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
10969600 10969600 PRJNA784298_P_NODE_6389_length_501_cov_2.878505_g6189_i0 PRJNA784298 6389 501 2.878505 14.42131005 Caudoviricetes sp. 2832643 Viruses Viruses 592 2.3299999999999992e-164   NTclustered gi|2054434277|tpg|BK035998.1| 2832643 g6189 i0 97.953 471.532934131737 342 6 68 1 161 501 18419 18078 MAG TPA_asm: Caudoviricetes sp. isolate ctbaE6, partial genome blastn 236238 592 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes 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
13519077 13519077 PRJNA784298_P_NODE_16991_length_300_cov_74.286344_g16790_i0 PRJNA784298 16991 300 74.286344 222.859032 Acinetobacter phage BUCT628 2862737 Viruses Viruses 73.1 2.14e-8   NTclustered gi|2074144488|gb|MZ593728.1| 2862737 g16790 i0 84.932 9.52666666666667 73 9 24 2 230 300 39521 39449 Acinetobacter phage BUCT628, complete genome blastn 2858 73.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Obolenskvirus Acinetobacter phage BUCT628
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
14793986 14793986 PRJNA784298_P_NODE_25912_length_244_cov_0.900585_g25711_i0 PRJNA784298 25912 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 235 2.0399999999999997e-57   NTclustered gi|2914948592|gb|OR221870.1| 2832643 g25711 i0 93.125 0.655737704918033 160 11 66 0 85 244 42615 42774 MAG: Caudoviricetes sp. isolate MSP1137 genomic sequence blastn 160 235 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
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.
23718184 23718184 PRJNA784298_P_NODE_22379_length_259_cov_2.301075_g22178_i0 PRJNA784298 22379 259 2.301075 5.95978425 Tupanvirus salinum 3060758 Viruses Viruses 52.8 0.024   NTclustered gi|2500358058|ref|NC_075039.1| 2126985 g22178 i0 100 0.108108108108108 28 0 11 0 10 37 161520 161547 Tupanvirus soda lake, partial genome blastn 28 52.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus salinum

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