metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA893346" and tax_phylum = "Pisuviricota"

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
27371992	27371992	PRJNA893346_P_NODE_10663_length_482_cov_1.070905_g10179_i0	PRJNA893346	10663	482	1.070905	5.1617621	Zebrafish gut calicivirus	RQ08	Viruses	Viruses	114	7.450000000000001e-26	NR	AVM87226.1	RQ08	g10179	i0	36.3	0.995850622406639	160	102	99.6	0	480	1	330	489	AVM87226.1 polyprotein [Zhejiang gunthers frog calicivirus 1]	diamond	480	114	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Caliciviridae		Zebrafish gut calicivirus
28129573	28129573	PRJNA893346_P_NODE_34305_length_250_cov_0.870056_g33815_i0	PRJNA893346	34305	250	0.870056	2.17514	Fish-associated picorna-like virus 3	3003959	Viruses	Viruses	142	2.7199999999999997e-37	NR	XCM68434.1	3003959	g33815	i0	77.4	1.008	84	17	98.4	1	5	250	572	655	XCM68434.1 MAG: structural polyprotein [Picornavirales sp.]	diamond	252	142	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales			Fish-associated picorna-like virus 3
28792361	28792361	PRJNA893346_P_NODE_28207_length_283_cov_1.100000_g27717_i0	PRJNA893346	28207	283	1.1	3.113	Durnavirales sp.	2809355	Viruses	Viruses	63.5	2.84e-9	NR	WRQ64726.1	2809355	g27717	i0	37.1	1.02826855123675	97	58	99.6	2	283	2	170	266	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	291	63.5	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
29707716	29707716	PRJNA893346_P_NODE_13990_length_417_cov_1.377907_g13503_i0	PRJNA893346	13990	417	1.377907	5.74587219	Partitiviridae sp.	1955170	Viruses	Viruses	164	6.489999999999999e-47	NR	QDH91349.1	1955170	g13503	i0	62.5	2.02158273381295	136	48	95.7	1	416	18	159	294	QDH91349.1 MAG: hypothetical protein H3Bulk427771_000001, partial [Partitiviridae sp.]	diamond	843	164	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales	Partitiviridae		Partitiviridae sp.
30308844	30308844	PRJNA893346_P_NODE_1652_length_1258_cov_1.960338_g1402_i0	PRJNA893346	1652	1258	1.960338	24.66105204	Durnavirales sp.	2809355	Viruses	Viruses	211	3.21e-59	NR	WRQ64726.1	2809355	g1402	i0	31.6	0.934817170111288	392	263	92.5	5	95	1258	11	401	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	1176	211	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.
30537316	30537316	PRJNA893346_P_NODE_34993_length_248_cov_1.760000_g34503_i0	PRJNA893346	34993	248	1.76	4.3648	Zebrafish jaw picornavirus	RQ13	Viruses	Viruses	102	4.0699999999999996e-23	NR	ADL38962.1	RQ13	g34503	i0	59.8	2.9758064516129	82	33	99.2	0	248	3	2094	2175	ADL38962.1 polyprotein [Oscivirus A2]	diamond	738	102	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Picornaviridae	Oscivirus	Zebrafish jaw picornavirus
30845558	30845558	PRJNA893346_P_NODE_22174_length_326_cov_1.217391_g21685_i0	PRJNA893346	22174	326	1.217391	3.96869466	Qianjiang marna-like virus 1	3347518	Viruses	Viruses	139	8.55e-36	NR	XHA88239.1	3347529	g21685	i0	63.6	0.984662576687117	107	37	97.5	2	325	8	353	458	XHA88239.1 MAG: hypothetical protein [Qianjiang marna-like virus 109]	diamond	321	139	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae		Qianjiang marna-like virus 109
31287779	31287779	PRJNA893346_P_NODE_12935_length_434_cov_2.124654_g12449_i0	PRJNA893346	12935	434	2.124654	9.22099836	Durnavirales sp.	2809355	Viruses	Viruses	103	7.68e-23	NR	WRQ64726.1	2809355	g12449	i0	34.5	0.960829493087558	139	91	96.1	0	423	7	179	317	WRQ64726.1 RNA-dependent RNA polymerase, partial [Durnavirales sp.]	diamond	417	103	1	Viruses	Orthornavirae	Pisuviricota	Duplopiviricetes	Durnavirales			Durnavirales sp.

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