metadata: contig_metadata: 12 rows where bioproject = "PRJNA741997" and tax

12 rows where bioproject = "PRJNA741997" 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_order	tax_family	tax_genus	tax_species
721362	721362	PRJNA741997_P_NODE_25581_length_440_cov_1.201635_g24461_i0	PRJNA741997	25581	440	1.201635	5.287194	Plotvirus plot	2170099	Viruses	Viruses	62.1	7.07e-5	NTclustered	gi\|1720702708\|gb\|MN119378.1\|	2596982	g24461	i0	91.489	0.220454545454545	47	1	10	2	373	416	45913	45867	Mycobacterium phage Penelope2018, complete genome	blastn	97	62.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Plotvirus	Plotvirus plot
721387	721387	PRJNA741997_P_NODE_30021_length_400_cov_1.155963_g28901_i0	PRJNA741997	30021	400	1.155963	4.623852	Dpdavirus caudatum	3428331	Viruses	Viruses	60.2	2.29e-4	NTclustered	gi\|2231638468\|ref\|NC_062762.1\|	2878010	g28901	i0	97.222	0.09	36	0	9	1	82	117	1098	1064	Halorubrum virus HRTV-29, complete genome	blastn	36	60.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Kirjokansivirales	Haloferuviridae	Dpdavirus	Dpdavirus caudatum
1997748	1997748	PRJNA741997_P_NODE_83962_length_244_cov_0.900585_g82842_i0	PRJNA741997	83962	244	0.900585	2.1974274	Pastovirus pasto	3431406	Viruses	Viruses	424	4.05e-114	NTclustered	gi\|1925843661\|gb\|MT708545.1\|	2767575	g82842	i0	97.951	1.98770491803279	244	5	100	0	1	244	35371	35128	Rhizobium phage Pasto, complete genome	blastn	485	424	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Pastovirus	Pastovirus pasto
14750240	14750240	PRJNA741997_P_NODE_19592_length_520_cov_3.058166_g18477_i0	PRJNA741997	19592	520	3.058166	15.9024632	Caudoviricetes sp.	2832643	Viruses	Viruses	56.5	0.004	NTclustered	gi\|2054455540\|tpg\|BK031416.1\|	2832643	g18477	i0	100	0.0576923076923077	30	0	6	0	475	504	43472	43501	MAG TPA_asm: Caudoviricetes sp. isolate ctPZW8, partial genome	blastn	30	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
16024121	16024121	PRJNA741997_P_NODE_54213_length_291_cov_1.059633_g53093_i0	PRJNA741997	54213	291	1.059633	3.08353203	Vibrio phage phiV208	2723906	Viruses	Viruses	52.8	0.027	NTclustered	gi\|1829640538\|gb\|MT227924.1\|	2723906	g53093	i0	86.275	0.175257731958763	51	4	18	1	131	181	17809	17856	Vibrio phage phiV208, complete genome	blastn	51	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Vibrio phage phiV208
19848623	19848623	PRJNA741997_P_NODE_68696_length_258_cov_1.248649_g67576_i0	PRJNA741997	68696	258	1.248649	3.22151442	Simplexvirus humanalpha1	3050292	Viruses	Viruses	63.9	1.08e-5	NTclustered	gi\|820019434\|gb\|KR011290.1\|	10298	g67576	i0	100	2.45736434108527	34	0	13	0	59	92	71518	71485	Human herpesvirus 1 strain 10-7-1, partial genome	blastn	634	63.9	1	Viruses	Heunggongvirae	Peploviricota	Herviviricetes	Herpesvirales	Orthoherpesviridae	Simplexvirus	Simplexvirus humanalpha1
27084202	27084202	PRJNA741997_P_NODE_42142_length_335_cov_0.874046_g41022_i0	PRJNA741997	42142	335	0.874046	2.9280541	uncultured Caudovirales phage	2100421	Viruses	Viruses	132	5.46e-33	NR	CAB4154472.1	2100421	g41022	i0	77	0.77910447761194	87	20	77.9	0	73	333	2091	2177	CAB4154472.1 LT_GEWL domain containing protein [uncultured Caudovirales phage]	diamond	261	132	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
27463496	27463496	PRJNA741997_P_NODE_42383_length_334_cov_1.057471_g41263_i0	PRJNA741997	42383	334	1.057471	3.53195314	uncultured Caudovirales phage	2100421	Viruses	Viruses	166	1.39e-47	NR	CAB4154604.1	2100421	g41263	i0	65.7	1.87724550898204	108	37	97	0	3	326	208	315	CAB4154604.1 hypothetical protein UFOVP653_14 [uncultured Caudovirales phage]	diamond	627	166	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
27526498	27526498	PRJNA741997_P_NODE_65383_length_265_cov_2.031250_g64263_i0	PRJNA741997	65383	265	2.03125	5.3828125	uncultured Caudovirales phage	2100421	Viruses	Viruses	171	2.13e-49	NR	CAB4122848.1	2100421	g64263	i0	95.4	0.984905660377358	87	4	98.5	0	263	3	92	178	CAB4122848.1 Terminase RNaseH-like domain containing protein [uncultured Caudovirales phage]	diamond	261	171	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30874019	30874019	PRJNA741997_P_NODE_71794_length_251_cov_0.865169_g70674_i0	PRJNA741997	71794	251	0.865169	2.17157419	Caudoviricetes sp.	2832643	Viruses	Viruses	137	3.84e-39	NR	DAG79872.1	2832643	g70674	i0	79.5	0.99203187250996006	83	17	99.2	0	3	251	48	130	DAG79872.1 MAG TPA: major tail protein [Caudoviricetes sp.]	diamond	249	137	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31664274	31664274	PRJNA741997_P_NODE_61237_length_275_cov_1.386139_g60117_i0	PRJNA741997	61237	275	1.386139	3.81188225	Caudoviricetes sp.	2832643	Viruses	Viruses	43.9	0.0206	NR	DAY59767.1	2832643	g60117	i0	39	0.643636363636364	59	33	64.4	1	25	201	147	202	DAY59767.1 MAG TPA: portal protein [Caudoviricetes sp.]	diamond	177	43.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32075623	32075623	PRJNA741997_P_NODE_29758_length_402_cov_0.796353_g28638_i0	PRJNA741997	29758	402	0.796353	3.20133906	Caudoviricetes sp.	2832643	Viruses	Viruses	116	1.97e-29	NR	XOS28093.1	2832643	g28638	i0	47.7	0.813432835820896	109	57	81.3	0	400	74	107	215	XOS28093.1 MAG: hypothetical protein MSP0001_901 [Caudoviricetes sp.]	diamond	327	116	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);;