metadata: contig_metadata: 15 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax

15 rows where analysis = "diamond", bioproject = "PRJNA1002570" and tax_superkingdom = "Viruses"

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
26812925	26812925	PRJNA1002570_P_NODE_43301_length_242_cov_0.911243_g43106_i0	PRJNA1002570	43301	242	0.911243	2.20520806	uncultured Caudovirales phage	2100421	Viruses	Viruses	124	1.42e-32	NR	CAB4196962.1	2100421	g43106	i0	75	0.991735537190083	80	20	99.2	0	242	3	41	120	CAB4196962.1 polynucleotide kinase [uncultured Caudovirales phage]	diamond	240	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
27319041	27319041	PRJNA1002570_P_NODE_28543_length_271_cov_1.555556_g28348_i0	PRJNA1002570	28543	271	1.555556	4.21555676	Caudoviricetes sp.	2832643	Viruses	Viruses	43.9	0.00422	NR	XOS05954.1	2832643	g28348	i0	51.2	0.907749077490775	41	18	43.2	1	3	119	58	98	XOS05954.1 MAG: hypothetical protein MSP1097_71 [Caudoviricetes sp.]	diamond	246	43.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
27476791	27476791	PRJNA1002570_P_NODE_17463_length_300_cov_1.374449_g17268_i0	PRJNA1002570	17463	300	1.374449	4.123347	Pseudomonas phage PIP	3095171	Viruses	Viruses	43.1	0.0491	NR	WPD58331.1	3095171	g17268	i0	39.2	0.51	51	25	51	1	273	121	167	211	WPD58331.1 hypothetical protein [Pseudomonas phage PIP]	diamond	153	43.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Nipunavirus	Pseudomonas phage PIP
27634809	27634809	PRJNA1002570_P_NODE_2664_length_660_cov_1.706985_g2476_i0	PRJNA1002570	2664	660	1.706985	11.266101	uncultured Caudovirales phage	2100421	Viruses	Viruses	64.7	4.66e-8	NR	CAB4134660.1	2100421	g2476	i0	50.7	0.340909090909091	75	32	34.1	3	190	414	1	70	CAB4134660.1 hypothetical protein UFOVP274_27 [uncultured Caudovirales phage]	diamond	225	64.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
28045106	28045106	PRJNA1002570_P_NODE_35585_length_251_cov_2.617978_g35390_i0	PRJNA1002570	35585	251	2.617978	6.57112478	Tupanvirus soda lake	2126985	Viruses	Viruses	73.6	5.59e-13	NR	YP_010782467.1	2126985	g35390	i0	49.3	1.74501992031873	73	25	87.3	1	2	220	427	487	YP_010782467.1 hypothetical protein QJ857_gp0240 [Tupanvirus soda lake]	diamond	438	73.6	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Tupanvirus	Tupanvirus salinum
28329245	28329245	PRJNA1002570_P_NODE_34366_length_255_cov_1.758242_g34171_i0	PRJNA1002570	34366	255	1.758242	4.4835171	Caudoviricetes sp.	2832643	Viruses	Viruses	144	4.53e-41	NR	XOR99882.1	2832643	g34171	i0	81	0.988235294117647	84	16	98.8	0	253	2	122	205	XOR99882.1 MAG: phage head morphogenesis protein [Caudoviricetes sp.]	diamond	252	144	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
28360772	28360772	PRJNA1002570_P_NODE_45646_length_228_cov_2.400000_g45451_i0	PRJNA1002570	45646	228	2.4	5.472	Caudoviricetes sp.	2832643	Viruses	Viruses	58.5	5.44e-9	NR	XOR55126.1	2832643	g45451	i0	83.9	0.407894736842105	31	5	40.8	0	2	94	73	103	XOR55126.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	93	58.5	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30280206	30280206	PRJNA1002570_P_NODE_7012_length_422_cov_3.249284_g6818_i0	PRJNA1002570	7012	422	3.249284	13.71197848	root	1	Root_unresolved	Root_unresolved	218	1.51e-66	NR	CAG7581109.1	707152	g6818	i0	66.2	3	142	46	99.5	1	3	422	261	402	CAG7581109.1 MAG: Leucine--tRNA ligase [uncultured marine phage]	diamond	1266	218	1	Viruses							uncultured marine phage
30634583	30634583	PRJNA1002570_P_NODE_6213_length_443_cov_1.872973_g6019_i0	PRJNA1002570	6213	443	1.872973	8.29727039	uncultured Caudovirales phage	2100421	Viruses	Viruses	81.6	8.37e-15	NR	CAB4151356.1	2100421	g6019	i0	55.9	2.83747178329571	93	34	60.9	4	127	396	132	220	CAB4151356.1 Pectate lyase superfamily protein [uncultured Caudovirales phage]	diamond	1257	81.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
30982409	30982409	PRJNA1002570_P_NODE_14934_length_312_cov_1.878661_g14739_i0	PRJNA1002570	14934	312	1.878661	5.86142232	Caudoviricetes sp.	2832643	Viruses	Viruses	56.2	5.59e-8	NR	XOF00566.1	2832643	g14739	i0	55.6	0.346153846153846	36	16	34.6	0	21	128	12	47	XOF00566.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	108	56.2	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31298301	31298301	PRJNA1002570_P_NODE_5115_length_481_cov_1.926471_g4921_i0	PRJNA1002570	5115	481	1.926471	9.26632551	Caulobacter phage CcrColossus	1211640	Viruses	Viruses	63.9	2.22e-9	NR	YP_006988261.1	1211640	g4921	i0	36	0.77962577962578	125	72	78	3	378	4	13	129	YP_006988261.1 hypothetical protein CcrColossus_gp027 [Caulobacter phage CcrColossus]	diamond	375	63.9	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Jeanschmidtviridae	Colossusvirus	Colossusvirus colossus
31765304	31765304	PRJNA1002570_P_NODE_42337_length_243_cov_1.358824_g42142_i0	PRJNA1002570	42337	243	1.358824	3.30194232	root	1	Root_unresolved	Root_unresolved	61.6	8.54e-9	NR	ANS04478.1	1868660	g42142	i0	68.9	1.2962962962963	45	12	55.6	1	177	43	189	231	ANS04478.1 hypothetical protein [uncultured Mediterranean phage]	diamond	315	61.6	1	Viruses							uncultured Mediterranean phage
32050077	32050077	PRJNA1002570_P_NODE_42198_length_243_cov_1.794118_g42003_i0	PRJNA1002570	42198	243	1.794118	4.35970674	Baoshanvirus	2732969	Viruses	Viruses	110	4.9000000000000005e-27	NR	YP_009799548.1	2126734	g42003	i0	67.5	1.90123456790123	77	25	95.1	0	242	12	140	216	YP_009799548.1 DNA primase/helicase [Staphylococcus phage phiSA_BS1]	diamond	462	111	0.990990990990991	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Herelleviridae	Baoshanvirus	Baoshanvirus BS1
32089108	32089108	PRJNA1002570_P_NODE_1278_length_1075_cov_3.808383_g1120_i0	PRJNA1002570	1278	1075	3.808383	40.94011725	Pseudanabaena phage Pam1	2936517	Viruses	Viruses	80.1	6.18e-14	NR	UQS94869.1	2936517	g1120	i0	62.9	0.173023255813953	62	23	17.3	0	886	1071	3	64	UQS94869.1 regulatory CII protein [Pseudanabaena phage Pam1]	diamond	186	80.1	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudanabaena phage Pam1
32215770	32215770	PRJNA1002570_P_NODE_1118_length_1218_cov_3.550218_g968_i0	PRJNA1002570	1118	1218	3.550218	43.24165524	Caudoviricetes sp.	2832643	Viruses	Viruses	82	1.5e-12	NR	XOS73902.1	2832643	g968	i0	31.3	0.551724137931034	224	141	54.7	7	1137	472	52	264	XOS73902.1 MAG: DarA [Caudoviricetes sp.]	diamond	672	82	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);;