metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA846110" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA846110" and tax_phylum = "Uroviricota"

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
4661509	4661509	PRJNA846110_P_NODE_25704_length_247_cov_0.885057_g25459_i0	PRJNA846110	25704	247	0.885057	2.18609079	Pseudomonas phage pPa_SNUABM_DT	2820398	Viruses	Viruses	124	5.88e-31	NR	QTH80393.1	2820398	g25459	i0	75.3	0.983805668016194	81	20	98.4	0	246	4	72	152	QTH80393.1 hypothetical protein PA10_00195 [Pseudomonas phage pPa_SNUABM_DT01]	diamond	243	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage pPa_SNUABM_DT01
26991226	26991226	PRJNA846110_P_NODE_24202_length_249_cov_0.875000_g23957_i0	PRJNA846110	24202	249	0.875	2.17875	Pantoea phage Survivor	3232176	Viruses	Viruses	124	5.54e-32	NR	XCN28360.1	3232176	g23957	i0	72.3	2	83	23	100	0	249	1	5	87	XCN28360.1 hypothetical protein [Pantoea phage Survivor]	diamond	498	124	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pantoea phage Survivor
27244361	27244361	PRJNA846110_P_NODE_13383_length_299_cov_2.738938_g13138_i0	PRJNA846110	13383	299	2.738938	8.18942462	Pantoea phage Nufs112	2894290	Viruses	Viruses	67	1.38e-11	NR	UJH95866.1	2894290	g13138	i0	63.3	0.491638795986622	49	18	49.2	0	151	297	70	118	UJH95866.1 recombination endonuclease VII [Pantoea phage Nufs112]	diamond	147	67	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Autographivirales		Hapakavirus	Hapakavirus Nufs112
27781419	27781419	PRJNA846110_P_NODE_15424_length_285_cov_1.858491_g15179_i0	PRJNA846110	15424	285	1.858491	5.29669935	Xanthomonas phage XbC2	2978503	Viruses	Viruses	82.4	7.58e-17	NR	UYE98594.1	2978503	g15179	i0	64.4	0.621052631578947	59	20	61.1	1	2	175	5	63	UYE98594.1 hypothetical protein XbC2_165 [Xanthomonas phage XbC2]	diamond	177	82.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Mimasvirus	Xanthomonas phage XbC2
28191532	28191532	PRJNA846110_P_NODE_26886_length_245_cov_1.343023_g26641_i0	PRJNA846110	26886	245	1.343023	3.29040635	Ralstonia phage RP31	1923890	Viruses	Viruses	104	6.049999999999999e-24	NR	BAW19303.1	1923890	g26641	i0	59	0.955102040816327	78	32	95.5	0	8	241	1983	2060	BAW19303.1 hypothetical protein [Ralstonia phage RP31]	diamond	234	104	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Chimalliviridae	Ripduovirus	Ripduovirus RP12
28444501	28444501	PRJNA846110_P_NODE_16886_length_278_cov_1.502439_g16641_i0	PRJNA846110	16886	278	1.502439	4.17678042	Aeromonas phage vB_AsaP_MQM1	3038230	Viruses	Viruses	89	3.33e-20	NR	WFZ78502.1	3038230	g16641	i0	72.9	0.636690647482014	59	16	63.7	0	3	179	86	144	WFZ78502.1 hypothetical protein MQM1_019 [Aeromonas phage vB_AsaP_MQM1]	diamond	177	89	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Aeromonas phage vB_AsaP_MQM1
29328352	29328352	PRJNA846110_P_NODE_18809_length_269_cov_1.326531_g18564_i0	PRJNA846110	18809	269	1.326531	3.56836839	Klebsiella phage KP13-16	2985658	Viruses	Viruses	57.4	3.37e-7	NR	UYL04503.1	2985658	g18564	i0	38.9	1.98513011152416	90	54	99.3	1	2	268	281	370	UYL04503.1 hypothetical protein EPNKCIFM_00201 [Klebsiella phage KP13-16]	diamond	534	57.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Klebsiella phage KP13-16
29517769	29517769	PRJNA846110_P_NODE_11710_length_318_cov_1.053061_g11465_i0	PRJNA846110	11710	318	1.053061	3.34873398	Caudoviricetes sp.	2832643	Viruses	Viruses	147	1.5599999999999999e-38	NR	XOR63729.1	2832643	g11465	i0	64.4	1.9622641509434	104	36	98.1	1	2	313	136	238	XOR63729.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	624	147	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30339623	30339623	PRJNA846110_P_NODE_8612_length_361_cov_0.986111_g8368_i0	PRJNA846110	8612	361	0.986111	3.55986071	Caudoviricetes sp.	2832643	Viruses	Viruses	93.6	5.84e-20	NR	XOR63743.1	2832643	g8368	i0	43.4	0.822714681440443	99	55	82.3	1	2	298	122	219	XOR63743.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	297	93.6	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
30402753	30402753	PRJNA846110_P_NODE_26293_length_246_cov_0.890173_g26048_i0	PRJNA846110	26293	246	0.890173	2.18982558	Caudoviricetes sp.	2832643	Viruses	Viruses	44.3	0.00243	NR	DAZ52916.1	2832643	g26048	i0	59	0.475609756097561	39	16	47.6	0	123	7	44	82	DAZ52916.1 MAG TPA: hypothetical protein [Caudoviricetes sp.]	diamond	117	44.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31097282	31097282	PRJNA846110_P_NODE_15215_length_286_cov_1.727700_g14970_i0	PRJNA846110	15215	286	1.7277	4.941222	Caudoviricetes sp.	2832643	Viruses	Viruses	57.8	8.55e-8	NR	XOS24387.1	2832643	g14970	i0	38.3	1.68881118881119	81	49	85	1	245	3	76	155	XOS24387.1 MAG: putative tail fiber protein [Caudoviricetes sp.]	diamond	483	57.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
31382066	31382066	PRJNA846110_P_NODE_16396_length_281_cov_1.105769_g16151_i0	PRJNA846110	16396	281	1.105769	3.10721089	Aeromonas phage vB_AsaP_MQM1	3038230	Viruses	Viruses	177	5.38e-50	NR	WFZ78487.1	3038230	g16151	i0	91.3	0.98220640569395	92	8	98.2	0	6	281	388	479	WFZ78487.1 portal protein [Aeromonas phage vB_AsaP_MQM1]	diamond	276	177	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Aeromonas phage vB_AsaP_MQM1
32402778	32402778	PRJNA846110_P_NODE_15619_length_284_cov_1.867299_g15374_i0	PRJNA846110	15619	284	1.867299	5.30312916	Viruses	10239	Viruses	Viruses	119	4.58e-30	NR	QTH80266.1	2820398	g15374	i0	89.3	1.21478873239437	56	6	59.2	0	274	107	291	346	QTH80266.1 radical SAM protein [Pseudomonas phage pPa_SNUABM_DT01]	diamond	345	119	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Pseudomonas phage pPa_SNUABM_DT01

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