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

8 rows where analysis = "diamond", bioproject = "PRJNA1095825" and tax_phylum = "Uroviricota"

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_family	tax_genus	tax_species
26878056	26878056	PRJNA1095825_P_NODE_261661_length_247_cov_0.885057_g258598_i0	PRJNA1095825	261661	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	47.8	9.16e-5	NR	XOQ87506.1	2832643	g258598	i0	38.5	0.789473684210526	65	35	78.9	1	221	27	3	62	XOQ87506.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	195	47.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
27794326	27794326	PRJNA1095825_P_NODE_271924_length_245_cov_0.895349_g268861_i0	PRJNA1095825	271924	245	0.895349	2.19360505	Caudoviricetes sp.	2832643	Viruses	Viruses	103	1.99e-24	NR	XOR63739.1	2832643	g268861	i0	62.5	0.979591836734694	80	30	98	0	240	1	242	321	XOR63739.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	240	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28678415	28678415	PRJNA1095825_P_NODE_291167_length_242_cov_0.911243_g288104_i0	PRJNA1095825	291167	242	0.911243	2.20520806	Pseudomonas phage Astolliot	2928830	Viruses	Viruses	72.4	3.26e-13	NR	UOL48755.1	2928830	g288104	i0	53.8	0.805785123966942	65	30	80.6	0	199	5	152	216	UOL48755.1 hypothetical protein [Pseudomonas phage Astolliot]	diamond	195	72.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Vandenendeviridae	Otagovirus	Pseudomonas phage Astolliot
28930901	28930901	PRJNA1095825_P_NODE_230888_length_254_cov_1.701657_g227825_i0	PRJNA1095825	230888	254	1.701657	4.32220878	Vibrio phage phi 1	1589297	Viruses	Viruses	152	5.11e-45	NR	YP_009198579.1	1589297	g227825	i0	83.3	0.992125984251969	84	14	99.2	0	1	252	22	105	YP_009198579.1 HNH endonuclease [Vibrio phage phi 1]	diamond	252	152	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Schitoviridae	Pacinivirus	Pacinivirus phi1
29246490	29246490	PRJNA1095825_P_NODE_127089_length_341_cov_3.630597_g124026_i0	PRJNA1095825	127089	341	3.630597	12.38033577	Vibrio phage BUCT194	2859072	Viruses	Viruses	51.6	9.47e-5	NR	YP_010657584.1	2859072	g124026	i0	32.7	2.9208211143695	110	73	95.9	1	340	14	2279	2388	YP_010657584.1 virion-encapsulated RNA polymerase [Vibrio phage BUCT194]	diamond	996	51.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Schitoviridae	Varunavirus	Varunavirus BUCT194
30920905	30920905	PRJNA1095825_P_NODE_287634_length_242_cov_0.911243_g284571_i0	PRJNA1095825	287634	242	0.911243	2.20520806	Nocardia phage P3.1	2815755	Viruses	Viruses	89	1.87e-18	NR	QSL67855.1	2815755	g284571	i0	59.7	0.954545454545455	77	31	95.5	0	235	5	150	226	QSL67855.1 portal protein [Nocardia phage P3.1]	diamond	231	89	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Nocardia phage P3.1
31900932	31900932	PRJNA1095825_P_NODE_86077_length_408_cov_2.101493_g83014_i0	PRJNA1095825	86077	408	2.101493	8.57409144	Alteromonas phage vB_AemP_PT15-A5	2981567	Viruses	Viruses	52.4	1.02e-4	NR	UYE90227.1	2981567	g83014	i0	33.3	0.573529411764706	78	52	57.4	0	9	242	2903	2980	UYE90227.1 RNA polymerase [Alteromonas phage vB_AemP_PT15-A5]	diamond	234	52.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Schitoviridae		Alteromonas phage vB_AemP_PT15-A5
32154107	32154107	PRJNA1095825_P_NODE_276818_length_244_cov_0.900585_g273755_i0	PRJNA1095825	276818	244	0.900585	2.1974274	Caudoviricetes sp.	2832643	Viruses	Viruses	84.3	1.81e-19	NR	XOR61043.1	2832643	g273755	i0	54.4	1.67213114754098	68	26	83.6	1	242	39	4	66	XOR61043.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	408	84.3	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);;