metadata: contig_metadata: 28 rows where bioproject = "PRJNA704949" and tax

28 rows where bioproject = "PRJNA704949" and tax_kingdom = "Orthornavirae"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1973147	1973147	PRJNA704949_P_NODE_37362_length_1268_cov_7.850697_g27610_i0	PRJNA704949	37362	1268	7.850697	99.54683796	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	2242	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g27610	i0	98.58	1	1268	18	100	0	1	1268	2739	1472	Malassezia restricta virus MrV40L, complete genome	blastn	1268	2242	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
2462677	2462677	PRJNA704949_P_NODE_1748642_length_181_cov_1.575758_g1733303_i0	PRJNA704949	1748642	181	1.575758	2.85212198	Vesiculovirus	11271	Viruses	Viruses	320	3.82e-83	NTclustered	gi\|61832\|emb\|V01213.1\|	11276	g1733303	i0	99.432	97.2044198895028	176	1	97	0	6	181	256	431	Vesicular stomatitis virus gene fragment encoding the G protein	blastn	17594	320	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Vesiculovirus	Vesicular stomatitis virus
5019248	5019248	PRJNA704949_P_NODE_95364_length_800_cov_4.909454_g83061_i0	PRJNA704949	95364	800	4.909454	39.275632	root	1	Root_unresolved	Root_unresolved	1445	0	NTclustered	gi\|2649349941\|gb\|OR995580.1\|	11276	g83061	i0	100	98.79625	782	0	98	0	19	800	3498	4279	Mutant Vesicular stomatitis virus clone recombinant VSVdM51-RBD, complete genome	blastn	79037	1445	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Rhabdoviridae	Vesiculovirus	Vesicular stomatitis virus
8343837	8343837	PRJNA704949_P_NODE_1581947_length_194_cov_1.331034_g1566608_i0	PRJNA704949	1581947	194	1.331034	2.58220596	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	353	4.1e-93	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g1566608	i0	99.485	1.70103092783505	194	1	100	0	1	194	3492	3299	Malassezia restricta virus MrV40L, complete genome	blastn	330	353	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
8838828	8838828	PRJNA704949_P_NODE_1241107_length_227_cov_1.752809_g1225770_i0	PRJNA704949	1241107	227	1.752809	3.97887643	Viruses	10239	Viruses	Viruses	69.4	2.01e-7	NTclustered	gi\|2557652486\|emb\|OY682391.1\|	2697049	g1225770	i0	95.455	16.8370044052863	44	0	19	2	1	44	11279	11238	Severe acute respiratory syndrome coronavirus 2 genome assembly, complete genome: monopartite	blastn	3822	69.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Nidovirales	Coronaviridae	Betacoronavirus	Betacoronavirus pandemicum
12180013	12180013	PRJNA704949_P_NODE_772610_length_304_cov_1.819608_g757279_i0	PRJNA704949	772610	304	1.819608	5.53160832	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	52.8	0.028	NTclustered	gi\|2196304047\|gb\|MZ679036.1\|	3003959	g757279	i0	94.286	0.115131578947368	35	1	12	1	143	177	4155	4188	MAG: Picornavirales sp. isolate s56-k141_864870 putative polyprotein gene, complete cds	blastn	35	52.8	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
12181119	12181119	PRJNA704949_P_NODE_905270_length_276_cov_4.528634_g889936_i0	PRJNA704949	905270	276	4.528634	12.49902984	Plasmopara viticola lesion associated ourmia-like virus 25	2686493	Viruses	Viruses	100	2.66e-22	NR	YP_010800225.1	2686493	g889936	i0	71.6	0.728260869565217	67	19	72.8	0	60	260	3	69	YP_010800225.1 RNA dependent RNA polymerase [Plasmopara viticola lesion associated ourmia-like virus 25]	diamond	201	100	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae	Magoulivirus	Magoulivirus fiplasmoparae
14725031	14725031	PRJNA704949_P_NODE_273672_length_511_cov_3.461039_g259002_i0	PRJNA704949	273672	511	3.461039	17.68590929	Ilarvirus PNRSV	3429931	Viruses	Viruses	939	0	NTclustered	gi\|1530829376\|gb\|MH427285.1\|	37733	g259002	i0	99.804	99.9804305283757	511	1	100	0	1	511	337	847	Prunus necrotic ringspot virus isolate PNRSV-RNA3-SA movement protein and coat protein genes, complete cds	blastn	51090	939	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Ilarvirus	Ilarvirus PNRSV
19816065	19816065	PRJNA704949_P_NODE_1396996_length_210_cov_2.260870_g1381658_i0	PRJNA704949	1396996	210	2.26087	4.747827	Tobamovirus rapae	3432887	Viruses	Viruses	383	5.75e-102	NTclustered	gi\|691192970\|gb\|KM067150.1\|	29272	g1381658	i0	99.524	17.947619047619	210	1	100	0	1	210	440	231	Turnip vein-clearing virus isolate Minnesota movement protein (MP) and coat protein (CP) genes, partial cds	blastn	3769	383	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus rapae
19824876	19824876	PRJNA704949_P_NODE_460116_length_401_cov_3.642045_g444905_i0	PRJNA704949	460116	401	3.642045	14.60460045	Totiviridae sp.	1955172	Viruses	Viruses	243	2.12e-59	NTclustered	gi\|2396038768\|gb\|ON812661.1\|	1955172	g444905	i0	80.984	2.40648379052369	305	58	76	0	96	400	4520	4216	MAG: Totiviridae sp. isolate TIGMIC_4, complete genome	blastn	965	243	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
21091613	21091613	PRJNA704949_P_NODE_1390917_length_211_cov_1.401235_g1375579_i0	PRJNA704949	1390917	211	1.401235	2.95660585	Chemarfal virus 260	3063286	Viruses	Viruses	331	2.13e-86	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g1375579	i0	96.078	3.75355450236967	204	6	97	2	7	210	146	347	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	792	331	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
22374035	22374035	PRJNA704949_P_NODE_322738_length_475_cov_1.708920_g307845_i0	PRJNA704949	322738	475	1.70892	8.11737	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	850	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g307845	i0	98.947	1.49263157894737	475	5	100	0	1	475	3191	2717	Malassezia restricta virus MrV40L, complete genome	blastn	709	850	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
23649709	23649709	PRJNA704949_P_NODE_31699_length_1403_cov_2.081979_g22473_i0	PRJNA704949	31699	1403	2.081979	29.21016537	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	2023	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g22473	i0	98.517	1.23093371347113	1146	17	99	0	258	1403	333	1478	Malassezia restricta virus MrV40L, complete genome	blastn	1727	2023	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
26988224	26988224	PRJNA704949_P_NODE_42682_length_1176_cov_2.966282_g32547_i0	PRJNA704949	42682	1176	2.966282	34.88347632	Totivirus sp.	2776824	Viruses	Viruses	501	8.259999999999999e-175	NR	QOQ37361.1	2776824	g32547	i0	72.6	0.836734693877551	328	90	83.7	0	1161	178	21	348	QOQ37361.1 capsid protein, partial [Totivirus sp.]	diamond	984	501	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
27156861	27156861	PRJNA704949_P_NODE_1711002_length_184_cov_1.533333_g1695663_i0	PRJNA704949	1711002	184	1.533333	2.82133272	Totivirus	11007	Viruses	Viruses	92.4	4.01e-20	NR	QOQ37362.1	2776824	g1695663	i0	73.6	1.71195652173913	53	14	86.4	0	166	8	111	163	QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.]	diamond	315	92.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
27209620	27209620	PRJNA704949_P_NODE_647602_length_336_cov_1.993031_g632276_i0	PRJNA704949	647602	336	1.993031	6.69658416	Erysiphe necator associated totivirus 8	2737098	Viruses	Viruses	75.9	2.7e-13	NR	WAK77400.1	2737098	g632276	i0	48	0.669642857142857	75	39	67	0	336	112	723	797	WAK77400.1 MAG: polyprotein [Erysiphe necator associated totivirus 8]	diamond	225	75.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Erysiphe necator associated totivirus 8
27620306	27620306	PRJNA704949_P_NODE_1808504_length_177_cov_1.218750_g1793165_i0	PRJNA704949	1808504	177	1.21875	2.1571875	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	58.2	5.8e-8	NR	UNY41988.1	3003959	g1793165	i0	59.3	0.915254237288136	54	16	89.8	2	162	4	157	205	UNY41988.1 MAG: polyprotein [Picornavirales sp.]	diamond	162	58.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
27841297	27841297	PRJNA704949_P_NODE_614784_length_346_cov_1.400673_g599460_i0	PRJNA704949	614784	346	1.400673	4.84632858	Scheffersomyces segobiensis virus L	1300323	Viruses	Viruses	101	3.54e-22	NR	YP_009507830.1	1300323	g599460	i0	46.2	1.83815028901734	106	56	91	1	27	341	226	331	YP_009507830.1 capsid [Scheffersomyces segobiensis virus L]	diamond	636	101	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus roku
28125358	28125358	PRJNA704949_P_NODE_1679025_length_186_cov_2.379562_g1663686_i0	PRJNA704949	1679025	186	2.379562	4.42598532	brine shrimp partiti-like virus 3	2900390	Viruses	Viruses	42.7	0.0179	NR	UNI73913.1	2900390	g1663686	i0	43.8	0.774193548387097	48	25	77.4	1	165	22	257	302	UNI73913.1 MAG: hypothetical protein [brine shrimp partiti-like virus 3]	diamond	144	42.7	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		brine shrimp partiti-like virus 3
28662004	28662004	PRJNA704949_P_NODE_1012987_length_258_cov_1.755981_g997652_i0	PRJNA704949	1012987	258	1.755981	4.53043098	Botourmiaviridae sp.	2808997	Viruses	Viruses	154	7.659999999999998e-42	NR	XFO98461.1	2808997	g997652	i0	82.1	0.976744186046512	84	15	97.7	0	257	6	433	516	XFO98461.1 RNA-dependent RNA polymerase [Botourmiaviridae sp.]	diamond	252	154	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
29482845	29482845	PRJNA704949_P_NODE_1890970_length_171_cov_1.688525_g1875631_i0	PRJNA704949	1890970	171	1.688525	2.88737775	Geotrichum candidum totivirus 4	3075233	Viruses	Viruses	44.7	0.00293	NR	WMZ16835.1	3075233	g1875631	i0	41.1	0.982456140350877	56	32	96.5	1	169	5	68	123	WMZ16835.1 RNA-dependent RNA polymerase [Geotrichum candidum totivirus 4]	diamond	168	44.7	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Geotrichum candidum totivirus 4
30525722	30525722	PRJNA704949_P_NODE_928413_length_272_cov_2.246637_g913079_i0	PRJNA704949	928413	272	2.246637	6.11085264	Malassezia restricta associated totivirus 1	3048757	Viruses	Viruses	103	1.5699999999999994e-23	NR	CAI9858976.1	3048757	g913079	i0	60.7	0.981617647058823	89	35	98.2	0	269	3	166	254	CAI9858976.1 polyprotein, partial [Malassezia restricta associated totivirus 1]	diamond	267	103	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 1
30694250	30694250	PRJNA704949_P_NODE_1206593_length_231_cov_1.972527_g1191256_i0	PRJNA704949	1206593	231	1.972527	4.55653737	Ghabrivirales	2732540	Viruses	Viruses	70.5	5.27e-12	NR	WAK77686.1	1955172	g1191256	i0	53.6	3.62337662337662	69	29	85.7	2	214	17	479	547	WAK77686.1 MAG: capsid protein [Totiviridae sp.]	diamond	837	70.9	0.994358251057828	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
30883898	30883898	PRJNA704949_P_NODE_2185974_length_160_cov_2.765766_g2170635_i0	PRJNA704949	2185974	160	2.765766	4.4252256	Totivirus	11007	Viruses	Viruses	80.1	7.52e-16	NR	QOQ37362.1	2776824	g2170635	i0	73.6	1.9875	53	14	99.4	0	159	1	187	239	QOQ37362.1 RNA-dependent RNA polymerase, partial [Totivirus sp.]	diamond	318	80.9	0.990111248454882	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
31283761	31283761	PRJNA704949_P_NODE_1896695_length_171_cov_1.278689_g1881356_i0	PRJNA704949	1896695	171	1.278689	2.18655819	Totiviridae sp.	1955172	Viruses	Viruses	63.9	4.62e-10	NR	WAK77450.1	1955172	g1881356	i0	65.2	0.807017543859649	46	16	80.7	0	140	3	262	307	WAK77450.1 MAG: capsid protein [Totiviridae sp.]	diamond	138	63.9	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
31884832	31884832	PRJNA704949_P_NODE_29057_length_1484_cov_2.907317_g20164_i0	PRJNA704949	29057	1484	2.907317	43.14458428	Totiviridae sp.	1955172	Viruses	Viruses	306	9.26e-93	NR	WAK77569.1	1955172	g20164	i0	38.3	1.9588948787062	486	283	96.4	6	1436	6	1	478	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	2907	306	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
32612670	32612670	PRJNA704949_P_NODE_983480_length_263_cov_1.457944_g968145_i0	PRJNA704949	983480	263	1.457944	3.83439272	Cryphonectria hypovirus 2	40282	Viruses	Viruses	50.1	1.3e-4	NR	NP_613266.1	40282	g968145	i0	45.5	0.501901140684411	44	24	50.2	0	260	129	2683	2726	NP_613266.1 polyprotein [Cryphonectria hypovirus 2]	diamond	132	50.1	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Hypoviridae	Alphahypovirus	Alphahypovirus americanum
32706840	32706840	PRJNA704949_P_NODE_32380_length_1383_cov_5.925037_g23075_i0	PRJNA704949	32380	1383	5.925037	81.94326171	Totivirus sp.	2776824	Viruses	Viruses	454	7.579999999999998e-157	NR	QOQ37363.1	2776824	g23075	i0	88.8	0.544468546637744	251	28	54.4	0	456	1208	1	251	QOQ37363.1 RNA-dependent RNA polymerase, partial [Totivirus sp.]	diamond	753	454	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.

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