metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1215774" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1215774" 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_family	tax_genus	tax_species
14359918	14359918	PRJNA1215774_P_NODE_31292_length_378_cov_1.593443_g30972_i0	PRJNA1215774	31292	378	1.593443	6.02321454	Caudoviricetes sp.	2832643	Viruses	Viruses	234	2.8300000000000002e-77	NR	XOR85270.1	2832643	g30972	i0	88.4	0.96031746031746	121	14	96	0	375	13	12	132	XOR85270.1 MAG: hypothetical protein MSP1786_56 [Caudoviricetes sp.]	diamond	363	234	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
26629496	26629496	PRJNA1215774_P_NODE_15761_length_548_cov_1.720000_g15443_i0	PRJNA1215774	15761	548	1.72	9.4256	Caudoviricetes sp.	2832643	Viruses	Viruses	128	9.63e-34	NR	DAL41008.1	2832643	g15443	i0	65.7	0.541970802919708	99	30	54.2	2	251	547	1	95	DAL41008.1 MAG TPA_asm: Exonuclease, partial [Caudoviricetes sp.]	diamond	297	128	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
28557138	28557138	PRJNA1215774_P_NODE_85347_length_238_cov_2.406061_g85027_i0	PRJNA1215774	85347	238	2.406061	5.72642518	uncultured Caudovirales phage	2100421	Viruses	Viruses	74.7	1.12e-15	NR	CAB4120785.1	2100421	g85027	i0	67.4	0.542016806722689	43	14	54.2	0	2	130	21	63	CAB4120785.1 hypothetical protein UFOVP5_22 [uncultured Caudovirales phage]	diamond	129	74.7	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
28702196	28702196	PRJNA1215774_P_NODE_57587_length_277_cov_1.303922_g57267_i0	PRJNA1215774	57587	277	1.303922	3.61186394	root	1	Root_unresolved	Root_unresolved	62.8	4.3e-9	NR	YP_007236986.1	1206557	g57267	i0	46.9	14.8483754512635	81	40	87.7	1	29	271	202	279	YP_007236986.1 hypothetical protein BN79_007 [Yersinia phage phiR2-01]	diamond	4113	62.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Demerecviridae	Epseptimavirus	Epseptimavirus R201
30167316	30167316	PRJNA1215774_P_NODE_49052_length_301_cov_1.350877_g48732_i0	PRJNA1215774	49052	301	1.350877	4.06613977	Caudoviricetes sp.	2832643	Viruses	Viruses	59.3	1.15e-7	NR	XOS41117.1	2832643	g48732	i0	56.4	1.64451827242525	55	24	54.8	0	300	136	426	480	XOS41117.1 MAG: hypothetical protein MSP1010_21 [Caudoviricetes sp.]	diamond	495	59.3	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes			Caudoviricetes sp.
30736116	30736116	PRJNA1215774_P_NODE_25794_length_419_cov_2.092486_g25474_i0	PRJNA1215774	25794	419	2.092486	8.76751634	uncultured Caudovirales phage	2100421	Viruses	Viruses	128	2.13e-31	NR	CAB4120769.1	2100421	g25474	i0	50.4	0.995226730310263	139	67	98.1	1	1	411	376	514	CAB4120769.1 LT_GEWL domain containing protein [uncultured Caudovirales phage]	diamond	417	128	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
32064103	32064103	PRJNA1215774_P_NODE_73998_length_248_cov_0.880000_g73678_i0	PRJNA1215774	73998	248	0.88	2.1824	uncultured Caudovirales phage	2100421	Viruses	Viruses	100	1.09e-22	NR	CAB4156114.1	2100421	g73678	i0	59.3	0.979838709677419	81	33	98	0	5	247	150	230	CAB4156114.1 hypothetical protein UFOVP664_38 [uncultured Caudovirales phage]	diamond	243	100	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes	Peduoviridae	Maltschvirus	Maltschvirus maltsch
32570713	32570713	PRJNA1215774_P_NODE_64319_length_260_cov_1.647059_g63999_i0	PRJNA1215774	64319	260	1.647059	4.2823534	Caudoviricetes sp.	2832643	Viruses	Viruses	172	1.41e-47	NR	QHJ78657.1	2832643	g63999	i0	94.2	0.992307692307692	86	5	99.2	0	1	258	674	759	QHJ78657.1 MAG: hypothetical protein [Caudoviricetes sp.]	diamond	258	172	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);;