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

29 rows where analysis = "blastn", bioproject = "PRJNA597223" 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
568828	568828	PRJNA597223_P_NODE_14761_length_438_cov_5.210918_g12971_i0	PRJNA597223	14761	438	5.210918	22.82382084	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	745	0	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g12971	i0	97.494	2.00456621004566	439	5	99	3	1	437	437	3	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	878	745	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
569118	569118	PRJNA597223_P_NODE_42221_length_218_cov_6.344262_g40375_i0	PRJNA597223	42221	218	6.344262	13.83049116	Chemarfal virus 258	3063149	Viruses	Viruses	363	7.84e-96	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g40375	i0	97.63	1.93577981651376	211	5	97	0	6	216	1176	966	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	422	363	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
1844408	1844408	PRJNA597223_P_NODE_10582_length_531_cov_3.745968_g8905_i0	PRJNA597223	10582	531	3.745968	19.89109008	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	749	0	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g8905	i0	95.699	3.9039548022598898	465	20	88	0	1	465	465	1	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	2073	749	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
1844548	1844548	PRJNA597223_P_NODE_24522_length_316_cov_4.163701_g22678_i0	PRJNA597223	24522	316	4.163701	13.15729516	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	540	5.18e-149	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g22678	i0	98.065	1.9620253164557	310	6	98	0	6	315	2717	3026	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	620	540	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
3120022	3120022	PRJNA597223_P_NODE_33843_length_253_cov_1.908257_g31997_i0	PRJNA597223	33843	253	1.908257	4.82789021	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	457	4.16e-124	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g31997	i0	99.209	1	253	2	100	0	1	253	4228	4480	Malassezia restricta virus MrV40L, complete genome	blastn	253	457	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
3692306	3692306	PRJNA597223_P_NODE_76943_length_161_cov_2.341270_g75097_i0	PRJNA597223	76943	161	2.34127	3.7694447	Totivirus	11007	Viruses	Viruses	292	7.24e-75	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g75097	i0	99.379	2	161	1	100	0	1	161	819	979	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	322	292	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
4396581	4396581	PRJNA597223_P_NODE_29724_length_277_cov_2.975207_g27878_i0	PRJNA597223	29724	277	2.975207	8.24132339	Chemarfal virus 258	3063149	Viruses	Viruses	435	2.1700000000000003e-117	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g27878	i0	94.946	2	277	14	100	0	1	277	17	293	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	554	435	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
4396633	4396633	PRJNA597223_P_NODE_34244_length_251_cov_1.055556_g32398_i0	PRJNA597223	34244	251	1.055556	2.64944556	Chemarfal virus 258	3063149	Viruses	Viruses	459	1.1499999999999996e-124	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g32398	i0	99.602	1	251	1	100	0	1	251	1356	1606	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	251	459	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
4397095	4397095	PRJNA597223_P_NODE_75264_length_163_cov_2.539062_g73418_i0	PRJNA597223	75264	163	2.539062	4.13867106	Malassezia restricta associated totivirus 2	3048758	Viruses	Viruses	291	2.64e-74	NTclustered	gi\|2512878154\|emb\|OX637980.1\|	3048758	g73418	i0	98.773	2	163	2	100	0	1	163	1246	1408	Malassezia restricta associated totivirus 2 CP gene for capsid protein	blastn	326	291	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia restricta associated totivirus 2
6947469	6947469	PRJNA597223_P_NODE_51666_length_194_cov_1.515723_g49820_i0	PRJNA597223	51666	194	1.515723	2.94050262	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	331	1.92e-86	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g49820	i0	97.436	1.00515463917526	195	3	99	1	2	194	1193	1387	Malassezia restricta virus MrV40L, complete genome	blastn	195	331	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
8222108	8222108	PRJNA597223_P_NODE_22827_length_332_cov_1.996633_g20985_i0	PRJNA597223	22827	332	1.996633	6.62882156	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	592	1.49e-164	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g20985	i0	98.795	2	332	4	100	0	1	332	4104	3773	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	664	592	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
8222867	8222867	PRJNA597223_P_NODE_9627_length_560_cov_1.841905_g8004_i0	PRJNA597223	9627	560	1.841905	10.314668	Chemarfal virus 260	3063286	Viruses	Viruses	520	1.2599999999999999e-142	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g8004	i0	96.226	3.25535714285714	318	11	57	1	4	320	1114	1431	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	1823	520	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
10773086	10773086	PRJNA597223_P_NODE_10009_length_548_cov_2.335283_g8361_i0	PRJNA597223	10009	548	2.335283	12.79735084	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	977	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g8361	i0	98.905	1	548	4	99	2	1	547	2127	1581	Malassezia restricta virus MrV40L, complete genome	blastn	548	977	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
10773872	10773872	PRJNA597223_P_NODE_8289_length_606_cov_1.854641_g6760_i0	PRJNA597223	8289	606	1.854641	11.23912446	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	1092	0	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g6760	i0	99.337	1.99009900990099	603	4	99	0	1	603	3651	3049	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	1206	1092	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
12048149	12048149	PRJNA597223_P_NODE_33770_length_253_cov_2.899083_g31924_i0	PRJNA597223	33770	253	2.899083	7.33467999	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	241	4.56e-59	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g31924	i0	93.333	0.976284584980237	165	7	96	3	1	161	787	623	Malassezia restricta virus MrV40S, complete genome	blastn	247	241	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S
12048624	12048624	PRJNA597223_P_NODE_7430_length_639_cov_2.243377_g5954_i0	PRJNA597223	7430	639	2.243377	14.33517903	Chemarfal virus 260	3063286	Viruses	Viruses	1070	0	NTclustered	gi\|2626079958\|gb\|OR270550.1\|	3063286	g5954	i0	96.87	1	639	20	100	0	1	639	102	740	MAG: Chemarfal virus 260 isolate ML188 genomic sequence	blastn	639	1070	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 260
17146426	17146426	PRJNA597223_P_NODE_10554_length_532_cov_2.529175_g8879_i0	PRJNA597223	10554	532	2.529175	13.455211	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	719	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g8879	i0	99.494	1.63157894736842	395	2	100	0	138	532	2854	2460	Malassezia restricta virus MrV40L, complete genome	blastn	868	719	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
17146478	17146478	PRJNA597223_P_NODE_15674_length_422_cov_3.439276_g13874_i0	PRJNA597223	15674	422	3.439276	14.51374472	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	667	0	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g13874	i0	96.758	1.90047393364929	401	12	95	1	1	400	5122	4722	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	802	667	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
17146501	17146501	PRJNA597223_P_NODE_18294_length_383_cov_2.252874_g16470_i0	PRJNA597223	18294	383	2.252874	8.62850742	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	693	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g16470	i0	99.475	1.18276762402089	381	2	99	0	3	383	1	381	Malassezia restricta virus MrV40L, complete genome	blastn	453	693	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
18420978	18420978	PRJNA597223_P_NODE_36955_length_238_cov_2.458128_g35109_i0	PRJNA597223	36955	238	2.458128	5.85034464	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	385	1.86e-102	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g35109	i0	95.798	2	238	10	100	0	1	238	4310	4547	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	476	385	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
18421222	18421222	PRJNA597223_P_NODE_55775_length_188_cov_3.470588_g53929_i0	PRJNA597223	55775	188	3.470588	6.52470544	Malassezia restricta virus MrV40S	2727864	Viruses	Viruses	159	9.229999999999999e-35	NTclustered	gi\|1832308146\|gb\|MN603498.1\|	2727864	g53929	i0	93.519	1.01063829787234	108	6	100	1	1	107	787	680	Malassezia restricta virus MrV40S, complete genome	blastn	190	159	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40S
18421575	18421575	PRJNA597223_P_NODE_875_length_1704_cov_3.831636_g531_i0	PRJNA597223	875	1704	3.831636	65.29107744	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	2863	0	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g531	i0	96.831	2.13086854460094	1704	51	100	1	1	1704	451	2151	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	3631	2863	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
19695675	19695675	PRJNA597223_P_NODE_53176_length_191_cov_1.641026_g51330_i0	PRJNA597223	53176	191	1.641026	3.13435966	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	342	8.699999999999999e-90	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g51330	i0	98.953	2	191	2	100	0	1	191	4733	4543	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	382	342	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
20971047	20971047	PRJNA597223_P_NODE_10417_length_536_cov_2.191617_g8748_i0	PRJNA597223	10417	536	2.191617	11.74706712	Chemarfal virus 258	3063149	Viruses	Viruses	918	0	NTclustered	gi\|2626079799\|gb\|OR270470.1\|	3063149	g8748	i0	97.575	1	536	13	100	0	1	536	1627	2162	MAG: Chemarfal virus 258 isolate ML188 genomic sequence	blastn	536	918	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales			Chemarfal virus 258
20971639	20971639	PRJNA597223_P_NODE_67997_length_174_cov_1.366906_g66151_i0	PRJNA597223	67997	174	1.366906	2.37841644	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	283	4.769999999999999e-72	NTclustered	gi\|2512878147\|emb\|OX637976.1\|	3048756	g66151	i0	95.977	1	174	7	100	0	1	174	2141	1968	Malassezia globosa associated totivirus 1 RdRp gene for RNA-dependent RNA polymerase	blastn	174	283	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
20971652	20971652	PRJNA597223_P_NODE_69217_length_172_cov_1.518248_g67371_i0	PRJNA597223	69217	172	1.518248	2.61138656	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	311	2.16e-80	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g67371	i0	99.415	0.994186046511628	171	1	99	0	2	172	2255	2425	Malassezia restricta virus MrV40L, complete genome	blastn	171	311	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
20971687	20971687	PRJNA597223_P_NODE_717_length_1854_cov_5.831776_g426_i0	PRJNA597223	717	1854	5.831776	108.12112704	Drosophila melanogaster totivirus SW-2009a	663282	Viruses	Viruses	2806	0	NTclustered	gi\|268053723\|ref\|NC_013499.1\|	663282	g426	i0	98.733	2.92340884573894	1579	20	99	0	8	1586	6779	5201	Drosophila melanogaster totivirus SW-2009a, complete genome	blastn	5420	2806	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Drosophila melanogaster totivirus SW-2009a
20971803	20971803	PRJNA597223_P_NODE_8177_length_610_cov_3.401739_g6653_i0	PRJNA597223	8177	610	3.401739	20.7506079	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	1088	0	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g6653	i0	98.852	1	610	7	100	0	1	610	3624	4233	Malassezia restricta virus MrV40L, complete genome	blastn	610	1088	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
22246561	22246561	PRJNA597223_P_NODE_72998_length_166_cov_2.473282_g71152_i0	PRJNA597223	72998	166	2.473282	4.10564812	Chrocurosk virus	3129322	Viruses	Viruses	152	1.33e-32	NTclustered	gi\|2717317280\|gb\|PP171770.1\|	3129322	g71152	i0	84.516	268.813253012048	155	22	92	2	12	164	1896	1742	MAG: Chrocurosk virus isolate CC1A_k141_129357 genomic sequence	blastn	44623	152	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Chrocurosk virus

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