contig_metadata
21 rows where bioproject = "PRJNA169559" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365177 | 365177 | PRJNA169559_P_NODE_6861_length_648_cov_2.416801_g5354_i0 | PRJNA169559 | 6861 | 648 | 2.416801 | 15.66087048 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 861 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g5354 | i0 | 96.408 | 2.87962962962963 | 529 | 8 | 94 | 1 | 1 | 518 | 3818 | 4346 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1866 | 861 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 1639683 | 1639683 | PRJNA169559_P_NODE_1742_length_1256_cov_2.796251_g1029_i0 | PRJNA169559 | 1742 | 1256 | 2.796251 | 35.12091256 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1323 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g1029 | i0 | 95.385 | 2.9593949044586 | 845 | 16 | 97 | 2 | 435 | 1256 | 7523 | 6679 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 3717 | 1323 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 2915687 | 2915687 | PRJNA169559_P_NODE_31423_length_259_cov_1.182609_g29347_i0 | PRJNA169559 | 31423 | 259 | 1.182609 | 3.06295731 | Marine virus AFVG_250M599 | 2693786 | Viruses | Viruses | 52.8 | 0.024 | NTclustered | gi|1789810420|gb|MN694776.1| | 2693786 | g29347 | i0 | 100 | 0.108108108108108 | 28 | 0 | 11 | 0 | 216 | 243 | 32187 | 32160 | MAG: Marine virus AFVG_250M599, complete genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Marine virus AFVG_250M599 | |||||
| 9293282 | 9293282 | PRJNA169559_P_NODE_5788_length_706_cov_2.146233_g4382_i0 | PRJNA169559 | 5788 | 706 | 2.146233 | 15.15240498 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 444 | 9.96e-120 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g4382 | i0 | 99.187 | 2.6685552407932 | 246 | 2 | 87 | 0 | 1 | 246 | 3787 | 4032 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1884 | 444 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 10568889 | 10568889 | PRJNA169559_P_NODE_1129_length_1528_cov_3.150100_g600_i0 | PRJNA169559 | 1129 | 1528 | 3.1501 | 48.133528 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 2422 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g600 | i0 | 95.051 | 3.05759162303665 | 1556 | 49 | 100 | 5 | 1 | 1528 | 4412 | 5967 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 4672 | 2422 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 11843453 | 11843453 | PRJNA169559_P_NODE_1410_length_1380_cov_2.569208_g804_i0 | PRJNA169559 | 1410 | 1380 | 2.569208 | 35.4550704 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1070 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g804 | i0 | 96.347 | 2.75217391304348 | 657 | 12 | 91 | 1 | 204 | 848 | 6867 | 7523 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 3798 | 1070 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 13118774 | 13118774 | PRJNA169559_P_NODE_2771_length_994_cov_3.017617_g1802_i0 | PRJNA169559 | 2771 | 994 | 3.017617 | 29.99511298 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 1105 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g1802 | i0 | 97.959 | 2.88229376257545 | 637 | 13 | 96 | 0 | 61 | 697 | 6578 | 5942 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 2865 | 1105 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 15667679 | 15667679 | PRJNA169559_P_NODE_12713_length_471_cov_1.800905_g10836_i0 | PRJNA169559 | 12713 | 471 | 1.800905 | 8.48226255 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 518 | 3.7599999999999996e-142 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g10836 | i0 | 97.368 | 2.56050955414013 | 304 | 8 | 85 | 0 | 168 | 471 | 2255 | 1952 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1206 | 518 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 18216698 | 18216698 | PRJNA169559_P_NODE_26955_length_283_cov_4.826772_g24879_i0 | PRJNA169559 | 26955 | 283 | 4.826772 | 13.65976476 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 52.8 | 0.026 | NTclustered | gi|2057081614|tpg|BK037934.1| | 2832643 | g24879 | i0 | 100 | 0.0989399293286219 | 28 | 0 | 10 | 0 | 217 | 244 | 39480 | 39453 | MAG TPA_asm: Caudoviricetes sp. isolate ctZGZ8, partial genome | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 18216773 | 18216773 | PRJNA169559_P_NODE_40875_length_233_cov_1.284314_g38798_i0 | PRJNA169559 | 40875 | 233 | 1.284314 | 2.99245162 | Clostridioides phage pCD1602_4 | 2801346 | Viruses | Viruses | 52.8 | 0.021 | NTclustered | gi|1981819503|gb|CP069348.1| | 2801346 | g38798 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 178 | 205 | 66800 | 66773 | Clostridioides phage pCD1602_4, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Clostridioides phage pCD1602_4 | |||||
| 19491181 | 19491181 | PRJNA169559_P_NODE_8676_length_577_cov_2.835766_g7016_i0 | PRJNA169559 | 8676 | 577 | 2.835766 | 16.36236982 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 874 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g7016 | i0 | 93.75 | 3.07798960138648 | 592 | 22 | 100 | 1 | 1 | 577 | 2453 | 3044 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1776 | 874 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 20766720 | 20766720 | PRJNA169559_P_NODE_6077_length_689_cov_2.137879_g4646_i0 | PRJNA169559 | 6077 | 689 | 2.137879 | 14.72998631 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 736 | 0 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g4646 | i0 | 97.882 | 2.72133526850508 | 425 | 9 | 90 | 0 | 160 | 584 | 3276 | 3700 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 1875 | 736 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 22041760 | 22041760 | PRJNA169559_P_NODE_47638_length_174_cov_1.337931_g45561_i0 | PRJNA169559 | 47638 | 174 | 1.337931 | 2.32799994 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 303 | 3.66e-78 | NTclustered | gi|1990739381|tpg|BK011179.1| | 2304617 | g45561 | i0 | 98.266 | 3 | 173 | 3 | 99 | 0 | 1 | 173 | 784 | 612 | TPA_asm: Zebrafish picornavirus 1 strain NCSZCF/ZfPV/2015/North Carolina/USA, complete genome | blastn | 522 | 303 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 26630790 | 26630790 | PRJNA169559_P_NODE_25301_length_299_cov_1.385185_g23225_i0 | PRJNA169559 | 25301 | 299 | 1.3851850000000001 | 4.14170315 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 57.8 | 3.58e-7 | NR | YP_010803269.1 | 3060017 | g23225 | i0 | 62.5 | 0.40133779264214 | 40 | 15 | 40.1 | 0 | 3 | 122 | 153 | 192 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 120 | 57.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 27231938 | 27231938 | PRJNA169559_P_NODE_3403_length_903_cov_2.027460_g2326_i0 | PRJNA169559 | 3403 | 903 | 2.02746 | 18.3079638 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 266 | 6.31e-83 | NR | YP_010803269.1 | 3060017 | g2326 | i0 | 52.9 | 0.803986710963455 | 242 | 114 | 80.4 | 0 | 899 | 174 | 173 | 414 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 726 | 266 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense | ||
| 30800498 | 30800498 | PRJNA169559_P_NODE_22074_length_342_cov_2.460064_g20009_i0 | PRJNA169559 | 22074 | 342 | 2.460064 | 8.41341888 | uncultured virus | 340016 | Viruses | Viruses | 102 | 1.43e-22 | NR | CAH6420218.1 | 340016 | g20009 | i0 | 40.7 | 1.95614035087719 | 113 | 67 | 99.1 | 0 | 339 | 1 | 92 | 204 | CAH6420218.1 Hypothetical protein MVR_LOCUS69 [uncultured virus] | diamond | 669 | 102 | 1 | Viruses | uncultured virus | ||||||||
| 30958696 | 30958696 | PRJNA169559_P_NODE_16754_length_414_cov_2.329870_g14776_i0 | PRJNA169559 | 16754 | 414 | 2.32987 | 9.6456618 | Marseillevirus LCMAC1 | 2506602 | Viruses | Viruses | 52 | 2.07e-5 | NR | QBK85646.1 | 2506602 | g14776 | i0 | 35.4 | 0.471014492753623 | 65 | 42 | 47.1 | 0 | 205 | 399 | 36 | 100 | QBK85646.1 MAG: hypothetical protein LCMAC101_02410 [Marseillevirus LCMAC101] | diamond | 195 | 52 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Pimascovirales | Marseilleviridae | Marseillevirus LCMAC101 | |||
| 31053673 | 31053673 | PRJNA169559_P_NODE_47775_length_171_cov_2.654930_g45698_i0 | PRJNA169559 | 47775 | 171 | 2.65493 | 4.5399303 | uncultured virus | 340016 | Viruses | Viruses | 44.7 | 0.00308 | NR | CAH6419193.1 | 340016 | g45698 | i0 | 42 | 1.75438596491228 | 50 | 29 | 87.7 | 0 | 19 | 168 | 797 | 846 | CAH6419193.1 2-5 RNA ligase superfamily [uncultured virus] | diamond | 300 | 44.7 | 1 | Viruses | uncultured virus | ||||||||
| 31559483 | 31559483 | PRJNA169559_P_NODE_5716_length_710_cov_9.505140_g4319_i0 | PRJNA169559 | 5716 | 710 | 9.50514 | 67.486494 | Edafosvirus sp. | 2487765 | Viruses | Viruses | 70.9 | 5.4e-10 | NR | AYV78747.1 | 2487765 | g4319 | i0 | 28.7 | 0.633802816901408 | 150 | 77 | 59.2 | 5 | 165 | 584 | 1013 | 1142 | AYV78747.1 MAG: hypothetical protein Edafosvirus29_11 [Edafosvirus sp.] | diamond | 450 | 70.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Edafosvirus sp. | |||
| 31622483 | 31622483 | PRJNA169559_P_NODE_42236_length_229_cov_1.975000_g40159_i0 | PRJNA169559 | 42236 | 229 | 1.975 | 4.52275 | Emiliania huxleyi virus 2 | 181208 | Viruses | Viruses | 46.6 | 0.00118 | NR | AET98133.1 | 181210 | g40159 | i0 | 44.2 | 0.563318777292576 | 43 | 23 | 56.3 | 1 | 100 | 228 | 45 | 86 | AET98133.1 hypothetical protein EPVG_00246 [Emiliania huxleyi virus 201] | diamond | 129 | 46.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Algavirales | Phycodnaviridae | Coccolithovirus | Emiliania huxleyi virus 201 | ||
| 32128924 | 32128924 | PRJNA169559_P_NODE_48238_length_162_cov_2.120301_g46161_i0 | PRJNA169559 | 48238 | 162 | 2.120301 | 3.43488762 | Fadolivirus algeromassiliense | 3060017 | Viruses | Viruses | 47 | 3.87e-4 | NR | YP_010803269.1 | 3060017 | g46161 | i0 | 52.4 | 0.777777777777778 | 42 | 20 | 77.8 | 0 | 160 | 35 | 373 | 414 | YP_010803269.1 ornithine decaroboxylase [Fadolivirus algeromassiliense] | diamond | 126 | 47 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Fadolivirus | Fadolivirus algeromassiliense |
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);;