metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1226487" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1226487" 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
27135531	27135531	PRJNA1226487_P_NODE_20922_length_355_cov_44.624113_g20820_i0	PRJNA1226487	20922	355	44.624113	158.41560115	Bacillus phage Shanette	1296656	Viruses	Viruses	47	0.00387	NR	YP_009216131.1	1296656	g20820	i0	31.1	0.76056338028169	90	61	76.1	1	325	56	245	333	YP_009216131.1 DNA primase [Bacillus phage Shanette]	diamond	270	47	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Herelleviridae	Siminovitchvirus	Siminovitchvirus shanette
27609925	27609925	PRJNA1226487_P_NODE_61224_length_255_cov_1.692308_g61122_i0	PRJNA1226487	61224	255	1.692308	4.3153854	Acinetobacter phage vB_AbaM_ME3	1837876	Viruses	Viruses	45.1	0.00669	NR	YP_009595850.1	1837876	g61122	i0	32.3	0.764705882352941	65	44	76.5	0	1	195	303	367	YP_009595850.1 hypothetical protein FDH01_gp018 [Acinetobacter phage vB_AbaM_ME3]	diamond	195	45.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Metrivirus	Metrivirus ME3
27704926	27704926	PRJNA1226487_P_NODE_63024_length_252_cov_7.418994_g62922_i0	PRJNA1226487	63024	252	7.418994	18.69586488	Escherichia phage slur	3102713	Viruses	Viruses	49.3	1.87e-5	NR	YP_009201555.1	1720493	g62922	i0	44	0.595238095238095	50	28	59.5	0	246	97	29	78	YP_009201555.1 hypothetical protein AVU05_gp12 [Escherichia phage slur01]	diamond	150	49.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Seuratvirus	Escherichia phage slur01
28083368	28083368	PRJNA1226487_P_NODE_58025_length_260_cov_1.647059_g57923_i0	PRJNA1226487	58025	260	1.647059	4.2823534	uncultured Caudovirales phage	2100421	Viruses	Viruses	46.2	4.14e-4	NR	CAB4162806.1	2100421	g57923	i0	48	0.576923076923077	50	24	57.7	1	3	152	45	92	CAB4162806.1 hypothetical protein UFOVP787_124 [uncultured Caudovirales phage]	diamond	150	46.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28272711	28272711	PRJNA1226487_P_NODE_73546_length_244_cov_1.801170_g73444_i0	PRJNA1226487	73546	244	1.80117	4.3948548	Yersinia phage MHG19	3025402	Viruses	Viruses	99	2.92e-25	NR	WCZ66322.1	3025402	g73444	i0	64.5	0.762295081967213	62	22	76.2	0	51	236	5	66	WCZ66322.1 hypothetical protein [Yersinia phage MHG19]	diamond	186	99	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae		Yersinia phage MHG19
28304428	28304428	PRJNA1226487_P_NODE_6766_length_505_cov_4.541667_g6670_i0	PRJNA1226487	6766	505	4.541667	22.93541835	Erwinia phage pEa_SNUABM_38	2859247	Viruses	Viruses	88.2	1.24e-18	NR	QXO09814.1	2859247	g6670	i0	35.9	0.778217821782178	131	76	76	3	410	27	29	154	QXO09814.1 hypothetical protein pEaSNUABM38_00092 [Erwinia phage pEa_SNUABM_38]	diamond	393	88.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Derbicusvirus	Erwinia phage pEa_SNUABM_38
28367509	28367509	PRJNA1226487_P_NODE_57646_length_260_cov_8.160428_g57544_i0	PRJNA1226487	57646	260	8.160428	21.2171128	Caudoviricetes sp.	2832643	Viruses	Viruses	46.2	2.24e-4	NR	DAR11252.1	2832643	g57544	i0	50	0.576923076923077	50	22	57.7	1	106	255	12	58	DAR11252.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	150	46.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28936015	28936015	PRJNA1226487_P_NODE_41808_length_285_cov_3.867925_g41706_i0	PRJNA1226487	41808	285	3.867925	11.02358625	Siphoviridae sp. ctHip2	2827830	Viruses	Viruses	88.2	6.24e-18	NR	DAF42606.1	2827830	g41706	i0	46.3	1	95	49	97.9	1	5	283	360	454	DAF42606.1 MAG TPA: DNA TRANSLOCASE FTSK [Siphoviridae sp. ctHip2]	diamond	285	88.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctHip2
29756746	29756746	PRJNA1226487_P_NODE_81631_length_226_cov_4.196078_g81529_i0	PRJNA1226487	81631	226	4.196078	9.48313628	uncultured Caudovirales phage	2100421	Viruses	Viruses	56.2	1.52e-7	NR	CAB4242287.1	2100421	g81529	i0	84.4	1.27433628318584	32	5	42.5	0	97	2	1	32	CAB4242287.1 hypothetical protein UFOVP108_99 [uncultured Caudovirales phage]	diamond	288	56.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
32254446	32254446	PRJNA1226487_P_NODE_1218_length_894_cov_14.462850_g1143_i0	PRJNA1226487	1218	894	14.46285	129.297879	Caudoviricetes sp.	2832643	Viruses	Viruses	381	3.709999999999999e-125	NR	DAM67750.1	2832643	g1143	i0	77.6	1.67114093959732	250	56	83.9	0	143	892	3	252	DAM67750.1 MAG TPA: chromosome partition protein [Caudoviricetes sp.]	diamond	1494	381	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes 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);;