metadata: contig_metadata: 20 rows where bioproject = "PRJNA951412" and tax

20 rows where bioproject = "PRJNA951412" 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
3814820	3814820	PRJNA951412_P_NODE_3523_length_265_cov_1.614583_g3438_i0	PRJNA951412	3523	265	1.614583	4.27864495	Moineauvirus	1623304	Viruses	Viruses	473	4.3599999999999987e-129	NTclustered	gi\|2437985630\|ref\|NC_070691.1\|	1971415	g3438	i0	98.868	100.581132075472	265	3	100	0	1	265	9340	9604	Streptococcus phage P3681, complete genome	blastn	26654	473	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Aliceevansviridae	Moineauvirus	Moineauvirus P3681
11466576	11466576	PRJNA951412_P_NODE_6229_length_246_cov_0.901734_g6144_i0	PRJNA951412	6229	246	0.901734	2.21826564	Viruses	10239	Viruses	Viruses	405	1.48e-108	NTclustered	gi\|2053070936\|tpg\|BK016058.1\|	2825571	g6144	i0	97.863	23.5121951219512	234	5	95	0	1	234	364	131	MAG TPA_asm: Siphoviridae sp. ctcK97, partial genome	blastn	5784	405	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Siphoviridae sp. ctcK97
13688484	13688484	PRJNA951412_P_NODE_6431_length_246_cov_0.895954_g6346_i0	PRJNA951412	6431	246	0.895954	2.20404684	Acinetobacter phage vB_AbaS_TRS1	1852629	Viruses	Viruses	422	1.47e-113	NTclustered	gi\|1070104669\|ref\|NC_031098.1\|	1852629	g6346	i0	97.561	7.89430894308943	246	6	100	0	1	246	33941	33696	Acinetobacter phage vB_AbaS_TRS1, complete genome	blastn	1942	422	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Acinetobacter phage vB_AbaS_TRS1
14962651	14962651	PRJNA951412_P_NODE_3752_length_259_cov_1.672043_g3667_i0	PRJNA951412	3752	259	1.672043	4.33059137	Caudoviricetes sp.	2832643	Viruses	Viruses	359	1.24e-94	NTclustered	gi\|2914804504\|gb\|OR221411.1\|	2832643	g3667	i0	94.421	95.0579150579151	233	13	90	0	27	259	27143	26911	MAG: Caudoviricetes sp. isolate MSP1680 genomic sequence	blastn	24620	359	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17512913	17512913	PRJNA951412_P_NODE_2334_length_309_cov_1.224576_g2249_i0	PRJNA951412	2334	309	1.224576	3.78393984	Caudoviricetes sp.	2832643	Viruses	Viruses	226	1.6099999999999998e-54	NTclustered	gi\|2914792039\|gb\|OR222787.1\|	2832643	g2249	i0	90.23	0.563106796116505	174	16	56	1	136	309	27841	27669	MAG: Caudoviricetes sp. isolate MSP0571 genomic sequence	blastn	174	226	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
17512955	17512955	PRJNA951412_P_NODE_5694_length_248_cov_0.880000_g5609_i0	PRJNA951412	5694	248	0.88	2.1824	Caudoviricetes sp.	2832643	Viruses	Viruses	453	5.2600000000000005e-123	NTclustered	gi\|2059803870\|tpg\|BK039751.1\|	2832643	g5609	i0	99.597	1.28225806451613	248	1	100	0	1	248	30960	31207	MAG TPA_asm: Caudoviricetes sp. isolate ctkVX2, partial genome	blastn	318	453	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
22611840	22611840	PRJNA951412_P_NODE_5658_length_248_cov_0.885714_g5573_i0	PRJNA951412	5658	248	0.885714	2.19657072	Caudoviricetes sp.	2832643	Viruses	Viruses	429	8.869999999999998e-116	NTclustered	gi\|2915040595\|gb\|OR222730.1\|	2832643	g5573	i0	97.976	1.20161290322581	247	5	99	0	1	247	48884	49130	MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence	blastn	298	429	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25160940	25160940	PRJNA951412_P_NODE_4060_length_253_cov_0.866667_g3975_i0	PRJNA951412	4060	253	0.866667	2.19266751	Caudoviricetes sp.	2832643	Viruses	Viruses	363	9.339999999999996e-96	NTclustered	gi\|2057857637\|tpg\|BK050476.1\|	2832643	g3975	i0	93.145	2.61660079051383	248	15	98	2	1	248	19418	19663	MAG TPA_asm: Caudoviricetes sp. isolate ctwJB10, partial genome	blastn	662	363	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
25160958	25160958	PRJNA951412_P_NODE_5520_length_248_cov_0.891429_g5435_i0	PRJNA951412	5520	248	0.891429	2.21074392	Caudoviricetes sp.	2832643	Viruses	Viruses	442	1.1399999999999995e-119	NTclustered	gi\|2915040595\|gb\|OR222730.1\|	2832643	g5435	i0	98.79	1	248	3	100	0	1	248	24683	24930	MAG: Caudoviricetes sp. isolate MSP0629 genomic sequence	blastn	248	442	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26740283	26740283	PRJNA951412_P_NODE_7621_length_243_cov_0.905882_g7536_i0	PRJNA951412	7621	243	0.905882	2.20129326	Erwinia phage Pastis	3056489	Viruses	Viruses	50.1	9.96e-5	NR	WJN64599.1	3056489	g7536	i0	37.6	1.04938271604938	85	45	98.8	3	241	2	2007	2088	WJN64599.1 virion encapsidated RNAP [Erwinia phage Pastis]	diamond	255	50.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Schitoviridae	Waedenswilvirus	Erwinia phage Pastis
27158252	27158252	PRJNA951412_P_NODE_1262_length_399_cov_0.950920_g1177_i0	PRJNA951412	1262	399	0.95092	3.7941708	root	1	Root_unresolved	Root_unresolved	53.9	9.73e-6	NR	YP_009786930.1	1897434	g1177	i0	71.9	1.24812030075188	32	9	24.1	0	303	398	101	132	YP_009786930.1 hypothetical protein HOR25_gp36 [Serratia phage SM9-3Y]	diamond	498	53.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales	Autotranscriptaviridae	Teetrevirus	Teetrevirus SALSA
27499675	27499675	PRJNA951412_P_NODE_6383_length_246_cov_0.895954_g6298_i0	PRJNA951412	6383	246	0.895954	2.20404684	Crassvirales sp.	2960088	Viruses	Viruses	130	1.5399999999999999e-34	NR	DAL01330.1	2960088	g6298	i0	88.9	0.98780487804878	81	9	98.8	0	1	243	55	135	DAL01330.1 MAG TPA: hypothetical protein [Crassvirales sp.]	diamond	243	130	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Crassvirales			Crassvirales sp.
28447006	28447006	PRJNA951412_P_NODE_2526_length_300_cov_1.255507_g2441_i0	PRJNA951412	2526	300	1.255507	3.766521	Pseudomonas phage vB_PsaM_M1	2995601	Viruses	Viruses	124	3.869999999999999e-32	NR	UZS00840.1	2995601	g2441	i0	56.7	0.97	97	41	97	1	4	294	3	98	UZS00840.1 endonuclease [Pseudomonas phage vB_PsaM_M1]	diamond	291	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Andersonviridae		Pseudomonas phage vB_PaeM_M1
29804402	29804402	PRJNA951412_P_NODE_2431_length_304_cov_1.346320_g2346_i0	PRJNA951412	2431	304	1.34632	4.0928128	Caudoviricetes sp.	2832643	Viruses	Viruses	160	1.4499999999999999e-43	NR	DAH57130.1	2832643	g2346	i0	75.8	0.9375	95	23	93.8	0	3	287	598	692	DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.]	diamond	285	160	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
29994150	29994150	PRJNA951412_P_NODE_1591_length_358_cov_1.350877_g1506_i0	PRJNA951412	1591	358	1.350877	4.83613966	Caudoviricetes sp.	2832643	Viruses	Viruses	171	3.34e-47	NR	DAH57130.1	2832643	g1506	i0	70.3	0.988826815642458	118	35	98.9	0	356	3	95	212	DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.]	diamond	354	171	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30214998	30214998	PRJNA951412_P_NODE_5992_length_247_cov_0.890805_g5907_i0	PRJNA951412	5992	247	0.890805	2.20028835	Xanthomonas phage DES1	2894399	Viruses	Viruses	75.5	1.89e-14	NR	UFK09597.1	2894399	g5907	i0	54.9	0.995951417004049	82	36	98.4	1	1	243	90	171	UFK09597.1 hypothetical protein [Xanthomonas phage DES1]	diamond	246	75.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Xanthomonas phage DES1
30878632	30878632	PRJNA951412_P_NODE_3374_length_270_cov_1.355330_g3289_i0	PRJNA951412	3374	270	1.35533	3.659391	Caudoviricetes sp.	2832643	Viruses	Viruses	103	8.07e-24	NR	DAH57143.1	2832643	g3289	i0	55.1	0.988888888888889	89	39	98.9	1	268	2	213	300	DAH57143.1 MAG TPA: AAA domain protein [Caudoviricetes sp.]	diamond	267	103	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31257852	31257852	PRJNA951412_P_NODE_1115_length_425_cov_0.835227_g1030_i0	PRJNA951412	1115	425	0.835227	3.54971475	Aeromonas phage vB_AceP_PAc	2996154	Viruses	Viruses	96.3	1.82e-22	NR	WAW11582.1	2996154	g1030	i0	45.8	0.755294117647059	107	53	72.7	2	339	31	21	126	WAW11582.1 hypothetical protein vBAcePPAc_0205 [Aeromonas phage vB_AceP_PAc]	diamond	321	96.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Plateaulakevirus	Aeromonas phage vB_AceP_PAc
31384530	31384530	PRJNA951412_P_NODE_4356_length_252_cov_0.865922_g4271_i0	PRJNA951412	4356	252	0.865922	2.18212344	Caudoviricetes sp.	2832643	Viruses	Viruses	138	9.02e-36	NR	DAH57130.1	2832643	g4271	i0	79.8	1	84	17	100	0	1	252	500	583	DAH57130.1 MAG TPA: DNA polymerase [Caudoviricetes sp.]	diamond	252	138	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32901232	32901232	PRJNA951412_P_NODE_3080_length_279_cov_1.500000_g2995_i0	PRJNA951412	3080	279	1.5	4.185	uncultured Caudovirales phage	2100421	Viruses	Viruses	58.2	1.16e-7	NR	CAB4139099.1	2100421	g2995	i0	38.6	0.946236559139785	88	44	94.6	1	264	1	60	137	CAB4139099.1 flap endonuclease-like protein [uncultured Caudovirales phage]	diamond	264	58.2	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);;