metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA670521" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA670521" and tax_kingdom = "Heunggongvirae"

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_species
19016628	19016628	PRJNA670521_P_NODE_73175_length_250_cov_0.870056_g72430_i0	PRJNA670521	73175	250	0.870056	2.17514	Achromobacter phage JWF	1589748	Viruses	Viruses	59.7	1.7e-8	NR	YP_009224045.1	1589748	g72430	i0	79.4	0.408	34	7	40.8	0	2	103	173	206	YP_009224045.1 deoxynucleoside monophosphate kinase [Achromobacter phage JWF]	diamond	102	59.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
27239667	27239667	PRJNA670521_P_NODE_84423_length_245_cov_0.895349_g83678_i0	PRJNA670521	84423	245	0.895349	2.19360505	Achromobacter phage JWF	1589748	Viruses	Viruses	120	9.36e-30	NR	YP_009224043.1	1589748	g83678	i0	72.5	0.979591836734694	80	22	98	0	4	243	314	393	YP_009224043.1 tail protein [Achromobacter phage JWF]	diamond	240	120	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
27555409	27555409	PRJNA670521_P_NODE_30104_length_360_cov_1.069686_g29359_i0	PRJNA670521	30104	360	1.069686	3.8508696	Achromobacter phage JWF	1589748	Viruses	Viruses	64.7	7.81e-11	NR	YP_009224076.1	1589748	g29359	i0	53.2	0.516666666666667	62	29	51.7	0	4	189	32	93	YP_009224076.1 hypothetical protein AXJ13_gp117 [Achromobacter phage JWF]	diamond	186	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
28029370	28029370	PRJNA670521_P_NODE_31965_length_352_cov_1.103943_g31220_i0	PRJNA670521	31965	352	1.103943	3.88587936	Achromobacter phage 2-1	3061295	Viruses	Viruses	140	2.5099999999999993e-40	NR	WKV22074.1	3061295	g31220	i0	65.2	1.56818181818182	92	32	78.4	0	77	352	1	92	WKV22074.1 hypothetical protein Phage2-1_00074 [Achromobacter phage 2-1]	diamond	552	140	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage 2-1
29387086	29387086	PRJNA670521_P_NODE_87769_length_243_cov_0.905882_g87024_i0	PRJNA670521	87769	243	0.905882	2.20129326	Caudoviricetes sp.	2832643	Viruses	Viruses	84.7	6.23e-17	NR	XOR40187.1	2832643	g87024	i0	54.2	0.888888888888889	72	33	88.9	0	5	220	2014	2085	XOR40187.1 MAG: tail protein [Caudoviricetes sp.]	diamond	216	84.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Caudoviricetes sp.
29418387	29418387	PRJNA670521_P_NODE_93749_length_235_cov_2.870370_g93004_i0	PRJNA670521	93749	235	2.87037	6.7453695	Achromobacter phage 2-1	3061295	Viruses	Viruses	100	3.49e-23	NR	WKV22052.1	3061295	g93004	i0	80.3	0.778723404255319	61	11	76.6	1	230	51	317	377	WKV22052.1 ATP-dependent DNA ligase [Achromobacter phage 2-1]	diamond	183	100	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage 2-1
29733978	29733978	PRJNA670521_P_NODE_64470_length_263_cov_1.215789_g63725_i0	PRJNA670521	64470	263	1.215789	3.19752507	Achromobacter phage JWF	1589748	Viruses	Viruses	121	2.37e-33	NR	YP_009224072.1	1589748	g63725	i0	79.8	0.958174904942966	84	16	95.8	1	255	4	48	130	YP_009224072.1 hypothetical protein AXJ13_gp066 [Achromobacter phage JWF]	diamond	252	121	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
29797268	29797268	PRJNA670521_P_NODE_80431_length_247_cov_0.879310_g79686_i0	PRJNA670521	80431	247	0.87931	2.1718957	Achromobacter phage JWF	1589748	Viruses	Viruses	108	1.06e-26	NR	YP_009224065.1	1589748	g79686	i0	66.7	0.874493927125506	72	24	87.4	0	1	216	189	260	YP_009224065.1 DNA polymerase I thermostable [Achromobacter phage JWF]	diamond	216	108	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
30650194	30650194	PRJNA670521_P_NODE_47273_length_303_cov_1.004348_g46528_i0	PRJNA670521	47273	303	1.004348	3.04317444	Achromobacter phage JWF	1589748	Viruses	Viruses	140	2.39e-39	NR	YP_009224035.1	1589748	g46528	i0	82.9	0.752475247524752	76	13	75.2	0	229	2	1	76	YP_009224035.1 hypothetical protein AXJ13_gp029 [Achromobacter phage JWF]	diamond	228	140	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
31598891	31598891	PRJNA670521_P_NODE_47056_length_303_cov_1.630435_g46311_i0	PRJNA670521	47056	303	1.630435	4.94021805	Achromobacter phage JWF	1589748	Viruses	Viruses	132	2.91e-36	NR	YP_009224008.1	1589748	g46311	i0	73.3	1.03960396039604	105	17	99	3	2	301	93	191	YP_009224008.1 hypothetical protein AXJ13_gp002 [Achromobacter phage JWF]	diamond	315	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF
32579609	32579609	PRJNA670521_P_NODE_52479_length_290_cov_1.064516_g51734_i0	PRJNA670521	52479	290	1.064516	3.0870964	Achromobacter phage JWF	1589748	Viruses	Viruses	113	2.45e-28	NR	YP_009224089.1	1589748	g51734	i0	58.4	1.0448275862069	101	37	99.3	4	2	289	40	140	YP_009224089.1 hypothetical protein AXJ13_gp104 [Achromobacter phage JWF]	diamond	303	113	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Achromobacter phage JWF

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