contig_metadata
14 rows where bioproject = "PRJNA512103" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4312473 | 4312473 | PRJNA512103_P_NODE_14464_length_274_cov_1.582222_g14052_i0 | PRJNA512103 | 14464 | 274 | 1.582222 | 4.33528828 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 486 | 5.8199999999999984e-133 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g14052 | i0 | 99.624 | 10.6788321167883 | 266 | 1 | 97 | 0 | 1 | 266 | 5336 | 5601 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2926 | 486 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 5590191 | 5590191 | PRJNA512103_P_NODE_4705_length_700_cov_2.499232_g4334_i0 | PRJNA512103 | 4705 | 700 | 2.499232 | 17.494624 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 1266 | 0 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g4334 | i0 | 99.711 | 10.8642857142857 | 692 | 1 | 99 | 1 | 1 | 691 | 8528 | 9219 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 7605 | 1266 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 6864187 | 6864187 | PRJNA512103_P_NODE_5666_length_602_cov_1.556962_g5278_i0 | PRJNA512103 | 5666 | 602 | 1.556962 | 9.37291124 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 1057 | 0 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g5278 | i0 | 98.985 | 11.0083056478405 | 591 | 5 | 98 | 1 | 9 | 598 | 2997 | 3587 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 6627 | 1057 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 6864247 | 6864247 | PRJNA512103_P_NODE_6_length_10678_cov_7273.287986_g4_i0 | PRJNA512103 | 6 | 10678 | 7273.287986 | 776641.69114508 | Maanshan Dicis tick virus 1 | 2972097 | Viruses | Viruses | 843 | 6.289999999999998e-258 | NR | UYL95314.1 | 2972097 | g4 | i0 | 32.3 | 4.52725229443716 | 1819 | 974 | 49.4 | 34 | 1997 | 7267 | 108 | 1731 | UYL95314.1 MAG: replicase polyprotein [Maanshan Dicis tick virus 1] | diamond | 48342 | 843 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Maanshan Dicis tick virus 1 | |||
| 8138785 | 8138785 | PRJNA512103_P_NODE_17767_length_232_cov_6.136612_g17355_i0 | PRJNA512103 | 17767 | 232 | 6.136612 | 14.23693984 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 364 | 2.3499999999999995e-96 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g17355 | i0 | 97.209 | 2.7801724137931 | 215 | 6 | 93 | 0 | 10 | 224 | 6141 | 5927 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 645 | 364 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 11965088 | 11965088 | PRJNA512103_P_NODE_3850_length_816_cov_2.376793_g3519_i0 | PRJNA512103 | 3850 | 816 | 2.376793 | 19.39463088 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 769 | 0 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g3519 | i0 | 99.526 | 10.3259803921569 | 422 | 2 | 94 | 0 | 395 | 816 | 7168 | 6747 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 8426 | 769 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 13239794 | 13239794 | PRJNA512103_P_NODE_22391_length_200_cov_1.350993_g21979_i0 | PRJNA512103 | 22391 | 200 | 1.350993 | 2.701986 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 348 | 1.98e-91 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g21979 | i0 | 98.969 | 10.67 | 194 | 2 | 97 | 0 | 1 | 194 | 1900 | 2093 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 2134 | 348 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 13240476 | 13240476 | PRJNA512103_P_NODE_9091_length_406_cov_1.809524_g8679_i0 | PRJNA512103 | 9091 | 406 | 1.809524 | 7.34666744 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 739 | 0 | NTclustered | gi|2209094746|gb|OL472445.1| | 2900464 | g8679 | i0 | 99.507 | 11 | 406 | 2 | 100 | 0 | 1 | 406 | 6738 | 6333 | MAG: Brine shrimp iflavirus 3 isolate KC/14 RNA-dependent RNA polymerase gene, complete cds | blastn | 4466 | 739 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 17063616 | 17063616 | PRJNA512103_P_NODE_4114_length_777_cov_2.590659_g3765_i0 | PRJNA512103 | 4114 | 777 | 2.590659 | 20.12942043 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 1391 | 0 | NTclustered | gi|2209094748|gb|OL472446.1| | 2900464 | g3765 | i0 | 99.349 | 10.8725868725869 | 768 | 5 | 99 | 0 | 10 | 777 | 8470 | 7703 | MAG: Brine shrimp iflavirus 3 isolate VIE/10 RNA-dependent RNA polymerase gene, complete cds | blastn | 8448 | 1391 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 19611751 | 19611751 | PRJNA512103_P_NODE_17876_length_232_cov_0.885246_g17464_i0 | PRJNA512103 | 17876 | 232 | 0.885246 | 2.05377072 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 401 | 1.7899999999999994e-107 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g17464 | i0 | 99.103 | 10.573275862069 | 223 | 2 | 96 | 0 | 10 | 232 | 3936 | 3714 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2453 | 401 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 20237297 | 20237297 | PRJNA512103_P_NODE_3536_length_866_cov_3.835985_g3223_i0 | PRJNA512103 | 3536 | 866 | 3.835985 | 33.2196301 | Cripavirus | 144051 | Viruses | Viruses | 86.1 | 8.6e-12 | NTclustered | gi|2802644575|gb|PQ246907.1| | 12136 | g3223 | i0 | 100 | 1.08775981524249 | 46 | 0 | 5 | 0 | 801 | 846 | 9097 | 9142 | Cricket paralysis virus strain CrPV_BEE, complete genome | blastn | 942 | 86.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Cripavirus | Cripavirus grylli | ||
| 22162566 | 22162566 | PRJNA512103_P_NODE_18_length_8280_cov_20.232657_g13_i0 | PRJNA512103 | 18 | 8280 | 20.232657 | 1675.2639996 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 13322 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13 | i0 | 95.789 | 3.03743961352657 | 8264 | 336 | 99 | 7 | 13 | 8273 | 3 | 8257 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 25150 | 13322 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22163101 | 22163101 | PRJNA512103_P_NODE_34318_length_162_cov_1.238938_g33906_i0 | PRJNA512103 | 34318 | 162 | 1.238938 | 2.00707956 | brine shrimp iflavirus 3 | 2900464 | Viruses | Viruses | 279 | 5.68e-71 | NTclustered | gi|2209094754|gb|OL472449.1| | 2900464 | g33906 | i0 | 99.351 | 10.4444444444444 | 154 | 1 | 95 | 0 | 9 | 162 | 2815 | 2662 | MAG: Brine shrimp iflavirus 3 isolate NM/94-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 1692 | 279 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | brine shrimp iflavirus 3 | ||
| 32163756 | 32163756 | PRJNA512103_P_NODE_25118_length_188_cov_1.057554_g24706_i0 | PRJNA512103 | 25118 | 188 | 1.057554 | 1.98820152 | Hebei betayadokarivirus | 3372915 | Viruses | Viruses | 48.1 | 2.25e-4 | NR | XHZ00044.1 | 3372915 | g24706 | i0 | 37 | 1.72340425531915 | 54 | 34 | 86.2 | 0 | 170 | 9 | 926 | 979 | XHZ00044.1 MAG: RNA-dependent RNA polymerase [Hebei betayadokarivirus] | diamond | 324 | 48.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Yadokarivirales | Yadokariviridae | Betayadokarivirus | Hebei betayadokarivirus |
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);;