metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA702290" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA702290" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26734195	26734195	PRJNA702290_P_NODE_1041_length_191_cov_7.401316_g1033_i0	PRJNA702290	1041	191	7.401316	14.13651356	Tolivirales sp.	2809914	Viruses	Viruses	48.9	5.85e-5	NR	WRQ66020.1	2809914	g1033	i0	92	0.392670157068063	25	2	39.3	0	113	187	144	168	WRQ66020.1 RNA-dependent RNA polymerase, partial [Tolivirales sp.]	diamond	75	48.9	1	Viruses		Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales			Tolivirales sp.
27240762	27240762	PRJNA702290_P_NODE_1103_length_191_cov_5.486842_g1095_i0	PRJNA702290	1103	191	5.486842	10.47986822	Totivirus sp.	2776824	Viruses	Viruses	56.6	2.26e-7	NR	QOQ37361.1	2776824	g1095	i0	88.5	0.408376963350785	26	3	40.8	0	79	2	198	223	QOQ37361.1 capsid protein, partial [Totivirus sp.]	diamond	78	56.6	1	Viruses		Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Totivirus sp.
27777885	27777885	PRJNA702290_P_NODE_2144_length_150_cov_11.927928_g2136_i0	PRJNA702290	2144	150	11.927928	17.891892	Cat Tien Hyleoglomeris arti-like virus	3240109	Viruses	Viruses	41.2	0.0367	NR	XGJ13234.1	3240109	g2136	i0	34	0.94	47	24	80	1	145	26	677	723	XGJ13234.1 MAG: VP1 protein [Cat Tien Hyleoglomeris arti-like virus]	diamond	141	41.2	1	Viruses								Cat Tien Hyleoglomeris arti-like virus
28535698	28535698	PRJNA702290_P_NODE_987_length_191_cov_8.578947_g979_i0	PRJNA702290	987	191	8.578947	16.38578877	Chemarfal virus 44	3062994	Viruses	Viruses	43.9	0.0074400000000000004	NR	WPR18184.1	3062994	g979	i0	86.4	0.345549738219895	22	3	34.6	0	76	11	686	707	WPR18184.1 MAG: RNA-dependent RNA polymerase [Chemarfal virus 44]	diamond	66	43.9	1	Viruses		Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Chemarfal virus 44
29040934	29040934	PRJNA702290_P_NODE_1228_length_191_cov_2.519737_g1220_i0	PRJNA702290	1228	191	2.519737	4.81269767	clirnapec virus 264	3368263	Viruses	Viruses	72	8.95e-13	NR	XII42428.1	3368263	g1220	i0	47	1.30366492146597	83	21	94.2	1	3	182	265	347	XII42428.1 MAG: capsid protein [clirnapec virus 264]	diamond	249	72	1	Viruses								clirnapec virus 264
29272661	29272661	PRJNA702290_P_NODE_489_length_203_cov_20.829268_g481_i0	PRJNA702290	489	203	20.829268	42.28341404	Orthornavirae	2732396	Viruses	Viruses	68.6	1.67e-11	NR	QDH87395.1	2585031	g481	i0	80	4.15270935960591	35	7	51.7	0	8	112	132	166	QDH87395.1 MAG: hypothetical protein H3Bulk42153_000002 [Riboviria sp.]	diamond	843	68.9	0.995645863570392	Viruses								Riboviria sp.
29829999	29829999	PRJNA702290_P_NODE_951_length_191_cov_9.401316_g943_i0	PRJNA702290	951	191	9.401316	17.95651356	Trichoderma harzianum dsRNA virus 3	3032470	Viruses	Viruses	48.5	1.72e-4	NR	WGH72980.1	3032470	g943	i0	83.3	0.37696335078534	24	4	37.7	0	3	74	269	292	WGH72980.1 MAG: putative RNA-dependent RNA polymerase [Trichoderma harzianum dsRNA virus 3]	diamond	72	48.5	1	Viruses	dsRNA viruses							Trichoderma harzianum dsRNA virus 3
30240802	30240802	PRJNA702290_P_NODE_1852_length_156_cov_12.341880_g1844_i0	PRJNA702290	1852	156	12.34188	19.2533328	Qianjiang dicistro-like virus 78	3347494	Viruses	Viruses	47	3.76e-4	NR	XHA87859.1	3347494	g1844	i0	72	0.480769230769231	25	7	48.1	0	82	156	571	595	XHA87859.1 MAG: polyprotein [Qianjiang dicistro-like virus 78]	diamond	75	47	1	Viruses		Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Dicistroviridae		Qianjiang dicistro-like virus 78
30872635	30872635	PRJNA702290_P_NODE_1614_length_158_cov_22.907563_g1606_i0	PRJNA702290	1614	158	22.907563	36.19394954	Neofusicoccum parvum victorivirus 1	2818054	Viruses	Viruses	84.7	1.86e-17	NR	QTE76047.1	2818054	g1606	i0	87.8	0.930379746835443	49	6	93	0	151	5	187	235	QTE76047.1 coat protein [Neofusicoccum parvum victorivirus 1]	diamond	147	84.7	1	Viruses		Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Pseudototiviridae	Victorivirus	Neofusicoccum parvum victorivirus 1
31030889	31030889	PRJNA702290_P_NODE_1575_length_159_cov_8.550000_g1567_i0	PRJNA702290	1575	159	8.55	13.5945	Leviviridae sp.	2027243	Viruses	Viruses	65.9	8.03e-11	NR	URG15095.1	2027243	g1567	i0	56.5	5.69811320754717	62	14	92.5	1	8	154	204	265	URG15095.1 MAG: RNA dependent RNA polymerase, partial [Leviviridae sp.]	diamond	906	65.9	1	Viruses		Orthornavirae	Lenarviricota	Leviviricetes	Norzivirales	Fiersviridae		Leviviridae sp.
31125055	31125055	PRJNA702290_P_NODE_275_length_283_cov_23.709016_g267_i0	PRJNA702290	275	283	23.709016	67.09651528	Hubei tombus-like virus 8	1923295	Viruses	Viruses	119	4.2699999999999995e-30	NR	YP_009336791.1	1923295	g267	i0	71.1	0.954063604240283	90	23	95.4	2	276	7	220	306	YP_009336791.1 hypothetical protein 3 [Hubei tombus-like virus 8]	diamond	270	119	1	Viruses								Hubei tombus-like virus 8
31441578	31441578	PRJNA702290_P_NODE_2136_length_150_cov_15.927928_g2128_i0	PRJNA702290	2136	150	15.927928	23.891892	Sanxia water strider virus 17	1923401	Viruses	Viruses	50.1	2.79e-5	NR	YP_009337232.1	1923401	g2128	i0	66.7	0.66	33	11	66	0	141	43	968	1000	YP_009337232.1 hypothetical protein 1 [Sanxia water strider virus 17]	diamond	99	50.1	1	Viruses								Sanxia water strider virus 17
31852720	31852720	PRJNA702290_P_NODE_437_length_214_cov_21.697143_g429_i0	PRJNA702290	437	214	21.697143	46.43188602	Qianjiang tombus-like virus 89	3348160	Viruses	Viruses	115	1.06e-28	NR	XHA86562.1	3348160	g429	i0	78.3	0.967289719626168	69	15	96.7	0	207	1	202	270	XHA86562.1 MAG: putative viral coat protein [Qianjiang tombus-like virus 89]	diamond	207	115	1	Viruses		Orthornavirae	Kitrinoviricota	Tolucaviricetes	Tolivirales	Tombusviridae		Qianjiang tombus-like virus 89
32370425	32370425	PRJNA702290_P_NODE_2159_length_150_cov_6.036036_g2151_i0	PRJNA702290	2159	150	6.036036	9.054054	Ghabrivirales	2732540	Viruses	Viruses	86.3	4.9e-18	NR	UHS72521.1	1955172	g2151	i0	76.6	4.54	47	11	94	0	10	150	285	331	UHS72521.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.]	diamond	681	86.3	1	Viruses		Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
32390750	32390750	PRJNA702290_P_NODE_1499_length_160_cov_14.611570_g1491_i0	PRJNA702290	1499	160	14.61157	23.378512	Nodaviridae sp.	1955166	Viruses	Viruses	60.8	4.92e-9	NR	USC30114.1	1955166	g1491	i0	56.8	0.825	44	19	82.5	0	144	13	85	128	USC30114.1 MAG: putative RNA-dependent RNA polymerase, partial [Nodaviridae sp.]	diamond	132	60.8	1	Viruses		Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae		Nodaviridae 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);;