metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA744060" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA744060" 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
6302558	6302558	PRJNA744060_P_NODE_5_length_4540_cov_13.313633_g3_i0	PRJNA744060	5	4540	13.313633	604.4389382	Totiviridae sp.	1955172	Viruses	Viruses	837	3.309999999999999e-285	NR	WAK77569.1	1955172	g3	i0	57.9	0.457929515418502	693	291	45.7	1	14	2089	1	693	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	2079	837	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
7576450	7576450	PRJNA744060_P_NODE_6_length_4540_cov_12.040519_g3_i1	PRJNA744060	6	4540	12.040519	546.6395626	Totiviridae sp.	1955172	Viruses	Viruses	837	3.309999999999999e-285	NR	WAK77569.1	1955172	g3	i1	57.9	0.457929515418502	693	291	45.7	1	4527	2452	1	693	WAK77569.1 MAG: capsid protein [Totiviridae sp.]	diamond	2079	837	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
27273942	27273942	PRJNA744060_P_NODE_1563_length_1168_cov_2.439269_g1387_i0	PRJNA744060	1563	1168	2.439269	28.49066192	Nanning Narna tick virus 3	2972237	Viruses	Viruses	68.9	1.6e-8	NR	UYL95385.1	2972237	g1387	i0	25.2	0.827054794520548	322	209	79.6	8	1152	223	317	618	UYL95385.1 MAG: hypothetical protein [Nanning Narna tick virus 3]	diamond	966	68.9	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Nanning Narna tick virus 3
27726501	27726501	PRJNA744060_P_NODE_3304_length_854_cov_3.142125_g3036_i0	PRJNA744060	3304	854	3.142125	26.8337475	Viruses	10239	Viruses	Viruses	119	4.52e-26	NR	XOD45381.1	3398652	g3036	i0	31.8	2.38524590163934	233	146	78.3	6	119	787	50	279	XOD45381.1 RdRp [Grapevine wood holobiome associated narna-like virus 16]	diamond	2037	120	0.991666666666667	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 16
28347595	28347595	PRJNA744060_P_NODE_7726_length_572_cov_3.545090_g7402_i0	PRJNA744060	7726	572	3.54509	20.2779148	Penaeus vannamei narna-like virus 2	3132560	Viruses	Viruses	50.8	0.00122	NR	WWZ85650.1	3132560	g7402	i0	41.4	0.456293706293706	87	43	42.5	4	36	278	557	641	WWZ85650.1 hypothetical protein [Penaeus vannamei narna-like virus 2]	diamond	261	50.8	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Penaeus vannamei narna-like virus 2
29641820	29641820	PRJNA744060_P_NODE_54570_length_222_cov_7.838926_g54241_i0	PRJNA744060	54570	222	7.838926	17.40241572	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	153	1.53e-41	NR	CAI9858974.1	3048756	g54241	i0	98.6	0.986486486486487	73	1	98.6	0	2	220	193	265	CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1]	diamond	219	153	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
30937508	30937508	PRJNA744060_P_NODE_2894_length_907_cov_2.211031_g2639_i0	PRJNA744060	2894	907	2.211031	20.05405117	Aspergillus flavus narnavirus 1	2871717	Viruses	Viruses	74.3	1.03e-10	NR	UAW09567.1	2871717	g2639	i0	27.4	1.53472987872106	234	152	72.4	5	680	24	51	281	UAW09567.1 MAG: replicase [Aspergillus flavus narnavirus 1]	diamond	1392	74.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus japonicum
31316603	31316603	PRJNA744060_P_NODE_12815_length_447_cov_10.058824_g12487_i0	PRJNA744060	12815	447	10.058824	44.96294328	Malassezia restricta virus MrV4	76775	Viruses	Viruses	263	3.67e-78	NR	QJA42332.1	2727863	g12487	i0	83.8	1.98657718120805	148	24	99.3	0	445	2	889	1036	QJA42332.1 polyprotein [Malassezia restricta virus MrV40L]	diamond	888	263	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
31664460	31664460	PRJNA744060_P_NODE_597_length_1569_cov_18.258021_g499_i0	PRJNA744060	597	1569	18.258021	286.46834949	Thelebolus microsporus partitivirus 1	2501047	Viruses	Viruses	256	6.09e-75	NR	AZT88598.1	2501047	g499	i0	37.4	0.852772466539197	446	252	83.4	7	1472	165	63	491	AZT88598.1 RNA-dependent RNA polymerase [Thelebolus microsporus partitivirus 1]	diamond	1338	256	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Thelebolus microsporus partitivirus 1
32085788	32085788	PRJNA744060_P_NODE_3958_length_787_cov_2.040616_g3674_i0	PRJNA744060	3958	787	2.040616	16.05964792	Narnavirus	186767	Viruses	Viruses	113	2.48e-24	NR	QHD64828.1	2695338	g3674	i0	33.9	7.53621346886912	242	146	90.3	7	716	6	272	504	QHD64828.1 RdRp [Erysiphe necator associated narnavirus 5]	diamond	5931	114	0.991228070175439	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Erysiphe necator associated narnavirus 5

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