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

8 rows where analysis = "diamond", bioproject = "PRJNA758087" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
7112019	7112019	PRJNA758087_P_NODE_22946_length_545_cov_38.608051_g21629_i0	PRJNA758087	22946	545	38.608051	210.41387795	Botourmiaviridae sp.	2808997	Viruses	Viruses	245	2.09e-74	NR	WAK77987.1	2808997	g21629	i0	71.6	2.77981651376147	169	46	91.9	1	37	537	414	582	WAK77987.1 MAG: hypothetical protein [Botourmiaviridae sp.]	diamond	1515	245	1	Viruses	Orthornavirae	Lenarviricota	Miaviricetes	Ourlivirales	Botourmiaviridae		Botourmiaviridae sp.
15231256	15231256	PRJNA758087_P_NODE_2592_length_2001_cov_6.771784_g2146_i0	PRJNA758087	2592	2001	6.771784	135.50339784	Dermatophagoides pteronyssinus virus 6	2851133	Viruses	Viruses	92	1.81e-15	NR	QWY79454.1	2851133	g2146	i0	35.7	0.214392803598201	143	90	21.1	1	1547	1125	208	350	QWY79454.1 hypothetical protein DerpV6_gp1 [Dermatophagoides pteronyssinus virus 6]	diamond	429	92	1	Viruses							Dermatophagoides pteronyssinus virus 6
18584898	18584898	PRJNA758087_P_NODE_15195_length_760_cov_3.576419_g13956_i0	PRJNA758087	15195	760	3.576419	27.1807844	Caudoviricetes sp.	2832643	Viruses	Viruses	171	2.5299999999999998e-48	NR	DAN81456.1	2832643	g13956	i0	53.5	0.627631578947368	159	73	62.4	1	564	91	1	159	DAN81456.1 MAG TPA: HIRAN domain [Caudoviricetes sp.]	diamond	477	171	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
24960050	24960050	PRJNA758087_P_NODE_30480_length_403_cov_3.518182_g29160_i0	PRJNA758087	30480	403	3.518182	14.17827346	Xanthomonas phage XbC2	2978503	Viruses	Viruses	94.4	2.52e-22	NR	UYE98832.1	2978503	g29160	i0	56.5	1.27295285359801	85	37	63.3	0	398	144	2	86	UYE98832.1 hypothetical protein XbC2_407 [Xanthomonas phage XbC2]	diamond	513	94.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Mimasvirus	Xanthomonas phage XbC2
27179199	27179199	PRJNA758087_P_NODE_3622_length_1749_cov_290.286396_g3053_i0	PRJNA758087	3622	1749	290.286396	5077.10906604	Riboviria sp.	2585031	Viruses	Viruses	527	5.109999999999998e-180	NR	QDH86582.1	2585031	g3053	i0	54	5.27615780445969	487	211	81.8	6	1492	62	1	484	QDH86582.1 MAG: RNA-dependent RNA polymerase [Riboviria sp.]	diamond	9228	527	1	Viruses							Riboviria sp.
28568798	28568798	PRJNA758087_P_NODE_14467_length_787_cov_6.567227_g13250_i0	PRJNA758087	14467	787	6.567227	51.68407649	Phytophthora cactorum alphaendornavirus 4	3367732	Viruses	Viruses	67	2e-8	NR	BFT85754.1	3367732	g13250	i0	26.9	0.693773824650572	182	128	68.2	4	106	642	2040	2219	BFT85754.1 polyprotein [Phytophthora cactorum alphaendornavirus 4]	diamond	546	67	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Endornaviridae	Alphaendornavirus	Phytophthora cactorum alphaendornavirus 4
28947996	28947996	PRJNA758087_P_NODE_42248_length_248_cov_0.880000_g40928_i0	PRJNA758087	42248	248	0.88	2.1824	uncultured Caudovirales phage	2100421	Viruses	Viruses	103	1.1499999999999999e-23	NR	CAB4146517.1	2100421	g40928	i0	61	0.991935483870968	82	30	99.2	1	248	3	677	756	CAB4146517.1 Prim_Pol domain containing protein [uncultured Caudovirales phage]	diamond	246	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32044462	32044462	PRJNA758087_P_NODE_4238_length_1630_cov_222.868979_g3593_i0	PRJNA758087	4238	1630	222.868979	3632.7643577	Erysiphe necator associated abispo virus 1	2748675	Viruses	Viruses	150	3.86e-35	NR	QLC27600.1	2748675	g3593	i0	27.6	0.958895705521472	521	333	90.6	15	54	1529	28	533	QLC27600.1 putative methyltransferase [Erysiphe necator associated abispo virus 1]	diamond	1563	150	1	Viruses							Erysiphe necator associated abispo virus 1

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