metadata: contig_metadata: 6 rows where bioproject = "PRJNA949785" and tax

6 rows where bioproject = "PRJNA949785" 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_family	tax_genus	tax_species
6366036	6366036	PRJNA949785_P_NODE_13865_length_270_cov_1.563452_g13668_i0	PRJNA949785	13865	270	1.563452	4.2213204	Pollockvirus	2842973	Viruses	Viruses	145	3.9699999999999995e-30	NTclustered	gi\|849254769\|ref\|NC_027381.1\|	1540097	g13668	i0	77.122	4.4037037037037	271	48	98	13	5	268	62629	62366	Escherichia phage Pollock, complete genome	blastn	1189	145	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Schitoviridae	Pollockvirus	Pollockvirus pollock
27373485	27373485	PRJNA949785_P_NODE_11643_length_300_cov_0.819383_g11446_i0	PRJNA949785	11643	300	0.819383	2.458149	uncultured Caudovirales phage	2100421	Viruses	Viruses	57.8	3.77e-7	NR	CAB4132264.1	2100421	g11446	i0	40.2	1.07	107	57	100	3	1	300	291	397	CAB4132264.1 hypothetical protein UFOVP248_7 [uncultured Caudovirales phage]	diamond	321	57.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
28162692	28162692	PRJNA949785_P_NODE_17305_length_246_cov_0.890173_g17108_i0	PRJNA949785	17305	246	0.890173	2.18982558	Caudoviricetes sp.	2832643	Viruses	Viruses	88.2	3.33e-18	NR	XOR02773.1	2832643	g17108	i0	57.3	1	82	29	98.8	2	245	3	238	314	XOR02773.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	246	88.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28636429	28636429	PRJNA949785_P_NODE_6967_length_410_cov_1.599407_g6770_i0	PRJNA949785	6967	410	1.599407	6.5575687	Alishewanella phage vB_AspM_Slicko	3038238	Viruses	Viruses	48.5	0.00124	NR	WGH49528.1	3038238	g6770	i0	40	0.585365853658537	80	40	55.6	4	138	365	38	113	WGH49528.1 hypothetical protein [Alishewanella phage vB_AspM_Slicko01]	diamond	240	48.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Alishewanella phage vB_AspM_Slicko01
29362469	29362469	PRJNA949785_P_NODE_16909_length_247_cov_0.885057_g16712_i0	PRJNA949785	16909	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	82.8	9e-17	NR	DAP03080.1	2832643	g16712	i0	56.1	0.995951417004049	82	35	98.4	1	247	5	138	219	DAP03080.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.]	diamond	246	82.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
31826974	31826974	PRJNA949785_P_NODE_15217_length_254_cov_1.220994_g15020_i0	PRJNA949785	15217	254	1.220994	3.10132476	uncultured Caudovirales phage	2100421	Viruses	Viruses	52.4	1.57e-5	NR	CAB4196514.1	2100421	g15020	i0	51.2	1.5	41	20	48.4	0	119	241	1	41	CAB4196514.1 RfbB dTDP-D-glucose 4,6-dehydratase [uncultured Caudovirales phage]	diamond	381	52.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch

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