metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA1204310" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA1204310" 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
16347455	16347455	PRJNA1204310_P_NODE_21553_length_391_cov_2.207547_g21256_i0	PRJNA1204310	21553	391	2.207547	8.63150877	Partitiviridae sp.	1955170	Viruses	Viruses	157	2.37e-44	NR	QDH91349.1	1955170	g21256	i0	63.6	0.989769820971867	129	44	96.7	1	391	14	155	283	QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.]	diamond	387	157	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
26882940	26882940	PRJNA1204310_P_NODE_721_length_1564_cov_2.091214_g635_i0	PRJNA1204310	721	1564	2.091214	32.70658696	Cryphonectria naterciae splipalmivirus 1	2841740	Viruses	Viruses	196	2.45e-51	NR	BCX55509.1	2841740	g635	i0	32.7	0.966751918158568	504	284	92.5	17	115	1560	103	573	BCX55509.1 putative RNA-dependent RNA polymerase [Cryphonectria naterciae splipalmivirus 1]	diamond	1512	196	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus cryphonectriae
28039108	28039108	PRJNA1204310_P_NODE_2365_length_1033_cov_2.029167_g2167_i0	PRJNA1204310	2365	1033	2.029167	20.96129511	Narnavirus	186767	Viruses	Viruses	138	1.91e-32	NR	WZE65507.1	3139161	g2167	i0	30.3	2.03291384317522	350	183	99.6	8	1	1029	262	557	WZE65507.1 RNA-dependent RNA polymerase [Ophiocordyceps sinensis narnavirus 4]	diamond	2100	138	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Ophiocordyceps sinensis narnavirus 4
28714849	28714849	PRJNA1204310_P_NODE_28887_length_345_cov_1.720588_g28590_i0	PRJNA1204310	28887	345	1.720588	5.9360286	Downy mildew lesion associated splipalmivirus 3	2719514	Viruses	Viruses	46.2	0.00555	NR	WNA22210.1	2719514	g28590	i0	44.4	0.469565217391304	54	30	47	0	184	345	54	107	WNA22210.1 MAG: hypothetical protein [Downy mildew lesion associated splipalmivirus 3]	diamond	162	46.2	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Jakapalmivirus	Jakapalmivirus ibericum
28967553	28967553	PRJNA1204310_P_NODE_5748_length_713_cov_13.000000_g5479_i0	PRJNA1204310	5748	713	13	92.69	Durnavirales sp.	2809355	Viruses	Viruses	112	8.899999999999999e-25	NR	WRQ64726.1	2809355	g5479	i0	33	0.85413744740533	203	132	84.2	4	107	706	11	212	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	609	112	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
29157024	29157024	PRJNA1204310_P_NODE_3869_length_846_cov_1.670116_g3627_i0	PRJNA1204310	3869	846	1.670116	14.12918136	Leptosphaeria biglobosa narnavirus 7	2985682	Viruses	Viruses	112	1.0799999999999999e-23	NR	UYL94525.1	2985682	g3627	i0	32.7	1.6595744680851101	217	136	74.1	5	160	786	38	252	UYL94525.1 MAG: RNA-dependent RNA polymerase [Leptosphaeria biglobosa narnavirus 7]	diamond	1404	112	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Leptosphaeria biglobosa narnavirus 7
29724895	29724895	PRJNA1204310_P_NODE_830_length_1501_cov_16.655462_g731_i0	PRJNA1204310	830	1501	16.655462	249.99848462	Durnavirales sp.	2809355	Viruses	Viruses	295	1.32e-90	NR	WRQ64726.1	2809355	g731	i0	35.7	0.939373750832778	470	296	92.9	6	107	1501	11	479	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1410	295	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
30041027	30041027	PRJNA1204310_P_NODE_831_length_1501_cov_9.115546_g731_i1	PRJNA1204310	831	1501	9.115546	136.82434546	Durnavirales sp.	2809355	Viruses	Viruses	294	3.69e-90	NR	WRQ64726.1	2809355	g731	i1	35.7	0.939373750832778	470	296	92.9	6	107	1501	11	479	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1410	294	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
30262446	30262446	PRJNA1204310_P_NODE_36112_length_310_cov_1.645570_g35815_i0	PRJNA1204310	36112	310	1.64557	5.101267	Frijoles virus VP-161A	426788	Viruses	Viruses	69.7	1.63e-12	NR	YP_009665189.1	426788	g35815	i0	44.8	0.841935483870968	87	46	84.2	1	295	35	27	111	YP_009665189.1 N protein, partial [Frijoles virus VP-161A]	diamond	261	69.7	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Hareavirales	Phenuiviridae	Phlebovirus	Phlebovirus limboense
30420488	30420488	PRJNA1204310_P_NODE_2093_length_1084_cov_7.941642_g1905_i0	PRJNA1204310	2093	1084	7.941642	86.08739928	Narnavirus sp.	2587225	Viruses	Viruses	65.1	1.26e-8	NR	CAK8705411.1	2587225	g1905	i0	34.4	1.26752767527675	128	73	34.9	3	992	615	4	122	CAK8705411.1 uncharacterized [Narnavirus sp.]	diamond	1374	65.1	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
31052337	31052337	PRJNA1204310_P_NODE_4595_length_787_cov_1.676471_g4338_i0	PRJNA1204310	4595	787	1.676471	13.19382677	Aspergillus fumigatus narnavirus 2	2250450	Viruses	Viruses	54.3	2.6e-4	NR	BCH36628.1	2250450	g4338	i0	26.4	0.880559085133418	231	147	82.7	8	113	763	262	483	BCH36628.1 hypothetical protein [Aspergillus fumigatus narnavirus 2]	diamond	693	54.3	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Splipalmiviridae	Divipalmivirus	Divipalmivirus aspergilli
31811013	31811013	PRJNA1204310_P_NODE_16497_length_440_cov_1.220708_g16200_i0	PRJNA1204310	16497	440	1.220708	5.3711152	Narnavirus sp.	2587225	Viruses	Viruses	170	6.68e-46	NR	CAK7594502.1	2587225	g16200	i0	55.1	0.940909090909091	138	61	93.4	1	435	25	97	234	CAK7594502.1 RNA-dependent RNA polymerase, partial [Narnavirus sp.]	diamond	414	170	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
32254291	32254291	PRJNA1204310_P_NODE_34618_length_317_cov_1.750000_g34321_i0	PRJNA1204310	34618	317	1.75	5.5475	Narnavirus sp.	2587225	Viruses	Viruses	103	5.42e-23	NR	CAK7594523.1	2587225	g34321	i0	49.1	1.89274447949527	106	53	99.4	1	315	1	781	886	CAK7594523.1 RNA-dependent RNA polymerase, partial [Narnavirus sp.]	diamond	600	103	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae	Narnavirus	Narnavirus sp.
32462774	32462774	PRJNA1204310_P_NODE_1939_length_1117_cov_1.754789_g1756_i0	PRJNA1204310	1939	1117	1.754789	19.60099313	Viruses	10239	Viruses	Viruses	72.8	7.79e-10	NR	WPR16641.1	3066944	g1756	i0	21.9	1.77529095792301	319	228	84.1	6	72	1010	274	577	WPR16641.1 MAG: RNA-dependent RNA polymerase [Mbeech associated narna-like virus 2]	diamond	1983	73.2	0.994535519125683	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Mbeech associated narna-like virus 2

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