metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax

19 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_superkingdom = "Viruses"

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
1941300	1941300	PRJNA683902_S_NODE_28842_length_183_cov_2.054795_g28398_i0	PRJNA683902	28842	183	2.054795	3.76027485	Narnaviridae sp.	2583949	Viruses	Viruses	106	2.47e-25	NR	URG17005.1	2583949	g28398	i0	85.2	1	61	9	100	0	183	1	308	368	URG17005.1 MAG: RNA dependent RNA polymerase, partial [Narnaviridae sp.]	diamond	183	106	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Narnaviridae sp.
27504771	27504771	PRJNA683902_S_NODE_33023_length_168_cov_1.450382_g32579_i0	PRJNA683902	33023	168	1.450382	2.43664176	Deltaflexivirus	2169569	Viruses	Viruses	87.4	2.51e-18	NR	QKN22675.1	2743100	g32579	i0	69.1	3.98214285714286	55	17	98.2	0	4	168	638	692	QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3]	diamond	669	87.4	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 3
27788844	27788844	PRJNA683902_S_NODE_12964_length_351_cov_1.926752_g12520_i0	PRJNA683902	12964	351	1.926752	6.76289952	Viruses	10239	Viruses	Viruses	142	1.1199999999999999e-38	NR	QDH87740.1	2585031	g12520	i0	68.4	1.7008547008547	98	31	83.8	0	58	351	1	98	QDH87740.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.]	diamond	597	143	0.993006993006993	Viruses							Riboviria sp.
27851775	27851775	PRJNA683902_S_NODE_39064_length_152_cov_1.686957_g38620_i0	PRJNA683902	39064	152	1.686957	2.56417464	Viruses	10239	Viruses	Viruses	81.6	2.06e-16	NR	QKN22675.1	2743100	g38620	i0	76	1.97368421052632	50	12	98.7	0	150	1	1693	1742	QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3]	diamond	300	81.6	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 3
28124497	28124497	PRJNA683902_S_NODE_36865_length_157_cov_1.950000_g36421_i0	PRJNA683902	36865	157	1.95	3.0615	Fusarium deltaflexivirus 2	2973081	Viruses	Viruses	77	9.53e-15	NR	BDQ13824.1	2973081	g36421	i0	65.4	1.98726114649682	52	18	99.4	0	156	1	367	418	BDQ13824.1 unnamed protein product [Fusarium deltaflexivirus 2]	diamond	312	77	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Fusarium deltaflexivirus 2
28262176	28262176	PRJNA683902_S_NODE_27306_length_190_cov_3.294118_g26862_i0	PRJNA683902	27306	190	3.294118	6.2588242	Chuvivirus	2842604	Viruses	Viruses	103	6.11e-24	NR	WET19887.1	2842604	g26862	i0	75.4	1.92631578947368	61	15	96.3	0	188	6	290	350	WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1]	diamond	366	103	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Jingchuvirales	Chuviridae	Chuvivirus	Chuvivirus
28313975	28313975	PRJNA683902_S_NODE_19946_length_239_cov_1.108911_g19502_i0	PRJNA683902	19946	239	1.108911	2.65029729	Erysiphe necator associated flexivirus 1	2743098	Viruses	Viruses	105	2.97e-24	NR	QKN22686.1	2743098	g19502	i0	64.9	0.96652719665272	77	27	96.7	0	9	239	511	587	QKN22686.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 1]	diamond	231	105	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 1
28882134	28882134	PRJNA683902_S_NODE_10428_length_439_cov_2.587065_g9987_i0	PRJNA683902	10428	439	2.587065	11.35721535	Erysiphe necator associated narnavirus 48	2736405	Viruses	Viruses	159	7.259999999999998e-42	NR	QJT93780.1	2736405	g9987	i0	60.2	1.74259681093394	128	50	87.5	1	3	386	883	1009	QJT93780.1 RNA-dependent RNA polymerase [Erysiphe necator associated narnavirus 48]	diamond	765	159	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 48
28988819	28988819	PRJNA683902_S_NODE_28228_length_186_cov_1.436242_g27784_i0	PRJNA683902	28228	186	1.436242	2.67141012	Deltaflexivirus	2169569	Viruses	Viruses	52.8	5.06e-6	NR	QKN22686.1	2743098	g27784	i0	41.8	1.91935483870968	55	32	88.7	0	15	179	1036	1090	QKN22686.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 1]	diamond	357	53.1	0.994350282485876	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 1
29008876	29008876	PRJNA683902_S_NODE_7548_length_630_cov_3.853288_g7155_i0	PRJNA683902	7548	630	3.853288	24.2757144	Erysiphe necator umbra-like virus 2	2695368	Viruses	Viruses	149	3.43e-40	NR	QHD64839.1	2695368	g7155	i0	64	0.542857142857143	114	41	54.3	0	5	346	175	288	QHD64839.1 ORF-B [Erysiphe necator umbra-like virus 2]	diamond	342	149	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Umbravirus	Erysiphe necator umbra-like virus 2
29367524	29367524	PRJNA683902_S_NODE_14629_length_313_cov_4.721014_g14185_i0	PRJNA683902	14629	313	4.721014	14.77677382	Umbravirus	39734	Viruses	Viruses	136	1.99e-35	NR	QOE55597.1	2741667	g14185	i0	71.1	1.9073482428115	97	28	93	0	292	2	30	126	QOE55597.1 RNA-dependent RNA polymerase [Macrophomina phaseolina umbra-like virus 3]	diamond	597	136	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Umbravirus	Macrophomina phaseolina umbra-like virus 3
29387554	29387554	PRJNA683902_S_NODE_10249_length_449_cov_2.046117_g9810_i0	PRJNA683902	10249	449	2.046117	9.18706533	Pestalotiopsis deltaflexivirus 1	2816841	Viruses	Viruses	52	2.04e-4	NR	QTH80200.1	2816841	g9810	i0	35.1	0.648106904231626	97	61	64.1	2	289	2	706	801	QTH80200.1 MAG: RNA-dependent RNA polymerase [Pestalotiopsis deltaflexivirus 1]	diamond	291	52	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Deltaflexiviridae		Pestalotiopsis deltaflexivirus 1
29525441	29525441	PRJNA683902_S_NODE_32190_length_171_cov_1.029851_g31746_i0	PRJNA683902	32190	171	1.029851	1.76104521	Narnavirus	186767	Viruses	Viruses	78.6	3.4e-15	NR	WRK14128.1	3111966	g31746	i0	70.2	2	57	17	100	0	171	1	701	757	WRK14128.1 RNA-dependent RNA polymerase [Nigrospora sphaerica narnavirus 1]	diamond	342	79.3	0.991172761664565	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Nigrospora sphaerica narnavirus 1
29545159	29545159	PRJNA683902_S_NODE_16570_length_279_cov_2.797521_g16126_i0	PRJNA683902	16570	279	2.797521	7.80508359	Grapevine-associated tymo-like virus 2	2814378	Viruses	Viruses	144	9.209999999999999e-40	NR	QXN75448.1	2814378	g16126	i0	77.2	0.989247311827957	92	21	98.9	0	2	277	223	314	QXN75448.1 MAG: RNA-dependent RNA polymerase, partial [Grapevine-associated tymo-like virus 2]	diamond	276	144	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Grapevine-associated tymo-like virus 2
30966993	30966993	PRJNA683902_S_NODE_33314_length_167_cov_1.500000_g32870_i0	PRJNA683902	33314	167	1.5	2.505	Riboviria sp.	2585031	Viruses	Viruses	58.9	2.59e-8	NR	QDH88074.1	2585031	g32870	i0	53.3	1.81437125748503	45	21	80.8	0	136	2	250	294	QDH88074.1 MAG: RNA-dependent RNA polymerase, partial [Riboviria sp.]	diamond	303	58.9	1	Viruses							Riboviria sp.
31579289	31579289	PRJNA683902_S_NODE_18936_length_249_cov_3.117925_g18492_i0	PRJNA683902	18936	249	3.117925	7.76363325	Umbravirus	39734	Viruses	Viruses	115	2.31e-28	NR	QDH89942.1	2585031	g18492	i0	65.1	2	83	29	100	0	249	1	84	166	QDH89942.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.]	diamond	498	116	0.991379310344828	Viruses							Riboviria sp.
31946956	31946956	PRJNA683902_S_NODE_4057_length_1145_cov_4.355596_g3828_i0	PRJNA683902	4057	1145	4.355596	49.8715742	Macrophomina phaseolina umbra-like virus 1	2741665	Viruses	Viruses	280	3.28e-86	NR	QOE55594.1	2741665	g3828	i0	51.1	1.45152838427948	276	134	72.1	1	1140	316	234	509	QOE55594.1 RNA-dependent RNA polymerase [Macrophomina phaseolina umbra-like virus 1]	diamond	1662	280	1	Viruses	Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae	Umbravirus	Macrophomina phaseolina umbra-like virus 1
32232168	32232168	PRJNA683902_S_NODE_25458_length_200_cov_2.147239_g25014_i0	PRJNA683902	25458	200	2.147239	4.294478	Riboviria sp.	2585031	Viruses	Viruses	70.5	3.53e-12	NR	QDH89805.1	2585031	g25014	i0	53.1	2.85	64	30	96	0	9	200	757	820	QDH89805.1 MAG: hypothetical protein H1Bulk3034_000001 [Riboviria sp.]	diamond	570	70.5	1	Viruses							Riboviria sp.
32295552	32295552	PRJNA683902_S_NODE_20039_length_238_cov_1.572139_g19595_i0	PRJNA683902	20039	238	1.572139	3.74169082	Erysiphe necator associated flexivirus 3	2743100	Viruses	Viruses	113	5.660000000000001e-27	NR	QKN22675.1	2743100	g19595	i0	65.4	0.983193277310924	78	27	98.3	0	3	236	221	298	QKN22675.1 RNA-dependent RNA polymerase [Erysiphe necator associated flexivirus 3]	diamond	234	113	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales			Erysiphe necator associated flexivirus 3

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