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

12 rows where bioproject = "PRJNA906294" 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
2163232	2163232	PRJNA906294_P_NODE_211802_length_248_cov_0.868571_g207686_i0	PRJNA906294	211802	248	0.868571	2.15405608	uncultured Caudovirales phage	2100421	Viruses	Viruses	127	6.809999999999998e-32	NR	CAB4122465.1	2100421	g207686	i0	70.7	0.991935483870968	82	24	99.2	0	2	247	3872	3953	CAB4122465.1 AdoMet_MTases domain containing protein [uncultured Caudovirales phage]	diamond	246	127	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
2163263	2163263	PRJNA906294_P_NODE_213102_length_247_cov_0.885057_g208986_i0	PRJNA906294	213102	247	0.885057	2.18609079	Caudoviricetes sp.	2832643	Viruses	Viruses	429	8.83e-116	NTclustered	gi\|2914832067\|gb\|OR222576.1\|	2832643	g208986	i0	97.976	1	247	5	100	0	1	247	4568	4814	MAG: Caudoviricetes sp. isolate MSP0358 genomic sequence	blastn	247	429	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5990252	5990252	PRJNA906294_P_NODE_169865_length_286_cov_2.098592_g165749_i0	PRJNA906294	169865	286	2.098592	6.00197312	Caudoviricetes sp.	2832643	Viruses	Viruses	52.8	0.026	NTclustered	gi\|2053183578\|tpg\|BK016306.1\|	2832643	g165749	i0	100	0.0979020979020979	28	0	10	0	73	100	13202	13229	MAG TPA_asm: Caudoviricetes sp. isolate ctZ787, partial genome	blastn	28	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
5990947	5990947	PRJNA906294_P_NODE_199745_length_255_cov_2.236264_g195629_i0	PRJNA906294	199745	255	2.236264	5.7024732	Staphylococcus phage vB_SsapH-Golestan-105-M	2872011	Viruses	Viruses	411	3.3199999999999995e-110	NTclustered	gi\|2086549864\|dbj\|LC648442.1\|	2872011	g195629	i0	95.686	14.4862745098039	255	11	100	0	1	255	100040	99786	Staphylococcus phage vB_SsapH-Golestan-105-M DNA, complete genome	blastn	3694	411	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Herelleviridae		Staphylococcus phage vB_SsapH-Golestan-105-M
12365306	12365306	PRJNA906294_P_NODE_142310_length_323_cov_1.212000_g138194_i0	PRJNA906294	142310	323	1.212	3.91476	Crassvirales sp.	2960088	Viruses	Viruses	56.5	0.002	NTclustered	gi\|2053233622\|tpg\|BK031035.1\|	2960088	g138194	i0	100	0.272445820433437	30	0	9	0	63	92	10199	10228	MAG TPA_asm: Crassvirales sp. isolate ct3DT2, partial genome	blastn	88	56.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Crassvirales			Crassvirales sp.
20013817	20013817	PRJNA906294_P_NODE_182676_length_273_cov_1.020000_g178560_i0	PRJNA906294	182676	273	1.02	2.7846	Moovirus moo	3060392	Viruses	Viruses	499	7.45e-137	NTclustered	gi\|2438080420\|ref\|NC_070850.1\|	2886042	g178560	i0	99.634	1	273	1	100	0	1	273	2637	2909	Shigella virus Moo19, complete genome	blastn	273	499	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Schitoviridae	Moovirus	Moovirus moo
25116147	25116147	PRJNA906294_S_NODE_1160_length_253_cov_1.538889_g1159_i0	PRJNA906294	1160	253	1.538889	3.89338917	Caudoviricetes sp.	2832643	Viruses	Viruses	58.4	4.93e-4	NTclustered	gi\|2056923661\|tpg\|BK054360.1\|	2832643	g1159	i0	97.143	1.71146245059289	35	0	14	1	1	35	33736	33703	MAG TPA_asm: Caudoviricetes sp. isolate ctUKC3, partial genome	blastn	433	58.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
26834547	26834547	PRJNA906294_P_NODE_149821_length_312_cov_1.158996_g145705_i0	PRJNA906294	149821	312	1.158996	3.61606752	uncultured Caudovirales phage	2100421	Viruses	Viruses	74.3	2.13e-13	NR	CAB4185846.1	2100421	g145705	i0	34.3	1.79807692307692	102	60	98.1	2	5	310	61	155	CAB4185846.1 Glycosyltransferase, DXD sugar-binding motif [uncultured Caudovirales phage]	diamond	561	74.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28105629	28105629	PRJNA906294_P_NODE_209365_length_248_cov_1.754286_g205249_i0	PRJNA906294	209365	248	1.754286	4.35062928	Biquartavirus	1912143	Viruses	Viruses	42.7	0.0218	NR	UOX40402.1	2907222	g205249	i0	41.7	1.41532258064516	48	25	56.9	2	246	106	107	152	UOX40402.1 hypothetical protein OBDJBBDK_00078 [Aeromonas phage AhFM11]	diamond	351	42.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Pantevenvirales	Straboviridae	Biquartavirus	Aeromonas phage AhFM11
28255976	28255976	PRJNA906294_P_NODE_213186_length_247_cov_0.885057_g209070_i0	PRJNA906294	213186	247	0.885057	2.18609079	uncultured Caudovirales phage	2100421	Viruses	Viruses	100	2.64e-22	NR	CAB4198872.1	2100421	g209070	i0	61	2.96356275303644	82	32	99.6	0	247	2	489	570	CAB4198872.1 crystallin beta/gamma motif-containing protein, partial [uncultured Caudovirales phage]	diamond	732	100	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
31857498	31857498	PRJNA906294_P_NODE_224677_length_243_cov_0.894118_g220561_i0	PRJNA906294	224677	243	0.894118	2.17270674	Caudoviricetes sp.	2832643	Viruses	Viruses	67.8	5.51e-11	NR	XOR59884.1	2832643	g220561	i0	43.2	0.91358024691358	74	42	91.4	0	3	224	177	250	XOR59884.1 MAG: major capsid protein [Caudoviricetes sp.]	diamond	222	67.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31984047	31984047	PRJNA906294_P_NODE_186078_length_269_cov_1.464286_g181962_i0	PRJNA906294	186078	269	1.464286	3.93892934	Caudoviricetes sp.	2832643	Viruses	Viruses	176	8.619999999999999e-55	NR	XOR23139.1	2832643	g181962	i0	87.6	0.992565055762082	89	11	99.3	0	268	2	23	111	XOR23139.1 MAG: HNH endonuclease [Caudoviricetes sp.]	diamond	267	176	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);;