metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA631796" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA631796" and tax_phylum = "Duplornaviricota"

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
603334	603334	PRJNA631796_P_NODE_13681_length_193_cov_3.674242_g13403_i0	PRJNA631796	13681	193	3.674242	7.09128706	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	346	6.82e-91	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g13403	i0	98.964	1	193	2	100	0	1	193	4424	4232	Malassezia restricta virus MrV40L, complete genome	blastn	193	346	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
1879535	1879535	PRJNA631796_P_NODE_14102_length_183_cov_5.967213_g13824_i0	PRJNA631796	14102	183	5.967213	10.91999979	Chemarfal virus 260	3063286	Viruses	Viruses	278	2.36e-70	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g13824	i0	93.989	1	183	11	100	0	1	183	395	577	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	183	278	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
1879553	1879553	PRJNA631796_P_NODE_462_length_1066_cov_3.314428_g303_i0	PRJNA631796	462	1066	3.314428	35.33180248	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	1869	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g303	i0	98.311	1.33489681050657	1066	18	100	0	1	1066	145	1210	Malassezia restricta virus MrV40L, complete genome	blastn	1423	1869	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
3154263	3154263	PRJNA631796_P_NODE_2463_length_453_cov_1.770408_g2187_i0	PRJNA631796	2463	453	1.770408	8.01994824	Chemarfal virus 258	3063149	Viruses	Viruses	787	0	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g2187	i0	98.013	4.00662251655629	453	9	100	0	1	453	1320	1772	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	1815	787	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
3154267	3154267	PRJNA631796_P_NODE_3423_length_378_cov_2.397476_g3146_i0	PRJNA631796	3423	378	2.397476	9.06245928	Totivirus sp.	2776824	Viruses	Viruses	353	8.81e-93	NTclustered	gi\|1918615616\|gb\|MT949667.1\|	2776824	g3146	i0	83.554	0.997354497354497	377	62	99	0	1	377	1963	1587	Totivirus sp. isolate sequence_5835 genomic sequence	blastn	377	353	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
3154290	3154290	PRJNA631796_P_NODE_8063_length_239_cov_2.067416_g7785_i0	PRJNA631796	8063	239	2.067416	4.94112424	Chemarfal virus 260	3063286	Viruses	Viruses	403	5.15e-108	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g7785	i0	97.071	1	239	7	100	0	1	239	810	1048	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	239	403	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
3154297	3154297	PRJNA631796_P_NODE_923_length_768_cov_3.869873_g685_i0	PRJNA631796	923	768	3.869873	29.72062464	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	1347	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g685	i0	98.307	1.62109375	768	13	100	0	1	768	2786	3553	Malassezia restricta virus MrV40L, complete genome	blastn	1245	1347	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
4431135	4431135	PRJNA631796_P_NODE_8784_length_231_cov_0.958824_g8506_i0	PRJNA631796	8784	231	0.958824	2.21488344	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	344	3.04e-90	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g8506	i0	93.562	1.00865800865801	233	12	100	2	1	231	610	379	Malassezia restricta virus MrV40S, complete genome	blastn	233	344	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S
4431144	4431144	PRJNA631796_P_NODE_9464_length_223_cov_2.438272_g9186_i0	PRJNA631796	9464	223	2.438272	5.43734656	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	374	3.72e-99	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g9186	i0	96.861	1.47085201793722	223	7	100	0	1	223	2800	2578	Malassezia restricta virus MrV40L, complete genome	blastn	328	374	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
6255667	6255667	PRJNA631796_P_NODE_11405_length_207_cov_3.684932_g11127_i0	PRJNA631796	11405	207	3.684932	7.62780924	Totivirus	11007	Viruses	Viruses	383	5.65e-102	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g11127	i0	100	2	207	0	100	0	1	207	1035	829	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	414	383	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
6981845	6981845	PRJNA631796_P_NODE_2086_length_494_cov_4.482679_g1810_i0	PRJNA631796	2086	494	4.482679	22.14443426	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	896	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g1810	i0	99.393	1.87044534412955	494	3	100	0	1	494	2258	2751	Malassezia restricta virus MrV40L, complete genome	blastn	924	896	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
7529926	7529926	PRJNA631796_P_NODE_9206_length_226_cov_1.539394_g8928_i0	PRJNA631796	9206	226	1.539394	3.47903044	Totivirus	11007	Viruses	Viruses	172	1.48e-38	NTclustered	gi\|1918615616\|gb\|MT949667.1\|	2776824	g8928	i0	80.444	1.99115044247788	225	44	99	0	2	226	745	969	Totivirus sp. isolate sequence_5835 genomic sequence	blastn	450	172	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
9531863	9531863	PRJNA631796_P_NODE_11428_length_207_cov_2.034247_g11150_i0	PRJNA631796	11428	207	2.034247	4.21089129	Victorivirus sanjyuichi	3433239	Viruses	Viruses	311	2.71e-80	NTclustered	gi\|2020025951\|dbj\|LC596824.1\|	2801159	g11150	i0	93.72	2.48309178743961	207	13	100	0	1	207	3739	3945	Fusarium sambucinum victorivirus 1 Fs2242v genomic RNA, complete genome	blastn	514	311	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Pseudototiviridae	Victorivirus	Victorivirus sanjyuichi
9531914	9531914	PRJNA631796_P_NODE_5568_length_292_cov_1.909091_g5290_i0	PRJNA631796	5568	292	1.909091	5.57454572	Chemarfal virus 258	3063149	Viruses	Viruses	496	1.04e-135	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g5290	i0	97.26	1	292	8	100	0	1	292	2069	1778	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	292	496	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
9531921	9531921	PRJNA631796_P_NODE_6508_length_268_cov_3.845411_g6230_i0	PRJNA631796	6508	268	3.845411	10.30570148	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	484	2.0399999999999996e-132	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g6230	i0	99.254	1	268	2	100	0	1	268	4076	3809	Malassezia restricta virus MrV40L, complete genome	blastn	268	484	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
9531941	9531941	PRJNA631796_P_NODE_9328_length_225_cov_0.993902_g9050_i0	PRJNA631796	9328	225	0.993902	2.2362795	Totivirus nijyushichi	3432964	Viruses	Viruses	411	2.869999999999999e-110	NTclustered	gi\|1895833611\|gb\|MN812428.1\|	2766745	g9050	i0	99.556	1	225	1	100	0	1	225	409	185	Malassezia sympodialis mycovirus isolate MsMV1, complete genome	blastn	225	411	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus nijyushichi
10807579	10807579	PRJNA631796_P_NODE_13509_length_196_cov_2.718519_g13231_i0	PRJNA631796	13509	196	2.718519	5.32829724	Chemarfal virus 260	3063286	Viruses	Viruses	340	3.229999999999999e-89	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g13231	i0	97.959	1	196	4	100	0	1	196	326	131	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	196	340	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
12082830	12082830	PRJNA631796_P_NODE_2970_length_408_cov_2.504323_g2693_i0	PRJNA631796	2970	408	2.504323	10.21763784	Totivirus sp.	2776824	Viruses	Viruses	399	1.2099999999999998e-106	NTclustered	gi\|1918615616\|gb\|MT949667.1\|	2776824	g2693	i0	84.352	1.00245098039216	409	62	100	2	1	408	419	826	Totivirus sp. isolate sequence_5835 genomic sequence	blastn	409	399	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
12082853	12082853	PRJNA631796_P_NODE_7710_length_244_cov_2.622951_g7432_i0	PRJNA631796	7710	244	2.622951	6.40000044	Victorivirus sanjyuichi	3433239	Viruses	Viruses	385	1.91e-102	NTclustered	gi\|2020025951\|dbj\|LC596824.1\|	2801159	g7432	i0	95.082	1.97131147540984	244	12	100	0	1	244	4309	4552	Fusarium sambucinum victorivirus 1 Fs2242v genomic RNA, complete genome	blastn	481	385	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Pseudototiviridae	Victorivirus	Victorivirus sanjyuichi
13357581	13357581	PRJNA631796_P_NODE_5031_length_308_cov_2.319838_g4753_i0	PRJNA631796	5031	308	2.319838	7.14510104	Chemarfal virus 258	3063149	Viruses	Viruses	442	1.4599999999999994e-119	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g4753	i0	92.532	2	308	23	100	0	1	308	79	386	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	616	442	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
15906188	15906188	PRJNA631796_P_NODE_1093_length_698_cov_4.569859_g843_i0	PRJNA631796	1093	698	4.569859	31.89761582	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	1033	0	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g843	i0	96.057	4.02005730659026	634	25	91	0	1	634	634	1	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	2806	1033	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
15906241	15906241	PRJNA631796_P_NODE_6213_length_275_cov_2.873832_g5935_i0	PRJNA631796	6213	275	2.873832	7.903038	Malassezia restricta associated totivirus 1	3048757	Viruses	Viruses	226	1.41e-54	NTclustered	gi\|2512878151\|emb\|OX637978.1\|	3048757	g5935	i0	81.752	0.996363636363636	274	46	99	3	1	272	1465	1736	Malassezia restricta associated totivirus 1 CP gene for capsid protein	blastn	274	226	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 1
17181402	17181402	PRJNA631796_P_NODE_8074_length_239_cov_1.651685_g7796_i0	PRJNA631796	8074	239	1.651685	3.94752715	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	431	2.3599999999999996e-116	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g7796	i0	99.163	1	239	2	100	0	1	239	254	492	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	239	431	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
17729927	17729927	PRJNA631796_P_NODE_894_length_782_cov_2.766990_g659_i0	PRJNA631796	894	782	2.76699	21.6378618	Totivirus	11007	Viruses	Viruses	1336	0	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g659	i0	97.564	1.99488491048593	780	19	99	0	3	782	1701	922	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	1560	1341	0.996271439224459	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
18455459	18455459	PRJNA631796_P_NODE_2715_length_430_cov_3.718157_g2438_i0	PRJNA631796	2715	430	3.718157	15.9880751	Totiviridae sp.	1955172	Viruses	Viruses	244	6.38e-60	NTclustered	gi\|2396038768\|gb\|ON812661.1\|	1955172	g2438	i0	78.457	2.76511627906977	376	79	87	2	54	428	4524	4150	MAG: Totiviridae sp. isolate TIGMIC_4, complete genome	blastn	1189	244	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
18455496	18455496	PRJNA631796_P_NODE_8435_length_234_cov_5.225434_g8157_i0	PRJNA631796	8435	234	5.225434	12.22751556	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	422	1.39e-113	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g8157	i0	99.145	1	234	2	100	0	1	234	1683	1450	Malassezia restricta virus MrV40L, complete genome	blastn	234	422	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
21005793	21005793	PRJNA631796_P_NODE_3377_length_380_cov_3.968652_g3100_i0	PRJNA631796	3377	380	3.968652	15.0808776	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	660	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g3100	i0	98.148	0.994736842105263	378	7	99	0	3	380	3471	3848	Malassezia restricta virus MrV40L, complete genome	blastn	378	660	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
21005805	21005805	PRJNA631796_P_NODE_5557_length_292_cov_2.965368_g5279_i0	PRJNA631796	5557	292	2.965368	8.65887456	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	512	1.03e-140	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g5279	i0	98.288	1	292	5	100	0	1	292	2058	1767	Malassezia restricta virus MrV40L, complete genome	blastn	292	512	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
21005828	21005828	PRJNA631796_P_NODE_8877_length_230_cov_1.106509_g8599_i0	PRJNA631796	8877	230	1.106509	2.5449707	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	257	4.05e-64	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g8599	i0	87.013	1.00434782608696	231	26	99	2	1	229	1056	828	Malassezia restricta virus MrV40S, complete genome	blastn	231	257	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S

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