metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA788929" 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
769494	769494	PRJNA788929_P_NODE_39481_length_247_cov_8.770115_g38820_i0	PRJNA788929	39481	247	8.770115	21.66218405	Hortaea werneckii totivirus 1	2501057	Viruses	Viruses	142	3.3499999999999996e-37	NR	AZT88647.1	2501057	g38820	i0	87.8	0.898785425101215	74	9	89.9	0	4	225	368	441	AZT88647.1 RNA-dependent RNA polymerase [Hortaea werneckii totivirus 1]	diamond	222	142	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Hortaea werneckii totivirus 1
12249142	12249142	PRJNA788929_P_NODE_45090_length_228_cov_18.270968_g44429_i0	PRJNA788929	45090	228	18.270968	41.65780704	Grapevine wood holobiome associated narna-like virus 14	3398650	Viruses	Viruses	84	9.18e-17	NR	XOD45373.1	3398650	g44429	i0	63.2	0.894736842105263	68	25	89.5	0	3	206	368	435	XOD45373.1 RdRp [Grapevine wood holobiome associated narna-like virus 14]	diamond	204	84	1	Viruses	Orthornavirae	Lenarviricota	Amabiliviricetes	Wolframvirales	Narnaviridae		Grapevine wood holobiome associated narna-like virus 14
22446391	22446391	PRJNA788929_P_NODE_12838_length_481_cov_35.002451_g12181_i0	PRJNA788929	12838	481	35.002451	168.36178931	Hangzhou totivirus 6	2905252	Viruses	Viruses	186	4.85e-51	NR	UHK03175.1	2905252	g12181	i0	63.1	0.929313929313929	149	55	92.9	0	27	473	348	496	UHK03175.1 MAG: hypothetical protein FuToV6_gp1 [Hangzhou totivirus 6]	diamond	447	186	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Hangzhou totivirus 6
23722520	23722520	PRJNA788929_P_NODE_7139_length_706_cov_38.895735_g6506_i0	PRJNA788929	7139	706	38.895735	274.6038891	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	295	8.749999999999997e-88	NR	XCM68117.1	3003959	g6506	i0	76.9	0.773371104815864	182	42	77.3	0	679	134	2704	2885	XCM68117.1 MAG: polyprotein [Picornavirales sp.]	diamond	546	295	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
26832247	26832247	PRJNA788929_P_NODE_44821_length_230_cov_4.458599_g44160_i0	PRJNA788929	44821	230	4.458599	10.2547777	Lasius niger virus 1	2018503	Viruses	Viruses	92.4	1.04e-19	NR	UXD80070.1	2018503	g44160	i0	60.9	1.91739130434783	69	27	90	0	208	2	1696	1764	UXD80070.1 RNA-dependent RNA polymerase [Lasius niger virus 1]	diamond	441	92.4	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Polycipiviridae	Sopolycivirus	Sopolycivirus gammalasii
29169670	29169670	PRJNA788929_P_NODE_46269_length_222_cov_6.046980_g45608_i0	PRJNA788929	46269	222	6.04698	13.4242956	Botourmiaviridae sp.	2808997	Viruses	Viruses	58.5	7.8e-8	NR	UJQ91984.1	2808997	g45608	i0	60	1.35135135135135	50	20	67.6	0	153	4	9	58	UJQ91984.1 MAG: putative RNA-dependent RNA polymerase, partial [Botourmiaviridae sp.]	diamond	300	58.5	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
29769318	29769318	PRJNA788929_P_NODE_36571_length_256_cov_1.683060_g35910_i0	PRJNA788929	36571	256	1.68306	4.3086336	Alphachrysovirus aspergilli	607716	Viruses	Viruses	156	5.779999999999998e-42	NR	YP_009508104.1	607716	g35910	i0	92.1	1.78125	76	6	89.1	0	5	232	705	780	YP_009508104.1 RNA-dependent RNA polymerase [Alphachrysovirus aspergilli]	diamond	456	156	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus aspergilli
29958911	29958911	PRJNA788929_P_NODE_12231_length_496_cov_35.186761_g11574_i0	PRJNA788929	12231	496	35.186761	174.52633456	Penicillium roqueforti ssRNA mycovirus 1	1532180	Viruses	Viruses	66.2	3.67e-9	NR	YP_009052456.1	1532180	g11574	i0	49.2	0.368951612903226	61	31	36.9	0	190	8	53	113	YP_009052456.1 RNA-dependent RNA polymerase [Penicillium roqueforti ssRNA mycovirus 1]	diamond	183	66.2	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Fusariviridae	Alphafusarivirus	Alphafusarivirus roqueforti
30970112	30970112	PRJNA788929_P_NODE_10214_length_558_cov_64.422680_g9561_i0	PRJNA788929	10214	558	64.42268	359.4785544	Sanya levivirus 1	2905509	Viruses	Viruses	75.5	9.71e-14	NR	UHR49790.1	2905509	g9561	i0	45.6	0.483870967741935	90	47	48.4	1	26	295	50	137	UHR49790.1 MAG: coat protein [Sanya levivirus 1]	diamond	270	75.5	1	Viruses	Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae	Eistcuvirus	Eistcuvirus conocephalivivens
31823593	31823593	PRJNA788929_P_NODE_22377_length_343_cov_3.614815_g21716_i0	PRJNA788929	22377	343	3.614815	12.39881545	Verticillium dahliae ormycovirus 2	3104771	Viruses	Viruses	92.4	4.04e-19	NR	WPV08071.1	3104771	g21716	i0	49	0.87463556851312	100	51	87.5	0	322	23	46	145	WPV08071.1 MAG: hypothetical protein [Verticillium dahliae ormycovirus 2]	diamond	300	92.4	1	Viruses	Orthornavirae		Orpoviricetes	Formycovirales	Betaormycoviridae	Vormycovirus	Vormycovirus verticilli
32076864	32076864	PRJNA788929_P_NODE_7198_length_702_cov_7.241653_g6564_i0	PRJNA788929	7198	702	7.241653	50.83640406	Alphachrysovirus aspergilli	607716	Viruses	Viruses	342	1.42e-108	NR	YP_009508103.1	607716	g6564	i0	73.1	0.952991452991453	223	59	94.9	1	16	681	417	639	YP_009508103.1 hypothetical protein [Alphachrysovirus aspergilli]	diamond	669	342	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Chrysoviridae	Alphachrysovirus	Alphachrysovirus aspergilli

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