contig_metadata
12 rows where bioproject = "PRJNA533114" and tax_kingdom = "Orthornavirae"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1780320 | 1780320 | PRJNA533114_P_NODE_3322_length_1156_cov_2.506002_g3180_i0 | PRJNA533114 | 3322 | 1156 | 2.506002 | 28.96938312 | brine shrimp arlivirus 8 | 2900383 | Viruses | Viruses | 406 | 8.539999999999999e-137 | NR | UNI74120.1 | 2900383 | g3180 | i0 | 56 | 0.908304498269896 | 350 | 154 | 90.8 | 0 | 1155 | 106 | 18 | 367 | UNI74120.1 MAG: hypothetical protein [brine shrimp arlivirus 8] | diamond | 1050 | 406 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsaeighalis | ||
| 4332153 | 4332153 | PRJNA533114_P_NODE_4_length_7169_cov_82.912909_g3_i0 | PRJNA533114 | 4 | 7169 | 82.912909 | 5944.02644621 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2948 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3 | i0 | 96.521 | 0.671083833170596 | 1782 | 58 | 67 | 4 | 5383 | 7162 | 5329 | 7108 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 4811 | 2948 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 6882201 | 6882201 | PRJNA533114_P_NODE_122246_length_233_cov_2.031250_g121994_i0 | PRJNA533114 | 122246 | 233 | 2.03125 | 4.7328125 | Zebrafish influenza B-like virus | RQ01 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|425786094|gb|CY128441.1| | RQ01 | g121994 | i0 | 100 | 0.124463519313305 | 29 | 0 | 12 | 0 | 53 | 81 | 2268 | 2296 | Influenza A virus (A/Viet Nam/001-1424/2009(H1N1)) PB1 and PB1-F2 genes, complete sequence | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Alphainfluenzavirus | Zebrafish influenza B-like virus | ||
| 13871455 | 13871455 | PRJNA533114_P_NODE_72831_length_282_cov_1.885167_g72579_i0 | PRJNA533114 | 72831 | 282 | 1.885167 | 5.31617094 | Norovirus | 142786 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|1832705315|gb|MT357898.1| | 122928 | g72579 | i0 | 100 | 0.595744680851064 | 28 | 0 | 10 | 0 | 2 | 29 | 7554 | 7581 | Norovirus GI isolate Hu/US/2017/GI.7[P7]/Pennsylvania1060 nonstructural polyprotein (ORF1), VP1 (ORF2), and VP2 (ORF3) genes, complete cds | blastn | 168 | 52.8 | 1 | Viruses | Norovirus GI | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Caliciviridae | Norovirus | Norovirus norwalkense | |
| 27598383 | 27598383 | PRJNA533114_P_NODE_7364_length_821_cov_2.053476_g7166_i0 | PRJNA533114 | 7364 | 821 | 2.053476 | 16.85903796 | Helfovirus | 3152732 | Viruses | Viruses | 55.8 | 7.78e-5 | NR | UJQ85368.1 | 2027243 | g7166 | i0 | 29.5 | 1.36662606577345 | 132 | 63 | 46.8 | 4 | 419 | 802 | 168 | 273 | UJQ85368.1 MAG: putative maturation protein [Leviviridae sp.] | diamond | 1122 | 56.2 | 0.99288256227758 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 28846020 | 28846020 | PRJNA533114_P_NODE_81628_length_269_cov_1.137755_g81376_i0 | PRJNA533114 | 81628 | 269 | 1.137755 | 3.06056095 | Qianjiang toti-like virus 11 | 3348833 | Viruses | Viruses | 50.8 | 7.25e-5 | NR | XHA85766.1 | 3348833 | g81376 | i0 | 35.6 | 0.970260223048327 | 87 | 55 | 95.9 | 1 | 267 | 10 | 392 | 478 | XHA85766.1 MAG: putative RNA-dependent RNA polymerase [Qianjiang toti-like virus 11] | diamond | 261 | 50.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Chrymotiviricetes | Ghabrivirales | Totiviridae | Qianjiang toti-like virus 11 | |||
| 30882539 | 30882539 | PRJNA533114_P_NODE_8794_length_758_cov_2.242336_g8578_i0 | PRJNA533114 | 8794 | 758 | 2.242336 | 16.99690688 | Soetuvirus | 2843054 | Viruses | Viruses | 123 | 2.35e-28 | NR | URG15442.1 | 2027243 | g8578 | i0 | 38.4 | 1.81662269129288 | 232 | 115 | 86.7 | 10 | 660 | 4 | 34 | 250 | URG15442.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 1377 | 124 | 0.991935483870968 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31198104 | 31198104 | PRJNA533114_P_NODE_108595_length_245_cov_1.697674_g108343_i0 | PRJNA533114 | 108595 | 245 | 1.697674 | 4.1593013 | Lenarviricota | 2732407 | Viruses | Viruses | 79.7 | 3.55e-15 | NR | URG16191.1 | 2027243 | g108343 | i0 | 51.5 | 4.24897959183673 | 66 | 32 | 80.8 | 0 | 218 | 21 | 136 | 201 | URG16191.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 1041 | 80.1 | 0.995006242197254 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31214647 | 31214647 | PRJNA533114_P_NODE_23395_length_469_cov_1.295455_g23145_i0 | PRJNA533114 | 23395 | 469 | 1.295455 | 6.07568395 | Leviviridae sp. | 2027243 | Viruses | Viruses | 124 | 2.05e-30 | NR | URG15607.1 | 2027243 | g23145 | i0 | 41.6 | 1.89339019189765 | 149 | 78 | 90.2 | 3 | 1 | 423 | 239 | 386 | URG15607.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.] | diamond | 888 | 124 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 31278345 | 31278345 | PRJNA533114_P_NODE_9195_length_741_cov_2.950599_g8972_i0 | PRJNA533114 | 9195 | 741 | 2.950599 | 21.86393859 | ssRNA phage SRR696 | 2845715 | Viruses | Viruses | 82.4 | 4.69e-14 | NR | YP_010769650.1 | 2786625 | g8972 | i0 | 36.8 | 0.615384615384615 | 152 | 87 | 60.7 | 5 | 741 | 292 | 265 | 409 | YP_010769650.1 maturation protein [ssRNA phage SRR6960803_9] | diamond | 456 | 82.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Omohevirus | Omohevirus peladaptatum | ||
| 32449074 | 32449074 | PRJNA533114_P_NODE_18159_length_531_cov_1.510917_g17910_i0 | PRJNA533114 | 18159 | 531 | 1.510917 | 8.02296927 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 97.1 | 1.05e-19 | NR | WLN26256.1 | 3065075 | g17910 | i0 | 50.5 | 0.514124293785311 | 91 | 45 | 51.4 | 0 | 530 | 258 | 144 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 273 | 97.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 32480689 | 32480689 | PRJNA533114_P_NODE_40499_length_365_cov_0.979452_g40247_i0 | PRJNA533114 | 40499 | 365 | 0.979452 | 3.5749998 | Phytophthora palustris narna-like virus 7 | 2976299 | Viruses | Viruses | 65.5 | 1.67e-9 | NR | WAK73591.1 | 2976299 | g40247 | i0 | 40.8 | 0.583561643835616 | 71 | 42 | 58.4 | 0 | 364 | 152 | 717 | 787 | WAK73591.1 RNA-dependent RNA polymerase [Phytophthora palustris narna-like virus 7] | diamond | 213 | 65.5 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Phytophthora palustris narna-like virus 7 |
Advanced export
JSON shape: default, array, newline-delimited
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);;